void Repeater1Paging() { if (Request.QueryString["pageindex"] != null) { pageindex = Convert.ToInt32(Request.QueryString["pageindex"]); } pagecount = Bll_Order.RowCount() % pagesize == 0 ? Bll_Order.RowCount() / pagesize : Bll_Order.RowCount() / pagesize + 1; if (Request.QueryString["pageindex"] != null) { if (Convert.ToInt32(Request.QueryString["pageindex"]) > pagecount) { pageindex = pagecount; } } List <Order> orders = Bll_Order.Paging(pageindex, pagesize); Repeater1.DataSource = orders; Repeater1.DataBind(); if (pageindex > 1) { HyperLink1.NavigateUrl = "Orders.aspx?pageindex=1"; HyperLink2.NavigateUrl = "Orders.aspx?pageindex=" + (pageindex - 1); } if (pageindex < pagecount) { HyperLink3.NavigateUrl = "Orders.aspx?pageindex=" + (pageindex + 1); HyperLink4.NavigateUrl = "Orders.aspx?pageindex=" + pagecount; } }
protected int pagecount = 1; //页大小 protected void Page_Load(object sender, EventArgs e) { if (Session["pagesize"] != null) { pagesize = Convert.ToInt32(Session["pagesize"]); } if (Request.QueryString["pageindex"] != null) { Repeater1Paging(); } if (!IsPostBack) { if (Request.QueryString["pageindex"] == null) { Repeater1.DataSource = Bll_Order.Select_All(); Repeater1.DataBind(); } } }
protected void Button1_Click(object sender, EventArgs e) { if ((TextBox1.Text != null && TextBox1.Text != "" && TextBox1.Text.Trim() != "") && (TextBox4.Text == null || TextBox4.Text == "" || TextBox4.Text.Trim() == "")) { Repeater1.DataSource = Bll_Order.Select_OID(TextBox1.Text); Repeater1.DataBind(); } if ((TextBox1.Text == null || TextBox1.Text == "" || TextBox1.Text.Trim() == "") && (TextBox4.Text != null && TextBox4.Text != "" && TextBox4.Text.Trim() != "")) { Repeater1.DataSource = Bll_Order.Select_OConsignee(TextBox4.Text); Repeater1.DataBind(); } if ((TextBox1.Text != null && TextBox1.Text != "" && TextBox1.Text.Trim() != "") && (TextBox4.Text != null && TextBox4.Text != "" && TextBox4.Text.Trim() != "")) { Repeater1.DataSource = Bll_Order.Select_OConsignee_OID(TextBox4.Text, TextBox1.Text); Repeater1.DataBind(); } if ((TextBox1.Text == null || TextBox1.Text == "" || TextBox1.Text.Trim() == "") && (TextBox4.Text == null || TextBox4.Text == "" || TextBox4.Text.Trim() == "")) { Session.Remove("pagesize"); Response.Redirect("Orders.aspx" /* + (Request.QueryString["pageindex"] == null ? "" : "?pageindex=" + Request.QueryString["pageindex"].ToString())*/); } }
protected void Button1_Click(object sender, EventArgs e) { string OConsignee = TextBox1.Text; //收货人昵称 string OAddress = TextBox2.Text; //地址 string OTelephone = TextBox3.Text; //联系电话 double OSumPrice = Convert.ToDouble(TextBox4.Text); //订单总消费 bool UpdateSwitch = true; //修改库存开关 string[] TradeTID = Request.QueryString["TradesTID"].ToString().Trim().Split('^'); //遍历结算中商品的库存对比购买的数量,如果全部商品库存足够,则打开修改开关,否则关闭修改开关 for (int i = 0; i < TradeTID.Length; i++) { if (TradeTID[i] != "") { Trade trade = Bll_Trade.Select_TradeAndBook_TID(Convert.ToInt32(TradeTID[i])); if (trade.BCount > Bll_Book.Select_BID(trade.BID).BCount) { UpdateSwitch = false; } } } //修改订单内商品的库存和销量 if (UpdateSwitch) { for (int i = 0; i < TradeTID.Length; i++) { if (TradeTID[i] != "") { Trade trade = Bll_Trade.Select_TradeAndBook_TID(Convert.ToInt32(TradeTID[i])); Bll_Book.Update_BCountAndBSaleCount(new Book() { BID = trade.BID, BCount = trade.BCount }); } } //为当前结算添加订单 Order order = new Order() { OID = Bll_Order.ObtainOID(), MID = Bll_Member.GetMID(Request.Cookies["Login"].Values["MName"]), ODate = DateTime.Now.ToString(), OConsignee = OConsignee, OAddress = OAddress, OTelephone = OTelephone, OSumPrice = OSumPrice, OState = "1" }; Bll_Order.Insert(order); //为订单添加订单明细 for (int i = 0; i < TradeTID.Length; i++) { if (TradeTID[i] != "") { Trade trade = Bll_Trade.Select_TradeAndBook_TID(Convert.ToInt32(TradeTID[i])); Bll_OrderDetails.Insert(new OrderDetails() { OID = order.OID, BID = trade.BID, BPrice = trade.BPrice, BCount = trade.BCount }); } } //清空当前用户购物车 Bll_Trade.Delelte_MID(order.MID); //订单号页面 Response.Redirect("Done.aspx?OID=" + order.OID); } else { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('部分商品库存不足')</script>"); } }
protected void Button3_Click(object sender, EventArgs e) { Bll_Order.UpdateOState_OID((sender as Button).CommandName, Convert.ToInt32((sender as Button).AccessKey)); Response.Redirect("Orders.aspx"); }