public GridPager <AppInstanceToken> GetPager(GridPagerPamater <AppInstanceTokenSearchPamater> searchParam)
{
var r = AppInstanceTokenDal.GetGridPager(searchParam); return(r);
}
public GridPager <CodeTemplate> GetPager(GridPagerPamater <CodeTemplateSearchPamater> searchParam)
{
var r = CodeTemplateDal.GetGridPager(searchParam); return(r);
}
internal static GridPager <AppInstanceToken> GetGridPager(GridPagerPamater <AppInstanceTokenSearchPamater> pamater)
{
string sql = "select SQL_CALC_FOUND_ROWS * from AppInstanceToken " + pamater.SearchPamater.CreateWhereSql() + " limit @Start,*@PageSize;select FOUND_ROWS();";
pamater.SearchPamater.Start = (pamater.Current - 1) * pamater.PageSize;
pamater.SearchPamater.PageSize = pamater.PageSize;
return(GetGridPager <AppInstanceToken>(con, sql, pamater.PageSize, pamater.Current, pamater.SearchPamater));
}