/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/5/23 17:24:16</remarks> public bool Update(ConfigVippackageEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ConfigVippackage_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@VipLevel", DbType.Int32, entity.VipLevel); database.AddInParameter(commandWrapper, "@Price", DbType.Int32, entity.Price); database.AddInParameter(commandWrapper, "@PrizeType", DbType.Int32, entity.PrizeType); database.AddInParameter(commandWrapper, "@PrizeItemCode", DbType.Int32, entity.PrizeItemCode); database.AddInParameter(commandWrapper, "@Counts", DbType.Int32, entity.Counts); database.AddInParameter(commandWrapper, "@IsBindlny", DbType.Int32, entity.IsBindlny); database.AddInParameter(commandWrapper, "@PackageId", DbType.Int32, entity.PackageId); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到ConfigVippackageEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ConfigVippackageEntity LoadSingleRow(IDataReader reader) { var obj = new ConfigVippackageEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj.VipLevel = (System.Int32)reader["VipLevel"]; obj.Price = (System.Int32)reader["Price"]; obj.PrizeType = (System.Int32)reader["PrizeType"]; obj.PrizeItemCode = (System.Int32)reader["PrizeItemCode"]; obj.Counts = (System.Int32)reader["Counts"]; obj.IsBindlny = (System.Int32)reader["IsBindlny"]; obj.PackageId = (System.Int32)reader["PackageId"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>ConfigVippackageEntity</returns> /// <remarks>2016/5/23 17:24:16</remarks> public ConfigVippackageEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ConfigVippackage_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); ConfigVippackageEntity 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>2016/5/23 17:24:16</remarks> public bool Update(ConfigVippackageEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/5/23 17:24:16</remarks> public bool Insert(ConfigVippackageEntity entity) { return(Insert(entity, null)); }
public static bool Update(ConfigVippackageEntity configVippackageEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ConfigVippackageProvider(zoneId); return(provider.Update(configVippackageEntity, trans)); }