获取列对象 grid.getHeaderAtIndex(columnIndex);
获取类的dataIndex,text
var fieldName = grid.getHeaderAtIndex(columnIndex-2).dataIndex;
var fieldText = grid.getHeaderAtIndex(columnIndex-2).text;
var grid=Ext.create('Ext.grid.Panel',{
id:'grid',
region:'center',
width:1760,
height:570,
store:vstore,
autoScroll:true,
//'CONSUMAGE','MAT_NAME','MAT_NO','NOWKC','PLANTCODE','PLANTNAME','PLANT_NUM','PLAN_NUM','PRICE','SUMKC','SUMNUMB','YEARJFIVE','YEARJFOUR','YEARJONE','YEARJTHREE','YEARJTWO','YEARNOWJ'
columns:[{header:'物资编码',text:'a',dataIndex:'MAT_NO',sortable:true,align:'center',width:'114'},
{header:'物资名称',text:'b',dataIndex:'MAT_NAME',sortable:true,align:'center',width:'75'},
{header:'所属厂矿',text:'c',dataIndex:'PLANTNAME',sortable:true,align:'center',width:'75'},
]});
Ext.getCmp('grid').columns[3].hide(false);
-----------------------------------------------
var grid=Ext.create('Ext.grid.Panel',{
id:'grid',
region:'center',
width:1760,
height:570,
store:vstore,
autoScroll:true,
//'CONSUMAGE','MAT_NAME','MAT_NO','NOWKC','PLANTCODE','PLANTNAME','PLANT_NUM','PLAN_NUM','PRICE','SUMKC','SUMNUMB','YEARJFIVE','YEARJFOUR','YEARJONE','YEARJTHREE','YEARJTWO','YEARNOWJ'
columns:[{header:'物资编码',text:'a',dataIndex:'MAT_NO',sortable:true,align:'center',width:'114'},
{header:'物资名称',text:'b',dataIndex:'MAT_NAME',sortable:true,align:'center',width:'75'},
{header:'所属厂矿',text:'c',dataIndex:'PLANTNAME',sortable:true,align:'center',width:'75'},
{header:'厂矿',columns:[
{header:sysYear-5+'年',text:'d',width:'60',sortable:true, dataInder:'YEARJFIVE',align:'center',hidden:true},//设置hidden可隐藏该列
{header:sysYear-4+'年',text:'e',width:'60',sortable:true, dataInder:'YEARJFOUR',align:'center'},
{header:sysYear-3+'年',text:'f',width:'60',sortable:true, dataInder:'YEARJTHREE',align:'center'},
{header:sysYear-2+'年',text:'g',width:'60',sortable:true, dataInder:'YEARJTWO',align:'center'},
{header:sysYear-1+'年',text:'h',width:'60',sortable:true, dataInder:'YEARJONE',align:'center'},
{header:sysYear+'年',text:'i',width:'60',sortable:true, dataInder:'YEARNOWJ',align:'center'},
{header:'年计划数量',text:'j',width:'80',sortable:true, dataInder:'PLANT_NUM',align:'center'},
{header:'当前库存',text:'k',width:'80',sortable:true, dataInder:'NOWKC',align:'center'},
{header:'消耗平均信息',text:'l',width:'85',sortable:true, dtaInder:'CONSUMAGE',align:'center' },
{header:'审核后数量',text:'m',width:'80',sortable:true, dataInder:0,align:'center'}
]},
{header:'合计',columns:[{header:'总库存(所有厂矿)',text:'n',width:'115',sortable:true, dataInder:'SUMKC',align:'center'},
{header:'2018年计划合计',text:'o',width:'105',sortable:true, dataInder:'PLAN_NUM',align:'center'},
{header:'当前库存合计',text:'p',width:'90',sortable:true, dataInder:'SUMKC',align:'center'},
{header:'审核后数量合计',text:'q',width:'100',sortable:true, dataInder:0,align:'center'},
{header:'计划金额合计',text:'r',width:'90',sortable:true, dataInder:'PRICE',align:'center'},
{header:'审核后金额合计',text:'s',width:'100',sortable:true, dataInder:0,align:'center'}
]}
]
});
隐藏列:
//Ext.getCmp('grid').columns[3].gridDataColumns[0].hide(true);
Ext.getCmp('grid').columns[3].items.items[0]
if (Ext.getStore('vstore').sum('YEARJFIVE')=="0"){Ext.getCmp('grid').columns[3].items.items[0].hide(true)};
if (Ext.getStore('vstore').sum('YEARJFOUR')=="0"){Ext.getCmp('grid').columns[3].items.items[1].hide(true)};
if (Ext.getStore('vstore').sum('YEARJTHREE')=="0"){Ext.getCmp('grid').columns[3].items.items[2].hide(true)};
if (Ext.getStore('vstore').sum('YEARJTWO')=="0"){Ext.getCmp('grid').columns[3].items.items[3].hide(true)};
if (Ext.getStore('vstore').sum('YEARJONE')=="0"){Ext.getCmp('grid').columns[3].items.items[4].hide(true)};
if (Ext.getStore('vstore').sum('YEARNOWJ')=="0"){Ext.getCmp('grid').columns[3].items.items[5].hide(true)};
获取类的dataIndex,text
var fieldName = grid.getHeaderAtIndex(columnIndex-2).dataIndex;
var fieldText = grid.getHeaderAtIndex(columnIndex-2).text;
var grid=Ext.create('Ext.grid.Panel',{
id:'grid',
region:'center',
width:1760,
height:570,
store:vstore,
autoScroll:true,
//'CONSUMAGE','MAT_NAME','MAT_NO','NOWKC','PLANTCODE','PLANTNAME','PLANT_NUM','PLAN_NUM','PRICE','SUMKC','SUMNUMB','YEARJFIVE','YEARJFOUR','YEARJONE','YEARJTHREE','YEARJTWO','YEARNOWJ'
columns:[{header:'物资编码',text:'a',dataIndex:'MAT_NO',sortable:true,align:'center',width:'114'},
{header:'物资名称',text:'b',dataIndex:'MAT_NAME',sortable:true,align:'center',width:'75'},
{header:'所属厂矿',text:'c',dataIndex:'PLANTNAME',sortable:true,align:'center',width:'75'},
]});
Ext.getCmp('grid').columns[3].hide(false);
-----------------------------------------------
var grid=Ext.create('Ext.grid.Panel',{
id:'grid',
region:'center',
width:1760,
height:570,
store:vstore,
autoScroll:true,
//'CONSUMAGE','MAT_NAME','MAT_NO','NOWKC','PLANTCODE','PLANTNAME','PLANT_NUM','PLAN_NUM','PRICE','SUMKC','SUMNUMB','YEARJFIVE','YEARJFOUR','YEARJONE','YEARJTHREE','YEARJTWO','YEARNOWJ'
columns:[{header:'物资编码',text:'a',dataIndex:'MAT_NO',sortable:true,align:'center',width:'114'},
{header:'物资名称',text:'b',dataIndex:'MAT_NAME',sortable:true,align:'center',width:'75'},
{header:'所属厂矿',text:'c',dataIndex:'PLANTNAME',sortable:true,align:'center',width:'75'},
{header:'厂矿',columns:[
{header:sysYear-5+'年',text:'d',width:'60',sortable:true, dataInder:'YEARJFIVE',align:'center',hidden:true},//设置hidden可隐藏该列
{header:sysYear-4+'年',text:'e',width:'60',sortable:true, dataInder:'YEARJFOUR',align:'center'},
{header:sysYear-3+'年',text:'f',width:'60',sortable:true, dataInder:'YEARJTHREE',align:'center'},
{header:sysYear-2+'年',text:'g',width:'60',sortable:true, dataInder:'YEARJTWO',align:'center'},
{header:sysYear-1+'年',text:'h',width:'60',sortable:true, dataInder:'YEARJONE',align:'center'},
{header:sysYear+'年',text:'i',width:'60',sortable:true, dataInder:'YEARNOWJ',align:'center'},
{header:'年计划数量',text:'j',width:'80',sortable:true, dataInder:'PLANT_NUM',align:'center'},
{header:'当前库存',text:'k',width:'80',sortable:true, dataInder:'NOWKC',align:'center'},
{header:'消耗平均信息',text:'l',width:'85',sortable:true, dtaInder:'CONSUMAGE',align:'center' },
{header:'审核后数量',text:'m',width:'80',sortable:true, dataInder:0,align:'center'}
]},
{header:'合计',columns:[{header:'总库存(所有厂矿)',text:'n',width:'115',sortable:true, dataInder:'SUMKC',align:'center'},
{header:'2018年计划合计',text:'o',width:'105',sortable:true, dataInder:'PLAN_NUM',align:'center'},
{header:'当前库存合计',text:'p',width:'90',sortable:true, dataInder:'SUMKC',align:'center'},
{header:'审核后数量合计',text:'q',width:'100',sortable:true, dataInder:0,align:'center'},
{header:'计划金额合计',text:'r',width:'90',sortable:true, dataInder:'PRICE',align:'center'},
{header:'审核后金额合计',text:'s',width:'100',sortable:true, dataInder:0,align:'center'}
]}
]
});
隐藏列:
//Ext.getCmp('grid').columns[3].gridDataColumns[0].hide(true);
Ext.getCmp('grid').columns[3].items.items[0]
if (Ext.getStore('vstore').sum('YEARJFIVE')=="0"){Ext.getCmp('grid').columns[3].items.items[0].hide(true)};
if (Ext.getStore('vstore').sum('YEARJFOUR')=="0"){Ext.getCmp('grid').columns[3].items.items[1].hide(true)};
if (Ext.getStore('vstore').sum('YEARJTHREE')=="0"){Ext.getCmp('grid').columns[3].items.items[2].hide(true)};
if (Ext.getStore('vstore').sum('YEARJTWO')=="0"){Ext.getCmp('grid').columns[3].items.items[3].hide(true)};
if (Ext.getStore('vstore').sum('YEARJONE')=="0"){Ext.getCmp('grid').columns[3].items.items[4].hide(true)};
if (Ext.getStore('vstore').sum('YEARNOWJ')=="0"){Ext.getCmp('grid').columns[3].items.items[5].hide(true)};