| | |
| | | select C.name as linename,'' as wkshname,M.partname,A.sqty as good_qty from TK_Wrk_OutRecord A |
| | | inner join TK_Wrk_Step S on A.wo_code=S.wo_code and A.step_code=S.step_code |
| | | inner join TMateriel_Info M on A.materiel_code=M.partcode |
| | | inner join TCustomer C on A.wx_code=C.code and C.btype='WX' |
| | | inner join TCustomer C on A.wx_code=C.code |
| | | where A.style='S' and S.isend='Y' and datediff(day,GETDATE(),A.lm_date)=0 |
| | | ) as A group by A.org_name,A.name,A.partname order by good_qty desc"; |
| | | var data = DapperHelper.selectlist(sql, new { shopcode = selects.ToArray() }); |