ExtJs数据管理操作源代码

1、/ JScript 文件var customerTypestore;var customerManage=function(node) var ftable=GPS_customer; var customerRightClick=new Ext.menu.Menu(); var powerfields = fbh,fcheck,ftype; var powerstore = new Ext.data.Store(/ autoLoad:true, proxy:new Ext.data.HttpProxy( url:DATA/table_power/getpower.aspx, method:P

2、OST ), reader:new Ext.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) var menuItem1 = new Ext.menu.Item( text: 添加, iconCls:addicon, handler

3、:function()AddcustomerFn(custtree); ); customerRightClick.add(menuItem1); if(powerstore.getAt(1).data.fcheck = 1) var menuItem2 = new Ext.menu.Item( text:删除, iconCls:deleteicon, handler:function()DeletecustomerFn(custtree); ); customerRightClick.add(menuItem2); if(powerstore.getAt(2).data.fcheck = 1

4、) var menuItem3 = new Ext.menu.Item( text:编辑, iconCls:editicon, handler:function()EditcustomerFn(custtree); ); customerRightClick.add(menuItem3); var menuItem4 = new Ext.menu.Item( text:查看, iconCls:lookicon, handler:function()lookcustomerFn(); ); customerRightClick.add(menuItem4); );powerstore.load(

5、params:ftable:ftable); / var pageSize = 16;/指定列参数var customerfields = 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 = new Ext.data.Store

