public PaginationJSON queryPaginationJSON(string tableORview_name, ConditionString where)
{
var request = GetParamsRequest();
return(queryPaginationAndFilterYourWhereJSON(new Parame
{
table_name = tableORview_name,
yourwhere = where.EXEC,
key_where = where.EXEC_KEY,
search_text = request.filter,
page = request.startRow,
limit_page = request.limitRow
}));
}
public object queryNonPaginationJSON(string tableORview_name, ConditionString where)
{
var request = GetParamsRequest();
return(JsonConvert.DeserializeObject(
queryPaginationYourWereJSON(new Parame
{
table_name = tableORview_name,
yourwhere = where.EXEC,
key_where = where.EXEC_KEY,
search_text = request.filter,
page = 0,
limit_page = 0
}).Item
));
}
public PaginationJSON queryPaginationJSON(string tableORview_name, ConditionString where, string sortByColumn, string sort_type)
{
checkSort_type(sort_type);
var request = GetParamsRequest();
return(queryPaginationAndFilterYourWhereJSON(new Parame
{
table_name = tableORview_name,
yourwhere = where.EXEC,
key_where = where.EXEC_KEY,
search_text = request.filter,
page = request.startRow,
limit_page = request.limitRow,
sortby = sortByColumn,
sort_type = sort_type
}));
}