public ActionResult GetUpdateDialog(int id) { eSalesService.Order2Service orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); eSalesService.EmpService empService = new eSalesService.EmpService(this.GetDBConnectionString()); eSalesService.CusService cusService = new eSalesService.CusService(this.GetDBConnectionString()); eSalesService.ShipService shipService = new eSalesService.ShipService(this.GetDBConnectionString()); eSaleModel.Order orderData = new eSaleModel.Order(); var data = orderService.GetOrderById(id); ViewBag.OrderId = data.OrderId; ViewBag.OrderDate = data.OrderDate; ViewBag.RequiredDate = data.RequiredDate; ViewBag.ShippedDate = data.ShippedDate; ViewBag.Freight = data.Freight; ViewBag.ShipCountry = data.ShipCountry; ViewBag.ShipCity = data.ShipCity; ViewBag.ShipRegion = data.ShipRegion; ViewBag.ShipPostalCode = data.ShipPostalCode; ViewBag.ShipAddress = data.ShipAddress; ViewBag.ShipName = data.ShipAddress; ViewBag.EmpId = data.EmpId; ViewBag.CustId = data.CustId; ViewBag.ShipperId = data.ShipperId; //ViewBag.OrderId = "updateProductGrid" + id; //ViewBag.EmpNameData = new SelectList(empService.GetEmpNameData(), "Value", "Text", orderData.EmpId); //ViewBag.CustNameData = new SelectList(cusService.GetCusNameData(), "Value", "Text", orderData.CustId); //ViewBag.ShipperNameData = new SelectList(shipService.GetShipperNameData(), "Value", "Text", orderData.ShipperId); return(PartialView()); }
public JsonResult Read() { var orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); var data = orderService.GetOrder(); return(this.Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetOrderByCondition(eSaleModel.Order condition) { var result = new eSaleModel.Order(); var orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); var store = new eSaleModel.Store(); result.O_OrderId = "%" + Convert.ToString(condition.OrderId) + "%"; result.CustName = "%" + (condition.CustName) + "%"; result.EmpId = condition.EmpName == null ? 0 : Int32.Parse(condition.EmpName); result.ShipperId = condition.ShipperName == null ? 0 : Int32.Parse(condition.ShipperName); result.OrderDate = condition.OrderDate; result.RequiredDate = condition.RequiredDate; result.ShippedDate = condition.ShippedDate; var data = orderService.GetOrderByCondition(result); return(this.Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteOrder(OrderDetailViewModel orderData) { var orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); try { var result = new OrderDetailViewModel(); result.OrderId = orderData.OrderId; var msg = orderService.DeleteOrder(result); return(this.Json(msg, JsonRequestBehavior.AllowGet)); } catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); error.Describe = "尚未填寫完成"; error.State = false; return(this.Json(error, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateOrder(OrderDetailViewModel orderData) { var orderService = new eSalesService.Order2Service(this.GetDBConnectionString()); try { var result = new OrderDetailViewModel(); result.CustId = Int32.Parse(orderData.CustName); result.EmpId = Int32.Parse(orderData.EmpName); result.OrderDate = orderData.OrderDate; result.RequiredDate = orderData.RequiredDate; result.ShippedDate = orderData.ShippedDate; result.ShipperId = Int32.Parse(orderData.ShipperName); result.OrderId = orderData.OrderId; result.Freight = orderData.Freight == null ? 0 : orderData.Freight; result.ShipCountry = orderData.ShipCountry == null ? string.Empty : orderData.ShipCountry; result.ShipCity = orderData.ShipCity == null ? string.Empty : orderData.ShipCity; result.ShipRegion = orderData.ShipRegion == null ? string.Empty : orderData.ShipRegion; result.ShipPostalCode = orderData.ShipPostalCode == null ? string.Empty : orderData.ShipPostalCode; result.ShipAddress = orderData.ShipAddress == null ? string.Empty : orderData.ShipAddress; result.ShipName = orderData.ShipName == null ? string.Empty : orderData.ShipName; result.Products = orderData.Products; var msg = orderService.UpdateOrder(result); return(this.Json(msg, JsonRequestBehavior.AllowGet)); } catch (Exception e) { var error = new eSaleModel.ViewModel.ErrorMsg(); error.Describe = "尚未填寫完成"; error.State = false; return(this.Json(error, JsonRequestBehavior.AllowGet)); } }