/// <summary> /// 将IDataReader的当前记录读取到DicMallitemEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public DicMallitemEntity LoadSingleRow(IDataReader reader) { var obj = new DicMallitemEntity(); obj.MallCode = (System.Int32)reader["MallCode"]; obj.Name = (System.String)reader["Name"]; obj.MallType = (System.Int32)reader["MallType"]; obj.Quality = (System.Int32)reader["Quality"]; obj.ShowOrder = (System.Int32)reader["ShowOrder"]; obj.ImageId = (System.Int32)reader["ImageId"]; obj.ItemIntro = (System.String)reader["ItemIntro"]; obj.ItemTip = (System.String)reader["ItemTip"]; obj.UseNote = (System.String)reader["UseNote"]; obj.UseMsg = (System.String)reader["UseMsg"]; obj.UseLevel = (System.Int32)reader["UseLevel"]; obj.ShowUse = (System.Boolean)reader["ShowUse"]; obj.CurrencyType = (System.Int32)reader["CurrencyType"]; obj.CurrencyCount = (System.Int32)reader["CurrencyCount"]; obj.CurrencyDiscount = (System.String)reader["CurrencyDiscount"]; obj.EffectType = (System.Int32)reader["EffectType"]; obj.EffectValue = (System.Int32)reader["EffectValue"]; obj.ShowFlag = (System.Boolean)reader["ShowFlag"]; obj.HotFlag = (System.Boolean)reader["HotFlag"]; obj.PackageFlag = (System.Boolean)reader["PackageFlag"]; obj.ShowBatch = (System.Boolean)reader["ShowBatch"]; return(obj); }
List <PointInTime> CalDiscount(DicMallitemEntity entity) { if (string.IsNullOrEmpty(entity.CurrencyDiscount)) { return(new List <PointInTime>(0)); } else { //0,0~100&1000,2000~60 string[] commandValues = entity.CurrencyDiscount.Split('&'); var pointInTimes = new List <PointInTime>(commandValues.Length); foreach (var commandValue in commandValues) { string[] rateInTimes = commandValue.Split('~'); string[] times = rateInTimes[0].Split(','); int discount = Convert.ToInt32(rateInTimes[1]); var pointEntity = new PointInTime(); pointEntity.Point = entity.CurrencyCount * discount / 100; pointEntity.StartTime = ShareUtil.BaseTime.AddMinutes(Convert.ToInt32(times[0])); pointEntity.EndTime = ShareUtil.BaseTime.AddMinutes(Convert.ToInt32(times[1])); pointInTimes.Add(pointEntity); } return(pointInTimes); } }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/19 15:57:49</remarks> public bool Update(DicMallitemEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_DicMallitem_Update"); database.AddInParameter(commandWrapper, "@MallCode", DbType.Int32, entity.MallCode); database.AddInParameter(commandWrapper, "@Name", DbType.String, entity.Name); database.AddInParameter(commandWrapper, "@MallType", DbType.Int32, entity.MallType); database.AddInParameter(commandWrapper, "@Quality", DbType.Int32, entity.Quality); database.AddInParameter(commandWrapper, "@ShowOrder", DbType.Int32, entity.ShowOrder); database.AddInParameter(commandWrapper, "@ImageId", DbType.Int32, entity.ImageId); database.AddInParameter(commandWrapper, "@ItemIntro", DbType.String, entity.ItemIntro); database.AddInParameter(commandWrapper, "@ItemTip", DbType.String, entity.ItemTip); database.AddInParameter(commandWrapper, "@UseNote", DbType.String, entity.UseNote); database.AddInParameter(commandWrapper, "@UseMsg", DbType.String, entity.UseMsg); database.AddInParameter(commandWrapper, "@UseLevel", DbType.Int32, entity.UseLevel); database.AddInParameter(commandWrapper, "@ShowUse", DbType.Boolean, entity.ShowUse); database.AddInParameter(commandWrapper, "@CurrencyType", DbType.Int32, entity.CurrencyType); database.AddInParameter(commandWrapper, "@CurrencyCount", DbType.Int32, entity.CurrencyCount); database.AddInParameter(commandWrapper, "@CurrencyDiscount", DbType.AnsiString, entity.CurrencyDiscount); database.AddInParameter(commandWrapper, "@EffectType", DbType.Int32, entity.EffectType); database.AddInParameter(commandWrapper, "@EffectValue", DbType.Int32, entity.EffectValue); database.AddInParameter(commandWrapper, "@ShowFlag", DbType.Boolean, entity.ShowFlag); database.AddInParameter(commandWrapper, "@HotFlag", DbType.Boolean, entity.HotFlag); database.AddInParameter(commandWrapper, "@PackageFlag", DbType.Boolean, entity.PackageFlag); database.AddInParameter(commandWrapper, "@ShowBatch", DbType.Boolean, entity.ShowBatch); 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="mallCode">mallCode</param> /// <returns>DicMallitemEntity</returns> /// <remarks>2015/10/19 15:57:49</remarks> public DicMallitemEntity GetById(System.Int32 mallCode) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_DicMallitem_GetById"); database.AddInParameter(commandWrapper, "@MallCode", DbType.Int32, mallCode); DicMallitemEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public static bool Update(DicMallitemEntity dicMallitemEntity, DbTransaction trans = null, string zoneId = "") { var provider = new DicMallitemProvider(zoneId); return(provider.Update(dicMallitemEntity, trans)); }
private string SaveBuyPointShipmentsTx(NbManagerEntity manager, int point, int bonus, PayChargehistoryEntity payEntity, ManagerMonthcardEntity monthcardEntity, MailBuilder mail, ManagerChargenumberEntity buyRecord, DicMallitemEntity mallConfig, string zoneId) { if (point > 0 || bonus > 0) { var messCode1 = PayCore.Instance.AddPoint(payEntity.Account, point, bonus, EnumChargeSourceType.GmCharge, payEntity.BillingId, null, zoneId); if (messCode1 != MessageCode.Success) { return("增加钻石失败" + point + "," + bonus + "," + (int)messCode1); } PayChargehistoryMgr.Insert(payEntity, null, zoneId); } if (monthcardEntity != null) { if (monthcardEntity.BuyNumber == 1) { if (!ManagerMonthcardMgr.Insert(monthcardEntity, null, zoneId)) { return("月卡发送失败"); } } else { if (!ManagerMonthcardMgr.Update(monthcardEntity, null, zoneId)) { return("月卡发送失败"); } } } if (!mail.Save(zoneId)) { return("邮件发送失败"); } if (buyRecord.Idx == 0) { ManagerChargenumberMgr.Insert(buyRecord, null, zoneId); } else { ManagerChargenumberMgr.Update(buyRecord, null, zoneId); } try { if (manager != null) { var curScore = mallConfig.EffectValue * 10; var vipManager = VipManagerMgr.GetById(manager.Idx, zoneId); if (vipManager != null) { curScore += vipManager.VipExp; vipManager.VipExp = curScore; VipManagerMgr.Update(vipManager, null, zoneId); } else { vipManager = new VipManagerEntity(manager.Idx, curScore, DateTime.Now, DateTime.Now, DateTime.Now); VipManagerMgr.Insert(vipManager, null, zoneId); } var newlevel = CacheFactory.VipdicCache.GetVipLevel(curScore); if (newlevel > manager.VipLevel) { manager.VipLevel = newlevel; ManagerUtil.SaveManagerData(manager, null, null, zoneId); } } } catch (Exception ex) { SystemlogMgr.Error("ChargeUpVip", ex); return(ex.Message); } return(""); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2015/10/19 15:57:49</remarks> public bool Update(DicMallitemEntity 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:57:49</remarks> public bool Insert(DicMallitemEntity entity) { return(Insert(entity, null)); }
static MallItemDescriptionEntity BuildMallDescription(DicItemEntity itemEntity, DicMallitemEntity mallEntity) { var entity = new MallItemDescriptionEntity(); entity.ItemCode = itemEntity.ItemCode; entity.ItemType = itemEntity.ItemType; entity.Name = itemEntity.ItemName; entity.ImageId = itemEntity.ImageId; entity.Idx = mallEntity.MallCode; entity.ItemIntro = mallEntity.ItemIntro; entity.ItemTip = mallEntity.ItemTip; entity.UseMsg = mallEntity.UseMsg; entity.UseNote = mallEntity.UseNote; entity.Quality = mallEntity.Quality; entity.UseLevel = mallEntity.UseLevel; entity.ImageId = itemEntity.ImageId; entity.ShowUse = mallEntity.ShowUse ? 1 : 0; entity.ShowBatch = mallEntity.ShowBatch ? 1 : 0; return(entity); }