protected void btnCheck_Click(object sender, EventArgs e) { List <CShoppingCart> cartList = Session["cart"] as List <CShoppingCart>; CBookFactory bookfactory = new CBookFactory(); COrdersFactory orderfactory = new COrdersFactory(); int bookId, bookPrice, count, subtotal; DateTime orderDate; string note; try { foreach (CShoppingCart c in cartList) { bookId = bookfactory.getbookId(c.書名); bookPrice = Convert.ToInt32(c.單價); count = Convert.ToInt32(c.數量); subtotal = Convert.ToInt32(c.小計); orderDate = Convert.ToDateTime(c.訂購日期); note = "收件人姓名" + tboxName1.Text + "電話" + tboxPhone1.Text + "地址" + tboxAddress1.Text + "email" + tboxEmail1.Text + "信用卡號碼" + tboxCardID.Text + "信用卡有效日期" + tboxCardMonth.Text + tboxCardYear.Text + "信用卡安全碼" + tboxSecurityID.Text; COrders order = new COrders() { book_id = bookId, bookPrice = bookPrice, count = count, subtotal = subtotal, orderDate = orderDate, note = note }; orderfactory.insertOrder(order); } } catch (Exception) { Response.Write("<script>alert('" + orderfactory.message + "')</script>"); } (Session["cart"] as List <CShoppingCart>).Clear(); Response.Write("<script>alert('" + orderfactory.message + "')</script>"); Response.Redirect("redirect.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { COrdersFactory factory = new COrdersFactory(); COrders order = new COrders() { book_id = 10002, bookPrice = 1200, count = 2, subtotal = 2400, orderDate = Convert.ToDateTime("2015/6/17"), note = "test" }; factory.insertOrder(order); }
private void reset_order_money(COrders order) { var menu = dao.get_Menu("name", order.menu); //var menu = db.Menu.FirstOrDefault(x => x.name == order.menu); if (menu != null) { if (order.priceType == "每小时") { order.money = Convert.ToDouble(menu.addMoney); } else if (order.comboId == null) { order.money = menu.price * order.number; } else if (order.comboId != null) { var combo = dao.get_Combo("id", order.comboId); if (combo == null) { return; } var freeIds = combo.disAssemble_freeIds(); var pars = new List <string>(); var vals = new List <string>(); int count = freeIds.Count; for (int i = 0; i < count; i++) { pars.Add("id"); vals.Add(freeIds[i].ToString()); } var freeMenus = dao.get_Menus(pars, vals, "or").Select(x => x.name); if (!freeMenus.Contains(order.menu)) { order.money = menu.price * order.number; } } } else { var combo = dao.get_Combo("id", order.comboId); order.money = combo.get_combo_price(dao); } }
public void insertOrder(COrders order) { try { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = connectionString; sds.InsertCommand = "dbo.insertOrders"; sds.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sds.InsertParameters.Add(new Parameter("book_id", DbType.Int32, order.book_id.ToString())); sds.InsertParameters.Add(new Parameter("bookPrice", DbType.Int32, order.bookPrice.ToString())); sds.InsertParameters.Add(new Parameter("count", DbType.Int32, order.count.ToString())); sds.InsertParameters.Add(new Parameter("subtotal", DbType.Int32, order.subtotal.ToString())); sds.InsertParameters.Add(new Parameter("orderDate", DbType.DateTime, order.orderDate.ToString())); sds.InsertParameters.Add(new Parameter("note", DbType.String, order.note)); sds.Insert(); message = "insert success"; } catch (Exception ex) { message = ex.Message; } }