ExtJs数据管理操作源代码.docx
《ExtJs数据管理操作源代码.docx》由会员分享，可在线阅读，更多相关《ExtJs数据管理操作源代码.docx（33页珍藏版）》请在冰豆网上搜索。
ExtJs数据管理操作源代码
//JScript文件
varcustomerTypestore;
varcustomerManage=function（node）{
varftable='GPS_customer';
varcustomerRightClick=newExt.menu.Menu（）;
varpowerfields=["fbh","fcheck","ftype"];
varpowerstore=newExt.data.Store（{
//autoLoad:
true,
proxy:
newExt.data.HttpProxy（
{
url:
"DATA/table_power/getpower.aspx",
method:
"POST"
}）,
reader:
newExt.data.JsonReader（
{
fields:
powerfields,
root:
"data",
id:
"fbh",
totalProperty:
"totalCount"
}）
listeners:
{
'load':
function（store,records,options）
{
if（powerstore.getTotalCount（）==3）
{
if（powerstore.getAt（0）.data.fcheck=='1'）
{
varmenuItem1=newExt.menu.Item（{
text:
'添加',
iconCls:
'addicon',
handler:
function（）{
AddcustomerFn（custtree）;}
}）;
customerRightClick.add（menuItem1）;
}
if（powerstore.getAt
（1）.data.fcheck=='1'）
{
varmenuItem2=newExt.menu.Item（{
text:
'删除',
iconCls:
'deleteicon',
handler:
function（）{DeletecustomerFn（custtree）;}
}）;
customerRightClick.add（menuItem2）;
}
if（powerstore.getAt
（2）.data.fcheck=='1'）
{
varmenuItem3=newExt.menu.Item（{
text:
'编辑',
iconCls:
'editicon',
handler:
function（）{EditcustomerFn（custtree）;}
}）;
customerRightClick.add（menuItem3）;
}
}
varmenuItem4=newExt.menu.Item（{
text:
'查看',
iconCls:
'lookicon',
handler:
function（）{lookcustomerFn（）;}
}）;
customerRightClick.add（menuItem4）;
}
}
}）;
powerstore.load（{params:
{ftable:
ftable}}）;
//varpageSize=16;
//指定列参数
varcustomerfields=["fcustomerid","fcustomer","fgroup","ftype","faddr","flevel","farea","fcaddr","fpostcode","ftel","ffax","femail","furl","fparent","fchild","fdrelation","frival","fuserid","fuser","flinkmanid","flinkman","fceoid","fceo","fbankacc","fbank","fbeizhu"];
customerstore=newExt.data.Store（{
//autoLoad:
true,
proxy:
newExt.data.HttpProxy（
{
url:
"DATA/customer/customer.aspx",
method:
"POST"
}）,
reader:
newExt.data.JsonReader（
{
fields:
customerfields,
root:
"data",
id:
"fcustomerid",
totalProperty:
"totalCount"
}）
}）;
customerstore.load（{params:
{start:
0,limit:
pageSize}}）;
functionSerachOpenRoomRecord（）
{
varfziduans=Ext.get（'customerziduan'）.dom.value;
varffhs=Ext.get（'customerfh'）.dom.value;
varmessage=Ext.get（'customermessage'）.dom.value;
varcheck=Ext.get（'customercbx'）.dom.checked;
//if（fziduans=='请选择查询'||message=='输入查询值'）
//{
//return;
//}
customerstore.reload
（{
params:
{start:
0,limit:
pageSize,fziduan:
fziduans,ffh:
ffhs,msg:
message,check:
check}
}）;
}
varfindtypefileds=Ext.data.Record.create（[
{name:
'fziduan',mapping:
'fziduan'},{name:
'fname',mapping:
'fname'},{name:
'ftype',mapping:
'ftype'}
]）;
varfindstore=newExt.data.Store（{
proxy:
newExt.data.HttpProxy（{
url:
'DATA/find.aspx?
ftable=GPS_customer',
method:
"POST"
}）,
reader:
newExt.data.JsonReader（{
root:
'data',
id:
'fziduan'
},
findtypefileds
）
}）;
findstore.load（）;
varlistfileds=Ext.data.Record.create（[
//{name:
'fid',mapping:
'fid'},
{name:
'flist',mapping:
'flist'}
]）;
varliststore=newExt.data.Store（{
proxy:
newExt.data.HttpProxy（{
url:
'DATA/fdatavallist.aspx?
ftable=GPS_customer&flist=',//+flist,
method:
"POST"
}）,
reader:
newExt.data.JsonReader（{
root:
'data',
id:
'flist'
},listfileds）
}）;
//liststore.load（）;
varcustomersm=newExt.grid.CheckboxSelectionModel（{
dataIndex:
"fcustomerid"
}）;
varcustomercm=newExt.grid.ColumnModel（[
customersm,
{header:
"客户代码",tooltip:
"客户代码",dataIndex:
"fcustomerid",sortable:
true,locked:
true},
{header:
"客户名称",tooltip:
"客户名称",dataIndex:
"fcustomer",sortable:
true,locked:
true},
{header:
"客户分类",tooltip:
"客户分类",dataIndex:
"fgroup",sortable:
true},
{header:
"客户属性",tooltip:
"客户属性",dataIndex:
"ftype",sortable:
true},
{header:
"客户地址",tooltip:
"客户地址",dataIndex:
"faddr",sortable:
true},
{header:
"客户级别",tooltip:
"客户级别",dataIndex:
"flevel",sortable:
true},
{header:
"所属区域",tooltip:
"所属区域",dataIndex:
"farea",sortable:
true},
{header:
"通讯地址",tooltip:
"通讯地址",dataIndex:
"fcaddr",sortable:
true},
{header:
"邮编",tooltip:
"邮编",dataIndex:
"fpostcode",sortable:
true},
{header:
"电话",tooltip:
"电话",dataIndex:
"ftel",sortable:
true},
{header:
"传真",tooltip:
"传真",dataIndex:
"ffax",sortable:
true},
{header:
"E-mail",tooltip:
"E-mail",dataIndex:
"femail",sortable:
true},
{header:
"网址",tooltip:
"网址",dataIndex:
"furl",sortable:
true},
{header:
"上级机构代码",tooltip:
"上级机构代码",dataIndex:
"fparent",sortable:
true},
{header:
"分支机构数目",tooltip:
"分支机构数目",dataIndex:
"fchild",sortable:
true},
{header:
"关系建立时间",tooltip:
"关系建立时间",dataIndex:
"fdrelation",sortable:
true,format:
'Y-m-d',xtype:
'datefield'},
{header:
"使用对手产品情况",tooltip:
"使用对手产品情况",dataIndex:
"frival",sortable:
true},
//{header:
"客户经理ID",tooltip:
"客户经理ID",dataIndex:
"fuserid",sortable:
true},
{header:
"客户经理",tooltip:
"客户经理",dataIndex:
"fuser",sortable:
true},
//{header:
"联系人ID",tooltip:
"联系人ID",dataIndex:
"flinkmanid",sortable:
true},
//{header:
"联系人",tooltip:
"联系人",dataIndex:
"flinkman",sortable:
true},
//{header:
"决策人ID",tooltip:
"决策人ID",dataIndex:
"fceoid",sortable:
true},
//{header:
"决策人",tooltip:
"决策人",dataIndex:
"fceo",sortable:
true},
{header:
"银行帐号",tooltip:
"银行帐号",dataIndex:
"fbankacc",sortable:
true},
{header:
"开户银行",tooltip:
"开户银行",dataIndex:
"fbank",sortable:
true},
{header:
"备注",tooltip:
"备注",dataIndex:
"fbeizhu",sortable:
true}
//{
//header:
"部门ID",
//dataIndex:
"fcustomerid",
//tooltip:
"部门ID",
////列不可操作
////menuDisabled:
true,
////可以进行排序
//sortable:
true
//}
]）;
//varcustomerRightClick=newExt.menu.Menu
//（{
//items:
//[{
//text:
'添加',
//iconCls:
'addicon',
//handler:
function（）{
//AddcustomerFn（custtree）;}
//},{
//text:
'编辑',
//iconCls:
'editicon',
//handler:
function（）{EditcustomerFn（custtree）;}
//},{
//text:
'删除',
//iconCls:
'deleteicon',
//handler:
function（）{DeletecustomerFn（custtree）;}
//}]
//}）;
//varbb=newExt.Toolbar.Button（{
//text:
'查询',
//pressed:
true,
//tooltip:
"查询结果",
//iconCls:
'serchopenroomrecord',
//handler:
SerachOpenRoomRecord
//}）;
//vartt=newExt.form.ComboBox（{
////id:
"fziduans",
//name:
"customerziduans",
//xtype:
"combo",
//tpl:
'qtip="{fziduan}.{fname}"class="x-combo-list-item">{fname}
升级会员 