/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/8/16 13:18:38</remarks> public bool Update(DicArenabagconfigEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_DicArenabagconfig_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@Name", DbType.String, entity.Name); database.AddInParameter(commandWrapper, "@Area", DbType.AnsiString, entity.Area); database.AddInParameter(commandWrapper, "@AllPosition", DbType.AnsiString, entity.AllPosition); database.AddInParameter(commandWrapper, "@Position", DbType.AnsiString, entity.Position); database.AddInParameter(commandWrapper, "@PositionDesc", DbType.AnsiString, entity.PositionDesc); database.AddInParameter(commandWrapper, "@CardLevel", DbType.AnsiString, entity.CardLevel); database.AddInParameter(commandWrapper, "@KpiLevel", DbType.AnsiString, entity.KpiLevel); database.AddInParameter(commandWrapper, "@LeagueLevel", DbType.AnsiString, entity.LeagueLevel); database.AddInParameter(commandWrapper, "@NameEn", DbType.AnsiString, entity.NameEn); database.AddInParameter(commandWrapper, "@Specific", DbType.AnsiString, entity.Specific); database.AddInParameter(commandWrapper, "@Kpi", DbType.AnsiString, entity.Kpi); database.AddInParameter(commandWrapper, "@Capacity", DbType.AnsiString, entity.Capacity); database.AddInParameter(commandWrapper, "@Speed", DbType.AnsiString, entity.Speed); database.AddInParameter(commandWrapper, "@Shoot", DbType.AnsiString, entity.Shoot); database.AddInParameter(commandWrapper, "@FreeKick", DbType.AnsiString, entity.FreeKick); database.AddInParameter(commandWrapper, "@Balance", DbType.AnsiString, entity.Balance); database.AddInParameter(commandWrapper, "@Physique", DbType.AnsiString, entity.Physique); database.AddInParameter(commandWrapper, "@Power", DbType.AnsiString, entity.Power); database.AddInParameter(commandWrapper, "@Aggression", DbType.AnsiString, entity.Aggression); database.AddInParameter(commandWrapper, "@Disturb", DbType.AnsiString, entity.Disturb); database.AddInParameter(commandWrapper, "@Interception", DbType.AnsiString, entity.Interception); database.AddInParameter(commandWrapper, "@Dribble", DbType.AnsiString, entity.Dribble); database.AddInParameter(commandWrapper, "@Pass", DbType.AnsiString, entity.Pass); database.AddInParameter(commandWrapper, "@Mentality", DbType.AnsiString, entity.Mentality); database.AddInParameter(commandWrapper, "@Response", DbType.AnsiString, entity.Response); database.AddInParameter(commandWrapper, "@Positioning", DbType.AnsiString, entity.Positioning); database.AddInParameter(commandWrapper, "@HandControl", DbType.AnsiString, entity.HandControl); database.AddInParameter(commandWrapper, "@Acceleration", DbType.AnsiString, entity.Acceleration); database.AddInParameter(commandWrapper, "@Bounce", DbType.AnsiString, entity.Bounce); database.AddInParameter(commandWrapper, "@Club", DbType.String, entity.Club); database.AddInParameter(commandWrapper, "@Birthday", DbType.AnsiString, entity.Birthday); database.AddInParameter(commandWrapper, "@Stature", DbType.AnsiString, entity.Stature); database.AddInParameter(commandWrapper, "@Weight", DbType.AnsiString, entity.Weight); database.AddInParameter(commandWrapper, "@Nationality", DbType.String, entity.Nationality); database.AddInParameter(commandWrapper, "@Description", DbType.String, entity.Description); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到DicArenabagconfigEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public DicArenabagconfigEntity LoadSingleRow(IDataReader reader) { var obj = new DicArenabagconfigEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj.Name = (System.String)reader["Name"]; obj.Area = (System.String)reader["Area"]; obj.AllPosition = (System.String)reader["AllPosition"]; obj.Position = (System.String)reader["Position"]; obj.PositionDesc = (System.String)reader["PositionDesc"]; obj.CardLevel = (System.String)reader["CardLevel"]; obj.KpiLevel = (System.String)reader["KpiLevel"]; obj.LeagueLevel = (System.String)reader["LeagueLevel"]; obj.NameEn = (System.String)reader["NameEn"]; obj.Specific = (System.String)reader["Specific"]; obj.Kpi = (System.String)reader["Kpi"]; obj.Capacity = (System.String)reader["Capacity"]; obj.Speed = (System.String)reader["Speed"]; obj.Shoot = (System.String)reader["Shoot"]; obj.FreeKick = (System.String)reader["FreeKick"]; obj.Balance = (System.String)reader["Balance"]; obj.Physique = (System.String)reader["Physique"]; obj.Power = (System.String)reader["Power"]; obj.Aggression = (System.String)reader["Aggression"]; obj.Disturb = (System.String)reader["Disturb"]; obj.Interception = (System.String)reader["Interception"]; obj.Dribble = (System.String)reader["Dribble"]; obj.Pass = (System.String)reader["Pass"]; obj.Mentality = (System.String)reader["Mentality"]; obj.Response = (System.String)reader["Response"]; obj.Positioning = (System.String)reader["Positioning"]; obj.HandControl = (System.String)reader["HandControl"]; obj.Acceleration = (System.String)reader["Acceleration"]; obj.Bounce = (System.String)reader["Bounce"]; obj.Club = (System.String)reader["Club"]; obj.Birthday = (System.String)reader["Birthday"]; obj.Stature = (System.String)reader["Stature"]; obj.Weight = (System.String)reader["Weight"]; obj.Nationality = (System.String)reader["Nationality"]; obj.Description = (System.String)reader["Description"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>DicArenabagconfigEntity</returns> /// <remarks>2016/8/16 13:18:38</remarks> public DicArenabagconfigEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_DicArenabagconfig_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); DicArenabagconfigEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public static bool Update(DicArenabagconfigEntity dicArenabagconfigEntity, DbTransaction trans = null, string zoneId = "") { var provider = new DicArenabagconfigProvider(zoneId); return(provider.Update(dicArenabagconfigEntity, trans)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/8/16 13:18:38</remarks> public bool Update(DicArenabagconfigEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/8/16 13:18:38</remarks> public bool Insert(DicArenabagconfigEntity entity) { return(Insert(entity, null)); }
private void CompareBirthday(DicArenabagconfigEntity bagConfig, ref List <DicPlayerEntity> bagList) { }
private List <DicItemEntity> SetArenaBagConfig(DicArenabagconfigEntity bagConfig, List <DicItemEntity> itemList) { List <DicItemEntity> items = new List <DicItemEntity>(); List <DicPlayerEntity> bagList = DicPlayerMgr.GetAllForCache(); try { #region 判断每个属性是否符合竞技场卡包配置,现在只能配置(所属赛区,球员位置,卡牌颜色等级,kpi等级,能力值,身高,体重,生日) if (!string.IsNullOrEmpty(bagConfig.Area)) { var str = bagConfig.Area; string[] strs = str.Split('|'); if (strs.Length > 1) { List <int> dicS = new List <int>(); for (int i = 0; i < strs.Length; i++) { int s = ConvertHelper.ConvertToInt(strs[i]); if (!dicS.Contains(s)) { dicS.Add(s); } } bagList.RemoveAll(b => (!dicS.Contains(b.Area))); } } if (!string.IsNullOrEmpty(bagConfig.PositionDesc)) { var str = bagConfig.PositionDesc; string[] strs = str.Split('|'); if (strs.Length > 1) { List <string> dicS = new List <string>(); for (int i = 0; i < strs.Length; i++) { if (!dicS.Contains(strs[i])) { dicS.Add(strs[i]); } } bagList.RemoveAll(b => (!dicS.Contains(b.PositionDesc))); } } if (!string.IsNullOrEmpty(bagConfig.CardLevel)) { var str = bagConfig.CardLevel; string[] strs = str.Split('|'); if (strs.Length > 1) { List <int> dicS = new List <int>(); for (int i = 0; i < strs.Length; i++) { int s = ConvertHelper.ConvertToInt(strs[i]); if (!dicS.Contains(s)) { dicS.Add(s); } } bagList.RemoveAll(b => (!dicS.Contains(b.CardLevel))); } } if (!string.IsNullOrEmpty(bagConfig.KpiLevel)) { var str = bagConfig.KpiLevel; string[] strs = str.Split('|'); if (strs.Length > 1) { List <string> dicS = new List <string>(); for (int i = 0; i < strs.Length; i++) { if (!dicS.Contains(strs[i])) { dicS.Add(strs[i]); } } bagList.RemoveAll(b => (!dicS.Contains(b.KpiLevel))); } } if (!string.IsNullOrEmpty(bagConfig.Capacity)) { var str = bagConfig.Capacity; string[] strs = str.Split('|'); if (strs.Length == 2) { var min = ConvertHelper.ConvertToInt(strs[0]); var max = ConvertHelper.ConvertToInt(strs[1]); if (max == 0) { bagList.RemoveAll(b => (b.Capacity < min)); } else { bagList.RemoveAll(b => (b.Capacity <min || b.Capacity> max)); } } } if (!string.IsNullOrEmpty(bagConfig.Stature)) { var str = bagConfig.Stature; string[] strs = str.Split('|'); if (strs.Length == 2) { var min = ConvertHelper.ConvertToInt(strs[0]); var max = ConvertHelper.ConvertToInt(strs[1]); if (max == 0) { bagList.RemoveAll(b => (b.Stature < min)); } else { bagList.RemoveAll(b => (b.Stature <min || b.Stature> max)); } } } if (!string.IsNullOrEmpty(bagConfig.Weight)) { var str = bagConfig.Weight; string[] strs = str.Split('|'); if (strs.Length == 2) { var min = ConvertHelper.ConvertToInt(strs[0]); var max = ConvertHelper.ConvertToInt(strs[1]); if (max == 0) { bagList.RemoveAll(b => (b.Weight < min)); } else { bagList.RemoveAll(b => (b.Weight <min || b.Weight> max)); } } } // 限制生日 if (!string.IsNullOrEmpty(bagConfig.Birthday)) { var i = 0; try { var str = bagConfig.Birthday; string[] strs = str.Split('|'); if (strs.Length == 2) { if (strs[1] == "0") { i = 1; var min = ConvertHelper.StringToDateTime(strs[0]); i = 2; bagList.RemoveAll(b => (ConvertHelper.StringToDateTime(b.Birthday) < min)); i = 3; } else if (strs[0] == "0") { i = 4; var max = ConvertHelper.StringToDateTime(strs[1]); i = 5; bagList.RemoveAll(b => (ConvertHelper.StringToDateTime(b.Birthday) > max)); i = 6; } else { var min = ConvertHelper.StringToDateTime(strs[0]); var max = ConvertHelper.StringToDateTime(strs[1]); bagList.RemoveAll( b => (ConvertHelper.StringToDateTime(b.Birthday) < min || ConvertHelper.StringToDateTime(b.Birthday) > max)); } } } catch (Exception e) { SystemlogMgr.Info("bagConfigBirthday", "*" + e.Message + "*竞技场礼包*"); } } #endregion foreach (var entity in bagList) { items.Add(itemList.Find(d => (d.LinkId == entity.Idx && d.ItemType == 1))); } return(items); } catch (Exception) { return(items); } }