From ae03ec7001b6ba415fa5ccac7c6ff06c81578eb1 Mon Sep 17 00:00:00 2001 From: test <15284381150@163.com> Date: 星期五, 19 九月 2025 08:02:38 +0800 Subject: [PATCH] Merge branch 'djp' --- Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs | 447 +++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 426 insertions(+), 21 deletions(-) diff --git a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs index 600b343..5ce43ae 100644 --- a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs +++ b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs @@ -1,6 +1,8 @@ 锘縰sing System; using System.Collections.Generic; +using System.ComponentModel; using System.Linq; +using System.Reflection.Metadata; using System.Security.Cryptography.X509Certificates; using System.Text; using System.Threading.Tasks; @@ -9,6 +11,7 @@ using Model.ModelDto; using Model.ModelDto.BllCheckDto; using Model.ModelDto.PdaDto; +using Model.ModelDto.SysDto; using Newtonsoft.Json; using SqlSugar; using Utility; @@ -417,15 +420,70 @@ /// <param name="locatNo">鍌ㄤ綅缂栧彿</param> /// <param name="palletNo">鎵樼洏鍙�</param> /// <returns></returns> - public async Task<List<DataStockDetail>> GetStockQueryList(string locatNo, string palletNo) + //public async Task<List<DataStockDetail>> GetStockQueryList(string locatNo, string palletNo) + //{ + // return await Db.Queryable<DataStockDetail>() + // .Where(s => s.IsDel == "0" && s.LocatNo.Contains(locatNo) || s.PalletNo.Contains(palletNo)) + // .OrderBy(s => new { s.LotNo, s.LocatNo, s.PalletNo }) + // .ToListAsync(); + //} + public async Task<List<StockDetailWithQtyDto>> GetStockQueryList(string locatNo, string palletNo, string boxNo) { - return await Db.Queryable<DataStockDetail>() - .Where(s => s.IsDel == "0" && s.LocatNo.Contains(locatNo) && s.PalletNo.Contains(palletNo)) - .OrderBy(s => new { s.LotNo, s.LocatNo, s.PalletNo }) - .ToListAsync(); - + return await Db.Queryable<DataStockDetail>("a") + .InnerJoin<DataBoxInfo>((a, b) => a.LotNo == b.LotNo) + .Where((a, b) => a.IsDel == "0") + .WhereIF(!string.IsNullOrWhiteSpace(locatNo), (a, b) => a.LocatNo.Contains(locatNo)) + .WhereIF(!string.IsNullOrWhiteSpace(palletNo), (a, b) => a.PalletNo.Contains(palletNo)) + .WhereIF(!string.IsNullOrWhiteSpace(boxNo), (a, b) => b.BoxNo.Contains(boxNo)) + .OrderBy((a, b) => new { a.LotNo, a.LocatNo, a.PalletNo }) + .Select((a, b) => new StockDetailWithQtyDto + { + LotNo = a.LotNo, + LotText = a.LotText, + SupplierLot = a.SupplierLot, + OwnerNo = a.OwnerNo, + OwnerName = a.OwnerName, + SupplierNo = a.SupplierNo, + SupplierName = a.SupplierName, + SkuNo = a.SkuNo, + SkuName = a.SkuName, + Standard = a.Standard, + Qty = b.Qty, // DataBoxInfo鐨凲ty瀛楁 + LockQty = a.LockQty, + FrozenQty = a.FrozenQty, + InspectQty = a.InspectQty, + ASNNo = a.ASNNo, + ASNDetailNo = a.ASNDetailNo, + SONo = a.SONo, + WareHouseNo = a.WareHouseNo, + RoadwayNo = a.RoadwayNo, + AreaNo = a.AreaNo, + LocatNo = a.LocatNo, + PalletNo = a.PalletNo, + PalletNo2 = a.PalletNo2, + PalletNo3 = a.PalletNo3, + PalletTags = a.PalletTags, + CompleteTime = a.CompleteTime, + ProductionTime = a.ProductionTime, + ExpirationTime = a.ExpirationTime, + Status = a.Status, + InspectMark = a.InspectMark, + BitPalletMark = a.BitPalletMark, + InspectStatus = a.InspectStatus, + InspectTime = a.InspectTime, + PackagNo = a.PackagNo, + IsBale = a.IsBale, + IsBelt = a.IsBelt, + UDF5 = a.UDF5, + IsDel = a.IsDel, + CreateTime = a.CreateTime, + CreateUser = a.CreateUser, + UpdateTime = a.UpdateTime, + UpdateUser = a.UpdateUser, + Demo = a.Demo + }) + .ToListAsync(); } - #endregion #region 鎵樼洏鍙樻洿锛堟墭鐩樿В缁戠粦瀹氾級 @@ -691,9 +749,9 @@ { throw Oops.Bah("鎵樼洏鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); } - if (models.WareHouseNo != "W04") + if (models.WareHouseNo != "W04" && models.WareHouseNo != "W02") { - throw Oops.Bah("璇ユ墭鐩樻湭鍦ㄥ钩搴撳唴,璇锋鏌�!"); + throw Oops.Bah("璇ユ墭鐩樻湭鍦ㄥ钩搴撳唴鎴栬揣鏋跺簱鍐�,璇锋鏌�!"); } return models.LocatNo; } @@ -721,7 +779,7 @@ { throw Oops.Bah("鎵樼洏鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); } - if (models.WareHouseNo != "W04") + if (models.WareHouseNo != "W04" && models.WareHouseNo != "W02") { throw Oops.Bah("璇ユ墭鐩樻湭鍦ㄥ钩搴撳唴,璇锋鏌�!"); } @@ -731,8 +789,14 @@ throw Oops.Bah("鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); } - - storageArea = await Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.AreaNo != storageLocat.AreaNo && w.WareHouseNo == "W04").OrderBy(o => o.AreaNo).ToListAsync(); + if (models.WareHouseNo == "W02") + { + storageArea = await Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.AreaNo != storageLocat.AreaNo && w.WareHouseNo == "W04" && (w.AreaNo == "B01" || w.AreaNo == "B02")).OrderBy(o => o.AreaNo).ToListAsync(); + } + else + { + storageArea = await Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.AreaNo != storageLocat.AreaNo && w.WareHouseNo == "W04").OrderBy(o => o.AreaNo).ToListAsync(); + } } return storageArea; @@ -779,7 +843,7 @@ /// <param name="palletNo"></param> /// <param name="areaNo"></param> /// <param name="ruku"></param> - public async Task AgvTransport(string palletNo, string areaNo, string ruku, string url, int userId) + /*public async Task AgvTransport(string palletNo, string areaNo, string ruku, string url, int userId) { try { @@ -829,7 +893,7 @@ { throw Oops.Bah("鎵樼洏鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); } - if (stockDetail.WareHouseNo != "W04") + if (stockDetail.WareHouseNo != "W04" && stockDetail.WareHouseNo != "W02") { throw Oops.Bah("璇ユ墭鐩樻湭鍦ㄥ钩搴撳唴,璇锋鏌�!"); } @@ -927,6 +991,339 @@ if (wcsModel.code == 200) { // 鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// + new TaskServer().EditTaskIssueOk(list2, time1, time2); + } + else + { + new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.message); + throw new Exception(wcsModel.message); + } + } + catch (Exception ex) + { + throw new Exception(ex.Message); + } + + } + catch (Exception e) + { + throw new Exception(e.Message); + } + }*/ + + public async Task AgvTransport(string palletNo, string areaNo, string ruku, string url, int userId) + { + try + { + if (string.IsNullOrEmpty(palletNo)) + { + throw Oops.Bah("璇锋壂鎻忔墭鐩樻潯鐮侊紒"); + } + if (string.IsNullOrEmpty(areaNo) && string.IsNullOrEmpty(ruku)) + { + throw Oops.Bah("璇烽�夋嫨鐩爣鍖哄煙鎴栧叆搴撳彛锛�"); + } + if (!string.IsNullOrEmpty(areaNo) && !string.IsNullOrEmpty(ruku)) + { + throw Oops.Bah("鐩爣鍖哄煙鍜屽叆搴撳彛涓嶈兘鍚屾椂閫夋嫨锛�"); + } + string EndLocat = string.Empty;//鐩爣浣嶇疆 + + var log = await Db.Queryable<LogTask>().FirstAsync(w => w.IsDel == "0" && w.PalletNo == palletNo && (w.Status == "0" || w.Status == "1")); + if (log != null) + { + throw Oops.Bah("璇ユ墭鐩樺凡鏈夌瓑寰呮墽琛屾垨姝e湪鎵ц鐨勪换鍔�!"); + } + var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(w => w.IsDel == "0" && w.PalletNo == palletNo); + if (stockDetail == null) + { + throw Oops.Bah("鎵樼洏涓婄墿鏂欏簱瀛樻槑缁嗕俊鎭笉瀛樺湪,璇锋鏌�!"); + } + if (!string.IsNullOrEmpty(areaNo)) + { + var storageArea = await Db.Queryable<SysStorageArea>().FirstAsync(w => w.IsDel == "0" && w.AreaNo == areaNo); + if (storageArea == null) + { + throw Oops.Bah("鎵�閫夊尯鍩熶俊鎭笉瀛樺湪,璇锋鏌�!"); + } + EndLocat = await GetLocat(areaNo); + } + else + { + EndLocat = ruku; + } + var stock = await Db.Queryable<DataStock>().FirstAsync(w => w.IsDel == "0" && w.SkuNo == stockDetail.SkuNo && w.LotNo == stockDetail.LotNo); + if (stock == null) + { + throw Oops.Bah("鎵樼洏涓婄墿鏂欏簱瀛樹俊鎭笉瀛樺湪,璇锋鏌�!"); + } + if (string.IsNullOrEmpty(stockDetail.LocatNo)) + { + throw Oops.Bah("鎵樼洏鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + if (stockDetail.WareHouseNo != "W04") + { + throw Oops.Bah("璇ユ墭鐩樻湭鍦ㄥ钩搴撳唴,璇锋鏌�!"); + } + + //璧峰鍌ㄤ綅淇℃伅 + var storageLocat = await Db.Queryable<SysStorageLocat>().FirstAsync(w => w.IsDel == "0" && w.LocatNo == stockDetail.LocatNo); + if (storageLocat == null) + { + throw Oops.Bah("鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + //鐩爣鍌ㄤ綅淇℃伅 + //var storageLocatEnd = new SysStorageLocat(); + + var storageLocatEnd = await Db.Queryable<SysStorageLocat>().FirstAsync(w => w.IsDel == "0" && w.LocatNo == EndLocat && w.Flag == "0"); + if (storageLocatEnd == null) + { + throw Oops.Bah("鐩爣鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + + + //娣诲姞鍑哄簱浠诲姟 + var taskNo = new Common().GetMaxNo("TK"); + var moveTask = new LogTask + { + TaskNo = taskNo, + Sender = "WMS", + Receiver = "WCS", + IsSuccess = 0, //鏄惁涓嬪彂鎴愬姛 0澶辫触 1鎴愬姛 + + StartLocat = stockDetail.LocatNo,//璧峰浣嶇疆 + EndLocat = EndLocat,//鐩爣浣嶇疆 + PalletNo = palletNo,//鎵樼洏鐮� + Msg = string.Format("杞繍浠诲姟锛歿0}=>>{1}", stockDetail.LocatNo, EndLocat), + IsSend = 1,//鏄惁鍙啀娆′笅鍙� + IsCancel = 1,//鏄惁鍙彇娑� + IsFinish = 1,//鏄惁鍙畬鎴� + Type = "2",//浠诲姟绫诲瀷 0 鍏ュ簱浠诲姟 1 鍑哄簱浠诲姟 2 绉诲簱浠诲姟 + Status = "0",//浠诲姟鐘舵��0锛氱瓑寰呮墽琛�1姝e湪鎵ц2鎵ц瀹屾垚 + OrderType = "3",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� + + CreateTime = DateTime.Now + }; + await Db.Insertable(moveTask).ExecuteCommandAsync(); + + //淇敼搴撳瓨鏄庣粏淇℃伅 + //stockDetail.Status = "4";//绉诲簱閿佸畾 + //stockDetail.LockQty = stockDetail.Qty;//閿佸畾搴撳瓨鏁伴噺 + //await Db.Updateable(stockDetail).ExecuteCommandAsync(); + ////淇敼搴撳瓨淇℃伅 + //stock.LockQty += (decimal)stockDetail.Qty; + //await Db.Updateable(stock).ExecuteCommandAsync(); + + //淇敼璧峰鍌ㄤ綅鍦板潃鐘舵�� + storageLocat.Status = "5";//0锛氱┖鍌ㄤ綅 1锛氭湁鐗╁搧 2锛氬叆搴撲腑 3锛氬嚭搴撲腑 4锛氱Щ鍏ヤ腑 5锛氱Щ鍑轰腑 + await Db.Updateable(storageLocat).ExecuteCommandAsync(); + + //淇敼鐩爣鍌ㄤ綅鍦板潃鐘舵�� + if (storageLocatEnd != null) + { + storageLocatEnd.Status = "4";//0锛氱┖鍌ㄤ綅 1锛氭湁鐗╁搧 2锛氬叆搴撲腑 3锛氬嚭搴撲腑 4锛氱Щ鍏ヤ腑 5锛氱Щ鍑轰腑 + await Db.Updateable(storageLocatEnd).ExecuteCommandAsync(); + } + //娣诲姞鎿嶄綔鏃ュ織璁板綍 + var k = new OperationCrServer().AddLogOperationCr("PDA妯″潡", "AGV杞繍", palletNo, "绉诲簱", $"PDA鍛煎彨灏忚溅瀵规墭鐩樺彿锛歿palletNo}鍙戣捣杞繍", userId); + + var outDto = new List<OutCommandDto> + { + new OutCommandDto() + { + TaskNo = moveTask.TaskNo, // 浠诲姟鍙� + TaskType = "2",// 浠诲姟绫诲瀷 0鍏� 1鍑� 2绉� + PalletNo = moveTask.PalletNo,//鎵樼洏鍙� + + StartLocate = moveTask.StartLocat, // 璧峰浣嶇疆 + EndLocate = EndLocat, // 鐩爣浣嶇疆 + + Order = 999, + Type = PLCTypeEnum.AGV + + } + }; + + // 姝e紡杩愯绋嬪簭鏀惧紑 + var list2 = outDto.Select(m => m.TaskNo).ToList(); + var jsonData = JsonConvert.SerializeObject(outDto); + string response = ""; + + try + { + var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") + response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橶CS鍑哄簱鍛戒护", "WCS"); + var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") + + //瑙f瀽杩斿洖鏁版嵁 + var wcsModel = JsonConvert.DeserializeObject<WcsModel2>(response); + if (wcsModel.code == 200) + { + // 鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// + new TaskServer().EditTaskIssueOk(list2, time1, time2); + } + else + { + new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.message); + throw new Exception(wcsModel.message); + } + } + catch (Exception ex) + { + throw new Exception(ex.Message); + } + + } + catch (Exception e) + { + throw new Exception(e.Message); + } + } + /// <summary> + /// 鍛煎彨agv杞繍绌烘墭鐩� + /// </summary> + /// <param name="palletNo"></param> + /// <param name="areaNo"></param> + /// <param name="locatNo"></param> + /// <param name="url"></param> + /// <param name="userId"></param> + /// <returns></returns> + /// <exception cref="Exception"></exception> + public async Task AgvNullPallet(string palletNo, string areaNo, string locatNo, string url, int userId) + { + try + { + if (string.IsNullOrEmpty(palletNo)) + { + throw Oops.Bah("璇锋壂鎻忔墭鐩樻潯鐮侊紒"); + } + if (string.IsNullOrEmpty(locatNo)) + { + throw Oops.Bah("璇锋壂鎻忚捣濮嬪湴鐮侊紒"); + } + if (string.IsNullOrEmpty(areaNo)) + { + throw Oops.Bah("璇烽�夋嫨鐩爣鍖哄煙锛�"); + } + string EndLocat = string.Empty;//鐩爣浣嶇疆 + + var log = await Db.Queryable<LogTask>().FirstAsync(w => w.IsDel == "0" && w.PalletNo == palletNo && (w.Status == "0" || w.Status == "1")); + if (log != null) + { + throw Oops.Bah("璇ユ墭鐩樺凡鏈夌瓑寰呮墽琛屾垨姝e湪鎵ц鐨勪换鍔�!"); + } + var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(w => w.IsDel == "0" && w.PalletNo == palletNo); + if (stockDetail != null) + { + throw Oops.Bah("鎵樼洏涓婄墿鏂欏瓨鍦ㄥ簱瀛樻槑缁嗕俊鎭�,璇锋鏌�!"); + } + + var storageArea = await Db.Queryable<SysStorageArea>().FirstAsync(w => w.IsDel == "0" && w.AreaNo == areaNo); + if (storageArea == null) + { + throw Oops.Bah("鎵�閫夊尯鍩熶俊鎭笉瀛樺湪,璇锋鏌�!"); + } + var palletInfo = await Db.Queryable<SysPallets>().FirstAsync(w => w.IsDel == "0" && w.PalletNo == palletNo); + if (palletInfo == null) + { + throw Oops.Bah("璇ユ墭鐩樹俊鎭笉瀛樺湪!"); + } + if (palletInfo.Status!="0") + { + throw Oops.Bah("璇ユ墭鐩樹笉鏄┖鎵樼洏!"); + } + //鏍规嵁鐩爣鍖哄煙鑾峰彇鐩爣鍌ㄤ綅鍦板潃 + EndLocat = await GetLocat(areaNo); + if (string.IsNullOrEmpty(EndLocat)) + { + throw Oops.Bah("鑾峰彇鐩爣鍌ㄤ綅澶辫触!"); + } + + //璧峰鍌ㄤ綅淇℃伅 + var storageLocat = await Db.Queryable<SysStorageLocat>().FirstAsync(w => w.IsDel == "0" && w.LocatNo == locatNo); + if (storageLocat == null) + { + throw Oops.Bah("鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + //鐩爣鍌ㄤ綅淇℃伅 + //var storageLocatEnd = new SysStorageLocat(); + + var storageLocatEnd = await Db.Queryable<SysStorageLocat>().FirstAsync(w => w.IsDel == "0" && w.LocatNo == EndLocat && w.Flag == "0"); + if (storageLocatEnd == null) + { + throw Oops.Bah("鐩爣鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + + //娣诲姞鍑哄簱浠诲姟 + var taskNo = new Common().GetMaxNo("TK"); + var moveTask = new LogTask + { + TaskNo = taskNo, + Sender = "WMS", + Receiver = "WCS", + IsSuccess = 0, //鏄惁涓嬪彂鎴愬姛 0澶辫触 1鎴愬姛 + + StartLocat = storageLocat.LocatNo,//璧峰浣嶇疆 + EndLocat = EndLocat,//鐩爣浣嶇疆 + PalletNo = palletNo,//鎵樼洏鐮� + Msg = string.Format("杞繍浠诲姟锛歿0}=>>{1}", storageLocat.LocatNo, EndLocat), + IsSend = 1,//鏄惁鍙啀娆′笅鍙� + IsCancel = 1,//鏄惁鍙彇娑� + IsFinish = 1,//鏄惁鍙畬鎴� + Type = "2",//浠诲姟绫诲瀷 0 鍏ュ簱浠诲姟 1 鍑哄簱浠诲姟 2 绉诲簱浠诲姟 + Status = "0",//浠诲姟鐘舵��0锛氱瓑寰呮墽琛�1姝e湪鎵ц2鎵ц瀹屾垚 + OrderType = "3",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� + + CreateTime = DateTime.Now + }; + await Db.Insertable(moveTask).ExecuteCommandAsync(); + + //淇敼璧峰鍌ㄤ綅鍦板潃鐘舵�� + storageLocat.Status = "5";//0锛氱┖鍌ㄤ綅 1锛氭湁鐗╁搧 2锛氬叆搴撲腑 3锛氬嚭搴撲腑 4锛氱Щ鍏ヤ腑 5锛氱Щ鍑轰腑 + await Db.Updateable(storageLocat).ExecuteCommandAsync(); + + //淇敼鐩爣鍌ㄤ綅鍦板潃鐘舵�� + //if (storageLocatEnd != null) + //{ + // storageLocatEnd.Status = "4";//0锛氱┖鍌ㄤ綅 1锛氭湁鐗╁搧 2锛氬叆搴撲腑 3锛氬嚭搴撲腑 4锛氱Щ鍏ヤ腑 5锛氱Щ鍑轰腑 + // await Db.Updateable(storageLocatEnd).ExecuteCommandAsync(); + //} + //娣诲姞鎿嶄綔鏃ュ織璁板綍 + var k = new OperationCrServer().AddLogOperationCr("PDA妯″潡", "AGV绌烘墭杞繍", palletNo, "绉诲簱", $"PDA鍛煎彨灏忚溅瀵规墭鐩樺彿锛歿palletNo}鍙戣捣杞繍", userId); + + var outDto = new List<OutCommandDto> + { + new OutCommandDto() + { + TaskNo = moveTask.TaskNo, // 浠诲姟鍙� + TaskType = "2",// 浠诲姟绫诲瀷 0鍏� 1鍑� 2绉� + PalletNo = moveTask.PalletNo,//鎵樼洏鍙� + + StartLocate = moveTask.StartLocat, // 璧峰浣嶇疆 + EndLocate = EndLocat, // 鐩爣浣嶇疆 + + Order = 999, + Type = PLCTypeEnum.AGV + + } + }; + + // 姝e紡杩愯绋嬪簭鏀惧紑 + var list2 = outDto.Select(m => m.TaskNo).ToList(); + var jsonData = JsonConvert.SerializeObject(outDto); + string response = ""; + + try + { + var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") + response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橶CS鍑哄簱鍛戒护", "WCS"); + var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") + + //瑙f瀽杩斿洖鏁版嵁 + var wcsModel = JsonConvert.DeserializeObject<WcsModel2>(response); + if (wcsModel.code == 200) + { + // 鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// new TaskServer().EditTaskIssueOk(list2, time1, time2); } else @@ -1105,9 +1502,18 @@ string endLocat = string.Empty;//鐩爣鍌ㄤ綅 //褰撳墠鍖哄煙鎵�鏈夊偍浣嶄俊鎭� var storageLocatList = await Db.Queryable<SysStorageLocat>().Where(w => w.WareHouseNo == "W04" && w.AreaNo == areaNo).ToListAsync(); - - var locatInfo2 = storageLocatList.Where(w => w.IsDel == "0" && w.Flag == "0" && w.Status == "0") + + var locatInfo2 = new SysStorageLocat(); + if (areaNo == "B10") + { + locatInfo2 = storageLocatList.Where(w => w.IsDel == "0" && w.Flag == "0") .OrderByDescending(m => m.Layer).OrderByDescending(m => m.Column).OrderByDescending(m => m.Row).First(); + } + else + { + locatInfo2 = storageLocatList.Where(w => w.IsDel == "0" && w.Flag == "0" && w.Status == "0") + .OrderByDescending(m => m.Layer).OrderByDescending(m => m.Column).OrderByDescending(m => m.Row).First(); + } if (locatInfo2 != null) { @@ -1227,9 +1633,9 @@ } //寮�鍚簨鍔� Db.BeginTran(); - + //搴撳瓨绠辨敮鏄庣粏淇℃伅 - var boxList = Db.Queryable<DataBoxInfo>().Where(w => w.IsDel == "0" && w.BoxNo == boxNo).ToList(); + var boxList = Db.Queryable<DataBoxInfo>().Where(w => w.IsDel == "0" && w.BoxNo == boxNo && w.Status == "2").ToList(); if (boxList.Count != 1) { throw new Exception("璇ョ鐮佷俊鎭敊璇紝瀛樺湪澶氫釜姝ょ鐮佷俊鎭�"); @@ -1303,9 +1709,8 @@ SkuName = boxInfo.SkuName, LotNo = boxInfo.LotNo, BoxNoList = new List<string>() { boxNoNew } , - Date1 = boxInfo.ProductionTime.ToString(), - Date2 = boxInfo.ExpirationTime.ToString(), - + Date1 = boxInfo.ProductionTime == null ? "" : Convert.ToDateTime(boxInfo.ProductionTime).ToString("yyyy-MM-dd"), + Date2 = boxInfo.ExpirationTime == null ? "" : Convert.ToDateTime(boxInfo.ExpirationTime).ToString("yyyy-MM-dd"), }; #endregion -- Gitblit v1.8.0