public String list(){

      try {

          LoginUser loginUser = getLoginUser();//获取当前登录用户

          if(curpage<=0){

              curpage=1;

          }

          pagesize=15;

          RunParam runParam = runParamService.getTzrqrq();

          if(faccountDate == null){

             faccountDate = runParam.getfItemDouDate();

             if(faccountDate == null){

                 faccountDate = MyUtils.nowYmDate();

             }

         }

         String s1=faccountDate.substring(0, 4);

         String s2=faccountDate.substring(5, 7);

         s1+=s2;

            String sql = "SELECT FContainerNO,FHappenCompanyNO,FHappenCompanyName,FContainerTypeNO,FContainerTypeName,";

                     sql += "FContainerName,FAccountDate,SUM(FQuantity_K) AS FQuantity_K,SUM(FQuantity_QC) AS FQuantity_QC,SUM(FQuantity_RK) AS FQuantity_RK,SUM(FQuantity_CK) AS FQuantity_CK,";

                     sql += "SUM(FQuantity_BS) AS FQuantity_BS,SUM(FQuantity_FX) AS FQuantity_FX,SUM(FQuantity_PC) AS FQuantity_PC FROM V_Bus_StoConAIAOAcc";

                     sql += " WHERE FAccountDate='"+s1+"'";

                     if(fhappenCompanyNO!=null&&!"".equals(fhappenCompanyNO)){

                         sql+=" and FHappenCompanyNO='"+fhappenCompanyNO+"'or FHappenCompanyName='"+fhappenCompanyNO+"'";

                     }

                     if("2".equals(loginUser.getUserType())){

                         sql+=" and FHappenCompanyNO='"+loginUser.getSupplierCode()+"'";

                     }

                     if(fcontainerNO!=null&&!"".equals(fcontainerNO)){

                         sql+=" and FContainerNO='"+fcontainerNO+"' or FContainerName='"+fcontainerNO+"'";

                     }

                     sql += " GROUP BY FContainerTypeNO,FContainerTypeName,FHappenCompanyNO,FHappenCompanyName,FContainerNO,FContainerName,FAccountDate ";

                     sql += " ORDER BY FHappenCompanyNO,FContainerTypeNO,FContainerNO ";

                    // sql = " SELECT TOP "+15 +" og.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY FHappenCompanyNO,FContainerTypeNO,FContainerNO) AS rownumber,o.* FROM ("+sql+") AS o) AS og WHERE og.rownumber>"+pagesize*(curpage-1);

                 stoConAIAOAccList = dbHelper.query(sql);

                 List<StoConAIAOAcc> list=new ArrayList<StoConAIAOAcc>();

                 int i=1;

                 for(Map map:stoConAIAOAccList){

                     if(i>pagesize*(curpage-1)&&i<=pagesize*curpage){

                         StoConAIAOAcc stoConAIAOAcc=new StoConAIAOAcc();

                         stoConAIAOAcc.setFcontainerNO(map.get("FContainerNO")==null?"":map.get("FContainerNO").toString());

                         stoConAIAOAcc.setFcontainerName(map.get("FContainerName")==null?"":map.get("FContainerName").toString());

                         stoConAIAOAcc.setFhappenComNO(map.get("FHappenCompanyNO")==null?"":map.get("FHappenCompanyNO").toString());

                         stoConAIAOAcc.setFhappenComName(map.get("FHappenCompanyName")==null?"":map.get("FHappenCompanyName").toString());

                         stoConAIAOAcc.setFcontainerTypeNO(map.get("FContainerTypeNO")==null?"":map.get("FContainerTypeNO").toString());

                         stoConAIAOAcc.setFcontainerTypeName(map.get("FContainerTypeName")==null?"":map.get("FContainerTypeName").toString());

                         stoConAIAOAcc.setFaccountDate(map.get("FAccountDate")==null?"":map.get("FAccountDate").toString());

                         stoConAIAOAcc.setFquantityk(map.get("FQuantity_K")==null?"":map.get("FQuantity_K").toString());

                         stoConAIAOAcc.setFquantityQC(map.get("FQuantity_QC")==null?"":map.get("FQuantity_QC").toString());

                         stoConAIAOAcc.setFquantityRK(map.get("FQuantity_RK")==null?"":map.get("FQuantity_RK").toString());

                         stoConAIAOAcc.setFquantityCK(map.get("FQuantity_CK")==null?"":map.get("FQuantity_CK").toString());

                         stoConAIAOAcc.setFquantityBS(map.get("FQuantity_BS")==null?"":map.get("FQuantity_BS").toString());

                         stoConAIAOAcc.setFquantityFX(map.get("FQuantity_FX")==null?"":map.get("FQuantity_FX").toString());

                         stoConAIAOAcc.setFquantityPC(map.get("FQuantity_PC")==null?"":map.get("FQuantity_PC").toString());

                         list.add(stoConAIAOAcc);

                     }

                     i++;

                 }

                 PageModel<StoConAIAOAcc> stoConAIAOAccPage1=new PageModel<StoConAIAOAcc>();

                 stoConAIAOAccPage1.setReList(list);

                 stoConAIAOAccPage1.setCurPage(curpage);

                 stoConAIAOAccPage1.setPerindex(curpage>1?(curpage-1):-1);

                 stoConAIAOAccPage1.setNextindex(curpage<(stoConAIAOAccList.size()%pagesize>0?(stoConAIAOAccList.size()/pagesize+1):(stoConAIAOAccList.size()/pagesize))?(curpage+1):-1);

                 stoConAIAOAccPage1.setItemCount(stoConAIAOAccList.size());

                 stoConAIAOAccPage1.setTotalPage(stoConAIAOAccList.size()%pagesize>0?(stoConAIAOAccList.size()/pagesize+1):(stoConAIAOAccList.size()/pagesize));

                 stoConAIAOAccPage1.setPageSize(pagesize);

                 stoConAIAOAccPage=stoConAIAOAccPage1;

          supplierList = supplierService.getAllIsp();

         } catch (Exception e) {

             e.printStackTrace();

         }

             return "stoConAIAOAccList";

  }