| | |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | if (UpdateDepartmentStatus(db, entity.Id, "B")) // 禁用部门 |
| | | return 1; |
| | | break; |
| | | case "2": |
| | | if (InsertDepartment(db, entity)) // 插入新部门 |
| | | return 1; |
| | | break; |
| | | case "3": |
| | | if (DeleteDepartment(db, entity.Id)) // 删除部门 |
| | | return 1; |
| | | break; |
| | | case "2": |
| | | case "4": |
| | | if (InsertOrUpdateDepartment(db, entity)) // 插入或更新部门 |
| | | return 1; |
| | |
| | | // 删除部门的方法 |
| | | private bool DeleteDepartment(SqlSugarScope db, decimal departmentId) |
| | | { |
| | | var deleteById = db.Deleteable<SysDepartment>().In(departmentId) |
| | | .ExecuteCommand(); |
| | | var deleteById = db.Deleteable<SysDepartment>() |
| | | .Where(s => s.Id == departmentId).ExecuteCommand(); |
| | | if (deleteById > 0) |
| | | return true; |
| | | |
| | |
| | | private bool InsertOrUpdateDepartment(SqlSugarScope db, |
| | | SysDepartment entity) |
| | | { |
| | | var exists = db.Queryable<SysDepartment>().Any(e => e.Id == entity.Id); |
| | | if (exists) |
| | | { |
| | | var update = db.Updateable(entity).ExecuteCommand(); |
| | | if (update > 0) |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | var insert = db.Insertable(entity).ExecuteCommand(); |
| | | if (insert > 0) |
| | | return true; |
| | | } |
| | | db.Deleteable<SysDepartment>() |
| | | .Where(s => s.Id == entity.Id).ExecuteCommand(); |
| | | |
| | | return false; |
| | | var insert = db.Insertable(entity).ExecuteCommand(); |
| | | return insert > 0; |
| | | } |
| | | |
| | | // 将 ErpDepartment 对象转换为 SysDepartment 对象的方法 |
| | |
| | | { |
| | | var ids = departmentList.Select(it => it.Id).ToArray(); |
| | | var deleteByIds = |
| | | db.Deleteable<SysDepartment>().In(ids).ExecuteCommand(); |
| | | db.Deleteable<SysDepartment>() |
| | | .Where(s => ids.Contains(s.Id)).ExecuteCommand(); |
| | | |
| | | if (deleteByIds > 0) |
| | | return true; |
| | | |
| | |
| | | private bool InsertOrUpdateDepartmentBatch(SqlSugarScope db, |
| | | List<SysDepartment> departmentList) |
| | | { |
| | | foreach (var entity in departmentList) |
| | | if (!InsertOrUpdateDepartment(db, entity)) |
| | | return false; |
| | | |
| | | return true; |
| | | return departmentList.All( |
| | | entity => InsertOrUpdateDepartment(db, entity)); |
| | | } |
| | | } |