Files

534 lines
18 KiB
C#

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<TaskHeaderListVM>();
return PartialView(vm);
}
[ActionDescription("Sys.Search")]
[HttpPost]
public string Search(TaskHeaderSearcher searcher)
{
var vm = Wtm.CreateVM<TaskHeaderListVM>(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<TaskHeaderVM>();
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<TaskHeaderVM>(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<TaskHeaderVM>(id);
return PartialView(vm);
}
[ActionDescription("Sys.Delete")]
[HttpPost]
public ActionResult Delete(string id, IFormCollection nouse)
{
var vm = Wtm.CreateVM<TaskHeaderVM>(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<TaskHeaderVM>(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<TaskHeader>()
.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<TaskDetail>(x => x.HeaderId == task.ID))
{
return FFResult().CloseDialog().Alert("任务存在明细,不能使用此功能取消").RefreshGrid();
}
var inventories = _unitwork.Find<Inventory>(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<Container>(x => x.Code == task.ContainerCode);
var location = _unitwork.FindSingle<Location>(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();
}
}
}
/// <summary>
/// 取消成品库未下发的出库任务(含下发失败、始终未下发到 WCS 的任务)。
/// 只回滚 WMS 数据,不调用 WCS。返回 null 表示成功,否则返回提示信息。
/// </summary>
/// <param name="task">任务主表(已加行锁的快照)</param>
private string CancelPendingOutboundTask(TaskHeader task)
{
if (task.TaskType != TaskTypeEnum.出库)
{
return "成品库仅支持取消未下发的出库任务,入库任务请在 WCS 侧处理";
}
if (task.Status != TaskStatusEnum.待下发)
{
return "任务已下发 WCS,不能在此取消,请在 WCS 侧处理";
}
var taskDetails = _unitwork.Find<TaskDetail>(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<int>();
foreach (var shipmentDetailId in shipmentDetailIds)
{
var shipmentDetail = _unitwork.FindSingle<ShipmentDetail>(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;
}
/// <summary>
/// 释放任务占用的托盘资源:库存解锁、容器解锁、起始库位解锁(不改变库存数量)
/// </summary>
/// <param name="task">任务主表</param>
private void ReleaseTaskPallet(TaskHeader task)
{
var operatorCode = Wtm.LoginUserInfo?.ITCode ?? "WMS";
var now = DateTime.Now;
var inventories = _unitwork.Find<Inventory>(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<Container>(x => x.Code == task.ContainerCode);
if (container != null)
{
container.IsLock = ContainerLockEnum.未锁;
container.UpdateBy = operatorCode;
container.UpdateTime = now;
_unitwork.Update(container);
}
// 出库任务取消时托盘仍在原库位,只解除库位锁,不修改库位与托盘的绑定关系
var location = _unitwork.FindSingle<Location>(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<WCSTaskResponse>("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<TaskHeaderVM>(id);
return PartialView(vm);
}
#endregion Details
#region BatchEdit
[HttpPost]
[ActionDescription("Sys.BatchEdit")]
public ActionResult BatchEdit(string[] IDs)
{
var vm = Wtm.CreateVM<TaskHeaderBatchVM>(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<TaskHeaderBatchVM>(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<TaskHeaderImportVM>();
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
}
}