jQuery动态显示和隐藏datagrid中的某一列的方法

2020-05-17 06:19:14易采站长站整理


$(function(){
$(‘#tt’).datagrid({
title:’报表统计’,
width:1020,
height:400,
url:”,
fitColumns:true,
loadMsg:’正在获取,请稍侯…’,
singleSelect:true,
nowrap:false,
columns:[[
{field:’REGION_NAME’,title:’分公司’,width:30,align:’center’},
{field:’COUNTY_NAME’,title:’区县’,width:80,align:’center’,editor:’text’},
{field:’AREA_NAME’,title:’网格’,width:80,align:’center’,editor:’text’},
{field:’ORG_NAME’,title:’网点’,width:80,align:’center’},
{field:’TOTAL_NUM’,title:’总业务量’,width:40,align:’center’},
{field:’DH_NUM’,title:’单宽业务量’,width:40,align:’center’},
{field:’RH_NUM’,title:’融合业务量’,width:40,align:’center’},
{field:’YYT_NUM’,title:’营业厅业务量’,width:40,align:’center’},
{field:’QT_NUM’,title:’其他业务量’,width:40,align:’center’}
]],
toolbar:[
],
onDblClickRow: function() {
//selected = $(‘#tt’).datagrid(‘getSelected’);
//var index = $(‘#tt’).datagrid(‘getRowIndex’, selected);
//$(‘#tt’).datagrid(‘beginEdit’, index);
//progress();
//taskPreempte(selected.taskId);
}
});
$(‘#my_toolbar’).appendTo(‘.datagrid-toolbar’);
var dd = new Date();
var d1 = dd.getFullYear()+ “-” + (dd.getMonth()+1) + “-1” ;
var d2 = dd.getFullYear() + “-” + (dd.getMonth()+1) + “-” + dd.getDate() ;
$(‘#qryStartDate’).datebox(‘setValue’, d1); // set datebox value
$(‘#qryEndDate’).datebox(‘setValue’, d2); // set datebox value
refreshRpt2();
});
function refreshRpt2(){
var strStatCond = “b.region_name”;
if($(‘#qryCon’).attr(“value”)!=100){
param.sts = $(‘#qryCon’).attr(“value”);
alert(param.sts);
}
param.qryBeginTime =$(‘#qryStartDate’).datebox(‘getValue’);
//alert(param.qryBeginTime);
param.qryEndTime = $(‘#qryEndDate’).datebox(‘getValue’);
//alert(param.qryEndTime);
if($(‘#region’)!= null && $(‘#region’).attr(“checked”) == true){
}
if($(‘#county’)!= null && $(‘#county’).attr(“checked”) == true){
strStatCond += “,c.county_name”;
$(‘#tt’).datagrid(‘showColumn’, ‘COUNTY_NAME’);
}else{
$(‘#tt’).datagrid(‘hideColumn’, ‘COUNTY_NAME’);