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