From 37caf664f302b7fbeef0bb00f5fd6b93810957ad Mon Sep 17 00:00:00 2001
From: lixiaojun <1287241240@qq.com>
Date: 星期三, 03 八月 2022 09:39:58 +0800
Subject: [PATCH] 修正能效汇总，数组保存bug
---
DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiWeekRecord.cs | 38 +++++++++
DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiHourRecord.cs | 38 +++++++++
DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiMonthRecord.cs | 38 +++++++++
DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiYearRecord.cs | 38 +++++++++
DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiDayRecord.cs | 38 +++++++++
5 files changed, 190 insertions(+), 0 deletions(-)
diff --git a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiDayRecord.cs b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiDayRecord.cs
index e75013f..383a55a 100644
--- a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiDayRecord.cs
+++ b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiDayRecord.cs
@@ -21,6 +21,44 @@
}
/// <summary>
+ ///
+ /// </summary>
+ /// <param name="list"></param>
+ /// <returns></returns>
+ public override bool Inserts(List<Entity.EtaSumMultiDayRecord> list)
+ {
+ if (list == null || list.Count < 1)
+ return default;
+ var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
+ if (corpIds.Count() != 1 || corpIds[0] < 1)
+ return default;
+ using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ foreach (var item in list)
+ {
+ var id = db.Insertable(item).ExecuteReturnSnowflakeId();
+ if (id < 1)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ }
+ db.CommitTran();
+ return true;
+ }
+ catch
+ {
+ db.RollbackTran();
+ return false;
+ }
+
+ }
+ }
+
+ /// <summary>
/// 閫氳繃瀵硅薄鑾峰彇
/// </summary>
public List<Entity.EtaSumMultiDayRecord> GetByObject(long CorpID, string ObjectType, long ObjectID)
diff --git a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiHourRecord.cs b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiHourRecord.cs
index f383a71..39df730 100644
--- a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiHourRecord.cs
+++ b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiHourRecord.cs
@@ -21,6 +21,44 @@
}
/// <summary>
+ ///
+ /// </summary>
+ /// <param name="list"></param>
+ /// <returns></returns>
+ public override bool Inserts(List<Entity.EtaSumMultiHourRecord> list)
+ {
+ if (list == null || list.Count < 1)
+ return default;
+ var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
+ if (corpIds.Count() != 1 || corpIds[0] < 1)
+ return default;
+ using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ foreach (var item in list)
+ {
+ var id = db.Insertable(item).ExecuteReturnSnowflakeId();
+ if (id < 1)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ }
+ db.CommitTran();
+ return true;
+ }
+ catch
+ {
+ db.RollbackTran();
+ return false;
+ }
+
+ }
+ }
+
+ /// <summary>
/// 閫氳繃瀵硅薄鑾峰彇
/// </summary>
public List<Entity.EtaSumMultiHourRecord> GetByObject(long CorpID, string ObjectType, long ObjectID)
diff --git a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiMonthRecord.cs b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiMonthRecord.cs
index 3881d31..9371f00 100644
--- a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiMonthRecord.cs
+++ b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiMonthRecord.cs
@@ -21,6 +21,44 @@
}
/// <summary>
+ ///
+ /// </summary>
+ /// <param name="list"></param>
+ /// <returns></returns>
+ public override bool Inserts(List<Entity.EtaSumMultiMonthRecord> list)
+ {
+ if (list == null || list.Count < 1)
+ return default;
+ var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
+ if (corpIds.Count() != 1 || corpIds[0] < 1)
+ return default;
+ using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ foreach (var item in list)
+ {
+ var id = db.Insertable(item).ExecuteReturnSnowflakeId();
+ if (id < 1)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ }
+ db.CommitTran();
+ return true;
+ }
+ catch
+ {
+ db.RollbackTran();
+ return false;
+ }
+
+ }
+ }
+
+ /// <summary>
/// 閫氳繃瀵硅薄鑾峰彇
/// </summary>
public List<Entity.EtaSumMultiMonthRecord> GetByObject(long CorpID, string ObjectType, long ObjectID)
diff --git a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiWeekRecord.cs b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiWeekRecord.cs
index 89b8f5c..86a1340 100644
--- a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiWeekRecord.cs
+++ b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiWeekRecord.cs
@@ -21,6 +21,44 @@
}
/// <summary>
+ ///
+ /// </summary>
+ /// <param name="list"></param>
+ /// <returns></returns>
+ public override bool Inserts(List<Entity.EtaSumMultiWeekRecord> list)
+ {
+ if (list == null || list.Count < 1)
+ return default;
+ var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
+ if (corpIds.Count() != 1 || corpIds[0] < 1)
+ return default;
+ using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ foreach (var item in list)
+ {
+ var id = db.Insertable(item).ExecuteReturnSnowflakeId();
+ if (id < 1)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ }
+ db.CommitTran();
+ return true;
+ }
+ catch
+ {
+ db.RollbackTran();
+ return false;
+ }
+
+ }
+ }
+
+ /// <summary>
/// 閫氳繃瀵硅薄鑾峰彇
/// </summary>
public List<Entity.EtaSumMultiWeekRecord> GetByObject(long CorpID, string ObjectType, long ObjectID)
diff --git a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiYearRecord.cs b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiYearRecord.cs
index d24154a..eaa4b92 100644
--- a/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiYearRecord.cs
+++ b/DAL/IStation.DAL4Eta/eta_sum/multi/EtaSumMultiYearRecord.cs
@@ -21,6 +21,44 @@
}
/// <summary>
+ ///
+ /// </summary>
+ /// <param name="list"></param>
+ /// <returns></returns>
+ public override bool Inserts(List<Entity.EtaSumMultiYearRecord> list)
+ {
+ if (list == null || list.Count < 1)
+ return default;
+ var corpIds = list.Select(x => x.CorpID).Distinct().ToList();
+ if (corpIds.Count() != 1 || corpIds[0] < 1)
+ return default;
+ using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ foreach (var item in list)
+ {
+ var id = db.Insertable(item).ExecuteReturnSnowflakeId();
+ if (id < 1)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ }
+ db.CommitTran();
+ return true;
+ }
+ catch
+ {
+ db.RollbackTran();
+ return false;
+ }
+
+ }
+ }
+
+ /// <summary>
/// 閫氳繃瀵硅薄鑾峰彇
/// </summary>
public List<Entity.EtaSumMultiYearRecord> GetByObject(long CorpID, string ObjectType, long ObjectID)
--
Gitblit v1.9.3