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