Messages

1

Help for ParamQuery Grid (free version) / Re: on pqpagerchange event currPage and rPP is undefined?

« on: December 10, 2015, 11:12:12 am »

I am waiting for your reply. Please help me.

2

Help for ParamQuery Grid (free version) / Re: on pqpagerchange event currPage and rPP is undefined?

« on: December 09, 2015, 12:46:38 pm »

Thank for your reposne.

But I am new for this.

Can you please give me example for this?

3

Help for ParamQuery Grid (free version) / Re: on pqpagerchange event currPage and rPP is undefined?

« on: December 09, 2015, 12:24:24 pm »

Thanks for your quick response.

But there is a problem. initially i don't have any data for showing .

User have to input some search data and on the basis of that data, result will be show on screen in the pqgrid.

I have one submit button that perform searching on the basis of search data. After coming data from the server now i want to perform pagination.

4

Help for ParamQuery Grid (free version) / on pqpagerchange event currPage and rPP is undefined?

« on: December 09, 2015, 11:06:15 am »

In my project, I have requirement for pagination for large data. on click of next page button i want to capture next page number and also the rows Per Page value so that I fetch data from Database using this values.

Please help me!

$("#grid_array").on("pqpagerchange", function (event, ui) {
                debugger;
                var sRPP = $("#grid_array").pqGrid("option", "rPP");
                var sCurrentPage = $("#grid_array").pqGrid("option", "curPage");
                $.ajax({
                    type: "GET",
                    url: '@Url.Action("SearchTransForPage","SEARCH_Permission")',
                    data: { sPageNum: sCurrentPage, sRecordsPerPage: sRPP },
                    success: function (data) {
                        debugger;
                        var arrData = [];
                        var model = JSON.parse(data);

                        for (var i = 0; i < model.length; i++) {
                            var arrtmp = [
                                model.WALLET_TXN_ID,
                                model.TXN_DATETIME,
                                model.TXN_TYPE,
                                model.TXN_STATUS_CODE,
                                model.Amount
                             ];

                            arrData.push(arrtmp);


                        }

                        var obj = { width: 1150, height: 270,
                            title: "Merchant Transactions",
                            numberCell: { resizable: true, title: "#" },
                            editable: false,
                            flexWidth: false,
                            showBottom: false,
                            resizable: false,
                            collapsible: false,
                            columnBorders: true,
                            selectionModel: { type: null },
                            pageModel: { type: 'local', rPP: 10, rPPOptions: [1, 10, 20, 30, 40, 50, 100, 500, 1000] },
                            rowBorders: true,
                            toolbar: {
                                cls: 'pq-toolbar-export',
                                items: [{
                                    type: 'button',
                                    label: "Export to Excel",
                                    icon: 'ui-icon-document',
                                    listeners: [{
                                        "click": function (evt) {
                                            $("#grid_array").pqGrid("exportExcel",
                                    { url: '@(Url.Action("excel", "SEARCH_Permission"))', sheetName: "pqGrid sheet" });
                                        }
                                    }]
                                }]
                            }
                        };
                        obj.colModel = [
                    { title: "Txn ID", render: function (ui) {
                        return '<a href= "\\SEARCH_Permission\\SearchDetails?id=' + ui.cellData + '" style="color:blue;text-decoration: underline;" >' + ui.cellData + '</a>';
                    }, width: 100
                    },
                    { title: "Txn DateTime", width: 200 },
                    { title: "Txn Type", width: 200 },
                    { title: "Txn Status", width: 100 },
                    {title: "Amount", width: 70 }
                        ];
                        obj.dataModel = { data: arrData };
                        $("#grid_array").pqPager({ rPP: sRPP });

                        $("#grid_array").pqPager({ currentPage: sCurrentPage });
                        var $grid = $("#grid_array").pqGrid(obj);

                    }
                });

            });

5

Help for ParamQuery Grid (free version) / paramquery grid numbering start again from 1 in next or previous page request

« on: December 08, 2015, 03:41:17 pm »

I have project in which i have use paramquery grid for showing search result. But there is a problem in showing data. Whenever user search for some data and request for next page, numbering of data starts from 1 .

How can i resolve this in such manner so that numbering is going on in order.

6

Help for ParamQuery Grid (free version) / Re: How to convert a column value as link (anchor) element.

« on: December 01, 2015, 02:46:50 pm »

Thanks for your reply. I have to check this with ASP MVC4.0.

7

Help for ParamQuery Grid (free version) / How to convert a column value as link (anchor) element.

« on: December 01, 2015, 01:15:47 pm »

I have project in which i have to show less data as search result with a column which has link for the details page. Pleas help me.

I have convert data coming from server into array of arrays into java-script array object and pass data to pqgrid which showing data but cant find anyway to insert link values.

Please help me its urgent.