啊鑫
2024-10-30 c02ff3f682398f022488f98b87a79d4a8e04b5dd
MES.Service/service/BasicData/SysDepartmentManager.cs
@@ -1,5 +1,4 @@
using Castle.Core.Resource;
using MES.Service.DB;
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
@@ -28,14 +27,11 @@
                    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;
@@ -76,8 +72,8 @@
    // 删除部门的方法
    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;
@@ -88,21 +84,11 @@
    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 对象的方法
@@ -213,7 +199,9 @@
    {
        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;
@@ -224,10 +212,7 @@
    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));
    }
}