优化树形导出excel

fs-danaus

2024-01-06 8c3a7d13ae0ea179545f9c49ff2d240add266974

 src/com/yc/app/v2/controller/APPController.java

@@ -219,10 +219,15 @@
     * @return
     */
    @RequestMapping(value = "/get9686.do")
    @CrossOrigin
    public @ResponseBody Object get9686List(HttpServletRequest request, HttpServletResponse response){
        CallBackMessage callBackMessage=new CallBackMessage();
        try {
            SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)+"");
            if(request!=null&&request.getSession()!=null&&request.getSession().getAttribute(SessionKey.DATA_BASE_ID)!=null) {
                SpObserver.setDBtoInstance("_" + request.getSession().getAttribute(SessionKey.DATA_BASE_ID) + "");
            }else {
                SpObserver.setDBtoInstance("_338");//固定取值，不需要登录
            }
            BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
            List list=  baseService.getJdbcTemplate().queryForList("select ColorName,HexColorValue from t9686 order by SortBy asc");
            callBackMessage.setInfo(list);