public IActionResult List(int page = 1, int pageSize = 10, string BusinessName = "")
{
string table = $@"select b.Id,b.Sort,b.StoreCount, b.Tel,b.BusinessName,b.Memo,b.issystemBusiness,
CONVERT(varchar(100), b.DueTime, 23) DueTime,b.Contact from TBusiness b";
if (_AbpSession.TenantId != null)
{
table += $" where TenantId={_AbpSession.TenantId}";
}
if (!string.IsNullOrEmpty(BusinessName))
{
table += $" and b.BusinessName like '%{BusinessName}%'";
}
int total;
DataSet ds = _commonAppService.GetPage(page, pageSize, table, "sort desc, id desc", out total);
IPagedList pageList = new PagedList <DataRow>(ds.Tables[0].Select(), page, pageSize, total);
if (Request.Headers.ContainsKey("x-requested-with"))
{
return(View("_Table", pageList));
}
return(View(pageList));
}