直接上代码,点查询为什么提交不了外部查询条件,<script type="text/javascript">
$(function(){
$("#datatable").flexigrid({
url: 'voucher/loadCheckUserList.action',
dataType: 'json',
colModel : [
{display: 'ID', name : 'ID', width : 130, sortable : true, align: 'left', hide: true},
{display: '排序', name : 'INTORDER', width : 40, sortable : true, align: 'left'},
{display: '姓名', name : 'NAME', width : 80, sortable : true, align: 'center'},
{display: '核算岗位', name : 'TACHENAME', width : 150, sortable : true, align: 'left'},
{display: '小组名称', name : 'TEAMNAME', width : 180, sortable : true, align: 'left'},
{display: '是否绩效考核', name : 'ISDELETE', width : 60, sortable : true, align: 'right'},
{display: '核算部', name : 'ISZJJB', width : 100, sortable : true, align: 'right'}
],
buttons : [
{name: '修改', bclass: 'modify', onpress : editRecord},
{separator: true}
],
/*
searchitems : [
{display: '排序', name : 'INTORDER'},
{display: '姓名', name : 'NAME', isdefault: true}
],
*/
method:'POST',
sortname: "INTORDER",
sortorder: "asc",
usepager: true,
autoload: false,//自动加载
//title: 'Countries',
useRp: true,
rp: 30,
//showTableToggleBtn: true,
width: 900,
height: 500
});
$(".page-toolbar-header .filter").toggle(function(){
$(".page-filter-center").slideUp();
}, function(){
$(".page-filter-center").slideDown();
});
$("#search").click(function(e){
var yearmonth = $("#selectyear").val()+""+$("#selectmonth").val();
var usertype = $.trim($("#usertype").val());
if( yearmonth == null || yearmonth == "" ){
jAlert("请选择年月!");
return;
}
//?yearmonth='+yearmonth+'&usertype='+usertype
var option = {newp : 1, extParam : [{ name: "yearmonth", value: yearmonth+'' },
{ name: "usertype", value: usertype+'' }]};
$("#datatable").flexOptions(option).flexReload();
});
});
</script>
<div class="page-container">
<div class="page-toolbar-container">
<div class="page-filter-center">
<label>月份:</label>
<select id='selectyear'>
<option value="2010">2010</option>
<option value="2011" selected>2011</option>
</select>
<label>年</label>
<select id='selectmonth'>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09" selected>9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<label>月</label>
<label>人员类型:</label>
<select id='usertype'>
<option value="fill">核算会计</option>
<option value="check">复核会计</option>
<option value="cash">资金会计</option>
</select>
<button id="search" class="xybutton">确定</button>
<button id="clear" class="xybutton">重置</button>
</div>
</div>
<table id = "datatable">
</table>
</div>
$(function(){
$("#datatable").flexigrid({
url: 'voucher/loadCheckUserList.action',
dataType: 'json',
colModel : [
{display: 'ID', name : 'ID', width : 130, sortable : true, align: 'left', hide: true},
{display: '排序', name : 'INTORDER', width : 40, sortable : true, align: 'left'},
{display: '姓名', name : 'NAME', width : 80, sortable : true, align: 'center'},
{display: '核算岗位', name : 'TACHENAME', width : 150, sortable : true, align: 'left'},
{display: '小组名称', name : 'TEAMNAME', width : 180, sortable : true, align: 'left'},
{display: '是否绩效考核', name : 'ISDELETE', width : 60, sortable : true, align: 'right'},
{display: '核算部', name : 'ISZJJB', width : 100, sortable : true, align: 'right'}
],
buttons : [
{name: '修改', bclass: 'modify', onpress : editRecord},
{separator: true}
],
/*
searchitems : [
{display: '排序', name : 'INTORDER'},
{display: '姓名', name : 'NAME', isdefault: true}
],
*/
method:'POST',
sortname: "INTORDER",
sortorder: "asc",
usepager: true,
autoload: false,//自动加载
//title: 'Countries',
useRp: true,
rp: 30,
//showTableToggleBtn: true,
width: 900,
height: 500
});
$(".page-toolbar-header .filter").toggle(function(){
$(".page-filter-center").slideUp();
}, function(){
$(".page-filter-center").slideDown();
});
$("#search").click(function(e){
var yearmonth = $("#selectyear").val()+""+$("#selectmonth").val();
var usertype = $.trim($("#usertype").val());
if( yearmonth == null || yearmonth == "" ){
jAlert("请选择年月!");
return;
}
//?yearmonth='+yearmonth+'&usertype='+usertype
var option = {newp : 1, extParam : [{ name: "yearmonth", value: yearmonth+'' },
{ name: "usertype", value: usertype+'' }]};
$("#datatable").flexOptions(option).flexReload();
});
});
</script>
<div class="page-container">
<div class="page-toolbar-container">
<div class="page-filter-center">
<label>月份:</label>
<select id='selectyear'>
<option value="2010">2010</option>
<option value="2011" selected>2011</option>
</select>
<label>年</label>
<select id='selectmonth'>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09" selected>9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<label>月</label>
<label>人员类型:</label>
<select id='usertype'>
<option value="fill">核算会计</option>
<option value="check">复核会计</option>
<option value="cash">资金会计</option>
</select>
<button id="search" class="xybutton">确定</button>
<button id="clear" class="xybutton">重置</button>
</div>
</div>
<table id = "datatable">
</table>
</div>
解决方案 »
- js 键盘事件
- 问下js里面的if语句写法??
- 网页UTF-8 GB2312编码 判断 ?
- 跪求高手指点页面导航的问题
- 浮动广告的问题!~ 紧急求救·!`
- 不用表单,如何定时刷新本页面,并调用脚本文件?
- 晕死,急:document.form1.mobile_model.insertAdjacentHTML("beforeEnd","<option value=xx"+models[j]+">"+models[j]+"</option>");
- 有谁知道csdn在线短消息发送的原理吗??
- 关于a标签切换
- MyPopup,一个JavaScript(js)弹出层、弹窗、对话框组件
- 关于AJAX的发音- -
- 坐标点有了,弹出框也有了,就差最后地图显示了!!
{ name: "usertype", value: usertype+'' }]};
$("#datatable").flexOptions(option).flexReload(); 这个有问题哦
option={
url: 'voucher/loadCheckUserList.action',
dataType: 'json',
colModel : [
{display: 'ID', name : 'ID', width : 130, sortable : true, align: 'left', hide: true},
{display: '排序', name : 'INTORDER', width : 40, sortable : true, align: 'left'},
{display: '姓名', name : 'NAME', width : 80, sortable : true, align: 'center'},
{display: '核算岗位', name : 'TACHENAME', width : 150, sortable : true, align: 'left'},
{display: '小组名称', name : 'TEAMNAME', width : 180, sortable : true, align: 'left'},
{display: '是否绩效考核', name : 'ISDELETE', width : 60, sortable : true, align: 'right'},
{display: '核算部', name : 'ISZJJB', width : 100, sortable : true, align: 'right'}
],
buttons : [
{name: '修改', bclass: 'modify', onpress : editRecord},
{separator: true}
],
/*
searchitems : [
{display: '排序', name : 'INTORDER'},
{display: '姓名', name : 'NAME', isdefault: true}
],
*/
method:'POST',
sortname: "INTORDER",
sortorder: "asc",
usepager: true,
autoload: false,//自动加载
//title: 'Countries',
useRp: true,
rp: 30,
//showTableToggleBtn: true,
width: 900,
height: 500
}
$("#datatable").flexOptions(option).flexReload();
想传日期的话在url里加吧 url: 'voucher/loadCheckUserList.action?date='+日期,
你只要触发事件,他就会给你这些信息;把内容在后台搞定,组合成json传回来就行了;你后台获取下他的from内容;他一共在from里存了六个可获取参数;
参数如下:
Request["page"]; //当前显示页数
Request["rp"]; //每页显示长度
Request["sortname"]; //排序的字段name
Request["sortorder"]; //排序方式 'asc'
Request["query"];,//搜索查询的条件
Request["qtype"];//搜索查询的类别
这里面的option是option={
url: 'voucher/loadCheckUserList.action',
dataType: 'json',
colModel : [
{display: 'ID', name : 'ID', width : 130, sortable : true, align: 'left', hide: true},
{display: '排序', name : 'INTORDER', width : 40, sortable : true, align: 'left'},
{display: '姓名', name : 'NAME', width : 80, sortable : true, align: 'center'},
{display: '核算岗位', name : 'TACHENAME', width : 150, sortable : true, align: 'left'},
{display: '小组名称', name : 'TEAMNAME', width : 180, sortable : true, align: 'left'},
{display: '是否绩效考核', name : 'ISDELETE', width : 60, sortable : true, align: 'right'},
{display: '核算部', name : 'ISZJJB', width : 100, sortable : true, align: 'right'}
],
buttons : [
{name: '修改', bclass: 'modify', onpress : editRecord},
{separator: true}
],
/*
searchitems : [
{display: '排序', name : 'INTORDER'},
{display: '姓名', name : 'NAME', isdefault: true}
],
*/
method:'POST',
sortname: "INTORDER",
sortorder: "asc",
usepager: true,
autoload: false,//自动加载
//title: 'Countries',
useRp: true,
rp: 30,
//showTableToggleBtn: true,
width: 900,
height: 500
}
而不能是
var option = {newp : 1, extParam : [{ name: "yearmonth", value: yearmonth+'' },
{ name: "usertype", value: usertype+'' }]};
想传日期的话在url里加吧 url: 'voucher/loadCheckUserList.action?date='+日期
后台获得日期:Request["date"];
$("#search").click(function(e){
var yearmonth = $("#selectyear").val()+""+$("#selectmonth").val();
var usertype = $.trim($("#usertype").val());
if( yearmonth == null || yearmonth == "" ){
jAlert("请选择年月!");
return;
}
option.url = 'voucher/loadCheckUserList.action?yearmonth='+yearmonth+'&usertype='+usertype;
option.newp = 1;
/* option.extParam = [{ name: "yearmonth", value: yearmonth+'' },
{ name: "usertype", value: usertype+'' }]; */
$("#datatable").flexigrid(option);
$("#datatable").flexOptions(option).flexReload();
});多谢,在各位大幅我之前已经弄好了。我这样实现的。