//購買btn
protected void btnPurchase_Click(object sender, EventArgs e)
{
DBFunction dbPurchase = new DBFunction("purchaseList");
//舊有資料更新
String[][] checkArr = dbPurchase.searchRowByColumn("product_name , num", "account", Session["account"].ToString());
if (checkArr.Length > 0)
{
bool check = false;
int i;
for (i = 0; i < checkArr.Length; i++)
{
if (checkArr[i][0].Equals(productName.Text))
{
check = true;
break;
}
}
if(check)
dbPurchase.modify("num", int.Parse(checkArr[i][1]) + int.Parse(numberDropList.SelectedValue), "account", Session["account"].ToString() + "' AND product_name='" + productName.Text);
else newData(dbPurchase);
}
else
{
newData(dbPurchase);
}
Response.Redirect("Product.aspx");
}
//click商品數量加入購物車
private void PutIntoCart(String num,String ID)
{
DBFunction dbPurchase = new DBFunction("purchaseList");
String[][] info = db.searchRowByColumn("name, price", "ID", ID);
//舊有資料更新
String[][] checkArr = dbPurchase.searchRowByColumn("product_name , num", "account", Session["account"].ToString());
if (checkArr.Length > 0)
{
bool check = false;
int i;
for (i = 0; i < checkArr.Length; i++)
{
if (checkArr[i][0].Equals(info[0][0]))
{
check = true;
break;
}
}
if (check)
dbPurchase.modify("num", int.Parse(checkArr[i][1]) + int.Parse(num), "account", Session["account"].ToString() + "' AND product_name='" + info[0][0]);
else newData(dbPurchase, info[0][0], num, (int.Parse(num) * int.Parse(info[0][1])).ToString());
}
else
{
newData(dbPurchase, info[0][0], num, (int.Parse(num) * int.Parse(info[0][1])).ToString());
}
Response.Redirect("Product.aspx");
}
