public ActionResult Index(int ID)
{
var model = new CustomerSearchViewModel()
{
ID = ID
};
return PartialView(model);
}
public ActionResult getall(CustomerSearchViewModel model, int page = 1, int rows = 10)
{
var query = CustomerService.GetALL().Include(x => x.JobCate).Include(x => x.CustomerCompany);
if (!string.IsNullOrEmpty(model.Customer_SearchName))
{
query = query.Where(x => x.Name.Contains(model.Customer_SearchName));
}
if (model.ID != 0)
{
query = query.Where(x => x.CustomerCompany.ID == model.ID);
}
var count = query.Count();
var data = query.Select(x => new CustomerListViewModel()
{
ID = x.ID,
JobID = x.JobID,
JobIDName = x.JobCate.CateName,
CompanyID = x.CompanyID,
Name = x.Name,
Mobile = x.Mobile,
Mobile1 = x.Mobile1,
Phone = x.Phone,
AddBirthDay = x.AddBirthDay,
IsLeap = x.IsLeap,
BirthDay = x.BirthDay,
BirthDay1 = x.BirthDay1,
QQ = x.QQ,
Jobs = x.Jobs,
Email = x.Email,
Favorite = x.Favorite,
Address = x.Address,
ReMark = x.ReMark,
AddTime = x.AddTime,
LastTime = x.LastTime,
Status = x.Status,
AddUser = x.AddUser,
LastUser = x.LastUser,
})
.OrderBy(x => x.ID)
.Skip((page - 1) * rows)
.Take(rows).ToList();
foreach (var item in data)
{
if (item.AddBirthDay)
{
if (item.IsLeap)
{
item.BirthDay1 = Utilities.ConvertToChineseYearStyle(item.BirthDay.Year) + item.BirthDay1;
}
else
{
item.BirthDay1 = item.BirthDay.ToString("yyyy-MM-dd");
}
}
else
{
item.BirthDay1 = "";
}
}
var obj = new
{
rows = data,
total = count
};
return Json(obj);
}