| | |
|---|
| | | public List<string> GetProductionPickDaa001(WarehouseQuery query) |
|---|
| | | { |
|---|
| | | var sql = |
|---|
| | | "SELECT DAA001 FROM WOMDAA A LEFT JOIN (SELECT COUNT(1) UN_NUM, PID FROM WOMDAB WHERE DAB006 > DAB007 GROUP BY PID) B ON A.ID = B.PID WHERE DAA001 LIKE '%" + |
|---|
| | | "SELECT DAA001 FROM WOMDAA A LEFT JOIN (SELECT COUNT(1) UN_NUM, PID FROM WOMDAB WHERE DAB006 > DAB007 GROUP BY DAB002) B ON A.GUID = B.daaGuid WHERE DAA001 = " + |
|---|
| | | query.daa001 + |
|---|
| | | "%' and DAA018 != '完工' AND DAA022 = 1 AND UN_NUM > 0 AND ROWNUM <= 10 order by a.id desc"; |
|---|
| | | " and DAA018 != '完工' AND DAA022 = 1 AND UN_NUM > 0 AND ROWNUM <= 10 order by a.id desc"; |
|---|
| | | |
|---|
| | | return Db.Ado.SqlQuery<string>(sql); |
|---|
| | | } |
|---|
| | |
|---|
| | | a.Daa001 == query.daa001 && d.IssueType == "1") |
|---|
| | | .Select((a, b, c, d) => new Womdab |
|---|
| | | { |
|---|
| | | Pid = b.Pid, |
|---|
| | | //Pid = b.Pid, |
|---|
| | | Dab003 = b.Dab003, |
|---|
| | | Dab006 = b.Dab006, |
|---|
| | | Dab007 = b.Dab007, |
|---|
