/// <summary> /// 创建优惠劵类型 /// </summary> /// <param name="couponTypeInfo">优惠劵类型信息</param> public void CreateCouponType(CouponTypeInfo couponTypeInfo) { DbParameter[] parms = { GenerateInParam("@name", SqlDbType.NVarChar, 50, couponTypeInfo.Name), GenerateInParam("@state", SqlDbType.TinyInt,1,couponTypeInfo.State), GenerateInParam("@money", SqlDbType.Int,4,couponTypeInfo.Money), GenerateInParam("@count", SqlDbType.Int,4,couponTypeInfo.Count), GenerateInParam("@sendmode", SqlDbType.TinyInt,1,couponTypeInfo.SendMode), GenerateInParam("@getmode", SqlDbType.TinyInt,1,couponTypeInfo.GetMode), GenerateInParam("@usemode", SqlDbType.TinyInt,1,couponTypeInfo.UseMode), GenerateInParam("@userranklower", SqlDbType.SmallInt,2,couponTypeInfo.UserRankLower), GenerateInParam("@orderamountlower", SqlDbType.Int,4,couponTypeInfo.OrderAmountLower), GenerateInParam("@limitcateid", SqlDbType.SmallInt,2,couponTypeInfo.LimitCateId), GenerateInParam("@limitbrandid", SqlDbType.Int,4,couponTypeInfo.LimitBrandId), GenerateInParam("@limitproduct", SqlDbType.TinyInt,1,couponTypeInfo.LimitProduct), GenerateInParam("@sendstarttime", SqlDbType.DateTime,8,couponTypeInfo.SendStartTime), GenerateInParam("@sendendtime", SqlDbType.DateTime,8,couponTypeInfo.SendEndTime), GenerateInParam("@useexpiretime", SqlDbType.Int,4,couponTypeInfo.UseExpireTime), GenerateInParam("@usestarttime", SqlDbType.DateTime,8,couponTypeInfo.UseStartTime), GenerateInParam("@useendtime", SqlDbType.DateTime,8,couponTypeInfo.UseEndTime) }; string commandText = string.Format("INSERT INTO [{0}coupontypes]([name],[state],[money],[count],[sendmode],[getmode],[usemode],[userranklower],[orderamountlower],[limitcateid],[limitbrandid],[limitproduct],[sendstarttime],[sendendtime],[useexpiretime],[usestarttime],[useendtime]) VALUES(@name,@state,@money,@count,@sendmode,@getmode,@usemode,@userranklower,@orderamountlower,@limitcateid,@limitbrandid,@limitproduct,@sendstarttime,@sendendtime,@useexpiretime,@usestarttime,@useendtime)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
public ActionResult AddCouponType(CouponTypeModel model) { if (ModelState.IsValid) { DateTime nullTime = new DateTime(1970, 1, 1); if (model.SendModel == 1 || model.SendModel == 2) { model.GetModel = 0; model.SendStartTime = nullTime; model.SendEndTime = nullTime; } if (model.UseTimeType == 1) { model.UseStartTime = nullTime; model.UseEndTime = nullTime; } else { model.UseExpireTime = 0; } CouponTypeInfo couponTypeInfo = new CouponTypeInfo() { Name = model.CouponTypeName, Money = model.Money, Count = model.Count, SendMode = model.SendModel, GetMode = model.GetModel, UseMode = model.UseModel, UserRankLower = model.UserRankLower, OrderAmountLower = model.OrderAmountLower, LimitCateId = model.LimitCateId, LimitBrandId = model.LimitBrandId, LimitProduct = model.LimitProduct, SendStartTime = model.SendStartTime.Value, SendEndTime = model.SendEndTime.Value, UseExpireTime = model.UseExpireTime, UseStartTime = model.UseStartTime.Value, UseEndTime = model.UseEndTime.Value, State = model.State }; AdminCoupons.CreateCouponType(couponTypeInfo); AddAdminOperateLog("添加优惠劵类型", "添加优惠劵类型,优惠劵类型为:" + model.CouponTypeName); return PromptView("优惠劵类型添加成功"); } LoadCouponType(); return View(model); }
/// <summary> /// 通过IDataReader创建CouponTypeInfo信息 /// </summary> public static CouponTypeInfo BuildCouponTypeFromReader(IDataReader reader) { CouponTypeInfo couponTypeInfo = new CouponTypeInfo(); couponTypeInfo.CouponTypeId = TypeHelper.ObjectToInt(reader["coupontypeid"]); couponTypeInfo.State = TypeHelper.ObjectToInt(reader["state"]); couponTypeInfo.Name = reader["name"].ToString(); couponTypeInfo.Money = TypeHelper.ObjectToInt(reader["money"]); couponTypeInfo.Count = TypeHelper.ObjectToInt(reader["count"]); couponTypeInfo.SendMode = TypeHelper.ObjectToInt(reader["sendmode"]); couponTypeInfo.GetMode = TypeHelper.ObjectToInt(reader["getmode"]); couponTypeInfo.UseMode = TypeHelper.ObjectToInt(reader["usemode"]); couponTypeInfo.UserRankLower = TypeHelper.ObjectToInt(reader["userranklower"]); couponTypeInfo.OrderAmountLower = TypeHelper.ObjectToInt(reader["orderamountlower"]); couponTypeInfo.LimitCateId = TypeHelper.ObjectToInt(reader["limitcateid"]); couponTypeInfo.LimitBrandId = TypeHelper.ObjectToInt(reader["limitbrandid"]); couponTypeInfo.LimitProduct = TypeHelper.ObjectToInt(reader["limitproduct"]); couponTypeInfo.SendStartTime = TypeHelper.ObjectToDateTime(reader["sendstarttime"]); couponTypeInfo.SendEndTime = TypeHelper.ObjectToDateTime(reader["sendendtime"]); couponTypeInfo.UseExpireTime = TypeHelper.ObjectToInt(reader["useexpiretime"]); couponTypeInfo.UseStartTime = TypeHelper.ObjectToDateTime(reader["usestarttime"]); couponTypeInfo.UseEndTime = TypeHelper.ObjectToDateTime(reader["useendtime"]); return couponTypeInfo; }
/// <summary> /// 创建优惠劵类型 /// </summary> /// <param name="couponTypeInfo">优惠劵类型信息</param> public static void CreateCouponType(CouponTypeInfo couponTypeInfo) { BrnShop.Core.BSPData.RDBS.CreateCouponType(couponTypeInfo); }
/// <summary> /// 创建优惠劵类型 /// </summary> /// <param name="couponTypeInfo">优惠劵类型信息</param> public static void CreateCouponType(CouponTypeInfo couponTypeInfo) { BrnShop.Data.Coupons.CreateCouponType(couponTypeInfo); }