| | |
| | | using static WIDESEA_DTO.SquareCabin.TowcsDto; |
| | | using WIDESEA_Common.WareHouseEnum; |
| | | using WIDESEA_DTO.SquareCabin; |
| | | using WIDESEA_Common; |
| | | using System.Xml.Linq; |
| | | using WIDESEA_Common.OrderEnum; |
| | | using static WIDESEA_DTO.SquareCabin.AlarmDto; |
| | | using OfficeOpenXml.Style; |
| | | using System.Security.Policy; |
| | | |
| | | namespace WIDESEA_WMSServer |
| | | namespace WIDESEA_SquareCabinServices |
| | | { |
| | | public class Business : IBusiness |
| | | public partial class Business : IBusiness |
| | | { |
| | | private readonly ICabinOrderServices _cabinOrderServices; |
| | | private readonly ICabinOrderDetailServices _cabinDetailServices; |
| | | private readonly IDeliveryOrderServices _deliveryOrderServices; |
| | | private readonly IDeliveryOrderDetailServices _deliveryOrderDetailServices; |
| | | private readonly IBasicService _basicService; |
| | | private readonly IMaterielInfoService _materielInfoService; |
| | | private readonly IMessageInfoService _messageInfoService; |
| | | private readonly IUnitOfWorkManage _unitOfWorkManage; |
| | | private readonly IInventory_BatchServices _inventory_BatchServices; |
| | | private readonly IInventoryInfoService _inventoryInfoService; |
| | | private readonly ISupplyTaskService _supplyTaskService; |
| | | private readonly ITacticsService _tacticsService; |
| | | public Business(IDeliveryOrderServices deliveryOrderServices, IBasicService basicService, IUnitOfWorkManage unitOfWorkManage, IInventory_BatchServices inventory_BatchServices, IInventoryInfoService inventoryInfoService, IDeliveryOrderDetailServices deliveryOrderDetailServices, ISupplyTaskService supplyTaskService, ICabinOrderServices cabinOrderServices, ITacticsService tacticsService, ICabinOrderDetailServices cabinDetailServices) |
| | | public Business(IDeliveryOrderServices deliveryOrderServices, IUnitOfWorkManage unitOfWorkManage, IDeliveryOrderDetailServices deliveryOrderDetailServices, ICabinOrderServices cabinOrderServices, ICabinOrderDetailServices cabinDetailServices, IMaterielInfoService materielInfoService, IMessageInfoService messageInfoService) |
| | | { |
| | | _deliveryOrderServices = deliveryOrderServices; |
| | | _basicService = basicService; |
| | | _unitOfWorkManage = unitOfWorkManage; |
| | | _inventory_BatchServices = inventory_BatchServices; |
| | | _inventoryInfoService = inventoryInfoService; |
| | | _deliveryOrderDetailServices = deliveryOrderDetailServices; |
| | | _supplyTaskService = supplyTaskService; |
| | | _cabinOrderServices = cabinOrderServices; |
| | | _tacticsService = tacticsService; |
| | | _cabinDetailServices = cabinDetailServices; |
| | | _materielInfoService = materielInfoService; |
| | | _messageInfoService = messageInfoService; |
| | | } |
| | | #region è·åERPå
¥åºå |
| | | static string SearchInDate = "2025-09-10 00:00:00"; |
| | | /// <summary> |
| | | /// è·å䏿¸¸ç³»ç»çå
¥åºå |
| | | /// </summary> |
| | | /// <param name="SearchInDate"></param> |
| | | /// <returns></returns> |
| | | public WebResponseContent GetUpstreamOrder() |
| | | { |
| | | var responseContent = new WebResponseContent(); |
| | | try |
| | | { |
| | | // 请æ±å°å |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/inOrder"; |
| | | //var url = "http://127.0.0.1:4523/m2/5660322-5340849-default/363009261"; |
| | | |
| | | if (string.IsNullOrEmpty(SearchInDate)) SearchInDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | //// 请æ±åæ° |
| | | var requestData = new |
| | | { |
| | | searchDate = SearchInDate |
| | | //searchDate = "2022-10-10 20:45:16" // æ£ç¡®çæ ¼å¼ |
| | | }; |
| | | SearchInDate = 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 = _cabinOrderServices.Db.Queryable<Dt_CabinOrder>() |
| | | .Select(x => x.Order_no) |
| | | .Distinct().ToList(); |
| | | |
| | | // è¿æ»¤æå·²åå¨çå
¥åºå |
| | | var newOrders = response.data |
| | | .Where(order => !existingOrderNos.Contains(order.order_no)) |
| | | .ToList(); |
| | | |
| | | if (!newOrders.Any()) |
| | | { |
| | | return responseContent.OK("ææå
¥åºåå·²åå¨ï¼æ éæ°å¢"); |
| | | } |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | try |
| | | { |
| | | List<Dt_CabinOrder> _CabinOrders = new List<Dt_CabinOrder>(); |
| | | //åå¨å
¥åºåå· |
| | | List<string> orderNos = new List<string>(); |
| | | |
| | | foreach (var order in newOrders) |
| | | { |
| | | if (order.order_type == "1") //æ£å¸¸å
¥åº |
| | | { |
| | | responseContent = _cabinOrderServices.CreateInboundOrder(order); |
| | | List<Dt_CabinOrder>? dt_CabinOrders = responseContent.Data as List<Dt_CabinOrder>; |
| | | if (dt_CabinOrders != null) _CabinOrders.AddRange(dt_CabinOrders); |
| | | } |
| | | else if (order.order_type == "3")//å
¥åºéæ |
| | | { |
| | | //å建åºåºå |
| | | #region 转æ¢ä¸ºåºåºå |
| | | UpstramOutOrderInfo upstramOutOrderInfo = new UpstramOutOrderInfo() |
| | | { |
| | | order_no = order.order_no, |
| | | order_type = order.order_type, |
| | | warehouse_no = order.warehouse_no, |
| | | details = new List<UpstreamOutOrderDetail>() |
| | | }; |
| | | foreach (var item in order.details) |
| | | { |
| | | UpstreamOutOrderDetail detail = new UpstreamOutOrderDetail() |
| | | { |
| | | batch_num = item.batch_num, |
| | | goods_no = item.goods_no, |
| | | order_qty = item.order_qty, |
| | | exp_date = item.exp_date, |
| | | }; |
| | | upstramOutOrderInfo.details.Add(detail); |
| | | } |
| | | _deliveryOrderServices.CreateOutboundOrder(upstramOutOrderInfo); |
| | | #endregion |
| | | } |
| | | else if (order.order_type == "5")//æ¥æº¢å
¥åº |
| | | { |
| | | _cabinOrderServices.CreateCheckInOrder(order); |
| | | } |
| | | }; |
| | | _cabinOrderServices.Db.InsertNav(_CabinOrders).Include(x => x.Details).ExecuteCommand(); |
| | | |
| | | //å¨ä¸åç»wcs |
| | | //EdiIn(); //åç»ä¸æ¸¸ |
| | | //妿è¿ä¸ªæ¹æ³æåäºï¼é£ä¹å°±è°ç¨CompleteOrderæ¥å£ï¼ç¶åæ¹å |
| | | _unitOfWorkManage.CommitTran(); |
| | | return responseContent.OK("忥å
¥åºåæå"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | SendErrorToUpstream(1, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | // å
¨å±å¼å¸¸æ¶ï¼ä¹æ¨éå¼å¸¸ç»ä¸æ¸¸ |
| | | SendErrorToUpstream(1, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region è·åERPåºåºå |
| | | static string SearchOutDate = "2025-09-10 00:00:00"; |
| | | public WebResponseContent GetUpstreamOutOrder() |
| | | { |
| | | var responseContent = new WebResponseContent(); |
| | | try |
| | | { |
| | | //var url = "http://121.37.118.63:80/GYZ2/95fck/outOrder"; |
| | | var url = "http://127.0.0.1:4523/m1/5660322-5340849-default/GYZ2/95fck/outOrder"; |
| | | if (string.IsNullOrEmpty(SearchOutDate)) SearchOutDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | //// 请æ±åæ° |
| | | var requestData = new |
| | | { |
| | | searchDate = SearchOutDate |
| | | //searchDate = "2022-10-10 20:45:16" // æ£ç¡®çæ ¼å¼ |
| | | }; |
| | | SearchOutDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss"); |
| | | |
| | | var result = HttpHelper.Post(url, requestData.ToJsonString()); |
| | | var response = JsonConvert.DeserializeObject<UpstreamResponse<UpstramOutOrderInfo>>(result); |
| | | |
| | | if (response.resultCode != "0") |
| | | { |
| | | SendErrorToUpstream(3, "", response.resultMsg ?? "䏿¸¸æ¥å£è¿å失败", ""); |
| | | return responseContent.Error(response.resultMsg ?? "䏿¸¸æ¥å£è¿å失败"); |
| | | } |
| | | |
| | | if (response.data == null || !response.data.Any()) |
| | | { |
| | | return responseContent.OK("æ æ°åºåºåæ°æ®"); |
| | | } |
| | | |
| | | // å·²åå¨åºåºåå· |
| | | var existingOutOrderNos = _deliveryOrderServices.Db.Queryable<Dt_DeliveryOrder>() |
| | | .Select(x => x.Out_no) |
| | | .Distinct().ToList(); |
| | | |
| | | // æ°åºåºå |
| | | var newOutOrders = response.data |
| | | .Where(outorder => !existingOutOrderNos.Contains(outorder.order_no)) |
| | | .ToList(); |
| | | |
| | | List<string> order_no = newOutOrders.Select(x => x.order_no).ToList(); |
| | | |
| | | if (!newOutOrders.Any()) |
| | | { |
| | | return responseContent.OK("ææåºåºåå·²åå¨ï¼æ éæ°å¢"); |
| | | } |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | try |
| | | { |
| | | List<Dt_DeliveryOrder> _DeliveryOrders = new List<Dt_DeliveryOrder>(); |
| | | List<string> orderNos = new List<string>(); |
| | | |
| | | foreach (var outorder in newOutOrders) |
| | | { |
| | | if (outorder.order_type == "1") // æ£å¸¸åºåºå |
| | | { |
| | | _deliveryOrderServices.CreateOutboundOrder(outorder);//å建åºåºåãå¤çåºåãæ·»å åºåºä»»å¡ |
| | | } |
| | | else if (outorder.order_type == "2")//åºåºéè´§ |
| | | { |
| | | // å建åºåºéè´§å - è¿ééè¦æ ¹æ®ä¸å¡é»è¾å®ç° |
| | | // ææ¶è·³è¿æå®ç°éè´§é»è¾ |
| | | //continue; |
| | | #region è½¬æ¢æå
¥åºå |
| | | UpstreamOrderInfo order = new UpstreamOrderInfo() |
| | | { |
| | | order_no = outorder.order_no, |
| | | order_type = outorder.order_type, |
| | | warehouse_no = outorder.warehouse_no, |
| | | details = new List<UpstreamOrderDetail>() |
| | | }; |
| | | foreach (var item in outorder.details) |
| | | { |
| | | UpstreamOrderDetail detail = new UpstreamOrderDetail() |
| | | { |
| | | batch_num = item.batch_num, |
| | | goods_no = item.goods_no, |
| | | order_qty = item.order_qty, |
| | | exp_date = item.exp_date, |
| | | }; |
| | | order.details.Add(detail); |
| | | } |
| | | responseContent = _cabinOrderServices.CreateInboundOrder(order); |
| | | List<Dt_CabinOrder>? dt_CabinOrders = responseContent.Data as List<Dt_CabinOrder>; |
| | | if (dt_CabinOrders != null && dt_CabinOrders.Count > 0) |
| | | _cabinOrderServices.Db.InsertNav(dt_CabinOrders).Include(x => x.Details).ExecuteCommand(); |
| | | #endregion |
| | | } |
| | | else if (outorder.order_type == "6")//æ¥æåºåº |
| | | { |
| | | _deliveryOrderServices.CreateCheckOutOrder(outorder); |
| | | } |
| | | } |
| | | |
| | | // æ¹éæå
¥åºåºååæç» |
| | | //if (_DeliveryOrders.Any()) |
| | | //{ |
| | | // BaseDal.Db.InsertNav(_DeliveryOrders).Include(x => x.Details).ExecuteCommand(); |
| | | //} |
| | | //ä¸ååºåºåä»»å¡ç»wcs |
| | | |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | //var tex = CreateSupplyTask(order_no); |
| | | //if (!tex) |
| | | //{ |
| | | // return responseContent.Error("å建ä¾åºä»»å¡å¤±è´¥"); |
| | | //} |
| | | return responseContent.OK($"忥åºåºåæåï¼å
±{_DeliveryOrders.Count}æ¡"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | SendErrorToUpstream(3, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | SendErrorToUpstream(3, "", ex.Message, ""); |
| | | return responseContent.Error("åæ¥å¤±è´¥: " + ex.Message); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ä¸åç«åºå
¥åºå |
| | | public WebResponseContent EdiIn() |
| | | { |
| | | try |
| | | { |
| | | //2.æ¥è¯¢ç¬¦åæ¡ä»¶ç订åï¼è¡¨å¤´ = æ°å»º && å
嫿ææç»ï¼ |
| | | //var orders = BaseDal.Db.Queryable<Dt_CabinOrder>() |
| | | // .Where(o => o.OdrderStatus == "æ°å»º") |
| | | // .Includes(o => o.Details, d => d.MedicineGoods) |
| | | // .ToList(); |
| | | //æ¥åºå
å«å
¨é¨çå
¥åºåï¼å
å«å
¨é¨æç»+ä¸ä¸ªæç»å¯¹åºä¸ä¸ªåå |
| | | var reslut = WarehouseEnum.ç«åº.ObjToInt().ToString("000"); |
| | | var orders = _cabinOrderServices.Db.CopyNew() |
| | | .Queryable<Dt_CabinOrder>() |
| | | .Where(o => o.OdrderStatus == "æ°å»º" && o.Warehouse_no == reslut) |
| | | .Includes(o => o.Details, d => d.MedicineGoods) |
| | | .ToList(); |
| | | // 3. åè¿æ»¤æä¸ç¬¦åæ¡ä»¶çæç»ï¼åªä¿ç Status=0ï¼ |
| | | var orders = _cabinOrderServices.Repository.QueryData(x => x.OdrderStatus == "æ°å»º" && x.Warehouse_no == reslut); |
| | | if (orders.Count < 1) return WebResponseContent.Instance.OK(); |
| | | string url = "http://172.16.1.2:9357/file-admin/api/in/ediIn"; |
| | | var cabinOrderDetails = _cabinDetailServices.Repository.QueryData(x => orders.Select(x => x.Id).ToList().Contains(x.OrderId)); |
| | | var materielInfos = _materielInfoService.Repository.QueryData(x => cabinOrderDetails.Select(x => x.Goods_no).Contains(x.MaterielCode)); |
| | | foreach (var order in orders) |
| | | { |
| | | Console.WriteLine($"订å {order.Order_no} åæç»æ°ï¼{order.Details.Count}"); |
| | | order.Details = order.Details.Where(d => d.Status == 0).ToList(); |
| | | Console.WriteLine($"订å {order.Order_no} è¿æ»¤åæç»æ°ï¼{order.Details.Count}"); |
| | | } |
| | | |
| | | |
| | | if (orders == null || !orders.Any()) |
| | | { |
| | | Console.WriteLine("没æç¬¦åæ¡ä»¶ç订åéè¦æ¨é"); |
| | | return WebResponseContent.Instance.Error("没æç¬¦åæ¡ä»¶ç订åéè¦æ¨é"); |
| | | } |
| | | |
| | | // 4. éå订åï¼ç»è£
DTO å¹¶æ¨é |
| | | foreach (var order in orders) |
| | | { |
| | | // ä»ç¬¬ä¸ä¸ªæ MedicineGoods çæç»ä¸ååº MaterielErpType |
| | | string materialCode = order.Details |
| | | .Select(d => d.MedicineGoods?.MaterielErpType) |
| | | .FirstOrDefault(x => !string.IsNullOrEmpty(x)) ?? "YY"; // é»è®¤å¼YY |
| | | |
| | | order.Details = cabinOrderDetails.Where(x => x.OrderId == order.Id).ToList(); |
| | | foreach (var item in order.Details) |
| | | { |
| | | item.MedicineGoods = materielInfos.Where(x => x.MaterielCode == item.Goods_no).First(); |
| | | } |
| | | #region ä¸åWCS |
| | | string materialCode = order.Details.FirstOrDefault()?.MedicineGoods?.MaterielErpType ?? "YY"; |
| | | var ediDto = new ToediInInfo |
| | | { |
| | | |
| | | //客æ·ä»£ç |
| | | customerCode = "905", |
| | | //ç©æç±»å |
| | |
| | | //产å |
| | | productCode = d.Goods_no, |
| | | //skuåç§° |
| | | productName = d.MedicineGoods?.MaterielName, |
| | | productName = d.MedicineGoods.MaterielName, |
| | | //skuè§æ ¼ |
| | | productSpecifications = d.MedicineGoods?.MaterielSpec, |
| | | productSpecifications = d.MedicineGoods.MaterielSpec, |
| | | //æ°é |
| | | quantity = (int)d.Order_qty, |
| | | //ææ |
| | | validityPeriod = d.Exp_date, |
| | | //ç产åå®¶ |
| | | manufacturer = d.MedicineGoods?.Factory, |
| | | manufacturer = d.MedicineGoods.Factory, |
| | | //æ¿å· |
| | | libraryNo = order.Warehouse_no, |
| | | }).ToList() |
| | | }; |
| | | |
| | | var url = "http://172.16.1.2:9357/file-admin/api/in/ediIn"; |
| | | //var url = "http://127.0.0.1:4523/m2/5660322-5340849-default/363019549"; |
| | | var result = HttpHelper.Post(url, ediDto.ToJsonString()); |
| | | var resp = JsonConvert.DeserializeObject<TowcsResponse<object>>(result); |
| | | |
| | | if (resp != null && resp.code == "0") |
| | | { |
| | | // æ´æ°è¡¨å¤´ç¶æ |
| | | _cabinOrderServices.Db.Updateable<Dt_CabinOrder>() |
| | | .SetColumns(o => new Dt_CabinOrder { OdrderStatus = "å¼å§" }) |
| | | .Where(o => o.Id == order.Id) |
| | | .ExecuteCommand(); |
| | | |
| | | // æ´æ°æç»ç¶æä¸ºå·²åæ¥ //è¿éè¦æ¯å°æ°å»º--ãå¼å§ç¶æ,å¨å端æ¥å£è¿åæä»¬çæ¶åå¨è¿å已宿 |
| | | _cabinDetailServices.Db.Updateable<Dt_CabinOrderDetail>() |
| | | .SetColumns(d => new Dt_CabinOrderDetail { Status = 1, OrderDetailStatus = "å¼å§" }) |
| | | .Where(d => d.OrderId == order.Id && d.Status == 0) |
| | | .ExecuteCommand(); |
| | | |
| | | Console.WriteLine($"订å {order.Order_no} æ¨éæå"); |
| | | order.OdrderStatus = "å¼å§"; |
| | | foreach (var item in cabinOrderDetails.Where(x => x.OrderId == order.Id)) |
| | | { |
| | | item.Status = 1; |
| | | item.OrderDetailStatus = "å¼å§"; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | SendErrorToUpstream(3, order.Order_no, resp?.msg ?? "WCS æ¨é失败", ""); |
| | | Console.WriteLine($"订å {order.Order_no} æ¨é失败ï¼{resp?.msg}"); |
| | | return new WebResponseContent { Status = false, Message = "è®¢åæ¨é失败" }; |
| | | } |
| | | #endregion |
| | | } |
| | | return new WebResponseContent { Status = true, Message = "æ¨éæå" }; |
| | | _cabinOrderServices.UpdateData(orders); |
| | | _cabinDetailServices.UpdateData(cabinOrderDetails); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | Console.WriteLine("EdiIn å¼å¸¸ï¼" + ex.Message); |
| | | return new WebResponseContent { Status = false, Message = ex.Message }; |
| | | Console.WriteLine("ä¸åWCSå
¥åºåå¼å¸¸ï¼" + ex.Message); |
| | | return WebResponseContent.Instance.Error(ex.Message); |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | #region ä¸åç«åºåºåºå |
| | | public WebResponseContent EdiOut() |
| | | { |
| | | var responseContent = new WebResponseContent(); |
| | | var WarehouseLk = WarehouseEnum.ç«åº.ObjToInt().ToString("000"); |
| | | try |
| | | { |
| | | // 1. æ¥è¯¢ç¬¦åæ¡ä»¶ç订åï¼è¡¨å¤´=æ°å»º && å
嫿ææç»ï¼ |
| | | var outOrders = _deliveryOrderServices.Db.CopyNew().Queryable<Dt_DeliveryOrder>() |
| | | .Where(o => o.OutStatus == "æ°å»º" && o.Warehouse_no == WarehouseLk) |
| | | .Includes(o => o.Details, d => d.MedicineGoods) |
| | | .ToList(); |
| | | |
| | | // 2. åè¿æ»¤æä¸ç¬¦åæ¡ä»¶çæç»ï¼åªä¿ç Status=0 ï¼ |
| | | foreach (var order in outOrders) |
| | | var reslut = WarehouseEnum.ç«åº.ObjToInt().ToString("000"); |
| | | var orders = _deliveryOrderServices.Repository.QueryData(x => x.OutStatus == "æ°å»º" && x.Warehouse_no == reslut); |
| | | if (orders.Count < 1) return WebResponseContent.Instance.OK(); |
| | | string url = "http://172.16.1.2:9357/file-admin/api/out/ediOut"; |
| | | var deliveryOrderDetails = _deliveryOrderDetailServices.Repository.QueryData(x => orders.Select(x => x.Id).ToList().Contains(x.DeliveryOrderId)); |
| | | var materielInfos = _materielInfoService.Repository.QueryData(x => deliveryOrderDetails.Select(x => x.Goods_no).Contains(x.MaterielCode)); |
| | | foreach (var order in orders) |
| | | { |
| | | order.Details = order.Details.Where(d => d.Status == 0).ToList(); |
| | | } |
| | | |
| | | if (outOrders == null || !outOrders.Any()) |
| | | { |
| | | Console.WriteLine("没æç¬¦åæ¡ä»¶ç订åéè¦æ¨é"); |
| | | return responseContent.Error("没æç¬¦åæ¡ä»¶ç订åéè¦æ¨é"); |
| | | } |
| | | |
| | | foreach (var order in outOrders) |
| | | { |
| | | try |
| | | order.Details = deliveryOrderDetails.Where(x => x.DeliveryOrderId == order.Id).ToList(); |
| | | foreach (var item in order.Details) |
| | | { |
| | | string materialCode = "YY";//é»è®¤å¼ |
| | | //è·åå½å订åç第ä¸ä¸ªæç»é¡¹ |
| | | var firstDetail = order.Details.FirstOrDefault(); |
| | | if (firstDetail?.MedicineGoods != null && !string.IsNullOrEmpty(firstDetail.MedicineGoods.MaterielErpType)) |
| | | { |
| | | //妿æ¡ä»¶æ»¡è¶³ï¼å°ç©æä»£ç 设置为第ä¸ä¸ªæç»é¡¹å¯¹åºçè¯åç©æä»£ç |
| | | materialCode = firstDetail.MedicineGoods.MaterielErpType; |
| | | } |
| | | switch (order.Out_type) |
| | | { |
| | | case "1"://æ£å¸¸åºåº |
| | | case "3"://å
¥åºéè´§ |
| | | order.Out_type = "10";//ä¸è¬äº¤æåºåºå |
| | | break; |
| | | case "6"://çäºåºåº |
| | | order.Out_type = "30";//çäºåºåºå |
| | | break; |
| | | } |
| | | // 3. ç»è£
DTO |
| | | var ediDto = new TowcsDto.ToediOutInfo |
| | | { |
| | | customerCode = "905", |
| | | materialCode = materialCode, |
| | | externalOrderNo = order.Out_no, |
| | | outOrderType = order.Out_type,//20æ¯çç¹åºåºå |
| | | priority = 1, |
| | | Is_cancel = 0, |
| | | details = order.Details.Select(d => new TowcsDto.ToeOutdiInDetail |
| | | { |
| | | batchNo = d.Batch_num, |
| | | productCode = d.Goods_no, |
| | | productName = d.MedicineGoods?.MaterielName, |
| | | productSpecifications = d.MedicineGoods?.MaterielModel, |
| | | quantity = (int)d.Order_qty, |
| | | //stocktakingDetails = order.Out_type == "3" |
| | | // ? new List<ToOutediInStock> |
| | | // { |
| | | // new ToOutediInStock { palletCode = "FC00001", quantity = d.Order_qty.ToString() } |
| | | // } |
| | | // : null |
| | | }).ToList() |
| | | }; |
| | | |
| | | // 4. è°ç¨æ¥å£ |
| | | //var url = "http://172.16.1.2:9357/file-admin/api/out/ediOut"; |
| | | var url = "http://127.0.0.1:4523/m2/5660322-5340849-default/363076920"; |
| | | |
| | | var result = HttpHelper.Post(url, ediDto.ToJsonString()); |
| | | var resp = JsonConvert.DeserializeObject<TowcsDto.TowcsResponse<object>>(result); |
| | | |
| | | if (resp != null && resp.code == "0") |
| | | { |
| | | // æ´æ°è¡¨å¤´ç¶æ |
| | | _cabinDetailServices.Db.Updateable<Dt_DeliveryOrder>() |
| | | .SetColumns(o => new Dt_DeliveryOrder { OutStatus = "å¼å§" }) |
| | | .Where(o => o.Id == order.Id) |
| | | .ExecuteCommand(); |
| | | |
| | | // æ´æ°æç»ç¶æ |
| | | _deliveryOrderDetailServices.Db.Updateable<Dt_DeliveryOrderDetail>() |
| | | .SetColumns(d => new Dt_DeliveryOrderDetail { Status = 1, OotDetailStatus = "å¼å§" }) |
| | | .Where(d => d.DeliveryOrderId == order.Id && d.Status == 0) |
| | | .ExecuteCommand(); |
| | | Console.WriteLine($"订å {order.Out_no} æ¨éæå"); |
| | | } |
| | | else |
| | | { |
| | | SendErrorToUpstream(3, order.Out_no, resp?.msg ?? "WCS æ¨é失败", ""); |
| | | Console.WriteLine($"订å {order.Out_no} æ¨é失败ï¼{resp?.msg}"); |
| | | } |
| | | //å é¤å
¨é¨ç¶ä¸ºå·²å®æçæç»å表头ï¼ç§»å
¥åå²è¡¨ |
| | | item.MedicineGoods = materielInfos.Where(x => x.MaterielCode == item.Goods_no).First(); |
| | | } |
| | | catch (Exception ex) |
| | | #region ä¸åWCS |
| | | string materialCode = order.Details.FirstOrDefault()?.MedicineGoods?.MaterielErpType ?? "YY"; |
| | | var ediDto = new ToediOutInfo |
| | | { |
| | | SendErrorToUpstream(3, order.Out_no, ex.Message, ""); |
| | | Console.WriteLine($"订å {order.Out_no} æ¨éå¼å¸¸ï¼{ex.Message}"); |
| | | //客æ·ä»£ç |
| | | customerCode = "905", |
| | | //ç©æç±»å |
| | | materialCode = materialCode, |
| | | externalOrderNo = order.Out_no, |
| | | outOrderType = order.Out_type, |
| | | priority = 1, |
| | | Is_cancel = 0, |
| | | details = order.Details.Select(d => new ToeOutdiInDetail |
| | | { |
| | | batchNo = d.Batch_num, |
| | | productCode = d.Goods_no, |
| | | productName = d.MedicineGoods.MaterielName, |
| | | productSpecifications = d.MedicineGoods.MaterielModel, |
| | | quantity = (int)d.Order_qty, |
| | | }).ToList() |
| | | }; |
| | | switch (order.Out_type) |
| | | { |
| | | case "1"://æ£å¸¸åºåº |
| | | case "3"://å
¥åºéè´§ |
| | | ediDto.outOrderType = "10";//ä¸è¬äº¤æåºåºå |
| | | break; |
| | | case "6"://çäºåºåº |
| | | ediDto.outOrderType = "30";//çäºåºåºå |
| | | break; |
| | | } |
| | | var result = HttpHelper.Post(url, ediDto.ToJsonString()); |
| | | var resp = JsonConvert.DeserializeObject<TowcsResponse<object>>(result); |
| | | if (resp != null && resp.code == "0") |
| | | { |
| | | order.OutStatus = "å¼å§"; |
| | | foreach (var item in deliveryOrderDetails.Where(x => x.DeliveryOrderId == order.Id)) |
| | | { |
| | | item.Status = 1; |
| | | item.OotDetailStatus = "å¼å§"; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | |
| | | return responseContent.OK("åºåºè®¢åæ¨é宿"); |
| | | _deliveryOrderServices.UpdateData(orders); |
| | | _deliveryOrderDetailServices.UpdateData(deliveryOrderDetails); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine("EdiOut å¼å¸¸ï¼" + ex.Message); |
| | | return responseContent.Error("åºåºè®¢åæ¨é失败ï¼" + ex.Message); |
| | | Console.WriteLine("ä¸åWCSåºåºåå¼å¸¸ï¼" + ex.Message); |
| | | return WebResponseContent.Instance.Error(ex.Message); |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | { |
| | | #region æ¥æ¾ææå·²å®æå
¥åºå |
| | | var inorders = _cabinOrderServices.Repository.QueryData(x => x.OdrderStatus == "已宿").Select(x => x.Order_no).Distinct().ToList(); |
| | | foreach (var inorder in inorders) |
| | | var Orders = _cabinOrderServices.Db.Queryable<Dt_CabinOrder>().Where(x => inorders.Contains(x.Order_no)).Includes(x => x.Details).ToList(); |
| | | List<Dt_CabinOrder> cabinOrders = new List<Dt_CabinOrder>(); |
| | | List<Dt_CabinOrderDetail> cabinOrderDetails = new List<Dt_CabinOrderDetail>(); |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/inOrderOk"; |
| | | foreach (var item in Orders.GroupBy(x => x.Order_no)) |
| | | { |
| | | //var Orders = BaseDal.QueryData(x => x.Order_no == inorder); |
| | | var Orders = _cabinOrderServices.Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == inorder).Includes(x => x.Details).ToList(); |
| | | if (!Orders.Where(x => x.OdrderStatus != "已宿").Any()) |
| | | if (!item.Where(x => x.OdrderStatus != "已宿").Any()) |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | _cabinOrderServices.Repository.DeleteAndMoveIntoHty(Orders, OperateTypeEnum.èªå¨å®æ); |
| | | foreach (var item in Orders) |
| | | if (item.First().Order_type == InOrderTypeEnum.Allocat.ObjToInt().ToString()) |
| | | { |
| | | _cabinDetailServices.Repository.DeleteAndMoveIntoHty(item.Details, OperateTypeEnum.èªå¨å®æ); |
| | | } |
| | | // è°ç¨ä¸æ¸¸æ¥å£ |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/inOrderOk"; |
| | | var result = HttpHelper.Post(url, new { order_no = inorder }.ToJsonString()); |
| | | var response = JsonConvert.DeserializeObject<UpstreamOrderResponse>(result); |
| | | if (response.resultCode == "0") |
| | | { |
| | | // æäº¤äºå¡ |
| | | _unitOfWorkManage.CommitTran(); |
| | | foreach (var a in item) |
| | | { |
| | | if (a.Details != null) cabinOrderDetails.AddRange(a.Details); |
| | | a.Details = null; |
| | | cabinOrders.Add(a); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | SendErrorToUpstream(2, "", $"䏿¸¸æ¥å£è¿å失败: {response.resultMsg}", inorder); |
| | | if (item.First().Order_type == "2") url = "http://121.37.118.63:80/GYZ2/95fck/outOrderOk";//åºåºéè´§ |
| | | var result = HttpHelper.Post(url, new { order_no = item.Key }.ToJsonString()); |
| | | var response = JsonConvert.DeserializeObject<UpstreamOrderResponse>(result); |
| | | if (response != null && response.resultCode == "0") |
| | | { |
| | | foreach (var a in item) |
| | | { |
| | | if (a.Details != null) cabinOrderDetails.AddRange(a.Details); |
| | | a.Details = null; |
| | | cabinOrders.Add(a); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | string mess = "䏿¥ERPæ ååº"; |
| | | if (response != null) mess = response.resultMsg; |
| | | _messageInfoService.AddMessageInfo(MessageGroupByEnum.InOrderAlarm, $"å
¥åºåå·ã{item.Key}ã宿䏿¥ERP失败", mess); |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | _cabinDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrderDetails, OperateTypeEnum.èªå¨å®æ); |
| | | _cabinOrderServices.Repository.DeleteAndMoveIntoHty(cabinOrders, OperateTypeEnum.èªå¨å®æ); |
| | | #endregion |
| | | return responseContent.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return responseContent.Error("æ¹éå¤ç失败ï¼" + ex.Message); |
| | | } |
| | | } |
| | |
| | | { |
| | | #region æ¥æ¾ææå·²å®æåºåºå |
| | | var outorders = _deliveryOrderServices.Repository.QueryData(x => x.OutStatus == "已宿").Select(x => x.Out_no).Distinct().ToList(); |
| | | foreach (var outorder in outorders) |
| | | var Orders = _deliveryOrderServices.Db.Queryable<Dt_DeliveryOrder>().Where(x => outorders.Contains(x.Out_no)).Includes(x => x.Details).ToList(); |
| | | List<Dt_DeliveryOrder> cabinOrders = new List<Dt_DeliveryOrder>(); |
| | | List<Dt_DeliveryOrderDetail> cabinOrderDetails = new List<Dt_DeliveryOrderDetail>(); |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/outOrderOk"; |
| | | foreach (var item in Orders.GroupBy(x => x.Out_no)) |
| | | { |
| | | var Orders = _deliveryOrderServices.Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == outorder).Includes(x => x.Details).ToList(); |
| | | if (!Orders.Where(x => x.OutStatus != "已宿").Any()) |
| | | if (!item.Where(x => x.OutStatus != "已宿").Any()) |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | _deliveryOrderServices.Repository.DeleteAndMoveIntoHty(Orders, OperateTypeEnum.èªå¨å®æ); |
| | | foreach (var item in Orders) |
| | | if (item.First().Out_type == OutOrderTypeEnum.Allocate.ObjToInt().ToString()) |
| | | { |
| | | _deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(item.Details, OperateTypeEnum.èªå¨å®æ); |
| | | foreach (var a in item) |
| | | { |
| | | if (a.Details != null) cabinOrderDetails.AddRange(a.Details); |
| | | a.Details = null; |
| | | cabinOrders.Add(a); |
| | | } |
| | | } |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/outOrderOk"; |
| | | var requestDate = new |
| | | { |
| | | order_no = outorder |
| | | }; |
| | | var result = HttpHelper.Post(url, requestDate.ToJsonString()); |
| | | var response = JsonConvert.DeserializeObject<UpstreamOrderResponse>(result); |
| | | if (response.resultCode == "0") _unitOfWorkManage.CommitTran(); |
| | | else |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | SendErrorToUpstream(4, "", $"䏿¸¸æ¥å£è¿å失败: {response.resultMsg}", outorder); |
| | | if (item.First().Out_type == "3") url = "http://121.37.118.63:80/GYZ2/95fck/inOrderOk";//å
¥åºéè´§ |
| | | var result = HttpHelper.Post(url, new { order_no = item.Key }.ToJsonString()); |
| | | var response = JsonConvert.DeserializeObject<UpstreamOrderResponse>(result); |
| | | if (response != null && response.resultCode == "0") |
| | | { |
| | | foreach (var a in item) |
| | | { |
| | | if (a.Details != null) cabinOrderDetails.AddRange(a.Details); |
| | | a.Details = null; |
| | | cabinOrders.Add(a); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | string mess = "䏿¥ERPæ ååº"; |
| | | if (response != null) mess = response.resultMsg; |
| | | _messageInfoService.AddMessageInfo(MessageGroupByEnum.InOrderAlarm, $"åºåºåå·ã{item.Key}ã宿䏿¥ERP失败", mess); |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | #endregion |
| | | _deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrderDetails, OperateTypeEnum.èªå¨å®æ); |
| | | _deliveryOrderServices.Repository.DeleteAndMoveIntoHty(cabinOrders, OperateTypeEnum.èªå¨å®æ); |
| | | |
| | | #endregion |
| | | return responseContent.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return responseContent.Error("æ¹éå¤ç失败ï¼" + ex.Message); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ¨éå¼å¸¸ä¸æ¥ERP |
| | | /// <summary> |
| | | /// æ¨éå¼å¸¸ä¿¡æ¯ç»ä¸æ¸¸ç³»ç»1.å
¥åºåæ¥å£ï¼2.å
¥åºåæ¥å®ææ¥å£ï¼3.åºåºåæ¥å£ï¼4.åºåºæ¥å®ææ¥å£ï¼5.è¯ååºç¡ä¿¡æ¯åæ¥æ¥å£ï¼6.ä¾åºåä¿¡æ¯æ¥å£ï¼7.客æ·ä¿¡æ¯æ¥å£ï¼8.åºå |
| | | /// </summary> |
| | | public void SendErrorToUpstream(int type, string code, string message, string remark) |
| | | { |
| | | try |
| | | { |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/lexceptionLogog"; |
| | | |
| | | var requestData = new |
| | | { |
| | | type = type.ToString(), |
| | | code = code, |
| | | message = message, |
| | | remark = remark |
| | | }; |
| | | |
| | | var result = HttpHelper.Post(url, requestData.ToJsonString()); |
| | | // å¯ä»¥ååºååæ£æ¥ resultCode æ¯å¦ä¸º0 |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | // è¿éä¸è¦åæå¼å¸¸äºï¼é¿å
æ»å¾ªç¯ |
| | | Console.WriteLine("å¼å¸¸æ¥å£æ¨é失败ï¼" + e.Message); |
| | | } |
| | | } |
| | | #endregion |