2
13693261870
2022-09-16 653761a31dfeb50dd3d007e892d69c90bf0cdafc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
 
//停用
 
// Ext.define('DataSourceDataModel', {
//     extend: 'Ext.data.Model',
//     fields:[
//         'databasetype','datasourceid','username','password','serveraddress','databasename','port','createuserid','createdate'
//     ],
//     idProperty: 'datasourceid'
// });
//
// var ZYMLZiYuanStore = new Ext.data.Store({
//     autoDestroy: true,
//     pageSize: 10,
//     model: 'DataSourceDataModel',
//     proxy: {
//         type: 'ajax',
//         url: '/res/ResManage/ResRegister/DataSourceData',
//         reader: {
//             root: 'topics',
//             totalProperty: 'totalCount'
//         },
//         simpleSortMode: true
//     },
//     remoteSort: true
// });
//
// var formdata = {};
// Ext.onReady(function () {
//     Ext.state.Manager.setProvider(new Ext.state.CookieProvider());
//     Ext.tip.QuickTipManager.init();
//     Ext.Ajax.timeout = 900000;
//     Ext.require([
//         'Ext.ux.PagingToolbar'
//     ]);
//
//     Ext.create('Ext.grid.Panel', {
//         id: 'gridexample',
//         renderTo: 'grid',
//         height: 500,
//         layout: 'fit',
//         autoScroll: false,
//         store: ZYMLZiYuanStore,
//         stateful: false,
//         stateId: 'ZYMLZiYuan-Grid',
//         viewConfig: {
//             forceFit: true,
//             enableTextSelection: true //列表数据可复制
//         },
//         columns: [
//             { xtype: 'rownumberer', text: "序号", width: '5%', align: 'center' },
//             { text: "数据库名称", dataIndex: 'databasename', width: '23.75%', sortable: false, align: 'center', filter: { type: 'string' },
//                 renderer: function (value, p, record) {
//                     var datasourceid = record.getData()["datasourceid"];
//                     return Ext.String.format(
//                         '<span style="text-decoration: underline;cursor:pointer;" onclick="ZiYuanEdit(\'{0}\')" >{1}</span>',
//                         datasourceid, value
//                     );
//                 }
//             },
//             { text: "数据库类型", dataIndex: 'databasetype', width: '23.75%', sortable: false, align: 'center', filter: { type: 'string' } },
//             { text: "数据库地址", dataIndex: 'serveraddress', width: '23.75%', sortable: false, align: 'center', filter: { type: 'string' } },
//             { text: "创建人", dataIndex: 'createuserid', width: '23.75%', sortable: false, align: 'center', filter: { type: 'string' } }
//         ],
//         bbar: Ext.create('Ext.ux.PagingToolbar', {
//             id: "Page",
//             name: "Page",
//             store: ZYMLZiYuanStore,
//             displayInfo: true,
//             firstText: "首页",
//             prevText: "上一页",
//             nextText: "下一页",
//             lastText: "尾页",
//             refreshText: '刷新',
//             beforePageText: '第',
//             afterPageText: '页,共 {0} 页',
//             displayMsg: '显示 {0} - {1} 条,共 {2} 条',
//             emptyMsg: "没有数据显示",
//             items: [
//                 {
//                     xtype: 'label',
//                     text: ''
//                 }
//             ]
//         })
//     });
//
//     ZYMLZiYuanStore.on('beforeload', function () {
//         GetSearchWhere("SearchForm");
//         ZYMLZiYuanStore.proxy.extraParams = [];
//         Ext.apply(ZYMLZiYuanStore.proxy.extraParams, formdata);
//     });
//     ZYMLZiYuanStore.on('load', function (store, records, successful, eOpts) {
//         var totalCount = store.totalCount;
//         if (totalCount == "") totalCount = "0";
//     });
//     ZYMLZiYuanStore.load();
//
//     //添加resize监听防止切换tab或者收起左栏导致grid不自适应宽度
//     $(window).resize(function () {
//         Ext.getCmp('gridexample').doLayout();//panel重新布局
//     });
// });
//
// //获取查询条件
// function GetSearchWhere(formId) {
//     var form = document.forms[formId];
//     for (var i = 0; i < form.elements.length; i++) {
//         var strID = form.elements[i].id;
//         var value = form.elements[i].value;
//         if (form.elements[i].type == "checkbox") {
//             if (form.elements[i].checked == true)
//                 value = "on";
//             else
//                 value = "";
//         }
//         if (form.elements[i].type == "radio") {
//             if (form.elements[i].checked == true) {
//                 strID = form.elements[i].name;
//                 value = form.elements[i].value;
//             }
//         }
//         formdata[strID] = (value == "全部" || value == "None" ? "" : value + "");
//     }
// }
//
// //添加
// function queding() {
//     //获取那个被选中
//     var valid=$('input:radio[name="selectName"]:checked').val();
//     var valname=$('input:radio[name="selectName"]:checked').attr("getname");
//     var valtype=$('input:radio[name="selectName"]:checked').attr("getype");
//     if(valid==null){
//         alert("选择数据库");
//     }else {
//         var index = parent.layer.getFrameIndex(window.name); //获取窗口索引
//         parent.$('#datasourceid').val(valid);
//         parent.$('#databasename').val(valname).change();
//         parent.$('#databasetype').val(valtype);
//         window.parent.spaceShowOrHide();
//         parent.layer.close(index);
//     }
// }
//
// function Clear() {
//     document.getElementById("SearchForm").reset();
// }
//
// function Search() {
//     Ext.getCmp('gridexample').dockedItems.items[1].store.currentPage = 1;
//     ZYMLZiYuanStore.load();
// }