From 80f7f4e4bed46064b44ea12fadf650cb7edb97ee Mon Sep 17 00:00:00 2001
From: duheng <2784771470@qq.com>
Date: 星期二, 23 七月 2024 10:58:47 +0800
Subject: [PATCH] 修复报错
---
HStation.Service.Organize.Core/04-dal/02-postgresql/EmployeeMain.cs | 89 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 89 insertions(+), 0 deletions(-)
diff --git a/HStation.Service.Organize.Core/04-dal/02-postgresql/EmployeeMain.cs b/HStation.Service.Organize.Core/04-dal/02-postgresql/EmployeeMain.cs
index bc9f75e..3143ba4 100644
--- a/HStation.Service.Organize.Core/04-dal/02-postgresql/EmployeeMain.cs
+++ b/HStation.Service.Organize.Core/04-dal/02-postgresql/EmployeeMain.cs
@@ -14,5 +14,94 @@
{
get { return Organize.ConfigHelper.PostgreSqlConnectionConfig; }
}
+
+ //鎻掑叆鎷撳睍(鍖呭惈鐧诲綍鐢ㄦ埛)
+ public long InsertLoginUserEx(Entity.EmployeeMain employeeMain, Entity.UserLoginMap userLoginMap, Entity.LoginUserMain loginUserMain)
+ {
+ if (employeeMain == null || userLoginMap == null || loginUserMain == null)
+ {
+ return default;
+ }
+ using (var db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ var result = db.Insertable(employeeMain).ExecuteReturnSnowflakeId();
+ if (result < 0)
+ {
+ db.RollbackTran();
+ return default;
+ }
+ else
+ {
+ var loginid = db.Insertable(loginUserMain).ExecuteReturnSnowflakeId();
+ if (loginid < 0)
+ {
+ db.RollbackTran();
+ return default;
+ }
+ else
+ {
+ userLoginMap.ObjectID = result;
+ userLoginMap.LoginID = loginid;
+ var mainandpartmap = db.Insertable(userLoginMap).ExecuteReturnSnowflakeId();
+ if (mainandpartmap < 0)
+ {
+ db.RollbackTran();
+ return default;
+ }
+ }
+ }
+
+ db.CommitTran();
+ return result;
+ }
+ catch (Exception ex)
+ {
+ db.RollbackTran();
+ throw;
+ }
+ }
+ }
+
+ //鎻掑叆鎷撳睍(涓嶅寘鍚櫥褰曠敤鎴�)
+ public long InsertEx(Entity.EmployeeMain employeeMain, Entity.UserLoginMap userLoginMap)
+ {
+ if (employeeMain == null || userLoginMap == null)
+ {
+ return default;
+ }
+ using (var db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ var result = db.Insertable(employeeMain).ExecuteReturnSnowflakeId();
+ if (result < 0)
+ {
+ db.RollbackTran();
+ return default;
+ }
+ else
+ {
+ userLoginMap.ObjectID = result;
+ var mainandpartmap = db.Insertable(userLoginMap).ExecuteReturnSnowflakeId();
+ if (mainandpartmap < 0)
+ {
+ db.RollbackTran();
+ return default;
+ }
+ }
+ db.CommitTran();
+ return result;
+ }
+ catch (Exception ex)
+ {
+ db.RollbackTran();
+ throw;
+ }
+ }
+ }
}
}
\ No newline at end of file
--
Gitblit v1.9.3