| | |
|---|
| | | // " left join mes_items s on s.id = C.daa002" + |
|---|
| | | // " where WORKSNO='" + id + "' and DAA018='已开工' order by DAA016 asc"; |
|---|
| | | //var sql1 = "select DAA001 tickeNo, s.ITEM_NO itemNo, s.ITEM_NAME itemName, s.ITEM_MODEL itemModel, DAA008 plannedNum\r\nfrom WOMDAA C\r\n left join mes_items s on s.id = C.daa002\r\nleft join womcaa A on A.caa001=C.daa021\r\nwhere C.DAA015 = '" + LineId + "'\r\n and DAA018 = '已开工' and A.CAA023='2'\r\norder by DAA016 asc"; |
|---|
| | | var sql1 = "select DAA001 tickeNo, s.ITEM_NO itemNo, s.ITEM_NAME itemName, s.ITEM_MODEL itemModel, DAA008 plannedNum\r\nfrom WOMDAA C\r\n " + |
|---|
| | | var sql1 = "select DAA001 tickeNo, s.ITEM_NO itemNo, s.ITEM_NAME itemName, s.ITEM_MODEL itemModel, DAA008 plannedNum ,PRD.PRD_ID PRDID\r\nfrom WOMDAA C\r\n " + |
|---|
| | | "left join mes_items s on s.id = C.daa002\r\n" + |
|---|
| | | "left join MES_PRD_ID PRD on PRD.ITEM_NO=s.ITEM_NO /*查询产品id*/\r\n" + |
|---|
| | | "left join womcaa A on A.caa001=C.daa021\r\n" + |
|---|
| | | "left join MESPROJECT_LIKE_CCLOGIN pr1 on A.PROJECT=pr1.PROJECT_ID\r\n" + |
|---|
| | | "left join MESLINE_LIKE_CCLOGIN_WORKS2 pr2 on pr1.id=pr2.LOGINID\r\n" + |
|---|
