| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using Masuit.Tools; |
| | | using NewPdaSqlServer.DB; |
| | | using NewPdaSqlServer.Dto.service; |
| | | using NewPdaSqlServer.entity; |
| | |
| | | string _intSum = ""; |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | | { |
| | | |
| | | if (query.userName.IsNullOrEmpty()) |
| | | { |
| | | throw new Exception("用户名不允许为空"); |
| | | } |
| | | if (query.daa001.IsNullOrEmpty()) |
| | | { |
| | | throw new Exception("领料单号不允许为空"); |
| | | } |
| | | if (query.barcode.IsNullOrEmpty()) |
| | | { |
| | | throw new Exception("条码不允许为空"); |
| | | } |
| | | |
| | | using (var cmd =new SqlCommand("[prc_pda_SCLL]", conn)) |
| | | { |
| | | try |
| | |
| | | //prC_pda_SCLL_CF |
| | | public ProductionPickDto ScanCodeCF(WarehouseQuery query) |
| | | { |
| | | |
| | | if (query.userName.IsNullOrEmpty()) |
| | | { |
| | | throw new Exception("用户名不允许为空"); |
| | | } |
| | | if (query.daa001.IsNullOrEmpty()) |
| | | { |
| | | throw new Exception("领料单号不允许为空"); |
| | | } |
| | | if (query.barcode.IsNullOrEmpty()) |
| | | { |
| | | throw new Exception("条码不允许为空"); |
| | | } |
| | | |
| | | if (query.Num is null or 0) |
| | | { |
| | | throw new Exception("条码拆分数不允许为空或者为0"); |
| | | } |
| | | |
| | | string _strMsg = ""; |
| | | string _intSum = ""; |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | |
| | | new("@c_User", query.userName), |
| | | new("@p_biLL_no", query.daa001), |
| | | new("@p_item_barcode", query.barcode), |
| | | new("@num", query.num), |
| | | new("@num", query.Num), |
| | | }; |
| | | parameters[0].Direction = ParameterDirection.Output; |
| | | parameters[1].Direction = ParameterDirection.Output; |