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