public List<NodeBean> getNodeQuery(int initPageNum, int perPageNum) {
int num = (initPageNum - 1) * perPageNum; // 要被排除的行数
String sql = "";
if (ruleValue == null) {
if (userBean.getLevel() == 0) {
sql = "SELECT * FROM t_node limit " + num + "," + perPageNum + "";
} else {
sql =
"SELECT * FROM t_node WHERE userId='"
+ userBean.getId()
+ "' limit "
+ num
+ ","
+ perPageNum
+ "";
}
} else {
if (userBean.getLevel() == 0) {
sql =
"SELECT * FROM t_node WHERE caseNodeId='"
+ ruleValue
+ "' limit "
+ num
+ ","
+ perPageNum
+ "";
} else {
sql =
"SELECT * FROM t_node WHERE caseNodeId='"
+ ruleValue
+ "' AND userId='"
+ userBean.getId()
+ "' limit "
+ num
+ ","
+ perPageNum
+ "";
}
}
return super.getBatchNode(sql);
}
public int getNodeTotalRow() {
String sql = "";
if (ruleValue == null) {
if (userBean.getLevel() == 0) {
sql = "SELECT COUNT(*) FROM t_node";
} else {
sql = "SELECT COUNT(*) FROM t_node WHERE userId='" + userBean.getId() + "'";
}
} else {
if (userBean.getLevel() == 0) {
sql = "SELECT COUNT(*) FROM t_node WHERE caseNodeId='" + ruleValue + "'";
} else {
sql =
"SELECT COUNT(*) FROM t_node WHERE caseNodeId='"
+ ruleValue
+ "' AND userId='"
+ userBean.getId()
+ "'";
}
}
return getVersion(sql);
}