Messages

1

Help for ParamQuery Pro / commercial use question

« on: February 25, 2020, 09:35:50 pm »

Dear paramvir,

sorry for the question, but I have not found an answer in the faq.
Can I use the pro version for more than one application? How can I prove to the customer that I have a license to use Paramquery pro?
thank you

2

Help for ParamQuery Pro / Re: Save sortingDir and Data on roDblclick.

« on: January 24, 2020, 10:09:33 pm »

Ok, thank you parmavir. but now there is another question: how do I load the grid with parameters saved in the qeurystring?
I tried:

 

Code: [Select]

  obj.dataModel = {

                    beforeSend: function () {
                        $(".loadingDiv").show();
                    },
                    complete: function () {
                        $(".loadingDiv").hide();
                    },
                    error: function () {
                        this.rollback();
                    },
                    data: data_grid_anagrafica,
                    location: "local",
                    sorting: "local",
                    space: true,
                    multiKey: null
                };
var sortingDir = *querystring direction variable*;
var sotringData = *querysring dataIndx variable*
obj.dataModel.sortIndx = sortingDir;
obj.dataModel.sortDir = sotringData;
obj.dataModel.data = data_grid;
 $grid = $("div#grid").pqGrid(obj);

but doesn't work for me. Any Idea? thanks.

3

Help for ParamQuery Pro / Save sortingDir and Data on roDblclick.

« on: January 17, 2020, 03:00:31 pm »

Hi paramvir,
how can i save the sorting data and sorting dir in navigate url?

for expample:

Code: [Select]

rowDblClick: function (evt, ui) {
    var id_user = ui.rowData.id_user;
    var user_name = ui.rowData.user_name;
    var navigateUrl = "newpage.aspx?id_user=" + id_user + "&username=" + user_name + "&rowIndex=" + ui.rowIndx + "&sortingdata=" + * SORTING COLUMN NAME * + "&sortingdir=" + *SORTING DIR* +";
window.open(navigateUrl, 'new window', 600, 600);

};

thank you so much for your patience

4

Help for ParamQuery Pro / what is the correct way to refresh grid by an external button?

« on: December 12, 2019, 06:50:36 pm »

Dear paramvir,
 
I'm still here with my ignorance.

I tried to make a button in a page that only refreshes the grid, but it doesn't work.

I simpy did:

 

Code: [Select]


 <div id="grid" style="margin: 0px auto;"></div>

 <button id="btn_refresh_grid" type="button" > Refresh</button>


<script>
          $( "#btn_refresh_grid" ).click(function() {
               var grid = $('div#grid').pqGrid("getInstance").grid;
               grid.refreshDataAndView();
             
           });
</script>




5

Help for ParamQuery Pro / How to correct way to delete multiple selected rows?

« on: November 04, 2019, 03:39:20 pm »

Hi, i've to delete multiple selected rows.
i tried to make some code but doesn't work properly.
(it doesn't delete all lines, but only the first)

Code: [Select]

var grid = $('#grid_prodotti').pqGrid("getInstance").grid;
var sel = grid.SelectRow().getSelection();
var rIndex;

for (i= 0; i < sel.length; i++) {
  rIndex = sel[i]['rowIndx'];
  grid.deleteRow({ rowIndx: rIndex  })
}


how is the correct way to delete multiple row?
thank you

6

Help for ParamQuery Pro / Re: how to call webmethod with custom grid button?

« on: October 09, 2019, 01:09:40 pm »

I've tried, but still doesn't work.
where is i wrong?

Code: [Select]


 {
                        title: "Assign", dataType: "string", align: "center", dataIndx: "assigned", maxWidth: 50, render: function (ui) {
                            var rowData = ui.rowData,
                                dataIndx = ui.dataIndx;


                            rowData.pq_cellcls = rowData.pq_cellcls || {};
                            if (rowData.state == "waiting" & rowData.assigned== "no") {

                                return "<button type='button'  class='btn btn-sm btn-light btn_assegna_direct'  ><i class='fas fa-plus'></i> </button>";

                            } else {
                                return "<button type='button'  class='btn btn-sm btn-secondary disabled'> <i class='fas fa-check'></i> </button>";
                            }
                        },
                        postRender: function (ui) {
                            var rowIndx = ui.rowIndx,
                                grid = this,
                                $cell = grid.getCell(ui);

                            $cell.find(".btn_assegna_direct").on("click", function () {
                             
                                 assignProduct(rowIndx, grid);
                            });

                        },
                                       
                         

         

                    }
],

 



7

Help for ParamQuery Pro / how to call webmethod with custom grid button?

« on: October 03, 2019, 04:19:54 pm »

Hi dear support,
i'm still here.

I need to now how to make a function for calling ajax on button row click.
I had rendered a button in grid, but I can't call a function.

Code: [Select]


                     {
                         title: "Assegna", dataType: "string", align: "center", dataIndx: "assegna", maxWidth: 50, render: function (ui) {
                             var rowData = ui.rowData,
                                 dataIndx = ui.dataIndx;

                             rowData.pq_cellcls = rowData.pq_cellcls || {};
                             if (rowData.stato == "In Attesa" & rowData.assegna == "Assegnare Si") {

                               
                                 return "<a title='Click for assign to user' onClick='assignFunction();' class='btn btn-sm btn-light btn_assegna_direct'  ><i class='fas fa-plus'></i> </a>";
                                 function assignFunction() {
                                     $.ajax({
                                         contentType: "application/json; charset=utf-8",
                                         data: '{"id_product" : "' + rowData.id_product+ '", "id_user" : "' + rowData.id_user+ '"}',
                                         dataType: "json",
                                         type: "POST",
                                         url: "page.aspx/AssignProduct",                             
                                         async: false,
                                         success: function (result) {
                                             msg += 'Product assigned';
                                         },
                                         error: function (result) { }
                                     });
                                     alert(msg);
                                 }

                             } else {
                                 return "<a title='Impossible to assign'  class='btn btn-sm btn-secondary disabled'> <i class='fas fa-check'></i> </a>";
                             }
                         }
                         
                         
                     },



8

Help for ParamQuery Pro / Grid Rows count

« on: September 26, 2019, 03:35:27 pm »

Dear support,
I have read the API's page, but I didn't understand.
How can i get gridview row count?
I have tried the below code but it give insufficient result.

Code: [Select]

    var data = $("div#grid").pqGrid('option', 'dataModel.data').length;
               
             $("#label").val(toString(data_no))
The result is NaN.
Thank you.

9

ParamQuery Pro Evaluation Support / Evaluation license?

« on: July 07, 2019, 07:54:00 pm »

Dear support service,
I've paid for "Enterprise" version of paramquery , but i've recived a mail with a Evaluation license copy's download link.
Where i can find Pro license? My PayPal mail Is [email protected].
Thankyou.