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