/**
* 设置ge(>=)查询条件
*
* @param keyname
* @param keyvalue1
* @param keyvalue2
*/
public void ge(String keyname, Object keyvalue) {
if (keyvalue != null && keyvalue != "") {
criterionList.addPara(Restrictions.ge(keyname, keyvalue));
if (flag) {
this.put(keyname, keyvalue);
}
flag = true;
}
}
/**
* 设置like(模糊)查询条件
*
* @param keyname
* @param keyvalue1
* @param keyvalue2
*/
public void like(String keyname, Object keyvalue) {
if (keyvalue != null && keyvalue != "") {
// criterionList.addPara(Restrictions.like(keyname, "%" + keyvalue+ "%"));
criterionList.addPara(Restrictions.like(keyname, keyvalue));
if (flag) {
this.put(keyname, keyvalue);
}
flag = true;
}
}
/**
* 加载dataTables 默认查询条件
*
* @param dataTables
*/
public void addJqCriteria(DataTables dataTables) {
String search = dataTables.getSearch(); // 查询关键字
SortInfo[] sortInfo = dataTables.getSortColumns(); // 排序字段
String[] sColumns = dataTables.getsColumns().split(","); // 字段
if (StringUtil.isNotEmpty(search)) {
for (String string : sColumns) {
if (string.indexOf("_") == -1) {
jqcriterionList.addPara(Restrictions.like(string, "%" + search + "%"));
}
}
add(getOrCriterion(jqcriterionList));
}
if (sortInfo.length > 0) {
for (SortInfo sortInfo2 : sortInfo) {
addOrder("" + sColumns[sortInfo2.getColumnId()] + "", sortInfo2.getSortOrder());
}
}
}
/**
* 设置isNull查询条件
*
* @param keyname
* @param keyvalue1
* @param keyvalue2
*/
public void isNotNull(String keyname) {
criterionList.addPara(Restrictions.isNotNull(keyname));
}
/**
* 设置in(包含)查询条件
*
* @param keyname
* @param keyvalue1
* @param keyvalue2
*/
public void in(String keyname, Object[] keyvalue) {
if (keyvalue != null && keyvalue[0] != "") {
criterionList.addPara(Restrictions.in(keyname, keyvalue));
}
}
