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/OrganizeManager.cs | 68 ++++++++++++----------------------
1 files changed, 24 insertions(+), 44 deletions(-)
diff --git a/MES.Service/service/BasicData/OrganizeManager.cs b/MES.Service/service/BasicData/OrganizeManager.cs
index 621cfe2..a1157ca 100644
--- a/MES.Service/service/BasicData/OrganizeManager.cs
+++ b/MES.Service/service/BasicData/OrganizeManager.cs
@@ -34,8 +34,7 @@
return 1;
break;
default:
- throw new ArgumentNullException(
- $"type娌℃湁{item.Type}杩欎釜绫诲瀷鐨勫弬鏁�");
+ throw new ArgumentNullException($"type娌℃湁{item.Type}杩欎釜绫诲瀷鐨勫弬鏁�");
}
throw new NotImplementedException("鎿嶄綔澶辫触");
@@ -45,8 +44,7 @@
public bool SaveList(List<ErpOrganize> Organize)
{
var list = Organize.Select(GetOrganize).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 =>
{
@@ -71,26 +69,21 @@
throw new NotImplementedException("鍚屾澶辫触");
break;
default:
- throw new ArgumentNullException(
- $"type娌℃湁{itemGroup.Key}杩欎釜绫诲瀷鐨勫弬鏁�");
+ throw new ArgumentNullException($"type娌℃湁{itemGroup.Key}杩欎釜绫诲瀷鐨勫弬鏁�");
}
-
return 1;
}) > 0;
}
- private bool UpdateOrganizetatus(SqlSugarScope db, string number,
- string status)
+ private bool UpdateOrganizetatus(SqlSugarScope db, string number, string status)
{
var equals = status.Equals("A");
- var result = db.Updateable<SysOrganization>()
- .SetColumns(s => s.Fforbidstatus == equals)
- // .SetColumns(s => s.Fforbidstatus == status)
- .Where(s => s.Fnumber == number).ExecuteCommand();
-
+ var result = db.Updateable<SysOrganization>().SetColumns(s => s.Fforbidstatus == equals)//.SetColumns(s => s.Fforbidstatus == status)
+ .Where(s => s.Fnumber == number).ExecuteCommand();
if (result > 0)
+ {
return true;
-
+ }
throw new NotImplementedException(status == "A" ? "鍚敤澶辫触" : "绂佺敤澶辫触");
}
@@ -105,11 +98,11 @@
private bool DeleteItem(SqlSugarScope db, string number)
{
- var deleteById = db.Deleteable<SysOrganization>()
- .Where(s => s.Fnumber == number).ExecuteCommand();
+ var deleteById = db.Deleteable<SysOrganization>().Where(s => s.Fnumber == number).ExecuteCommand();
if (deleteById > 0)
+ {
return true;
-
+ }
throw new NotImplementedException("鍒犻櫎澶辫触");
}
/*
@@ -140,23 +133,14 @@
private SysOrganization GetOrganize(ErpOrganize organize)
{
DateTime? createDate = null;
- if (!string.IsNullOrEmpty(organize.FCreateDate) &&
- DateTime.TryParseExact(organize.FCreateDate,
- "yyyy-MM-dd HH:mm:ss",
- CultureInfo.InvariantCulture,
- DateTimeStyles.None,
- out DateTime parsedCreateDate))
+ if (!string.IsNullOrEmpty(organize.FCreateDate) && DateTime.TryParseExact(organize.FCreateDate,"yyyy-MM-dd HH:mm:ss",CultureInfo.InvariantCulture,DateTimeStyles.None,out DateTime parsedCreateDate))
{
createDate = parsedCreateDate;
}
DateTime? forbidDate = null;
- if (!string.IsNullOrEmpty(organize.FFORBIDDATE) &&
- DateTime.TryParseExact(organize.FFORBIDDATE,
- "yyyy-MM-dd HH:mm:ss",
- CultureInfo.InvariantCulture,
- DateTimeStyles.None,
- out DateTime parsedForbidDate))
+
+ if (!string.IsNullOrEmpty(organize.FFORBIDDATE) && DateTime.TryParseExact(organize.FFORBIDDATE, "yyyy-MM-dd HH:mm:ss",CultureInfo.InvariantCulture,DateTimeStyles.None,out DateTime parsedForbidDate))
{
forbidDate = parsedForbidDate;
}
@@ -174,19 +158,18 @@
FFORBIDDATE = forbidDate
};
}
- private bool UpdateOrganizetatusBatch(SqlSugarScope db,
- List<SysOrganization> itemList, string status)
+ private bool UpdateOrganizetatusBatch(SqlSugarScope db,List<SysOrganization> itemList, string status)
{
var numbers = itemList.Select(it => it.Fnumber).ToArray();
var equals = status.Equals("A");
- var result = db.Updateable<SysOrganization>()
- .SetColumns(s => s.Fforbidstatus == equals)
+ var result = db.Updateable<SysOrganization>().SetColumns(s => s.Fforbidstatus == equals)
// .SetColumns(s => s.Fforbidstatus == status)
.Where(s => numbers.Contains(s.Fnumber)).ExecuteCommand();
if (result > 0)
+ {
return true;
-
+ }
throw new NotImplementedException(status == "A" ? "鍚敤澶辫触" : "绂佺敤澶辫触");
}
@@ -200,30 +183,27 @@
throw new NotImplementedException("鎻掑叆澶辫触");
}
- private bool DeleteItemBatch(SqlSugarScope db,
- List<SysOrganization> itemList)
+ private bool DeleteItemBatch(SqlSugarScope db,List<SysOrganization> itemList)
{
var numbers = itemList.Select(it => it.Fnumber).ToArray();
- var deleteByIds = db.Deleteable<SysOrganization>()
- .Where(s => numbers.Contains(s.Fnumber)).ExecuteCommand();
+ var deleteByIds = db.Deleteable<SysOrganization>().Where(s => numbers.Contains(s.Fnumber)).ExecuteCommand();
if (deleteByIds > 0)
+ {
return true;
-
+ }
throw new NotImplementedException("鍒犻櫎澶辫触");
}
private bool InsertOrUpdate(SqlSugarScope db, SysOrganization entity)
{
- db.Deleteable<SysOrganization>()
- .Where(s => s.Fnumber == entity.Fnumber).ExecuteCommand();
+ db.Deleteable<SysOrganization>().Where(s => s.Fnumber == entity.Fnumber).ExecuteCommand();
var insert = db.Insertable(entity).ExecuteCommand();
return insert > 0;
}
- private bool InsertOrUpdateBatch(SqlSugarScope db,
- List<SysOrganization> itemList)
+ private bool InsertOrUpdateBatch(SqlSugarScope db,List<SysOrganization> itemList)
{
return itemList.All(entity => InsertOrUpdate(db, entity));
}
--
Gitblit v1.9.3