public string JsonDataForEasyUIdataGridFoorter(int pageindex, int pagesize, string filterJson, string sort = "FID", string order = "asc") { string sortorder = sort + " " + order; var pcp = new ProcCustomPage(GetTableName()) { IDX_PAGE_IN = pageindex, CURR_PAGE_COUNT_IN = pagesize, SQL_ORDERBY_IN = sortorder.Trim(), SQL_WHERE_IN = string.Format("({0})", filterJson.IsNullOrEmpty() ? " 1=1 " : filterJson), }; // LogHelper.WriteLog("where: "+pcp.SQL_WHERE_IN); int recordCount; //DataTable dt = GetPageWithSp(pcp, out recordCount); IEnumerable <T> list = GetList <T>(GetPageWithSp(pcp, out recordCount)); return(JSONhelper.FormatJSONForEasyuiDataGridFooter(recordCount, list, GetEasyuiDatagridFooter(list))); }