jeecg 自定义datagurid

public DataGrid findData(DataGrid dataGrid, String name, String jobid) {
// TODO Auto-generated method stub
// 查询条件组装器
int firstResult = (dataGrid.getPage() - 1) * dataGrid.getRows();
// 获取当前的登录对象
TSUser u = ResourceUtil.getSessionUserName();
// List list = new ArrayList();
// String sql = "select b.ry_id,b.ry_mc as rymc,b.ssfy,b.xt_lx as xtlx,b.xt_id as xtid from JC_GZRY b order by b.modify_time desc";
String sql = "select t.id,t.realname,t.userkey,t.username,t.departid,t.jobid from t_s_base_user t where t.jobid = 2";
if(StringUtil.isNotEmpty(name) ){
sql = sql +" and t.username like '%"+name+"%'";
}
if(StringUtil.isNotEmpty(jobid) ){
sql = sql +" and t.jobid = "+jobid;
}

sql = sql + " order by t.jobid asc";
List list = getSession().createSQLQuery(sql)
.setFirstResult(firstResult).setMaxResults(dataGrid.getRows())
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
dataGrid.setResults(list);
//计算条数，分页
List count = getSession().createSQLQuery(sql).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();


/* String sqlCount = "select count(*) from JC_GZRY";
List count = getSession().createSQLQuery(sqlCount).list();*/
if (count != null) {
dataGrid.setTotal(count.size());
}
return dataGrid;

}


@RequestMapping(params = "importUserForm")
public void importUserForm(HttpServletRequest req,HttpServletResponse response, DataGrid dataGrid) {
String name = req.getParameter("username");
String jobid = req.getParameter("jobid"); 
DataGrid findData = userService.findData(dataGrid,name,jobid);

TagUtil.datagrid(response, findData);
}