From 48ed41879227c9b495f48ecd7cfde0acfd375da3 Mon Sep 17 00:00:00 2001
From: zhanghonglin <zhanghonglin@hnkhzn.com>
Date: 星期二, 28 十月 2025 08:53:12 +0800
Subject: [PATCH] 新增整形机入库功能
---
项目代码/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs | 1129 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 1,056 insertions(+), 73 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 958a791..75939b9 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"
@@ -16,15 +16,22 @@
#endregion << 鐗� 鏈� 娉� 閲� >>
using AutoMapper;
+using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using SqlSugar;
using System.Diagnostics.CodeAnalysis;
+using System.Threading.Tasks;
+using WIDESEAWCS_Common.LocationEnum;
+using WIDESEAWCS_Common.StockEnum;
using WIDESEAWCS_Common.TaskEnum;
using WIDESEAWCS_Core;
using WIDESEAWCS_Core.BaseRepository;
using WIDESEAWCS_Core.BaseServices;
using WIDESEAWCS_DTO.TaskInfo;
+using WIDESEAWCS_ISystemServices;
using WIDESEAWCS_ITaskInfoService;
+using WIDESEAWCS_IWMSPart;
using WIDESEAWCS_Model.Models;
+using WIDESEAWCS_Model.Models.System;
using WIDESEAWCS_QuartzJob.Models;
using WIDESEAWCS_QuartzJob.Service;
@@ -35,7 +42,20 @@
private readonly IRouterService _routerService;
private readonly ITaskExecuteDetailService _taskExecuteDetailService;
private readonly IRepository<Dt_TaskExecuteDetail> _taskExecuteDetailRepository;
+ private readonly IRepository<Dt_StockInfo> _stockRepository;
+ private readonly IRepository<Dt_LocationInfo> _locationRepository;
+ private readonly IRepository<dt_batchInfo> _batchinfoRepository;
+ private readonly IRepository<Dt_Task_hty> _taskhtyRepository;
+ private readonly IUnitOfWorkManage _unitOfWorkManage;
+ 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()
{
@@ -54,12 +74,43 @@
/// </summary>
public IRepository<Dt_Task> Repository => BaseDal;
- public TaskService(IRepository<Dt_Task> BaseDal, IRouterService routerService, ITaskExecuteDetailService taskExecuteDetailService, IRepository<Dt_TaskExecuteDetail> taskExecuteDetailRepository, IMapper mapper) : base(BaseDal)
+ //SBText ITaskService.text { get => throw new NotImplementedException(); set => throw new NotImplementedException(); }
+
+ public TaskService(IRepository<Dt_Task> BaseDal, IRouterService routerService,
+ ITaskExecuteDetailService taskExecuteDetailService,
+ IRepository<Dt_TaskExecuteDetail> taskExecuteDetailRepository,
+ IRepository<Dt_StockInfo> stockRepository,
+ IRepository<Dt_LocationInfo> locationRepository,
+ 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;
_taskExecuteDetailService = taskExecuteDetailService;
_taskExecuteDetailRepository = taskExecuteDetailRepository;
+ _stockRepository = stockRepository;
+ _locationRepository = locationRepository;
+ _batchinfoRepository = batchRepository;
+ _taskhtyRepository = taskhtyRepository;
+ _unitOfWorkManage = unitOfWorkManage;
+ _errorinfoRepository = errorinfoRepository;
+ _ErrormsginfoService = errormsginfoService;
_mapper = mapper;
+ _dt_stationInfoRepository = dt_stationInfoRepository;
+ _dt_taskRepositiry = dt_taskRepositiry;
+ _StockInfoRepository = StockInfoRepository;
+ _LocationInfoRepository = LocationInfoRepository;
+ _batchInfoRepository = batchInfoRepository;
+ _outStockRepository = outStockRepository;
}
/// <summary>
@@ -152,6 +203,17 @@
}
/// <summary>
+ /// 鏍规嵁浠诲姟鐘舵�佹煡璇换鍔�
+ /// </summary>
+ /// <param name="deviceNo">璁惧缂栧彿</param>
+ /// <param name="currentAddress">褰撳墠鍦板潃</param>
+ /// <returns></returns>
+ public Dt_Task QueryTaskState()
+ {
+ return BaseDal.QueryFirst(x => x.TaskState == (int)TaskInStatusEnum.InNew);
+ }
+
+ /// <summary>
/// 鏍规嵁璁惧缂栧彿銆佸綋鍓嶅湴鍧�鏌ヨ杈撻�佺嚎鏈墽琛岀殑浠诲姟
/// </summary>
/// <param name="deviceNo">璁惧缂栧彿</param>
@@ -207,12 +269,75 @@
/// <param name="deviceNo">璁惧缂栧彿</param>
/// <param name="currentAddress">褰撳墠鍦板潃</param>
/// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
- public Dt_Task QueryStackerCraneTask(string deviceNo, string currentAddress = "")
+ public Dt_Task QueryStackerCraneTask(string workTpe, string currentAddress = "")
{
- if (string.IsNullOrEmpty(currentAddress))
- return BaseDal.QueryFirst(x => x.Roadway == deviceNo && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
+ Dt_Task task = new Dt_Task();
+ try
+ {
+ //浼樺厛鏌ヨ褰撳墠浠诲姟姹犱腑鏄惁鏈夊彇璐у畬鎴愮殑浠诲姟
+ task = BaseDal.QueryFirst(v => v.TaskState == (int)TaskInStatusEnum.Line_Ingrab || v.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting);
+ if (task != null)
+ {
+ //浼樺厛杩斿洖鎵ц鍒颁竴鍗婄殑浠诲姟缁х画鎵ц
+ return task;
+ }
+ else
+ {
+ //鏌ヨ澶╄溅绉诲姩浠诲姟
+ task = BaseDal.QueryFirst(v => v.TaskType == (int)TaskMoveEnum.Mowe && v.TaskState == (int)TaskMoveStatusEnum.OutNewMove);
+ if (task != null)
+ {
+ return task;
+ }
+ }
+ //鏌ヨ褰撳墠浠诲姟姹犱腑鏄惁瀛樺湪鐘舵�佷负闈炴柊寤虹殑
+ //task= BaseDal.QueryFirst(v => v.TaskState != (int)TaskInStatusEnum.InNew || v.TaskState != (int)TaskOutStatusEnum.OutNew);
+ //if (task != null)
+ //{
+ // throw new Exception($"褰撳墠浠诲姟姹犱腑瀛樺湪鎵ц涓殑浠诲姟,浠诲姟鍙�:銆恵task.TaskNum}銆�");
+ //}
+ //if (task != null)
+ //{
+ // if (task.TaskState != (int)TaskMoveStatusEnum.OutNewMove)
+ // {
+
+ // }
+ //}
+ if (workTpe.Equals("In"))
+ {
+ //OrderBy(鍗囧簭鎺掑簭)
+ task = BaseDal.QueryData(v => (v.TaskType == (int)TaskInboundTypeEnum.TiChuRuKu || v.TaskType == (int)TaskInboundTypeEnum.Inbound) && v.TaskState == (int)TaskInStatusEnum.InNew).OrderByDescending(v => v.Grade).First();
+ }
+ else if (workTpe.Equals("Out"))
+ {
+ task = BaseDal.QueryData(v => (v.TaskType == (int)TaskOutboundTypeEnum.TiChuChuKu || v.TaskType == (int)TaskOutboundTypeEnum.TiChuZhiJieChuKu || v.TaskType == (int)TaskOutboundTypeEnum.Outbound || v.TaskType == (int)TaskOutboundTypeEnum.OutInventory) && v.TaskState == (int)TaskOutStatusEnum.OutNew).OrderByDescending(v => v.Grade).First();
+ }
+
+ }
+ catch (Exception)
+ {
+ //灏嗛敊璇俊鎭洿鏂拌嚦閿欒淇℃伅璁板綍琛�
+
+ }
+ return task;
+ }
+
+ public Dt_Task QueryTasking()
+ {
+ Dt_Task task = new Dt_Task();
+ task = BaseDal.QueryFirst(v => v.TaskState != (int)TaskInStatusEnum.InNew
+ && v.TaskState != (int)TaskMoveStatusEnum.OutNewMove
+ && v.TaskState != (int)TaskOutStatusEnum.OutNew
+ && v.TaskState != (int)TaskOutStatusEnum.SC_OutExecuting
+ && v.TaskState != (int)TaskInStatusEnum.Line_Ingrab);
+ if (task != null)
+ {
+ return task;
+ }
else
- return BaseDal.QueryFirst(x => x.Roadway == deviceNo && x.CurrentAddress == currentAddress && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
+ {
+ return null;
+ }
}
/// <summary>
@@ -251,13 +376,13 @@
/// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
public Dt_Task QueryTakNnmTask(int taskNum)
{
- return BaseDal.QueryFirst(v=>v.TaskNum== taskNum);
+ return BaseDal.QueryFirst(v => v.TaskId == taskNum);
}
/// <summary>
/// 淇敼澶╄溅浠诲姟鐘舵�侊紝灏嗗叆搴撳彇璐ф墽琛屼腑淇敼涓哄叆搴撳彇璐у畬鎴�
/// </summary>
/// <returns></returns>
- public WebResponseContent UpdateTaskStatusToLine_Ingrab(Dt_Task task)
+ public WebResponseContent UpdateTaskStatusToLine_Ingrab(Dt_Task task)
{
WebResponseContent content = new WebResponseContent();
try
@@ -269,6 +394,7 @@
catch (Exception ex)
{
content = WebResponseContent.Instance.Error(ex.Message);
+ UpdateTaskExceptionMessage(task.TaskId, ex.Message);
}
return content;
}
@@ -289,6 +415,7 @@
catch (Exception ex)
{
content = WebResponseContent.Instance.Error(ex.Message);
+ UpdateTaskExceptionMessage(task.TaskId, ex.Message);
}
return content;
}
@@ -314,21 +441,21 @@
WebResponseContent content = new WebResponseContent();
try
{
- Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
+ Dt_Task task = BaseDal.QueryFirst(x => x.TaskId == taskNum);
if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�");
- if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup)
- {
- task.TaskState = (int)TaskOutStatusEnum.OutPending;
- }
- else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup)
- {
- task.TaskState = (int)TaskInStatusEnum.InPending;
- }
+ //if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup)
+ //{
+ // task.TaskState = (int)TaskOutStatusEnum.OutPending;
+ //}
+ //else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup)
+ //{
+ // task.TaskState = (int)TaskInStatusEnum.InPending;
+ //}
task.ExceptionMessage = message;
task.ModifyDate = DateTime.Now;
BaseDal.UpdateData(task);
- _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, task.ExceptionMessage);
+ //_taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, task.ExceptionMessage);
content = WebResponseContent.Instance.OK();
}
@@ -340,17 +467,42 @@
}
/// <summary>
- /// 鏇存柊浠诲姟鐘舵�佷俊鎭紝骞跺悓姝ヨ嚦WMS
+ /// 鏇存柊浠诲姟鐘舵�佷俊鎭�
/// </summary>
/// <param name="taskNum">浠诲姟鍙�</param>
/// <param name="status">浠诲姟鐘舵��</param>
public void UpdateTaskStatus(int taskNum, int status)
{
- Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
- if (task == null) return;
- task.TaskState = status;
- task.ModifyDate = DateTime.Now;
- BaseDal.UpdateData(task);
+ try
+ {
+ Dt_Task task = BaseDal.QueryFirst(x => x.TaskId == taskNum);
+ if (status == 2 && (task.TaskType == (int)TaskInboundTypeEnum.Inbound || task.TaskType == (int)TaskInboundTypeEnum.TiChuRuKu))
+ {
+ task.TaskState = (int)TaskInStatusEnum.Line_InGrabExecuting;
+ }
+ else if (status == 2 && (task.TaskType == (int)TaskOutboundTypeEnum.Outbound || task.TaskType == (int)TaskOutboundTypeEnum.OutInventory || task.TaskType == (int)TaskOutboundTypeEnum.TiChuChuKu || task.TaskType == (int)TaskOutboundTypeEnum.TiChuZhiJieChuKu))
+ {
+ task.TaskState = (int)TaskOutStatusEnum.Line_OutGrabExecuting;
+ }
+ else if (status == 3 && (task.TaskType == (int)TaskInboundTypeEnum.Inbound || task.TaskType == (int)TaskInboundTypeEnum.TiChuRuKu))
+ {
+ task.TaskState = (int)TaskInStatusEnum.Line_InDownExecuting;
+ }
+ else if (status == 3 && (task.TaskType == (int)TaskOutboundTypeEnum.Outbound || task.TaskType == (int)TaskOutboundTypeEnum.OutInventory || task.TaskType == (int)TaskOutboundTypeEnum.TiChuChuKu || task.TaskType == (int)TaskOutboundTypeEnum.TiChuZhiJieChuKu))
+ {
+ task.TaskState = (int)TaskOutStatusEnum.Line_OutWownExecuting;
+ }
+ else if (status == 4 && task.TaskType == (int)TaskMoveEnum.Mowe)
+ {
+ task.TaskState = (int)TaskMoveStatusEnum.Line_OutMove;
+ }
+ task.ModifyDate = DateTime.Now;
+ BaseDal.UpdateData(task);
+ }
+ catch (Exception ex)
+ {
+ UpdateTaskExceptionMessage(taskNum, ex.Message);
+ }
}
/// <summary>
@@ -478,74 +630,295 @@
/// </summary>
/// <param name="taskNum">浠诲姟缂栧彿</param>
/// <returns>杩斿洖澶勭悊缁撴灉</returns>
- public WebResponseContent StackCraneTaskCompleted(int taskNum)
+ public WebResponseContent StackCraneTaskCompleted(int taskNum, float weight)
{
WebResponseContent content = new WebResponseContent();
try
{
- Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
- if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�");
-
- if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup && task.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting)
+ var nawtask = BaseDal.QueryFirst(v => v.TaskId == taskNum);
+ if (nawtask == null)
{
- List<Dt_Router> routers = _routerService.QueryNextRoutes(task.NextAddress, task.TargetAddress);
- if (!routers.Any()) return WebResponseContent.Instance.Error($"鏈壘鍒拌澶囪矾鐢变俊鎭�");
-
- int nextStatus = task.TaskState.GetNextNotCompletedStatus<TaskOutStatusEnum>();
- task.TaskState = nextStatus;
- task.CurrentAddress = task.NextAddress;
- task.NextAddress = routers.FirstOrDefault().ChildPosi;
- task.ModifyDate = DateTime.Now;
- task.Modifier = "System";
- BaseDal.UpdateData(task);
-
- _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄嚭搴撳畬鎴�");
- //todo 鍚屾鍒癢MS
-
- //鏆備笉鑰冭檻澶氫釜鍑哄簱鍙�
+ throw new Exception(string.Format("澶╄溅鏀捐揣瀹屾垚浠诲姟鏈煡璇㈠埌浠诲姟鍙穥0}", taskNum));
}
- else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup)
- {
- //todo
- int nextStatus = task.TaskState.GetNextNotCompletedStatus<TaskInStatusEnum>();
- task.TaskState = nextStatus;
- task.ModifyDate = DateTime.Now;
- task.Modifier = "System";
- BaseDal.UpdateData(task);
- _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄叆搴撳畬鎴�");
- WMSTaskDTO taskDTO = new WMSTaskDTO()
+ if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound || nawtask.TaskType == (int)TaskInboundTypeEnum.TiChuRuKu)
+ {
+ var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鍓旈櫎鏋�");
+ string sourceAddress = station.Row + "-" + station.Column + "-1";
+ if (nawtask.SourceAddress.Equals(sourceAddress))
{
- TaskNum = Convert.ToInt32(DateTime.Now.ToString("HHmmss")),
- Grade = 1,
- PalletCode = task.PalletCode + "S",
- RoadWay = "SC01",
- SourceAddress = task.TargetAddress,
- TargetAddress = "CLOutAreaA",
- TaskState = (int)TaskOutStatusEnum.OutNew,
- Id = 0,
- TaskType = (int)TaskOutboundTypeEnum.Outbound
- };
+ 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;
- content = ReceiveWMSTask(new List<WMSTaskDTO> { taskDTO });
- }
- else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.RelocationGroup)
- {
- //todo 璋冪敤WMS绉诲簱瀹屾垚
- }
- else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OtherGroup)
- {
+ //寮�濮嬫暟鎹簱浜嬪姟
+ _unitOfWorkManage.BeginTran();
+ _stockRepository.AddData(stock);
+ _locationRepository.UpdateData(location);
+ _taskhtyRepository.AddData(taskhty);
+ BaseDal.DeleteData(nawtask);
+ //鎻愪氦浜嬪姟
+ _unitOfWorkManage.CommitTran();
+ }
+ else
+ {
+ 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();
+ }
}
- else
+ else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound || nawtask.TaskType == (int)TaskOutboundTypeEnum.TiChuChuKu)
{
- throw new Exception($"浠诲姟绫诲瀷閿欒,鏈壘鍒拌浠诲姟绫诲瀷,浠诲姟鍙�:銆恵taskNum}銆�,浠诲姟绫诲瀷:銆恵task.TaskType}銆�");
+ 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;
+
+ //濡傛灉鏀捐揣浣嶇疆琛屾槸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 = "30-5-1";
+ Movstask.NextAddress = "text";
+ Movstask.Grade = 1;
+ Movstask.WMSId = 3;
+ Movstask.Remark = 0;
+ Movstask.PalletCode = "text";
+ Movstask.CurrentAddress = "text";
+
+ //寮�濮嬫暟鎹簱浜嬪姟
+ BaseDal.AddData(Movstask);
+ _unitOfWorkManage.BeginTran();
+ _stockRepository.DeleteData(stock);
+ _locationRepository.UpdateData(location);
+ _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 || nawtask.TaskType == (int)TaskOutboundTypeEnum.TiChuZhiJieChuKu)
+ {
+ //澶勭悊浠诲姟淇℃伅
+ 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;
+ if (nawtask.TaskType == (int)TaskOutboundTypeEnum.OutInventory || nawtask.TaskType == (int)TaskOutboundTypeEnum.TiChuZhiJieChuKu)
+ {
+ //寮�濮嬪垱寤轰换鍔�
+ 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);
+ _taskhtyRepository.AddData(taskhty);
+ BaseDal.DeleteData(nawtask);
+ //鎻愪氦浜嬪姟
+ _unitOfWorkManage.CommitTran();
+ }
+ else
+ {
+ //寮�濮嬫暟鎹簱浜嬪姟
+ _unitOfWorkManage.BeginTran();
+ _taskhtyRepository.AddData(taskhty);
+ BaseDal.DeleteData(nawtask);
+ //鎻愪氦浜嬪姟
+ _unitOfWorkManage.CommitTran();
+ }
}
content = WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
+ //鍥炴粴浜嬪姟
+ _unitOfWorkManage.RollbackTran();
content = WebResponseContent.Instance.Error($"浠诲姟瀹屾垚寮傚父,浠诲姟鍙�:銆恵taskNum}銆�");
+ UpdateTaskExceptionMessage(taskNum, ex.Message);
}
return content;
}
@@ -640,5 +1013,615 @@
}
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 || nawtask.TaskType == (int)TaskInboundTypeEnum.TiChuRuKu)
+ {
+ //鍓旈櫎鍏ュ簱
+ 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 = (int)MateTypeEnum.TiChu;
+ //淇敼璐т綅淇℃伅
+ 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
+ {
+ 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 || nawtask.TaskType == (int)TaskOutboundTypeEnum.TiChuChuKu)
+ {
+ //鍓旈櫎鍑哄簱
+ 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();
+ }
+ //姝ｅ父鍑哄簱
+ 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);
+ if (locationTow!=null)
+ {
+ 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);
+ _locationRepository.UpdateData(location);
+ if (locationTow != null)
+ {
+ _locationRepository.UpdateData(locationTow);
+ _stockRepository.DeleteData(Towstock);
+ }
+ _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);
+ Dt_StockInfo stockInfos = _stockRepository.QueryFirst(v => v.LocationCode == task.NextAddress);
+
+ if (locationtow != null)
+ {
+ locationtow.LocationStatus = (int)LocationStatusEnum.InStock;
+ stockInfos.StockStatus = (int)stockEnum.Free;
+ }
+ Dt_StockInfo stockInfo = _stockRepository.QueryFirst(v => v.LocationCode == task.SourceAddress);
+ stockInfo.StockStatus = (int)stockEnum.Free;
+
+ _unitOfWorkManage.BeginTran();
+ _locationRepository.UpdateData(location);
+ if (locationtow != null)
+ {
+ _locationRepository.UpdateData(locationtow);
+ _stockRepository.UpdateData(stockInfos);
+ }
+ _stockRepository.UpdateData(stockInfo);
+ 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 location = _locationRepository.QueryFirst(v => v.LocationCode == wei);
+ if (location.LocationType != (int)LocationTypeEnum.Flat)
+ {
+ return content.OK("5");
+ }
+ //鏌ヨ褰撳墠浠诲姟姹犱腑鏄惁瀛樺湪鍑哄簱浠诲姟锛屽嚭搴撲换鍔″彧鑳藉瓨鍦ㄤ竴鏉�
+ 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");
+ }
+
+ public WebResponseContent zhijiechuku()
+ {
+ Dt_Task task = new Dt_Task();
+ WebResponseContent content = new WebResponseContent();
+ var isout = _outStockRepository.QueryFirst(v => v.Id == 1);
+ if (isout.isout == 0)
+ {
+ var oldtask = _dt_taskRepositiry.QueryFirst(v => v.TaskType == (int)TaskOutboundTypeEnum.Outbound);
+ if (oldtask != null)
+ {
+ throw new Exception($"褰撳墠浠诲姟姹犱腑宸插瓨鍦ㄤ竴鏉″嚭搴撲换鍔�");
+ }
+ var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "瑗胯法鏋跺瓙");
+ task.TargetAddress = station.Row + "-" + station.Column + "-1";
+ var stations = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鍓旈櫎鏋�");
+ task.SourceAddress = stations.Row + "-" + stations.Column + "-1";
+ var oldhtytask = _dt_taskRepositiry.QueryFirst(v => v.SourceAddress == task.SourceAddress);
+ if (oldhtytask == null)
+ {
+ task.Grade = 3;
+ task.Remark = (int)MateTypeEnum.TiChu;
+ task.NextAddress = "text";
+ task.Roadway = "TC01";
+ task.TaskType = (int)TaskOutboundTypeEnum.TiChuZhiJieChuKu;
+ task.TaskState = (int)TaskOutStatusEnum.OutNew;
+ task.PalletCode = "text";
+ task.CurrentAddress = "text";
+ task.WMSId = 2;
+ _dt_taskRepositiry.AddData(task);
+ return content.OK("2");
+ }
+ }
+ else
+ {
+ return content.OK("1");
+ }
+ return content.OK("3");
+ }
+
+ public WebResponseContent tichuchuku(string wei)
+ {
+ Dt_Task task = new Dt_Task();
+ WebResponseContent content = new WebResponseContent();
+ //if (!OHTJob.oHTReadData.R_TCMode && !OHTJob.oHTReadData.R_TC_isready)
+ //{
+ // throw new Exception($"瑙勬暣鏈哄墧闄ゆ灦瀛愬彲鏀炬澘鎴栧墧闄や笂鏂欐ā寮忎俊鍙蜂负false");
+ //}
+ var oldtask = _dt_taskRepositiry.QueryFirst(v => v.TaskType == (int)TaskOutboundTypeEnum.Outbound);
+ var isout = _outStockRepository.QueryFirst(v => v.Id == 1);
+ if (isout.isout == 0)
+ {
+ var location = _locationRepository.QueryFirst(v => v.LocationCode == wei);
+ if(location.LocationType != (int)LocationTypeEnum.Cube)
+ {
+ return content.OK("5");
+ }
+ if (oldtask != null)
+ {
+ throw new Exception($"褰撳墠浠诲姟姹犱腑宸插瓨鍦ㄤ竴鏉″嚭搴撲换鍔�");
+ }
+ //鏌ヨ搴撳瓨
+ Dt_LocationInfo huo = _LocationInfoRepository.QueryFirst(v => v.LocationCode == wei);
+ if (huo.LocationStatus == 0)
+ {
+ return content.OK("4");
+ }
+ huo.LocationStatus = 1;
+ Dt_StockInfo stockinfo = _StockInfoRepository.QueryFirst(v => v.LocationCode == wei);
+ if (stockinfo==null)
+ {
+ return content.OK("4");
+ }
+ stockinfo.StockStatus = 1;
+ var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "瑗胯法鏋跺瓙");
+ task.TargetAddress = station.Row + "-" + station.Column + "-1";
+ var oldhtytask = _dt_taskRepositiry.QueryFirst(v => v.SourceAddress == task.SourceAddress);
+ if (oldhtytask == null)
+ {
+ task.SourceAddress = wei;
+ task.Grade = 3;
+ task.Remark = (int)MateTypeEnum.TiChu;
+ task.NextAddress = "text";
+ task.Roadway = "TC01";
+ task.TaskType = (int)TaskOutboundTypeEnum.TiChuChuKu;
+ task.TaskState = (int)TaskOutStatusEnum.OutNew;
+ task.PalletCode = "text";
+ task.CurrentAddress = "text";
+ task.WMSId = 2;
+ _unitOfWorkManage.BeginTran();
+ _dt_taskRepositiry.AddData(task);
+ _LocationInfoRepository.UpdateData(huo);
+ _StockInfoRepository.UpdateData(stockinfo);
+ _unitOfWorkManage.CommitTran();
+ return content.OK("2");
+ }
+ }
+ else
+ {
+ return content.OK("1");
+ }
+ return content.OK("3");
+ }
+
+ public WebResponseContent tichuruku(string wei)
+ {
+ Dt_Task task = new Dt_Task();
+ 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)
+ {
+ var location = _locationRepository.QueryFirst(v => v.LocationCode == wei);
+ if (location.LocationType != (int)LocationTypeEnum.Cube)
+ {
+ return content.OK("5");
+ }
+ //鍒ゆ柇搴撳瓨鏄惁鏈夎揣
+ //鏌ヨ璐т綅
+ Dt_LocationInfo huo = _LocationInfoRepository.QueryFirst(v => v.LocationCode == wei);
+ if (huo.LocationStatus!=0)
+ {
+ return content.OK("4");
+ }
+ huo.LocationStatus = 1;
+ var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鍓旈櫎鏋�");
+ task.SourceAddress = station.Row + "-" + station.Column + "-1";
+ var oldhtytask = _dt_taskRepositiry.QueryFirst(v => v.SourceAddress == task.SourceAddress);
+ if (oldhtytask == null)
+ {
+ task.TargetAddress = wei;
+ task.Grade = 3;
+ task.Remark = (int)MateTypeEnum.TiChu;
+ task.NextAddress = "text";
+ task.Roadway = "TC01";
+ task.TaskType = (int)TaskInboundTypeEnum.TiChuRuKu;
+ task.TaskState = (int)TaskInStatusEnum.InNew;
+ task.PalletCode = "text";
+ task.CurrentAddress = "text";
+ task.WMSId = 2;
+ _unitOfWorkManage.BeginTran();
+ _dt_taskRepositiry.AddData(task);
+ _LocationInfoRepository.UpdateData(huo);
+ _unitOfWorkManage.CommitTran();
+ return content.OK("2");
+ }
+ }
+ else
+ {
+ return content.OK("1");
+ }
+ return content.OK("3");
+ }
+
+ public WebResponseContent zxjruku(string wei,string weis)
+ {
+ Dt_Task task = new Dt_Task();
+ 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)
+ {
+ var location = _locationRepository.QueryFirst(v => v.LocationCode == wei);
+ if (location.LocationType != (int)LocationTypeEnum.Flat)
+ {
+ return content.OK("5");
+ }
+ //鍒ゆ柇搴撳瓨鏄惁鏈夎揣
+ //鏌ヨ璐т綅
+ Dt_LocationInfo huo = _LocationInfoRepository.QueryFirst(v => v.LocationCode == wei);
+ Dt_LocationInfo huos = _LocationInfoRepository.QueryFirst(v => v.LocationCode == weis);
+ if (huo.LocationStatus != 0)
+ {
+ return content.OK("4");
+ }
+ huo.LocationStatus = 1;
+ huos.LocationStatus = 1;
+ var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "鏁村舰鏈烘斁鏂欎綅");
+ task.SourceAddress = station.Row + "-" + station.Column + "-1";
+ var oldhtytask = _dt_taskRepositiry.QueryFirst(v => v.SourceAddress == task.SourceAddress);
+ if (oldhtytask == null)
+ {
+ task.TargetAddress = wei;
+ task.Grade = 3;
+ task.Remark = (int)MateTypeEnum.ZiChan;
+ task.NextAddress = weis;
+ task.Roadway = "TC01";
+ task.TaskType = (int)TaskInboundTypeEnum.Inbound;
+ task.TaskState = (int)TaskInStatusEnum.InNew;
+ task.PalletCode = "text";
+ task.CurrentAddress = "text";
+ task.WMSId = 2;
+ _unitOfWorkManage.BeginTran();
+ _dt_taskRepositiry.AddData(task);
+ _LocationInfoRepository.UpdateData(huo);
+ _LocationInfoRepository.UpdateData(huos);
+ _unitOfWorkManage.CommitTran();
+ return content.OK("2");
+ }
+ }
+ else
+ {
+ return content.OK("1");
+ }
+ return content.OK("3");
+ }
}
}
--
Gitblit v1.9.3