private void appendOrderByBuffer(StringBuffer sqlBuf, Class objClass) throws Exception {
if (ClassTool.isNullObj(this.orderByBuf)) {
this.orderByBuf = new StringBuffer();
}
this.orderByBuf.trimToSize();
if (this.orderByBuf.length() > 0 || this.getPageDto() != null) {
if (this.orderByBuf.length() > 0) {
sqlBuf.append(" order by ");
sqlBuf.append(this.orderByBuf);
}
if (this.getPageDto() != null) {
DBTool.parseSortAndFilter(this.getPageDto());
if (!StringTool.isEmpty(this.getPageDto().getSort())) {
if (this.orderByBuf.length() == 0) {
sqlBuf.append(" order by ");
} else if (this.orderByBuf.length() > 0) {
sqlBuf.append(", ");
}
String sort =
ClassTool.getDBColumnNameByObjFieldName(objClass, this.getPageDto().getSort());
if (StringTool.isEmpty(sort)) {
sort = StringTool.translateToDBColumn(this.getPageDto().getSort());
}
sqlBuf.append(sort);
sqlBuf.append(" ");
sqlBuf.append(this.getPageDto().getDir());
}
}
}
}
private void appendWhereBuffer(StringBuffer sqlBuf) throws Exception {
if (ClassTool.isNullObj(this.whereBuf)) {
this.whereBuf = new StringBuffer();
}
this.whereBuf.trimToSize();
if (this.whereBuf.length() > 0 || this.getPageDto() != null) {
if (this.getPageDto() != null) {
DBTool.parseSortAndFilter(this.getPageDto());
if (!StringTool.isEmpty(this.getPageDto().getFilter())) {
this.getPageDto()
.setFilterOperator(
StringTool.isEmpty(
this.getPageDto().getFilterOperator(), GeneralConstants.EQUAL_MARK));
if (this.whereBuf.length() > 0) {
whereBuf.append(" and ");
}
whereBuf.append(this.getPageDto().getFilter());
whereBuf.append(" ");
if ("like".equalsIgnoreCase(this.getPageDto().getFilterOperator())) {
if (StringTool.isEmpty(this.getPageDto().getFilterValue().trim())) {
this.getPageDto().setFilterOperator(GeneralConstants.EQUAL_MARK);
}
}
whereBuf.append(this.getPageDto().getFilterOperator());
if ("like".equalsIgnoreCase(this.getPageDto().getFilterOperator())
|| "not like".equalsIgnoreCase(this.getPageDto().getFilterOperator())) {
whereBuf.append(" '%");
whereBuf.append(this.getPageDto().getFilterValue().trim());
whereBuf.append("%' and ");
whereBuf.append(this.getPageDto().getFilter());
whereBuf.append(" != ' ' ");
} else {
whereBuf.append(" '");
whereBuf.append(this.getPageDto().getFilterValue().trim());
whereBuf.append("'");
if (StringTool.isEmpty(this.getPageDto().getFilterValue().trim())) {
if (GeneralConstants.EQUAL_MARK.equals(this.getPageDto().getFilterOperator())) {
whereBuf.append(" or ");
whereBuf.append(this.getPageDto().getFilter());
whereBuf.append(" IS NULL ");
} else if (GeneralConstants.NOT_EQUAL_MARK.equals(
this.getPageDto().getFilterOperator())) {
whereBuf.append(" and ");
whereBuf.append(this.getPageDto().getFilter());
whereBuf.append(" IS NOT NULL ");
}
}
}
}
}
if (this.whereBuf.length() > 0) {
sqlBuf.append(" where ");
sqlBuf.append(this.whereBuf);
}
}
}
