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));
}
}
