//送出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>");
}
//新增購物車資料
private void newData(DBFunction dbPurchase)
{
String[][] attributes = dbPurchase.searchSchema("name");
String[] schemaArr = new String[attributes.Length];
for (int i = 0; i < attributes.Length; i++)
{
schemaArr[i] = attributes[i][0];
}
String[] values = new String[] { "", Session["account"].ToString(), productName.Text, finalPrice, numberDropList.SelectedValue };
dbPurchase.insert(schemaArr, values);
}
//新增購物車資料
private void newData(DBFunction dbPurchase, String name, String num, String price)
{
String[][] attributes = dbPurchase.searchSchema("name");
String[] schemaArr = new String[attributes.Length];
for (int i = 0; i < attributes.Length; i++)
{
schemaArr[i] = attributes[i][0];
}
String[] values = new String[] { "", Session["account"].ToString(), name, price, num };
dbPurchase.insert(schemaArr, values);
}
