/// <summary> /// SearchByCategory函数的功能:根据类型查找商品 /// </summary> /// <param name="category">商品的类型</param> /// <returns>根据商品的类型查询的商品的信息的Linq查询结果的集合</returns> public object SearchByCategory(string category) { product_Entity P = new product_Entity(); P.P_category = category; return(Date.searchByCategory(P)); }
//--搜索模块-- /// <summary> /// 1.SearchByProName函数的功能:根据商品名称查找商品 /// </summary> /// <param name="name">商品的名称</param> /// <returns>根据商品名称查询的商品的信息的Linq查询结果的集合</returns> public object SearchByProName(string name) { product_Entity P = new product_Entity(); P.P_name = name; return(Date.searchByProName(P)); }
protected void Button1_Click(object sender, EventArgs e) { SellService a = new SellService(); product_Entity b = new product_Entity(); b.S_account = Session["UserAccount"].ToString().Trim(); b.P_name = txtProduct_name.Text; b.P_category = txtProduct_category.Text; b.P_price = double.Parse(txtProduct_price.Text); b.P_cNum = int.Parse(txtProduct_number.Text); b.P_photo = FileUpload1.FileName; a.add(b, FileUpload1); Response.Write(MessagesBox.showMessages("添加成功")); }
/// <summary> /// 添加商品 /// </summary> /// <param name="sellAccount"></param> /// <param name="product"></param> public void addProduct(product_Entity product, FileUpload e) { product_T productT = new product_T(); productT.s_account = product.S_account; productT.p_name = product.P_name; productT.p_category = product.P_category; productT.p_price = (decimal)product.P_price; productT.p_cNum = product.P_cNum; productT.p_photo = "~/Images/" + product.S_account + "/" + e.FileName + ""; sellDB.product_T.InsertOnSubmit(productT); upLoadPhoto(e, product.S_account); sellDB.SubmitChanges(); }
//以下是商品模块功能 public product_Entity inquireProById(string account, int ProId) { product_T product = new product_T(); product_Entity product_E = new product_Entity(); product = sellDB.product_T.Where(c => c.s_account.Equals(account) && c.p_Id.Equals(ProId)).First(); product_E.P_Id = product.p_Id; product_E.P_name = product.p_name; product_E.P_photo = product.p_photo; product_E.P_price = (double)product.p_price; product_E.P_cNum = product.p_cNum; product_E.P_saleNum = product.p_saleNum; product_E.P_category = product.p_category; return(product_E); }
protected void btnSubmit_Click(object sender, EventArgs e) { SellService a = new SellService(); product_Entity b = new product_Entity(); b.P_Id = int.Parse(Request.QueryString["id"].ToString()); b.S_account = Session["UserAccount"].ToString().Trim(); b.P_name = txtProduct_name.Text.Trim(); b.P_category = txtProduct_category.Text.Trim(); b.P_price = double.Parse(txtProduct_price.Text.Trim()); b.P_cNum = int.Parse(txtProduct_number.Text.Trim()); b.P_photo = "~/Images/" + Session["UserAccount"].ToString().Trim() + "/" + FileUpload1.FileName; if (a.updateProInfo(Session["UserAccount"].ToString().Trim(), b, FileUpload1)) { Response.Write(MessagesBox.showMessages("更改成功!")); } else { Response.Write(MessagesBox.showMessages("更改失败!")); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserAccount"] == null) { Response.Redirect("../login.aspx"); } //这里我改了,时间2016.12.17.22.05 //else if (Session["UserAccount"].Equals(Request.QueryString["account"])==false) //{ // Response.Redirect("../login.aspx"); //} if (!IsPostBack) { product_Entity product = new product_Entity(); product = dt.inquireProById(Session["UserAccount"].ToString(), int.Parse(Request.QueryString["id"])); txtProduct_name.Text = product.P_name; txtProduct_number.Text = product.P_cNum.ToString(); txtProduct_price.Text = product.P_price.ToString(); txtProduct_category.Text = product.P_category; Image1.ImageUrl = product.P_photo; } }
public bool updateProInfo(string sellerAccount, product_Entity product, FileUpload e) { var results = sellDB.product_T.Where(c => c.p_Id.Equals(product.P_Id) && c.s_account.Equals(sellerAccount)); if (results.Count() > 0) { if (e.FileName != "") { foreach (product_T p in results) { p.p_name = product.P_name; p.p_price = decimal.Parse(product.P_price.ToString()); p.p_cNum = product.P_cNum; p.p_category = product.P_category; upLoadPhoto(e, sellerAccount); } sellDB.SubmitChanges(); } else { foreach (product_T p in results) { p.p_name = product.P_name; p.p_price = decimal.Parse(product.P_price.ToString()); p.p_cNum = product.P_cNum; p.p_category = product.P_category; } sellDB.SubmitChanges(); } return(true); } else { return(true); } }
/// <summary> /// searchByCategory函数的功能:访问数据库根据商品的分类查找出商品的信息 /// </summary> /// <param name="product">商品对象</param> /// <returns>LINQ查询结果的集合</returns> public object searchByCategory(product_Entity product) { var Category = buyerDB.product_T.Where(r => r.p_category == product.P_category).Select(r => r); return((object)Category); }
//--搜索模块-- /// <summary> /// searchByProName函数的功能:访问数据库根据商品的名称查找出商品的信息 /// </summary> /// <param name="product">商品对象</param> /// <returns>LINQ查询结果的集合</returns> public object searchByProName(product_Entity product) { var Name = buyerDB.product_T.Where(n => n.p_name == product.P_name).Select(n => n); return((object)Name); }
/// <summary> /// 添加商品 /// </summary> /// <param name="a"></param> /// <param name="e"></param> public void add(product_Entity a, FileUpload e) { /*product_T b = new product_T();*/ db.addProduct(a, e); }
/// <summary> /// 修改商品 /// </summary> /// <param name="a"></param> /// <param name="s_account"></param> /// <param name="e"></param> public bool updateProInfo(string sellerAccount, product_Entity product, FileUpload e) { return(db.updateProInfo(sellerAccount, product, e)); }