Ext.define('gridState',{
extend: 'Ext.data.Model',
fields: [{name:'zbID',mapping:'zbID'},'gwID','bkhr','zbmc','dfsj','dftjlx','zycd','mbms','dfbz','sjms','df','dfsj','dfr','lddfms','shbz','shjy','shsj','shrxm','dfzt']
});
pageVar.gridStore = Ext.create('Ext.data.Store', {
model: 'gridState',
proxy: {
//异步获取数据,这里的URL可以改为任何动态页面,只要返回JSON数据即可
type: 'ajax',
url: '/jxkh/app/jsp/jxkh_dafen_Mr.jsp?fg=2',
reader: {
type: 'json',
root: 'items'
}
},
autoLoad: true
});
pageVar.mainPanel = Ext.create('Ext.grid.Panel',{
region:'center',
store: pageVar.gridStore,
columns: [
{text:"ID",dataIndex:'zbID',align:'center',sortable:true,hidden:true},
{text:"岗位ID",dataIndex:'gwID',align:'center',sortable:true,hidden:true},
{text:"被考核人",dataIndex:'bkhr',align:'center',sortable:true,width:100},
{text:"指标名称",dataIndex:'zbmc',align:'center',sortable:true,width:230},
{text:"得分时间",dataIndex:'dfsj',align:'center',sortable:true,width:100},
{text:"得分统计类型",dataIndex:'dftjlx',align:'center',sortable:true},
{text:"重要程度",dataIndex:'zycd',align:'center',sortable:true},
{text:"目标描述",dataIndex:'mbms',align:'center',sortable:true,hidden:true},
{text:"得分比重",dataIndex:'dfbz',align:'center',sortable:true},
{text:"实级描述",dataIndex:'sjms',align:'center',sortable:true,hidden:true},
{text:"得分",dataIndex:'df',align:'center',sortable:true,renderer:formatScore},
{text:"打分时间",dataIndex:'dfsj',align:'center',sortable:true},
{text:"打分人",dataIndex:'dfr',align:'center',sortable:true},
{text:"领导打分描述",dataIndex:'lddfms',align:'center',sortable:true,hidden:true},
{text:"审核标志",dataIndex:'shbz',align:'center',sortable:true,hidden:true},
{text:"审核建议",dataIndex:'shjy',align:'center',sortable:true,hidden:true},
{text:"审核时间",dataIndex:'shsj',align:'center',sortable:true,hidden:true},
{text:"审核人姓名",dataIndex:'shrxm',align:'center',sortable:true,hidden:true},
{text:"得分状态",dataIndex:'dfzt',align:'center',sortable:true,renderer:formatState}
],
title: '打分指标',
viewConfig: {
stripeRows: true
} ,
listeners: {
dblclick: {
element: 'body', //bind to the underlying el property on the panel
fn: function(){
var msg='';
var msg1='';
var msg2='';
var zbid='';
var zbName='';
var zbscore='';
var roww=pageVar.mainPanel.getSelectionModel().getSelection();
for(var i=0;i<roww.length;i++){
zbid=zbid+roww[i].get('zbID');
zbName=zbName+roww[i].get('zbmc');
msg=msg+roww[i].get('mbms');//应该绑定mbms
msg1=msg1+roww[i].get('sjms');//应该绑定sjms
msg2=msg2+roww[i].get('lddfms');//应该绑定lddfms
zbscore=zbscore+roww[i].get('df');
Ext.getCmp('zbid').setValue(zbid);
Ext.getCmp('tgtName').setValue(zbName);
Ext.getCmp('tgtD').setValue(msg);
Ext.getCmp('trueD').setValue(msg1);
Ext.getCmp('lddfDetail').setValue(msg2);
Ext.getCmp('score').setValue(zbscore);
}
}
}
}
}) ;
----------------------------------------------返回的json串---------------------
private void zbInfoJSON(RSTable rs,HttpServletResponse resp){
PrintWriter out = null;
StringBuffer sb = new StringBuffer();
try
{
out = resp.getWriter();
out.println("{");
sb.append("{");
out.println("items:[");
sb.append("items:[");
if(rs != null && rs.getRowCount() > 0)
{
for(int i = 0; i < rs.getRowCount(); i++)
{
out.print("{");
sb.append("{");
out.print("'zbID' :'" + rs.getStringValue(i,0) + "',");
sb.append("'zbID':'" + rs.getStringValue(i, 0) + "',");
out.print("'bkhr' :'" + rs.getStringValue(i, 1) + "',");
sb.append("'bkhr':'" + rs.getStringValue(i, 1) + "',");
out.print("'gwID':'" + rs.getStringValue(i, 2) + "',");
sb.append("'gwID':'" + rs.getStringValue(i, 2) + "',");
out.print("'zbmc':'" + rs.getStringValue(i, 3)+ "',");
sb.append("'zbmc':'" + rs.getStringValue(i, 3) + "',");
out.print("'dftjlx':'" + rs.getStringValue(i, 4)+ "',");
sb.append("'dftjlx':'" + rs.getStringValue(i, 4) + "',");
out.print("'zycd':'" + rs.getStringValue(i, 5)+ "',");
sb.append("'zycd':'" + rs.getStringValue(i, 5) + "',");
out.print("'mbms':'" + rs.getStringValue(i, 6)+ "',");
sb.append("'mbms':'" + rs.getStringValue(i, 6) + "',");
out.print("'dfbz':'" + rs.getDoubleValue(i, 7)+ "'");
sb.append("'dfbz':'" + rs.getDoubleValue(i, 7) + "'");
out.print("}");
sb.append("}");
if(i != rs.getRowCount() - 1)
{
out.print(",");
sb.append(",");
}
}
}
out.println("]");
sb.append("]");
out.println("}");
sb.append("}");
}
catch(IOException e)
{
out.print("]");
sb.append("]");
e.toString();
}
System.out.println(sb.toString());
}