| | |
| | | using HslCommunication; |
| | | using MailKit.Search; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Newtonsoft.Json; |
| | | using SqlSugar; |
| | | using System; |
| | |
| | | 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_Core; |
| | | using WIDESEA_Core.BaseRepository; |
| | | using WIDESEA_Core.BaseServices; |
| | | using WIDESEA_Core.Enums; |
| | | using WIDESEA_Core.Helper; |
| | | using WIDESEA_IBasicService; |
| | | using WIDESEA_ISquareCabinServices; |
| | | using WIDESEA_IWMsInfoServices; |
| | | using WIDESEA_Model.Models; |
| | | |
| | | using static System.Net.WebRequestMethods; |
| | |
| | | { |
| | | public class CabinOrderServices : ServiceBase<Dt_CabinOrder, IRepository<Dt_CabinOrder>>, ICabinOrderServices |
| | | { |
| | | |
| | | static string SearchDate = ""; |
| | | private readonly IBasicService _basicService; |
| | | 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; |
| | | public IRepository<Dt_CabinOrder> Repository => BaseDal; |
| | | |
| | | public CabinOrderServices(IRepository<Dt_CabinOrder> BaseDal, IBasicService basicService) : base(BaseDal) |
| | | public CabinOrderServices(IRepository<Dt_CabinOrder> BaseDal, IBasicService basicService, IMedicineGoodsServices medicineGoodsServices, IUnitOfWorkManage unitOfWorkManage, IInventory_BatchServices inventory_BatchServices, IInventoryInfoService inventoryInfoService, ICabinOrderDetailServices cabinOrderDetailServices, ICabinOrderHtyServices cabinOrderHtyServices, ICabinOrderDetailHtyServices cabinOrderDetailHtyServices, ISupplyTaskService supplyTaskService) : base(BaseDal) |
| | | { |
| | | _basicService = basicService; |
| | | _medicineGoodsServices = medicineGoodsServices; |
| | | _unitOfWorkManage = unitOfWorkManage; |
| | | _inventory_BatchServices = inventory_BatchServices; |
| | | _inventoryInfoService = inventoryInfoService; |
| | | _cabinOrderDetailServices = cabinOrderDetailServices; |
| | | _supplyTaskService = supplyTaskService; |
| | | } |
| | | |
| | | |
| | | |
| | | 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_CabinOrder> dt_ReceiveOrders = new List<Dt_CabinOrder>(); |
| | | if (string.IsNullOrEmpty(orderNo)) |
| | | { |
| | | dt_ReceiveOrders = Db.Queryable<Dt_CabinOrder>().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<Dt_CabinOrder>().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; |
| | | } |
| | | public WebResponseContent GetCabinOrderDetail(int pageNo, string orderNo) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | Dt_CabinOrder cabinOrder = Db.Queryable<Dt_CabinOrder>().Includes(x => x.Details).First(x => x.Order_no == orderNo); |
| | | List<Dt_CabinOrderDetail> cabinOrderDetails = cabinOrder.Details.Where(x => x.Reservoirarea == pageNo.ToString()).ToList(); |
| | | content.OK(data: cabinOrderDetails); |
| | | return content; |
| | | } |
| | | 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 Inqty = saveModel.MainData["Inqty"].ObjToInt(); |
| | | var warehouseCode = saveModel.MainData["warehouseCode"].ToString(); |
| | | Dt_CabinOrder cabinOrder = BaseDal.Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == orderNo && x.Warehouse_no == warehouseCode).Includes(x => x.Details).First(); |
| | | if (cabinOrder == null) return WebResponseContent.Instance.Error($"å
¥åºå已宿"); |
| | | Dt_CabinOrderDetail cabinOrderDetail = cabinOrder.Details.Where(x => x.Batch_num == batchNo && x.Reservoirarea == warehouseCode).First(); |
| | | if (cabinOrderDetail == null) return WebResponseContent.Instance.Error($"å
¥åºåæç»å·²å®æ"); |
| | | Dt_MaterielInfo materielInfo = _basicService.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.DeleteAndMoveIntoHty(cabinOrderDetail, OperateTypeEnum.èªå¨å®æ); |
| | | } |
| | | else |
| | | { |
| | | _cabinOrderDetailServices.Repository.UpdateData(cabinOrderDetail); |
| | | } |
| | | var cabinOrder1 = BaseDal.Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == cabinOrder.Order_no).Includes(x => x.Details).First(); |
| | | if (cabinOrder1.Details == null || cabinOrder1.Details.Count < 1) cabinOrder.OdrderStatus = "已宿"; |
| | | Repository.UpdateData(cabinOrder); |
| | | #endregion |
| | | |
| | | #region è´§ä½ |
| | | var location = _basicService.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.LocationStatus != LocationStatusEnum.InStock.ObjToInt()) |
| | | { |
| | | location.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | _basicService.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; |
| | | _inventoryInfoService.UpdateData(inventoryInfo); |
| | | } |
| | | else |
| | | { |
| | | inventoryInfo = new Dt_InventoryInfo() |
| | | { |
| | | LocationCode = LocationCode, |
| | | MaterielCode = materielInfo.MaterielCode, |
| | | MaterielName = materielInfo.MaterielName, |
| | | MaterielSpec = materielInfo.MaterielSpec, |
| | | OutboundQuantity = 0, |
| | | StockQuantity = 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, |
| | | }; |
| | | _inventoryInfoService.AddData(inventoryInfo); |
| | | } |
| | | #endregion |
| | | |
| | | #region ä»»å¡è®°å½ |
| | | Dt_SupplyTask supplyTask = new Dt_SupplyTask() |
| | | { |
| | | WarehouseCode = cabinOrderDetail.Reservoirarea, |
| | | 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 |
| | | |
| | | #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_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, |
| | | ValidityPeriod = inventoryInfo.ValidityPeriod, |
| | | 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; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// è·å䏿¸¸ç³»ç»çå
¥åºå |
| | | /// </summary> |
| | | /// <param name="searchDate"></param> |
| | | /// <returns></returns> |
| | | //public WebResponseContent GetUpstreamOrder(DateTime searchDate) |
| | | //{ |
| | | // var responseContent = new WebResponseContent(); |
| | | |
| | | // try |
| | | // { |
| | | // // 请æ±å°å |
| | | // var url = "http://127.0.0.1:9090/GYZ2/95fck/inOrder"; |
| | | |
| | | // //// 请æ±åæ° |
| | | // var requestData = new |
| | | // { |
| | | // searchDate = searchDate.ToString("yyyy-MM-dd HH:mm:ss") |
| | | // }; |
| | | |
| | | // // åèµ·è¯·æ± |
| | | // var result = HttpHelper.Post(url, requestData.ToJsonString()); |
| | | |
| | | // // ååºåå |
| | | // var response = JsonConvert.DeserializeObject<UpstreamResponse<UpstreamOrderInfo>>(result); |
| | | |
| | | // if (response.resultCode != "0") |
| | | // { |
| | | // // è°ç¨å¼å¸¸æ¥å£ |
| | | // SendErrorToUpstream(1, "", response.resultMsg ?? "䏿¸¸æ¥å£è¿å失败", ""); |
| | | // return responseContent.Error(response.resultMsg ?? "䏿¸¸æ¥å£è¿å失败"); |
| | | // } |
| | | |
| | | // if (response.data == null || !response.data.Any()) |
| | | // { |
| | | // return responseContent.OK("æ æ°å
¥åºåæ°æ®"); |
| | | // } |
| | | |
| | | // Db.Ado.BeginTran(); |
| | | // List<Dt_CabinOrder> _CabinOrders = new List<Dt_CabinOrder>(); |
| | | // foreach (var order in response.data) |
| | | // { |
| | | // try |
| | | // { |
| | | // // æå
¥å
¥åºå表 |
| | | // 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 = "æ°å»º", |
| | | // }; |
| | | // //var orderId = Db.Insertable(entityOrder).ExecuteReturnIdentity(); //å°±æ¯è¿å主é®IDã |
| | | |
| | | // // æå
¥å
¥åºæç»è¡¨ |
| | | // var detailEntities = order.details.Select(d => new Dt_CabinOrderDetail |
| | | // { |
| | | // //OrderId= orderId, |
| | | // Goods_no = d.goods_no, |
| | | // Order_qty = d.order_qty, |
| | | // Batch_num = d.batch_num, |
| | | // Exp_date = d.exp_date, |
| | | // Warehouse_no = d.warehouse_no, |
| | | // Status = 0, |
| | | // }).ToList(); |
| | | // entityOrder.Details.AddRange(detailEntities); //建ç«ä¸»å¯¹è±¡ä¸å对象çå
³èå
³ç³» |
| | | // _CabinOrders.Add(entityOrder); |
| | | |
| | | // //èªå·± |
| | | // /// Db.Insertable(detailEntities).ExecuteCommand(); |
| | | |
| | | // //è¿éè¦è°ç¨ä¸ä¸ªæ¥å£å°ä¸é¢çä¿¡æ¯ä¼ ç»wcsï¼ç¶åæ¹åç¶æ |
| | | // } |
| | | // catch (Exception innerEx) |
| | | // { |
| | | // // éå¯¹ææ¡è®¢åæ¥éæ¶ï¼æ¨éå¼å¸¸ç»ä¸æ¸¸ |
| | | // SendErrorToUpstream(1, order.order_no, innerEx.Message, ""); |
| | | // throw; // æåºå¼å¸¸ï¼è®©å¤å±æè·åæ» |
| | | // } |
| | | // } |
| | | // // æ¹éæå
¥ï¼SqlSugarèªå¨å¤ç主å¤é®å
³ç³»ï¼ |
| | | // Db.Insertable(_CabinOrders).ExecuteCommand(); |
| | | // Db.Ado.CommitTran(); |
| | | |
| | | // //妿EdiIn宿é£ä¹å°±è°ç¨CompleteOrderæ¥å£ |
| | | |
| | | // return responseContent.OK("忥å
¥åºåæå"); |
| | | // } |
| | | // catch (Exception ex) |
| | | // { |
| | | // // å
¨å±å¼å¸¸æ¶ï¼ä¹æ¨éå¼å¸¸ç»ä¸æ¸¸ |
| | | // SendErrorToUpstream(1, "", ex.Message, ""); |
| | | // Db.Ado.RollbackTran(); |
| | | // return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | // } |
| | | //} |
| | | |
| | | |
| | | public WebResponseContent GetUpstreamOrder() |
| | | { |
| | | var responseContent = new WebResponseContent(); |
| | |
| | | |
| | | foreach (var order in newOrders) |
| | | { |
| | | bool skipOrder = false;//æ è®°æ¯å¦è·³è¿è¯¥å
¥åºå |
| | | var entityOrder = new Dt_CabinOrder |
| | | { |
| | | Order_no = order.order_no, |
| | |
| | | }; |
| | | foreach (var item in order.details) |
| | | { |
| | | // å°ä¸æ¸¸å
¥åºæ°éè½¬ä¸ºæ£æ° |
| | | item.order_qty = Math.Abs(item.order_qty); |
| | | #region æ ¹æ®ç©æç¼ç æ¥è¯¢ç©æä¿¡æ¯ |
| | | Dt_MaterielInfo materielInfo = _basicService.MaterielInfoService.Repository.QueryFirst(x => x.MaterielCode == item.goods_no); |
| | | ///æ ¹æ®ç©æä¿¡æ¯å¤§å°ä»¶å±æ§åºåæ¯å¦å
¥ç«åº |
| | | //å¦æç©æä¿¡æ¯ä¸åå¨ï¼è·³è¿æ´ä¸ªå
¥åºå |
| | | if (materielInfo == null) |
| | | { |
| | | skipOrder = true; |
| | | Console.WriteLine($"è·³è¿å
¥åºå {order.order_no}ï¼åå ï¼æªæ¾å°åå [{item.goods_no}] çç©æä¿¡æ¯ã"); |
| | | break; |
| | | } |
| | | |
| | | // è¥ç©æä¸å卿 MaterielSourceType 为空ï¼åè·³è¿æ´ä¸ªå
¥åºå |
| | | if (materielInfo == null || !Enum.IsDefined(typeof(MaterielSourceTypeEnum), materielInfo.MaterielSourceType)) |
| | | { |
| | | skipOrder = true; |
| | | break; |
| | | } |
| | | //Dt_MedicineGoods materielInfo = BaseDal.Db.Queryable<Dt_MedicineGoods>().Where(x => x.Goods_no == item.goods_no).First(); |
| | | ///æ ¹æ®ç©æä¿¡æ¯å¤§å°ä»¶å±æ§åºåæ¯å¦å
¥ç«åº //大件å
¥å¹³åº |
| | | if (materielInfo.MaterielSourceType == MaterielSourceTypeEnum.PurchasePart) |
| | | { |
| | | Dt_CabinOrderDetail orderDetail = new Dt_CabinOrderDetail() |
| | | { |
| | | Reservoirarea= order.warehouse_no, |
| | | Reservoirarea = order.warehouse_no, |
| | | Goods_no = item.goods_no, |
| | | Order_qty = item.order_qty, |
| | | Batch_num = item.batch_num, |
| | |
| | | else |
| | | { |
| | | Dt_CabinOrderDetail orderDetail = null; |
| | | var ys = item.order_qty % materielInfo.BoxQty; |
| | | var xs = item.order_qty / materielInfo.BoxQty; |
| | | var ys = item.order_qty % materielInfo.BoxQty; //ä¸è½æ´é¤ç®±è§çæ£ä»¶æ° |
| | | var xs = item.order_qty / materielInfo.BoxQty;//æ´ç®±æ°é |
| | | #region çæç«åºå
¥åºå |
| | | |
| | | #region 夿æ¯å¦ææ£ä»¶ |
| | |
| | | { |
| | | orderDetail = new Dt_CabinOrderDetail() |
| | | { |
| | | Reservoirarea = order.warehouse_no, |
| | | Goods_no = item.goods_no, |
| | | Order_qty = ys, |
| | | Batch_num = item.batch_num, |
| | |
| | | { |
| | | orderDetail = new Dt_CabinOrderDetail() |
| | | { |
| | | Reservoirarea = order.warehouse_no, |
| | | Goods_no = item.goods_no, |
| | | Order_qty = materielInfo.BoxQty, |
| | | Batch_num = item.batch_num, |
| | |
| | | { |
| | | orderDetail = new Dt_CabinOrderDetail() |
| | | { |
| | | Reservoirarea = order.warehouse_no, |
| | | Goods_no = item.goods_no, |
| | | Order_qty = materielInfo.BoxQty * xs, |
| | | Batch_num = item.batch_num, |
| | |
| | | #endregion |
| | | } |
| | | _basicService.MaterielInfoService.Repository.UpdateData(materielInfo); |
| | | //_medicineGoodsServices.Db.Updateable(materielInfo).ExecuteCommand(); |
| | | #endregion |
| | | } |
| | | // âå¦æè·³è¿è¯¥åï¼åç´æ¥continueï¼ä¸ä¿å |
| | | if (skipOrder) |
| | | { |
| | | Console.WriteLine($"è·³è¿å
¥åºå {order.order_no}ï¼å 为å卿ªå®ä¹ç©æå±æ§çååã"); |
| | | continue; |
| | | } |
| | | _CabinOrders.Add(entityOrder); |
| | | orderNos.Add(order.order_no); |
| | |
| | | catch (Exception ex) |
| | | { |
| | | // å
¨å±å¼å¸¸æ¶ï¼ä¹æ¨éå¼å¸¸ç»ä¸æ¸¸ |
| | | SendErrorToUpstream(1, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 对没æè¿è¡ç»´æ¤ååä¿¡æ¯è¡¨çå
¥åºåè¿è¡è¿æ»¤å¤ç |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | public WebResponseContent GetUpstreamOrder2() |
| | | { |
| | | var responseContent = new WebResponseContent(); |
| | | try |
| | | { |
| | | // 请æ±å°å |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/inOrder"; |
| | | //if (string.IsNullOrEmpty(SearchDate)) SearchDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | //// 请æ±åæ° |
| | | var requestData = new |
| | | { |
| | | //searchDate = SearchDate |
| | | searchDate = "2020-10-10 20:45:16" // æ£ç¡®çæ ¼å¼ |
| | | }; |
| | | //SearchDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss"); |
| | | |
| | | var result = HttpHelper.Post(url, requestData.ToJsonString()); |
| | | var response = JsonConvert.DeserializeObject<UpstreamResponse<UpstreamOrderInfo>>(result); |
| | | |
| | | if (response.resultCode != "0") |
| | | { |
| | | SendErrorToUpstream(1, "", response.resultMsg ?? "䏿¸¸æ¥å£è¿å失败", ""); |
| | | return responseContent.Error(response.resultMsg ?? "䏿¸¸æ¥å£è¿å失败"); |
| | | } |
| | | |
| | | if (response.data == null || !response.data.Any()) |
| | | return responseContent.OK("æ æ°å
¥åºåæ°æ®"); |
| | | |
| | | var existingOrderNos = BaseDal.Db.Queryable<Dt_CabinOrder>() |
| | | .Select(x => x.Order_no) |
| | | .ToList(); |
| | | |
| | | var newOrders = response.data |
| | | .Where(order => !existingOrderNos.Contains(order.order_no)) |
| | | .ToList(); |
| | | |
| | | if (!newOrders.Any()) |
| | | return responseContent.OK("ææå
¥åºåå·²åå¨ï¼æ éæ°å¢"); |
| | | |
| | | Db.Ado.BeginTran(); |
| | | try |
| | | { |
| | | List<Dt_CabinOrder> _CabinOrders = new(); |
| | | List<string> orderNos = new(); |
| | | |
| | | foreach (var order in newOrders) |
| | | { |
| | | bool skipOrder = false; // æ è®°æ¯å¦è·³è¿è¯¥å
¥åºå |
| | | 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 = new List<Dt_CabinOrderDetail>() |
| | | }; |
| | | |
| | | foreach (var item in order.details) |
| | | { |
| | | item.order_qty = Math.Abs(item.order_qty); |
| | | |
| | | // æ¥è¯¢ç©æä¿¡æ¯ |
| | | var materielInfo = BaseDal.Db.Queryable<Dt_MedicineGoods>() |
| | | .Where(x => x.Goods_no == item.goods_no) |
| | | .First(); |
| | | |
| | | |
| | | //å¦æç©æä¿¡æ¯ä¸åå¨ï¼è·³è¿æ´ä¸ªå
¥åºå |
| | | if (materielInfo == null) |
| | | { |
| | | skipOrder = true; |
| | | Console.WriteLine($"è·³è¿å
¥åºå {order.order_no}ï¼åå ï¼æªæ¾å°åå [{item.goods_no}] çç©æä¿¡æ¯ã"); |
| | | break; |
| | | } |
| | | |
| | | // è¥ç©æä¸å卿 MaterielSourceType 为空ï¼åè·³è¿æ´ä¸ªå
¥åºå |
| | | if (materielInfo == null || !Enum.IsDefined(typeof(MaterielSourceTypeEnum), materielInfo.MaterielSourceType)) |
| | | { |
| | | skipOrder = true; |
| | | break; |
| | | } |
| | | |
| | | // åºå大件/å°ä»¶ |
| | | if (materielInfo.MaterielSourceType == MaterielSourceTypeEnum.PurchasePart) |
| | | { |
| | | var detail = new Dt_CabinOrderDetail |
| | | { |
| | | Reservoirarea = order.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(detail); |
| | | } |
| | | else |
| | | { |
| | | Dt_CabinOrderDetail orderDetail = null; |
| | | var ys = item.order_qty % materielInfo.BoxQty; // ä¸è½æ´é¤çæ£ä»¶ |
| | | var xs = item.order_qty / materielInfo.BoxQty; // æ´ç®±æ°é |
| | | |
| | | // ææ£ä»¶ |
| | | if (ys > 0) |
| | | { |
| | | orderDetail = new Dt_CabinOrderDetail |
| | | { |
| | | Reservoirarea = order.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; |
| | | } |
| | | |
| | | // ä¸è¶³æä½åºåæ¶è¡¥å
¥ç«åº |
| | | while (materielInfo.Business_qty < materielInfo.MinQty && xs > 0) |
| | | { |
| | | xs--; |
| | | if (orderDetail == null) |
| | | { |
| | | orderDetail = new Dt_CabinOrderDetail |
| | | { |
| | | Reservoirarea = order.warehouse_no, |
| | | Goods_no = item.goods_no, |
| | | Order_qty = materielInfo.BoxQty, |
| | | Batch_num = item.batch_num, |
| | | Exp_date = item.exp_date, |
| | | OrderDetailStatus = "æ°å»º", |
| | | Status = 0 |
| | | }; |
| | | } |
| | | else |
| | | { |
| | | orderDetail.Order_qty += materielInfo.BoxQty; |
| | | } |
| | | materielInfo.Business_qty += materielInfo.BoxQty; |
| | | } |
| | | |
| | | if (orderDetail != null) entityOrder.Details.Add(orderDetail); |
| | | |
| | | // å©ä½æ´ç®±å
¥å¹³åº |
| | | if (xs > 0) |
| | | { |
| | | entityOrder.Details.Add(new Dt_CabinOrderDetail |
| | | { |
| | | Reservoirarea = order.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 |
| | | }); |
| | | } |
| | | } |
| | | |
| | | _medicineGoodsServices.Db.Updateable(materielInfo).ExecuteCommand(); |
| | | } |
| | | |
| | | // âå¦æè·³è¿è¯¥åï¼åç´æ¥continueï¼ä¸ä¿å |
| | | if (skipOrder) |
| | | { |
| | | Console.WriteLine($"è·³è¿å
¥åºå {order.order_no}ï¼å 为å卿ªå®ä¹ç©æå±æ§çååã"); |
| | | continue; |
| | | } |
| | | |
| | | _CabinOrders.Add(entityOrder); |
| | | orderNos.Add(order.order_no); |
| | | } |
| | | |
| | | if (_CabinOrders.Any()) |
| | | { |
| | | BaseDal.Db.InsertNav(_CabinOrders).Include(x => x.Details).ExecuteCommand(); |
| | | Db.Ado.CommitTran(); |
| | | return responseContent.OK($"æå忥 {_CabinOrders.Count} æ¡å
¥åºå"); |
| | | } |
| | | else |
| | | { |
| | | Db.Ado.RollbackTran(); |
| | | return responseContent.OK("æ å¯å¤ççå
¥åºåï¼åå屿§æªå®ä¹ææªæ¾å°ï¼"); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Db.Ado.RollbackTran(); |
| | | SendErrorToUpstream(1, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | SendErrorToUpstream(1, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | |
| | | string materialCode = "YY";//é»è®¤å¼ |
| | | //è·åå½å订åç第ä¸ä¸ªæç»é¡¹ |
| | | var firstDetail = order.Details.FirstOrDefault(); |
| | | if (firstDetail?.MedicineGoods != null && !string.IsNullOrEmpty(firstDetail.MedicineGoods.MaterialCode)) |
| | | if (firstDetail?.MedicineGoods != null && !string.IsNullOrEmpty(firstDetail.MedicineGoods.MaterielErpType)) |
| | | { |
| | | //妿æ¡ä»¶æ»¡è¶³ï¼å°ç©æä»£ç 设置为第ä¸ä¸ªæç»é¡¹å¯¹åºçè¯åç©æä»£ç |
| | | materialCode = firstDetail.MedicineGoods.MaterialCode; |
| | | materialCode = firstDetail.MedicineGoods.MaterielErpType; |
| | | } |
| | | |
| | | var ediDto = new ToediInInfo |
| | |
| | | //产å |
| | | productCode = d.Goods_no, |
| | | //skuåç§° |
| | | productName = d.MedicineGoods?.Goods_spm, |
| | | productName = d.MedicineGoods?.MaterielName, |
| | | //skuè§æ ¼ |
| | | productSpecifications = d.MedicineGoods?.Model, |
| | | productSpecifications = d.MedicineGoods?.MaterielSpec, |
| | | //æ°é |
| | | quantity = (int)d.Order_qty, |
| | | //ææ |