public virtual DataTable GetPageWithSp(ProcCustomPage pcp, out int recordCount)
{
if (pcp.SQL_ORDERBY_IN != null)
{
pcp.SQL_ORDERBY_IN = pcp.SQL_ORDERBY_IN.Trim();
}
return(DbUtils.GetPageWithSp(pcp, out recordCount));
}
public virtual DataTable GetDatatForPage(string tablename, int pageindex, int pagesize, string where, string orderby = "")
{
var pcp = new ProcCustomPage(tablename)
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = orderby,
SQL_WHERE_IN = where
};
int recordCount;
DataTable dt = GetPageWithSp(pcp, out recordCount);
return(dt);
}
public IEnumerable <T> GetPageWtihRecordCount(int page, int pageSize, out int recordCount, string filterJson = null, string sort = "FID", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage(GetTableName())
{
IDX_PAGE_IN = page,
CURR_PAGE_COUNT_IN = pageSize,
SQL_ORDERBY_IN = sortorder.Trim(),
SQL_WHERE_IN = string.Format("({0})", filterJson.IsNullOrEmpty() ? " 1=1 " : filterJson),
};
IEnumerable <T> list = GetList <T>(GetPageWithSp(pcp, out recordCount));
return(list);
}
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)));
}
public string JsonDataForEasyUIdataGrid(string where, string tablename, int pageindex, int pagesize, string filterJson, string sort = "FID", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage(tablename)
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = sortorder.Trim(),
SQL_WHERE_IN = where
};
// 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.FormatJSONForEasyuiDataGrid(recordCount, list));
}
