protected void Page_Load(object sender, EventArgs e) { if (subTool.CheckUserLogin("-1")) { userID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517User", "userID")); if (!IsPostBack) { if (Request.QueryString["InfoID"] != null && Request.QueryString["InfoID"] != "") { InfoID = Int32.Parse(Request.QueryString["InfoID"]); txtInfoId.Text = InfoID.ToString(); btnAdd.Visible = false; btnUpdate.Visible = true; lblAddAcceptAddr.Text = "修改收货人地址"; BindUpdateAcceptAddr(InfoID); } else { btnAdd.Visible = true; btnUpdate.Visible = false; lblAddAcceptAddr.Text = "添加收货人地址"; } } } }
protected void btnAdd_Click(object sender, ImageClickEventArgs e) { int addrID = WebUnitily.CheckInt(rbListAddr.SelectedValue); if (addrID == 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("请您选择收货地址!")); return; } L_AcceptAddrInfo addrinfo = new AcceptAddrInfo().GetBindUpdateAcceptAddr(addrID, userID); if (addrinfo == null) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("您所选择的收货地址不存在!")); return; } L_OrderListInfo olistinfo = new L_OrderListInfo(); olistinfo.UserID = userID; olistinfo.AcceptName = addrinfo.RealityName; olistinfo.AcceptAddr = addrinfo.Province + addrinfo.City + addrinfo.Country + addrinfo.RowAddr; olistinfo.HandSet = addrinfo.HandSet; olistinfo.Tel = addrinfo.Tel; olistinfo.ZipCode = addrinfo.zipCode; olistinfo.OrderTime = DateTime.Now; olistinfo.ShippedTime = DateTime.Now; olistinfo.OrderState = 10; //0代表取消订单 10代表等待付款 20代表已付款 30代表已发货 olistinfo.IsNew = 0; //0 新订单 1一查看 olistinfo.AdminID = 0; olistinfo.OrderID = userID.ToString() + DateTime.Now.ToString("yyyyMMddmm"); int exeResult = order.AddUserOrderItem(olistinfo); switch (exeResult) { case 10: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("您的订单提交成功,你需要付款")); break; case 0: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("您的订单提交成功,你需要付款")); break; case -2: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("您的购物车中没有产品,请您选择产品", "UserCard.aspx")); break; case -3: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("您还没有购物车呢,请您先选择产品", "UserCard.aspx")); break; default: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("您的订单提交失败")); break; } BindDataListShoppingRar(); }
protected void Page_Load(object sender, EventArgs e) { if (subTool.CheckAdminLogin("20")) { adminID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517Admin", "adminType")); if (!IsPostBack) { BindIndexyifahuo(); } } }
protected void Page_Load(object sender, EventArgs e) { if (subTool.CheckAdminLogin("20")) { adminID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517Admin", "adminID")); } if (!IsPostBack) { BindAdminManagerOrderList(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { classID = WebUnitily.CheckInt(Request["classID"]); keyWord = WebUnitily.CheckStr(Request["keyWord"]); orderBy = WebUnitily.CheckStr(Request["orderBy"]); BindIndexHelp(); BindIndexHelpTitle(); } }
protected void Page_Load(object sender, EventArgs e) { if (subTool.CheckUserLogin("-1")) { userID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517User", "userID")); if (!IsPostBack) { BindIndexOrderListInfo(); } } }
private void BindIndexHelp() { StringBuilder sb = new StringBuilder(); int currPage = WebUnitily.CheckInt(Request["p"]); if (currPage == 0) { currPage = 1; } L_PageList pl = new L_PageList(); pl.Currpage = currPage; pl.PageSize = 10; new8517PageList.CurPage = currPage; //select helpID,helptitle,postTime from ShopHelp where isPost=1 pl.TableName = " ShopHelp"; pl.PKey = " helpID"; pl.FieldList = " helpID,helptitle,postTime"; if (classID != 0) { pl.Conditon = " and classID=" + classID + " or ParentIDRoute like '%/,'+CAST(" + classID + " as varchar(10))+'/,%' ESCAPE '/'"; } if (keyWord != "") { pl.Conditon = " and HelpTitle like '%" + keyWord + "%'"; } pl.Conditon = " and isPost=1"; if (orderBy == "") { pl.OrderBy = " postTime desc"; } longyuan_TableUpDateFieldsInfo tb = new longyuan_TableUpDateFieldsInfo(); DataSet dSet = tb.GetPageList(pl); if (dSet.Tables.Count > 0) { if (dSet.Tables[0].Rows.Count > 0) { ddlBindIndexHelpInfo.DataSource = dSet.Tables[0]; ddlBindIndexHelpInfo.DataBind(); new8517PageList.TotalPage = int.Parse(tb.PageCount.ToString()); } else { new8517PageList.Visible = false; ddlBindIndexHelpInfo.Visible = false; lbInfo.Visible = true; lbInfo.Text = "此类别还没有帮助主题呢!!"; } } }
private void changeBuyNum() { StringBuilder sb = new StringBuilder(); L_CartInfo cInfo = new L_CartInfo(); cInfo.UserID = userID; cInfo.CartID = WebUnitily.CheckStr(Request["cartID"]); cInfo.ProductID = WebUnitily.CheckInt(Request["PId"]); cInfo.BugNum = WebUnitily.CheckInt(Request["BuyNum"]); DataSet Set = cartinfo.GetUpdateShoppingNumMoney(cInfo); sb.Append("<table style=\" width:100%; margin-top:5px; padding:5px; border:none;\" cellpadding=\"0\" cellspacing=\"0\">"); if (Set.Tables.Count > 0) { string proName; sb.Append("<tr class=\"cartListTitle\"><td>商品名称/图片</td><td class=\"FieldName100\">单价</td><td class=\"FieldName120\">数量</td><td class=\"FieldName120\">本商品合计</td><td class=\"FieldName80\"> 操作</td></tr>"); for (int i = 0; i < Set.Tables[0].Rows.Count; i++) { DataRow drv = Set.Tables[0].Rows[i]; sb.Append("<tr>"); sb.Append("<tr class=\"cartListRow\">"); if (drv["ProSmallPath"].ToString() != "") { sb.Append("<td><img src=\"" + "../photo/" + drv["ProSmallPath"] + "\" alt=\"产品图片\" />"); } else { sb.Append("<td><img src=\"/Images/Erro.png\" alt=\"产品图片\" />"); } proName = drv["ProductName"].ToString(); if (proName.Length > 20) { proName = proName.Substring(0, 20); } sb.Append("<p class=\"wenzi\"><a href=\"../product/ProductInfo.aspx?PId=" + drv["ProductID"] + "\" title=" + drv["ProductName"] + "\" target=\"_blank\">" + proName + "</a></p></td>"); sb.Append("<td class=\"FieldName100\">" + string.Format("{0:C2}", drv["MenberPrince"]) + "</td>"); sb.Append("<td class=\"FieldName120\"><input id=\"txtBuyNum_" + drv["ProductId"] + "\" type=\"text\" class=\"input\" maxlength=\"5\" style=\"width:50px;\" onblur=\"Cart8517.ChangeBuyNum('" + drv["CartID"] + "'," + drv["ProductID"] + ");\" value=\"" + drv["BuyNum"] + "\" /></td>"); sb.Append("<td class=\"FieldName120\"><span class=\"red\">" + string.Format("{0:C2}", drv["MoneyAmount"]) + "</span></td>"); sb.Append("<td class=\"FieldName80\"><a href=\"javascript:void(0);\" onclick=\"Cart8517.DelCartProduct('" + drv["CartID"] + "','" + drv["ProductID"] + "');\" title=\"删除\">删除</a></td>"); sb.Append("</tr>"); } sb.Append("<tr class=\"cartListRow\"><td colspan=\"5\" style=\"text-align:right;\">总价(包含运费):<span class=\"red\">" + string.Format("{0:C2}", Set.Tables[1].Rows[0]["MoneyTotal"]) + "</span>元</td></tr>"); } else { sb.Append("<tr class=\"cartListRow\"><td colspan=\"5\" style=\"text-align:right;\"><div class=\"NoInfo\">您还没有购买产品!!</div></td></tr>"); } sb.Append("</table>"); Response.Write(sb.ToString()); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { classID = WebUnitily.CheckInt(Request["ClassId"]); bindClassList(); if (Request.QueryString["Order"] == null) { } else { order = Request.QueryString["Order"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (subTool.CheckUserLogin("-1")) { userID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517User", "userID")); if (!IsPostBack) { BindIndexHotShopping(); BindDataListShoppingRar(); BindAcceptAddrList(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { Int32 Id = WebUnitily.CheckInt(Request["Id"]); if (Id == 0) { Response.Write(WebUnitily.AlertUrl("请选择产品", "/")); Response.End(); } bindDataInfo(Id); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int infoID = WebUnitily.CheckInt(Request["helpID"]); if (infoID == 0) { Response.Write(WebUnitily.AlertUrl("请您选择帮助主题", "HelpList.aspx")); Response.End(); } BindIndexHelpTitle(); BindHelpInfo(infoID); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int PId = WebUnitily.CheckInt(Request["PId"]); ViewState["PID"] = PId; if (PId == 0) { Response.Write(WebUnitily.AlertUrl("请选择产品", "ProductList.aspx")); Response.End(); } txtId.Text = PId.ToString(); GetBindTuiJian(); BindProductInfoByProductID(PId); } }
protected void btnAdd_Click(object sender, EventArgs e) { L_AcceptAddrInfo acceptinfo = new L_AcceptAddrInfo(); acceptinfo.ProvinceID = WebUnitily.CheckInt(Request.Form["ProvinceId"]); acceptinfo.Province = WebUnitily.CheckStr(txtProvince.Text.Trim()); acceptinfo.CityID = WebUnitily.CheckInt(Request.Form["CityId"]); acceptinfo.City = WebUnitily.CheckStr(txtcity.Text.Trim()); acceptinfo.CountryID = WebUnitily.CheckInt(Request.Form["CountyId"]); acceptinfo.Country = WebUnitily.CheckStr(txtCountry.Text.Trim()); acceptinfo.RowAddr = WebUnitily.CheckStr(txtRowAddr.Text.Trim()); acceptinfo.RealityName = WebUnitily.CheckStr(txtRealityName.Text.Trim()); acceptinfo.HandSet = WebUnitily.CheckStr(txtHandset.Text.Trim()); acceptinfo.Tel = WebUnitily.CheckStr(txtDel.Text.Trim()); acceptinfo.zipCode = WebUnitily.CheckStr(txtZipCode.Text.Trim()); acceptinfo.QQNum = WebUnitily.CheckStr(txtQQMath.Text.Trim()); acceptinfo.UserID = userID; acceptinfo.PostTime = DateTime.Now; int exeResult = accept.InsertAcceptAddr(acceptinfo); switch (exeResult) { case 1: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("收货地址添加成功!")); break; case 0: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("收货地址最多只能添加10个,请您检查!")); break; default: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("收货地址添加失败,请您检查!")); break; } txtcity.Text = ""; txtCountry.Text = ""; txtDel.Text = ""; txtHandset.Text = ""; txtProvince.Text = ""; txtQQMath.Text = ""; txtRealityName.Text = ""; txtRowAddr.Text = ""; txtZipCode.Text = ""; }
protected void linkDelete_Click(object sender, EventArgs e) { L_CartInfo cart = new L_CartInfo(); cart.UserID = userID; cart.CartID = WebUnitily.CheckStr(Request["CardID"]); cart.ProductID = WebUnitily.CheckInt(Request["PId"]); if (cartinfo.GetCartListDelete(cart) == 1) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("购物车中的商品删除成功!")); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("商品删除失败!")); } BindIndexShoppingCartInfo(); }
private void BindIndexOrderListInfo() { StringBuilder sb = new StringBuilder(); int currPage = WebUnitily.CheckInt(Request["p"]); if (currPage == 0) { currPage = 1; } L_PageList pl = new L_PageList(); pl.Currpage = currPage; pl.PageSize = 16; pList8517.CurPage = currPage; pl.TableName = " (OrderList as a Left Join (Select orderID,Sum(memberPrice*discount) as PriceTotal,Sum(freign) as FreightTotal From orderDetail group by orderID) as b On b.orderID=a.orderID) "; pl.PKey = " a.orderID "; pl.FieldList = " a.orderID,a.userID,isNew,orderState,orderTime,ISNULL(b.PriceTotal,0) as PriceTotal,ISNULL(b.FreightTotal,0) as FreightTotal "; pl.Conditon = " and orderState=10 and userID= " + userID; pl.OrderBy = " orderTime Desc "; TableUpDateFieldsInfo tb = new TableUpDateFieldsInfo(); DataSet dSet = tb.GetPageList(pl); if (dSet.Tables.Count > 0) { if (dSet.Tables[0].Rows.Count > 0) { gvBindOrderListInfo.DataSource = dSet.Tables[0]; gvBindOrderListInfo.DataKeyNames = new string[] { "orderID" }; gvBindOrderListInfo.DataBind(); pList8517.TotalPage = int.Parse(tb.PageCount.ToString()); } else { gvBindOrderListInfo.DataBind(); } } else { gvBindOrderListInfo.DataBind(); } }
private void BindProduct() { int currPage = WebUnitily.CheckInt(Request["p"]); //获取所请求页的索引 if (currPage == 0) { currPage = 1; } L_PageList p1 = new L_PageList(); p1.Currpage = currPage; p1.PageSize = 15; //获取分页的用户控件 pList8517.CurPage = currPage; p1.TableName = "Product"; p1.PKey = "productID"; p1.FieldList = "productID,productName,categoryName,productImage,currentPrice,menberPrice,danwei,productStore,remainDay,addTime,isPost,isCommend"; // p1.Conditon = " and isPost=1"; p1.OrderBy = " addTime Desc"; TableUpDateFieldsInfo tb = new TableUpDateFieldsInfo(); DataSet dsSet = tb.GetPageList(p1); if (dsSet.Tables.Count > 0) { if (dsSet.Tables[0].Rows.Count > 0) { gvProduct.DataSource = dsSet.Tables[0]; gvProduct.DataKeyNames = new string[] { "ProductID" }; gvProduct.DataBind(); pList8517.TotalPage = int.Parse(tb.PageCount.ToString()); } else { gvProduct.DataBind(); } } else { gvProduct.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (subTool.CheckUserLogin("-1")) { userID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517User", "userID")); string requestType = WebUnitily.CheckStr(Request.Form["RequestType"]); //获取窗体变量的集合 switch (requestType) { case "add": userAddCart(); break; case "change": break; } } }
private void BindIndexyifahuo() { StringBuilder sb = new StringBuilder(); int currPage = WebUnitily.CheckInt(Request["p"]); if (currPage == 0) { currPage = 1; } L_PageList pl = new L_PageList(); pl.Currpage = currPage; pl.PageSize = 15; plist8571.CurPage = currPage; pl.TableName = "(OrderList as a Left Join (Select orderID,sum(memberPrice*BugNum*DisCount) as PriceTotal,sum(freign) as freightTotal From OrderDeTail Group by orderID) as b on b.orderID=a.orderID) "; pl.PKey = "a.orderID "; pl.FieldList = "a.orderID,a.userID,isNew,orderState,acceptName,acceptAddr,handSet,tel,zipCode,orderTime,ISNULL(b.priceTotal,0) as priceTotal,ISNULL(b.freightTotal,0) as freightTotal "; pl.Conditon = "and orderState=30 "; pl.OrderBy = "orderTime Desc "; longyuan_TableUpDateFieldsInfo tb = new longyuan_TableUpDateFieldsInfo(); DataSet set = tb.GetPageList(pl); if (set.Tables.Count > 0) { if (set.Tables[0].Rows.Count > 0) { gvBindyifahuo.DataSource = set.Tables[0]; gvBindyifahuo.DataKeyNames = new string[] { "orderID" }; gvBindyifahuo.DataBind(); } else { gvBindyifahuo.DataBind(); } } else { gvBindyifahuo.DataBind(); } }
private void bindClassList() { StringBuilder sb = new StringBuilder(); int currpage = WebUnitily.CheckInt(Request["p"]); if (currpage == 0) { currpage = 1; } L_PageList pl = new L_PageList(); pl.Currpage = currpage; pl.PageSize = 10; plList8531.CurPage = currpage; pl.TableName = "Product "; pl.PKey = "productID "; pl.FieldList = "productID,ProductName,ProductImage,Price,CurrentPrice,MenberPrice,Danwei,RemainDay,AddTime,LinkQQId,LinkQQName "; pl.OrderBy = " AddTime Desc "; TableUpDateFieldsInfo tb = new TableUpDateFieldsInfo(); DataSet set = tb.GetPageList(pl); if (set.Tables.Count > 0) { if (set.Tables[0].Rows.Count > 0) { rpDataList.DataSource = set.Tables[0]; rpDataList.DataBind(); plList8531.TotalPage = int.Parse(tb.PageCount.ToString()); } else { rpDataList.DataBind(); } } else { rpDataList.DataBind(); } }
private void BindHelpInfo() { int currPage = WebUnitily.CheckInt(Request["p"]); if (currPage == 0) { currPage = 1; } L_PageList pl = new L_PageList(); pl.Currpage = currPage; pl.PageSize = 10; pList8517.CurPage = currPage; pl.TableName = "ShopHelp"; pl.PKey = "helpID"; pl.FieldList = "helpID,helpTitle,classID,className,helpContent,postTime,isPost"; pl.OrderBy = "postTime desc"; longyuan_TableUpDateFieldsInfo tb = new longyuan_TableUpDateFieldsInfo(); DataSet dsSet = tb.GetPageList(pl); if (dsSet.Tables.Count > 0) { if (dsSet.Tables[0].Rows.Count > 0) { gvHelpInfo.DataSource = dsSet.Tables[0]; gvHelpInfo.DataKeyNames = new string[] { "helpID" }; gvHelpInfo.DataBind(); pList8517.TotalPage = Int32.Parse(tb.PageCount.ToString()); } else { gvHelpInfo.DataBind(); } } else { gvHelpInfo.DataBind(); } }
protected void imgBuyProduct_Click(object sender, ImageClickEventArgs e) { if (subTool.CheckUserLogin("-1")) { int userID = WebUnitily.CheckInt(mycookie.getCookiesValue("shop8517User", "userID")); L_CartInfo cInfo = new L_CartInfo(); cInfo.UserID = userID; cInfo.CartID = userID.ToString() + DateTime.Now.ToString("yyyyMMddmm"); cInfo.ProductID = WebUnitily.CheckInt(ViewState["PID"]); cInfo.BugNum = WebUnitily.CheckInt(txtBuyNum.Text); cInfo.bugTime = DateTime.Now; if (cInfo.ProductID == 0) { Response.Write("你需要加入购物车的商品不存在,请您检查!!"); Response.End(); } if (cInfo.BugNum == 0) { Response.Write("请检查你要购买的商品数!"); Response.End(); } int exresult = cartinfo.addCart(cInfo); switch (exresult) { case 20: Response.Write("<script>alert('商品添加购物车成功');</script>"); Server.Transfer("../orderinfo/UserCard.aspx"); break; case 10: Response.Write("<script>alert('商品添加收藏夹成功');</script>"); Server.Transfer("../orderinfo/UserCard.aspx"); break; default: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("加入购物车失败,请您检查")); break; } } }
private void userAddCart() { L_CartInfo cInfo = new L_CartInfo(); cInfo.UserID = userID; cInfo.CartID = userID.ToString() + DateTime.Now.ToString("yyyyMMddmm"); cInfo.ProductID = WebUnitily.CheckInt(Request.Form["PId"]); cInfo.BugNum = WebUnitily.CheckInt(Request.Form["BuyNum"]); cInfo.bugTime = DateTime.Now; if (cInfo.ProductID == 0) { Response.Write("-1"); Response.End(); } if (cInfo.BugNum == 0) { Response.Write("-1"); Response.End(); } int extResult = cartinfo.addCart(cInfo); switch (extResult) { case 20: Response.Write("产品已经在购物车中"); Response.End(); break; case 10: Response.Write("产品加入购物车成功"); Response.End(); break; default: Response.Write("加入购物车失败"); Response.End(); break; } }
private void BindBulletin() { int currPage = WebUnitily.CheckInt(Request["p"]); if (currPage == 0) { currPage = 1; } L_PageList pl = new L_PageList(); pl.Currpage = currPage; pl.PageSize = 2; pList8517.CurPage = currPage; pl.TableName = "Bulletin"; pl.PKey = "ID"; pl.FieldList = "ID,bulletinTitle,bulletinContent,isPost,orderNum,postTime"; pl.OrderBy = "postTime desc"; TableUpDateFieldsInfo tb = new TableUpDateFieldsInfo(); DataSet Dset = tb.GetPageList(pl); if (Dset.Tables.Count > 0) { if (Dset.Tables[0].Rows.Count > 0) { gvBulletin.DataSource = Dset.Tables[0]; gvBulletin.DataKeyNames = new string[] { "ID" }; gvBulletin.DataBind(); pList8517.TotalPage = int.Parse(tb.PageCount.ToString()); } else { gvBulletin.DataBind(); } } }