From 5e9162834262836280dfb143e9872f2a53876169 Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期六, 19 七月 2025 13:54:06 +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 47c3324..e132364 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).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