From 9bda2a9c4dcd6512b32a31cde6af4d5d8e80c668 Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期五, 23 五月 2025 09:59:26 +0800 Subject: [PATCH] 1.销售订单优化 2.组织新增同步时间 --- MES.Service/service/BasicData/MesStaffManager.cs | 19 ++++++++++++++----- 1 files changed, 14 insertions(+), 5 deletions(-) diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs index a3aeee7..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 }; } -- Gitblit v1.9.3