using System; using System.Collections.Generic; using System.Linq; using System.Security.Cryptography; using HHWMS.Web.Models; using HHWMS.Web.Support; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Microsoft.EntityFrameworkCore; using WalkingTec.Mvvm.Core; using WalkingTec.Mvvm.Core.Extensions; using WalkingTec.Mvvm.Mvc; namespace HHWMS.Web.Controllers { [Area("taskManage")] [ActionDescription("任务主表")] public partial class TaskHeaderController : BaseController { private readonly IUnitWork _unitwork; public TaskHeaderController(IUnitWork unitwork) { _unitwork = unitwork; } #region Search [ActionDescription("Sys.Search")] public ActionResult Index() { var vm = Wtm.CreateVM(); return PartialView(vm); } [ActionDescription("Sys.Search")] [HttpPost] public string Search(TaskHeaderSearcher searcher) { var vm = Wtm.CreateVM(passInit: true); if (ModelState.IsValid) { vm.Searcher = searcher; return vm.GetJson(false); } else { return vm.GetError(); } } #endregion Search #region Create [ActionDescription("Sys.Create")] public ActionResult Create() { var vm = Wtm.CreateVM(); return PartialView(vm); } [HttpPost] [ActionDescription("Sys.Create")] public ActionResult Create(TaskHeaderVM vm) { if (!ModelState.IsValid) { return PartialView(vm); } else { vm.DoAdd(); if (!ModelState.IsValid) { vm.DoReInit(); return PartialView(vm); } else { return FFResult().CloseDialog().RefreshGrid(); } } } #endregion Create #region Edit [ActionDescription("Sys.Edit")] public ActionResult Edit(string id) { var vm = Wtm.CreateVM(id); return PartialView(vm); } [ActionDescription("Sys.Edit")] [HttpPost] [ValidateFormItemOnly] public ActionResult Edit(TaskHeaderVM vm) { if (!ModelState.IsValid) { return PartialView(vm); } else { vm.DoEdit(); if (!ModelState.IsValid) { vm.DoReInit(); return PartialView(vm); } else { return FFResult().CloseDialog().RefreshGridRow(vm.Entity.ID); } } } #endregion Edit #region Delete [ActionDescription("Sys.Delete")] public ActionResult Delete(string id) { var vm = Wtm.CreateVM(id); return PartialView(vm); } [ActionDescription("Sys.Delete")] [HttpPost] public ActionResult Delete(string id, IFormCollection nouse) { var vm = Wtm.CreateVM(id); vm.DoDelete(); if (!ModelState.IsValid) { return PartialView(vm); } else { return FFResult().CloseDialog().RefreshGrid(); } } #endregion Delete #region Cancel [ActionDescription("TaskHeader.Cancel")] public ActionResult Cancel(string id) { var vm = Wtm.CreateVM(id); return PartialView(vm); } [HttpPost] [ActionDescription("TaskHeader.Cancel")] public ActionResult Cancel(string id, IFormCollection nouse) { if (!int.TryParse(id, out var taskId)) { return FFResult().CloseDialog().Alert("任务参数错误").RefreshGrid(); } using (var transaction = DC.BeginTransaction()) { try { var task = DC.Set() .FromSqlRaw("SELECT * FROM `TaskHeader` WHERE `ID` = {0} FOR UPDATE", taskId) .AsNoTracking() .SingleOrDefault(); if (task == null) { return FFResult().CloseDialog().Alert("任务不存在或已被处理").RefreshGrid(); } // 非线边库(成品库等)走"未下发出库任务取消",只回滚 WMS 数据,不调用 WCS if (task.ZoneId != 1027) { var outboundError = CancelPendingOutboundTask(task); if (outboundError != null) { return FFResult().CloseDialog().Alert(outboundError).RefreshGrid(); } transaction.Commit(); return FFResult().CloseDialog().Alert("任务取消成功").RefreshGrid(); } // 线边库仅允许取消入库任务,其余逻辑保持不变 if (task.RoadWay != 1 || task.TaskType != TaskTypeEnum.入库) { return FFResult().CloseDialog().Alert("仅允许取消线边库入库任务").RefreshGrid(); } if (task.Status != TaskStatusEnum.新建 && task.Status != TaskStatusEnum.待下发 && task.Status != TaskStatusEnum.已下发) { return FFResult().CloseDialog().Alert("当前任务状态不允许取消").RefreshGrid(); } if (_unitwork.IsExit(x => x.HeaderId == task.ID)) { return FFResult().CloseDialog().Alert("任务存在明细,不能使用此功能取消").RefreshGrid(); } var inventories = _unitwork.Find(x => x.ContainerCode == task.ContainerCode) .ToList(); if (inventories.Any(x => x.ZoneId != task.ZoneId || !SameCode(x.LocationCode, task.ToLocation) || x.TaskStatus != InventoryTaskStatusEnum.Locked || (x.Qty ?? 0) != 0)) { return FFResult().CloseDialog() .Alert("托盘存在非零库存或库存状态不一致,不能取消") .RefreshGrid(); } var container = _unitwork.FindSingle(x => x.Code == task.ContainerCode); var location = _unitwork.FindSingle(x => x.Code == task.ToLocation); var hasInventory = inventories.Any(); if (container == null || location == null || container.IsLock != ContainerLockEnum.任务锁 || container.Status != (hasInventory ? ContainerStatus.有 : ContainerStatus.空) || !SameCode(container.LocationCode, task.ToLocation) || location.Status != LocationStatusEnum.锁定 || location.ContainerStatus != (hasInventory ? LocationStatus.有货 : LocationStatus.空仓位) || !SameCode(location.ContainerCode, task.ContainerCode)) { return FFResult().CloseDialog() .Alert("托盘或库位状态与任务不一致,请先排查") .RefreshGrid(); } if (task.Status == TaskStatusEnum.已下发 && !TryCancelWcsTask(task, out var wcsError)) { return FFResult().CloseDialog().Alert(wcsError).RefreshGrid(); } var operatorCode = Wtm.LoginUserInfo?.ITCode ?? "WMS"; var now = DateTime.Now; if (inventories.Any()) { _unitwork.BatchDelete(inventories); } container.LocationCode = string.Empty; container.IsLock = ContainerLockEnum.未锁; container.Status = hasInventory ? ContainerStatus.有 : ContainerStatus.空; container.UpdateBy = operatorCode; container.UpdateTime = now; _unitwork.Update(container); location.ContainerCode = string.Empty; location.Status = LocationStatusEnum.未锁; location.ContainerStatus = LocationStatus.空仓位; location.Version = Guid.NewGuid(); location.UpdateBy = operatorCode; location.UpdateTime = now; _unitwork.Update(location); _unitwork.Delete(task); transaction.Commit(); Wtm.DoLog("取消线边库入库任务", ActionLogTypesEnum.Normal, "CancelInboundTask", request: task.TaskNo, result: $"取消成功,清理库存{inventories.Count}条"); return FFResult().CloseDialog().Alert("任务取消成功").RefreshGrid(); } catch (Exception ex) { transaction.Rollback(); return FFResult().CloseDialog() .Alert(ex.InnerException?.Message ?? ex.Message) .RefreshGrid(); } } } /// /// 取消成品库未下发的出库任务(含下发失败、始终未下发到 WCS 的任务)。 /// 只回滚 WMS 数据,不调用 WCS。返回 null 表示成功,否则返回提示信息。 /// /// 任务主表(已加行锁的快照) private string CancelPendingOutboundTask(TaskHeader task) { if (task.TaskType != TaskTypeEnum.出库) { return "成品库仅支持取消未下发的出库任务,入库任务请在 WCS 侧处理"; } if (task.Status != TaskStatusEnum.待下发) { return "任务已下发 WCS,不能在此取消,请在 WCS 侧处理"; } var taskDetails = _unitwork.Find(x => x.HeaderId == task.ID).ToList(); var shipmentDetailIds = taskDetails .Where(x => x.OrderDetailId.HasValue) .Select(x => x.OrderDetailId.Value) .Distinct() .ToList(); // 1. 先删任务明细,避免后面重算已分配数量时仍把它们统计进去 if (taskDetails.Any()) { _unitwork.BatchDelete(taskDetails); } // 2. 释放托盘:库存解锁、容器解锁、起始库位解锁(库存数量不变) ReleaseTaskPallet(task); // 3. 删除任务主表 _unitwork.Delete(task); // 4. 回退出库单已分配数量与单据状态 var operatorCode = Wtm.LoginUserInfo?.ITCode ?? "WMS"; var shipmentHeaderIds = new List(); foreach (var shipmentDetailId in shipmentDetailIds) { var shipmentDetail = _unitwork.FindSingle(x => x.ID == shipmentDetailId); if (shipmentDetail == null) { continue; } ShipmentStatusCalculator.RecalculateDetail(_unitwork, shipmentDetail, operatorCode); if (!shipmentHeaderIds.Contains(shipmentDetail.HeaderId)) { shipmentHeaderIds.Add(shipmentDetail.HeaderId); } } foreach (var shipmentHeaderId in shipmentHeaderIds) { ShipmentStatusCalculator.RecalculateHeader(_unitwork, shipmentHeaderId, operatorCode); } Wtm.DoLog("取消成品库未下发出库任务", ActionLogTypesEnum.Normal, "CancelPendingOutboundTask", request: task.TaskNo, result: $"取消成功,清理任务明细{taskDetails.Count}条,回退出库明细{shipmentDetailIds.Count}条"); return null; } /// /// 释放任务占用的托盘资源:库存解锁、容器解锁、起始库位解锁(不改变库存数量) /// /// 任务主表 private void ReleaseTaskPallet(TaskHeader task) { var operatorCode = Wtm.LoginUserInfo?.ITCode ?? "WMS"; var now = DateTime.Now; var inventories = _unitwork.Find(x => x.ContainerCode == task.ContainerCode).ToList(); foreach (var inventory in inventories) { inventory.TaskStatus = InventoryTaskStatusEnum.Idle; inventory.UpdateBy = operatorCode; inventory.UpdateTime = now; } if (inventories.Any()) { _unitwork.BatchUpdate(inventories); } var container = _unitwork.FindSingle(x => x.Code == task.ContainerCode); if (container != null) { container.IsLock = ContainerLockEnum.未锁; container.UpdateBy = operatorCode; container.UpdateTime = now; _unitwork.Update(container); } // 出库任务取消时托盘仍在原库位,只解除库位锁,不修改库位与托盘的绑定关系 var location = _unitwork.FindSingle(x => x.Code == task.FromLocation); if (location != null && location.Status == LocationStatusEnum.锁定) { location.Status = LocationStatusEnum.未锁; location.UpdateBy = operatorCode; location.UpdateTime = now; _unitwork.Update(location); } } private static bool SameCode(string left, string right) { return string.Equals(left, right, StringComparison.OrdinalIgnoreCase); } private bool TryCancelWcsTask(TaskHeader task, out string errorMessage) { try { var request = new { TaskNo = task.TaskNo }; var wcsResult = Wtm.CallAPI("WCSXB", "TaskCancel", HttpMethodEnum.POST, request).Result.Data; if (wcsResult == null) { errorMessage = "WCS取消任务无响应,WMS未清理数据"; return false; } if (!wcsResult.Success) { errorMessage = $"WCS取消任务失败:{wcsResult.Msg}"; return false; } errorMessage = null; return true; } catch (Exception ex) { errorMessage = $"调用WCS取消任务接口异常:{ex.InnerException?.Message ?? ex.Message}"; return false; } } #endregion Cancel #region Details [ActionDescription("Sys.Details")] public ActionResult Details(string id) { var vm = Wtm.CreateVM(id); return PartialView(vm); } #endregion Details #region BatchEdit [HttpPost] [ActionDescription("Sys.BatchEdit")] public ActionResult BatchEdit(string[] IDs) { var vm = Wtm.CreateVM(Ids: IDs); return PartialView(vm); } [HttpPost] [ActionDescription("Sys.BatchEdit")] public ActionResult DoBatchEdit(TaskHeaderBatchVM vm, IFormCollection nouse) { if (!ModelState.IsValid || !vm.DoBatchEdit()) { return PartialView("BatchEdit", vm); } else { return FFResult().CloseDialog().RefreshGrid().Alert(Localizer["Sys.BatchEditSuccess", vm.Ids.Length]); } } #endregion BatchEdit #region BatchDelete [HttpPost] [ActionDescription("Sys.BatchDelete")] public ActionResult BatchDelete(string[] IDs) { var vm = Wtm.CreateVM(Ids: IDs); return PartialView(vm); } [HttpPost] [ActionDescription("Sys.BatchDelete")] public ActionResult DoBatchDelete(TaskHeaderBatchVM vm, IFormCollection nouse) { if (!ModelState.IsValid || !vm.DoBatchDelete()) { return PartialView("BatchDelete", vm); } else { return FFResult().CloseDialog().RefreshGrid().Alert(Localizer["Sys.BatchDeleteSuccess", vm.Ids.Length]); } } #endregion BatchDelete #region Import [ActionDescription("Sys.Import")] public ActionResult Import() { var vm = Wtm.CreateVM(); return PartialView(vm); } [HttpPost] [ActionDescription("Sys.Import")] public ActionResult Import(TaskHeaderImportVM vm, IFormCollection nouse) { if (vm.ErrorListVM.EntityList.Count > 0 || !vm.BatchSaveData()) { return PartialView(vm); } else { return FFResult().CloseDialog().RefreshGrid().Alert(Localizer["Sys.ImportSuccess", vm.EntityList.Count.ToString()]); } } #endregion Import #region Export [ActionDescription("Sys.Export")] [HttpPost] public IActionResult ExportExcel(TaskHeaderListVM vm) { return vm.GetExportData(); } #endregion Export } }