namespace Yw.DAL.PostgreSql
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public partial class SysUnitValue : BaseDAL_Code_Sorter<Entity.SysUnitValue>, ISysUnitValue
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get { return ConfigHelper.PostgreSqlConnectionConfig; }
|
|
}
|
|
|
/// <summary>
|
/// 通过 TypeID 获取
|
/// </summary>
|
public List<Entity.SysUnitValue> GetByTypeID(long TypeID)
|
{
|
using (SqlSugarClient db = new(ConnectionConfig))
|
{
|
return db.Queryable<Entity.SysUnitValue>()
|
.Where(x => x.TypeID == TypeID)
|
.OrderBy(x => x.SortCode).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ID 删除（重写是为了清除关联的单位名称和单位转换）
|
/// </summary>
|
public override bool DeleteByID(long ID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
try
|
{
|
db.BeginTran();
|
var bol = db.Deleteable<Entity.SysUnitValue>().Where(x => x.ID == ID)
|
.ExecuteCommandHasChange();
|
if (!bol)
|
{
|
db.RollbackTran();
|
return false;
|
}
|
db.Deleteable<Entity.SysUnitName>().Where(x => x.ValueID == ID).ExecuteCommandHasChange();
|
db.Deleteable<Entity.SysUnitTransfer>().Where(x => x.FromValueID == ID || x.ToValueID == ID).ExecuteCommandHasChange();
|
db.CommitTran();
|
return true;
|
}
|
catch
|
{
|
db.RollbackTran();
|
throw;
|
}
|
}
|
}
|
|
|
|
|
}
|
}
|
