public JsonResult InsertCus(Models.Customers cus)
{
Services.CusServices cusService = new Services.CusServices();
try
{
var cusData = new Models.Customers();
cusData.CompanyName = cus.CompanyName == null ? string.Empty : cus.CompanyName;
cusData.ContactName = cus.ContactName == null ? string.Empty : cus.ContactName;
cusData.ContactTitle = cus.ContactTitle;
cusData.CreationDate = cus.CreationDate;
cusData.Address = cus.Address == null ? string.Empty : cus.Address;
cusData.City = cus.City == null ? string.Empty : cus.City;
cusData.Country = cus.Country == null ? string.Empty : cus.Country;
cusData.Region = cus.Region == null ? string.Empty : cus.Region;
cusData.PostalCode = cus.PostalCode == null ? string.Empty : cus.PostalCode;
cusData.Phone = cus.Phone == null ? string.Empty : cus.Phone;
cusData.Fax = cus.Fax == null ? string.Empty : cus.Fax;
var data = cusService.InsertCus(cusData);
return(this.Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(this.Json(e, JsonRequestBehavior.AllowGet));
}
}
public JsonResult DeleteCus(int id)
{
Services.CusServices cusService = new Services.CusServices();
var data = cusService.DeleteCus(id);
return(this.Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCusGrid()
{
Services.CusServices cusService = new Services.CusServices();
var data = cusService.GetCusGrid();
return(this.Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 取得所有 PorductName 和 PorductID
/// </summary>
/// <returns></returns>
public JsonResult ReadContactTitleList()
{
Services.CusServices cusService = new Services.CusServices();
var data = cusService.GetContactTitleData();
return(this.Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult SearchCus(Models.Customers cus)
{
Services.CusServices cusService = new Services.CusServices();
var cusData = new Models.CustomerView1();
cusData.CustomerID = Convert.ToInt16(cus.CustomerID);
cusData.CompanyName = "%" + Convert.ToString(cus.CompanyName) + "%";
cusData.ContactName = "%" + Convert.ToString(cus.ContactName) + "%";
cusData.ContactTitle = "000" + Convert.ToString(cus.ContactTitle);
var data = cusService.SearchCus(cusData);
return(this.Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult GetUpdateWindow(int id)
{
Services.CusServices cusService = new Services.CusServices();
var data = cusService.GetCusById(id);
ViewBag.CustomerID = data.CustomerID;
ViewBag.CompanyName = data.CompanyName;
ViewBag.ContactName = data.ContactName;
ViewBag.ContactTitle = Convert.ToInt16(data.ContactTitle);
ViewBag.CreationDate = data.CreationDate;
ViewBag.Address = data.Address;
ViewBag.City = data.City;
ViewBag.Country = data.Country;
ViewBag.Region = data.Region;
ViewBag.PostalCode = data.PostalCode;
ViewBag.Phone = data.Phone;
ViewBag.Fax = data.Fax;
return(PartialView());
}
