| | |
|---|
| | | where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1' |
|---|
| | | ) B on T.org_code=B.wksp_code where T.description='W' and is_delete<>'1' |
|---|
| | | UNION ALL |
|---|
| | | select distinct T.btype as wksp_code,(case T.btype when 'WX' then '外协供方' end ) as wksp_name,'W' as type,(case when B.btype is null then 'N' else 'Y' end) flag |
|---|
| | | 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 |
|---|
| | | from TCustomer T |
|---|
| | | left join( |
|---|
| | | select distinct A.eqp_code,B.btype from TFlw_Rteqp A |
|---|
| | | select distinct A.eqp_code,B.type from TFlw_Rteqp A |
|---|
| | | inner join TCustomer B on A.eqp_code=B.code |
|---|
| | | where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1' |
|---|
| | | ) B on T.btype=B.btype where T.btype='WX' and T.is_delete<>'1'"; |
|---|
| | | ) B on T.type=B.type where T.type in('211','228') and T.is_delete<>'1'"; //226(客户) |
|---|
| | | dynamicParams.Add("@stepcode", stepcode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | for (int i = 0; i < data.Rows.Count; i++) |
|---|
| | |
|---|
| | | rout.type = data.Rows[i]["TYPE"].ToString(); |
|---|
| | | rout.flag = data.Rows[i]["FLAG"].ToString(); |
|---|
| | | rout.children = new List<StepEqpCn>(); |
|---|
| | | if (rout.code == "WX") //外协供方 |
|---|
| | | if (rout.code == "211"|| rout.code == "228") //外协供方 |
|---|
| | | { |
|---|
| | | //根据外协供方标识编码查找外协供方信息(包含已关联标识) |
|---|
| | | sql = @"select A.code,A.name,'W' as type,(case when B.eqp_code is null then 'N' else 'Y' end) flag |
|---|
| | |
|---|
| | | left join( |
|---|
| | | select distinct A.eqp_code from TFlw_Rteqp A |
|---|
| | | inner join TCustomer B on A.eqp_code=B.code |
|---|
| | | where B.btype=@wxcode and A.is_delete<>'1' and B.is_delete<>'1' |
|---|
| | | ) B on A.code=B.eqp_code where A.btype=@wxcode and A.is_delete<>'1'"; |
|---|
| | | where A.step_code=@stepcode and B.type=@wxcode and A.is_delete<>'1' and B.is_delete<>'1' |
|---|
| | | ) B on A.code=B.eqp_code where A.type=@wxcode and A.is_delete<>'1'"; |
|---|
| | | dynamicParams.Add("@stepcode", stepcode); |
|---|
| | | dynamicParams.Add("@wxcode", rout.code); |
|---|
| | | var data0 = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | for (int k = 0; k < data0.Rows.Count; k++) |
|---|
