Beispiel #1
0
        public object queryNonPaginationJSON(string tableORview_name, ConditionString where)
        {
            var request = GetParamsRequest();

            return(queryPaginationAndFilterYourWhereJSONnonPagination(new Parame
            {
                table_name = tableORview_name,
                yourwhere = where.EXEC,
                key_where = where.EXEC_KEY,
                search_text = request.filter,
                page = 0,
                limit_page = 0
            }));
        }
Beispiel #2
0
        public Pagination <T> queryPagination <T>(string tableORview_name, ConditionString where)
        {
            var request = GetParamsRequest();

            return(queryPaginationAndFilterYourWhere <T>(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,
            }));
        }
Beispiel #3
0
        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
            }));
        }