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