// GET: Order public ActionResult Index() { ModelService.OrderService orderService = new ModelService.OrderService(); List <Models.Order> dataList = orderService.GetEmployeeData(); List <SelectListItem> employeeList = new List <SelectListItem>(); List <SelectListItem> shipperList = new List <SelectListItem>(); //員工List foreach (var item in dataList) { employeeList.Add(new SelectListItem() { Text = item.EmployeeName, Value = item.EmployeeID.ToString(), }); } ViewBag.empData = employeeList; ViewBag.empData2 = employeeList; //供應商List dataList = orderService.GetShipperData(); foreach (var item in dataList) { shipperList.Add(new SelectListItem() { Text = item.ShipperName, Value = item.ShipperID.ToString() }); } ViewBag.shipperData = shipperList; return(View()); }
public JsonResult GetData(Models.Order order) { ModelService.OrderService orderService = new ModelService.OrderService(); List <Models.Order> list = orderService.SearchOrder(order); return(this.Json(list)); }
public CustJsonResult GetData(Models.Order order) { ModelService.OrderService orderService = new ModelService.OrderService(); List <Models.Order> list = orderService.SearchOrder(order); //var A= this.Json(list); //return A; //var a = this.Json(list); return(new CustJsonResult { Data = list }); }
// GET: Order public ActionResult Index() { ModelService.OrderService orderService = new ModelService.OrderService(); //員工List List <Models.Order> dataList = orderService.GetEmployeeData(); ViewBag.empData = new SelectList(dataList, "EmployeeID", "EmployeeName"); //供應商List dataList = orderService.GetShipperData(); ViewBag.shipperData = new SelectList(dataList, "ShipperID", "ShipperName"); return(View()); }
/// <summary> /// 新增訂單頁面 /// </summary> /// <returns></returns> public ActionResult InsertPage() { ModelService.OrderService orderService = new ModelService.OrderService(); List <Models.Order> dataList = orderService.GetEmployeeData(); List <Models.OrderDetails> ProductList = orderService.GetProductData(); List <SelectListItem> employeeList = new List <SelectListItem>(); List <SelectListItem> shipperList = new List <SelectListItem>(); List <SelectListItem> customerList = new List <SelectListItem>(); List <SelectListItem> productList = new List <SelectListItem>(); List <SelectListItem> unitpriceList = new List <SelectListItem>(); //員工List foreach (var item in dataList) { employeeList.Add(new SelectListItem() { Text = item.EmployeeName, Value = item.EmployeeID.ToString(), }); } ViewBag.empData = employeeList; //供應商List dataList = orderService.GetShipperData(); foreach (var item in dataList) { shipperList.Add(new SelectListItem() { Text = item.ShipperName, Value = item.ShipperID.ToString() }); } ViewBag.shipperData = shipperList; ///客戶List dataList = orderService.GetCustomerData(); foreach (var item in dataList) { customerList.Add(new SelectListItem() { Text = item.CustomerName, Value = item.CustomerID.ToString() }); } ViewBag.customerData = customerList; //產品List foreach (var item in ProductList) { productList.Add(new SelectListItem() { Text = item.ProductName, Value = item.ProductID.ToString() }); } ViewBag.productData = productList; ProductList = orderService.GetPriceData(); foreach (var item in ProductList) { unitpriceList.Add(new SelectListItem() { Value = item.UnitPrice }); } ViewBag.UnitPrice = unitpriceList; return(View()); }
public ActionResult DoDelete(string OrderID) { ModelService.OrderService orderService = new ModelService.OrderService(); orderService.DeleteOrderById(OrderID); return(RedirectToAction("Index")); }
public ActionResult DoUpdate(Models.Order order) { ModelService.OrderService orderService = new ModelService.OrderService(); orderService.UpdateOrderById(order); return(RedirectToAction("Index")); }
/// <summary> /// 修改訂單頁面 (get) /// </summary> /// <param name="OrderID"></param> /// <returns></returns> public ActionResult UpdatePage(string OrderID) { ModelService.OrderService orderService = new ModelService.OrderService(); List <Models.Order> dataList = orderService.GetEmployeeData(); List <Models.OrderDetails> ProductList = orderService.GetProductData(); Models.Order order = orderService.GetOrderById(OrderID); List <Models.OrderDetails> orderdetails = orderService.GetOrderDetialById(OrderID); List <SelectListItem> employeeList = new List <SelectListItem>(); List <SelectListItem> shipperList = new List <SelectListItem>(); List <SelectListItem> customerList = new List <SelectListItem>(); List <SelectListItem> productList = new List <SelectListItem>(); List <SelectListItem> unitpriceList = new List <SelectListItem>(); List <List <SelectListItem> > getProductData = new List <List <SelectListItem> >(); double total = 0; for (var i = 0; i < orderdetails.Count; i++) { double Qty = Convert.ToDouble(orderdetails[i].Qty); double UnitPrice = Convert.ToDouble(orderdetails[i].UnitPrice); total += Qty * UnitPrice; } ViewBag.Total = total + Convert.ToDouble(order.Freight); //員工List foreach (var item in dataList) { employeeList.Add(new SelectListItem() { Text = item.EmployeeName, Value = item.EmployeeID.ToString(), Selected = item.EmployeeID.Equals(order.EmployeeID) }); } ViewBag.empData = employeeList; //供應商List dataList = orderService.GetShipperData(); foreach (var item in dataList) { shipperList.Add(new SelectListItem() { Text = item.ShipperName, Value = item.ShipperID.ToString(), Selected = item.ShipperID.Equals(order.ShipperID) }); } ViewBag.shipperData = shipperList; ///客戶List dataList = orderService.GetCustomerData(); foreach (var item in dataList) { customerList.Add(new SelectListItem() { Text = item.CustomerName, Value = item.CustomerID.ToString(), Selected = item.CustomerID.Equals(order.CustomerID) }); } ViewBag.customerData = customerList; //產品List for (int i = 0; i < orderdetails.Count; i++) { foreach (var item in ProductList) { productList.Add(new SelectListItem() { Text = item.ProductName, Value = item.ProductID.ToString(), Selected = item.ProductID.Equals(orderdetails[i].ProductID), }); } getProductData.Add(new List <SelectListItem>(productList)); productList.Clear(); } ViewBag.productData = getProductData; ProductList = orderService.GetPriceData(); foreach (var item in ProductList) { unitpriceList.Add(new SelectListItem() { Value = item.UnitPrice }); } ViewBag.UnitPrice = unitpriceList; ViewBag.orderData = order; //Convert將基底資料類型轉換為其他基底資料類型 DateTime orderdate = Convert.ToDateTime(order.OrderDate); ViewBag.OrderDate = (orderdate.ToString("yyyy-MM-dd")); DateTime requireDdate = Convert.ToDateTime(order.RequiredDate); ViewBag.RequireDdate = (requireDdate.ToString("yyyy-MM-dd")); DateTime shippedDate = Convert.ToDateTime(order.ShippedDate); ViewBag.ShippedDate = (shippedDate.ToString("yyyy-MM-dd")); ViewBag.OrderDetails = orderdetails; return(View()); }
public ActionResult DoInsert(Models.Order order) { ModelService.OrderService orderService = new ModelService.OrderService(); orderService.InsertOrder(order); return(RedirectToAction("Index")); }