/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/19 15:48:05</remarks> public bool Update(ConfigSkillcardlevelEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ConfigSkillcardlevel_Update"); database.AddInParameter(commandWrapper, "@RowId", DbType.Int32, entity.RowId); database.AddInParameter(commandWrapper, "@SkillClass", DbType.Int32, entity.SkillClass); database.AddInParameter(commandWrapper, "@SkillLevel", DbType.Int32, entity.SkillLevel); database.AddInParameter(commandWrapper, "@MinExp", DbType.Int32, entity.MinExp); database.AddInParameter(commandWrapper, "@MaxExp", DbType.Int32, entity.MaxExp); database.AddInParameter(commandWrapper, "@RowTime", DbType.Date, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.RowId = (System.Int32)database.GetParameterValue(commandWrapper, "@RowId"); return(Convert.ToBoolean(results)); }
public bool TryGetSkillLevel(int skillClass, int skillLevel, out ConfigSkillcardlevelEntity cfg) { cfg = null; Dictionary <int, ConfigSkillcardlevelEntity> cfgs = null; if (!s_dicSkillExp.TryGetValue(skillClass, out cfgs) || !cfgs.TryGetValue(skillLevel, out cfg)) { return(false); } return(null != cfg); }
/// <summary> /// 将IDataReader的当前记录读取到ConfigSkillcardlevelEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ConfigSkillcardlevelEntity LoadSingleRow(IDataReader reader) { var obj = new ConfigSkillcardlevelEntity(); obj.RowId = (System.Int32)reader["RowId"]; obj.SkillClass = (System.Int32)reader["SkillClass"]; obj.SkillLevel = (System.Int32)reader["SkillLevel"]; obj.MinExp = (System.Int32)reader["MinExp"]; obj.MaxExp = (System.Int32)reader["MaxExp"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="rowId">rowId</param> /// <returns>ConfigSkillcardlevelEntity</returns> /// <remarks>2015/10/19 15:48:05</remarks> public ConfigSkillcardlevelEntity GetById(System.Int32 rowId) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ConfigSkillcardlevel_GetById"); database.AddInParameter(commandWrapper, "@RowId", DbType.Int32, rowId); ConfigSkillcardlevelEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2015/10/19 15:48:05</remarks> public bool Update(ConfigSkillcardlevelEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/19 15:48:05</remarks> public bool Insert(ConfigSkillcardlevelEntity entity) { return(Insert(entity, null)); }
public static bool Update(ConfigSkillcardlevelEntity configSkillcardlevelEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ConfigSkillcardlevelProvider(zoneId); return(provider.Update(configSkillcardlevelEntity, trans)); }