/// <summary> /// 从IDataReader创建BuySendPromotionInfo /// </summary> public static BuySendPromotionInfo BuildBuySendPromotionFromReader(IDataReader reader) { BuySendPromotionInfo buySendPromotionInfo = new BuySendPromotionInfo(); buySendPromotionInfo.PmId = TypeHelper.ObjectToInt(reader["pmid"]); buySendPromotionInfo.StoreId = TypeHelper.ObjectToInt(reader["storeid"]); buySendPromotionInfo.StartTime = TypeHelper.ObjectToDateTime(reader["starttime"]); buySendPromotionInfo.EndTime = TypeHelper.ObjectToDateTime(reader["endtime"]); buySendPromotionInfo.UserRankLower = TypeHelper.ObjectToInt(reader["userranklower"]); buySendPromotionInfo.State = TypeHelper.ObjectToInt(reader["state"]); buySendPromotionInfo.Name = reader["name"].ToString(); buySendPromotionInfo.Type = TypeHelper.ObjectToInt(reader["type"]); buySendPromotionInfo.BuyCount = TypeHelper.ObjectToInt(reader["buycount"]); buySendPromotionInfo.SendCount = TypeHelper.ObjectToInt(reader["sendcount"]); return buySendPromotionInfo; }
/// <summary> /// 获得买送促销活动 /// </summary> /// <param name="buyCount">购买数量</param> /// <param name="pid">商品id</param> /// <param name="buyTime">购买时间</param> /// <returns></returns> public static BuySendPromotionInfo GetBuySendPromotion(int buyCount, int pid, DateTime buyTime) { BuySendPromotionInfo buySendPromotionInfo = null; //获得买送促销活动列表 List <BuySendPromotionInfo> buySendPromotionList = GetBuySendPromotionList(pid, buyTime); //买送促销活动存在时 if (buySendPromotionList.Count > 0) { foreach (BuySendPromotionInfo item in buySendPromotionList) { if (item.BuyCount <= buyCount) { buySendPromotionInfo = item; } } } return(buySendPromotionInfo); }
public ActionResult AddBuySendPromotion(BuySendPromotionModel model) { if (ModelState.IsValid) { BuySendPromotionInfo buySendPromotionInfo = new BuySendPromotionInfo() { StartTime = model.StartTime, EndTime = model.EndTime, UserRankLower = model.UserRankLower, State = model.State, Name = model.PromotionName, Type = model.Type, BuyCount = model.BuyCount, SendCount = model.SendCount }; AdminPromotions.CreateBuySendPromotion(buySendPromotionInfo); AddAdminOperateLog("添加买送促销", "添加买送促销,买送促销为:" + model.PromotionName); return PromptView("买送促销添加成功"); } LoadBuySendPromotion(); return View(model); }
/// <summary> /// 更新买送促销活动 /// </summary> public void UpdateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { DbParameter[] parms = { GenerateInParam("@starttime", SqlDbType.DateTime,8,buySendPromotionInfo.StartTime), GenerateInParam("@endtime", SqlDbType.DateTime,8,buySendPromotionInfo.EndTime), GenerateInParam("@userranklower", SqlDbType.SmallInt,2,buySendPromotionInfo.UserRankLower), GenerateInParam("@state", SqlDbType.TinyInt,1,buySendPromotionInfo.State), GenerateInParam("@name", SqlDbType.NVarChar,50,buySendPromotionInfo.Name), GenerateInParam("@type", SqlDbType.TinyInt,1,buySendPromotionInfo.Type), GenerateInParam("@buycount", SqlDbType.TinyInt, 1, buySendPromotionInfo.BuyCount), GenerateInParam("@sendcount", SqlDbType.TinyInt, 1, buySendPromotionInfo.SendCount), GenerateInParam("@pmid", SqlDbType.Int,4,buySendPromotionInfo.PmId) }; string commandText = string.Format("UPDATE [{0}buysendpromotions] SET [starttime]=@starttime,[endtime]=@endtime,[userranklower]=@userranklower,[state]=@state,[name]=@name,[type]=@type,[buycount]=@buycount,[sendcount]=@sendcount WHERE [pmid]=@pmid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 创建买送促销活动 /// </summary> public void CreateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { DbParameter[] parms = { GenerateInParam("@starttime", SqlDbType.DateTime,8,buySendPromotionInfo.StartTime), GenerateInParam("@endtime", SqlDbType.DateTime,8,buySendPromotionInfo.EndTime), GenerateInParam("@userranklower", SqlDbType.SmallInt,2,buySendPromotionInfo.UserRankLower), GenerateInParam("@state", SqlDbType.TinyInt,1,buySendPromotionInfo.State), GenerateInParam("@name", SqlDbType.NVarChar,50,buySendPromotionInfo.Name), GenerateInParam("@type", SqlDbType.TinyInt,1,buySendPromotionInfo.Type), GenerateInParam("@buycount", SqlDbType.TinyInt, 1, buySendPromotionInfo.BuyCount), GenerateInParam("@sendcount", SqlDbType.TinyInt, 1, buySendPromotionInfo.SendCount) }; string commandText = string.Format("INSERT INTO [{0}buysendpromotions]([starttime],[endtime],[userranklower],[state],[name],[type],[buycount],[sendcount]) VALUES(@starttime,@endtime,@userranklower,@state,@name,@type,@buycount,@sendcount)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新买送促销活动 /// </summary> public static void UpdateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { BrnMall.Data.Promotions.UpdateBuySendPromotion(buySendPromotionInfo); }
/// <summary> /// 设置订单商品的买送促销活动 /// </summary> /// <param name="orderProductInfo">订单商品</param> /// <param name="buyCount">购买数量</param> /// <param name="buySendPromotionInfo">买送优惠活动</param> public static void SetBuySendPromotionOfOrderProduct(OrderProductInfo orderProductInfo, int buyCount, BuySendPromotionInfo buySendPromotionInfo) { orderProductInfo.RealCount = buyCount + (buyCount / buySendPromotionInfo.BuyCount) * buySendPromotionInfo.SendCount; orderProductInfo.BuyCount = buyCount; orderProductInfo.ExtCode2 = buySendPromotionInfo.PmId; }
/// <summary> /// 创建买送促销活动 /// </summary> public static void CreateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { BrnShop.Data.Promotions.CreateBuySendPromotion(buySendPromotionInfo); }
/// <summary> /// 更新买送促销活动 /// </summary> public static void UpdateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { BrnMall.Core.BMAData.RDBS.UpdateBuySendPromotion(buySendPromotionInfo); if (_promotionnosql != null) _promotionnosql.ClearAllBuySendPromotion(buySendPromotionInfo.StoreId); }
/// <summary> /// 创建买送促销活动 /// </summary> public static void CreateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { BrnShop.Core.BSPData.RDBS.CreateBuySendPromotion(buySendPromotionInfo); if (_promotionnosql != null) _promotionnosql.ClearAllBuySendPromotion(); }
/// <summary> /// 更新买送促销活动 /// </summary> public static void UpdateBuySendPromotion(BuySendPromotionInfo buySendPromotionInfo) { NStore.Data.Promotions.UpdateBuySendPromotion(buySendPromotionInfo); }