namespace Yw.DAL.PostgreSql
{
    /// <summary>
    /// 
    /// </summary>
    public partial class SysUnitName : BaseDAL<Entity.SysUnitName>, ISysUnitName
    {
        /// <summary>
        /// 
        /// </summary>
        public override ConnectionConfig ConnectionConfig
        {
            get { return ConfigHelper.PostgreSqlConnectionConfig; }
        }

        /// <summary>
        /// 通过 ValueID 获取
        /// </summary>
        public List<Entity.SysUnitName> GetByValueID(long ValueID)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Queryable<Entity.SysUnitName>()
                    .Where(x => x.ValueID == ValueID).ToList();
            }
        }


        /// <summary>
        /// Value
        /// </summary>
        public bool SetByValueID(long ValueID, List<Entity.SysUnitNameValueSetter> list)
        {
            using (var db = new SqlSugarClient(ConnectionConfig))
            {
                if (list == null || list.Count < 1)
                {
                    return db.Deleteable<Entity.SysUnitName>()
                         .Where(x => x.ValueID == ValueID)
                         .ExecuteCommandHasChange();
                }

                try
                {
                    db.BeginTran();

                    var ids = new List<long>();
                    foreach (var setter in list)
                    {
                        var entity = db.Queryable<Entity.SysUnitName>()
                            .Where(x => x.ValueID == ValueID && x.LangID == setter.LangID).First();
                        if (entity == null)
                        {
                            entity = new Entity.SysUnitName()
                            {
                                ValueID = ValueID,
                                LangID = setter.LangID,
                                Name = setter.Name
                            };
                        }
                        else
                        {
                            entity.Name = setter.Name;
                        }
                        if (entity.ID < 1)
                        {
                            entity.ID = db.Insertable(entity).ExecuteReturnSnowflakeId();
                            if (entity.ID < 1)
                            {
                                db.RollbackTran();
                                return false;
                            }
                        }
                        else
                        {
                            var bol = db.Updateable(entity).ExecuteCommandHasChange();
                            if (!bol)
                            {
                                db.RollbackTran();
                                return false;
                            }
                        }
                        ids.Add(entity.ID);
                    }

                    //删除
                    db.Deleteable<Entity.SysUnitName>()
                        .Where(x => x.ValueID == ValueID && !ids.Contains(x.ID))
                        .ExecuteCommandHasChange();

                    db.CommitTran();
                    return true;
                }
                catch
                {
                    db.RollbackTran();
                    throw;
                }
            }
        }



    }
}