public PartialViewResult boxCards(string key = "", string anotherkey = "", string cardgroups = "", string customergroup = "", string fromdate = "", string todate = "", int page = 1) { var pageSize = 20; int total = 0; var customergroups = GetListChild("", customergroup); //var list = _tblCardService.GetAllPagingByFirst(key, anotherkey, cardgroups, customergroups, fromdate, todate, page, pageSize); //var gridModel = PageModelCustom<tblCardExtend>.GetPage(list, page, pageSize); var list = _tblCardService.GetAllPagingByFirst_SQL(key, anotherkey, cardgroups, customergroups, fromdate, todate, ref total, page, pageSize); var gridModel = PageModelCustom <tblCardExtend> .GetPage(list, page, pageSize, total); return(PartialView(gridModel)); }