From 5141cb46c3e277e58ea71d3d99b116ca816974e1 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期一, 20 一月 2025 01:20:32 +0800
Subject: [PATCH] 1.改造客户信息接口，将组织id变为单据体 2.修改处理数据方法，有一个组织id就有几条数据，并插入。
---
StandardPda/MES.Service/service/BasicData/MesCustomerManager.cs | 64 +++++++++++++++++---------------
1 files changed, 34 insertions(+), 30 deletions(-)
diff --git a/StandardPda/MES.Service/service/BasicData/MesCustomerManager.cs b/StandardPda/MES.Service/service/BasicData/MesCustomerManager.cs
index d771095..c58718f 100644
--- a/StandardPda/MES.Service/service/BasicData/MesCustomerManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/MesCustomerManager.cs
@@ -1,7 +1,9 @@
锘縰sing MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
+using MES.Service.util;
using SqlSugar;
+using System.Collections.Generic;
namespace MES.Service.service.BasicData;
@@ -16,20 +18,20 @@
switch (customer.Type)
{
case "0":
- if (UpdateCustomerStatus(db, entity.Id, "A"))
+ if (UpdateCustomerStatusBatch(db, entity, "A"))
return 1;
break;
case "1":
- if (UpdateCustomerStatus(db, entity.Id, "B"))
+ if (UpdateCustomerStatusBatch(db, entity, "B"))
return 1;
break;
case "3":
- if (DeleteCustomer(db, entity.Id))
+ if (DeleteCustomerBatch(db, entity))
return 1;
break;
case "2":
case "4":
- if (InsertOrUpdate(db, entity))
+ if (InsertOrUpdateBatch(db, entity))
return 1;
break;
default:
@@ -43,8 +45,20 @@
public bool SaveList(List<ErpCustomer> customers)
{
- var list = customers.Select(GetSysDepartment).ToList();
- var groupBy = list.GroupBy(s => s.Type)
+ //var list = customers.Select(GetSysDepartment).ToList();
+
+ //鍥犱负U9鐨勬ā寮忥紝浼氬鑷村缁勭粐鐨勫熀纭�鏁版嵁琚鐞嗘垚List<>,鎵�浠ラ渶瑕佷慨鏀规柟娉曪紝SaveLits涓簲璇ユ槸鎶婂崟鏉″鐞嗗嚭鏉ョ殑List鏁版嵁鍔犺捣鏉ワ紝鑰屼笉鏄箣鍓嶇殑鏂规硶澶勭悊銆�
+ List<MesCustomer> mes_customers = new List<MesCustomer>();
+ foreach (ErpCustomer customer in customers)
+ {
+ var mesCustomerList = GetSysDepartment(customer);
+ if (mesCustomerList != null)
+ {
+ mes_customers.AddRange(mesCustomerList);
+ }
+ }
+
+ var groupBy = mes_customers.GroupBy(s => s.Type)
.ToDictionary(g => g.Key, g => g.ToList());
return UseTransaction(db =>
@@ -110,39 +124,29 @@
throw new NotImplementedException("鍒犻櫎澶辫触");
}
- private MesCustomer GetSysDepartment(ErpCustomer customer)
+ private List<MesCustomer> GetSysDepartment(ErpCustomer customer)
{
- return new MesCustomer
+ //var db = SqlSugarHelper.GetInstance();
+ //var id = db.Insertable(insertObj).ExecuteReturnIdentity();
+
+ List<MesCustomer> customers = new List<MesCustomer>();
+
+ customers = customer.ErpDetails.Select(ErpDetails => new MesCustomer
{
- Id = Convert.ToDecimal(customer.Id),
+ Id = GetSeqUtil.GetSeq("U9_MES_ID"),
CustNo = customer.FNumber,
CustSname = customer.FShortName,
CustName = customer.FName,
Anred = customer.FContact,
Telf1 = customer.FMobilephone,
Fseller = customer.FSeller,
-
- /// <summary>
- /// 鎺ュ彛瀛楁璋冩暣锛氭爣鍑嗙増鎺ュ彛鏂板 ERP鍗曟嵁鐘舵�� 瀛楁銆�
- /// </summary>
- /// <remarks>
- /// 淇敼浜猴細<姹犲崡楠�>
- /// 淇敼鏃ユ湡锛�<2024-12-27>
- /// 淇敼璇存槑锛�
- /// - 鍘熶唬鐮侊細绌�
- /// - 淇敼鍚庯細
- ///FDOCUMENTSTATUS = customer.FDocumentStatus,
- /// </remarks>
- FDOCUMENTSTATUS = customer.FDocumentStatus,
-
+ CUSTOMER_STATE = customer.State,
Fforbidstatus = customer.FForbidStatus,
- Remark = customer.fremarks,
- CreateDate = DateTime.Now,
- CreateOrg= Convert.ToDecimal(customer.FCreateOrgId),
- UseOrg= Convert.ToDecimal(customer.FUseOrgId),
- Company = "1000",
- Factory = "1000"
- };
+ UseOrg = Convert.ToDecimal(ErpDetails.FUseOrgId),
+
+ }).ToList();
+
+ return customers;
}
private bool UpdateCustomerStatusBatch(SqlSugarScope db,
--
Gitblit v1.9.3