protected void tijiao_Click(object sender, EventArgs e) { Model.product mym = new Model.product(); mym.title = _title.Text; mym.content = FCKeditor1.Value; mym.imageid = _imageid.Text; mym.ischeap = Convert.ToInt32(_ischeap.SelectedValue); mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue); mym.localprice = Convert.ToDouble(_localprice.Text); mym.marketprice = Convert.ToDouble(_marketprice.Text); mym.posttime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); mym.procount = Convert.ToInt32(_procount.Text); mym.top = Convert.ToInt32(_top.SelectedValue); mym.weight = _weight.Text; mym.cateid = Convert.ToInt32(_cateid.SelectedValue); BLL.product bpro = new BLL.product(); int result = bpro.insert(mym); if (result > 0) { msg("成功添加产品!!"); string mmmm = DateTime.Now.ToString("yyyyMMddhhmmssfff"); _imageid.Text = mmmm; _title.Text = ""; FCKeditor1.Value = ""; _procount.Text = ""; _weight.Text = ""; _localprice.Text = ""; _marketprice.Text = ""; imagela.Text = ""; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } //Tool.Admin.admin(); try { i = int.Parse(Request["id"]); Model.product a = new Model.product() { id = i }; Hq = BLL.Product.Getproduct(a); } catch { i = 1; Model.product a = new Model.product() { id = i }; Hq = BLL.Product.Getproduct(a); } product_name.Text = Hq.product_name; product_intro.Text = Hq.product_name; Image1.ImageUrl = "../img/product/" + Hq.product_imageurl; product_price.Text = Hq.product_price.ToString(); product_content.Value = Hq.product_content; product_content.Rows = 12; product_content.Cols = 60; }
protected void sous_Click(object sender, EventArgs e) { Model.product mym = new Model.product(); mym.title = Text_title.Text; BLL.product myb = new BLL.product(); DataSet ds = myb.select_title(mym); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Delete") { Model.product mym = new Model.product(); mym.id = Convert.ToInt32(e.CommandArgument); BLL.product myb = new BLL.product(); string s_imageid = myb.select_imageid(mym); BLL.proimage b_image = new BLL.proimage(); DataSet ds = b_image.select_sizeid(s_imageid); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string size_id = Convert.ToString(ds.Tables[0].Rows[i]["_sizeid"]); BLL.size s_bll = new BLL.size(); int result_s = s_bll.delete(size_id); string path1 = Convert.ToString(ds.Tables[0].Rows[i]["_imageurl"]); string path = "~/" + path1; if (File.Exists(Server.MapPath(path))) { File.Delete(Server.MapPath(path)); } } int r_image = b_image.delete(s_imageid); int result = myb.delete_id(mym); if (result > 0) { msg("删除成功!!"); bing(); } } if (e.CommandName == "Edit") { Response.Redirect("proupdate.aspx?id=" + e.CommandArgument + ""); } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Delete") { Model.product mym = new Model.product(); mym.id = Convert.ToInt32(e.CommandArgument); BLL.product myb = new BLL.product(); string s_imageid = myb.select_imageid(mym); BLL.proimage b_image = new BLL.proimage(); DataSet ds = b_image.select_sizeid(s_imageid); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string size_id = Convert.ToString(ds.Tables[0].Rows[i]["_sizeid"]); BLL.size s_bll = new BLL.size(); int result_s = s_bll.delete(size_id); string path1 = Convert.ToString(ds.Tables[0].Rows[i]["_imageurl"]); string path = "~/" + path1; if (File.Exists(Server.MapPath(path))) { File.Delete(Server.MapPath(path)); } } int r_image = b_image.delete(s_imageid); int result = myb.delete_id(mym); if (result > 0) { msg("删除成功!!"); bing(); } } if (e.CommandName == "Edit") { Response.Redirect("proupdate.aspx?id="+e.CommandArgument+""); } }
protected void Button1_OnClick(object sender, EventArgs e) { Tool.UpFile u = new UpFile(); Model.product a = new Model.product() { id = i, product_imageurl = u.upFileName(this.FileUpload1, "../img/product/"), product_name = product_name.Text, product_intro = product_intro.Text, product_price = int.Parse(product_price.Text), product_content = product_content.Value }; _ = BackStages.List <Model.product> .Getproduct(a) > 0 ? Tool.Tool.Alert("True", "../img/product/" + Hq.product_imageurl) : Tool.Tool.Alert("False"); }
protected void LinkButton1_Click(object sender, EventArgs e) { //if (Session["_username"] == null) //{ // Common.MessageAlert.Alert(Page, "对不起,你还没有登入!!"); //} // //引用shoplist //else //{ Model.product mypro = new Model.product(); mypro.id = Convert.ToInt32(Request.QueryString["uid"].ToString()); BLL.BLLshoplist blll = new BLL.BLLshoplist(); SqlDataReader dr = blll.readpro(mypro); DataTable dt; if (Session["dt"] == null) { dt = new DataTable(); dt.Columns.Add("id", typeof(Int32)); dt.Columns.Add("title", typeof(String)); dt.Columns.Add("localprice", typeof(Double)); dt.Columns.Add("posttime", typeof(String)); dt.Columns.Add("buycount", typeof(Int32)); dt.Columns.Add("sumprice", typeof(Int32)); } else { dt = (DataTable)Session["dt"]; } DataRow row = dt.NewRow(); if (dr.Read()) { row["id"] = Convert.ToInt32(dr["_id"].ToString()); row["title"] = Convert.ToString(dr["_title"].ToString()); row["localprice"] = Convert.ToDouble(dr["_localprice"].ToString()); row["posttime"] = Convert.ToString(dr["_posttime"].ToString()); row["buycount"] = 1; row["sumprice"] = Convert.ToDouble(dr["_localprice"].ToString()); dt.Rows.Add(row); } dr.Close(); Session["dt"] = dt; Response.Redirect("shoplist.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } string sid = Request["id"]; if (Request["id"] == null) { pr = (Model.product)BLL.Product.GetProductS(1)[0]; } else { id = int.Parse(sid); pr = (Model.product)BLL.Product.GetProductS(int.Parse(sid))[0]; } }
protected void LinkButton1_Click(object sender, EventArgs e) { //if (Session["_username"] == null) //{ // Common.MessageAlert.Alert(Page, "对不起,你还没有登入!!"); //} // //引用shoplist //else //{ Model.product mypro = new Model.product(); mypro.id = Convert.ToInt32(Request.QueryString["uid"].ToString()); BLL.BLLshoplist blll = new BLL.BLLshoplist(); MySqlDataReader dr = blll.readpro(mypro); DataTable dt; if (Session["dt"] == null) { dt = new DataTable(); dt.Columns.Add("id", typeof(Int32)); dt.Columns.Add("title", typeof( String )); dt.Columns.Add("localprice", typeof(Double)); dt.Columns.Add("posttime", typeof(String)); dt.Columns .Add ("buycount", typeof (Int32)); dt.Columns.Add("sumprice", typeof(Int32)); } else { dt = (DataTable)Session["dt"]; } DataRow row = dt.NewRow(); if (dr.Read()) { row["id"] = Convert.ToInt32(dr["_id"].ToString()); row["title"] = Convert.ToString (dr["_title"].ToString()); row["localprice"] = Convert.ToDouble(dr["_localprice"].ToString()); row["posttime"] = Convert.ToString(dr["_posttime"].ToString()); row["buycount"] = 1; row["sumprice"] = Convert.ToDouble(dr["_localprice"].ToString()); dt.Rows.Add(row); } dr.Close(); Session["dt"] = dt; Response.Redirect("shoplist.aspx"); }
protected void tijiao_Click(object sender, EventArgs e) { Model.product mym = new Model.product(); mym.title = _title.Text; mym.content = FCKeditor1.Value; mym.imageid = _imageid.Text; mym.ischeap = Convert.ToInt32(_ischeap.SelectedValue); mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue); mym.localprice = Convert.ToDouble(_localprice.Text); mym.marketprice = Convert.ToDouble(_marketprice.Text); mym.posttime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); mym.procount = Convert.ToInt32(_procount.Text); mym.top = Convert.ToInt32(_top.SelectedValue); mym.weight = _weight.Text; mym.cateid = Convert.ToInt32(_cateid.SelectedValue); BLL.product bpro = new BLL.product(); int result = bpro.insert(mym); if (result > 0) { msg("成功添加产品!!"); string mmmm = DateTime.Now.ToString("yyyyMMddhhmmssfff"); _imageid.Text = mmmm; _title.Text = ""; FCKeditor1.Value = ""; _procount.Text = ""; _weight.Text = ""; sizela.Text = ""; _localprice.Text = ""; _marketprice.Text = ""; imagela.Text = ""; } }
protected void tijiao_Click(object sender, EventArgs e) { Model.product mym = new Model.product(); mym.title = _title.Text; mym.content = FCKeditor1.Value; mym.id = Convert.ToInt32(L_id.Text); mym.ischeap = Convert.ToInt32(_ischeap.SelectedValue); mym.isrecomment = Convert.ToInt32(_isrecomment.SelectedValue); mym.localprice = Convert.ToDouble(_localprice.Text); mym.marketprice = Convert.ToDouble(_marketprice.Text); mym.procount = Convert.ToInt32(_procount.Text); mym.top = Convert.ToInt32(_top.SelectedValue); mym.weight = _weight.Text; mym.cateid = Convert.ToInt32(_cateid.SelectedValue); BLL.product bpro = new BLL.product(); int result = bpro.update(mym); if (result > 0) { msg("成功更新商品!!"); Response.Redirect("proselect.aspx"); } }
//订单。。。。。。。 protected void LinkButton2_Click(object sender, EventArgs e) { if (Session["_user_name"] == null) { Common.MessageAlert.Alert(Page, "对不起,您还没有登入!!"); } //引用shoplist else { Model.product mypro = new Model.product(); mypro.id = Convert.ToInt32(Request.QueryString["uid"].ToString()); BLL.BLLshoplist blll = new BLL.BLLshoplist(); SqlDataReader dr = blll.readpro(mypro); DataTable dt; if (Session["dt"] == null) { dt = new DataTable(); dt.Columns.Add("id", typeof(Int32)); dt.Columns.Add("localprice", typeof(Double)); dt.Columns.Add("posttime", typeof(String)); dt.Columns.Add("buycount", typeof(Int32)); dt.Columns.Add("sumprice", typeof(Int32)); dt.Columns.Add("color", typeof(String)); dt.Columns.Add("size", typeof(String)); dt.Columns.Add("title", typeof(String)); dt.Columns.Add("cate", typeof(String)); dt.Columns.Add("image", typeof(String)); dt.Columns.Add("only", typeof(String)); dt.Columns.Add("weight", typeof(String)); dt.Columns.Add("sumweight", typeof(String)); } else { dt = (DataTable)Session["dt"]; for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToInt32(dt.Rows[i]["id"]) == mypro.id && Convert.ToString(dt.Rows[i]["color"]) == d_color.Text && Convert.ToString(dt.Rows[i]["size"]) == _size.Text) { dt.Rows[i]["buycount"] = Convert.ToInt32(dt.Rows[i]["buycount"]) + 1; Session["dt"] = dt; Response.Redirect("shoplist.aspx"); return; } } } DataRow row = dt.NewRow(); if (dr.Read()) { row["weight"] = dr["_product_weight"].ToString(); row["sumweight"] = dr["_product_weight"].ToString(); row["only"] = DateTime.Now.ToString("yyyyMMddhhmmssfff"); row["size"] = _size.Text; row["image"] = Image_1.ImageUrl; row["cate"] = cate_name.Text; row["title"] = title_l.Text; row["color"] = d_color.Text; row["id"] = Convert.ToInt32(dr["_id"].ToString()); row["localprice"] = Convert.ToDouble(dr["_local_price"].ToString()); row["posttime"] = Convert.ToString(dr["_post_time"].ToString()); row["buycount"] = 1; row["sumprice"] = Convert.ToDouble(dr["_local_price"].ToString()); dt.Rows.Add(row); } dr.Close(); Session["dt"] = dt; Response.Redirect("shoplist.aspx"); } }