protected void AddBook(int id)
{
//isExit表示商品是否已经在购物车中，是为1，否为0
int isExit = 0;
for (int j = 0; j < Profile.Cart.BookName.Count; j++)
{
if (id == (int)Profile.Cart.BookId[j])
{
//若同类商品已经存在于购物车，则将该商品的购买数量加1
int s = (int)Profile.Cart.Qty[j];
s++;
Profile.Cart.Qty[j] = s;
Profile.Save();
isExit = 1;
}
}
if (isExit == 0)
{
//若购物车中无指定商品编号的商品，添加一个新商品到Profile.cart的个属性
MyBookStoreDataContext db = new MyBookStoreDataContext();
var book = (from p in db.Book
where p.BookId == id
select p).First();
Profile.Cart.Price.Add(book.Price);
Profile.Cart.Qty.Add(1);
Profile.Cart.BookId.Add(book.BookId);
Profile.Cart.BookName.Add(book.BookName);
Profile.Save();//保存到ASPNETDB数据库中
}
}
protected void Button3_Click(object sender, EventArgs e)
{
lblError.Text = "";
MyBookStoreDataContext db = new MyBookStoreDataContext();
//循环利用FindControl()找到TextBox控件txtQty,然后判断其值是否为空，若非空
//则在Book表中查询txtQty所在行商品编号确定的商品，从而比较txtQty中的输入值和库存量
for (int i = 0; i < GridView1.Rows.Count; i++)
{
TextBox txtQty = new TextBox();
txtQty = (TextBox)GridView1.Rows[i].FindControl("txtQty");
if (txtQty != null)
{
var book = (from p in db.Book
where p.BookId == int.Parse(GridView1.Rows[i].Cells[1].Text)
select p).First();
if (int.Parse(txtQty.Text) > book.Qty)
{
lblError.Text += "Erro:库存不足，商品名为" + GridView1.Rows[i].Cells[2].Text + "的商品数量为" + book.Qty.ToString() + "<br/>";
}
else
{
//调用自定义方法，改变存储在Profile中的购买数量
ChangeQty(int.Parse(GridView1.Rows[i].Cells[1].Text), int.Parse(txtQty.Text));
}
}
}
Bind(); //调用自定义方法，显示购物车中的所有商品
}
protected void Button1_Click(object sender, EventArgs e)
{
MyBookStoreDataContext db = new MyBookStoreDataContext();
var result = from c in db.Book
where SqlMethods.Like(c.BookName, "%" + TextBox1.Text + "%")
select c;
if (result.Count() != 0)
{
DetailsView1.DataSource = result;
DetailsView1.DataBind();
}
else
{
Label2.Text = "没有满足条件的数据";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
MyBookStoreDataContext db = new MyBookStoreDataContext();
//在AdminOrder表中添加一条订单
AdminOrder order = new AdminOrder();
//收货人、联系方式、收货地址从页面的TextBox控件中获得
order.UserNmae = txtName.Text;
order.Address = txtAddress.Text;
order.Phone = txtPhone.Text;
order.OrderDate = DateTime.Now;
order.Status = "未审核";
//插入实体order，提交更改后在AdminOrder表添加一条记录
db.AdminOrder.InsertOnSubmit(order);
db.SubmitChanges();
//在OrderItem表中添加订单详细信息
int id = order.OrderId;
for (int i = 0; i < Profile.Cart.BookName.Count; i++)
{
OrderItem orderItem = new OrderItem();
orderItem.OrderId = id;
orderItem.BookName = (string)Profile.Cart.BookName[i];
orderItem.Price = (decimal)Profile.Cart.Price[i];
orderItem.Qty = (int)Profile.Cart.Qty[i];
orderItem.TotalPrice = (int)Profile.Cart.Qty[i] * (decimal)Profile.Cart.Price[i];
db.OrderItem.InsertOnSubmit(orderItem);
db.SubmitChanges();
var book = (from c in db.Book
where c.BookId == (int)Profile.Cart.BookId[i]
select c).First();
book.Qty -= orderItem.Qty;
db.SubmitChanges();
}
//清空Profile.Cart中的对象
Profile.Cart.BookId.Clear();
Profile.Cart.BookName.Clear();
Profile.Cart.Price.Clear();
Profile.Cart.Qty.Clear();
Profile.Cart.TotalPrice = "";
lblMsg.Text = "已经结算成功，谢谢光临";
}
