摘要：頁面顯示前端代碼大箱碼關(guān)聯(lián)信息列表大箱碼關(guān)聯(lián)的箱碼不同箱碼用分號分開，相同箱碼用逗號分開關(guān)聯(lián)數(shù)量頁面切換動(dòng)作設(shè)置默認(rèn)的頁號設(shè)置默認(rèn)的每頁記錄數(shù)注意格式是，不是請求成功，將返回的數(shù)據(jù)一頁的記錄數(shù)綁定到控件總記錄個(gè)數(shù)獲取條數(shù)由于顯

  
                
  
                    
 
                         
大箱碼
                            
關(guān)聯(lián)的箱碼（不同箱碼用分號分開，相同箱碼用逗號分開）
                         
關(guān)聯(lián)數(shù)量
                     
  
                
  
                
  
                
             
  
            
             

 function getDataByPageRows(pageNum, rowsLimit){  
        $("#pp").show();
               pageNum = pageNum || 1;     // 設(shè)置默認(rèn)的頁號  
               rowsLimit = rowsLimit || 2;// 設(shè)置默認(rèn)的每頁記錄數(shù)  
               $.ajax({  
                   type: "POST",  
                   dataType: "json",       // 注意格式是html，不是json  
                   url:"<%=basePath%>outdata/querydetaillist",
                   data: {  
                       startdate: $("#startdate").datetimebox("getValue"),
                       enddate: $("#enddate").datetimebox("getValue"),
                       storecode: $("#storecode").val(),
                       page: pageNum,
                       rows: rowsLimit
                   },  
                   success: function(data){   // 請求成功，將返回的數(shù)據(jù)（一頁的記錄數(shù)）綁定到 datagrid控件  
                       var count = data.total;   // 總記錄個(gè)數(shù)  
                       var datarow = data.rows;  //獲取條數(shù)；
                       $("#dgs").datagrid("loadData",datarow);  
                       $("#pp").pagination({  
                           total: count,           // 由于顯示 ”共XXX條記錄” 等信息用  
                           pageNumber: pageNum    //   
                       });  
                   }  
               });//ajax         
           }

@RequestMapping(value="/querydetaillist")
    @ResponseBody
    public String querydetaillist(Model model,HttpServletResponse response,HttpServletRequest request,
            @RequestParam(value = "page", required = false, defaultValue = "") String page,
            @RequestParam(value = "storecode", required = false, defaultValue = "") String storecode,
            @RequestParam(value = "startdate", required = false, defaultValue = "") String startdate,
            @RequestParam(value = "enddate", required = false, defaultValue = "") String enddate,
            @RequestParam(value = "rows", required = false, 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();
    }

          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,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
        )
    

easyui 中文網(wǎng):http://www.jeasyui.net/plugin...
oracle多行合并成一行: listagg within group:http://blog.csdn.net/baojiang...