Exemple #1
0
        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
            }));
        }
Exemple #2
0
        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
                       ));
        }
Exemple #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
            }));
        }