/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/2/19 15:23:11</remarks> public bool Update(ConfigDaysattendprizeEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_ConfigDaysattendprize_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@PrizeType", DbType.Int32, entity.PrizeType); database.AddInParameter(commandWrapper, "@PrizeItemCode", DbType.Int32, entity.PrizeItemCode); database.AddInParameter(commandWrapper, "@Count", DbType.Int32, entity.Count); database.AddInParameter(commandWrapper, "@HasDouble", DbType.Boolean, entity.HasDouble); database.AddInParameter(commandWrapper, "@DoubleVipLevel", DbType.Int32, entity.DoubleVipLevel); database.AddInParameter(commandWrapper, "@IsBinding", DbType.Boolean, entity.IsBinding); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Int32)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
private MessageCode SendPrize(Guid managerId, ConfigDaysattendprizeEntity prizeEntity) { bool doublePrize = false; var manager = ManagerCore.Instance.GetManager(managerId); if (manager == null) { return(MessageCode.NbParameterError); } //是否有双倍奖励 if (prizeEntity.HasDouble && manager.VipLevel >= prizeEntity.DoubleVipLevel) { doublePrize = true; } var code = MessageCode.Success; switch (prizeEntity.PrizeType) { case 1: //点券 var point = prizeEntity.Count; if (doublePrize) { point = point * 2; } code = PayCore.Instance.AddBonus(managerId, point, EnumChargeSourceType.LeaguePrize, ShareUtil.GenerateComb().ToString(), null); break; case 2: //奖励物品 var count = prizeEntity.Count; if (doublePrize) { count = count * 2; } //获取背包 var package = ItemCore.Instance.GetPackage(managerId, EnumTransactionType.LeaguePrize); if (package == null) { return(MessageCode.NbNoPackage); } code = package.AddItems(prizeEntity.PrizeItemCode, count, 1, prizeEntity.IsBinding, false); if (package.Save()) { package.Shadow.Save(); } break; } return(code); }
/// <summary> /// 将IDataReader的当前记录读取到ConfigDaysattendprizeEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public ConfigDaysattendprizeEntity LoadSingleRow(IDataReader reader) { var obj = new ConfigDaysattendprizeEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj.PrizeType = (System.Int32)reader["PrizeType"]; obj.PrizeItemCode = (System.Int32)reader["PrizeItemCode"]; obj.Count = (System.Int32)reader["Count"]; obj.HasDouble = (System.Boolean)reader["HasDouble"]; obj.DoubleVipLevel = (System.Int32)reader["DoubleVipLevel"]; obj.IsBinding = (System.Boolean)reader["IsBinding"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>ConfigDaysattendprizeEntity</returns> /// <remarks>2016/2/19 15:23:11</remarks> public ConfigDaysattendprizeEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_ConfigDaysattendprize_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); ConfigDaysattendprizeEntity 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/2/19 15:23:11</remarks> public bool Update(ConfigDaysattendprizeEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/2/19 15:23:11</remarks> public bool Insert(ConfigDaysattendprizeEntity entity) { return(Insert(entity, null)); }
public static bool Update(ConfigDaysattendprizeEntity configDaysattendprizeEntity, DbTransaction trans = null, string zoneId = "") { var provider = new ConfigDaysattendprizeProvider(zoneId); return(provider.Update(configDaysattendprizeEntity, trans)); }