| | |
|---|
| | | |
|---|
| | | // 1. 主表插入 |
|---|
| | | var sql1 = @" |
|---|
| | | INSERT INTO MES_SN_STATUS_DETAILS |
|---|
| | | (ID, TICKET_NO, SN_NO, WORKSTATION_NO, SN_STATE, LOGIN_ID, TURNOVER_CODE, LINE_NO) |
|---|
| | | SELECT SEQ_MES_SN_STATUS_DETAILS_ID.NEXTVAL, |
|---|
| | | INSERT INTO MES_SN_STATUS_DETAILS |
|---|
| | | (ID, TICKET_NO, SN_NO, WORKSTATION_NO, SN_STATE, LOGIN_ID, TURNOVER_CODE, LINE_NO) values ( |
|---|
| | | SEQ_MES_SN_STATUS_DETAILS_ID.NEXTVAL, |
|---|
| | | :ticketNo, |
|---|
| | | :snNo, |
|---|
| | | :workstationNo, |
|---|
| | | :snState, |
|---|
| | | :loginId, |
|---|
| | | :turnoverCode, |
|---|
| | | :LINE_NO |
|---|
| | | FROM WOMDAA |
|---|
| | | WHERE DAA001 = :ticketNo |
|---|
| | | AND ROWNUM = 1"; |
|---|
| | | :LINE_NO)"; |
|---|
| | | var parameters1 = new[] |
|---|
| | | { |
|---|
| | | new OracleParameter("ticketNo", asnInfo.tickeNo ?? (object)DBNull.Value), |
|---|
