| | |
|---|
| | | // .ToList(); |
|---|
| | | |
|---|
| | | var sql =string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,b.dab006 FQty,b.dab007 SQty,b.dab006 - b.dab007 DSQty , |
|---|
| | | dbo.F_QX_GETRECODEPOTSE(B.dab003) as RecoKw |
|---|
| | | dbo.F_QX_GETRECODEPOTSE(B.dab003,'','','') as RecoKw |
|---|
| | | FROM WOMDAB B |
|---|
| | | LEFT JOIN WOMDAA A ON A.guid = B.daaGuid |
|---|
| | | LEFT JOIN MES_ITEMS C ON B.dab003 = C.item_id |
|---|
| | |
|---|
| | | var sql2 = new StringBuilder(@" |
|---|
| | | SELECT '['+DAA001+']['+DAA021+']' AS daaInfo,DAA001,DAA021 |
|---|
| | | FROM WOMDAA |
|---|
| | | WHERE daa018 NOT IN ('W:完工', 'D:待开工')"); |
|---|
| | | WHERE daa018 <>'W:完工'"); |
|---|
| | | |
|---|
| | | if (!string.IsNullOrWhiteSpace(unity.selectKey?.ToString())) |
|---|
| | | { |
|---|
