/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/19 16:24:59</remarks> public bool Update(DicManagerwilltipsEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_DicManagerwilltips_Update"); database.AddInParameter(commandWrapper, "@SkillId", DbType.Int32, entity.SkillId); database.AddInParameter(commandWrapper, "@SkillCode", DbType.AnsiString, entity.SkillCode); database.AddInParameter(commandWrapper, "@SkillName", DbType.String, entity.SkillName); database.AddInParameter(commandWrapper, "@WillRank", DbType.Int32, entity.WillRank); database.AddInParameter(commandWrapper, "@ActType", DbType.String, entity.ActType); database.AddInParameter(commandWrapper, "@DriveFlag", DbType.Int32, entity.DriveFlag); database.AddInParameter(commandWrapper, "@DriveFlagMemo", DbType.String, entity.DriveFlagMemo); database.AddInParameter(commandWrapper, "@BuffMemo", DbType.String, entity.BuffMemo); database.AddInParameter(commandWrapper, "@BuffArg", DbType.Currency, entity.BuffArg); database.AddInParameter(commandWrapper, "@BuffArg2", DbType.Currency, entity.BuffArg2); database.AddInParameter(commandWrapper, "@Icon", DbType.AnsiString, entity.Icon); database.AddInParameter(commandWrapper, "@Memo", DbType.String, entity.Memo); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// GetById /// </summary> /// <param name="skillCode">skillCode</param> /// <returns>DicManagerwilltipsEntity</returns> /// <remarks>2015/10/19 16:24:59</remarks> public DicManagerwilltipsEntity GetById(System.String skillCode) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_DicManagerwilltips_GetById"); database.AddInParameter(commandWrapper, "@SkillCode", DbType.AnsiString, skillCode); DicManagerwilltipsEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// 将IDataReader的当前记录读取到DicManagerwilltipsEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public DicManagerwilltipsEntity LoadSingleRow(IDataReader reader) { var obj = new DicManagerwilltipsEntity(); obj.SkillId = (System.Int32)reader["SkillId"]; obj.SkillCode = (System.String)reader["SkillCode"]; obj.SkillName = (System.String)reader["SkillName"]; obj.WillRank = (System.Int32)reader["WillRank"]; obj.ActType = (System.String)reader["ActType"]; obj.DriveFlag = (System.Int32)reader["DriveFlag"]; obj.DriveFlagMemo = (System.String)reader["DriveFlagMemo"]; obj.BuffMemo = (System.String)reader["BuffMemo"]; obj.BuffArg = (System.Decimal)reader["BuffArg"]; obj.BuffArg2 = (System.Decimal)reader["BuffArg2"]; obj.Icon = (System.String)reader["Icon"]; obj.Memo = (System.String)reader["Memo"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
public CombTipsEntity(DicManagerwilltipsEntity dic) { this.SkillCode = dic.SkillCode.Replace("W", "C"); this.SkillName = dic.SkillName; this.Icon = dic.Icon; }
public static bool Update(DicManagerwilltipsEntity dicManagerwilltipsEntity, DbTransaction trans = null, string zoneId = "") { var provider = new DicManagerwilltipsProvider(zoneId); return(provider.Update(dicManagerwilltipsEntity, trans)); }
public static SkillTipsEntity ExportSkillTips(bool includeStarSkillLevel = false) { var tips = new SkillTipsEntity(); tips.SkillCard = DicSkillcardtipsMgr.GetAll(); tips.StarSkill = DicStarskilltipsMgr.GetAll(); tips.ManagerTalent = DicManagertalenttipsMgr.GetAll(); tips.ClubSkills = DicClubskillMgr.GetAll(); var wills = DicManagerwilltipsMgr.GetAll(); var willParts = DicManagerwillparttipsMgr.GetAll(); var dicWill = new Dictionary <string, DicManagerwilltipsEntity>(wills.Count); tips.LowWill = new List <DicManagerwilltipsEntity>(); tips.HighWill = new List <DicManagerwilltipsEntity>(); var strengthList = ConfigStrengthMgr.GetAll(); var _configStrengthDic = new Dictionary <int, ConfigStrengthEntity>(strengthList.Count); foreach (var entity in strengthList) { var key = BuildStrengthKey(entity.CardLevel, entity.Source, entity.Target); if (!_configStrengthDic.ContainsKey(key)) { _configStrengthDic.Add(key, entity); } } tips.PlayerStrengthDic = _configStrengthDic; var allSkillConfig = ConfigSkillupgradeMgr.GetAll(); var _SkillUpgradeDic = new Dictionary <int, ConfigSkillupgradeEntity>(allSkillConfig.Count); foreach (var item in allSkillConfig) { var key = GetKey(item.SkillLevel, item.Quality); if (!_SkillUpgradeDic.ContainsKey(key)) { _SkillUpgradeDic.Add(key, item); } else { _SkillUpgradeDic[key] = item; } } tips.SkillUpGradeDic = _SkillUpgradeDic; var allprpo = ConfigPrposellMgr.GetAll(); tips.PrpoSelllist = allprpo; var allSkill = DicSkillstreeMgr.GetAll(); var allSkillDesc = DicSkillstreedesdicMgr.GetAll(); var skillList = new List <ManagerSkillTree>(); foreach (var skill in allSkill) { var desc = allSkillDesc.FindAll(r => r.SkillCode == skill.SkillCode); foreach (var d in desc) { var sk = new ManagerSkillTree(); sk.CoditionPoint = skill.ConditionPoint; sk.Condition = skill.Condition; sk.Description = d.Description; sk.ManagerLevel = skill.RequireManagerLevel; sk.ManagerType = skill.ManagerType; sk.MaxPoint = skill.MaxPoint; sk.SkillCode = skill.SkillCode; sk.SkillLevel = d.SkillLevel; sk.SkillName = skill.SkillName; sk.Opener = skill.Opener; skillList.Add(sk); } } tips.ManagerSkillTree = skillList; #region CombLink //var combLinks = DicPlayerlinkMgr.GetAll(); var cdic = new SortedDictionary <int, int>(); int cno = 0; int cnt = 0; //foreach (var item in combLinks) //{ // if (!cdic.TryGetValue(item.Idx, out cno)) // { // if (!cdic.TryGetValue(item.LinkId, out cno)) // cno = ++cnt; // } // cdic[item.Idx] = cno; // cdic[item.LinkId] = cno; //} var dicComb = new Dictionary <int, string>(); var list = new List <int>(); for (int i = 0; i <= cnt; i++) { cno = 0; list.Clear(); foreach (var kvp in cdic) { if (kvp.Value != i) { continue; } if (cno == 0) { cno = kvp.Key; } else { list.Add(kvp.Key); } } if (list.Count > 0) { dicComb[cno] = string.Join(",", list.ToArray()); } } #endregion foreach (var item in wills) { if (item.WillRank == 1) { tips.LowWill.Add(item); } else { tips.HighWill.Add(item); } dicWill[item.SkillCode] = item; } DicManagerwilltipsEntity will = null; foreach (var g in willParts.GroupBy(i => i.SkillCode)) { if (!dicWill.TryGetValue(g.Key, out will)) { continue; } will.PartList = g.ToList(); } CombTipsEntity comb = null; tips.Combs = new List <CombTipsEntity>(); foreach (var item in dicWill.Values) { if (item.WillRank == 1) { continue; } comb = new CombTipsEntity(item); comb.PartList = new List <CombPartTipsEntity>(); foreach (var part in item.PartList) { if (dicComb.ContainsKey(part.Pid)) { part.LinkPid = dicComb[part.Pid]; } else { part.LinkPid = string.Empty; } comb.PartList.Add(new CombPartTipsEntity(part)); } tips.Combs.Add(comb); } //tips.StarArousalSkills = DicStararousalskillsMgr.GetAll(); tips.Potential = new Dictionary <int, List <ConfigPotentialEntity> >(); var allPotential = ConfigPotentialMgr.GetAll(); foreach (var item in allPotential) { if (!tips.Potential.ContainsKey(item.PotentialId)) { tips.Potential.Add(item.PotentialId, new List <ConfigPotentialEntity>()); } tips.Potential[item.PotentialId].Add(item); } if (includeStarSkillLevel) { tips.StarSkillLevels = DicStarskillleveltipsMgr.GetAll(); } return(tips); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2015/10/19 16:24:59</remarks> public bool Update(DicManagerwilltipsEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/19 16:24:59</remarks> public bool Insert(DicManagerwilltipsEntity entity) { return(Insert(entity, null)); }