public ActionResult OrderDetail(int?oid) { if (oid == null) { RedirectToAction("Index"); } #region 列出訂單明細 System.Text.StringBuilder sb = new System.Text.StringBuilder(); DB.DB mydb = new DB.DB(); DB.IOrder io = new DB.Impl_Order(mydb.Connection); DataTable tt = io.GetOrderDetail(oid.Value); int totalPrice = 0; if (tt != null) { foreach (DataRow r in tt.Rows) { totalPrice += (int)r["proPrice"] * (int)r["quantity"]; sb.Append("<tr>"); sb.Append(string.Format("<td>{0}</td>", r["proName"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["proPrice"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["quantity"].ToString())); sb.Append("</tr>"); } } ViewData["orderID"] = oid.ToString(); ViewData["totalPrice"] = totalPrice.ToString(); ViewData["orderDetailList"] = sb.ToString(); #endregion return(View()); }
// GET: Customer public ActionResult Index() { #region 列出訂單 System.Text.StringBuilder sb = new System.Text.StringBuilder(); DB.DB mydb = new DB.DB(); DB.IOrder io = new DB.Impl_Order(mydb.Connection); DataTable tt = io.GetOrderInfoByCustPhone(Session["Login"].ToString()); if (tt != null) { foreach (DataRow r in tt.Rows) { sb.Append("<tr>"); sb.Append(string.Format("<td align=\"center\"><a style=\"text-decoration:underline\" href=\"/Customer/OrderDetail?oid={0}\">{1}</a></td>", r["orderID"].ToString(), r["orderID"].ToString())); sb.Append(string.Format("<td align=\"center\">{0}</td>", r["rcptName"].ToString())); sb.Append(string.Format("<td align=\"center\">{0}</td>", r["rcptPhone"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["rcptAddr"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["DTName"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["Shipping"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["orderState"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["orderNote"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["orderTime"].ToString())); sb.Append("</tr>"); } } ViewData["orderList"] = sb.ToString(); #endregion return(View()); }
public ActionResult ChageOrderState(Models.Order order) { DB.DB mydb = new DB.DB("SQLAdmin", "admin1234"); DB.IOrder io = new DB.Impl_Order(mydb.Connection); io.UpdateOrder(order.orderID, order.orderState); return(RedirectToAction("ManageOrder")); }
public ActionResult ManageOrder() { #region 列出訂單 System.Text.StringBuilder sb = new System.Text.StringBuilder(); DB.DB mydb = new DB.DB(); DB.IOrder io = new DB.Impl_Order(mydb.Connection); DataTable tt = io.GetOrderInfo(); if (tt != null) { foreach (DataRow r in tt.Rows) { sb.Append("<tr>"); sb.Append(string.Format("<td align=\"center\">{0}</td>", r["orderID"].ToString())); sb.Append(string.Format("<td align=\"center\">{0}</td>", r["custID"].ToString())); sb.Append(string.Format("<td align=\"center\">{0}</td>", r["rcptName"].ToString())); sb.Append(string.Format("<td align=\"center\">{0}</td>", r["rcptPhone"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["rcptAddr"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["DTName"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["Shipping"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["orderState"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["orderNote"].ToString())); sb.Append(string.Format("<td>{0}</td>", r["orderTime"].ToString())); sb.Append("</tr>"); } } ViewData["orderList"] = sb.ToString(); #endregion return(View()); }
public ActionResult PlaceOrder(Models.Order order) { if (Session["Cart"] == null) { return(RedirectToAction("Index", "Home")); } DB.DB mydb = new DB.DB(); DB.ICustomer ic = new DB.Impl_Customer(mydb.Connection); order.custID = ic.GetCustIDByPhone(Session["Login"].ToString()); DB.DB mydb2 = new DB.DB("SQLAdmin", "admin1234"); DB.IOrder io = new DB.Impl_Order(mydb2.Connection); order.orderID = io.AddNewOrder(order.custID, order.rcptName, order.rcptPhone, order.rcptAddr, order.DTID, order.Shipping, order.orderNote); HashSet <Models.CartItem> myCart = Session["Cart"] as HashSet <Models.CartItem>; List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (Models.CartItem ii in myCart) { Dictionary <string, object> temp = new Dictionary <string, object>(); temp["proID"] = ii.ID; temp["Quantity"] = ii.Quantity; items.Add(temp); } DB.DB mydb3 = new DB.DB("SQLAdmin", "admin1234"); DB.IOrder io2 = new DB.Impl_Order(mydb3.Connection); bool finish = io2.AddCartItems(order.orderID, items); if (finish) { return(RedirectToAction("FinishOrder", new { msg = "已完成訂單!請至個人中心查看!" })); } else { return(RedirectToAction("FinishOrder", new { msg = "訂單失敗!請重新下訂貨聯絡客服!" })); } }