//購買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");
}
//送出btn
protected void btnSubmit_Click(object sender, EventArgs e)
{
DBFunction dbOrder = new DBFunction("orderList");
DBFunction dbProduct = new DBFunction("product");
String[][] attributes = dbOrder.searchSchema("name");
String[] schemaArr = new String[attributes.Length+1];
int orderID = findOrderID(dbOrder);
for (int i = 1; i < attributes.Length+1; i++)
{
schemaArr[i] = attributes[i-1][0];
}
for (int i = 0; i < arrOrder.Length; i++ )
{
int subtotal = 0;
if (arrOrder[i][7] == null || arrOrder[i][7].Equals("0"))
{
subtotal = Convert.ToInt32(arrOrder[i][3]) * Convert.ToInt32(arrOrder[i][5]);
}
else
{
String[] discountArr = disc.findingType(int.Parse(arrOrder[i][7]), int.Parse(arrOrder[i][5]), int.Parse(arrOrder[i][3]));
subtotal = int.Parse(discountArr[1]);
}
DateTime dt = DateTime.Now;
String[] values = new String[] { "", orderID.ToString(), Session["account"].ToString(), arrOrder[i][2], arrOrder[i][5], subtotal.ToString(), "", "", dt.ToShortDateString().ToString() };
dbOrder.insert(schemaArr, values);
dbProduct.modify("num", int.Parse(arrOrder[i][4]) - int.Parse(arrOrder[i][5]), "name", arrOrder[i][2]);
db.delete("ID", arrOrder[i][1]);
}
Response.Write("<Script language='JavaScript'>alert('購買成功!');location.href='../Index.aspx';</Script>");
}
//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");
}
