Messages

1

Help for ParamQuery Pro / Re: How avoid scientific notation when Excel export

« on: January 20, 2021, 07:49:24 am »

The actual value is 34300E7 which is string, how can I avoid scientific notation when Excel export

2

Help for ParamQuery Pro / Re: How avoid scientific notation when Excel export

« on: January 20, 2021, 06:19:21 am »

Could you show me some examples?

3

Help for ParamQuery Pro / How avoid scientific notation when Excel export

« on: January 18, 2021, 01:32:48 pm »

How avoid scientific notation when Excel export

4

Help for ParamQuery Pro / Re: Avoid default requests

« on: November 30, 2020, 07:22:01 am »

I need  use 'remote' mode , but I don't want to trigger  it immediately when grid open.

5

Help for ParamQuery Pro / Avoid default requests

« on: November 27, 2020, 06:43:33 am »

Hi
  How can I avoid default request after grid rendering? I want to request remote data manually.

6

Help for ParamQuery Pro / how to add new row with child grid

« on: October 14, 2020, 01:53:56 pm »

Hi, I have a nested detail grid that can display the main grid data and the child grid data, but I will not add a new row with the child grid data,initialize the child grid data。

My data are as follows
"groupDtls" is the child grid data

Code: [Select]

{
"uuid": "8bd15218481c48fc895410a2eb7ef4b0",
"dipCgoGrpUuid": null,
"cgoGrpCnnme": null,
"isLimChanged": 0,
"groupDtls": [
{
"recVer": 5,
"svcLoopAbbrv": "IC2",
"dirBound": "S",
"polCde": "PJN",
},{
"recVer": 5,
"svcLoopAbbrv": "IC9",
"dirBound": "N",
"polCde": "NAS",
},

]
}

7

Bug Report / getHtDetail throw -150

« on: June 29, 2020, 01:38:36 pm »

 An error was thrown when I used the detailmodel
 There is no problem opening the current page and clicking details. But when I switch to another page, and then switch back, there will be an error whit throw -150 , the code is as follows

var option = {
        width: '100%',
       height:$(window).height()-190,
        dataModel: dataModel,
        pageModel: pageModel,
        sortModel: sortModel,
        colModel: colModel,
        trackModel: {on: true},
        fillHandle: "",
        scrollModel: { autoFit: false },
        autoRowHead: false,
        showTop: false,
        wrap: false,
        freezeCols: 4,
        flexHeight: false,
        numberCell: { show: false },
        virtualX: false,
        virtualY: false,
        searchFormId: "#searchForm",
        selectionModel: {type: 'cell', toggle: true, mode: "range"},
        sorter: [ { dataIndx: 'recUpdDt', dir: "down" }],
        detailModel: {
           collapseIcon: "ui-icon-plus",
           expandIcon: "ui-icon-minus",
           //height: 200,
           init: function (ui) {
            var rowData = ui.rowData;
               var rowIndx = rowData.pq_ri;
               var detailobj = gridDetailModel( $(this).pqGrid('instance'), rowData.dipProductPriceLimDtls, rowIndx); //get a copy of gridDetailModel                       
               var $grid = $("<div></div>").pqGrid( detailobj );//init the detail grid.
               return $grid;
           }
      },
      cellClick: function (event, ui) {
         currPriceTableRowData = JSON.parse(JSON.stringify(ui.rowData))
        },
      editorEnd:priceTableEditorEnd
    };

function gridDetailModel( gridMain, rowData, parentRowIndex){
   return {
        colModel: [
             ***
       ],
       width: '80%',
        height: 190,
        freezeCols: 2,
        autoRowHead: false,
       scrollModel: { autoFit: true },
        numberCell: { show: false },
        trackModel: {on: true},
        selectionModel: {type: 'cell', toggle: true, mode: "single"},
        dataModel: {data: rowData, recIndx: "dipProductPriceLimDtlUuid"},
        virtualX: false,
       virtualY: true
      
    };
}

What should I do to solve this problem，thinks.

8

Bug Report / Re: Data disappear after using 7.2

« on: April 27, 2020, 06:45:08 am »

Noted ,Thanks your support

9

