| | |
| | | using NewPdaSqlServer.DB; |
| | | using NewPdaSqlServer.Dto.service; |
| | | using NewPdaSqlServer.entity; |
| | | using SqlSugar; |
| | | using static Microsoft.EntityFrameworkCore.DbLoggerCategory; |
| | | using NewPdaSqlServer.util; |
| | | |
| | | namespace NewPdaSqlServer.service.Warehouse; |
| | | |
| | |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | | { |
| | | if (unity.userName.IsNullOrEmpty()) throw new Exception("用户名不允许为空"); |
| | | if (unity.sectionCode.IsNullOrEmpty()) throw new Exception("库位编号不允许为空"); |
| | | if (unity.sectionCode.IsNullOrEmpty()) |
| | | throw new Exception("库位编号不允许为空"); |
| | | if (unity.barcode.IsNullOrEmpty()) throw new Exception("条码不允许为空"); |
| | | |
| | | using (var cmd = new SqlCommand("[prc_pda_inv_cprk]", conn)) |
| | |
| | | new("@po_womInBarSum", SqlDbType.NVarChar, 300), |
| | | new("@pi_user", unity.userName), |
| | | new("@pi_barcode", unity.barcode), |
| | | new("@pi_sectionCode", unity.sectionCode), |
| | | |
| | | new("@pi_sectionCode", unity.sectionCode) |
| | | }; |
| | | parameters[0].Direction = ParameterDirection.Output; |
| | | parameters[1].Direction = ParameterDirection.Output; |
| | |
| | | return _strMsg; |
| | | |
| | | //return 0; |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | } |