protected void btnSearch_Click(object sender, EventArgs e)
{
string Key = "'%" + this.txtKey.Text + "%'";
string where = "bookTitle like" + Key + "or ISBN like" + Key + "or auther like" + Key;
DataTable dt = Bbook.GetList(where).Tables[0];
GridView1.DataSource = dt;
GridView1.DataBind();
}
public void rpBind()
{
//设置购物车内容的数据源
dtTable = new DataTable();
DataColumn column2 = new DataColumn("ISBN"); //商品ID代号
DataColumn column3 = new DataColumn("bookTitle"); //商品名称
DataColumn column4 = new DataColumn("Num"); //数量
DataColumn column5 = new DataColumn("price"); //单价
DataColumn column6 = new DataColumn("totalPrice"); //总价
DataColumn column7 = new DataColumn("bookState"); //状态
dtTable.Columns.Add(column2);
dtTable.Columns.Add(column3);
dtTable.Columns.Add(column4);
dtTable.Columns.Add(column5);
dtTable.Columns.Add(column6);
dtTable.Columns.Add(column7);
string str = "'" + Session["OrderID"].ToString() + "'";
DataTable dsTableo = ordersh.GetList("orderNo=" + str).Tables[0];
DataTable dsTables = sale.GetList("orderNo=" + str).Tables[0];
DataTable dsTableb;
foreach (DataRow Rrow in dsTables.Rows)
{
DataRow row = dtTable.NewRow();
row["ISBN"] = Rrow["ISBN"];
dsTableb = book.GetList("ISBN=" + "'" + Rrow["ISBN"].ToString() + "'").Tables[0];
row["bookTitle"] = dsTableb.Rows[0]["bookTitle"];
row["Num"] = Rrow["quantity"];
row["price"] = dsTableb.Rows[0]["salePrice"];
row["totalPrice"] = (int.Parse(row["Num"].ToString()) * float.Parse(row["price"].ToString())).ToString();
row["bookState"] = Rrow["bookState"];
dtTable.Rows.Add(row);
}
this.rptOrderItems.DataSource = dtTable.DefaultView;
this.rptOrderItems.DataBind();
}