Bug Report / Re: Data disappear after using 7.2

« on: April 22, 2020, 08:10:35 am »

It reproduces too

1. sex select 'Condition:equal female' , left 2 records.
2. college select 'Condition:equal ',then lost focus (not click 'OK') , click select all.All data disappear

10

Bug Report / Data disappear after using 7.2

« on: April 21, 2020, 01:00:36 pm »

Hi

We use the version 7.2 and meet this,please see the pictures  in attachment , here is the steps：

1.Do fillter in one column.
2.Open another filter window,then close.
3.Check sellct all. All data gone.


Here is the table options:

   var colM = [ {
      align : "center",
      cb : {
         header : true,
         select : true,
         all : true
      },
      dataIndx : '',
      type : 'checkbox',
      dataType : 'bool',
      editor : false,
      sortable : false,
      menuIcon : false,
   }, {
      dataIndx : 'cnNme',
      title : 'name',
      editor : {
         type : "textbox",
      },
      width : 100,
   }, {
      dataIndx : 'collegeNme',
      title : 'college',
      editor : {
         type : "textbox",
         init : colCollegeEditor
      },
      width : 200,
   }, {
      dataIndx : 'sexNme',
      title : 'sex',
      editor : {
         type : "textbox",
         init : colSexEditor
      },
      width : 100,
   }, {
      dataIndx : 'birth',
      title : 'birth',
      editor : {
         type : "textbox",
         init : dts.pqGrid.dateEditor
      },
      width : 200,
   }, {
      dataIndx : 'countryCde',
      title : 'country',
      editor : {
         type : "textbox",
         init : colCountryEditor
      },
      width : 100,
   }, {
      dataIndx : 'cityNme',
      title : 'city',
      editor : {
         type : "textbox",
         init : colCityEditor
      },
      width : 150,
   }, {
      dataIndx : 'marry',
      title : 'marry',
      align : "center",
      type : 'checkbox',
      dataType : 'bool',
      editor : false,
      width : 100,
   } ];

   
   var option = {
      dataModel : {
         location : "local", // local / remote
         recIndx : "uuid" // UUID
      },
      sortModel : {
         type : 'local', // local / remote
         single : true,
         multiKey : 'shiftKey'
      
      },
      colModel : colM,
      showTop : false,
      numberCell : {
         show : false
      
      },
      fillHandle : "",
      selectionModel : {
         type : 'cell',
         mode : "single"
      },
      editModel : {
         saveKey : $.ui.keyCode.ENTER,
         keyUpDown : false,
         clicksToEdit : 1
      },
      trackModel : {
         on : true
      },
      menuIcon : true,
      groupModel : {
         checkbox : true,
      }
   };

        var tableDate = [ {
      uuid : '1111',
      cnNme : 'YYY',
      collegeUuid : 'collegeuuid0001',
      collegeNme : 'college1',
      sexCde : 'M',
      sexNme : 'male',
      birth : '2000-01-01 01:00:00',
      countryCde : 'CN',
      countryUuid : 'countryUuid001',
      cityNme : 'Shanghai',
      cityUuid : 'cityUuid001',
      marry : true
   }, {
        uuid : '2222',
        cnNme : 'XXX',
        collegeUuid : 'collegeuuid0002',
        collegeNme : 'college2',
        sexCde : 'F',
        sexNme : 'female',
        birth : '2010-01-01 01:00:00',
        countryCde : 'CN',
        countryUuid : 'countryUuid001',
        cityNme : 'Dalian',
        cityUuid : 'cityUuid002',
        marry : false
    } , {
        uuid : '2222',
        cnNme : 'XXX',
        collegeUuid : 'collegeuuid0002',
        collegeNme : 'college3',
        sexCde : 'F',
        sexNme : 'female',
        birth : '2010-01-01 01:00:00',
        countryCde : 'CN',
        countryUuid : 'countryUuid001',
        cityNme : 'Dalian',
        cityUuid : 'cityUuid0044',
        marry : false
    } ]

11

Help for ParamQuery Pro / Where can I find ver 7.2 download link

« on: April 20, 2020, 02:21:14 pm »

In pro downloads,The newest version is 7.1