public IQueryable <VW_CompanyList_2> Query(QueryCompanyModel model)
{
var data = base.All();
if (!string.IsNullOrEmpty(model.CompanyName))
{
data = data.Where(p => p.客戶名稱.Contains(model.CompanyName));
}
return(data.AsQueryable());
}
public IQueryable <VW_CompanyList> Query(QueryCompanyModel model)
{
var data = base.All();
if (!string.IsNullOrEmpty(model.CompanyName))
{
data = data.Where(p => p.CompanyName.Contains(model.CompanyName));
}
if (string.IsNullOrEmpty(model.sort))
{
data = data.OrderBy(p => p.Id);
}
else
{
data = data.OrderBy(model.sort + " " + model.sidx);
}
return(data.AsQueryable());
}
public IPagedList <客戶資料> Query(QueryCompanyModel model, int DefaultPage)
{
var data = this.Query(model);
return(data.ToPagedList(model.Page ?? DefaultPage, model.PageSite ?? DefaultPage));
}
