From 5de35354e8dfcb4933350d0d1b645d400bcf23ab Mon Sep 17 00:00:00 2001 From: sjz <1240968267@qq.com> Date: 星期二, 22 七月 2025 15:30:09 +0800 Subject: [PATCH] 优化多组织 --- MES.Service/service/BasicData/MesStaffManager.cs | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs index 52a57c9..28a1ef5 100644 --- a/MES.Service/service/BasicData/MesStaffManager.cs +++ b/MES.Service/service/BasicData/MesStaffManager.cs @@ -42,8 +42,7 @@ } // 鏇存柊鍛樺伐鐘舵�佺殑鏂规硶 - private bool UpdateStaffStatus(SqlSugarScope db, decimal staffId, - string status) + private bool UpdateStaffStatus(SqlSugarScope db, decimal staffId,string status) { var result = db.Updateable<MesStaff>().SetColumns(s => s.FforbidStatus == status).Where(s => s.Id == staffId).ExecuteCommand(); return true; @@ -52,10 +51,10 @@ // 鎻掑叆鎴栨洿鏂板憳宸ョ殑鏂规硶 private bool InsertOrUpdateStaff(SqlSugarScope db, MesStaff entity) { - var exists = db.Queryable<MesStaff>().Any(e => e.Id == entity.Id); + var exists = db.Queryable<MesStaff>().Any(e => e.Id == entity.Id && e.StaffNo==entity.StaffNo); if (exists) { - var update = db.Updateable(entity).ExecuteCommand(); + var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.StaffNo == entity.StaffNo).ExecuteCommand(); return true; } else -- Gitblit v1.9.3