//購買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");
}
protected void Page_Load(object sender, EventArgs e)
{
DBFunction db = new DBFunction("product");
String[][] arr = db.searchByColumn("product_name");
for (int i = 0; i < arr.Length; i++)
{
Response.Write(arr[i][0] + "<br/>");
}
String[][] arr2 = db.searchSchema("name");
for (int i = 0; i < arr2.Length; i++)
{
Response.Write(arr2[i][0] + "<br/>");
}
String[] arr3 = db.searchByRow("product_color","黑")[0];
for (int i = 0; i < arr3.Length; i++)
{
Response.Write(arr3[i]);
}
String[] arr4 = db.searchByRow("product_price", 20, 30)[0];
for (int i = 0; i < arr4.Length; i++)
{
Response.Write(arr4[i] + "<br/>");
}
/*
String[] value = {"", "青茶", "25", "green", "L"};
String str = db.insert(arr2, value);
Response.Write(str + "<br/>");
String str = db.delete("product_name", "青茶");
Response.Write(str + "<br/>");
*/
}
//送出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 int findOrderID(DBFunction dbOrder)
{
String[][] IDArr = dbOrder.searchGroupBy("ID");
int newID = 0;
for (int i = 0; i < IDArr.Length; i++)
{
if (int.Parse(IDArr[i][0]) > newID) newID = int.Parse(IDArr[i][0]);
}
return ++newID;
}
//新增購物車資料
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);
}
protected void Page_Load(object sender, EventArgs e)
{
String dtID = Request.QueryString["deleteTypeID"];
if (dtID != null && dtID != "")
{
if (dbType.searchRowByColumn("name","id",dtID)[0][0]=="未分類" && dbType.searchByRow("name", "未分類").Length != 0)
{
if (db.searchByRow("type", dbType.searchByRow("name", "未分類")[0][0]).Length != 0)
{
Response.Write("<Script language='JavaScript'>alert('未分類中尚有商品');</script>");
}
}
else
{
Response.Write(""
+ "<script>"
+ "if(confirm('確認刪除?'))"
+ "{alert('刪除成功');document.location.href='Product.aspx?deleteType=" + dtID + "';}"
+ "else{alert('取消');windows.location.href='Product.aspx';}</script>");
}
}
String dt = Request.QueryString["deleteType"];
if (dt != null && dt!="")
{
deleteType(dt);
}
setLeftBar();
//0708每次load都先判斷是否有回傳值，第一次開網頁並沒有回傳
if (Session["account"] == null || !Session["account"].Equals("admin"))
{
buycarStr += "<div id='buycar'><a href='PurchaseCar.aspx'><img src='../Picture/buycar.png' /></a></div>";
}
else
{
txtType.Visible = true;
ImageButton1.Visible = true;
}
String del = Request.QueryString["del"];
if (del != null && del != "")
{
Response.Write(""
+ "<script>"
+ "if(confirm('確認刪除?'))"
+ "{alert('刪除成功');document.location.href='Product.aspx?delete=" + del + "';}"
+ "else{alert('取消');windows.location.href='Product.aspx';}</script>");
}
String deleteStr = Request.QueryString["delete"];
if (deleteStr != null)
{
delete(deleteStr);
}
DBFunction dbIndex = new DBFunction("indexInfo");
String[][] infoArr = dbIndex.searchByColumn("phone");
String phone = infoArr[0][0].Replace(" ", " ");
String num = Request.QueryString["num"];
String ID = Request.QueryString["ID"];
if (num != null && num != "")
{
if ((String)Session["account"] != null)
{
PutIntoCart(num,ID);
}
else
{
Response.Write("<Script language='JavaScript'>alert('請聯絡電話：" + phone + "');location.href='Product.aspx';</Script>");
}
}
else if(ID != null && (num == null || num=="")){
Response.Write("<Script language='JavaScript'>alert('請聯絡電話：" + phone + "');location.href='Product.aspx';</Script>");
}
pageShow(20);
}
//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");
}
//新增購物車資料
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);
}
