lixiaojun
2024-06-02 1485ae366d837f9df65405636123ba56a638b731
Yw.Service.Unit.Core/04-dal/02-postgresql/03-value/SysUnitValue.cs
@@ -28,8 +28,35 @@
            }
        }
        /// <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;
                }
            }
        }