| | |
| | | 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)) |