jQuery表格插件ParamQuery简单使用方法示例

jQuery表格插件ParamQuery简单使用方法示例

  实现步骤:

  先在html的head中加入对jQuery和jQuery UI的引用:

  

复制代码 代码如下:

  <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/themes/base/jquery-ui.css" />

  <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>       <!--用了CDN链接(自适应http, https的切换),所以src的开头直接用了"//"-->

  <script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js"></script>  <!--同上-->

  再加入对Param Query Grid的引用:

  

复制代码 代码如下:

  <link rel="stylesheet" href="/Content/pqgrid/pqgrid.min.css" />           <!--这个css文件必须引用,无论你是用了皮肤,还是没有用到皮肤,都要引用-->

  <script type="text/javascript" src="/Scripts/pqgrid.min.js" ></script>    <!--这个js文件必须引用-->

  增加脚本代码:

  

复制代码 代码如下:

  $(function () {

  var data = [    [1, 'Exxon Mobil', '339,938.0', '36,130.0'],

  [2, 'Wal-Mart Stores', '315,654.0', '11,231.0'],

  [3, 'Royal Dutch Shell', '306,731.0', '25,311.0'],

  [4, 'BP', '267,600.0', '22,341.0'],

  [5, 'General Motors', '192,604.0', '-10,567.0'],

  [6, 'Chevron', '189,481.0', '14,099.0'],

  [7, 'DaimlerChrysler', '186,106.3', '3,536.3'],

  [8, 'Toyota Motor', '185,805.0', '12,119.6'],

  [9, 'Ford Motor', '177,210.0', '2,024.0'],

  [10, 'ConocoPhillips', '166,683.0', '13,529.0'],

  [11, 'General Electric', '157,153.0', '16,353.0'],

  [12, 'Total', '152,360.7', '15,250.0'],

  [13, 'ING Group', '138,235.3', '8,958.9'],

  [14, 'Citigroup', '131,045.0', '24,589.0'],

  [15, 'AXA', '129,839.2', '5,186.5'],

  [16, 'Allianz', '121,406.0', '5,442.4'],

  [17, 'Volkswagen', '118,376.6', '1,391.7'],

  [18, 'Fortis', '112,351.4', '4,896.3'],

  [19, 'Crédit Agricole', '110,764.6', '7,434.3'],

  [20, 'American Intl. Group', '108,905.0', '10,477.0']

  ];

  var obj = {};

  obj.width = 700;

  obj.height = 400;

  obj.colModel = [{ title: "Rank", width: 100, dataType: "integer" },

  { title: "Company", width: 200, dataType: "string" },

  { title: "Revenues ($ millions)", width: 150, dataType: "float", align: "right" },

  { title: "Profits ($ millions)", width: 150, dataType: "float", align: "right" }];

  obj.dataModel = { data: data };

  $("#grid_array").pqGrid(obj);

  });

  最后,在要显示的地方加入div元素,用来显示表格:

  

复制代码 代码如下:

  <div id="grid_array"></div>

  运行就能看到效果

  加入Theme皮肤的Demo

jQuery表格插件ParamQuery简单使用方法示例

  实现步骤:

  js代码逻辑部分没有任何变动,哈哈。

  html的head部分增加那么一句style引用,就搞定了,如下:

  

复制代码 代码如下:

  <link rel="stylesheet" href="/Content/pqgrid/pqgrid.min.css" />               <!- 这句就是增加的,其他没有任何变动...哈哈 ->

  <link rel="stylesheet" href="/Content/pqgrid/themes/peach/pq-grid.css" />

  <script type="text/javascript" src="/Scripts/pqgrid.min.js" ></script>