6、(/ autoLoad:true, proxy:new Ext.data.HttpProxy( url:DATA/customer/customer.aspx, method:POST ), reader:new Ext.data.JsonReader( fields:customerfields, root:data, id:fcustomerid, totalProperty:totalCount );customerstore.load(params:start:0,limit:pageSize); function SerachOpenRoomRecord() var fziduans

7、 = Ext.get(customerziduan).dom.value; var ffhs = Ext.get(customerfh).dom.value; var message = Ext.get(customermessage).dom.value; var check = Ext.get(customercbx).dom.checked;/ if(fziduans = 请选择查询 | message = 输入查询值)/ / return; / customerstore.reload ( params:start:0,limit:pageSize,fziduan:fziduans,f

8、fh:ffhs,msg:message,check:check ); var findtypefileds = Ext.data.Record.create( name: fziduan,mapping:fziduan,name: fname,mapping:fname,name:ftype,mapping:ftype ); var findstore = new Ext.data.Store( proxy: new Ext.data.HttpProxy( url:DATA/find.aspx?ftable=GPS_customer, method:POST ), reader: new Ex

9、t.data.JsonReader( root: data, id: fziduan , findtypefileds ) ); findstore.load(); var listfileds=Ext.data.Record.create(/ name:fid,mapping:fid, name:flist,mapping:flist ); var liststore=new Ext.data.Store( proxy:new Ext.data.HttpProxy( url:DATA/fdatavallist.aspx?ftable=GPS_customer&flist=,/+flist,

10、method:POST ), reader:new Ext.data.JsonReader( root:data, id:flist ,listfileds) );/ liststore.load();var customersm = new Ext.grid.CheckboxSelectionModel(dataIndex:fcustomerid);var customercm = new Ext.grid.ColumnModel(customersm,header:客户代码,tooltip:客户代码,dataIndex:fcustomerid,sortable:true,locked:tr

11、ue,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,head

12、er:所属区域,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

13、: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:使用对手产

14、品情况,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:决策人

15、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:fcustomeri

16、d,/tooltip:部门ID,/列不可操作/menuDisabled:true,/可以进行排序/ sortable:true/ ); / var customerRightClick=new Ext.menu.Menu/ (/ items:/ / text: 添加,/ iconCls:addicon,/ handler:function()/AddcustomerFn(custtree);/ ,/ text:编辑,/ iconCls:editicon,/ handler:function()EditcustomerFn(custtree);/ ,/ text:删除,/ iconCls:del

17、eteicon,/ handler:function()DeletecustomerFn(custtree);/ / );/ var bb = new Ext.Toolbar.Button(/ text:查询,/ pressed:true,/ tooltip:查询结果,/ iconCls:serchopenroomrecord,/ handler:SerachOpenRoomRecord/ );/ var tt = new Ext.form.ComboBox( / id:fziduans,/ name:customerziduans,/xtype:combo,/tpl: fname,/选择记录

18、时的备注/fieldLabel:客人性别,/传入后台真实值value field /value/hiddenName:customerziduan,/width:100,/typeAhead: true,/readOnly:true,/mode:remote,/displayField:fname,/valueField:fziduan,/triggerAction:all,/emptyText:请选择查询,/value:客户代码,/store:findstore/,listeners:/ select:function(combo, record, index) / liststore.pr

19、oxy= new Ext.data.HttpProxy(method:POST,url: DATA/fdatavallist.aspx?ftable=GPS_customer&flist= + combo.getValue(); / liststore.load(); / /);/ var tbbar = new Ext.Toolbar(/ text:查询,/ pressed:true,/ tooltip:查询结果,/ iconCls:serchopenroomrecord,/ handler:SerachOpenRoomRecord/ ); var customergrid = new Ex

20、t.grid.GridPanel( id:customerGrid,/ autoHeight: true,/ title: center-north, region: center, /renderTo: ugrid,store:customerstore,sm:customersm,cm:customercm,loadMask:true,/自适应宽度 参数为列数autoExpandColumn:6,/超过长度带自动滚动条autoScroll:true,border:false,viewConfig:columnsText:显示/隐藏列,sortAscText:正序排列,sortDescTex

21、t:倒序排列,/分页bbar:new Ext.PagingToolbar(store:customerstore,pageSize:pageSize,/显示右下角信息displayInfo:true,displayMsg:当前记录 0 - 1 条 共 2 条记录, emptyMsg:No results to display, prevText:上一页,nextText:下一页,refreshText:刷新,lastText:最后页,firstText:第一页,beforePageText:当前页,afterPageText:共0页),tbar:,搜索: , , / id:fziduans,

22、name:customerziduans,xtype:combo,tpl: fname,/选择记录时的备注/fieldLabel:客人性别,/传入后台真实值value field /valuehiddenName:customerziduan,width:100,typeAhead: true,readOnly:true,mode:remote,displayField:fname,valueField:fziduan,triggerAction:all,emptyText:请选择查询,/value:客户代码,store:findstore,listeners: select:function

23、(combo, record, index) xy= new Ext.data.HttpProxy(method:POST,url: DATA/fdatavallist.aspx?ftable=GPS_customer&flist= + combo.getValue(); liststore.load(); , / id:ffhs, name:customerfhs,xtype:combo,hiddenName:customerfh,readOnly:true,width:50,mode:local,displayField:value,valueField:valu

24、e,triggerAction:all,value:=,store:new Ext.data.SimpleStore(fields:value,data:=,=,=,like,not like),/ xtype:textfield, width:120,/ id:message, name:customermessage, emptyText:输入查询值,xtype:combo,/tpl: fname,/选择记录时的备注/fieldLabel:客人性别,/传入后台真实值value field /valuetypeAhead: true,readOnly:false,mode:remote,di

25、splayField:flist,valueField:flist,triggerAction:all,store:liststore,-, text:查询, pressed:true, tooltip:查询结果, iconCls:serchopenroomrecord, handler:SerachOpenRoomRecord ,-, xtype:checkbox, checked: false, fieldLabel: , labelSeparator: , boxLabel: 结果中查询, name: customercbx ,-,new Ext.Toolbar.Fill(), text

26、:修改归属经理, iconCls:editicon1, handler:function()rencustomerFn(custtree); , text:查看, iconCls:lookicon, handler:function()lookcustomerFn(); ,-,listeners: contextmenu:function(e) e.stopEvent(); ,/ render:function(component)/ / customergrid.tbar.add(bb);/ , rowcontextmenu:function(grid,rowIndex,e) e.stopE

27、vent(); customerRightClick.showAt(e.getXY(); ); / grid end var custroot = new Ext.tree.AsyncTreeNode(text : 根客户,expanded : true,/设置根节点默认是展开的id : 0); var custtree = new Ext.tree.TreePanel( id: custtree, title: 客户资料, region:west, split: true, autoheight: true,/ minSize: 150, width: 200, minSize: 175,

28、maxSize: 400, autoScroll: true, collapsible: true, enableDD:true, / tree-specific configs: rootVisible: true, lines: true,/ singleExpand: true, useArrows: true, / loader: new Ext.tree.TreeLoader(/ dataUrl:tree-data.json/ ), loader: new Ext.tree.TreeLoader(/ id:0, dataUrl:DATA/customer/custTree.aspx,

29、 listeners: beforeload:function(Treeloader,node1) Treeloader.baseParams= id:node1.id, method:POST ; ), root: custroot /new Ext.tree.AsyncTreeNode() , tbar : / / text : 取得被选节点,/ handler : function()/var sm = custtree.getSelectionModel();/取得树的选择模式对象/var node1 = sm.getSelectedNode();/取得当前选中的节点/alert(节点

30、ID： + node1.id);/ /,/ /text : 根客户,/handler : function()/ var sm = custtree.getSelectionModel();/取得树的选择模式对象/var node1 = sm.getSelectedNode();/取得当前选中的节点/var loader = custtree.getLoader();/取得树加载器/loader.load(custroot,function()/custroot.expand();/重新加载后展开根节点/);/重新加载根节点/custtree.expandPath(custtree.getPa

31、th(node1.id);/,-, xtype:textfield, width:130, name:treefilter, emptyText:过滤节点 ,listeners: render: function(f) f.el.on(keydown, filterTree, f, buffer: 350); /,/ text:过滤,/ pressed:true,/ tooltip:过滤结果,/ iconCls:filter,/ handler:function()/ custtree.expandAll();/ var text = Ext.get(treefilter).dom.value

32、;/ if(text= | text=过滤节点)/ / filter.clear();/ / else/ / filterTree(text);/ / , iconCls: icon-expand-all, tooltip: 全部展开, handler: function() custtree.root.expand(true); , iconCls: icon-collapse-all, tooltip: 全部收起, handler: function() custtree.root.collapse(true); ); var hiddenPkgs = ; function filterT

33、ree(e) custtree.expandAll(); var text = e.target.value; Ext.each(hiddenPkgs, function(n) n.ui.show(); ); if (!text) filter.clear(); return; / custtree.expandAll(); var re = new RegExp(Ext.escapeRe(text), i); filter.filterBy(function(n) / var textval = n.text; return !n.isLeaf() | re.test(n.text); );

34、 / hide empty packages that werent filtered hiddenPkgs = ; custtree.root.cascade(function(n) / var ret=false; if (n.id!=0 & !n.isLeaf() & n.ui.ctNode.offsetHeight = 3) else if(!n.isLeaf() & re.test(n.text) n.ui.show(); hiddenPkgs.pop(n); / if(n.isLeaf()/ return false;/ else/ return true; custtree.ro

35、ot.cascade(function(n) if (!n.isLeaf() & n.ui.ctNode.offsetHeight = 3) else if(!n.isLeaf() & re.test(n.text) n.ui.show(); hiddenPkgs.pop(n); ); ); var filter = new Ext.tree.TreeFilter(custtree, clearBlank: true, autoClear: true ); / Assign the changeLayout function to be called on tree node click. custtree.on(click, function(node1,event) /叶子节点点击不