From baa7d3abea49a36b1ca83d29343e720647ee2b8b Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期一, 05 五月 2025 10:29:55 +0800
Subject: [PATCH] 1.生产订单新增同步时间。 2.采购订单新增同步时间。 3.员工新增账号逻辑优化。 4.基础信息+业务单据增加route储存单号。
---
MES.Service/service/BasicData/MesStaffManager.cs | 24 ++++++++++++++++++------
1 files changed, 18 insertions(+), 6 deletions(-)
diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs
index 776945d..8921d64 100644
--- a/MES.Service/service/BasicData/MesStaffManager.cs
+++ b/MES.Service/service/BasicData/MesStaffManager.cs
@@ -61,14 +61,22 @@
private bool InsertOrUpdateStaff(SqlSugarScope db, SysUser sysUser,
MesStaff entity)
{
- db.Deleteable<SysUser>()
- .Where(s => s.Account == sysUser.Account).ExecuteCommand();
+
+ var exists = db.Queryable<SysUser>().Any(u => u.Account == sysUser.Account);
+ if (!exists)
+ {
+ var insertUser = db.Insertable(sysUser).ExecuteCommand();
+ if (insertUser <= 0) return false;
+ }
+
+ //db.Deleteable<SysUser>()
+ // .Where(s => s.Account == sysUser.Account).ExecuteCommand();
db.Deleteable<MesStaff>()
.Where(s => s.Id == entity.Id).ExecuteCommand();
- var insertUser = db.Insertable(sysUser).ExecuteCommand();
- if (insertUser <= 0) return false;
+
+
var insertStaff = db.Insertable(entity).ExecuteCommand();
return insertStaff > 0;
}
@@ -124,7 +132,8 @@
UserName = staff.FName,
Password = "E1ADC3949BA59ABBE56E057F2F883E", // 鍒濆瀵嗙爜
DepartNo = staff.FPostDept,
- Type = staff.Type
+ Type = staff.Type,
+ CreateTime = DateTime.Now
};
}
@@ -232,6 +241,9 @@
private bool InsertOrUpdateBatch(SqlSugarScope db, List<SysUser> userList,
List<MesStaff> staffList)
{
- return !(from sysUser in userList let entity = staffList.First(s => s.StaffNo == sysUser.Account) where !InsertOrUpdateStaff(db, sysUser, entity) select sysUser).Any();
+ return !(from sysUser in userList
+ let entity = staffList.First(s => s.StaffNo == sysUser.Account)
+ where !InsertOrUpdateStaff(db, sysUser, entity)
+ select sysUser).Any();
}
}
\ No newline at end of file
--
Gitblit v1.9.3