From 9ae0890dd74771ba9edd44d4830e0de37f8d9938 Mon Sep 17 00:00:00 2001
From: wangxinhui <wangxinhui@hnkhzn.com>
Date: 星期五, 26 九月 2025 16:55:03 +0800
Subject: [PATCH] MES接口优化，老厂排程优化等
---
项目代码/WMS/WMSServices/WIDESEA_BasicService/Base/MaterielInfoService.cs | 83 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 80 insertions(+), 3 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_BasicService/Base/MaterielInfoService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_BasicService/Base/MaterielInfoService.cs"
index 629ba5e..f65da62 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_BasicService/Base/MaterielInfoService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_BasicService/Base/MaterielInfoService.cs"
@@ -1,10 +1,15 @@
-锘縰sing System;
+锘縰sing AutoMapper;
+using SqlSugar.Extensions;
+using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
+using WIDESEA_Common.WareHouseEnum;
using WIDESEA_Core;
+using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
+using WIDESEA_DTO.Basic;
using WIDESEA_IBasicRepository;
using WIDESEA_IBasicService;
using WIDESEA_Model.Models;
@@ -16,24 +21,96 @@
private readonly IBasicRepository _basicRepository;
public IMaterielInfoRepository Repository => BaseDal;
+ private readonly IUnitOfWorkManage _unitOfWorkManage;
+ private readonly IMapper _mapper;
- public MaterielInfoService(IMaterielInfoRepository BaseDal, IBasicRepository basicRepository) : base(BaseDal)
+ public MaterielInfoService(IMaterielInfoRepository BaseDal, IBasicRepository basicRepository,IUnitOfWorkManage unitOfWorkManage,IMapper mapper) : base(BaseDal)
{
_basicRepository = basicRepository;
+ _unitOfWorkManage = unitOfWorkManage;
+ _mapper = mapper;
}
/// <summary>
/// 娣诲姞鑰佸巶鐗╂枡淇℃伅
/// </summary>
/// <returns></returns>
- public WebResponseContent AddMaterial()
+ public WebResponseContent AddMaterial(List<BSTMaterialDTO> bSTMaterialDTOs)
{
WebResponseContent content = new WebResponseContent();
try
{
+ List<Dt_MaterielInfo> OldMaterielInfos = BaseDal.QueryData(x => x.WarehouseId == WarehouseEnum.LLDYL.ObjToInt());
+ //鏂板
+ List<BSTMaterialDTO> bSTMaterialsDTOAdd = bSTMaterialDTOs.Where(x => x.Way == 1).ToList();
+ //淇敼
+ List<BSTMaterialDTO> bSTMaterialsDTOUpdate = bSTMaterialDTOs.Where(x => x.Way == 2).ToList();
+ //鍒犻櫎
+ List<BSTMaterialDTO> bSTMaterialsDTODel = bSTMaterialDTOs.Where(x => x.Way == 3).ToList();
+ List<Dt_MaterielInfo> materielInfosAdd = new List<Dt_MaterielInfo>();
+ List<Dt_MaterielInfo> materielInfosUpdate = new List<Dt_MaterielInfo>();
+ //鏂板
+ if (bSTMaterialsDTOAdd.Count>0)
+ {
+ //鍒ゆ柇閲嶅鎻掑叆
+ Dt_MaterielInfo? ExistMaterial = OldMaterielInfos.FirstOrDefault(x => bSTMaterialsDTOAdd.Select(x => x.MaterialId).Contains(x.MaterialSourceId));
+ if (ExistMaterial != null)
+ {
+ return content.Error($"鐗╂枡{nameof(BSTMaterialDTO.MaterialId)}:{ExistMaterial.MaterialSourceId}宸插瓨鍦�");
+ }
+
+ foreach (var item in bSTMaterialsDTOAdd)
+ {
+ if (bSTMaterialsDTOUpdate.FirstOrDefault(x=>x.MaterialId==item.MaterialId)!=null)
+ {
+ continue;
+ }
+ Dt_MaterielInfo materielInfo = _mapper.Map<Dt_MaterielInfo>(item);
+ materielInfosAdd.Add(materielInfo);
+ }
+ }
+ //鏇存柊
+ if (bSTMaterialsDTOUpdate.Count > 0)
+ {
+ //鑾峰彇宸插瓨鍦ㄧ殑鐗╂枡
+ List<Dt_MaterielInfo>? ExistbSTMaterialsUpdate = OldMaterielInfos.Where(x => bSTMaterialsDTOUpdate.Select(x => x.MaterialId).Contains(x.MaterialSourceId)).ToList();
+ foreach (var item in bSTMaterialsDTOUpdate)
+ {
+ Dt_MaterielInfo? materielInfoUpdate = ExistbSTMaterialsUpdate.FirstOrDefault(x => x.MaterialSourceId == item.MaterialId);
+ //濡傛灉鐗╂枡宸插瓨鍦ㄥ垯杩涜鏇存敼
+ if (materielInfoUpdate!=null)
+ {
+ materielInfoUpdate.MaterielCode = item.MaterialNo;
+ materielInfoUpdate.MaterielName = item.Name;
+ materielInfoUpdate.MaterielSpec = item.Spec;
+ materielInfoUpdate.MaterielWide = item.MaterielWide;
+ materielInfoUpdate.MaterielThickness = item.MaterielThickness;
+ materielInfoUpdate.MaterielLength = item.MaterielLength;
+ materielInfoUpdate.MaterielWeight = item.Weight;
+ materielInfoUpdate.MaterielUnit = item.Unit;
+ materielInfosUpdate.Add(materielInfoUpdate);
+ }
+ else//濡傛灉涓嶅瓨鍦ㄥ垯杩涜鏂板
+ {
+ Dt_MaterielInfo materielInfo = _mapper.Map<Dt_MaterielInfo>(item);
+ materielInfosAdd.Add(materielInfo);
+ }
+ }
+ }
+ //鍒犻櫎
+ if (bSTMaterialsDTODel.Count > 0)
+ {
+ }
+ //鏇存柊鏁版嵁
+ _unitOfWorkManage.CommitTran();
+ BaseDal.AddData(materielInfosAdd);
+ BaseDal.UpdateData(materielInfosUpdate);
+ _unitOfWorkManage.CommitTran();
+ return content.OK("鎺ユ敹鎴愬姛");
}
catch (Exception ex)
{
+ _unitOfWorkManage.RollbackTran();
content.Error(ex.Message);
}
return content;
--
Gitblit v1.9.3