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