提交选中的:materialTypes是一个list
if (materialTypes != null && materialTypes.size() > 0) {
hql += " and ( 1=1 ";
for (int i = 0; i < materialTypes.size(); i++) {
if (materialTypes.get(i).getSelected() == 1) {
if (i == materialTypes.size() - 1) {
hql += " and c.materialType = :materialType" + i;
parameterMap.put("materialType" + i, materialTypes
.get(i).getTypeClass());
} else {
hql += " and c.materialType = :materialType" + i
+ " or ";
parameterMap.put("materialType" + i, materialTypes
.get(i).getTypeClass());
}
}
}
hql += ")";
}
提交全部:shelfs为一个list
if (shelfs != null && shelfs.size() > 0) {
hql += " and ( 1=1 ";
for (int i = 0,j=0; i < shelfs.size(); i++) {
if (shelfs.get(i).getSelected() == 1) {
if (j == 0) {
hql += " and a.shelfId = :shelfId" + i;
parameterMap.put("shelfId" + i, shelfs.get(i)
.getId());
j++;
} else {
hql += " or a.shelfId = :shelfId" + i;
parameterMap.put("shelfId" + i, shelfs.get(i)
.getId());
}
}
}
hql += ")";
}