public void query() throws ServletException, IOException {
HttpServletRequest request = Struts2Utils.getRequest();
List<TbBaseUserInfo> list = null;
List<PropertyFilter> filters =
HibernateWebUtils.buildPropertyFilters(Struts2Utils.getRequest());
GridServerHandler gridServerHandler =
new GridServerHandler(Struts2Utils.getRequest(), Struts2Utils.getResponse());
// 角色查询
String vcRoleNo = request.getParameter("role_search");
if (vcRoleNo != null && !vcRoleNo.equals("")) {
String vcUserNos = baseUserInfoManager.getUserIdByRoleId(vcRoleNo);
String[] vun = vcUserNos.split(",");
filters.add(new PropertyFilter("id", vun, MatchType.IN));
}
page.setOrderBy("id");
page.setOrder("desc");
page.setPageSize(gridServerHandler.getPageSize());
page.setPageNo(gridServerHandler.getPageInfo().getPageNum());
page = baseUserInfoManager.search(page, filters);
int totalRowNum = gridServerHandler.getTotalRowNum();
if (totalRowNum < 1) {
totalRowNum = page.getTotalCount();
gridServerHandler.setTotalRowNum(totalRowNum);
}
list = page.getResult();
gridServerHandler.setData(this.formatViewData(list));
Struts2Utils.renderJson(gridServerHandler.getLoadResponseText());
}
public void queryKey() throws ServletException, IOException {
GridServerHandler gridServerHandler =
new GridServerHandler(Struts2Utils.getRequest(), Struts2Utils.getResponse());
SortInfo si = gridServerHandler.getSingleSortInfo();
if (si != null) {
String order = si.getSortOrder();
if ("defaultsort".equals(order)) {
page.setOrder("desc");
page.setOrderBy("fullDate");
} else {
page.setOrder(order);
page.setOrderBy(MantoEyeUtils.getSortField(si.getFieldName()));
}
// 默认排序方式
} else {
page.setOrderBy("fullDate");
page.setOrder("desc");
}
page.setPageSize(gridServerHandler.getPageSize());
page.setPageNo(gridServerHandler.getPageInfo().getPageNum());
page = keywordsTacticsImpl.queryKey(page, id, startTime, endTime);
int totalRowNum = gridServerHandler.getTotalRowNum();
if (totalRowNum < 1) {
totalRowNum = page.getTotalCount();
gridServerHandler.setTotalRowNum(totalRowNum);
}
gridServerHandler.setData(page.getResult(), KeywordsDetail.class);
Struts2Utils.renderJson(gridServerHandler.getLoadResponseText());
}
/** 查询数据 */
public void query() throws ServletException, IOException {
List<CommonFlush> list = null;
GridServerHandler gridServerHandler =
new GridServerHandler(Struts2Utils.getRequest(), Struts2Utils.getResponse());
SortInfo si = gridServerHandler.getSingleSortInfo();
if (si != null) {
String order = si.getSortOrder();
if ("defaultsort".equals(order)) {
page.setOrder("desc");
page.setOrderBy("nmFlush");
} else {
page.setOrder(order);
page.setOrderBy(MantoEyeUtils.getSortField(si.getFieldName()));
}
// 默认排序方式
} else {
page.setOrderBy("nmFlush");
page.setOrder("desc");
}
page.setPageSize(gridServerHandler.getPageSize());
page.setPageNo(gridServerHandler.getPageInfo().getPageNum());
page =
spaceDistributeBusinessManager.query(
page,
Integer.parseInt(dataType_search),
Common.StringToInt(spaceLevel_search),
businessName,
Integer.parseInt(timeLevel_search),
time_search);
int totalRowNum = gridServerHandler.getTotalRowNum();
if (totalRowNum < 1) {
totalRowNum = page.getTotalCount();
gridServerHandler.setTotalRowNum(totalRowNum);
}
list = page.getResult();
gridServerHandler.setData(list, CommonFlush.class);
Struts2Utils.renderJson(gridServerHandler.getLoadResponseText());
}