using AngleSharp.Dom; using Masuit.Tools; using Newtonsoft.Json; using SharpCompress.Common; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Security.Policy; using System.Text; using System.Threading.Tasks; using WIDESEA_Core; using WIDESEA_Core.BaseServices; using WIDESEA_Core.Helper; using WIDESEA_ISquareCabinRepository; using WIDESEA_ISquareCabinServices; using WIDESEA_Model.Models; using static WIDESEA_DTO.SquareCabin.OrderDto; using static WIDESEA_DTO.SquareCabin.TowcsDto; namespace WIDESEA_SquareCabinServices { public class MedicineGoodsServices : ServiceBase, IMedicineGoodsServices { public MedicineGoodsServices(IMedicineGoodsRepository BaseDal) : base(BaseDal) { } /// /// 获取药品基础信息同步接口 /// /// public WebResponseContent GetMedicineGoodsInfom(DateTime searchDate) { var responseContent = new WebResponseContent(); try { var url = "http://127.0.0.1:9090/GYZ2/95fck/goodsInfo"; // 请求参数 var requestData = new { searchDate = searchDate.ToString("yyyy-MM-dd HH:mm:ss") }; // 发起请求 var result = HttpHelper.Post(url, requestData.ToJsonString()); // 反序列化 var response = JsonConvert.DeserializeObject>(result); if (response.resultCode != "0") { // 调用异常接口 SendErrorToUpstream(5, "", response.resultMsg ?? "上游接口返回失败", ""); return responseContent.Error(response.resultMsg ?? "上游接口返回失败"); } if (response.data == null || !response.data.Any()) { return responseContent.OK("无新药品数据"); } #region //foreach (var Medicat in response.data) //{ // var entity = new Dt_MedicineGoods // { // Goods_no = Medicat.goods_no, // Goods_spm = Medicat.goods_spm, // Model = Medicat.model, // Factory = Medicat.factory, // Unit = Medicat.unit, // Item_Iength = Medicat.item_length, // Item_weight = Medicat.item_weight, // Item_hight = Medicat.item_hight, // Item_volumn = Medicat.item_volumn, // Storage_cond = Medicat.storage_cond, // Remark = Medicat.remark, // GoodStatus = "未下发", // ModifyDate = Medicat.modify_date // }; // AddData(entity); //} #endregion // 收集所有要插入的实体 var entityList = response.data.Select(Medicat => new Dt_MedicineGoods { Goods_no = Medicat.goods_no, Goods_spm = Medicat.goods_spm, Model = Medicat.model, Factory = Medicat.factory, Unit = Medicat.unit, Item_Iength = Medicat.item_length, Item_weight = Medicat.item_weight, Item_hight = Medicat.item_hight, Item_volumn = Medicat.item_volumn, Storage_cond = Medicat.storage_cond, Remark = Medicat.remark, GoodStatus = "未下发", ModifyDate = Medicat.modify_date }).ToList(); // 一次性批量插入数据库 BaseDal.Db.Insertable(entityList).ExecuteCommand(); ProductSynchronous(); return responseContent.OK("同步成功"); } catch (Exception ex) { SendErrorToUpstream(5, "", ex.Message, ""); return responseContent.Error(ex.Message); } } /// /// 发给下游wcs同步药品信息 /// /// public WebResponseContent ProductSynchronous() { try { //先找到所有未下发的药品 var list = BaseDal.QueryData(x => x.GoodStatus == "未下发").ToList(); if (list == null || !list.Any()) { return new WebResponseContent().OK("无未下发药品"); } //找到了就将整个list发给下游系统 foreach (var item in list) { var medicineDTO = new ProductInfo { //用户code customerCode = "905", //物料类型 materialCode = "YY", //产品编码 productCode= item.Goods_no, //产品名 productName =item.Goods_spm , //产品条码 productBarCode= item.Goods_no, //规格 productSpecifications=item.Model, //单位 unit = item.Unit, //长 singleProductLongNum = item.Item_Iength.ToString(), //宽 singleProductWideNum = item.Item_weight.ToString(), //高 singleProductHighNum = item.Item_hight.ToString(), //重量 singleProductWeight = item.Item_weight.ToString(), //体积 singleProductVolume = item.Item_volumn.ToString(), //是否取消 Is_delete = "0" }; var url = "http://172.16.1.2:9357/file-admin/api/product/productSynchronous"; var result = HttpHelper.Post(url, medicineDTO.ToJsonString()); var resp = JsonConvert.DeserializeObject>(result); if (resp!=null&&resp.code=="0") { //更新药品状态-已完成 BaseDal.Db.Updateable() .SetColumns(x => x.GoodStatus == "下发完成") .Where(x => x.Goods_no == item.Goods_no) .ExecuteCommand(); } else { SendErrorToUpstream(5, medicineDTO.materialCode, resp?.msg ?? "WCS药品信息同步失败", ""); return new WebResponseContent { Status = false, Message = "订单推送失败" }; } } return new WebResponseContent { Status = true, Message = "成功" }; } catch (Exception ex) { Console.WriteLine("ProductSynchronous 异常:" + ex.Message); return new WebResponseContent { Status = false, Message = ex.Message }; } } /// /// 推送异常信息给上游系统1.入库单接口;2.入库单报完成接口;3.出库单接口;4.出库报完成接口;5.药品基础信息同步接口;6.供应商信息接口;7.客户信息接口;8.库存 /// public void SendErrorToUpstream(int type, string code, string message, string remark) { try { var url = "http://127.0.0.1:9090/GYZ2/95fck/exceptionLog"; 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); } } } }