| | |
| | | /// <summary> |
| | | /// 工单单号 |
| | | /// </summary> |
| | | public string tickeNo { get; set; } |
| | | public string? tickeNo { get; set; } |
| | | /// <summary> |
| | | /// 线体 |
| | | /// </summary> |
| | | public string? lineNo { get; set; } |
| | | /// <summary> |
| | | /// SN号 |
| | | /// </summary> |
| | |
| | | :snState, |
| | | :loginId, |
| | | :turnoverCode, |
| | | NVL(DAA015, '') |
| | | :LINE_NO |
| | | FROM WOMDAA |
| | | WHERE DAA001 = :ticketNo |
| | | AND ROWNUM = 1"; |
| | |
| | | new OracleParameter("workstationNo", asnInfo.workstationNo ?? (object)DBNull.Value), |
| | | new OracleParameter("snState", asnInfo.snState ?? (object)DBNull.Value), |
| | | new OracleParameter("loginId", asnInfo.loginId ?? (object)DBNull.Value), |
| | | new OracleParameter("turnoverCode", asnInfo.turnoverCode ?? (object)DBNull.Value) |
| | | new OracleParameter("turnoverCode", asnInfo.turnoverCode ?? (object)DBNull.Value), |
| | | new OracleParameter("LINE_NO", asnInfo.lineNo ?? (object)DBNull.Value) |
| | | }; |
| | | |
| | | int i = sqlHelper.ExecuteNonQueryWithTransaction(sql1, parameters1, connection, transaction); |