easyUI的不同部门查看不同的信息sql语句和总结

 今天老大安排了一个工作，把之前我写的业务优化一遍、查看时候不同部门查看不同的部门信息，好了开始上代码

// -   查询所有帖子 （不同部门不同信息）根据创建时间降序排列
	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: '',

 总结完毕