| | |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | |
|---|
| | | //获取设备类型数据 |
|---|
| | | sql = @"select A.seq,A.wo_code,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date, |
|---|
| | | sql = @"select A.seq,A.wo_code,M.m_po,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date, |
|---|
| | | B.stepcode,B.stepname,A.plan_qty,(case when A.good_qty=0 then '' end) as good_qty,(case when A.ng_qty=0 then '' end) as ng_qty,A.wo_code+';'+B.stepcode as stepqrcode |
|---|
| | | from TK_Wrk_Step A |
|---|
| | | left join TK_Wrk_Man M on A.wo_code=M.wo_code |
|---|
