using HslCommunication;
|
using MailKit.Search;
|
using Microsoft.Data.SqlClient;
|
using Microsoft.IdentityModel.Tokens;
|
using Newtonsoft.Json;
|
using OfficeOpenXml.Style;
|
using Org.BouncyCastle.Asn1.X509;
|
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.Outbound;
|
using WIDESEA_DTO.SquareCabin;
|
using WIDESEA_IBasicService;
|
using WIDESEA_ISquareCabinServices;
|
using WIDESEA_IWMsInfoServices;
|
using WIDESEA_Model.Models;
|
using static WIDESEA_DTO.SquareCabin.OrderDto;
|
|
|
|
namespace WIDESEA_SquareCabinServices
|
{
|
public partial class DeliveryOrderServices : ServiceBase<Dt_DeliveryOrder, IRepository<Dt_DeliveryOrder>>, IDeliveryOrderServices
|
{
|
private readonly ICabinOrderServices _cabinOrderServices;
|
private readonly IUnitOfWorkManage _unitOfWorkManage;
|
private readonly IInventory_BatchServices _inventory_BatchServices;
|
private readonly ILocationInfoService _locationInfoService;
|
private readonly IInventoryInfoService _inventoryInfoService;
|
private readonly IDeliveryOrderDetailServices _deliveryOrderDetailServices;
|
private readonly ISupplyTaskService _supplyTaskService;
|
private readonly ISupplyTaskHtyService _supplyTaskHtyService;
|
private readonly ITacticsService _tacticsService;
|
private readonly IMaterielInfoService _materielInfoService;
|
private readonly IMessageInfoService _messageInfoService;
|
public IRepository<Dt_DeliveryOrder> Repository => BaseDal;
|
public DeliveryOrderServices(IRepository<Dt_DeliveryOrder> BaseDal, IUnitOfWorkManage unitOfWorkManage, IInventory_BatchServices inventory_BatchServices, IInventoryInfoService inventoryInfoService, IDeliveryOrderDetailServices deliveryOrderDetailServices, ISupplyTaskService supplyTaskService, ICabinOrderServices cabinOrderServices, ITacticsService tacticsService, ISupplyTaskHtyService supplyTaskHtyService, IMessageInfoService messageInfoService, IMaterielInfoService materielInfoService, ILocationInfoService locationInfoService) : base(BaseDal)
|
{
|
_unitOfWorkManage = unitOfWorkManage;
|
_deliveryOrderDetailServices = deliveryOrderDetailServices;
|
_supplyTaskService = supplyTaskService;
|
_inventory_BatchServices = inventory_BatchServices;
|
_inventoryInfoService = inventoryInfoService;
|
_cabinOrderServices = cabinOrderServices;
|
_tacticsService = tacticsService;
|
_supplyTaskHtyService = supplyTaskHtyService;
|
_messageInfoService = messageInfoService;
|
_materielInfoService = materielInfoService;
|
_locationInfoService = locationInfoService;
|
}
|
public override WebResponseContent UpdateData(SaveModel saveModel)
|
{
|
try
|
{
|
int id = saveModel.MainData["id"].ObjToInt();
|
var warehouse_no = saveModel.MainData["warehouse_no"].ToString();
|
var out_no = saveModel.MainData["out_no"].ToString();
|
//OutboundOrderAddDTO outboundOrder = saveModel.MainData.DicToModel<OutboundOrderAddDTO>();
|
//Dt_DeliveryOrder deliveryOrder = BaseDal.QueryFirst(x => x.Id == id);
|
List<DeliveryOrderDetailAddDTO> orderDetailAddDTOs = saveModel.DetailData.DicToIEnumerable<DeliveryOrderDetailAddDTO>();
|
orderDetailAddDTOs = orderDetailAddDTOs.Where(x => x.id == 0).ToList();
|
if (orderDetailAddDTOs.Count < 1) return WebResponseContent.Instance.OK();
|
if (orderDetailAddDTOs.Where(x => string.IsNullOrEmpty(x.locationCode)).Any()) return WebResponseContent.Instance.Error("货位号为必填字段!");
|
if (orderDetailAddDTOs.Where(x => string.IsNullOrEmpty(x.exp_date)).Any()) return WebResponseContent.Instance.Error("效期为必填字段!");
|
var LocationCodes = orderDetailAddDTOs.Select(x => x.locationCode);
|
List<Dt_LocationInfo> locationInfos = _locationInfoService.Repository.QueryData(x => x.WarehouseCode == warehouse_no && LocationCodes.Contains(x.LocationCode));
|
var diff = LocationCodes.Except(locationInfos.Select(x => x.LocationCode)).ToArray();
|
if (diff.Length > 0) return WebResponseContent.Instance.Error($"货位编号【{string.Join(", ", diff)}】不属于当前库房");
|
var array1 = orderDetailAddDTOs.Select(x => x.goods_no);
|
var MaterielInfos = _materielInfoService.Repository.QueryData(x => array1.Contains(x.MaterielCode));
|
var array2 = MaterielInfos.Select(x => x.MaterielCode);
|
diff = array1.Except(array2).ToArray();
|
if (diff.Length > 0) return WebResponseContent.Instance.Error($"请维护物料编号【{string.Join(", ", diff)}】的物料信息");
|
if (warehouse_no == WarehouseEnum.立库.ObjToInt().ToString("000"))
|
{
|
var MaterielInfos1 = MaterielInfos.Where(x => x.MaterielSourceType == MaterielSourceTypeEnum.PurchasePart).ToList();
|
if (MaterielInfos1.Count > 0)
|
{
|
return WebResponseContent.Instance.Error($"物料编号【{string.Join(", ", MaterielInfos1.Select(x => x.MaterielCode))}】的物料属性分类为大件，不可入立库");
|
}
|
}
|
var InventoryInfos = _inventoryInfoService.Repository.QueryData(x => x.WarehouseCode == warehouse_no && array2.ToList().Contains(x.MaterielCode));
|
var Batchs = _inventory_BatchServices.Repository.QueryData(x => array2.Contains(x.MaterielCode));
|
List<Dt_DeliveryOrderDetail> deliveryOrderDetails = new List<Dt_DeliveryOrderDetail>();
|
List<Dt_SupplyTask> supplyTasks = new List<Dt_SupplyTask>();
|
List<Dt_InventoryInfo> inventoryInfos = new List<Dt_InventoryInfo>();
|
List<Dt_Inventory_Batch> inventory_Batches = new List<Dt_Inventory_Batch>();
|
foreach (var item in orderDetailAddDTOs)
|
{
|
if (InventoryInfos.Where(x => x.MaterielCode == item.goods_no && x.BatchNo == item.batch_num).Any())
|
return WebResponseContent.Instance.Error($"物料编号【{item.goods_no}】物料批次【{item.batch_num}】已存在库存");
|
#region 添加盘点单详情
|
Dt_DeliveryOrderDetail dt_DeliveryOrde = new Dt_DeliveryOrderDetail()
|
{
|
DeliveryOrderId = id,
|
Reservoirarea = warehouse_no,
|
Status = 2,
|
Order_qty = 0,
|
Order_Outqty = item.order_Outqty,
|
Goods_no = item.goods_no,
|
OotDetailStatus = "新建",
|
Batch_num = item.batch_num,
|
Creater = App.User.UserName,
|
CreateDate = DateTime.Now,
|
};
|
deliveryOrderDetails.Add(dt_DeliveryOrde);
|
#endregion
|
|
#region 添加库存、批次信息、盘点任务
|
var MaterielInfo = MaterielInfos.First(x => x.MaterielCode == item.goods_no);
|
Dt_InventoryInfo inventoryInfo = new Dt_InventoryInfo()
|
{
|
BatchNo = item.batch_num,
|
MaterielCode = MaterielInfo.MaterielCode,
|
AvailableQuantity = 0,
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName,
|
InDate = DateTime.Now,
|
LocationCode = item.locationCode,
|
MaterielName = MaterielInfo.MaterielName,
|
MaterielSpec = MaterielInfo.MaterielSpec,
|
OutboundQuantity = 0,
|
StockQuantity = 0,
|
StockStatus = StockStatusEmun.盘点锁定.ObjToInt(),
|
SupplyQuantity = 0,
|
WarehouseCode = warehouse_no,
|
ValidityPeriod = item.exp_date
|
};
|
inventoryInfos.Add(inventoryInfo);
|
Dt_Inventory_Batch? inventory_Batch = Batchs.FirstOrDefault(x => x.BatchNo == item.batch_num && x.MaterielCode == item.goods_no);
|
if (inventory_Batch == null)
|
{
|
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.AvailableQuantity,
|
ValidityPeriod = inventoryInfo.ValidityPeriod.ObjToDate(),
|
SupplyQuantity = inventoryInfo.SupplyQuantity,
|
};
|
inventory_Batches.Add(inventory_Batch);
|
}
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = warehouse_no,
|
TaskStatus = SupplyStatusEnum.NewCheck.ObjToInt(),
|
BatchNo = inventoryInfo.BatchNo,
|
MaterielName = inventoryInfo.MaterielName,
|
MaterielCode = inventoryInfo.MaterielCode,
|
MaterielSpec = inventoryInfo.MaterielSpec,
|
TaskType = TaskTypeEnum.OutInventory.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName,
|
LocationCode = inventoryInfo.LocationCode,
|
OrderNo = out_no,
|
StockQuantity = inventoryInfo.StockQuantity,
|
SupplyQuantity = 0,
|
Remark = "盘点"
|
};
|
supplyTasks.Add(supplyTask);
|
#endregion
|
}
|
_unitOfWorkManage.BeginTran();
|
_deliveryOrderDetailServices.AddData(deliveryOrderDetails);
|
_inventoryInfoService.AddData(inventoryInfos);
|
if (inventory_Batches.Count > 0) _inventory_BatchServices.AddData(inventory_Batches);
|
_supplyTaskService.AddData(supplyTasks);
|
_unitOfWorkManage.CommitTran();
|
return WebResponseContent.Instance.OK("盘点详情添加成功,请通过ERP平账！");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
#region 创建出库单
|
/// <summary>
|
/// 创建出库单
|
/// </summary>
|
/// <param name="outorder"></param>
|
/// <returns></returns>
|
public WebResponseContent CreateOutboundOrder(UpstramOutOrderInfo outorder)
|
{
|
WebResponseContent webResponseContent = new WebResponseContent();
|
try
|
{
|
Dt_Tactics tactics = _tacticsService.Repository.QueryFirst(x => x.TacticeName == "出库策略");
|
#region 特殊库房出库
|
string WareCodeMJ = WarehouseEnum.麻精库.ObjToInt().ToString("000");
|
string WareCodeLD = WarehouseEnum.冷冻库.ObjToInt().ToString("000");
|
if (outorder.warehouse_no == WareCodeMJ || outorder.warehouse_no == WareCodeLD)
|
{
|
#region 添加出库单
|
var entityOrder = new Dt_DeliveryOrder
|
{
|
Out_no = outorder.order_no,
|
Out_type = outorder.order_type,
|
Client_no = outorder.client_no,
|
Client_name = outorder.client_name,
|
Account_time = outorder.account_time,
|
Warehouse_no = outorder.warehouse_no,
|
OutStatus = "新建",
|
Details = outorder.details.Select(d => new Dt_DeliveryOrderDetail
|
{
|
Reservoirarea = outorder.warehouse_no,
|
Goods_no = d.goods_no,
|
Order_qty = Math.Abs(d.order_qty), // 出库数量转为正数
|
Batch_num = d.batch_num,
|
Exp_date = d.exp_date,
|
OotDetailStatus = "新建",
|
Status = 2, // pad平库，无需同步
|
}).ToList()
|
};
|
#endregion
|
#region 处理库存、库存批次、添加出库任务
|
List<Dt_SupplyTask> supplyTasks = new List<Dt_SupplyTask>();
|
List<Dt_Inventory_Batch> batchesUp = new List<Dt_Inventory_Batch>();
|
List<Dt_InventoryInfo> inventoryInfosUp = new List<Dt_InventoryInfo>();
|
var inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => entityOrder.Details.Select(e => e.Goods_no).Contains(x.MaterielCode));
|
var InventoryInfos = _inventoryInfoService.Repository.QueryData(x => entityOrder.Details.Select(e => e.Goods_no).Contains(x.MaterielCode) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.AvailableQuantity > 0 && x.WarehouseCode == outorder.warehouse_no);
|
foreach (var item in entityOrder.Details)
|
{
|
Dt_Inventory_Batch? inventory_Batch = inventory_Batchs.Where(x => x.MaterielCode == item.Goods_no && x.BatchNo == item.Batch_num).FirstOrDefault();
|
if (inventory_Batch == null) throw new Exception($"未找到出库单号【{entityOrder.Out_no}】中物料编号【{item.Goods_no}】物料批次【{item.Batch_num}】的库存批次信息");
|
if (inventory_Batch.AvailableQuantity < item.Order_qty) throw new Exception($"出库单号【{entityOrder.Out_no}】中物料编号【{item.Goods_no}】物料批次【{item.Batch_num}】的库存批次信息可用数量不足");
|
inventory_Batch.AvailableQuantity -= item.Order_qty;
|
inventory_Batch.OutboundQuantity += item.Order_qty;
|
List<Dt_InventoryInfo> dt_InventoryInfos = InventoryInfos.Where(x => x.MaterielCode == item.Goods_no && x.BatchNo == item.Batch_num).ToList();
|
if (dt_InventoryInfos.Count < 1) throw new Exception($"出库单号【{entityOrder.Out_no}】中物料编号【{item.Goods_no}】物料批次【{item.Batch_num}】的可用库存不足");
|
#region 按出库策略查找库存
|
if (tactics.SelectTactice == TacticsEnum.ComeOutonFirstTime.ObjToInt())
|
dt_InventoryInfos = dt_InventoryInfos.OrderBy(x => x.ValidityPeriod).ToList();
|
else
|
dt_InventoryInfos = dt_InventoryInfos.OrderBy(x => x.InDate).ToList();
|
#endregion
|
var Order_qty = item.Order_qty;//出库单数量
|
foreach (var InventoryInfo in dt_InventoryInfos)
|
{
|
if (Order_qty <= 0) break;
|
if (InventoryInfo.AvailableQuantity <= Order_qty)
|
{
|
Order_qty -= InventoryInfo.AvailableQuantity;
|
InventoryInfo.OutboundQuantity += InventoryInfo.AvailableQuantity;
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = InventoryInfo.WarehouseCode,
|
BatchNo = InventoryInfo.BatchNo,
|
MaterielName = InventoryInfo.MaterielName,
|
MaterielCode = InventoryInfo.MaterielCode,
|
MaterielSpec = InventoryInfo.MaterielSpec,
|
TaskStatus = SupplyStatusEnum.NewOut.ObjToInt(),
|
TaskType = outorder.order_type == "1" ? TaskTypeEnum.Out.ObjToInt() : TaskTypeEnum.InReturn.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName ?? "System",
|
LocationCode = InventoryInfo.LocationCode,
|
OrderNo = entityOrder.Out_no,
|
StockQuantity = InventoryInfo.AvailableQuantity,
|
SupplyQuantity = 0,
|
Remark = "出库"
|
};
|
supplyTasks.Add(supplyTask);
|
InventoryInfo.AvailableQuantity = 0;
|
}
|
else
|
{
|
InventoryInfo.AvailableQuantity -= Order_qty;
|
InventoryInfo.OutboundQuantity += Order_qty;
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = InventoryInfo.WarehouseCode,
|
BatchNo = InventoryInfo.BatchNo,
|
MaterielName = InventoryInfo.MaterielName,
|
MaterielCode = InventoryInfo.MaterielCode,
|
MaterielSpec = InventoryInfo.MaterielSpec,
|
TaskStatus = SupplyStatusEnum.NewOut.ObjToInt(),
|
TaskType = outorder.order_type == "1" ? TaskTypeEnum.Out.ObjToInt() : TaskTypeEnum.InReturn.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName ?? "System",
|
LocationCode = InventoryInfo.LocationCode,
|
OrderNo = entityOrder.Out_no,
|
StockQuantity = Order_qty,
|
SupplyQuantity = 0,
|
Remark = "出库"
|
};
|
supplyTasks.Add(supplyTask);
|
Order_qty = 0;
|
}
|
inventoryInfosUp.Add(InventoryInfo);
|
}
|
batchesUp.Add(inventory_Batch);
|
}
|
_unitOfWorkManage.BeginTran();
|
_supplyTaskService.AddData(supplyTasks);
|
_inventory_BatchServices.UpdateData(batchesUp);
|
_inventoryInfoService.UpdateData(inventoryInfosUp);
|
BaseDal.Db.CopyNew().InsertNav(entityOrder).Include(x => x.Details).ExecuteCommand();
|
_unitOfWorkManage.CommitTran();
|
#endregion
|
}
|
#endregion
|
else
|
{
|
string WareCodeDJ = WarehouseEnum.大件库.ObjToInt().ToString("000");
|
string WareCodeLK = WarehouseEnum.立库.ObjToInt().ToString("000");
|
#region 创建大件库、立库出库头表
|
var entityOrder = new Dt_DeliveryOrder
|
{
|
Out_no = outorder.order_no,
|
Out_type = outorder.order_type,
|
OutStatus = "新建",
|
Client_name = outorder.client_name,
|
Account_time = outorder.account_time,
|
Client_no = outorder.client_no,
|
Warehouse_no = WareCodeDJ,
|
Details = new List<Dt_DeliveryOrderDetail>()
|
};
|
var entityOrderLK = new Dt_DeliveryOrder
|
{
|
Out_no = outorder.order_no,
|
Out_type = outorder.order_type,
|
OutStatus = "新建",
|
Client_name = outorder.client_name,
|
Account_time = outorder.account_time,
|
Client_no = outorder.client_no,
|
Warehouse_no = WareCodeLK,
|
Details = new List<Dt_DeliveryOrderDetail>()
|
};
|
#endregion
|
#region 查找库存
|
List<Dt_Inventory_Batch> batchesUp = new List<Dt_Inventory_Batch>();
|
List<Dt_InventoryInfo> inventoryInfosUp = new List<Dt_InventoryInfo>();
|
List<Dt_SupplyTask> supplyTasks = new List<Dt_SupplyTask>();
|
List<Dt_MaterielInfo> materielInfos = _materielInfoService.Repository.QueryData(x => outorder.details.Select(e => e.goods_no).Contains(x.MaterielCode));
|
var inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => outorder.details.Select(e => e.goods_no).Contains(x.MaterielCode));
|
var InventoryInfos = _inventoryInfoService.Repository.QueryData(x => outorder.details.Select(e => e.goods_no).Contains(x.MaterielCode) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.AvailableQuantity > 0 && (x.WarehouseCode == WareCodeDJ || x.WarehouseCode == WareCodeLK));
|
foreach (var detail in outorder.details)
|
{
|
#region 查询库存批次和库存
|
Dt_Inventory_Batch? inventory_Batch = inventory_Batchs.Where(x => x.MaterielCode == detail.goods_no && x.BatchNo == detail.batch_num).FirstOrDefault();
|
if (inventory_Batch == null) throw new Exception($"未找到出库单号【{outorder.order_no}】中物料编号【{detail.goods_no}】物料批次【{detail.batch_num}】的库存批次信息");
|
if (inventory_Batch.AvailableQuantity < detail.order_qty) throw new Exception($"出库单号【{outorder.order_no}】中物料编号【{detail.goods_no}】物料批次【{detail.batch_num}】的库存批次信息可用数量不足");
|
inventory_Batch.AvailableQuantity -= detail.order_qty;
|
inventory_Batch.OutboundQuantity += detail.order_qty;
|
List<Dt_InventoryInfo> dt_InventoryInfos = InventoryInfos.Where(x => x.MaterielCode == inventory_Batch.MaterielCode && x.BatchNo == inventory_Batch.BatchNo).ToList();
|
if (dt_InventoryInfos.Count < 1) throw new Exception($"出库单号【{outorder.order_no}】中物料编号【{detail.goods_no}】物料批次【{detail.batch_num}】的可用库存不足");
|
#endregion
|
#region 按出库策略查找库存
|
if (tactics.SelectTactice == TacticsEnum.ComeOutonFirstTime.ObjToInt())
|
dt_InventoryInfos = dt_InventoryInfos.OrderBy(x => x.ValidityPeriod).ToList();
|
else
|
dt_InventoryInfos = dt_InventoryInfos.OrderBy(x => x.InDate).ToList();
|
#endregion
|
var Order_qty = Math.Abs(detail.order_qty);//出库单数量
|
#region 根据物料编码查询物料信息
|
Dt_MaterielInfo? materielInfo = materielInfos.Where(x => x.MaterielCode == detail.goods_no).FirstOrDefault();
|
if (materielInfo == null) throw new Exception($"未找到药品编码【{detail.goods_no}】的信息");
|
if (!Enum.IsDefined(typeof(MaterielSourceTypeEnum), materielInfo.MaterielSourceType))
|
throw new Exception($"请设置药品编号【{detail.goods_no}】的属性分类");
|
#endregion
|
#region 大件
|
if (materielInfo.MaterielSourceType == MaterielSourceTypeEnum.PurchasePart)//如果物料是大件
|
{
|
#region 添加出库详情
|
Dt_DeliveryOrderDetail orderDetail = new Dt_DeliveryOrderDetail()
|
{
|
Reservoirarea = entityOrder.Warehouse_no,
|
Goods_no = detail.goods_no,
|
Order_qty = detail.order_qty,
|
Batch_num = detail.batch_num,
|
Exp_date = detail.exp_date,
|
OotDetailStatus = "新建",
|
Order_Outqty = 0,
|
Status = 2
|
};
|
entityOrder.Details.Add(orderDetail);
|
#endregion
|
|
#region 计算库存、添加出库任务
|
foreach (var InventoryInfo in dt_InventoryInfos)
|
{
|
if (Order_qty <= 0) break;
|
if (InventoryInfo.AvailableQuantity < Order_qty)
|
{
|
Order_qty -= InventoryInfo.AvailableQuantity;
|
InventoryInfo.OutboundQuantity += InventoryInfo.AvailableQuantity;
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = InventoryInfo.WarehouseCode,
|
BatchNo = InventoryInfo.BatchNo,
|
MaterielName = InventoryInfo.MaterielName,
|
MaterielCode = InventoryInfo.MaterielCode,
|
MaterielSpec = InventoryInfo.MaterielSpec,
|
TaskStatus = SupplyStatusEnum.NewOut.ObjToInt(),
|
TaskType = outorder.order_type == "1" ? TaskTypeEnum.Out.ObjToInt() : TaskTypeEnum.InReturn.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName ?? "System",
|
LocationCode = InventoryInfo.LocationCode,
|
OrderNo = entityOrder.Out_no,
|
StockQuantity = InventoryInfo.AvailableQuantity,
|
SupplyQuantity = 0,
|
Remark = "出库"
|
};
|
supplyTasks.Add(supplyTask);
|
InventoryInfo.AvailableQuantity = 0;
|
}
|
else
|
{
|
InventoryInfo.AvailableQuantity -= Order_qty;
|
InventoryInfo.OutboundQuantity += Order_qty;
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = InventoryInfo.WarehouseCode,
|
BatchNo = InventoryInfo.BatchNo,
|
MaterielName = InventoryInfo.MaterielName,
|
MaterielCode = InventoryInfo.MaterielCode,
|
MaterielSpec = InventoryInfo.MaterielSpec,
|
TaskStatus = SupplyStatusEnum.NewOut.ObjToInt(),
|
TaskType = outorder.order_type == "1" ? TaskTypeEnum.Out.ObjToInt() : TaskTypeEnum.InReturn.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName ?? "System",
|
LocationCode = InventoryInfo.LocationCode,
|
OrderNo = entityOrder.Out_no,
|
StockQuantity = Order_qty,
|
SupplyQuantity = 0,
|
Remark = "出库"
|
};
|
supplyTasks.Add(supplyTask);
|
Order_qty = 0;
|
}
|
}
|
#endregion
|
inventoryInfosUp.AddRange(dt_InventoryInfos);
|
batchesUp.Add(inventory_Batch);
|
//_inventory_BatchServices.Repository.UpdateData(inventory_Batch);
|
//_inventoryInfoService.Repository.UpdateData(dt_InventoryInfos);
|
//_supplyTaskService.AddData(supplyTasks);
|
}
|
#endregion
|
else
|
{
|
if (materielInfo.BoxQty < 1) throw new Exception($"请设置药品编号【{detail.goods_no}】的箱规数量");
|
Dt_DeliveryOrderDetail orderDetail = null;
|
Dt_DeliveryOrderDetail orderDetailLK = null;
|
var ys = Order_qty % materielInfo.BoxQty; //不能整除箱规的散件数
|
var xs = (int)(Order_qty / materielInfo.BoxQty);//保留整数
|
#region 散件优先分配立库
|
if (ys > 0)
|
{
|
orderDetailLK = new Dt_DeliveryOrderDetail()
|
{
|
Reservoirarea = entityOrderLK.Warehouse_no,
|
Goods_no = detail.goods_no,
|
Order_qty = ys,
|
Batch_num = detail.batch_num,
|
Exp_date = detail.exp_date,
|
OotDetailStatus = "新建",
|
Order_Outqty = 0,
|
Status = 0
|
};
|
}
|
#endregion
|
|
#region 整件优先分配大件库,计划库存,添加出库任务
|
foreach (var item in dt_InventoryInfos.Where(x => x.WarehouseCode == WareCodeDJ))
|
{
|
if (xs <= 0 || item.AvailableQuantity <= 0) break;
|
decimal outqty = 0;
|
while (item.AvailableQuantity > 0 && xs > 0)
|
{
|
xs--;
|
if (orderDetail == null)
|
{
|
orderDetail = new Dt_DeliveryOrderDetail()
|
{
|
Reservoirarea = entityOrder.Warehouse_no,
|
Goods_no = detail.goods_no,
|
Order_qty = materielInfo.BoxQty,
|
Batch_num = detail.batch_num,
|
Exp_date = detail.exp_date,
|
OotDetailStatus = "新建",
|
Order_Outqty = 0,
|
Status = 2
|
};
|
item.AvailableQuantity -= materielInfo.BoxQty;
|
item.OutboundQuantity += materielInfo.BoxQty;
|
outqty += materielInfo.BoxQty;
|
}
|
else
|
{
|
orderDetail.Order_qty += materielInfo.BoxQty;
|
item.AvailableQuantity -= materielInfo.BoxQty;
|
item.OutboundQuantity += materielInfo.BoxQty;
|
outqty += materielInfo.BoxQty;
|
}
|
}
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = item.WarehouseCode,
|
BatchNo = item.BatchNo,
|
MaterielName = item.MaterielName,
|
MaterielCode = item.MaterielCode,
|
MaterielSpec = item.MaterielSpec,
|
TaskStatus = SupplyStatusEnum.NewOut.ObjToInt(),
|
TaskType = outorder.order_type == "1" ? TaskTypeEnum.Out.ObjToInt() : TaskTypeEnum.InReturn.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName ?? "System",
|
LocationCode = item.LocationCode,
|
OrderNo = entityOrder.Out_no,
|
StockQuantity = outqty,
|
SupplyQuantity = 0,
|
Remark = "出库"
|
};
|
supplyTasks.Add(supplyTask);
|
inventoryInfosUp.Add(item);
|
//_inventoryInfoService.Repository.UpdateData(item);
|
}
|
#endregion
|
|
#region 分配完大件库如果还有箱数，再选择分配立库
|
if (xs > 0)
|
{
|
if (orderDetailLK == null)
|
{
|
orderDetailLK = new Dt_DeliveryOrderDetail()
|
{
|
Reservoirarea = entityOrderLK.Warehouse_no,
|
Goods_no = detail.goods_no,
|
Order_qty = xs * materielInfo.BoxQty,
|
Batch_num = detail.batch_num,
|
Exp_date = detail.exp_date,
|
OotDetailStatus = "新建",
|
Order_Outqty = 0,
|
Status = 0
|
};
|
}
|
else
|
{
|
orderDetailLK.Order_qty += xs * materielInfo.BoxQty;
|
}
|
}
|
#endregion
|
|
#region 立库出库单，修改立库库存，添加立库出库任务
|
if (orderDetailLK != null)
|
{
|
#region 添加出库任务、修改库存信息
|
Dt_InventoryInfo? inventoryInfo = dt_InventoryInfos.FirstOrDefault(x => x.WarehouseCode == WareCodeLK);
|
if (inventoryInfo == null)
|
throw new Exception($"出库单【{outorder.order_no}】详情存在散件,物料编号【{detail.goods_no}】物料批次【{detail.batch_num}】所需数量【{Convert.ToInt32(orderDetailLK.Order_qty)}】请人工调拨补货入立库");
|
inventoryInfo.AvailableQuantity -= orderDetailLK.Order_qty;
|
inventoryInfo.OutboundQuantity += orderDetailLK.Order_qty;
|
Dt_SupplyTask supplyTask = new Dt_SupplyTask()
|
{
|
WarehouseCode = inventoryInfo.WarehouseCode,
|
BatchNo = inventoryInfo.BatchNo,
|
MaterielName = inventoryInfo.MaterielName,
|
MaterielCode = inventoryInfo.MaterielCode,
|
MaterielSpec = inventoryInfo.MaterielSpec,
|
TaskStatus = SupplyStatusEnum.NewOut.ObjToInt(),
|
TaskType = outorder.order_type == "1" ? TaskTypeEnum.Out.ObjToInt() : TaskTypeEnum.InReturn.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName ?? "System",
|
LocationCode = inventoryInfo.LocationCode,
|
OrderNo = entityOrder.Out_no,
|
StockQuantity = orderDetailLK.Order_qty,
|
SupplyQuantity = 0,
|
Remark = "出库"
|
};
|
supplyTasks.Add(supplyTask);
|
#endregion
|
//_inventoryInfoService.Repository.UpdateData(inventoryInfo);
|
inventoryInfosUp.Add(inventoryInfo);
|
entityOrderLK.Details.Add(orderDetailLK);
|
}
|
#endregion
|
if (orderDetail != null) entityOrder.Details.Add(orderDetail);
|
batchesUp.Add(inventory_Batch);
|
//_inventory_BatchServices.Repository.UpdateData(inventory_Batch);
|
//_supplyTaskService.AddData(supplyTasks);
|
}
|
}
|
try
|
{
|
_unitOfWorkManage.BeginTran();
|
_supplyTaskService.AddData(supplyTasks);
|
_inventory_BatchServices.UpdateData(batchesUp);
|
_inventoryInfoService.UpdateData(inventoryInfosUp);
|
if (entityOrder.Details.Count > 0)
|
BaseDal.Db.CopyNew().InsertNav(entityOrder).Include(x => x.Details).ExecuteCommand();
|
if (entityOrderLK.Details.Count > 0)
|
BaseDal.Db.CopyNew().InsertNav(entityOrderLK).Include(x => x.Details).ExecuteCommand();
|
_unitOfWorkManage.CommitTran();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
}
|
#endregion
|
}
|
webResponseContent.OK();
|
}
|
catch (Exception ex)
|
{
|
_messageInfoService.AddMessageInfo(MessageGroupByEnum.OutOrderAlarm, (outorder.order_type == "3" ? "入库退货" : "正常出库") + $"：单号【{outorder.order_no}】", ex.Message);
|
webResponseContent.Error(ex.Message);
|
}
|
return webResponseContent;
|
}
|
#endregion
|
|
#region 创建盘亏出库单
|
public WebResponseContent CreateCheckOutOrder(UpstramOutOrderInfo order)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
string WareCodeMJ = WarehouseEnum.麻精库.ObjToInt().ToString("000");
|
string WareCodeLD = WarehouseEnum.冷冻库.ObjToInt().ToString("000");
|
List<Dt_SupplyTask_Hty> supplyTask_Hties = new List<Dt_SupplyTask_Hty>();
|
List<Dt_Inventory_Batch> batchesUp = new List<Dt_Inventory_Batch>();
|
List<Dt_InventoryInfo> infosUp = new List<Dt_InventoryInfo>();
|
var codes = order.details.Select(x => x.goods_no).ToList();
|
#region 特殊库房
|
if (order.warehouse_no == WareCodeMJ || order.warehouse_no == WareCodeLD)
|
{
|
List<Dt_Inventory_Batch> inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => codes.Contains(x.MaterielCode));
|
List<Dt_InventoryInfo> _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.SupplyQuantity);
|
if (Qty != item.order_qty) throw new Exception($"盘亏出库单【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的盘亏数量有误");
|
//找所有库存
|
List<Dt_InventoryInfo> 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.OutFinish.ObjToInt(),
|
BatchNo = inventoryInfo.BatchNo,
|
MaterielName = inventoryInfo.MaterielName,
|
MaterielCode = inventoryInfo.MaterielCode,
|
MaterielSpec = inventoryInfo.MaterielSpec,
|
TaskType = TaskTypeEnum.ChenckOut.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName,
|
LocationCode = inventoryInfo.LocationCode,
|
OrderNo = order.order_no,
|
StockQuantity = Math.Abs(inventoryInfo.SupplyQuantity),
|
SupplyQuantity = 0,
|
Remark = "盘亏入库"
|
};
|
//_supplyTaskHtyService.AddData(supplyTask_Hty);
|
supplyTask_Hties.Add(supplyTask_Hty);
|
}
|
#endregion
|
inventoryInfo.StockQuantity += inventoryInfo.SupplyQuantity;
|
inventoryInfo.AvailableQuantity = inventoryInfo.StockQuantity;
|
inventoryInfo.SupplyQuantity = 0;
|
inventoryInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt();
|
}
|
inventory_Batch.StockQuantity += inventory_Batch.SupplyQuantity;
|
inventory_Batch.AvailableQuantity = inventory_Batch.StockQuantity;
|
inventory_Batch.SupplyQuantity = 0;
|
infosUp.AddRange(inventoryInfos);
|
batchesUp.Add(inventory_Batch);
|
//_inventoryInfoService.UpdateData(inventoryInfos);
|
//_inventory_BatchServices.UpdateData(inventory_Batch);
|
}
|
#endregion
|
|
#region 创建盘点单
|
var entityOrder = new Dt_DeliveryOrder
|
{
|
Out_no = order.order_no,
|
Out_type = order.order_type,
|
Client_no = order.client_no,
|
Client_name = order.client_name,
|
OutStatus = "已完成",
|
Account_time = order.account_time,
|
Warehouse_no = order.warehouse_no,
|
Details = order.details.Select(d => new Dt_DeliveryOrderDetail
|
{
|
Goods_no = d.goods_no,
|
Order_qty = Math.Abs(d.order_qty),
|
Order_Outqty = Math.Abs(d.order_qty),
|
Batch_num = d.batch_num,
|
Exp_date = d.exp_date,
|
Reservoirarea = order.warehouse_no,
|
OotDetailStatus = "已完成",
|
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();
|
#endregion
|
}
|
#endregion
|
else
|
{
|
List<Dt_DeliveryOrder> deliveryOrdersAdd = new List<Dt_DeliveryOrder>();
|
string WareCodeLK = WarehouseEnum.立库.ObjToInt().ToString("000");
|
string WareCodeDJ = WarehouseEnum.大件库.ObjToInt().ToString("000");
|
List<Dt_Inventory_Batch> inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => codes.Contains(x.MaterielCode));
|
List<Dt_InventoryInfo> _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.SupplyQuantity);
|
if (Qty != item.order_qty) throw new Exception($"盘亏出库单【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的盘亏数量有误");
|
//找所有库存
|
List<Dt_InventoryInfo> 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.SupplyQuantity);
|
var LkQty = inventoryLK.SupplyQuantity;
|
//获取大件库盘点差异数
|
var inventoryDJ = inventoryInfos.Where(x => x.WarehouseCode == WareCodeDJ).ToList();
|
//var DJQty = Math.Abs(inventoryDJ.Sum(x => x.SupplyQuantity));
|
var DJQty = inventoryDJ.Sum(x => x.SupplyQuantity);
|
var count = Math.Abs(LkQty + DJQty);
|
if (count != 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.OutFinish.ObjToInt(),
|
BatchNo = inventoryInfo.BatchNo,
|
MaterielName = inventoryInfo.MaterielName,
|
MaterielCode = inventoryInfo.MaterielCode,
|
MaterielSpec = inventoryInfo.MaterielSpec,
|
TaskType = TaskTypeEnum.ChenckOut.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName,
|
LocationCode = inventoryInfo.LocationCode,
|
OrderNo = order.order_no,
|
StockQuantity = Math.Abs(inventoryInfo.SupplyQuantity),
|
SupplyQuantity = 0,
|
Remark = "盘亏入库"
|
};
|
//_supplyTaskHtyService.AddData(supplyTask_Hty);
|
supplyTask_Hties.Add(supplyTask_Hty);
|
}
|
#endregion
|
inventoryInfo.StockQuantity += inventoryInfo.SupplyQuantity;
|
inventoryInfo.AvailableQuantity = inventoryInfo.StockQuantity;
|
inventoryInfo.SupplyQuantity = 0;
|
inventoryInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt();
|
}
|
//_inventoryInfoService.UpdateData(inventoryInfos);
|
inventory_Batch.StockQuantity += inventory_Batch.SupplyQuantity;
|
inventory_Batch.AvailableQuantity = inventory_Batch.StockQuantity;
|
inventory_Batch.SupplyQuantity = 0;
|
//_inventory_BatchServices.UpdateData(inventory_Batch);
|
infosUp.AddRange(inventoryInfos);
|
batchesUp.Add(inventory_Batch);
|
#endregion
|
|
#region 创建大件库盘点单
|
var entityOrder = new Dt_DeliveryOrder
|
{
|
Out_no = order.order_no,
|
Out_type = order.order_type,
|
Client_no = order.client_no,
|
Account_time = order.account_time,
|
OutStatus = "已完成",
|
Client_name = order.client_name,
|
Warehouse_no = WareCodeDJ,
|
Details = order.details.Select(d => new Dt_DeliveryOrderDetail
|
{
|
Goods_no = d.goods_no,
|
Order_qty = Math.Abs(d.order_qty),
|
Order_Outqty = Math.Abs(d.order_qty),
|
Batch_num = d.batch_num,
|
Exp_date = d.exp_date,
|
Reservoirarea = WareCodeDJ,
|
OotDetailStatus = "已完成",
|
Status = 2,
|
}).ToList()
|
};
|
//Db.InsertNav(entityOrder).Include(it => it.Details).ExecuteCommand();
|
//Repository.AddData(entityOrder);
|
deliveryOrdersAdd.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.OutFinish.ObjToInt(),
|
BatchNo = inventoryInfo.BatchNo,
|
MaterielName = inventoryInfo.MaterielName,
|
MaterielCode = inventoryInfo.MaterielCode,
|
MaterielSpec = inventoryInfo.MaterielSpec,
|
TaskType = TaskTypeEnum.ChenckOut.ObjToInt(),
|
CreateDate = DateTime.Now,
|
Creater = App.User.UserName,
|
LocationCode = inventoryInfo.LocationCode,
|
OrderNo = order.order_no,
|
StockQuantity = Math.Abs(inventoryInfo.SupplyQuantity),
|
SupplyQuantity = 0,
|
Remark = "盘亏出库"
|
};
|
//_supplyTaskHtyService.AddData(supplyTask_Hty);
|
supplyTask_Hties.Add(supplyTask_Hty);
|
}
|
#endregion
|
inventoryInfo.StockQuantity += inventoryInfo.SupplyQuantity;
|
inventoryInfo.AvailableQuantity = inventoryInfo.StockQuantity;
|
inventoryInfo.SupplyQuantity = 0;
|
inventoryInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt();
|
}
|
//_inventoryInfoService.UpdateData(inventoryInfos);
|
infosUp.AddRange(inventoryInfos);
|
#endregion
|
|
#region 创建大件库盘点单
|
if (DJQty != 0)
|
{
|
var cabinOrder = new Dt_DeliveryOrder
|
{
|
Out_no = order.order_no,
|
Out_type = order.order_type,
|
Client_name = order.client_name,
|
Account_time = order.account_time,
|
OutStatus = "已完成",
|
Client_no = order.client_no,
|
Warehouse_no = WareCodeDJ,
|
Details = order.details.Select(d => new Dt_DeliveryOrderDetail
|
{
|
Goods_no = d.goods_no,
|
Order_qty = DJQty,
|
Order_Outqty = DJQty,
|
Batch_num = d.batch_num,
|
Exp_date = d.exp_date,
|
Reservoirarea = WareCodeDJ,
|
OotDetailStatus = "已完成",
|
Status = 2,
|
}).ToList()
|
};
|
//Repository.AddData(cabinOrder);
|
//Db.InsertNav(cabinOrder).Include(it => it.Details).ExecuteCommand();
|
deliveryOrdersAdd.Add(cabinOrder);
|
}
|
#endregion
|
//这里
|
#region 创建立库盘点单
|
var entityOrder = new Dt_DeliveryOrder
|
{
|
Out_no = order.order_no,
|
Out_type = order.order_type,
|
Client_no = order.client_no,
|
Account_time = order.account_time,
|
OutStatus = "新建",
|
Client_name = order.client_name,
|
Warehouse_no = WareCodeLK,
|
Details = order.details.Select(d => new Dt_DeliveryOrderDetail
|
{
|
Goods_no = d.goods_no,
|
Order_qty = Math.Abs(LkQty), //给下游WCS的是要整数
|
Batch_num = d.batch_num,
|
Exp_date = d.exp_date,
|
Reservoirarea = WareCodeLK,
|
OotDetailStatus = "新建",
|
Status = 0,
|
}).ToList()
|
};
|
//Db.InsertNav(entityOrder).Include(it => it.Details).ExecuteCommand();
|
//Repository.AddData(entityOrder);
|
deliveryOrdersAdd.Add(entityOrder);
|
#endregion
|
}
|
//return WebResponseContent.Instance.OK("成功");
|
}
|
_unitOfWorkManage.BeginTran();
|
_supplyTaskHtyService.AddData(supplyTask_Hties);
|
_inventoryInfoService.UpdateData(infosUp);
|
_inventory_BatchServices.UpdateData(batchesUp);
|
BaseDal.Db.InsertNav(deliveryOrdersAdd).Include(it => it.Details).ExecuteCommand();
|
_unitOfWorkManage.CommitTran();
|
}
|
return WebResponseContent.Instance.OK("成功");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
#endregion
|
|
|
//盘点 拿整个批次信息表的商品批号和商品编号来进行盘点
|
public WebResponseContent InventoryGood(string batchNo, string goodsNo)
|
{
|
var response = new WebResponseContent();
|
try
|
{
|
// 1️⃣ 查找指定批次与物料的库存信息
|
var batchInfo = BaseDal.Db.CopyNew().Queryable<Dt_Inventory_Batch>()
|
.Where(x => x.BatchNo == batchNo && x.MaterielCode == goodsNo)
|
.First();
|
|
if (batchInfo == null)
|
return response.Error($"未找到该物料 [{goodsNo}] 批次 [{batchNo}] 的库存信息");
|
|
// 2️⃣ 组装请求 DTO（完全符合接口文档结构）
|
var ediDto = new TowcsDto.ToediOutInfo
|
{
|
customerCode = "905",
|
materialCode = "YY", // 物料类型CODE
|
externalOrderNo = $"PDCK-{batchInfo.Id}", // 外部出库单号
|
outOrderType = "20", // 盘点出库单
|
priority = 1,
|
Is_cancel = 0,
|
details = new List<TowcsDto.ToeOutdiInDetail>
|
{
|
new TowcsDto.ToeOutdiInDetail
|
{
|
batchNo = batchInfo.BatchNo,
|
productCode = batchInfo.MaterielCode,
|
productName = batchInfo.MaterielName,
|
productSpecifications = batchInfo.MaterielSpec,
|
quantity = (int)batchInfo.SupplyQuantity,
|
//stocktakingDetails = new List<TowcsDto.ToOutediInStock>
|
//{
|
// // 盘点明细可根据实际托盘拆分；此处示例仅1条
|
// new TowcsDto.ToOutediInStock
|
// {
|
// palletCode = "FC00001",
|
// quantity = batchInfo.SupplyQuantity.ToString()
|
// }
|
//}
|
}
|
}
|
};
|
|
// 3️⃣ 调用接口
|
string url = "http://172.16.1.2:9357/file-admin/api/out/ediOut";
|
var result = HttpHelper.Post(url, ediDto.ToJsonString());
|
var resp = JsonConvert.DeserializeObject<TowcsDto.TowcsResponse<object>>(result);
|
|
// 4️⃣ 响应处理
|
if (resp == null)
|
return response.Error("WCS 无响应");
|
if (resp.code != "0")
|
return response.Error($"WCS返回失败: {resp.msg}");
|
|
return response.OK("盘点出库下发成功");
|
}
|
catch (Exception ex)
|
{
|
return response.Error("盘点失败：" + ex.Message);
|
}
|
}
|
|
|
/// <summary>
|
/// 查询出库单列表
|
/// </summary>
|
/// <param name="saveModel"></param>
|
/// <returns></returns>
|
public WebResponseContent GetDeliveryOrders(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_DeliveryOrder> dt_ReceiveOrders = new List<Dt_DeliveryOrder>();
|
if (string.IsNullOrEmpty(orderNo))
|
{
|
dt_ReceiveOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => (x.OutStatus == "新建" || x.OutStatus == "开始") && x.Warehouse_no == warehouseCode && x.Out_type != "20").Includes(x => x.Details).OrderByDescending(x => x.CreateDate).ToPageList(pageNo, 5);
|
}
|
else
|
{
|
dt_ReceiveOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => (x.Out_no.Contains(orderNo) || x.Client_no.Contains(orderNo)) && (x.OutStatus == "新建" || x.OutStatus == "开始") && x.Out_type != "20" && 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;
|
}
|
|
/// <summary>
|
/// 查询出库/盘点单详情 看出库单明细。
|
/// </summary>
|
/// <param name="pageNo"></param>
|
/// <param name="orderNo"></param>
|
/// <param name="isPick"></param>
|
/// <returns></returns>
|
public WebResponseContent GetDeliveryOrderDetail(int pageNo, string orderNo, bool isPick)
|
{
|
WebResponseContent content = new WebResponseContent();
|
Dt_DeliveryOrder cabinOrder = new Dt_DeliveryOrder();
|
if (isPick)
|
cabinOrder = Db.Queryable<Dt_DeliveryOrder>().Includes(x => x.Details).First(x => x.Out_no == orderNo && x.Out_type == "20");
|
else
|
cabinOrder = Db.Queryable<Dt_DeliveryOrder>().Includes(x => x.Details).First(x => x.Out_no == orderNo && x.Out_type != "20");
|
//List<Dt_DeliveryOrderDetail>? cabinOrderDetails = cabinOrder.Details?.Where(x => x.Reservoirarea == pageNo.ToString()).ToList();
|
List<Dt_DeliveryOrderDetail>? cabinOrderDetails = cabinOrder.Details?.Where(x => x.Status == 2).ToList();
|
content.OK(data: cabinOrderDetails);
|
return content;
|
}
|
|
|
/// <summary>
|
/// pad出库完成
|
/// </summary>
|
/// <param name="saveModel"></param>
|
/// <returns></returns>
|
public WebResponseContent OutFinish(SaveModel saveModel)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
var LocationCode = saveModel.MainData["locationCode"].ToString();
|
var TaskId = saveModel.MainData["taskId"].ObjToInt();
|
Dt_SupplyTask supplyTask = _supplyTaskService.Repository.QueryFirst(x => x.TaskId == TaskId && x.TaskStatus == SupplyStatusEnum.NewOut.ObjToInt());
|
if (supplyTask == null) throw new Exception("当前出库任务已完成");
|
if (supplyTask.LocationCode != LocationCode) throw new Exception($"当前出库货位【{LocationCode}】与任务分配货位不匹配");
|
Dt_DeliveryOrder deliveryOrder = BaseDal.Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == supplyTask.OrderNo && x.Warehouse_no == supplyTask.WarehouseCode).Includes(x => x.Details).First();
|
if (deliveryOrder == null) return WebResponseContent.Instance.OK($"出库单已完成");
|
content = OutTaskFinish(supplyTask, deliveryOrder);
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
|
public WebResponseContent OutTaskFinish(Dt_SupplyTask supplyTask, Dt_DeliveryOrder deliveryOrder)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_DeliveryOrderDetail? cabinOrderDetail = deliveryOrder.Details.FirstOrDefault(x => x.Batch_num == supplyTask.BatchNo && x.Goods_no == supplyTask.MaterielCode);
|
if (cabinOrderDetail == null) throw new Exception($"出库单明细未找到");
|
Dt_MaterielInfo materielInfo = _materielInfoService.Repository.QueryFirst(x => x.MaterielCode == supplyTask.MaterielCode);
|
if (materielInfo == null) throw new Exception($"请维护物料编号【{supplyTask.MaterielCode}】的物料信息");
|
cabinOrderDetail.Order_Outqty += supplyTask.StockQuantity;
|
if (cabinOrderDetail.Order_Outqty > cabinOrderDetail.Order_qty) throw new Exception($"出库数量不可超出单据数量");
|
deliveryOrder.OutStatus = "开始";
|
cabinOrderDetail.OotDetailStatus = "开始";
|
if (cabinOrderDetail.Order_Outqty == cabinOrderDetail.Order_qty) cabinOrderDetail.OotDetailStatus = "已完成";
|
|
#region 库存
|
Dt_InventoryInfo inventoryInfo = _inventoryInfoService.Repository.QueryFirst(x => x.BatchNo == cabinOrderDetail.Batch_num && x.MaterielCode == cabinOrderDetail.Goods_no && x.LocationCode == supplyTask.LocationCode);
|
if (inventoryInfo == null) throw new Exception($"未找到货位【{supplyTask.LocationCode}】的库存信息");
|
inventoryInfo.StockQuantity -= supplyTask.StockQuantity;
|
inventoryInfo.OutboundQuantity -= supplyTask.StockQuantity;
|
#endregion
|
Dt_LocationInfo location = _locationInfoService.Repository.QueryFirst(x => x.LocationCode == supplyTask.LocationCode);
|
#region 货位
|
if (supplyTask.WarehouseCode != WarehouseEnum.立库.ObjToInt().ToString("000"))
|
{
|
if (location == null)
|
return WebResponseContent.Instance.Error($"请维护货位编号【{supplyTask.LocationCode}】的货位信息");
|
Dt_InventoryInfo inventoryInfo1 = _inventoryInfoService.Repository.QueryFirst(x => x.LocationCode == supplyTask.LocationCode);
|
if (inventoryInfo1 == null) location.LocationStatus = LocationStatusEnum.Free.ObjToInt();
|
}
|
#endregion
|
|
#region 库存批次 如果任务类型是调拨出库任务（8）就不修改批次库存
|
Dt_Inventory_Batch inventory_Batch = _inventory_BatchServices.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo && x.MaterielCode ==
|
inventoryInfo.MaterielCode);
|
if (supplyTask.TaskType != TaskTypeEnum.AllocatOut.ObjToInt())
|
{
|
inventory_Batch.StockQuantity -= supplyTask.StockQuantity;
|
inventory_Batch.OutboundQuantity -= supplyTask.StockQuantity;
|
}
|
#endregion
|
supplyTask.TaskStatus = SupplyStatusEnum.OutFinish.ObjToInt();
|
|
_unitOfWorkManage.BeginTran();
|
if (inventory_Batch.StockQuantity <= 0)
|
_inventory_BatchServices.DeleteData(inventory_Batch);
|
else
|
_inventory_BatchServices.UpdateData(inventory_Batch);
|
_materielInfoService.UpdateData(materielInfo);
|
if (inventoryInfo.StockQuantity <= 0)
|
_inventoryInfoService.DeleteData(inventoryInfo);
|
else
|
_inventoryInfoService.UpdateData(inventoryInfo);
|
if (location != null) _locationInfoService.UpdateData(location);
|
_deliveryOrderDetailServices.UpdateData(cabinOrderDetail);
|
_supplyTaskService.Repository.DeleteAndMoveIntoHty(supplyTask, OperateTypeEnum.人工完成);
|
|
#region 判断详情是否全部完成
|
if (!_deliveryOrderDetailServices.Repository.QueryData(x => x.DeliveryOrderId == deliveryOrder.Id && x.OotDetailStatus != "已完成").Any())
|
deliveryOrder.OutStatus = "已完成";
|
BaseDal.UpdateData(deliveryOrder);
|
if (supplyTask.WarehouseCode == WarehouseEnum.立库.ObjToInt().ToString("000"))
|
{
|
materielInfo.Business_qty -= supplyTask.StockQuantity;
|
if (materielInfo.Business_qty < materielInfo.MinQty)
|
CreateAllocatInOut(materielInfo);//创建调拨任务
|
}
|
#endregion
|
_unitOfWorkManage.CommitTran();
|
|
content.OK();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
|
public WebResponseContent OutTaskFinish(Dt_SupplyTask supplyTask)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_DeliveryOrder? cabinOrder = BaseDal.Db.CopyNew().Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == supplyTask.OrderNo && x.Warehouse_no == supplyTask.WarehouseCode).Includes(x => x.Details).First();
|
if (cabinOrder == null) return WebResponseContent.Instance.OK($"出库单已完成");
|
|
Dt_DeliveryOrderDetail? cabinOrderDetail = cabinOrder.Details.Where(x => x.Batch_num == supplyTask.BatchNo && x.Reservoirarea == supplyTask.WarehouseCode && x.Goods_no == supplyTask.MaterielCode).FirstOrDefault();
|
if (cabinOrderDetail == null) 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_Outqty += supplyTask.StockQuantity;
|
if (cabinOrderDetail.Order_Outqty > cabinOrderDetail.Order_qty)
|
return WebResponseContent.Instance.Error($"出库数量不可超出单据数量");
|
|
|
#region 处理出库单，货位，库存，库存批次信息,出库任务
|
//_unitOfWorkManage.BeginTran();
|
|
#region 出库单
|
cabinOrder.OutStatus = "开始";
|
cabinOrderDetail.OotDetailStatus = "开始";
|
if (cabinOrderDetail.Order_Outqty == cabinOrderDetail.Order_qty)
|
{
|
cabinOrderDetail.OotDetailStatus = "已完成";
|
//_deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrderDetail, OperateTypeEnum.自动完成);
|
}
|
_deliveryOrderDetailServices.Repository.UpdateData(cabinOrderDetail);
|
var cabinOrder1 = BaseDal.Db.CopyNew().Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == cabinOrder.Out_no && x.Warehouse_no == supplyTask.WarehouseCode && x.Out_type != "20").Includes(x => x.Details).First();
|
if (!cabinOrder1.Details.Where(x => x.OotDetailStatus != "已完成").Any())
|
cabinOrder.OutStatus = "已完成";
|
Repository.UpdateData(cabinOrder);
|
#endregion
|
|
#region 库存
|
Dt_InventoryInfo inventoryInfo = _inventoryInfoService.Repository.QueryFirst(x => x.BatchNo == cabinOrderDetail.Batch_num && x.MaterielCode == cabinOrderDetail.Goods_no && x.LocationCode == supplyTask.LocationCode);
|
if (inventoryInfo == null) return WebResponseContent.Instance.Error($"未找到货位【{supplyTask.LocationCode}】的库存信息");
|
inventoryInfo.StockQuantity -= supplyTask.StockQuantity;
|
inventoryInfo.OutboundQuantity -= supplyTask.StockQuantity;
|
if (inventoryInfo.StockQuantity <= 0)
|
_inventoryInfoService.DeleteData(inventoryInfo);
|
else
|
_inventoryInfoService.UpdateData(inventoryInfo);
|
#endregion
|
|
#region 货位
|
if (supplyTask.WarehouseCode != WarehouseEnum.立库.ObjToInt().ToString("000"))
|
{
|
var location = _locationInfoService.Repository.QueryFirst(x => x.LocationCode == supplyTask.LocationCode);
|
if (location == null)
|
return WebResponseContent.Instance.Error($"请维护货位编号【{supplyTask.LocationCode}】的货位信息");
|
//if (location.EnableStatus == EnableStatusEnum.Disable.ObjToInt())
|
// return WebResponseContent.Instance.Error($"货位编号【{supplyTask.LocationCode}】已禁用，请恢复正常再使用");
|
Dt_InventoryInfo inventoryInfo1 = _inventoryInfoService.Repository.QueryFirst(x => x.LocationCode == supplyTask.LocationCode);
|
if (inventoryInfo1 == null)
|
{
|
location.LocationStatus = LocationStatusEnum.Free.ObjToInt();
|
_locationInfoService.UpdateData(location);
|
}
|
}
|
#endregion
|
|
//_supplyTaskService.UpdateData(supplyTask);
|
supplyTask.TaskNum = cabinOrderDetail.Id;
|
supplyTask.TaskStatus = SupplyStatusEnum.OutFinish.ObjToInt();
|
_supplyTaskService.Repository.DeleteAndMoveIntoHty(supplyTask, OperateTypeEnum.人工完成);
|
|
#region 库存批次 如果任务类型是调拨出库任务（8）就不修改批次库存
|
if (supplyTask.TaskType != TaskTypeEnum.AllocatOut.ObjToInt())
|
{
|
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 -= supplyTask.StockQuantity;
|
inventory_Batch.OutboundQuantity -= supplyTask.StockQuantity;
|
if (inventory_Batch.StockQuantity <= 0)
|
_inventory_BatchServices.DeleteData(inventory_Batch);
|
else
|
_inventory_BatchServices.UpdateData(inventory_Batch);
|
}
|
}
|
#endregion
|
if (supplyTask.WarehouseCode == WarehouseEnum.立库.ObjToInt().ToString("000"))
|
{
|
materielInfo.Business_qty -= supplyTask.StockQuantity;
|
_materielInfoService.UpdateData(materielInfo);
|
if (materielInfo.Business_qty < materielInfo.MinQty)
|
CreateAllocatInOut(materielInfo);//创建调拨任务
|
}
|
//_unitOfWorkManage.CommitTran();
|
#endregion
|
content.OK();
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
|
/// <summary>
|
/// 人工在出库单中点击完成按钮实现上报
|
/// </summary>
|
/// <param name="key">id</param>
|
/// <returns></returns>
|
public WebResponseContent FinishOutOrder(int key)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_DeliveryOrder deliveryOrder = BaseDal.QueryFirst(x => x.Id == key);
|
List<Dt_DeliveryOrder> deliveryOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == deliveryOrder.Out_no).Includes(x => x.Details).ToList();//找出所有出库单号相同的出库单
|
List<Dt_DeliveryOrderDetail> deliveryOrderDetails = new List<Dt_DeliveryOrderDetail>();
|
foreach (var item in deliveryOrders)
|
{
|
if (item.Details != null) deliveryOrderDetails.AddRange(item.Details);
|
item.Modifier = App.User.UserName;
|
item.ModifyDate = DateTime.Now;
|
item.Details = null;
|
}
|
if (deliveryOrder.Out_type == OutOrderTypeEnum.Allocate.ObjToInt().ToString())
|
{
|
_deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(deliveryOrderDetails, OperateTypeEnum.人工完成);
|
BaseDal.DeleteAndMoveIntoHty(deliveryOrders, OperateTypeEnum.人工完成);
|
}
|
else
|
{
|
var url = "http://121.37.118.63:80/GYZ2/95fck/outOrderOk";
|
if (deliveryOrder.Out_type == "3") url = "http://121.37.118.63:80/GYZ2/95fck/inOrderOk";
|
var requestDate = new
|
{
|
order_no = deliveryOrder.Out_no
|
};
|
var result = HttpHelper.Post(url, requestDate.ToJsonString());
|
var response = JsonConvert.DeserializeObject<UpstreamOrderResponse>(result);
|
if (response == null) throw new Exception("上报ERP出库单完成失败！");
|
if (response.resultCode != "0" && response.resultMsg != "未找到合法单据") throw new Exception(response.resultMsg);
|
_deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(deliveryOrderDetails, OperateTypeEnum.人工完成);
|
BaseDal.DeleteAndMoveIntoHty(deliveryOrders, OperateTypeEnum.人工完成);
|
}
|
content.OK();
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
}
|
}
|
