DepartmentController.java
3.12 KB
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
package com.jflyfox.system.department;
import java.util.List;
import com.jfinal.plugin.activerecord.Page;
import com.jflyfox.component.base.BaseProjectController;
import com.jflyfox.jfinal.component.annotation.ControllerBind;
import com.jflyfox.jfinal.component.db.SQLUtils;
import com.jflyfox.util.StrUtils;
/**
* 部门
*
* @author flyfox 2014-4-24
*/
@ControllerBind(controllerKey = "/system/department")
public class DepartmentController extends BaseProjectController {
private static final String path = "/pages/system/department/department_";
public void index() {
list();
}
public void list() {
SysDepartment model = getModelByAttr(SysDepartment.class);
SQLUtils sql = new SQLUtils(" from sys_department t "
+ " left join sys_department p on t.parent_id = p.id where 1=1 ");
if (model.getAttrValues().length != 0) {
sql.setAlias("t");
// 查询条件
sql.whereLike("name", model.getStr("name"));
}
// 排序
String orderBy = getBaseForm().getOrderBy();
if (StrUtils.isEmpty(orderBy)) {
sql.append(" order by t.sort,t.id desc ");
} else {
sql.append(" order by ").append(orderBy);
}
Page<SysDepartment> page = SysDepartment.dao.paginate(getPaginator(), "select t.*,p.name as parentName ", //
sql.toString().toString());
// 下拉框
setAttr("page", page);
setAttr("attr", model);
List<SysDepartment> departments = SysDepartment.dao.find("select * from sys_department order by sort,id ");
setAttr("departments", departments);
render(path + "list.html");
}
public void add() {
// 获取页面信息,设置目录传入
SysDepartment model = SysDepartment.dao.findById(getParaToInt());
setAttr("selectParentDepartments", new DepartmentSvc().selectDepart(model == null ? 0 : model.getId()));
render(path + "add.html");
}
public void view() {
SysDepartment model = SysDepartment.dao.findById(getParaToInt());
setAttr("model", model);
SysDepartment department = SysDepartment.dao.findById(model.getParentId());
model.put("parentName", department != null ? department.getName() : null);
render(path + "view.html");
}
public void delete() {
// 日志添加
SysDepartment model = new SysDepartment();
Integer userid = getSessionUser().getUserid();
String now = getNow();
model.put("update_id", userid);
model.put("update_time", now);
model.deleteById(getParaToInt());
list();
}
public void edit() {
SysDepartment model = SysDepartment.dao.findById(getParaToInt());
setAttr("model", model);
// 下拉框
setAttr("selectParentDepartments", new DepartmentSvc().selectDepart(model.getParentId(), model.getId()));
render(path + "edit.html");
}
public void save() {
Integer pid = getParaToInt();
SysDepartment model = getModel(SysDepartment.class);
// 日志添加
Integer userid = getSessionUser().getUserid();
String now = getNow();
model.set("update_id", userid);
model.set("update_time", now);
if (pid != null && pid > 0) { // 更新
model.update();
} else { // 新增
model.remove("id");
model.set("create_id", userid);
model.set("create_time", now);
model.save();
}
renderMessage("保存成功");
}
}