easyui一行显示多行_easyui datagrid以及oracle中的多行合并一行

前端代码:

toolbar="#toolbar" rownumbers="true" singleSelect="true" fitColumns="true">

大箱码关联的箱码(不同箱码用分号分开，相同箱码用逗号分开)关联数量

data-options="

total: 0,pageSize:15,pageList: [15,30,50,100],onSelectPage: function(pageNumber,pageSize){ // 页面切换动作

getDataByPageRows(pageNumber,pageSize);

}">

js:

function getDataByPageRows(pageNum,rowsLimit){

$("#pp").show();

pageNum = pageNum || 1; // 设置默认的页号

rowsLimit = rowsLimit || 2;// 设置默认的每页记录数

$.ajax({

type: "POST",dataType: 'json',// 注意格式是html，不是json

url:"outdata/querydetaillist",data: {

startdate: $("#startdate").datetimeBox('getValue'),enddate: $("#enddate").datetimeBox('getValue'),storecode: $("#storecode").val(),page: pageNum,rows: rowsLimit

},success: function(data){ // 请求成功，将返回的数据(一页的记录数)绑定到 datagrid控件

var count = data.total; // 总记录个数

var datarow = data.rows; //获取条数；

$('#dgs').datagrid('loadData',datarow);

$('#pp').pagination({

total: count,// 由于显示 ”共XXX条记录” 等信息用

pageNumber: pageNum //

});

}

});//ajax

}

controller:

@RequestMapping(value="/querydetaillist")

@ResponseBody

public String querydetaillist(Model model,HttpServletResponse response,HttpServletRequest request,@RequestParam(value = "page",required = false,defaultValue = "") String page,@RequestParam(value = "storecode",defaultValue = "") String storecode,@RequestParam(value = "startdate",defaultValue = "") String startdate,@RequestParam(value = "enddate",defaultValue = "") String enddate,@RequestParam(value = "rows",defaultValue = "") String rows){

int endindex=Integer.valueOf(page)*Integer.valueOf(rows);

int startindex=(Integer.valueOf(page)-1)*Integer.valueOf(rows);

Map params = new HashMap();

if(!storecode.equals("")){

storecode = storecode.replaceFirst("^0*","");

}

if(!startdate.equals("")){

startdate = startdate.replaceAll(" ","");

}

if(!enddate.equals("")){

enddate = enddate.replaceAll(" ","");

}

params.put("endIndex",endindex);

params.put("storecode",storecode);

params.put("startIndex",startindex);

params.put("startdate",startdate);

params.put("enddate",enddate);

List datalist=outdataDao.querydetaillist(params);

String total=outdataDao.querydetaillistcount(params);

JSONObject obj=new JSONObject();

obj.put("total",total);

obj.put("rows",datalist);

return obj.toJSONString();

}

xml:

select * from (

select tt1.*,ROWNUM as rowno

from (

select storecode,listagg(casecode,';') within group (order by casecode) as casecode,count(casecode) as "count" from

(

select s.storecode,c.caseid,listagg(c.casecode,',') within group (order by c.casecode,c.caseid) as casecode,count(distinct caseid)

from ys_store s

left join ys_case c on s.id=c.storeid

where 1=1 and casecode is not null

and to_char(s.gldate,'yyyy-MM-dd')>='${startdate}'

and to_char(s.gldate,'yyyy-MM-dd')<='${enddate}'

and s.storecode=${storecode}

group by s.storecode,c.caseid

)

group by storecode

) tt1

where ROWNUM <= '${endIndex}') tt2

where tt2.rowno > '${startIndex}'

select count(*) from(

select storecode,c.caseid

)

group by storecode

)

参考文档:

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

如您喜欢交流学习经验，点击链接加入交流1群：1065694478(已满)交流2群：163560250