/// <summary>
/// 通过IDataReader创建CouponTypeInfo信息
/// </summary>
public static CouponTypeInfo BuildCouponTypeFromReader(IDataReader reader)
{
CouponTypeInfo couponTypeInfo = new CouponTypeInfo();
couponTypeInfo.CouponTypeId = TypeHelper.ObjectToInt(reader["coupontypeid"]);
couponTypeInfo.StoreId = TypeHelper.ObjectToInt(reader["storeid"]);
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.LimitStoreCid = TypeHelper.ObjectToInt(reader["limitstorecid"]);
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;
}
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()
{
StoreId = model.StoreId,
Name = model.CouponTypeName,
Money = model.Money,
Count = model.Count,
SendMode = model.SendModel,
GetMode = model.GetModel,
UseMode = model.UseModel,
UserRankLower = model.UserRankLower,
OrderAmountLower = model.OrderAmountLower,
LimitStoreCid = model.LimitStoreCid,
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);
AddMallAdminLog("添加优惠劵类型", "添加优惠劵类型,优惠劵类型为:" + model.CouponTypeName);
return PromptView("优惠劵类型添加成功");
}
LoadCouponType();
return View(model);
}
/// <summary>
/// 创建优惠劵类型
/// </summary>
/// <param name="couponTypeInfo">优惠劵类型信息</param>
public void CreateCouponType(CouponTypeInfo couponTypeInfo)
{
DbParameter[] parms = {
GenerateInParam("@storeid", SqlDbType.Int,4,couponTypeInfo.StoreId),
GenerateInParam("@state", SqlDbType.TinyInt,1,couponTypeInfo.State),
GenerateInParam("@name", SqlDbType.NVarChar, 50, couponTypeInfo.Name),
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("@limitstorecid", SqlDbType.Int,4,couponTypeInfo.LimitStoreCid),
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]([storeid],[state],[name],[money],[count],[sendmode],[getmode],[usemode],[userranklower],[orderamountlower],[limitstorecid],[limitproduct],[sendstarttime],[sendendtime],[useexpiretime],[usestarttime],[useendtime]) VALUES(@storeid,@state,@name,@money,@count,@sendmode,@getmode,@usemode,@userranklower,@orderamountlower,@limitstorecid,@limitproduct,@sendstarttime,@sendendtime,@useexpiretime,@usestarttime,@useendtime)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 领取优惠劵
/// </summary>
/// <param name="partUserInfo">用户信息</param>
/// <param name="couponTypeInfo">优惠劵类型信息</param>
/// <param name="pullTime">领取时间</param>
/// <param name="pullIP">领取ip</param>
/// <returns></returns>
public static string PullCoupon(PartUserInfo partUserInfo, CouponTypeInfo couponTypeInfo, DateTime pullTime, string pullIP)
{
int sendCount = GetSendCouponCount(couponTypeInfo.CouponTypeId);
BrnMall.Core.BMACache.Insert(CacheKeys.MALL_COUPONTYPE_SENDCOUNT + couponTypeInfo.CouponTypeId, sendCount + 1);
string couponSN = GenerateCouponSN();
CouponInfo couponInfo = new CouponInfo();
couponInfo.CouponSN = couponSN;
couponInfo.Uid = partUserInfo.Uid;
couponInfo.CouponTypeId = couponTypeInfo.CouponTypeId;
couponInfo.StoreId = couponTypeInfo.StoreId;
couponInfo.Oid = 0;
couponInfo.UseTime = new DateTime(1900, 1, 1);
couponInfo.UseIP = "";
couponInfo.Money = couponTypeInfo.Money;
couponInfo.ActivateTime = pullTime;
couponInfo.ActivateIP = pullIP;
couponInfo.CreateUid = partUserInfo.Uid;
couponInfo.CreateOid = 0;
couponInfo.CreateTime = pullTime;
couponInfo.CreateIP = pullIP;
CreateCoupon(couponInfo);
return couponSN;
}
/// <summary>
/// 创建优惠劵类型
/// </summary>
/// <param name="couponTypeInfo">优惠劵类型信息</param>
public static void CreateCouponType(CouponTypeInfo couponTypeInfo)
{
BrnMall.Data.Coupons.CreateCouponType(couponTypeInfo);
}
/// <summary>
/// 创建优惠劵类型
/// </summary>
/// <param name="couponTypeInfo">优惠劵类型信息</param>
public static void CreateCouponType(CouponTypeInfo couponTypeInfo)
{
BrnMall.Core.BMAData.RDBS.CreateCouponType(couponTypeInfo);
}
