| | |
| | | break; |
| | | case "2": |
| | | case "4": |
| | | DeleteStaff(db, sysUser, entity.Id); |
| | | if (InsertOrUpdateStaff(db, sysUser, entity)) // 插入或更新员工 |
| | | return 1; |
| | | break; |
| | |
| | | private bool InsertOrUpdateStaff(SqlSugarScope db, SysUser sysUser, |
| | | MesStaff entity) |
| | | { |
| | | 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(); |
| | |
| | | private bool InsertOrUpdateBatch(SqlSugarScope db, List<SysUser> userList, |
| | | List<MesStaff> staffList) |
| | | { |
| | | foreach (var sysUser in userList) |
| | | { |
| | | var entity = staffList.First(s => s.StaffNo == sysUser.Account); |
| | | if (!InsertOrUpdateStaff(db, sysUser, entity)) return false; |
| | | } |
| | | |
| | | return true; |
| | | return !(from sysUser in userList let entity = staffList.First(s => s.StaffNo == sysUser.Account) where !InsertOrUpdateStaff(db, sysUser, entity) select sysUser).Any(); |
| | | } |
| | | } |