| | |
|---|
| | | sql = @"select stepcode,stepname from TStep where is_delete<>'1' and enable='Y'"; |
|---|
| | | var data = DapperHelper.selecttable(sql); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.count = data.Rows.Count; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | | mes.data = data; |
|---|
| | | } |
|---|
| | |
|---|
| | | left join( |
|---|
| | | select distinct A.eqp_code,B.wksp_code from TFlw_Rteqp A |
|---|
| | | inner join TEqpInfo B on A.eqp_code=B.code |
|---|
| | | where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1' |
|---|
| | | where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1' and B.enable='Y' |
|---|
| | | ) B on T.org_code=B.wksp_code where T.description='W' and is_delete<>'1' |
|---|
| | | UNION ALL |
|---|
| | | select distinct T.type as wksp_code,(case when T.type='211' then '供应商' when T.type='228' then '客户/供应商' end ) as wksp_name,'W' as type,(case when B.type is null then 'N' else 'Y' end) flag |
|---|
| | |
|---|
| | | left join( |
|---|
| | | select distinct A.eqp_code from TFlw_Rteqp A |
|---|
| | | inner join TEqpInfo B on A.eqp_code=B.code |
|---|
| | | where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1' |
|---|
| | | where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1' and B.enable='Y' |
|---|
| | | ) B on A.code=B.eqp_code where A.wksp_code=@wkspcode and A.is_delete<>'1'"; |
|---|
| | | dynamicParams.Add("@stepcode", stepcode); |
|---|
| | | dynamicParams.Add("@wkspcode", data.Rows[i]["WKSP_CODE"].ToString()); |
|---|
