/// <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); }