| | |
|---|
| | | string[] selects = Array.ConvertAll<string, string>(shopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] |
|---|
| | | //查询产线下已开工的加工单信息 |
|---|
| | | sql = @"select * from ( |
|---|
| | | select distinct E.saleOrderCode,A.wo_code,P.plan_qty,M.partcode,M.partname,M.partspec,T.name as uomname from TK_Wrk_Record A |
|---|
| | | select distinct E.saleOrderCode,A.wo_code,P.plan_qty,M.partcode,M.partname,M.partspec,T.name as uomname,S.good_qty,S.ng_qty,S.bad_qty from TK_Wrk_Record A |
|---|
| | | inner join TK_Wrk_Man P on A.wo_code=P.wo_code |
|---|
| | | left join TMateriel_Info M on P.materiel_code=M.partcode |
|---|
| | | left join TUom T on M.uom_code=T.code |
|---|
