| | |
| | | using 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; |
| | | |
| | |
| | | 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: |
| | |
| | | |
| | | 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 => |
| | |
| | | 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, |