| | |
|---|
| | | |
|---|
| | | |
|---|
| | | //取直接关联线体的产测登录号数据，去取获取工单 |
|---|
| | | var sql1 = "select DAA001 tickeNo,s.ITEM_NO itemNo,s.ITEM_NAME itemName,s.ITEM_MODEL itemModel,DAA008 plannedNum from " + |
|---|
| | | "MESLINE_LIKE_CCLOGIN_WORKS A1" + |
|---|
| | | " join MES_LINE b on A1.LOGINID=b.ID" + |
|---|
| | | " left join WOMDAA C on C.DAA015=B.LINE_NO" + |
|---|
| | | " 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 from " + |
|---|
| | | // "MESLINE_LIKE_CCLOGIN_WORKS A1" + |
|---|
| | | // " join MES_LINE b on A1.LOGINID=b.ID" + |
|---|
| | | // " left join WOMDAA C on C.DAA015=B.LINE_NO" + |
|---|
| | | // " 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 = '" + id + "'\r\n and DAA018 = '已开工' and A.CAA023='2'\r\norder by DAA016 asc"; |
|---|
| | | return SQLHelper.ExecuteQuery(sql1); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | // 1. 主表插入 |
|---|
| | | var sql1 = $@" |
|---|
| | | INSERT INTO MES_SN_STATUS_DETAILS |
|---|
| | | (ID, TICKET_NO, SN_NO, WORKSTATION_NO, SN_STATE, LOGIN_ID) |
|---|
| | | (ID, TICKET_NO, SN_NO, WORKSTATION_NO, SN_STATE, LOGIN_ID,TURNOVER_CODE) |
|---|
| | | VALUES (SEQ_MES_SN_STATUS_DETAILS_ID.NEXTVAL, |
|---|
| | | '{asnInfo.tickeNo}', |
|---|
| | | '{asnInfo.snNo}', |
|---|
| | | '{asnInfo.workstationNo}', |
|---|
| | | '{asnInfo.snState}', |
|---|
| | | '{asnInfo.loginId}')"; |
|---|
| | | '{asnInfo.loginId}','{asnInfo.turnoverCode}')"; |
|---|
| | | int i = sqlHelper.ExecuteNonQueryWithTransaction(connection, transaction, sql1); |
|---|
| | | |
|---|
| | | // 2. 失败项插入 |
|---|
