| | |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.org_name as wkshp_name, |
|---|
| | | A.route_code,E.name as route_name,A.stck_code,F.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,U.username as lm_user,A.lm_date |
|---|
| | | A.route_code,E.name as route_name,A.stck_code,F.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,U.username as lm_user,A.lm_date,S.bad_qty |
|---|
| | | from TK_Wrk_Man A |
|---|
| | | left join (select wo_code,sum(bad_qty) as bad_qty from TK_Wrk_Step where bad_qty>0 group by wo_code) S on A.wo_code=S.wo_code |
|---|
| | | left join TMateriel_Info B on A.materiel_code=B.partcode |
|---|
| | | left join TOrganization C on A.wkshp_code=C.org_code |
|---|
| | | left join T_Sec_Stck D on A.stck_code=D.code |
|---|
| | | left join TFlw_Rout E on A.route_code=E.code |
|---|
| | | left join T_Sec_Stck F on A.stck_code=F.code |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | where A.is_delete<>'1' and A.status='START' and A.wotype='PO' " + search; |
|---|
| | | where A.is_delete<>'1' and A.status='START' and A.wotype='PO' and S.bad_qty>0 " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
