今天老大安排了一个工作,把之前我写的业务优化一遍、查看时候不同部门查看不同的部门信息,好了开始上代码
// - 查询所有帖子 (不同部门不同信息)根据创建时间降序排列
List<MessPublish> findAllMessI(@Param("begin")Integer bigin,@Param("end")Integer end,@Param("corpId")String corpId);
mapper文件
<!-- 分页查询所有类型的帖子(含通过未通过的)不同部门不同信息。根据创建时间降序排列。 -->
<select id="findAllMessI" resultType="MessPublish">
select mess.* from (select ROW_NUMBER() over(order by
CreateTime desc) row_num,* from Mes_publish) mess where row_num between #{begin} and #{end} and CorpID=#{corpId}
order by mess.CheckState;
</select>
业务层代码
//查询所有帖子(含通过和未通过和不同部门不同信息)
List<MessPublish> findAllI(Integer pageNumber,Integer pageSize,String corpId);
业务实现层代码
// 查询所有类型通过审核的
@Override
public List<MessPublish> findAllI(Integer pageNumber, Integer pageSize,String corpId) {
int begin = pageNumber * pageSize - pageSize + 1;
int end = pageNumber * pageSize;
List<MessPublish> findAllListI = mapper.findAllMessI(begin,end,corpId);
return findAllListI;
}
控制层代码
@RequestMapping("getMessDatagridI")
@ResponseBody
public String getMessDatagrid1(@RequestParam(value="title",required=false)String title,@RequestParam(value="pageNumber",required=false) Integer pageNumber,@RequestParam(value = "pageSize",required=false)Integer pageSize,
@RequestParam(value="corpId",required=false)String corpId){
pageNumber = (pageNumber == null) ? 1:pageNumber;
pageSize = (pageSize == null) ? 10:pageSize;
List<MessPublish> list =null;
if(null != title)
list = messPubservice.findByTitle(title);
else
list = messPubservice.findAllI(pageNumber, pageSize,corpId);
String json ="";
int total =messPubservice.total();
Map map = new HashMap<String,Object>();
map.put("total", total);
map.put("rows", list);
json = JSONObject.fromObject(map).toString();
return json;
前段jsp代码
var initMessDatagrid = function(){
var corpId ="${sessionScope.user.corpID}";
$('#MessPubList').datagrid({
fitColumns:true,
striped:true,
idField:'id',
rownumbers:true,
singleSelect:true,
pagination:true,
url:'<%=basePath%>/messPub/getMessDatagridI?corpId='+corpId,
title: '',
总结完毕