using Yw.DAL.PostgreSql;
|
|
namespace HStation.DAL.PostgreSql
|
{
|
/// <summary>
|
///
|
/// </summary>:
|
public partial class EmployeeMain : BaseDAL_Paras_Flags_TagName_Sorter<Entity.EmployeeMain>, IEmployeeMain
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
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;
|
}
|
}
|
}
|
}
|
}
|