From 90a00e294885d4a62fa7d8927513ff6f948ce6b4 Mon Sep 17 00:00:00 2001 From: Zhang-Hong-Lin <a3219986988@163.com> Date: 星期日, 27 四月 2025 10:21:36 +0800 Subject: [PATCH] 1 --- 项目代码/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs | 701 +++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 591 insertions(+), 110 deletions(-) diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs" index 17d369e..5031e00 100644 --- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs" +++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs" @@ -50,6 +50,12 @@ private readonly IRepository<dt_errormsgInfo> _errorinfoRepository; private readonly Idt_ErrormsginfoService _ErrormsginfoService; private readonly IMapper _mapper; + private readonly IRepository<dt_stationInfo> _dt_stationInfoRepository; + private readonly IRepository<Dt_Task> _dt_taskRepositiry; + private readonly IRepository<Dt_LocationInfo> _LocationInfoRepository; + private readonly IRepository<Dt_StockInfo> _StockInfoRepository; + private readonly IRepository<dt_batchInfo> _batchInfoRepository; + private readonly IRepository<dt_outstockinfo> _outStockRepository; private Dictionary<string, OrderByType> _taskOrderBy = new() { @@ -78,8 +84,14 @@ IRepository<dt_batchInfo> batchRepository, IRepository<Dt_Task_hty> taskhtyRepository, IRepository<dt_errormsgInfo> errorinfoRepository, + IRepository<dt_stationInfo> dt_stationInfoRepository, + IRepository<Dt_Task> dt_taskRepositiry, Idt_ErrormsginfoService errormsginfoService, IUnitOfWorkManage unitOfWorkManage, + IRepository<Dt_StockInfo> StockInfoRepository, + IRepository<dt_batchInfo> batchInfoRepository, + IRepository<Dt_LocationInfo> LocationInfoRepository, + IRepository<dt_outstockinfo> outStockRepository, IMapper mapper) : base(BaseDal) { _routerService = routerService; @@ -93,6 +105,12 @@ _errorinfoRepository = errorinfoRepository; _ErrormsginfoService = errormsginfoService; _mapper = mapper; + _dt_stationInfoRepository = dt_stationInfoRepository; + _dt_taskRepositiry = dt_taskRepositiry; + _StockInfoRepository = StockInfoRepository; + _LocationInfoRepository = LocationInfoRepository; + _batchInfoRepository = batchInfoRepository; + _outStockRepository = outStockRepository; } /// <summary> @@ -621,127 +639,210 @@ { throw new Exception(string.Format("澶╄溅鏀捐揣瀹屾垚浠诲姟鏈煡璇㈠埌浠诲姟鍙穥0}", taskNum)); } - - + if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound) { - var batck = _batchinfoRepository.QueryFirst(v=>v.Id==1); - //鏂板缓搴撳瓨 - Dt_StockInfo stock = new Dt_StockInfo(); - stock.LocationCode = nawtask.TargetAddress; - stock.Weight = (decimal)weight; - stock.StockStatus = (int)stockEnum.Free; - stock.BatchNo = batck.InBatch; - if (nawtask.Remark== (int)MateTypeEnum.ZiChan) + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鍓旈櫎鏋�"); + string sourceAddress = station.Row + "-" + station.Column + "-1"; + if (nawtask.SourceAddress.Equals(sourceAddress)) { - stock.Remark = (int)MateTypeEnum.ZiChan; + var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); + //鏂板缓搴撳瓨 + Dt_StockInfo stock = new Dt_StockInfo(); + stock.LocationCode = nawtask.TargetAddress; + stock.Weight = (decimal)weight; + stock.StockStatus = (int)stockEnum.Free; + stock.BatchNo = batck.InBatch; + stock.Remark = 3; + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); + location.LocationStatus = (int)LocationStatusEnum.InStock; + //澶勭悊浠诲姟淇℃伅 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + + //寮�濮嬫暟鎹簱浜嬪姟 + _unitOfWorkManage.BeginTran(); + _stockRepository.AddData(stock); + _locationRepository.UpdateData(location); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); } else { - stock.Remark = (int)MateTypeEnum.WaiGou; + var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); + //鏂板缓搴撳瓨 + Dt_StockInfo stock = new Dt_StockInfo(); + stock.LocationCode = nawtask.TargetAddress; + stock.Weight = (decimal)weight; + stock.StockStatus = (int)stockEnum.Free; + stock.BatchNo = batck.InBatch; + if (nawtask.Remark == (int)MateTypeEnum.ZiChan) + { + stock.Remark = (int)MateTypeEnum.ZiChan; + } + else + { + stock.Remark = (int)MateTypeEnum.WaiGou; + } + Dt_StockInfo stockTow = new Dt_StockInfo(); + stockTow.LocationCode = nawtask.NextAddress; + stockTow.Weight = (decimal)weight; + stockTow.StockStatus = (int)stockEnum.Free; + stockTow.BatchNo = batck.InBatch; + if (nawtask.Remark == (int)MateTypeEnum.ZiChan) + { + stockTow.Remark = (int)MateTypeEnum.ZiChan; + } + else + { + stockTow.Remark = (int)MateTypeEnum.WaiGou; + } + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); + location.LocationStatus = (int)LocationStatusEnum.InStock; + //淇敼璐т綅淇℃伅 + var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); + locationtow.LocationStatus = (int)LocationStatusEnum.InStock; + //澶勭悊浠诲姟淇℃伅 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + + //寮�濮嬫暟鎹簱浜嬪姟 + _unitOfWorkManage.BeginTran(); + _stockRepository.AddData(stock); + _stockRepository.AddData(stockTow); + _locationRepository.UpdateData(location); + _locationRepository.UpdateData(locationtow); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); } - Dt_StockInfo stockTow = new Dt_StockInfo(); - stockTow.LocationCode = nawtask.NextAddress; - stockTow.Weight = (decimal)weight; - stockTow.StockStatus = (int)stockEnum.Free; - stockTow.BatchNo = batck.InBatch; - if (nawtask.Remark == (int)MateTypeEnum.ZiChan) - { - stockTow.Remark = (int)MateTypeEnum.ZiChan; - } - else - { - stockTow.Remark = (int)MateTypeEnum.WaiGou; - } - //淇敼璐т綅淇℃伅 - var location = _locationRepository.QueryFirst(v=>v.LocationCode==nawtask.TargetAddress); - location.LocationStatus = (int)LocationStatusEnum.InStock; - //淇敼璐т綅淇℃伅 - var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); - locationtow.LocationStatus = (int)LocationStatusEnum.InStock; - //澶勭悊浠诲姟淇℃伅 - Dt_Task_hty taskhty = new Dt_Task_hty(); - taskhty.TaskNum = nawtask.TaskNum; - taskhty.Roadway = nawtask.Roadway; - taskhty.TaskType = nawtask.TaskType; - taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; - taskhty.SourceAddress = nawtask.SourceAddress; - taskhty.TargetAddress = nawtask.TargetAddress; - taskhty.ExceptionMessage = nawtask.ExceptionMessage; - taskhty.Grade = nawtask.Grade; - taskhty.Dispatchertime = nawtask.Dispatchertime; - taskhty.Remark = nawtask.Remark; - taskhty.PalletCode = nawtask.PalletCode; - taskhty.NextAddress = nawtask.NextAddress; - taskhty.CurrentAddress = nawtask.CurrentAddress; - - //寮�濮嬫暟鎹簱浜嬪姟 - _unitOfWorkManage.BeginTran(); - _stockRepository.AddData(stock); - _stockRepository.AddData(stockTow); - _locationRepository.UpdateData(location); - _locationRepository.UpdateData(locationtow); - _taskhtyRepository.AddData(taskhty); - BaseDal.DeleteData(nawtask); - //鎻愪氦浜嬪姟 - _unitOfWorkManage.CommitTran(); } else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound) { - //鏌ユ壘搴撳瓨 - var stock = _stockRepository.QueryFirst(v=>v.LocationCode== nawtask.SourceAddress); - if (stock == null) + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "瑗胯法鏋跺瓙"); + string targetAddress = station.Row + "-" + station.Column + "-1"; + if (nawtask.TargetAddress.Equals(targetAddress)) { - throw new Exception($"鏈壘鍒板簱瀛樹俊鎭揣浣嶅彿:銆恵nawtask.TargetAddress}銆�"); + //鏌ユ壘搴撳瓨 + var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + if (stock == null) + { + throw new Exception($"鏈壘鍒板簱瀛樹俊鎭揣浣嶅彿:銆恵nawtask.TargetAddress}銆�"); + } + //淇敼璐т綅鐘舵�� + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + location.LocationStatus = (int)LocationStatusEnum.Free; + //鍑嗗鍘嗗彶浠诲姟鏁版嵁 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + //寮�濮嬫暟鎹簱浜嬪姟 + + _unitOfWorkManage.BeginTran(); + _stockRepository.DeleteData(stock); + _locationRepository.UpdateData(location); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); } - var Towstock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); - //淇敼璐т綅鐘舵�� - var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); - location.LocationStatus = (int)LocationStatusEnum.Free; - //淇敼璐т綅鐘舵�� - var locationTow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); - locationTow.LocationStatus = (int)LocationStatusEnum.Free; - //鍑嗗鍘嗗彶浠诲姟鏁版嵁 - Dt_Task_hty taskhty = new Dt_Task_hty(); - taskhty.TaskNum = nawtask.TaskNum; - taskhty.Roadway = nawtask.Roadway; - taskhty.TaskType = nawtask.TaskType; - taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; - taskhty.SourceAddress = nawtask.SourceAddress; - taskhty.TargetAddress = nawtask.TargetAddress; - taskhty.ExceptionMessage = nawtask.ExceptionMessage; - taskhty.Grade = nawtask.Grade; - taskhty.Dispatchertime = nawtask.Dispatchertime; - taskhty.Remark = nawtask.Remark; - taskhty.PalletCode = nawtask.PalletCode; - taskhty.NextAddress = nawtask.NextAddress; - taskhty.CurrentAddress = nawtask.CurrentAddress; - //濡傛灉鏀捐揣浣嶇疆琛屾槸40锛屽垯绔嬮┈鐢熸垚涓�鏉$Щ鍔ㄤ换鍔� - //寮�濮嬪垱寤轰换鍔� - Dt_Task Movstask = new Dt_Task(); - Movstask.Roadway = "TC01"; - Movstask.TaskType = (int)TaskMoveEnum.Mowe; - Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove; - Movstask.SourceAddress = "0"; - Movstask.TargetAddress = "1-5-1"; - Movstask.NextAddress = "text"; - Movstask.Grade = 1; - Movstask.WMSId = 3; - Movstask.Remark = 0; - Movstask.PalletCode = "text"; - Movstask.CurrentAddress = "text"; - //寮�濮嬫暟鎹簱浜嬪姟 - - _unitOfWorkManage.BeginTran(); - BaseDal.AddData(Movstask); - _stockRepository.DeleteData(stock); - _stockRepository.DeleteData(Towstock); - _locationRepository.UpdateData(location); - _locationRepository.UpdateData(locationTow); - _taskhtyRepository.AddData(taskhty); - BaseDal.DeleteData(nawtask); - //鎻愪氦浜嬪姟 - _unitOfWorkManage.CommitTran(); + else + { + //鏌ユ壘搴撳瓨 + var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + if (stock == null) + { + throw new Exception($"鏈壘鍒板簱瀛樹俊鎭揣浣嶅彿:銆恵nawtask.TargetAddress}銆�"); + } + var Towstock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); + //淇敼璐т綅鐘舵�� + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + location.LocationStatus = (int)LocationStatusEnum.Free; + //淇敼璐т綅鐘舵�� + var locationTow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); + locationTow.LocationStatus = (int)LocationStatusEnum.Free; + //鍑嗗鍘嗗彶浠诲姟鏁版嵁 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + //濡傛灉鏀捐揣浣嶇疆琛屾槸40锛屽垯绔嬮┈鐢熸垚涓�鏉$Щ鍔ㄤ换鍔� + //寮�濮嬪垱寤轰换鍔� + Dt_Task Movstask = new Dt_Task(); + Movstask.Roadway = "TC01"; + Movstask.TaskType = (int)TaskMoveEnum.Mowe; + Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove; + Movstask.SourceAddress = "0"; + Movstask.TargetAddress = "8-5-1"; + Movstask.NextAddress = "text"; + Movstask.Grade = 1; + Movstask.WMSId = 3; + Movstask.Remark = 0; + Movstask.PalletCode = "text"; + Movstask.CurrentAddress = "text"; + //寮�濮嬫暟鎹簱浜嬪姟 + + _unitOfWorkManage.BeginTran(); + BaseDal.AddData(Movstask); + _stockRepository.DeleteData(stock); + _stockRepository.DeleteData(Towstock); + _locationRepository.UpdateData(location); + _locationRepository.UpdateData(locationTow); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); + } } else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.OutInventory || nawtask.TaskType == (int)TaskMoveEnum.Mowe) { @@ -768,7 +869,7 @@ Movstask.TaskType = (int)TaskMoveEnum.Mowe; Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove; Movstask.SourceAddress = "0"; - Movstask.TargetAddress = "1-5-1"; + Movstask.TargetAddress = "8-5-1"; Movstask.NextAddress = "text"; Movstask.Grade = 1; Movstask.WMSId = 3; @@ -895,5 +996,385 @@ } return content; } + + public WebResponseContent AtOnceUpdate(int taskid) + { + WebResponseContent content = new WebResponseContent(); + Dt_Task nawtask = BaseDal.QueryFirst(v => v.TaskId == taskid); + //鍏ュ簱 + if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound) + { + //鍓旈櫎鍏ュ簱 + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鍓旈櫎鏋�"); + string sourceAddress = station.Row + "-" + station.Column + "-1"; + if (nawtask.SourceAddress.Equals(sourceAddress)) + { + var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); + //鏂板缓搴撳瓨 + Dt_StockInfo stock = new Dt_StockInfo(); + stock.LocationCode = nawtask.TargetAddress; + stock.StockStatus = (int)stockEnum.Free; + stock.BatchNo = batck.InBatch; + stock.Remark = 3; + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); + location.LocationStatus = (int)LocationStatusEnum.InStock; + //澶勭悊浠诲姟淇℃伅 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + + //寮�濮嬫暟鎹簱浜嬪姟 + _unitOfWorkManage.BeginTran(); + _stockRepository.AddData(stock); + _locationRepository.UpdateData(location); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); + } + //姝e父鍏ュ簱 + else + { + var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); + //鏂板缓搴撳瓨 + Dt_StockInfo stock = new Dt_StockInfo(); + stock.LocationCode = nawtask.TargetAddress; + stock.StockStatus = (int)stockEnum.Free; + stock.BatchNo = batck.InBatch; + if (nawtask.Remark == (int)MateTypeEnum.ZiChan) + { + stock.Remark = (int)MateTypeEnum.ZiChan; + } + else + { + stock.Remark = (int)MateTypeEnum.WaiGou; + } + Dt_StockInfo stockTow = new Dt_StockInfo(); + stockTow.LocationCode = nawtask.NextAddress; + stockTow.StockStatus = (int)stockEnum.Free; + stockTow.BatchNo = batck.InBatch; + if (nawtask.Remark == (int)MateTypeEnum.ZiChan) + { + stockTow.Remark = (int)MateTypeEnum.ZiChan; + } + else + { + stockTow.Remark = (int)MateTypeEnum.WaiGou; + } + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); + location.LocationStatus = (int)LocationStatusEnum.InStock; + //淇敼璐т綅淇℃伅 + var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); + locationtow.LocationStatus = (int)LocationStatusEnum.InStock; + //澶勭悊浠诲姟淇℃伅 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + + //寮�濮嬫暟鎹簱浜嬪姟 + _unitOfWorkManage.BeginTran(); + _stockRepository.AddData(stock); + _stockRepository.AddData(stockTow); + _locationRepository.UpdateData(location); + _locationRepository.UpdateData(locationtow); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); + } + } + //鍑哄簱 + else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound) + { + //鍓旈櫎鍑哄簱 + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "瑗胯法鏋跺瓙"); + string targetAddress = station.Row + "-" + station.Column + "-1"; + if (nawtask.TargetAddress.Equals(targetAddress)) + { + //鏌ユ壘搴撳瓨 + var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + if (stock == null) + { + throw new Exception($"鏈壘鍒板簱瀛樹俊鎭揣浣嶅彿:銆恵nawtask.TargetAddress}銆�"); + } + //淇敼璐т綅鐘舵�� + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + location.LocationStatus = (int)LocationStatusEnum.Free; + //鍑嗗鍘嗗彶浠诲姟鏁版嵁 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + //寮�濮嬫暟鎹簱浜嬪姟 + + _unitOfWorkManage.BeginTran(); + _stockRepository.DeleteData(stock); + _locationRepository.UpdateData(location); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); + } + //姝e父鍑哄簱 + else + { + //鏌ユ壘搴撳瓨 + var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + if (stock == null) + { + throw new Exception($"鏈壘鍒板簱瀛樹俊鎭揣浣嶅彿:銆恵nawtask.TargetAddress}銆�"); + } + var Towstock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); + //淇敼璐т綅鐘舵�� + var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); + location.LocationStatus = (int)LocationStatusEnum.Free; + //淇敼璐т綅鐘舵�� + var locationTow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); + locationTow.LocationStatus = (int)LocationStatusEnum.Free; + //鍑嗗鍘嗗彶浠诲姟鏁版嵁 + Dt_Task_hty taskhty = new Dt_Task_hty(); + taskhty.TaskNum = nawtask.TaskNum; + taskhty.Roadway = nawtask.Roadway; + taskhty.TaskType = nawtask.TaskType; + taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; + taskhty.SourceAddress = nawtask.SourceAddress; + taskhty.TargetAddress = nawtask.TargetAddress; + taskhty.ExceptionMessage = nawtask.ExceptionMessage; + taskhty.Grade = nawtask.Grade; + taskhty.Dispatchertime = nawtask.Dispatchertime; + taskhty.Remark = nawtask.Remark; + taskhty.PalletCode = nawtask.PalletCode; + taskhty.NextAddress = nawtask.NextAddress; + taskhty.CurrentAddress = nawtask.CurrentAddress; + //寮�濮嬫暟鎹簱浜嬪姟 + + _unitOfWorkManage.BeginTran(); + _stockRepository.DeleteData(stock); + _stockRepository.DeleteData(Towstock); + _locationRepository.UpdateData(location); + _locationRepository.UpdateData(locationTow); + _taskhtyRepository.AddData(taskhty); + BaseDal.DeleteData(nawtask); + //鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); + } + } + return content.OK("瀹屾垚"); + } + + public WebResponseContent speciadelete(Dt_Task task) + { + WebResponseContent content = new WebResponseContent(); + if (task.TaskState == (int)TaskMoveStatusEnum.OutNewMove) + { + BaseDal.DeleteData(task); + } + else if (task.TaskState == (int)TaskInStatusEnum.InNew) + { + //鍓旈櫎鍏ュ簱 + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鍓旈櫎鏋�"); + string sourceAddress = station.Row + "-" + station.Column + "-1"; + if (task.SourceAddress.Equals(sourceAddress)) + { + Dt_LocationInfo locationinfo = _locationRepository.QueryFirst(v => v.LocationCode == task.TargetAddress); + locationinfo.LocationStatus = 0; + _unitOfWorkManage.BeginTran(); + _locationRepository.UpdateData(locationinfo); + BaseDal.DeleteData(task); + _unitOfWorkManage.CommitTran(); + return content.OK("2"); + } + else + { + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == task.TargetAddress); + location.LocationStatus = (int)LocationStatusEnum.Free; + //淇敼璐т綅淇℃伅 + var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == task.NextAddress); + locationtow.LocationStatus = (int)LocationStatusEnum.Free; + _unitOfWorkManage.BeginTran(); + _locationRepository.UpdateData(location); + _locationRepository.UpdateData(locationtow); + BaseDal.DeleteData(task); + _unitOfWorkManage.CommitTran(); + return content.OK("3"); + } + } + else if (task.TaskState == (int)TaskOutStatusEnum.OutNew) + { + //鍓旈櫎鍑哄簱 + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "瑗胯法鏋跺瓙"); + string targetAddress = station.Row + "-" + station.Column + "-1"; + if (task.TargetAddress.Equals(targetAddress)) + { + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == task.SourceAddress); + location.LocationStatus = (int)LocationStatusEnum.InStock; + Dt_StockInfo stockInfo = _stockRepository.QueryFirst(v => v.LocationCode == task.SourceAddress); + stockInfo.StockStatus = (int)stockEnum.Free; + _unitOfWorkManage.BeginTran(); + _locationRepository.UpdateData(location); + _stockRepository.UpdateData(stockInfo); + BaseDal.DeleteData(task); + _unitOfWorkManage.CommitTran(); + return content.OK("4"); + } + else + { + //淇敼璐т綅淇℃伅 + var location = _locationRepository.QueryFirst(v => v.LocationCode == task.SourceAddress); + location.LocationStatus = (int)LocationStatusEnum.InStock; + //淇敼璐т綅淇℃伅 + var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == task.NextAddress); + locationtow.LocationStatus = (int)LocationStatusEnum.InStock; + + Dt_StockInfo stockInfo = _stockRepository.QueryFirst(v => v.LocationCode == task.SourceAddress); + stockInfo.StockStatus = (int)stockEnum.Free; + Dt_StockInfo stockInfos = _stockRepository.QueryFirst(v => v.LocationCode == task.NextAddress); + stockInfos.StockStatus = (int)stockEnum.Free; + _unitOfWorkManage.BeginTran(); + _locationRepository.UpdateData(location); + _locationRepository.UpdateData(locationtow); + _stockRepository.UpdateData(stockInfo); + _stockRepository.UpdateData(stockInfos); + BaseDal.DeleteData(task); + _unitOfWorkManage.CommitTran(); + return content.OK("5"); + } + } + return content.OK("1"); + } + + public WebResponseContent speciaupdate(Dt_Task task) + { + WebResponseContent content = new WebResponseContent(); + if (task.TaskState == (int)TaskInStatusEnum.InNew) + { + task.TaskState = (int)TaskInStatusEnum.Line_Ingrab; + BaseDal.UpdateData(task); + } + else if (task.TaskState == (int)TaskInStatusEnum.Line_Ingrab) + { + task.TaskState = (int)TaskInStatusEnum.InNew; + BaseDal.UpdateData(task); + } + else if (task.TaskState == (int)TaskOutStatusEnum.OutNew) + { + task.TaskState = (int)TaskOutStatusEnum.SC_OutExecuting; + BaseDal.UpdateData(task); + } + else if (task.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting) + { + task.TaskState = (int)TaskOutStatusEnum.OutNew; + BaseDal.UpdateData(task); + } + else + { + return content.OK("鐘舵�佷笉鍏佽"); + } + return content.OK("1"); + } + + public WebResponseContent banzidong(string wei,string weis) + { + WebResponseContent content = new WebResponseContent(); + //if (!OHTJob.oHTReadData.R_ZXJ_isWork) + //{ + // throw new Exception($"鏁村舰鏈烘姇鍏ヤ娇鐢ㄤ俊鍙蜂负false"); + //} + var isout = _outStockRepository.QueryFirst(v => v.Id == 1); + if (isout.isout == 0) + { + //if (!OHTJob.oHTReadData.R_ZXJ_TCMode) + //{ + // throw new Exception($"鏁村舰鏈轰笉灞炰簬澶╄溅涓婃枡妯″紡鎴栧ぉ杞︽斁鏉夸俊鍙蜂负false"); + //} + //if (!OHTJob.oHTReadData.R_HC_isReadyWork) + //{ + // throw new Exception($"鏁村舰鏈哄ぉ杞︽斁鏉夸俊鍙蜂负false"); + //} + //鏌ヨ褰撳墠浠诲姟姹犱腑鏄惁瀛樺湪鍑哄簱浠诲姟锛屽嚭搴撲换鍔″彧鑳藉瓨鍦ㄤ竴鏉� + var oldtask = _dt_taskRepositiry.QueryFirst(v => v.TaskType == (int)TaskOutboundTypeEnum.Outbound); + if (oldtask != null) + { + throw new Exception($"褰撳墠浠诲姟姹犱腑宸插瓨鍦ㄤ竴鏉″嚭搴撲换鍔�"); + } + + //鏌ヨ搴撳瓨 + Dt_StockInfo ku = _stockRepository.QueryFirst(v => v.LocationCode == wei); + if (ku == null) + { + return content.OK("3"); + } + //鏌ヨ鐩搁偦搴撳瓨 + Dt_StockInfo kus = _stockRepository.QueryFirst(v => v.LocationCode == weis); + ku.StockStatus = (int)stockEnum.Lock; + kus.StockStatus = (int)stockEnum.Lock; + //鏌ヨ璐т綅 + Dt_LocationInfo huo = _LocationInfoRepository.QueryFirst(v => v.LocationCode == wei); + //鏌ヨ鐩搁偦璐т綅 + Dt_LocationInfo huos = _LocationInfoRepository.QueryFirst(v => v.LocationCode == weis); + huo.LocationStatus = (int)LocationStatusEnum.Lock; + huos.LocationStatus = (int)LocationStatusEnum.Lock; + //鏌ヨ缁堢偣绔欏彴淇℃伅 + var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鏁村舰鏈烘斁鏂欎綅"); + //寮�濮嬪垱寤轰换鍔� + Dt_Task outtask = new Dt_Task(); + outtask.Roadway = "TC01"; + outtask.TaskType = (int)TaskOutboundTypeEnum.Outbound; + outtask.TaskState = (int)TaskOutStatusEnum.OutNew; + outtask.SourceAddress = ku.LocationCode; + outtask.TargetAddress = station.Row + "-" + station.Column + "-1"; + outtask.NextAddress = huos.LocationCode; + outtask.Grade = 2; + outtask.WMSId = 3; + outtask.Remark = kus.Remark; + outtask.PalletCode = "text"; + outtask.CurrentAddress = "text"; + _unitOfWorkManage.BeginTran(); + _LocationInfoRepository.UpdateData(huo); + _LocationInfoRepository.UpdateData(huos); + _StockInfoRepository.UpdateData(ku); + _dt_taskRepositiry.AddData(outtask); + _StockInfoRepository.UpdateData(kus); + _unitOfWorkManage.CommitTran(); + return content.OK("2"); + } + return content.OK("1"); + } } } -- Gitblit v1.9.3