/// <summary> /// 编辑产品 /// </summary> /// <param name="mproduct"></param> /// <param name="productimgurl"></param> /// <param name="path"></param> /// <returns></returns> public string EditeProduct(Mproduct mproduct, HttpPostedFileBase productimgurl, string path) { MwxResult mwxResult = new MwxResult() { errcode = -1 }; if (productimgurl != null) { string savePath = string.Empty; string fileSave = FileOpert.UploadImg(productimgurl, path + "uploadFile\\" + System.DateTime.Now.ToString("yyyy") + "\\", out savePath); if (string.IsNullOrEmpty(fileSave)) { mproduct.productimgurl = savePath.Replace(path, ""); } } bool addResult = new ProductService().UpdateProdctPrice(mproduct.productid, (decimal)mproduct.origprice, (decimal)mproduct.sellprice, (int)mproduct.stock, (int)mproduct.priority, mproduct); if (addResult) { mwxResult.errmsg = "保存成功!"; mwxResult.errcode = 0; CacheData.allRecommendPro = null; CacheData.allRecommendProList = null; } else { mwxResult.errmsg = "保存失败!"; } return(JsonHelper.GetJson <MwxResult>(mwxResult)); }
public ActionResult Edit(Mproduct mproduct, HttpPostedFileBase file) { if (ModelState.IsValid) { string slug = Mystring.ToSlug(mproduct.name.ToString()); file = Request.Files["img"]; string filename = file.FileName.ToString(); if (filename.Equals("") == false) { var namecateDb = db.Categorys.Where(m => m.ID == mproduct.catid).First(); string namecate = Mystring.ToStringNospace(namecateDb.name); string ExtensionFile = Mystring.GetFileExtension(filename); string namefilenew = namecate + "/" + slug + "." + ExtensionFile; var path = Path.Combine(Server.MapPath("~/public/images"), namefilenew); var folder = Server.MapPath("~/public/images/" + namecate); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } file.SaveAs(path); mproduct.img = namefilenew; } mproduct.slug = slug; mproduct.updated_at = DateTime.Now; mproduct.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(mproduct).State = EntityState.Modified; db.SaveChanges(); ViewBag.listCate = db.Categorys.Where(m => m.status != 0 && m.ID > 2).ToList(); Message.set_flash("Sửa thành công", "success"); return(RedirectToAction("Index")); } Message.set_flash("Sửa thất bại", "danger"); ViewBag.listCate = db.Categorys.Where(m => m.status != 0 && m.ID > 2).ToList(); return(View(mproduct)); }
public ActionResult DeleteConfirmed(int id) { Mproduct mproduct = db.Products.Find(id); db.Products.Remove(mproduct); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// 新增产品 /// </summary> /// <param name="mproduct"></param> /// <param name="productimgurl"></param> /// <param name="path"></param> /// <returns></returns> public string AddProduct(Mproduct mproduct, HttpPostedFileBase productimgurl, string path) { MwxResult mwxResult = new MwxResult() { errcode = -1 }; //// 实现步骤 //// 1.数据合法性验证 //// 2.图片入库 //// 3.数据落地 string savePath = string.Empty; mwxResult.errmsg = this.CheckedProduct(mproduct); if (productimgurl == null) { mwxResult.errmsg = "产品图片不能为空!"; return(JsonHelper.GetJson <MwxResult>(mwxResult)); } if (!string.IsNullOrEmpty(mwxResult.errmsg)) { return(JsonHelper.GetJson <MwxResult>(mwxResult)); } //// 存图片 string fileSave = FileOpert.UploadImg(productimgurl, path + "uploadFile\\" + System.DateTime.Now.ToString("yyyy") + "\\", out savePath); if (string.IsNullOrEmpty(fileSave)) { mproduct.productimgurl = savePath.Replace(path, ""); } else { //// 构建错误信息并返回 mwxResult.errmsg = fileSave; return(JsonHelper.GetJson <MwxResult>(mwxResult)); } mproduct.productid = PublicTools.GetRandomNumberByTime(); ///// 入库 bool addResult = new ProductService().AddProduct(mproduct); if (addResult) { mwxResult.errmsg = "新增成功!"; mwxResult.errcode = 0; CacheData.allRecommendPro = null; CacheData.allRecommendProList = null; } else { mwxResult.errmsg = "新增失败!"; } return(JsonHelper.GetJson <MwxResult>(mwxResult)); }
public ActionResult deleteTrash(int id) { Mproduct mproduct = db.Products.Find(id); db.Products.Remove(mproduct); db.SaveChanges(); Message.set_flash("Đã xóa vĩnh viễn 1 sản phẩm", "success"); return(RedirectToAction("trash")); }
public ActionResult Create(Mproduct mproduct, HttpPostedFileBase file) { ViewBag.listCate = db.Categorys.Where(m => m.status != 0 && m.ID > 2).ToList(); if (ModelState.IsValid) { string slug = Mystring.ToSlug(mproduct.name.ToString()); if (db.Categorys.Where(m => m.slug == slug).Count() > 0) { Message.set_flash("Sản phẩm đã tồn tại trong bảng Category", "danger"); return(View(mproduct)); } if (db.topics.Where(m => m.slug == slug).Count() > 0) { Message.set_flash("Sản phẩm đã tồn tại trong bảng Topic", "danger"); return(View(mproduct)); } if (db.Products.Where(m => m.slug == slug).Count() > 0) { Message.set_flash(" Sản phẩm đã tồn tại trong bảng Product", "danger"); return(View(mproduct)); } // lấy tên loại sản phẩm var namecateDb = db.Categorys.Where(m => m.ID == mproduct.catid).First(); string namecate = Mystring.ToStringNospace(namecateDb.name); // lấy tên ảnh file = Request.Files["img"]; string filename = file.FileName.ToString(); //lấy đuôi ảnh string ExtensionFile = Mystring.GetFileExtension(filename); // lấy tên sản phẩm làm slug //lấy tên mới của ảnh slug + [đuôi ảnh lấy đc] string namefilenew = namecate + "/" + slug + "." + ExtensionFile; //lưu ảnh vào đường đẫn var path = Path.Combine(Server.MapPath("~/public/images"), namefilenew); //nếu thư mục k tồn tại thì tạo thư mục var folder = Server.MapPath("~/public/images/" + namecate); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } file.SaveAs(path); mproduct.img = namefilenew; mproduct.slug = slug; mproduct.sold = 0; mproduct.created_at = DateTime.Now; mproduct.updated_at = DateTime.Now; mproduct.created_by = int.Parse(Session["Admin_id"].ToString()); mproduct.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Products.Add(mproduct); db.SaveChanges(); Message.set_flash("Thêm thành công", "success"); return(RedirectToAction("index")); } Message.set_flash("Thêm Thất Bại", "danger"); return(View(mproduct)); }
public ActionResult Retrash(int id) { Mproduct mproduct = db.Products.Find(id); mproduct.Status = 2; db.Entry(mproduct).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Trash", "Product")); }
public ActionResult Retrash(int id) { Mproduct mproduct = db.Products.Find(id); mproduct.status = 2; mproduct.updated_at = DateTime.Now; mproduct.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(mproduct).State = EntityState.Modified; db.SaveChanges(); Message.set_flash("khôi phục thành công", "success"); return(RedirectToAction("trash")); }
public ActionResult Status(int id) { Mproduct mproduct = db.Products.Find(id); mproduct.status = (mproduct.status == 1) ? 2 : 1; mproduct.updated_at = DateTime.Now; mproduct.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(mproduct).State = EntityState.Modified; db.SaveChanges(); Message.set_flash("Thay đổi trang thái thành công", "success"); return(RedirectToAction("Index")); }
// GET: Admin/Products/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Mproduct mproduct = db.Products.Find(id); if (mproduct == null) { return(HttpNotFound()); } return(View(mproduct)); }
// GET: Admin/Products/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Mproduct mproduct = db.Products.Find(id); if (mproduct == null) { return(HttpNotFound()); } ViewBag.listCate = db.Categorys.Where(m => m.status != 0 && m.ID > 2).ToList(); return(View(mproduct)); }
public string ShowStatus(int id) { string strStatus = ""; Mproduct mproduct = db.Products.Find(id); if (mproduct.Status == 1) { strStatus = "<span class ='btn btn-info btn-sm'><i class='fas fa-toggle-on'></i></span>"; } else { strStatus = "<span class ='btn btn-danger btn-sm'><i class='fas fa-toggle-off'></i></span>"; } return(strStatus); }
public ActionResult status(int id) { Mproduct mproduct = db.Products.Find(id); if (mproduct.Status == 1) { mproduct.Status = 0; } else { mproduct.Status = 1; } db.Entry(mproduct).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// 根据产品ID获取产品model /// </summary> /// <param name="productid"></param> /// <returns></returns> public Mproduct GetMproductModelById(string productid) { string sql = "select productid,classid,supclassid,className,supclassName,productname,productformat,productformatunit,origprice,sellprice,stock,shelfstate,hassellnum," + "productdetails,productimgurl,priority,isDelete,isEffective,great_time,modify_time,recommend from product where isDelete=0 and productid=?productid;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = productid; parameterList.Add(parameter); using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList.ToArray())) { if (sqlDataReader != null) { if (sqlDataReader.Read()) { Mproduct model = new Mproduct(); model.productid = sqlDataReader["productid"] != DBNull.Value ? sqlDataReader["productid"].ToString() : string.Empty; model.classid = sqlDataReader["classid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["classid"].ToString()) : 0; model.supclassid = sqlDataReader["supclassid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["supclassid"].ToString()) : 0; model.className = sqlDataReader["className"] != DBNull.Value ? sqlDataReader["className"].ToString() : string.Empty; model.supclassName = sqlDataReader["supclassName"] != DBNull.Value ? sqlDataReader["supclassName"].ToString() : string.Empty; model.productname = sqlDataReader["productname"] != DBNull.Value ? sqlDataReader["productname"].ToString() : string.Empty; model.productformat = sqlDataReader["productformat"] != DBNull.Value ? sqlDataReader["productformat"].ToString() : string.Empty; model.productformatunit = sqlDataReader["productformatunit"] != DBNull.Value ? sqlDataReader["productformatunit"].ToString() : string.Empty; model.origprice = sqlDataReader["origprice"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["origprice"].ToString()) : 0; model.sellprice = sqlDataReader["sellprice"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["sellprice"].ToString()) : 0; model.stock = sqlDataReader["stock"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["stock"].ToString()) : 0; model.shelfstate = sqlDataReader["shelfstate"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["shelfstate"].ToString()) : 0; model.hassellnum = sqlDataReader["hassellnum"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["hassellnum"].ToString()) : 0; model.productdetails = sqlDataReader["productdetails"] != DBNull.Value ? sqlDataReader["productdetails"].ToString() : string.Empty; model.productimgurl = sqlDataReader["productimgurl"] != DBNull.Value ? sqlDataReader["productimgurl"].ToString() : string.Empty; model.priority = sqlDataReader["priority"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["priority"].ToString()) : 0; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue; model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue; model.recommend = sqlDataReader["recommend"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["recommend"].ToString()) : 0; return(model); } } } return(null); }
// GET: Admin/Product/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Mproduct mproduct = db.Products.Find(id); var Listcat = db.Categories.Where(m => m.Status == 1).ToList(); //.OrderByDescending(m => m.Created_at) ViewBag.listCatId = new SelectList(Listcat, "Id", "Name"); if (mproduct == null) { return(HttpNotFound()); } return(View(mproduct)); }
/// <summary> /// 新产品 /// </summary> /// <returns></returns> public string AddProductMeth(Mproduct mproduct) { if (!base.CheckIsLogin()) { return("-1"); } HttpPostedFileBase productimgurl = Request.Files["productimgurl"]; if (string.IsNullOrEmpty(mproduct.productid)) { return(new ProductBus().AddProduct(mproduct, productimgurl, Server.MapPath("/"))); } else { //// 编辑 return(new ProductBus().EditeProduct(mproduct, productimgurl, Server.MapPath("/"))); } }
/// <summary> /// 检查产品信息的有效性 /// </summary> /// <param name="mproduct"></param> /// <returns></returns> private string CheckedProduct(Mproduct mproduct) { if (mproduct == null) { return("产品参数有误!"); } if (string.IsNullOrEmpty(mproduct.productname)) { return("产品名称不能为空!"); } if (mproduct.classid < 1) { return("产品类别必须选择!"); } return(null); }
public ActionResult Edit(FormCollection collection, Mproduct mproduct) { int user_id = (!Session["user_id"].Equals("")) ? Convert.ToInt32(Session["user_id"].ToString()) : 1; XString mystr = new XString(); if (ModelState.IsValid) { mproduct.CatId = Convert.ToInt32(collection["Listcat"]); string strslug = mystr.ToAscii(mproduct.Name); mproduct.Slug = strslug; mproduct.Created_at = DateTime.Now; mproduct.Created_by = user_id; mproduct.Updated_at = DateTime.Now; mproduct.Updated_by = user_id; db.Entry(mproduct).State = EntityState.Modified; //upload file var file = Request.Files["fileimg"]; if (file != null && file.ContentLength > 0) { //string phammorong = file.FileName.Substring(file.FileName.LastIndexOf(".")); mproduct.Img = file.FileName.ToString(); string path = Server.MapPath("~/images/product/") + file.FileName.ToString(); file.SaveAs(path); //lưu db.SaveChanges(); } return(RedirectToAction("Index")); } var list = db.Categories.Where(m => m.Status != 0).ToList(); ViewBag.Listcat = new SelectList(list, "id", "Name"); return(View(mproduct)); }
public JsonResult Additem(long productID) { var item = new MfavoriteProduct(); Mproduct product = db.Products.Find(productID); var favorite = Session[SessionFavorite]; if (favorite != null) { var list = (List <MfavoriteProduct>)favorite; if (list.Exists(m => m.favoriteProduct.ID == productID)) { return(Json(new { status = 1, meThod = "ExistProduct" }, JsonRequestBehavior.AllowGet)); } else { item.favoriteProduct = product; item.status = 2; list.Add(item); item.method = "favoriteExist"; return(Json(item, JsonRequestBehavior.AllowGet)); } } else { item.favoriteProduct = product; item.status = 3; item.method = "favoriteEmpty"; var list = new List <MfavoriteProduct>(); list.Add(item); Session[SessionFavorite] = list; } return(Json(item, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取产品数据总条数 /// </summary> /// <param name="classid"></param> /// <param name="supclassid"></param> /// <param name="productname"></param> /// <param name="shelfstate"></param> /// <returns></returns> public List <Mproduct> GetProductPagList(int pagIndex, int pagCount, int classid, int supclassid, string productname, int shelfstate, int isDelete = 0, int recommend = -1) { // 查询条件 StringBuilder sqlWhere = new StringBuilder($" isDelete ={isDelete} "); if (classid > 0) { sqlWhere.Append(" and classid =?classid"); } if (supclassid > 0) { sqlWhere.Append(" and supclassid =?supclassid"); } if (!string.IsNullOrEmpty(productname)) { sqlWhere.Append(" and productname like CONCAT('%',?productname,'%')"); } if (shelfstate != 0) { sqlWhere.Append(" and shelfstate =?shelfstate"); } if (recommend >= 0) { sqlWhere.Append(" and recommend =" + recommend); } string sql = " SELECT productid,classid,supclassid,className,supclassName,productname,productformat,productformatunit,origprice,sellprice,stock,shelfstate,hassellnum," + "productdetails,productimgurl,priority,isDelete,isEffective,great_time,modify_time,recommend " + $" FROM product WHERE {sqlWhere.ToString()} ORDER BY priority ASC , productid desc limit {((pagIndex - 1) * pagCount)}, {pagCount}; "; //string sql = " SELECT TOP " + pagCount * pagIndex + " productid,classid,supclassid,className,supclassName,productname,productformat,productformatunit,origprice,sellprice,stock,shelfstate,hassellnum," + // "productdetails,productimgurl,priority,isDelete,isEffective,great_time,modify_time " + // " FROM( SELECT ROW_NUMBER() OVER(ORDER BY great_time DESC) AS ROWID,* FROM product) AS TEMP1 WHERE isDelete=0 and ROWID> " + pagCount * (pagIndex - 1); List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?classid", MySqlDbType.Int32); parameter.Value = classid; parameterList.Add(parameter); parameter = new MySqlParameter("?supclassid", MySqlDbType.Int32); parameter.Value = supclassid; parameterList.Add(parameter); parameter = new MySqlParameter("?productname", MySqlDbType.VarChar, 100); parameter.Value = productname; parameterList.Add(parameter); parameter = new MySqlParameter("?shelfstate", MySqlDbType.Int32); parameter.Value = shelfstate; parameterList.Add(parameter); List <Mproduct> listModel = null; using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList.ToArray())) { if (sqlDataReader != null) { listModel = new List <Mproduct>(); while (sqlDataReader.Read()) { Mproduct model = new Mproduct(); model.productid = sqlDataReader["productid"] != DBNull.Value ? sqlDataReader["productid"].ToString() : string.Empty; model.classid = sqlDataReader["classid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["classid"].ToString()) : 0; model.supclassid = sqlDataReader["supclassid"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["supclassid"].ToString()) : 0; model.className = sqlDataReader["className"] != DBNull.Value ? sqlDataReader["className"].ToString() : string.Empty; model.supclassName = sqlDataReader["supclassName"] != DBNull.Value ? sqlDataReader["supclassName"].ToString() : string.Empty; model.productname = sqlDataReader["productname"] != DBNull.Value ? sqlDataReader["productname"].ToString() : string.Empty; model.productformat = sqlDataReader["productformat"] != DBNull.Value ? sqlDataReader["productformat"].ToString() : string.Empty; model.productformatunit = sqlDataReader["productformatunit"] != DBNull.Value ? sqlDataReader["productformatunit"].ToString() : string.Empty; model.origprice = sqlDataReader["origprice"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["origprice"].ToString()) : 0; model.sellprice = sqlDataReader["sellprice"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["sellprice"].ToString()) : 0; model.stock = sqlDataReader["stock"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["stock"].ToString()) : 0; model.shelfstate = sqlDataReader["shelfstate"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["shelfstate"].ToString()) : 0; model.hassellnum = sqlDataReader["hassellnum"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["hassellnum"].ToString()) : 0; model.productdetails = sqlDataReader["productdetails"] != DBNull.Value ? sqlDataReader["productdetails"].ToString() : string.Empty; model.productimgurl = sqlDataReader["productimgurl"] != DBNull.Value ? sqlDataReader["productimgurl"].ToString() : string.Empty; model.priority = sqlDataReader["priority"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["priority"].ToString()) : 0; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue; model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue; model.recommend = sqlDataReader["recommend"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["recommend"].ToString()) : 0; listModel.Add(model); } } } return(listModel); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddProduct(Mproduct model) { //// sql语句 string sql = "INSERT INTO product(productid,classid,supclassid,className,supclassName,productname,productformat,productformatunit,origprice,sellprice,stock,shelfstate,hassellnum,productdetails,productimgurl,priority,isDelete,isEffective,great_time,modify_time,recommend) " + "VALUES (?productid,?classid,?supclassid,(select classname from productclass where classid=?classid),(select classname from productclass where classid=?supclassid),?productname,?productformat,?productformatunit,?origprice,?sellprice,?stock,?shelfstate,?hassellnum,?productdetails,?productimgurl,?priority,?isDelete,?isEffective,?great_time,?modify_time,recommend)"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = model.productid; parameterList.Add(parameter); parameter = new MySqlParameter("?classid", MySqlDbType.Int32); parameter.Value = model.classid; parameterList.Add(parameter); parameter = new MySqlParameter("?supclassid", MySqlDbType.Int32); parameter.Value = model.supclassid; parameterList.Add(parameter); parameter = new MySqlParameter("?productname", MySqlDbType.VarChar, 100); parameter.Value = model.productname; parameterList.Add(parameter); parameter = new MySqlParameter("?productformat", MySqlDbType.VarChar, 20); parameter.Value = model.productformat; parameterList.Add(parameter); parameter = new MySqlParameter("?productformatunit", MySqlDbType.VarChar, 50); parameter.Value = model.productformatunit; parameterList.Add(parameter); parameter = new MySqlParameter("?origprice", MySqlDbType.Decimal); parameter.Value = model.origprice; parameterList.Add(parameter); parameter = new MySqlParameter("?sellprice", MySqlDbType.Decimal); parameter.Value = model.sellprice; parameterList.Add(parameter); parameter = new MySqlParameter("?stock", MySqlDbType.Int32); parameter.Value = model.stock; parameterList.Add(parameter); parameter = new MySqlParameter("?shelfstate", MySqlDbType.Int32); parameter.Value = model.shelfstate; parameterList.Add(parameter); parameter = new MySqlParameter("?hassellnum", MySqlDbType.Int32); parameter.Value = 0; parameterList.Add(parameter); parameter = new MySqlParameter("?productdetails", MySqlDbType.Text); parameter.Value = model.productdetails; parameterList.Add(parameter); parameter = new MySqlParameter("?productimgurl", MySqlDbType.VarChar, 100); parameter.Value = model.productimgurl; parameterList.Add(parameter); parameter = new MySqlParameter("?priority", MySqlDbType.Int32); parameter.Value = model.priority; parameterList.Add(parameter); parameter = new MySqlParameter("?isDelete", MySqlDbType.Int32); parameter.Value = 0; parameterList.Add(parameter); parameter = new MySqlParameter("?isEffective", MySqlDbType.Int32); parameter.Value = 1; parameterList.Add(parameter); DateTime dateTime = System.DateTime.Now; parameter = new MySqlParameter("?great_time", MySqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); parameter = new MySqlParameter("?modify_time", MySqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); parameter = new MySqlParameter("?recommend", MySqlDbType.Int32); parameter.Value = model.recommend; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
public RedirectToRouteResult Additem(long productID, int quantity) { var item = new Cart_item(); Mproduct product = db.Products.Find(productID); var cart = Session[SessionCart]; if (cart != null) { var list = (List <Cart_item>)cart; if (list.Exists(m => m.product.Id == productID)) { int quantity1 = 0; foreach (var item1 in list) { if (item1.product.Id == productID) { item1.quantity += quantity; quantity1 = item1.quantity; } } int priceTotol = 0; int price = 0; foreach (var item1 in list) { int temp = (int)item1.product.Price * (int)item1.quantity; priceTotol += temp; price = (int)item1.product.Price; } return(RedirectToAction("Index")); } else { item.product = product; item.quantity = quantity; list.Add(item); item.countCart = list.Count(); item.meThod = "cartExist"; int priceTotol = 0; foreach (var item1 in list) { int temp = (int)item1.product.Price * (int)item1.quantity; priceTotol += temp; } item.priceTotal = priceTotol; return(RedirectToAction("Index")); } } else { item.product = product; item.quantity = quantity; item.meThod = "cartEmpty"; item.countCart = 1; item.priceTotal = (int)product.Price; var list = new List <Cart_item>(); list.Add(item); Session[SessionCart] = list; } return(RedirectToAction("Index")); }
/// <summary> /// 根据产品的价格、库存信息 /// </summary> /// <param name="productid"></param> /// <param name="origprice"></param> /// <param name="sellprice"></param> /// <param name="stock"></param> /// <returns></returns> public bool UpdateProdctPrice(string productid, decimal origprice, decimal sellprice, int stock, int priority, Mproduct mproduct) { string sql = "update product set "; if (origprice > 0) { sql = sql + " origprice = ?origprice,"; } if (sellprice > 0) { sql = sql + " sellprice = ?sellprice,"; } if (stock >= 0) { sql = sql + " stock = ?stock,"; } if (priority > 0) { sql = sql + " priority = ?priority,"; } if (!string.IsNullOrEmpty(mproduct.productimgurl)) { sql = sql + " productimgurl = ?productimgurl,"; } if (mproduct.supclassid > 0) { sql = sql + " supclassid = " + mproduct.supclassid + ","; sql = sql + " supclassName = (select classname from productclass where classid=" + mproduct.supclassid + "),"; } if (mproduct.classid > 0) { sql = sql + " classid = " + mproduct.classid + ","; sql = sql + " className = (select classname from productclass where classid=" + mproduct.classid + "),"; } if (!string.IsNullOrEmpty(mproduct.productname)) { sql = sql + " productname = ?productname,"; } sql = sql + " productformat = ?productformat,"; sql = sql + " productformatunit = ?productformatunit,"; sql = sql + " origprice = ?origprice,"; sql = sql + " sellprice = ?sellprice,"; sql = sql + " stock = ?stock,"; sql = sql + " shelfstate = ?shelfstate,"; sql = sql + " priority = ?priority,"; sql = sql + " productdetails = ?productdetails,"; sql = sql.TrimEnd(',') + " where productid=?productid;"; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?productid", MySqlDbType.VarChar, 25); parameter.Value = productid; parameterList.Add(parameter); parameter = new MySqlParameter("?origprice", MySqlDbType.Decimal); parameter.Value = origprice; parameterList.Add(parameter); parameter = new MySqlParameter("?sellprice", MySqlDbType.Decimal); parameter.Value = sellprice; parameterList.Add(parameter); parameter = new MySqlParameter("?stock", MySqlDbType.Int32); parameter.Value = stock; parameterList.Add(parameter); parameter = new MySqlParameter("?productformat", MySqlDbType.VarChar, 20); parameter.Value = mproduct.productformat; parameterList.Add(parameter); parameter = new MySqlParameter("?productformatunit", MySqlDbType.VarChar, 50); parameter.Value = mproduct.productformatunit; parameterList.Add(parameter); parameter = new MySqlParameter("?shelfstate", MySqlDbType.Int32); parameter.Value = mproduct.shelfstate; parameterList.Add(parameter); parameter = new MySqlParameter("?productdetails", MySqlDbType.Text); parameter.Value = mproduct.productdetails; parameterList.Add(parameter); parameter = new MySqlParameter("?productimgurl", MySqlDbType.VarChar, 100); parameter.Value = mproduct.productimgurl; parameterList.Add(parameter); parameter = new MySqlParameter("?priority", MySqlDbType.Int32); parameter.Value = mproduct.priority; parameterList.Add(parameter); parameter = new MySqlParameter("?productname", MySqlDbType.VarChar, 100); parameter.Value = mproduct.productname; parameterList.Add(parameter); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 新增产品类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddProduct(Mproduct model) { return(opertService.AddProduct(model)); }
/// <summary> /// 根据产品的价格、库存信息 /// </summary> /// <param name="productid"></param> /// <param name="origprice"></param> /// <param name="sellprice"></param> /// <param name="stock"></param> /// <returns></returns> public bool UpdateProdctPrice(string productid, decimal origprice, decimal sellprice, int stock, int priority, Mproduct mproduct) { return(opertService.UpdateProdctPrice(productid, origprice, sellprice, stock, priority, mproduct)); }
public JsonResult Additem(long productID, int quantity) { var item = new Cart_item(); Mproduct product = db.Products.Find(productID); var cart = Session[SessionCart]; if (cart != null) { var list = (List <Cart_item>)cart; if (list.Exists(m => m.product.ID == productID)) { int quantity1 = 0; bool bad = false; foreach (var item1 in list) { if (item1.product.ID == productID) { if ((item1.quantity + quantity) > (item1.product.number - item1.product.sold)) { bad = true; } else { item1.quantity += quantity; quantity1 = item1.quantity; } } } int priceTotol = 0; foreach (var item1 in list) { if (item1.product.pricesale > 0) { int temp = (((int)item1.product.price) - ((int)item1.product.price / 100 * (int)item1.product.pricesale)) * ((int)item1.quantity); priceTotol += temp; } else { int temp = (int)item1.product.price * (int)item1.quantity; priceTotol += temp; } } return(Json(new { ProductPrice = ((int)product.price) - (((int)product.price / 100) * ((int)product.pricesale)), bad = bad, price = product.price, priceSale = product.pricesale, quantity = quantity1, priceTotol = priceTotol, productID = productID, meThod = "updateQuantity" }, JsonRequestBehavior.AllowGet)); } else { item.meThod = "cartExist"; item.f = false; if (quantity > (product.number - product.sold)) { item.f = true; item.quantity = 0; } else { item.quantity = quantity; list.Add(item); item.product = product; item.countCart = list.Count(); item.meThod = "cartExist"; int priceTotol = 0; foreach (var item1 in list) { if (item1.product.pricesale > 0) { int temp = (((int)item1.product.price) - ((int)item1.product.price / 100 * (int)item1.product.pricesale)) * ((int)item1.quantity); priceTotol += temp; } else { int temp = (int)item1.product.price * (int)item1.quantity; priceTotol += temp; } } item.priceTotal = priceTotol; item.priceSaleee = (int)product.price - (int)product.price / 100 * (int)product.pricesale; } return(Json(item, JsonRequestBehavior.AllowGet)); } } else { item.product = product; item.meThod = "cartEmpty"; item.countCart = 1; item.f = false; if (quantity > (product.number - product.sold)) { item.f = true; item.quantity = 0; } else { item.quantity = quantity; var list = new List <Cart_item>(); list.Add(item); Session[SessionCart] = list; if (item.product.pricesale > 0) { item.priceTotal = (((int)item.product.price) - ((int)item.product.price / 100 * (int)item.product.pricesale)) * ((int)item.quantity); } else { item.priceTotal = (int)product.price; } item.priceTotal = (((int)item.product.price) - ((int)item.product.price / 100 * (int)item.product.pricesale)) * ((int)item.quantity); } } return(Json(item, JsonRequestBehavior.AllowGet)); }