提交 | 用户 | 时间
|
71e81e
|
1 |
layui.use(['table', 'admin', 'ax'], function () { |
懒 |
2 |
var $ = layui.$; |
|
3 |
var table = layui.table; |
|
4 |
var $ax = layui.ax; |
|
5 |
var admin = layui.admin; |
|
6 |
|
|
7 |
/** |
|
8 |
* 数据库信息表管理 |
|
9 |
*/ |
|
10 |
var DatabaseInfo = { |
|
11 |
tableId: "databaseInfoTable" |
|
12 |
}; |
|
13 |
|
|
14 |
/** |
|
15 |
* 初始化表格的列 |
|
16 |
*/ |
|
17 |
DatabaseInfo.initColumn = function () { |
|
18 |
return [[ |
|
19 |
{type: 'checkbox'}, |
|
20 |
{field: 'dbId', hide: true, title: '主键id'}, |
|
21 |
{field: 'dbName', align: "center", sort: true, title: '数据库名称'}, |
|
22 |
{field: 'jdbcDriver', align: "center", sort: true, title: '驱动类型', minWidth: 182}, |
|
23 |
{field: 'userName', align: "center", sort: true, title: '账号'}, |
|
24 |
{field: 'password', align: "center", sort: true, title: '密码'}, |
|
25 |
{field: 'jdbcUrl', align: "center", sort: true, title: 'jdbc的url'}, |
|
26 |
{field: 'remarks', align: "center", sort: true, title: '备注'}, |
|
27 |
{field: 'createTime', align: "center", sort: true, title: '创建时间', minWidth: 160}, |
|
28 |
{align: 'center', toolbar: '#tableBar', title: '操作'} |
|
29 |
]]; |
|
30 |
}; |
|
31 |
|
|
32 |
/** |
|
33 |
* 点击查询按钮 |
|
34 |
*/ |
|
35 |
DatabaseInfo.search = function () { |
|
36 |
var queryData = {}; |
|
37 |
queryData['condition'] = $("#condition").val(); |
|
38 |
table.reload(DatabaseInfo.tableId, { |
|
39 |
where: queryData, page: {curr: 1} |
|
40 |
}); |
|
41 |
}; |
|
42 |
|
|
43 |
/** |
|
44 |
* 弹出添加对话框 |
|
45 |
*/ |
|
46 |
DatabaseInfo.openAddDlg = function () { |
|
47 |
window.location.href = Feng.ctxPath + '/databaseInfo/add'; |
|
48 |
}; |
|
49 |
|
|
50 |
/** |
|
51 |
* 导出excel按钮 |
|
52 |
*/ |
|
53 |
DatabaseInfo.exportExcel = function () { |
|
54 |
var checkRows = table.checkStatus(DatabaseInfo.tableId); |
|
55 |
if (checkRows.data.length === 0) { |
|
56 |
Feng.error("请选择要导出的数据"); |
|
57 |
} else { |
|
58 |
table.exportFile(tableResult.config.id, checkRows.data, 'xls'); |
|
59 |
} |
|
60 |
}; |
|
61 |
|
|
62 |
/** |
|
63 |
* 点击删除 |
|
64 |
* |
|
65 |
* @param data 点击按钮时候的行数据 |
|
66 |
*/ |
|
67 |
DatabaseInfo.onDeleteItem = function (data) { |
|
68 |
var operation = function () { |
|
69 |
var ajax = new $ax(Feng.ctxPath + "/databaseInfo/delete", function (data) { |
|
70 |
Feng.success("删除成功!"); |
|
71 |
table.reload(DatabaseInfo.tableId); |
|
72 |
}, function (data) { |
|
73 |
Feng.error("删除失败!" + data.responseJSON.message + "!"); |
|
74 |
}); |
|
75 |
ajax.set("dbId", data.dbId); |
|
76 |
ajax.start(); |
|
77 |
}; |
|
78 |
Feng.confirm("是否删除?", operation); |
|
79 |
}; |
|
80 |
|
|
81 |
// 渲染表格 |
|
82 |
var tableResult = table.render({ |
|
83 |
elem: '#' + DatabaseInfo.tableId, |
|
84 |
url: Feng.ctxPath + '/databaseInfo/list', |
|
85 |
page: true, |
|
86 |
height: "full-158", |
|
87 |
cellMinWidth: 100, |
|
88 |
cols: DatabaseInfo.initColumn() |
|
89 |
}); |
|
90 |
|
|
91 |
// 搜索按钮点击事件 |
|
92 |
$('#btnSearch').click(function () { |
|
93 |
DatabaseInfo.search(); |
|
94 |
}); |
|
95 |
|
|
96 |
// 添加按钮点击事件 |
|
97 |
$('#btnAdd').click(function () { |
|
98 |
DatabaseInfo.openAddDlg(); |
|
99 |
}); |
|
100 |
|
|
101 |
// 导出excel |
|
102 |
$('#btnExp').click(function () { |
|
103 |
DatabaseInfo.exportExcel(); |
|
104 |
}); |
|
105 |
|
|
106 |
// 工具条点击事件 |
|
107 |
table.on('tool(' + DatabaseInfo.tableId + ')', function (obj) { |
|
108 |
var data = obj.data; |
|
109 |
var layEvent = obj.event; |
|
110 |
|
|
111 |
if (layEvent === 'edit') { |
|
112 |
DatabaseInfo.openEditDlg(data); |
|
113 |
} else if (layEvent === 'delete') { |
|
114 |
DatabaseInfo.onDeleteItem(data); |
|
115 |
} |
|
116 |
}); |
|
117 |
}); |