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());
}
}
}
}
