From 0c1a03e880bbf795b771a9c8ee4b7b271c262b58 Mon Sep 17 00:00:00 2001 From: sjz <1240968267@qq.com> Date: 星期五, 12 九月 2025 14:23:56 +0800 Subject: [PATCH] 切换验收数据库 --- MES.Service/service/BasicData/MesUnitManager.cs | 38 +++++++++++++++----------------------- 1 files changed, 15 insertions(+), 23 deletions(-) diff --git a/MES.Service/service/BasicData/MesUnitManager.cs b/MES.Service/service/BasicData/MesUnitManager.cs index 4157420..ebc1787 100644 --- a/MES.Service/service/BasicData/MesUnitManager.cs +++ b/MES.Service/service/BasicData/MesUnitManager.cs @@ -33,8 +33,7 @@ return 1; break; default: - throw new ArgumentNullException( - $"type娌℃湁{unit.Type}杩欎釜绫诲瀷鐨勫弬鏁�"); + throw new ArgumentNullException($"type娌℃湁{unit.Type}杩欎釜绫诲瀷鐨勫弬鏁�"); } throw new NotImplementedException("鎿嶄綔澶辫触"); @@ -44,8 +43,7 @@ public bool SaveList(List<ErpUnit> units) { var list = units.Select(GetMesUnit).ToList(); - var groupBy = list.GroupBy(s => s.Type) - .ToDictionary(g => g.Key, g => g.ToList()); + var groupBy = list.GroupBy(s => s.Type).ToDictionary(g => g.Key, g => g.ToList()); return UseTransaction(db => { @@ -70,8 +68,7 @@ throw new NotImplementedException("鍚屾澶辫触"); break; default: - throw new ArgumentNullException( - $"type娌℃湁{unitGroup.Key}杩欎釜绫诲瀷鐨勫弬鏁�"); + throw new ArgumentNullException($"type娌℃湁{unitGroup.Key}杩欎釜绫诲瀷鐨勫弬鏁�"); } return 1; @@ -81,13 +78,12 @@ private bool UpdateUnitStatus(SqlSugarScope db, decimal unitId, string status) { - var result = db.Updateable<MesUnit>() - .SetColumns(s => s.Fforbidstatus == status) - .Where(s => s.Id == unitId).ExecuteCommand(); + var result = db.Updateable<MesUnit>().SetColumns(s => s.Fforbidstatus == status).Where(s => s.Id == unitId).ExecuteCommand(); if (result > 0) + { return true; - + } throw new NotImplementedException(status == "A" ? "鍚敤澶辫触" : "绂佺敤澶辫触"); } @@ -102,11 +98,11 @@ private bool DeleteUnit(SqlSugarScope db, decimal unitId) { - var deleteById = db.Deleteable<MesUnit>() - .Where(s => s.Id == unitId).ExecuteCommand(); + var deleteById = db.Deleteable<MesUnit>().Where(s => s.Id == unitId).ExecuteCommand(); if (deleteById > 0) + { return true; - + } throw new NotImplementedException("鍒犻櫎澶辫触"); } @@ -135,17 +131,15 @@ }; } - private bool UpdateUnitStatusBatch(SqlSugarScope db, List<MesUnit> unitList, - string status) + private bool UpdateUnitStatusBatch(SqlSugarScope db, List<MesUnit> unitList,string status) { var ids = unitList.Select(it => it.Id).ToArray(); - var result = db.Updateable<MesUnit>() - .SetColumns(s => s.Fforbidstatus == status) - .Where(s => ids.Contains(s.Id)).ExecuteCommand(); + var result = db.Updateable<MesUnit>().SetColumns(s => s.Fforbidstatus == status).Where(s => ids.Contains(s.Id)).ExecuteCommand(); if (result > 0) + { return true; - + } throw new NotImplementedException(status == "A" ? "鍚敤澶辫触" : "绂佺敤澶辫触"); } @@ -161,15 +155,13 @@ private bool DeleteUnitBatch(SqlSugarScope db, List<MesUnit> unitList) { var ids = unitList.Select(it => it.Id).ToArray(); - var deleteByIds = db.Deleteable<MesUnit>() - .Where(s => ids.Contains(s.Id)).ExecuteCommand(); + var deleteByIds = db.Deleteable<MesUnit>().Where(s => ids.Contains(s.Id)).ExecuteCommand(); return deleteByIds > 0; } private bool InsertOrUpdate(SqlSugarScope db, MesUnit entity) { - db.Deleteable<MesUnit>() - .Where(s => s.Id == entity.Id).ExecuteCommand(); + db.Deleteable<MesUnit>().Where(s => s.Id == entity.Id).ExecuteCommand(); var insert = db.Insertable(entity).ExecuteCommand(); return insert > 0; } -- Gitblit v1.9.3