/// <summary>
/// 更新套装促销活动
/// </summary>
public void UpdateSuitPromotion(SuitPromotionInfo suitPromotionInfo)
{
DbParameter[] parms = {
GenerateInParam("@starttime1", SqlDbType.DateTime,8,suitPromotionInfo.StartTime1),
GenerateInParam("@endtime1", SqlDbType.DateTime,8,suitPromotionInfo.EndTime1),
GenerateInParam("@starttime2", SqlDbType.DateTime,8,suitPromotionInfo.StartTime2),
GenerateInParam("@endtime2", SqlDbType.DateTime,8,suitPromotionInfo.EndTime2),
GenerateInParam("@starttime3", SqlDbType.DateTime,8,suitPromotionInfo.StartTime3),
GenerateInParam("@endtime3", SqlDbType.DateTime,8,suitPromotionInfo.EndTime3),
GenerateInParam("@userranklower", SqlDbType.SmallInt,2,suitPromotionInfo.UserRankLower),
GenerateInParam("@state", SqlDbType.TinyInt,1,suitPromotionInfo.State),
GenerateInParam("@name", SqlDbType.NVarChar,50,suitPromotionInfo.Name),
GenerateInParam("@quotaupper", SqlDbType.Int,4,suitPromotionInfo.QuotaUpper),
GenerateInParam("@onlyonce", SqlDbType.TinyInt, 1, suitPromotionInfo.OnlyOnce),
GenerateInParam("@pmid", SqlDbType.Int,4,suitPromotionInfo.PmId)
};
string commandText = string.Format("UPDATE [{0}suitpromotions] SET [starttime1]=@starttime1,[endtime1]=@endtime1,[starttime2]=@starttime2,[endtime2]=@endtime2,[starttime3]=@starttime3,[endtime3]=@endtime3,[userranklower]=@userranklower,[state]=@state,[name]=@name,[quotaupper]=@quotaupper,[onlyonce]=@onlyonce WHERE [pmid]=@pmid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建套装促销活动
/// </summary>
public int CreateSuitPromotion(SuitPromotionInfo suitPromotionInfo)
{
DbParameter[] parms = {
GenerateInParam("@starttime1", SqlDbType.DateTime,8,suitPromotionInfo.StartTime1),
GenerateInParam("@endtime1", SqlDbType.DateTime,8,suitPromotionInfo.EndTime1),
GenerateInParam("@starttime2", SqlDbType.DateTime,8,suitPromotionInfo.StartTime2),
GenerateInParam("@endtime2", SqlDbType.DateTime,8,suitPromotionInfo.EndTime2),
GenerateInParam("@starttime3", SqlDbType.DateTime,8,suitPromotionInfo.StartTime3),
GenerateInParam("@endtime3", SqlDbType.DateTime,8,suitPromotionInfo.EndTime3),
GenerateInParam("@userranklower", SqlDbType.SmallInt,2,suitPromotionInfo.UserRankLower),
GenerateInParam("@state", SqlDbType.TinyInt,1,suitPromotionInfo.State),
GenerateInParam("@name", SqlDbType.NVarChar,50,suitPromotionInfo.Name),
GenerateInParam("@quotaupper", SqlDbType.Int,4,suitPromotionInfo.QuotaUpper),
GenerateInParam("@onlyonce", SqlDbType.TinyInt, 1, suitPromotionInfo.OnlyOnce)
};
string commandText = string.Format("INSERT INTO [{0}suitpromotions]([starttime1],[endtime1],[starttime2],[endtime2],[starttime3],[endtime3],[userranklower],[state],[name],[quotaupper],[onlyonce]) VALUES(@starttime1,@endtime1,@starttime2,@endtime2,@starttime3,@endtime3,@userranklower,@state,@name,@quotaupper,@onlyonce);SELECT SCOPE_IDENTITY();",
RDBSHelper.RDBSTablePre);
return TypeHelper.ObjectToInt(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms), -1);
}
public ActionResult AddSuitPromotion(SuitPromotionModel model)
{
if (ModelState.IsValid)
{
DateTime noTime = new DateTime(1900, 1, 1);
SuitPromotionInfo suitPromotionInfo = new SuitPromotionInfo()
{
StartTime1 = model.StartTime1,
EndTime1 = model.EndTime1,
StartTime2 = model.StartTime2.HasValue ? model.StartTime2.Value : noTime,
EndTime2 = model.EndTime2.HasValue ? model.EndTime2.Value : noTime,
StartTime3 = model.StartTime3.HasValue ? model.StartTime3.Value : noTime,
EndTime3 = model.EndTime3.HasValue ? model.EndTime3.Value : noTime,
UserRankLower = model.UserRankLower,
State = model.State,
Name = model.PromotionName,
QuotaUpper = model.QuotaUpper,
OnlyOnce = model.OnlyOnce
};
AdminPromotions.CreateSuitPromotion(suitPromotionInfo);
AddAdminOperateLog("添加套装促销活动", "添加套装促销活动,套装促销活动为:" + model.PromotionName);
return PromptView("套装促销活动添加成功");
}
LoadSuitPromotion();
return View(model);
}
/// <summary>
/// 创建套装促销活动
/// </summary>
public static int CreateSuitPromotion(SuitPromotionInfo suitPromotionInfo)
{
return BrnShop.Core.BSPData.RDBS.CreateSuitPromotion(suitPromotionInfo);
}
/// <summary>
/// 从IDataReader创建SuitPromotionInfo
/// </summary>
public static SuitPromotionInfo BuildSuitPromotionFromReader(IDataReader reader)
{
SuitPromotionInfo suitPromotionInfo = new SuitPromotionInfo();
suitPromotionInfo.PmId = TypeHelper.ObjectToInt(reader["pmid"]);
suitPromotionInfo.StartTime1 = TypeHelper.ObjectToDateTime(reader["starttime1"]);
suitPromotionInfo.EndTime1 = TypeHelper.ObjectToDateTime(reader["endtime1"]);
suitPromotionInfo.StartTime2 = TypeHelper.ObjectToDateTime(reader["starttime2"]);
suitPromotionInfo.EndTime2 = TypeHelper.ObjectToDateTime(reader["endtime2"]);
suitPromotionInfo.StartTime3 = TypeHelper.ObjectToDateTime(reader["starttime3"]);
suitPromotionInfo.EndTime3 = TypeHelper.ObjectToDateTime(reader["endtime3"]);
suitPromotionInfo.UserRankLower = TypeHelper.ObjectToInt(reader["userranklower"]);
suitPromotionInfo.State = TypeHelper.ObjectToInt(reader["state"]);
suitPromotionInfo.Name = reader["name"].ToString();
suitPromotionInfo.QuotaUpper = TypeHelper.ObjectToInt(reader["quotaupper"]);
suitPromotionInfo.OnlyOnce = TypeHelper.ObjectToInt(reader["onlyonce"]);
return suitPromotionInfo;
}
/// <summary>
/// 更新套装促销活动
/// </summary>
public static void UpdateSuitPromotion(SuitPromotionInfo suitPromotionInfo)
{
BrnShop.Core.BSPData.RDBS.UpdateSuitPromotion(suitPromotionInfo);
if (_promotionnosql != null)
_promotionnosql.DeleteSuitPromotion(suitPromotionInfo.PmId);
}