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