From 70e8a5aec5d49a95483d4c0e066ccdcc45a02e79 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期日, 09 二月 2025 21:51:37 +0800 Subject: [PATCH] 采购订单接口 --- StandardPda/MES.Service/service/BasicData/EmployeeInfoManager.cs | 193 +++++++++++++++++++++++------------------------ 1 files changed, 95 insertions(+), 98 deletions(-) diff --git a/StandardPda/MES.Service/service/BasicData/EmployeeInfoManager.cs b/StandardPda/MES.Service/service/BasicData/EmployeeInfoManager.cs index 1146417..8c31a54 100644 --- a/StandardPda/MES.Service/service/BasicData/EmployeeInfoManager.cs +++ b/StandardPda/MES.Service/service/BasicData/EmployeeInfoManager.cs @@ -1,110 +1,107 @@ -锘縰sing SqlSugar; -using System; -using System.Collections.Generic; -using MES.Service.DB; +锘縰sing MES.Service.DB; using MES.Service.Dto.webApi; using MES.Service.Modes; -using MES.Service.util; +using SqlSugar; -namespace MES.Service.service +namespace MES.Service.service.BasicData; + +public class EmployeeInfoManager : Repository<EmployeeInfo> { - public class EmployeeInfoManager : Repository<EmployeeInfo> + public bool Save(ErpEmployeeInfo unit) { - public bool Save(ErpEmployeeInfo unit) - { - var entity = GetMesItems(unit); // 灏� ErpStaff 杞崲涓� MesStaff + var entity = GetMesItems(unit); // 灏� ErpStaff 杞崲涓� MesStaff - return UseTransaction(db => + return UseTransaction(db => + { + switch (unit.Type) { - switch (unit.Type) - { - case "2": - case "4": - if (InsertOrUpdateEmp(db, entity.employeeInfo, - entity.employeeItems)) // 鎻掑叆鎴栨洿鏂板憳宸� - return 1; - break; - case "3": - if (DeleteEmp(db, entity.employeeInfo, - entity.employeeItems)) // 鍒犻櫎鍛樺伐 - return 1; - break; - default: - throw new ArgumentNullException( - $"type娌℃湁{unit.Type}杩欎釜绫诲瀷鐨勫弬鏁�"); - } - - throw new NotImplementedException("鎿嶄綔澶辫触"); - }) > 0; - } - - public bool SaveList(List<ErpEmployeeInfo> departments) - { - var result = departments.Select(Save).ToList(); - return result.All(b => b); - } - - private bool InsertOrUpdateEmp(SqlSugarScope db, - EmployeeInfo entityEmployeeInfo, - List<EmployeeItem> entityEmployeeItems) - { - db.Deleteable<EmployeeInfo>().Where( - s => s.Id == entityEmployeeInfo.Id).ExecuteCommand(); - - db.Deleteable<EmployeeItem>() - .Where(a => a.Eid == entityEmployeeInfo.Id).ExecuteCommand(); - - var executeCommand = - db.Insertable(entityEmployeeInfo).ExecuteCommand(); - var command = db.Insertable(entityEmployeeItems).PageSize(1).IgnoreColumnsNull().ExecuteCommand(); - - return executeCommand > 0 && command > 0; - } - - private bool DeleteEmp(SqlSugarScope db, - EmployeeInfo entityEmployeeInfo, - List<EmployeeItem> entityEmployeeItems) - { - var command = db.Deleteable<EmployeeInfo>().Where( - s => s.Id == entityEmployeeInfo.Id).ExecuteCommand(); - - var executeCommand = db.Deleteable<EmployeeItem>() - .Where(a => a.Eid == entityEmployeeInfo.Id).ExecuteCommand(); - - return executeCommand > 0 && command > 0; - } - - - private (EmployeeInfo employeeInfo, List<EmployeeItem> employeeItems) - GetMesItems( - ErpEmployeeInfo item) - { - var items = new EmployeeInfo - { - Id = Convert.ToDecimal(item.Id), - EmployeeNo = item.fNumber, - EmployeeName = item.fName, - DepartmentCode = item.fPostDeptid, - DocumentStatus = item.FDocumentStatus, - IsDisabled = item.FForbidStatus, - Organization = item.FUseOrgId - }; - - var employeeItems = new List<EmployeeItem>(); - - foreach (var erpEmployeeInfoDto in item.OperatorTypes) - { - var employee = new EmployeeItem - { - Eid = items.Id, - EType = erpEmployeeInfoDto.OperatorType, - CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") - }; - - employeeItems.Add(employee); + case "2": + case "4": + if (InsertOrUpdateEmp(db, entity.employeeInfo, + entity.employeeItems)) // 鎻掑叆鎴栨洿鏂板憳宸� + return 1; + break; + case "3": + if (DeleteEmp(db, entity.employeeInfo, + entity.employeeItems)) // 鍒犻櫎鍛樺伐 + return 1; + break; + default: + throw new ArgumentNullException( + $"type娌℃湁{unit.Type}杩欎釜绫诲瀷鐨勫弬鏁�"); } - return (items, employeeItems); + throw new NotImplementedException("鎿嶄綔澶辫触"); + }) > 0; + } + + public bool SaveList(List<ErpEmployeeInfo> departments) + { + var result = departments.Select(Save).ToList(); + return result.All(b => b); + } + + private bool InsertOrUpdateEmp(SqlSugarScope db, + EmployeeInfo entityEmployeeInfo, + List<EmployeeItem> entityEmployeeItems) + { + db.Deleteable<EmployeeInfo>().Where( + s => s.Id == entityEmployeeInfo.Id).ExecuteCommand(); + + db.Deleteable<EmployeeItem>() + .Where(a => a.Eid == entityEmployeeInfo.Id).ExecuteCommand(); + + var executeCommand = + db.Insertable(entityEmployeeInfo).ExecuteCommand(); + var command = db.Insertable(entityEmployeeItems).PageSize(1) + .IgnoreColumnsNull().ExecuteCommand(); + + return executeCommand > 0 && command > 0; + } + + private bool DeleteEmp(SqlSugarScope db, + EmployeeInfo entityEmployeeInfo, + List<EmployeeItem> entityEmployeeItems) + { + var command = db.Deleteable<EmployeeInfo>().Where( + s => s.Id == entityEmployeeInfo.Id).ExecuteCommand(); + + var executeCommand = db.Deleteable<EmployeeItem>() + .Where(a => a.Eid == entityEmployeeInfo.Id).ExecuteCommand(); + + return executeCommand > 0 && command > 0; + } + + + private (EmployeeInfo employeeInfo, List<EmployeeItem> employeeItems) + GetMesItems( + ErpEmployeeInfo item) + { + var items = new EmployeeInfo + { + Id = Convert.ToDecimal(item.Id), + EmployeeNo = item.fNumber, + EmployeeName = item.fName, + DepartmentCode = item.fPostDeptid, + DocumentStatus = item.FDocumentStatus, + IsDisabled = item.FForbidStatus, + Organization = item.FUseOrgId + }; + + var employeeItems = new List<EmployeeItem>(); + + foreach (var erpEmployeeInfoDto in item.OperatorTypes) + { + var employee = new EmployeeItem + { + Eid = items.Id, + EType = erpEmployeeInfoDto.OperatorType, + CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + }; + + employeeItems.Add(employee); } + + return (items, employeeItems); } } \ No newline at end of file -- Gitblit v1.9.3