| | |
| | | public dynamic getKbBarMxInfo(dynamic query) |
| | | { |
| | | |
| | | var sql = string.Format(@"SELECT ITEM_BARCODE, QUANTITY,item_no,item_name,item_model |
| | | var sql = string.Format(@"SELECT ITEM_BARCODE, QUANTITY,item_no,item_name,item_model,weight |
| | | FROM MES_INV_ITEM_BARCODES_TBMX A |
| | | LEFT JOIN WOMDAA B ON B.daa001 = A.DAA_001 |
| | | LEFT JOIN MES_ITEMS C ON C.item_id = B.daa002 |
| | |
| | | public dynamic SubmitKbInspection(dynamic query) |
| | | { |
| | | if (query == null) throw new ArgumentNullException(nameof(query), "参数对象不能为 null"); |
| | | |
| | | |
| | | // 参数校验 |
| | | if (string.IsNullOrEmpty(query.userAccount?.ToString())) |
| | | throw new ArgumentException("用户名不允许为空", nameof(query.userAccount)); |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | public dynamic GetWeightByXt(dynamic query) |
| | | { |
| | | if (query == null) throw new ArgumentNullException(nameof(query), "参数对象不能为null"); |
| | | |
| | | // 参数校验 |
| | | if (string.IsNullOrEmpty(query.userName?.ToString())) |
| | | throw new ArgumentException("用户名不允许为空", nameof(query.userName)); |
| | | |
| | | if (string.IsNullOrEmpty(query.LsBar?.ToString())) |
| | | throw new ArgumentException("卡板条码不允许为空", nameof(query.LsBar)); |
| | | |
| | | var _strMsg = ""; |
| | | var _status = -1; |
| | | var _weight = "0"; |
| | | |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | | { |
| | | using (var cmd = new SqlCommand("prc_pda_Xbar_chenzhong", conn)) |
| | | { |
| | | try |
| | | { |
| | | conn.Open(); |
| | | cmd.CommandType = CommandType.StoredProcedure; |
| | | |
| | | SqlParameter[] parameters = |
| | | { |
| | | new("@pi_user", SqlDbType.NVarChar, 100) { Value = query.userName }, |
| | | new("@pi_ls_barcode", SqlDbType.NVarChar, 100) { Value = query.LsBar }, |
| | | new("@po_outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output }, |
| | | new("@po_outStatus", SqlDbType.Int) { Direction = ParameterDirection.Output }, |
| | | new("@po_outWeight", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output } |
| | | }; |
| | | |
| | | cmd.Parameters.AddRange(parameters); |
| | | cmd.ExecuteNonQuery(); |
| | | |
| | | _strMsg = parameters[2].Value?.ToString() ?? ""; |
| | | _status = Convert.ToInt32(parameters[3].Value ?? -1); |
| | | _weight = parameters[4].Value?.ToString() ?? "0"; |
| | | |
| | | if (_status <= 0) throw new Exception(_strMsg); |
| | | |
| | | return new |
| | | { |
| | | message = _strMsg, |
| | | status = _status, |
| | | weight = _weight, |
| | | barCode = query.Bar |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw new Exception($"产品称重失败:{ex.Message}"); |
| | | } |
| | | finally |
| | | { |
| | | conn.Close(); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |