/// <summary>
/// 添加定时商品
/// </summary>
/// <param name="timeProductInfo">定时商品信息</param>
public void AddTimeProduct(TimeProductInfo timeProductInfo)
{
DbParameter[] parms = {
GenerateInParam("@pid", SqlDbType.Int, 4, timeProductInfo.Pid),
GenerateInParam("@onsalestate", SqlDbType.TinyInt, 1, timeProductInfo.OnSaleState),
GenerateInParam("@outsalestate", SqlDbType.TinyInt, 1, timeProductInfo.OutSaleState),
GenerateInParam("@onsaletime", SqlDbType.DateTime, 8, timeProductInfo.OnSaleTime),
GenerateInParam("@outsaletime", SqlDbType.DateTime, 8,timeProductInfo.OutSaleTime)
};
string commandText = string.Format("INSERT INTO [{0}timeproducts]([pid],[onsalestate],[outsalestate],[onsaletime],[outsaletime]) VALUES(@pid,@onsalestate,@outsalestate,@onsaletime,@outsaletime)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 更新定时商品
/// </summary>
/// <param name="timeProductInfo">定时商品信息</param>
public static void UpdateTimeProduct(TimeProductInfo timeProductInfo)
{
BrnShop.Data.Products.UpdateTimeProduct(timeProductInfo);
}
/// <summary>
/// 添加定时商品
/// </summary>
/// <param name="timeProductInfo">定时商品信息</param>
public static void AddTimeProduct(TimeProductInfo timeProductInfo)
{
BrnShop.Data.Products.AddTimeProduct(timeProductInfo);
}
/// <summary>
/// 更新定时商品
/// </summary>
/// <param name="timeProductInfo">定时商品信息</param>
public void UpdateTimeProduct(TimeProductInfo timeProductInfo)
{
DbParameter[] parms = {
GenerateInParam("@pid", SqlDbType.Int, 4, timeProductInfo.Pid),
GenerateInParam("@onsalestate", SqlDbType.TinyInt, 1, timeProductInfo.OnSaleState),
GenerateInParam("@outsalestate", SqlDbType.TinyInt, 1, timeProductInfo.OutSaleState),
GenerateInParam("@onsaletime", SqlDbType.DateTime, 8, timeProductInfo.OnSaleTime),
GenerateInParam("@outsaletime", SqlDbType.DateTime, 8,timeProductInfo.OutSaleTime),
GenerateInParam("@recordid", SqlDbType.Int, 4, timeProductInfo.RecordId)
};
string commandText = string.Format("UPDATE [{0}timeproducts] SET [pid]=@pid,[onsalestate]=@onsalestate,[outsalestate]=@outsalestate,[onsaletime]=@onsaletime,[outsaletime]=@outsaletime WHERE [recordid]=@recordid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 添加定时商品
/// </summary>
/// <param name="timeProductInfo">定时商品信息</param>
public static void AddTimeProduct(TimeProductInfo timeProductInfo)
{
BrnShop.Core.BSPData.RDBS.AddTimeProduct(timeProductInfo);
}
/// <summary>
/// 从IDataReader创建TimeProductInfo
/// </summary>
public static TimeProductInfo BuildTimeProductFromReader(IDataReader reader)
{
TimeProductInfo timeProductInfo = new TimeProductInfo();
timeProductInfo.RecordId = TypeHelper.ObjectToInt(reader["recordid"]);
timeProductInfo.Pid = TypeHelper.ObjectToInt(reader["pid"]);
timeProductInfo.OnSaleState = TypeHelper.ObjectToInt(reader["onsalestate"]);
timeProductInfo.OutSaleState = TypeHelper.ObjectToInt(reader["outsalestate"]);
timeProductInfo.OnSaleTime = TypeHelper.ObjectToDateTime(reader["onsaletime"]);
timeProductInfo.OutSaleTime = TypeHelper.ObjectToDateTime(reader["outsaletime"]);
return timeProductInfo;
}
/// <summary>
/// 更新定时商品
/// </summary>
/// <param name="timeProductInfo">定时商品信息</param>
public static void UpdateTimeProduct(TimeProductInfo timeProductInfo)
{
BrnShop.Core.BSPData.RDBS.UpdateTimeProduct(timeProductInfo);
}
public ActionResult AddTimeProduct(TimeProductModel model)
{
PartProductInfo partProductInfo = AdminProducts.AdminGetPartProductById(model.Pid);
if (partProductInfo == null)
ModelState.AddModelError("Pid", "请选择商品");
if (AdminProducts.IsExistTimeProduct(model.Pid))
ModelState.AddModelError("Pid", "此商品已经存在");
if (ModelState.IsValid)
{
DateTime noTime = new DateTime(1900, 1, 1);
TimeProductInfo timeProductInfo = new TimeProductInfo()
{
Pid = model.Pid,
OnSaleState = model.OnSaleTime == null ? 0 : 1,
OutSaleState = model.OutSaleTime == null ? 0 : 1,
OnSaleTime = model.OnSaleTime == null ? noTime : model.OnSaleTime.Value,
OutSaleTime = model.OutSaleTime == null ? noTime : model.OutSaleTime.Value
};
AdminProducts.AddTimeProduct(timeProductInfo);
AddAdminOperateLog("添加定时商品", "添加定时商品,定时商品为:" + partProductInfo.Name);
return PromptView("定时商品添加成功");
}
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
return View(model);
}
