JQuery -轻量级插件Flexgrid 表格排序问题

Question

问题RT..排序问题
代码如下..
[code="javascript"]

<br> $(&quot;#flex1&quot;).flexigrid<br> (<br> {<br> url: &#39;../ProductInfoServlet?hidden=manage&#39;,<br> dataType: &#39;json&#39;,<br> colModel : [<br> {display: &#39;产品编号&#39;, name : &#39;PINO&#39;, width : 50, sortable : true, align: &#39;center&#39;, hide: false},<br> {display: &#39;产品图片&#39;, name : &#39;PIIMAGE&#39;, width : 140, sortable : true, align: &#39;center&#39;,hide: true},<br> {display: &#39;产品名称&#39;, name : &#39;PINAME&#39;, width : 100, sortable : true, align: &#39;center&#39;},<br> {display: &#39;产品类型&#39;, name : &#39;PCNAME&#39;, width : 80, sortable : true, align: &#39;center&#39;},<br> {display: &#39;产品分类&#39;, name : &#39;PICATEGROY&#39;, width : 70, sortable : true, align: &#39;center&#39;},<br> &lt;!--{display: &#39;产品特征&#39;, name : &#39;PIFEATRUES&#39;, width : 200, sortable : true, align : &#39;center&#39;,hide: true},--&gt;<br> {display: &#39;产品数量&#39;, name : &#39;PIQUANTITY&#39;, width : 50, sortable : true, align: &#39;left&#39;},<br> &lt;!--{display: &#39;产品信息&#39;, name : &#39;PIINFO&#39;, width : 200, sortable : false, align: &#39;center&#39;,hide: true},--&gt;<br> {display: &#39;产品价格&#39;, name : &#39;PIPRICES&#39;, width : 80, sortable : true, align: &#39;left&#39;},<br> {display: &#39;发布日期&#39;, name : &#39;PIDATE&#39;, width : 130, sortable : true, align: &#39;center&#39;},<br> {display: &#39;发布人&#39;, name : &#39;PIAUTHOR&#39;, width : 100, sortable : true, align: &#39;center&#39;}<br> ],<br> buttons : [<br> {name: &#39;查看&#39;, bclass: &#39;select&#39;, onpress : button},<br><br> {name: &#39;添加&#39;, bclass: &#39;add&#39;, onpress : button},<br> {name: &#39;删除&#39;, bclass: &#39;delete&#39;, onpress : button},<br> {name: &#39;修改&#39;, bclass: &#39;modify&#39;, onpress : button},<br><br> {separator: true}<br> ],<br> searchitems : [<br> {display: &#39;产品编号&#39;, name : &#39;PINO&#39;, isdefault: true},<br> {display: &#39;产品名称&#39;, name : &#39;PINAME&#39;}<br> &lt;!--{display: &#39;类别名称&#39;, name : &#39;PCNAME&#39;}--&gt;<br> ],<br> ///不能调整视窗宽度<br> nohresize: false,<br> sortname: &quot;PINO&quot;,<br> sortorder: &quot;desc&quot;,<br> usepager: true,<br> title: &#39;产品信息管理&#39;,<br> useRp: true,<br> rp: 20,<br> showTableToggleBtn: true,<br> width: 780,<br> height: 300<br> }<br> );</p> <pre><code> function button(com,grid) { if (com==&#39;删除&#39;) { ${&quot;hidden&quot;}.value=&quot;delete&quot;; if($(&#39;.trSelected&#39;,grid).length==0){ alert(&quot;请选择要删除的数据&quot;); }else{ if(confirm(&#39;是否删除这 &#39; + $(&#39;.trSelected&#39;,grid).length + &#39; 条记录吗?&#39;)) { var id =&quot;&quot;; for(var i=0;i&lt;$(&#39;.trSelected&#39;,grid).length;i++){ if(i==$(&#39;.trSelected&#39;,grid).length-1){ id += &quot;id=&quot;+$(&#39;.trSelected&#39;,grid).find(&quot;td:first&quot;).eq(i).text(); } else { id += &quot;id=&quot;+$(&#39;.trSelected&#39;,grid).find(&quot;td:first&quot;).eq(i).text()+&quot;&amp;&quot;; } } window.location.href=&quot;../ProductInfoServlet?hidden=&quot;+${&quot;hidden&quot;}.value+&quot;&amp;&quot;+id; } } } else if (com==&#39;添加&#39;) { ${&quot;hidden&quot;}.value=&quot;add&quot;; window.location.href=&quot;proInfoAdd.jsp?hidden=&quot;+${&quot;hidden&quot;}.value; } else if (com==&#39;修改&#39;) { ${&quot;hidden&quot;}.value=&quot;modify&quot;; if($(&quot;.trSelected&quot;).length==1){ window.location.href=&quot;proInfoModify.jsp?hidden=&quot;+${&quot;hidden&quot;}.value+&quot;&amp;id=&quot;+$(&#39;.trSelected&#39;,grid).find(&quot;td&quot;).eq(0).text(); }else if($(&quot;.trSelected&quot;).length&gt;1){ alert(&quot;请选择一个修改,不能同时修改多个&quot;); }else if($(&quot;.trSelected&quot;).length==0){ alert(&quot;请选择一个您要修改的产品&quot;) } } else if (com==&#39;查看&#39;){ if($(&quot;.trSelected&quot;).length==1){ window.location.href=&quot;proInfoSel.jsp?id=&quot;+$(&#39;.trSelected&#39;,grid).find(&quot;td&quot;).eq(0).text(); }else if($(&quot;.trSelected&quot;).length&gt;1){ alert(&quot;请选择一个查看,不能同时产看多个&quot;); }else if($(&quot;.trSelected&quot;).length==0){ alert(&quot;请选择一个您要查看的产品&quot;) } } } &lt;/script&gt; </code></pre> <p>[/code]<br> 我也已经把sortable : true 设置为true了.<br> 但是点击之后并没有排序.<br> 是不是需要写什么事件?<br> display: &#39;产品编号&#39;, name : &#39;PINO&#39;, width : 50, sortable : true, align: &#39;center&#39;, hide: false},<br> 每个字段的代码如上.<br> 感觉应该把&#39;PINO&#39;通过什么传到后台. 手动构建SQL语句. 但又感觉不对. 怎么判断是这次点击是desc下次点击又是asc呢.<br> [img]<a href="http://darrick.iteye.com/upload/picture/pic/39174/45fa7484-5470-3c94-ae02-9b99c3ab7ddb.jpg%5B/img%5D">http://darrick.iteye.com/upload/picture/pic/39174/45fa7484-5470-3c94-ae02-9b99c3ab7ddb.jpg[/img]</a><br> 这个排序是我手动构造的order by pino desc排序.<br> but..<br> [img]<a href="http://darrick.iteye.com/upload/picture/pic/39176/60e6dec3-db70-36dd-9e31-af262088b359.jpg%5B/img%5D">http://darrick.iteye.com/upload/picture/pic/39176/60e6dec3-db70-36dd-9e31-af262088b359.jpg[/img]</a><br> 点击产品名称后 并没有根据产品名称的首字母进行排序.<br> 鄙人冒昧的上来问一下各位. 有能提供解决方案的吗?<br> 十分感谢了</p>

Answer 1

在后台用getRequest().getParameter("sortorder")和getRequest().getParameter("sortname")就能拿到相关信息了