| | |
|---|
| | | addProcess = () => { |
|---|
| | | let _sql = this.props.form.getFieldValue('dataresource') |
|---|
| | | |
|---|
| | | _sql = _sql + `\n/* select a.*,case when isnull(w.remark,'')='' then a.remark else w.remark end as remark_w,case when isnull(w.statusname,'')='' then a.statusname else w.statusname end as statusname_w,w.status as status_w from 数据源 a left join (select * from s_my_works_flow where works_flow_code='流程编码' and deleted=0) w on a.id=w.works_flow_id where isnull(w.status,0)=0 */` |
|---|
| | | _sql = _sql + `\n/* select a.*, w.remark as remark_w, w.statusname as statusname_w,w.status as status_w from 数据源 a inner join (select * from s_my_works_flow where works_flow_code=@works_flow_code@ and status=0 and deleted=0) w on a.id=w.works_flow_id */` |
|---|
| | | |
|---|
| | | this.props.form.setFieldsValue({ |
|---|
| | | dataresource: _sql |
|---|
