using HslCommunication; using MailKit.Search; using Microsoft.AspNetCore.Mvc; using Microsoft.Data.SqlClient; using Newtonsoft.Json; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using WIDESEA_Common; using WIDESEA_Common.LocationEnum; using WIDESEA_Common.OrderEnum; using WIDESEA_Common.StockEnum; using WIDESEA_Common.TaskEnum; using WIDESEA_Common.WareHouseEnum; using WIDESEA_Core; using WIDESEA_Core.BaseRepository; using WIDESEA_Core.BaseServices; using WIDESEA_Core.Enums; using WIDESEA_Core.Helper; using WIDESEA_DTO.SquareCabin; using WIDESEA_IBasicService; using WIDESEA_ISquareCabinServices; using WIDESEA_IWMsInfoServices; using WIDESEA_Model.Models; using static System.Net.WebRequestMethods; using static WIDESEA_DTO.SquareCabin.OrderDto; using static WIDESEA_DTO.SquareCabin.TowcsDto; namespace WIDESEA_SquareCabinServices { public partial class CabinOrderServices : ServiceBase>, ICabinOrderServices { private readonly IMedicineGoodsServices _medicineGoodsServices; private readonly IUnitOfWorkManage _unitOfWorkManage; private readonly IInventory_BatchServices _inventory_BatchServices; private readonly IInventoryInfoService _inventoryInfoService; private readonly ICabinOrderDetailServices _cabinOrderDetailServices; private readonly ISupplyTaskService _supplyTaskService; private readonly ISupplyTaskHtyService _supplyTaskHtyService; private readonly ILocationInfoService _locationInfoService; private readonly IMaterielInfoService _materielInfoService; private readonly IMessageInfoService _messageInfoService; public IRepository Repository => BaseDal; public CabinOrderServices(IRepository BaseDal, IMedicineGoodsServices medicineGoodsServices, IUnitOfWorkManage unitOfWorkManage, IInventory_BatchServices inventory_BatchServices, IInventoryInfoService inventoryInfoService, ICabinOrderDetailServices cabinOrderDetailServices, ICabinOrderHtyServices cabinOrderHtyServices, ICabinOrderDetailHtyServices cabinOrderDetailHtyServices, ISupplyTaskService supplyTaskService, ISupplyTaskHtyService supplyTaskHtyService, IMessageInfoService messageInfoService, IMaterielInfoService materielInfoService, ILocationInfoService locationInfoService) : base(BaseDal) { _medicineGoodsServices = medicineGoodsServices; _unitOfWorkManage = unitOfWorkManage; _inventory_BatchServices = inventory_BatchServices; _inventoryInfoService = inventoryInfoService; _cabinOrderDetailServices = cabinOrderDetailServices; _supplyTaskService = supplyTaskService; _supplyTaskHtyService = supplyTaskHtyService; _messageInfoService = messageInfoService; _materielInfoService = materielInfoService; _locationInfoService = locationInfoService; } /// /// pda查询入库单信息 /// /// /// public WebResponseContent GetCabinOrders(SaveModel saveModel) { WebResponseContent content = new WebResponseContent(); try { int pageNo = saveModel.MainData["pageNo"].ObjToInt(); string warehouseCode = saveModel.MainData["warehouseId"].ToString(); string orderNo = saveModel.MainData["orderNo"].ToString(); List dt_ReceiveOrders = new List(); if (string.IsNullOrEmpty(orderNo)) { dt_ReceiveOrders = Db.Queryable().Where(x => (x.OdrderStatus == "新建" || x.OdrderStatus == "开始") && x.Warehouse_no == warehouseCode).Includes(x => x.Details).OrderByDescending(x => x.CreateDate).ToPageList(pageNo, 5); } else { dt_ReceiveOrders = Db.Queryable().Where(x => (x.Order_no.Contains(orderNo) || x.Supplier_no.Contains(orderNo)) && (x.OdrderStatus == "新建" || x.OdrderStatus == "开始") && x.Warehouse_no == warehouseCode).OrderByDescending(x => x.CreateDate).Includes(x => x.Details).ToPageList(pageNo, 5); } content.OK(data: dt_ReceiveOrders); } catch (Exception) { throw; } return content; } /// /// pda查看入库详情表 /// /// /// /// public WebResponseContent GetCabinOrderDetail(int pageNo, string orderNo) { WebResponseContent content = new WebResponseContent(); Dt_CabinOrder cabinOrder = Db.Queryable().Includes(x => x.Details).First(x => x.Order_no == orderNo); List cabinOrderDetails = cabinOrder.Details.Where(x => x.Status == 2 && x.OrderDetailStatus != "已完成").ToList(); content.OK(data: cabinOrderDetails); return content; } /// /// Pad入库完成 /// /// /// public WebResponseContent FeedbackIn([FromBody] SaveModel saveModel) { WebResponseContent content = new WebResponseContent(); try { var LocationCode = saveModel.MainData["LocationCode"].ToString(); var orderNo = saveModel.MainData["orderNo"].ToString(); var batchNo = saveModel.MainData["batchNo"].ToString(); var id = saveModel.MainData["id"].ObjToInt(); var materielCode = saveModel.MainData["materielCode"].ToString(); var Inqty = saveModel.MainData["Inqty"].ObjToInt(); var warehouseCode = saveModel.MainData["warehouseCode"].ToString(); Dt_CabinOrder cabinOrder = BaseDal.Db.Queryable().Where(x => x.Order_no == orderNo && x.Warehouse_no == warehouseCode).Includes(x => x.Details).First(); if (cabinOrder == null || cabinOrder.OdrderStatus == "已完成") return WebResponseContent.Instance.Error($"入库单已完成"); //Dt_CabinOrderDetail cabinOrderDetail = cabinOrder.Details.Where(x => x.Goods_no == materielCode && x.Batch_num == batchNo && x.Status == 2).FirstOrDefault(); Dt_CabinOrderDetail cabinOrderDetail = cabinOrder.Details.Where(x => x.Id == id).FirstOrDefault(); if (cabinOrderDetail == null || cabinOrderDetail.OrderDetailStatus == "已完成") return WebResponseContent.Instance.Error($"入库单明细已完成"); Dt_MaterielInfo materielInfo = _materielInfoService.Repository.QueryFirst(x => x.MaterielCode == cabinOrderDetail.Goods_no); if (materielInfo == null) return WebResponseContent.Instance.Error($"请维护物料编号【{cabinOrderDetail.Goods_no}】的物料信息"); cabinOrderDetail.Order_Inqty += Inqty; if (cabinOrderDetail.Order_Inqty > cabinOrderDetail.Order_qty) return WebResponseContent.Instance.Error($"入库数量不可超出单据数量"); #region 处理入库单，货位，库存，库存批次信息 _unitOfWorkManage.BeginTran(); #region 入库单 cabinOrder.OdrderStatus = "开始"; cabinOrderDetail.OrderDetailStatus = "开始"; if (cabinOrderDetail.Order_Inqty == cabinOrderDetail.Order_qty) { cabinOrderDetail.OrderDetailStatus = "已完成"; } _cabinOrderDetailServices.Repository.UpdateData(cabinOrderDetail); var cabinOrder1 = BaseDal.Db.Queryable().Where(x => x.Order_no == cabinOrder.Order_no && x.Warehouse_no == warehouseCode).Includes(x => x.Details).First(); if (!cabinOrder1.Details.Where(x => x.OrderDetailStatus != "已完成").Any()) cabinOrder.OdrderStatus = "已完成"; Repository.UpdateData(cabinOrder); #endregion #region 货位 var location = _locationInfoService.Repository.QueryFirst(x => x.LocationCode == LocationCode); if (location == null) return WebResponseContent.Instance.Error($"请维护货位编号【{LocationCode}】的货位信息"); if (location.EnableStatus == EnableStatusEnum.Disable.ObjToInt()) return WebResponseContent.Instance.Error($"货位编号【{LocationCode}】已禁用，请恢复正常再使用"); if (location.WarehouseCode != cabinOrderDetail.Reservoirarea) return WebResponseContent.Instance.Error($"货位编号【{LocationCode}】所属库房与当前入库单所属库房不匹配"); if (location.LocationStatus == LocationStatusEnum.Free.ObjToInt()) { location.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); _locationInfoService.UpdateData(location); } #endregion #region 库存 Dt_InventoryInfo inventoryInfo = _inventoryInfoService.Repository.QueryFirst(x => x.BatchNo == cabinOrderDetail.Batch_num && x.MaterielCode == cabinOrderDetail.Goods_no && x.LocationCode == LocationCode); if (inventoryInfo != null) { inventoryInfo.StockQuantity += Inqty; inventoryInfo.AvailableQuantity += Inqty; inventoryInfo.InDate = DateTime.Now; _inventoryInfoService.UpdateData(inventoryInfo); } else { inventoryInfo = new Dt_InventoryInfo() { LocationCode = LocationCode, MaterielCode = materielInfo.MaterielCode, MaterielName = materielInfo.MaterielName, MaterielSpec = materielInfo.MaterielSpec, OutboundQuantity = 0, StockQuantity = Inqty, AvailableQuantity = Inqty, StockStatus = StockStatusEmun.入库完成.ObjToInt(), ValidityPeriod = cabinOrderDetail.Exp_date, WarehouseCode = cabinOrderDetail.Reservoirarea, SupplyQuantity = 0, InDate = DateTime.Now, BatchNo = cabinOrderDetail.Batch_num, Creater = App.User.UserName, CreateDate = DateTime.Now, }; switch (inventoryInfo.WarehouseCode) { case "001": inventoryInfo.Remark = "智能立库"; break; case "002": inventoryInfo.Remark = "大件库"; break; case "003": inventoryInfo.Remark = "麻精库"; break; case "010": inventoryInfo.Remark = "冷冻库"; break; } _inventoryInfoService.AddData(inventoryInfo); } #endregion #region 任务记录 #region MyRegion //Dt_SupplyTask supplyTask = new Dt_SupplyTask() //{ // WarehouseCode = cabinOrderDetail.Reservoirarea, // TaskNum = cabinOrderDetail.Id, // TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(), // BatchNo = inventoryInfo.BatchNo, // MaterielName = inventoryInfo.MaterielName, // MaterielCode = inventoryInfo.MaterielCode, // MaterielSpec = inventoryInfo.MaterielSpec, // TaskType = TaskTypeEnum.InPick.ObjToInt(), // CreateDate = DateTime.Now, // Creater = App.User.UserName, // LocationCode = location.LocationCode, // OrderNo = cabinOrder.Order_no, // StockQuantity = Inqty, // SupplyQuantity = 0, // Remark = "入库" //}; //_supplyTaskService.AddData(supplyTask); #endregion Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty() { WarehouseCode = cabinOrderDetail.Reservoirarea, TaskNum = cabinOrderDetail.Id, OperateType = OperateTypeEnum.人工完成.ToString(), InsertTime = DateTime.Now, TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(), BatchNo = inventoryInfo.BatchNo, MaterielName = inventoryInfo.MaterielName, MaterielCode = inventoryInfo.MaterielCode, MaterielSpec = inventoryInfo.MaterielSpec, TaskType = cabinOrder.Order_type == "1" ? TaskTypeEnum.In.ObjToInt() : TaskTypeEnum.OutReturn.ObjToInt(), CreateDate = DateTime.Now, Creater = App.User.UserName, LocationCode = location.LocationCode, OrderNo = cabinOrder.Order_no, StockQuantity = Inqty, SupplyQuantity = 0, Remark = "入库" }; _supplyTaskHtyService.AddData(supplyTask_Hty); #endregion #region 库存批次 Dt_Inventory_Batch inventory_Batch = _inventory_BatchServices.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo && x.MaterielCode == inventoryInfo.MaterielCode); if (inventory_Batch != null) { inventory_Batch.StockQuantity += Inqty; inventory_Batch.AvailableQuantity += Inqty; _inventory_BatchServices.UpdateData(inventory_Batch); } else { inventory_Batch = new Dt_Inventory_Batch() { BatchNo = inventoryInfo.BatchNo, CreateDate = inventoryInfo.CreateDate, Creater = inventoryInfo.Creater, MaterielCode = inventoryInfo.MaterielCode, ERPStockQuantity = 0, MaterielName = inventoryInfo.MaterielName, MaterielSpec = inventoryInfo.MaterielSpec, OutboundQuantity = inventoryInfo.OutboundQuantity, ProductionDate = inventoryInfo.ProductionDate, Status = false, StockQuantity = inventoryInfo.StockQuantity, AvailableQuantity = inventoryInfo.StockQuantity, ValidityPeriod = inventoryInfo.ValidityPeriod.ObjToDate(), SupplyQuantity = inventoryInfo.SupplyQuantity, }; _inventory_BatchServices.AddData(inventory_Batch); } #endregion _unitOfWorkManage.CommitTran(); #endregion content.OK(cabinOrderDetail.Order_Inqty.ToString()); } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); content.Error(ex.Message); } return content; } #region 创建入库单 /// /// 创建入库单,返回一个入库单集合到data /// public WebResponseContent CreateInboundOrder(UpstreamOrderInfo order) { WebResponseContent webResponseContent = new WebResponseContent(); try { string WareCodeMJ = WarehouseEnum.麻精库.ObjToInt().ToString("000"); string WareCodeLD = WarehouseEnum.冷冻库.ObjToInt().ToString("000"); List dt_CabinOrders = new List(); #region 特殊药品入特殊库房 if (order.warehouse_no == WareCodeMJ || order.warehouse_no == WareCodeLD) { var entityOrder = new Dt_CabinOrder { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "新建", Supplier_name = order.supplier_name, Warehouse_no = order.warehouse_no, Details = order.details.Select(d => new Dt_CabinOrderDetail { Reservoirarea = order.warehouse_no, Goods_no = d.goods_no, Order_qty = Math.Abs(d.order_qty), Batch_num = d.batch_num, Exp_date = d.exp_date, OrderDetailStatus = "新建", Status = 2, //如果是001房那么就是未同步状态，如果不是001房那么就是无需同步状态 }).ToList() }; dt_CabinOrders.Add(entityOrder); BaseDal.Db.InsertNav(dt_CabinOrders).Include(x => x.Details).ExecuteCommand(); //webResponseContent.OK(data: dt_CabinOrders); } #endregion else { #region 创建入库单头表、大件库和立库 var entityOrder = new Dt_CabinOrder//大件库订单 { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "新建", Supplier_name = order.supplier_name, Warehouse_no = WarehouseEnum.大件库.ObjToInt().ToString("000"), Details = new List() }; var entityOrderLK = new Dt_CabinOrder//立库订单 { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "新建", Supplier_name = order.supplier_name, Warehouse_no = WarehouseEnum.立库.ObjToInt().ToString("000"), Details = new List() }; #endregion List materielInfos = _materielInfoService.Repository.QueryData(x => order.details.Select(x => x.goods_no).Contains(x.MaterielCode)); List materielInfosUp = new List(); foreach (var item in order.details) { // 将上游入库数量转为正数 item.order_qty = Math.Abs(item.order_qty); #region 根据物料编码查询物料信息 Dt_MaterielInfo? materielInfo = materielInfos.Where(x => x.MaterielCode == item.goods_no).FirstOrDefault(); if (materielInfo == null) throw new Exception($"未找到药品编码【{item.goods_no}】的信息"); if (!Enum.IsDefined(typeof(MaterielSourceTypeEnum), materielInfo.MaterielSourceType)) throw new Exception($"请设置药品编号【{item.goods_no}】的属性分类"); #endregion #region 大件 if (materielInfo.MaterielSourceType == MaterielSourceTypeEnum.PurchasePart)//如果物料是大件 { Dt_CabinOrderDetail orderDetail = new Dt_CabinOrderDetail() { Reservoirarea = entityOrder.Warehouse_no, Goods_no = item.goods_no, Order_qty = item.order_qty, Batch_num = item.batch_num, Exp_date = item.exp_date, OrderDetailStatus = "新建", Status = 2 }; entityOrder.Details.Add(orderDetail); } #endregion else { if (materielInfo.BoxQty < 1) throw new Exception($"请设置药品编号【{item.goods_no}】的箱规数量"); if (materielInfo.MinQty < 1) throw new Exception($"请设置药品编号【{item.goods_no}】的立库最低库存数"); Dt_CabinOrderDetail orderDetail = null; var ys = item.order_qty % materielInfo.BoxQty; //不能整除箱规的散件数 var xs = (int)(item.order_qty / materielInfo.BoxQty);//保留整数 #region 判断是否有散件 if (ys > 0) { orderDetail = new Dt_CabinOrderDetail() { Reservoirarea = entityOrderLK.Warehouse_no, Goods_no = item.goods_no, Order_qty = ys, Batch_num = item.batch_num, Exp_date = item.exp_date, OrderDetailStatus = "新建", Status = 0 }; materielInfo.Business_qty += ys; } #endregion #region 判断立库库存是否大于立库最低库存数 while (materielInfo.Business_qty < materielInfo.MinQty && xs > 0) //当业务数量和整箱数都大于0的时候才会停止循环 { xs--; if (orderDetail == null) { orderDetail = new Dt_CabinOrderDetail() { Reservoirarea = entityOrderLK.Warehouse_no, Goods_no = item.goods_no, Order_qty = materielInfo.BoxQty, Batch_num = item.batch_num, Exp_date = item.exp_date, OrderDetailStatus = "新建", Status = 0 }; materielInfo.Business_qty += materielInfo.BoxQty; } else { orderDetail.Order_qty += materielInfo.BoxQty; materielInfo.Business_qty += materielInfo.BoxQty; } } if (orderDetail != null) entityOrderLK.Details.Add(orderDetail); #endregion #region 剩余整件入平库 if (xs > 0) { orderDetail = new Dt_CabinOrderDetail() { Reservoirarea = entityOrder.Warehouse_no, Goods_no = item.goods_no, Order_qty = materielInfo.BoxQty * xs, Batch_num = item.batch_num, Exp_date = item.exp_date, OrderDetailStatus = "新建", Status = 2 }; entityOrder.Details.Add(orderDetail); } #endregion materielInfosUp.Add(materielInfo); } //_materielInfoService.UpdateData(materielInfo); } _unitOfWorkManage.BeginTran(); if (materielInfosUp.Count > 0) _materielInfoService.UpdateData(materielInfosUp); if (entityOrder.Details.Count > 0) dt_CabinOrders.Add(entityOrder); if (entityOrderLK.Details.Count > 0) dt_CabinOrders.Add(entityOrderLK); if (dt_CabinOrders.Count > 0) BaseDal.Db.InsertNav(dt_CabinOrders).Include(x => x.Details).ExecuteCommand(); _unitOfWorkManage.CommitTran(); //webResponseContent.OK(data: dt_CabinOrders); } } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); webResponseContent.Error(ex.Message); } return webResponseContent; } #endregion #region 创建盘盈入库单 public WebResponseContent CreateCheckInOrder(UpstreamOrderInfo order) { WebResponseContent content = new WebResponseContent(); try { string WareCodeMJ = WarehouseEnum.麻精库.ObjToInt().ToString("000"); string WareCodeLD = WarehouseEnum.冷冻库.ObjToInt().ToString("000"); List supplyTask_Hties = new List(); List batchesUp = new List(); List infosUp = new List(); var codes = order.details.Select(x => x.goods_no).ToList(); #region 特殊库房 if (order.warehouse_no == WareCodeMJ || order.warehouse_no == WareCodeLD) { List inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => codes.Contains(x.MaterielCode)); List _InventoryInfos = _inventoryInfoService.Repository.QueryData(x => codes.Contains(x.MaterielCode)); #region 库存、库存批次平账 foreach (var item in order.details) { //找库存批次信息 Dt_Inventory_Batch inventory_Batch = inventory_Batchs.Where(x => x.MaterielCode == item.goods_no && x.BatchNo == item.batch_num).First(); var Qty = Math.Abs(inventory_Batch.StockQuantity - inventory_Batch.SupplyQuantity); if (Qty != item.order_qty) throw new Exception($"盘盈入库单【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的盘盈数量有误"); //找所有库存 List inventoryInfos = _InventoryInfos.Where(x => x.MaterielCode == inventory_Batch.MaterielCode && x.BatchNo == inventory_Batch.BatchNo).ToList(); foreach (var inventoryInfo in inventoryInfos) { #region 添加盘盈入库任务 if (inventoryInfo.StockQuantity != inventoryInfo.SupplyQuantity) { Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty() { WarehouseCode = inventoryInfo.WarehouseCode, OperateType = OperateTypeEnum.自动完成.ToString(), InsertTime = DateTime.Now, TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(), BatchNo = inventoryInfo.BatchNo, MaterielName = inventoryInfo.MaterielName, MaterielCode = inventoryInfo.MaterielCode, MaterielSpec = inventoryInfo.MaterielSpec, TaskType = TaskTypeEnum.ChenckIn.ObjToInt(), CreateDate = DateTime.Now, Creater = App.User.UserName, LocationCode = inventoryInfo.LocationCode, OrderNo = order.order_no, StockQuantity = Math.Abs(inventoryInfo.StockQuantity - inventoryInfo.SupplyQuantity), SupplyQuantity = 0, Remark = "盘盈入库" }; //_supplyTaskHtyService.AddData(supplyTask_Hty); supplyTask_Hties.Add(supplyTask_Hty); } #endregion inventoryInfo.StockQuantity = inventoryInfo.SupplyQuantity; inventoryInfo.SupplyQuantity = 0; inventoryInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); } infosUp.AddRange(inventoryInfos); inventory_Batch.StockQuantity = inventory_Batch.SupplyQuantity; inventory_Batch.SupplyQuantity = 0; batchesUp.Add(inventory_Batch); //_inventoryInfoService.UpdateData(inventoryInfos); //_inventory_BatchServices.UpdateData(inventory_Batch); } #endregion #region 创建盘点单 var entityOrder = new Dt_CabinOrder { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "已完成", Supplier_name = order.supplier_name, Warehouse_no = order.warehouse_no, Details = order.details.Select(d => new Dt_CabinOrderDetail { Goods_no = d.goods_no, Order_qty = Math.Abs(d.order_qty), Order_Inqty = Math.Abs(d.order_qty), Batch_num = d.batch_num, Exp_date = d.exp_date, Reservoirarea = order.warehouse_no, OrderDetailStatus = "已完成", Status = 2, }).ToList() }; _unitOfWorkManage.BeginTran(); _supplyTaskHtyService.AddData(supplyTask_Hties); _inventoryInfoService.UpdateData(infosUp); _inventory_BatchServices.UpdateData(batchesUp); BaseDal.Db.InsertNav(entityOrder).Include(it => it.Details).ExecuteCommand(); _unitOfWorkManage.CommitTran(); //Repository.AddData(entityOrder); #endregion } #endregion else { List cabinOrdersAdd = new List(); string WareCodeLK = WarehouseEnum.立库.ObjToInt().ToString("000"); string WareCodeDJ = WarehouseEnum.大件库.ObjToInt().ToString("000"); List inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => codes.Contains(x.MaterielCode)); List _InventoryInfos = _inventoryInfoService.Repository.QueryData(x => codes.Contains(x.MaterielCode)); foreach (var item in order.details) { //找库存批次信息 Dt_Inventory_Batch inventory_Batch = inventory_Batchs.Where(x => x.MaterielCode == item.goods_no && x.BatchNo == item.batch_num).First(); var Qty = Math.Abs(inventory_Batch.StockQuantity - inventory_Batch.SupplyQuantity); if (Qty != item.order_qty) throw new Exception($"盘盈入库单【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的盘盈数量有误"); //找所有库存 List inventoryInfos = _InventoryInfos.Where(x => x.MaterielCode == inventory_Batch.MaterielCode && x.BatchNo == inventory_Batch.BatchNo).ToList(); //获取立库盘点差异数 var inventoryLK = inventoryInfos.Where(x => x.WarehouseCode == WareCodeLK).First(); var LkQty = Math.Abs(inventoryLK.StockQuantity - inventoryLK.SupplyQuantity); //获取大件库盘点差异数 var inventoryDJ = inventoryInfos.Where(x => x.WarehouseCode == WareCodeDJ).ToList(); var DJQty = Math.Abs(inventoryDJ.Sum(x => x.StockQuantity) - inventoryDJ.Sum(x => x.SupplyQuantity)); if (LkQty + DJQty != Qty) throw new Exception($"【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的物料信息与物料批次信息盘盈数量不符"); if (LkQty == 0)//立库无差异 { #region 库存、库存批次平账 foreach (var inventoryInfo in inventoryInfos) { #region 添加盘盈入库任务 if (inventoryInfo.StockQuantity != inventoryInfo.SupplyQuantity) { Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty() { WarehouseCode = inventoryInfo.WarehouseCode, OperateType = OperateTypeEnum.自动完成.ToString(), InsertTime = DateTime.Now, TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(), BatchNo = inventoryInfo.BatchNo, MaterielName = inventoryInfo.MaterielName, MaterielCode = inventoryInfo.MaterielCode, MaterielSpec = inventoryInfo.MaterielSpec, TaskType = TaskTypeEnum.ChenckIn.ObjToInt(), CreateDate = DateTime.Now, Creater = App.User.UserName, LocationCode = inventoryInfo.LocationCode, OrderNo = order.order_no, StockQuantity = Math.Abs(inventoryInfo.StockQuantity - inventoryInfo.SupplyQuantity), SupplyQuantity = 0, Remark = "盘盈入库" }; //_supplyTaskHtyService.AddData(supplyTask_Hty); supplyTask_Hties.Add(supplyTask_Hty); } #endregion inventoryInfo.StockQuantity = inventoryInfo.SupplyQuantity; inventoryInfo.SupplyQuantity = 0; inventoryInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); } //_inventoryInfoService.UpdateData(inventoryInfos); infosUp.AddRange(inventoryInfos); inventory_Batch.StockQuantity = inventory_Batch.SupplyQuantity; inventory_Batch.SupplyQuantity = 0; //_inventory_BatchServices.UpdateData(inventory_Batch); batchesUp.Add(inventory_Batch); #endregion #region 创建大件库盘点单 var entityOrder = new Dt_CabinOrder { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "已完成", Supplier_name = order.supplier_name, Warehouse_no = WareCodeDJ, Details = order.details.Select(d => new Dt_CabinOrderDetail { Goods_no = d.goods_no, Order_qty = Math.Abs(d.order_qty), Order_Inqty = Math.Abs(d.order_qty), Batch_num = d.batch_num, Exp_date = d.exp_date, Reservoirarea = WareCodeDJ, OrderDetailStatus = "已完成", Status = 2, }).ToList() }; //Repository.AddData(entityOrder); //Db.InsertNav(entityOrder).Include(it => it.Details).ExecuteCommand(); cabinOrdersAdd.Add(entityOrder); #endregion } else { #region 大件库库存平账 inventoryInfos = inventoryInfos.Where(x => x.WarehouseCode == WareCodeDJ).ToList(); foreach (var inventoryInfo in inventoryInfos) { #region 添加盘盈入库任务 if (inventoryInfo.StockQuantity != inventoryInfo.SupplyQuantity) { Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty() { WarehouseCode = inventoryInfo.WarehouseCode, OperateType = OperateTypeEnum.自动完成.ToString(), InsertTime = DateTime.Now, TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(), BatchNo = inventoryInfo.BatchNo, MaterielName = inventoryInfo.MaterielName, MaterielCode = inventoryInfo.MaterielCode, MaterielSpec = inventoryInfo.MaterielSpec, TaskType = TaskTypeEnum.ChenckIn.ObjToInt(), CreateDate = DateTime.Now, Creater = App.User.UserName, LocationCode = inventoryInfo.LocationCode, OrderNo = order.order_no, StockQuantity = Math.Abs(inventoryInfo.StockQuantity - inventoryInfo.SupplyQuantity), SupplyQuantity = 0, Remark = "盘盈入库" }; //_supplyTaskHtyService.AddData(supplyTask_Hty); supplyTask_Hties.Add(supplyTask_Hty); } #endregion inventoryInfo.StockQuantity = inventoryInfo.SupplyQuantity; inventoryInfo.SupplyQuantity = 0; inventoryInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); } //_inventoryInfoService.UpdateData(inventoryInfos); infosUp.AddRange(inventoryInfos); #endregion #region 创建大件库盘点单 if (DJQty != 0) { var cabinOrder = new Dt_CabinOrder { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "已完成", Supplier_name = order.supplier_name, Warehouse_no = WareCodeDJ, Details = order.details.Select(d => new Dt_CabinOrderDetail { Goods_no = d.goods_no, Order_qty = DJQty, Order_Inqty = DJQty, Batch_num = d.batch_num, Exp_date = d.exp_date, Reservoirarea = WareCodeDJ, OrderDetailStatus = "已完成", Status = 2, }).ToList() }; //Repository.AddData(cabinOrder); //Db.InsertNav(cabinOrder).Include(it => it.Details).ExecuteCommand(); cabinOrdersAdd.Add(cabinOrder); } #endregion #region 创建立库盘点单 var entityOrder = new Dt_CabinOrder { Order_no = order.order_no, Order_type = order.order_type, Supplier_no = order.supplier_no, Account_tiem = order.account_time, OdrderStatus = "新建", Supplier_name = order.supplier_name, Warehouse_no = WareCodeLK, Details = order.details.Select(d => new Dt_CabinOrderDetail { Goods_no = d.goods_no, Order_qty = LkQty, Batch_num = d.batch_num, Exp_date = d.exp_date, Reservoirarea = WareCodeLK, OrderDetailStatus = "新建", Status = 0, }).ToList() }; //Repository.AddData(entityOrder); //Db.InsertNav(entityOrder).Include(it => it.Details).ExecuteCommand(); cabinOrdersAdd.Add(entityOrder); #endregion } } _unitOfWorkManage.BeginTran(); _supplyTaskHtyService.AddData(supplyTask_Hties); _inventoryInfoService.UpdateData(infosUp); _inventory_BatchServices.UpdateData(batchesUp); BaseDal.Db.InsertNav(cabinOrdersAdd).Include(it => it.Details).ExecuteCommand(); _unitOfWorkManage.CommitTran(); } } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); //_messageInfoService.AddMessageInfo(MessageGroupByEnum.InOrderAlarm, "创建盘盈入库单", ex.Message); content.Error(ex.Message); } return content; } #endregion /// /// 人工入库完成 /// /// /// public WebResponseContent FinishInOrder(int key) { WebResponseContent content = new WebResponseContent(); try { Dt_CabinOrder cabinOrder = BaseDal.QueryFirst(x => x.Id == key); List cabinOrders = Db.Queryable().Where(x => x.Order_no == cabinOrder.Order_no).Includes(x => x.Details).ToList();//找出所有出库单号相同的出库单 List cabinOrderDetails = new List(); foreach (var item in cabinOrders) { if (item.Details != null) cabinOrderDetails.AddRange(cabinOrderDetails); item.Modifier = App.User.UserName; item.ModifyDate = DateTime.Now; item.Details = null; } if (cabinOrder.Order_type == InOrderTypeEnum.Allocat.ObjToInt().ToString()) { _cabinOrderDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrderDetails, OperateTypeEnum.人工完成); BaseDal.DeleteAndMoveIntoHty(cabinOrders, OperateTypeEnum.人工完成); } else { var url = "http://121.37.118.63:80/GYZ2/95fck/outOrderOk"; var requestDate = new { order_no = cabinOrder.Order_no }; var result = HttpHelper.Post(url, requestDate.ToJsonString()); var response = JsonConvert.DeserializeObject(result); if (response == null) throw new Exception("上报ERP入库单完成失败！"); if (response.resultCode != "0") throw new Exception(response.resultMsg); _cabinOrderDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrderDetails, OperateTypeEnum.人工完成); BaseDal.DeleteAndMoveIntoHty(cabinOrders, OperateTypeEnum.人工完成); } content.OK(); } catch (Exception ex) { content.Error(ex.Message); } return content; } } }