| | |
| | | #region 判断 |
| | | if (string.IsNullOrEmpty(palletNo)) |
| | | { |
| | | throw new Exception("托盘号不能为空"); |
| | | throw new Exception("托盘号不能为空!"); |
| | | } |
| | | if (string.IsNullOrEmpty(houseNo)) |
| | | { |
| | |
| | | for (int i = 1; i <= 2; i++) |
| | | { |
| | | var iStr = i.ToString(); |
| | | locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "", iStr); |
| | | try |
| | | { |
| | | locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "", iStr); |
| | | } |
| | | catch (Exception e) |
| | | { } |
| | | if (locate != null) |
| | | { |
| | | break; |
| | |
| | | var roadStr = Db.Queryable<SysStorageRoadway>().Where(m => m.IsDel == "0" && m.Status == "0").Select(m=>m.RoadwayNo).ToList(); |
| | | //巷道组信息 |
| | | var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo) && !string.IsNullOrWhiteSpace(m.RoadwayNo) && roadStr.Contains(m.RoadwayNo)) |
| | | .GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList(); |
| | | .GroupBy(m => m.RoadwayNo) |
| | | .Select(m => m.RoadwayNo) |
| | | .ToList() |
| | | .OrderBy(roadwayNo => |
| | | { |
| | | // 移除所有非数字字符,只保留数字 |
| | | var numbersOnly = new string(roadwayNo.Where(char.IsDigit).ToArray()); |
| | | return int.TryParse(numbersOnly, out int result) ? result : 0; |
| | | }).ToList(); |
| | | |
| | | #endregion |
| | | |
| | |
| | | //Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | |
| | | // 调用Limes接口发起请验 |
| | | var sendModel = new SendLimesModel() |
| | | // 调用Sqp接口发起请验 |
| | | var sendModel = new SendSapQcDetailVm() |
| | | { |
| | | QcNo = data.QcNo, |
| | | SkuNo = data.SkuNo, |
| | | Qty = data.Qty.ToString(), |
| | | LotNo = data.LotNo, |
| | | SupplierLot = data.SupplierLot, |
| | | RequestUser = userName, // 请验人 |
| | | skuNo=data.SkuNo, |
| | | skuName = data.SkuNo, |
| | | lotNo = data.LotNo, |
| | | Qty = Convert.ToDecimal(data.Qty), |
| | | SupplierLot = data.SupplierLot |
| | | }; |
| | | var jsonData = JsonConvert.SerializeObject(sendModel); |
| | | string response = ""; |
| | |
| | | try |
| | | { |
| | | var time1 = DateTime.Now;//发送时间 .ToString("yyyy-MM-dd HH:mm:ss") |
| | | //response = HttpHelper.DoPost(url, jsonData, "上传Limes系统发起请验", "Limes"); |
| | | //response = HttpHelper.DoPost(url, jsonData, "上传Sap系统发起请验", "Sap"); |
| | | var time2 = DateTime.Now;//返回时间 .ToString("yyyy-MM-dd HH:mm:ss") |
| | | |
| | | ////解析返回数据 |