• map的使用


     /**
         * 查询条件下拉框列表数据与新增页面下拉列表查询
         */
        public Map <String, Object> selectList(QhyfController ctl) throws ActiveRecordException {
            Page <BizApproveSayingInfo> BizApproveSayingInfoPage = null;
            List <Object> paras = new ArrayList <Object>();
            List <Record> enterpriseList = null;
            List <Record> institutionsList = null;
            List <Record> bodyList = null;
            /*List<Record> fileList = null;
            List<Record> approveList=null;*/
            List <Record> fileNameList = null;
            List<Record> uuidList=null;
            Map <String, Object> recordData = null;
            //获取核心企业
            String enterpriseSql = "select uuid AS core_enterprise_id, core_enterprise_name from biz_core_enterprise where sys_status = 1 ";
            enterpriseList = Db.find(enterpriseSql);
            // 获取金融机构数据表信息
            String institutionsSql = "select uuid AS financial_institutions_id, financial_institutions_name from biz_financial_institutions where sys_status = 1 ";
            institutionsList = Db.find(institutionsSql);
            // 获取签约主体数据表信息
            String bodySql = "select uuid AS signing_body_id, sign_body_name from biz_signing_body where sys_status = 1 ";
            bodyList = Db.find(bodySql);
            // 类别
        /*    String fileSql = " select DICT_ID AS file_type_id, DICT_NAME AS file_type_name from sys_dict_entry where DICT_TYPE_ID = 'biz_file_type' and sys_status = 1 ";
            fileList = Db.find(fileSql);
            //获取审核类别
            String approveSql=" select DICT_ID AS approve_type_id,DICT_NAME AS approve_type_name from sys_dict_entry where DICT_TYPE_ID = 'biz_approve_type' and sys_status = 1 ";
            approveList=Db.find(approveSql);*/
            //获取文件名
            String fileNameSql = " SELECT DISTINCT " +
                    " b.uuid AS file_id, " +
                    " b.file_name " +
                    "FROM " +
                    " biz_fullset_file_info a, " +
                    " biz_document_define b " +
                    "WHERE " +
                    " a.sys_status = 1 " +
                    "AND b.sys_status = 1 " +
                    "AND a.file_id = b.uuid " +
                    "AND a.file_type = '03' " +
                    "and a.approve_type = '11' ";
            fileNameList = Db.find(fileNameSql);
            recordData = new HashMap <String, Object>();
            recordData.put("enterpriseList", enterpriseList);
            recordData.put("institutionsList", institutionsList);
            recordData.put("bodyList", bodyList);
        /*    recordData.put("fileList", fileList);
            recordData.put("approveList", approveList);*/
    
            recordData.put("fileNameList", fileNameList);
            return recordData;
        }
                    //为下拉列表赋值
                    ajax_jsonp("/app/bl/bizapprovesaying/datalist/", null,
                        function (response) {
                            //核心企业数据表信息
                            $.each(response.data[0].enterpriseList, function (index, value) {
                                queryDiv.find("#coreEnterpriseName").append("<option value='" + value.coreEnterpriseId +
                                    "'>" + value.coreEnterpriseName + "</option>");
                            });
                            //签约主体数据表信息
                            $.each(response.data[0].bodyList, function (index, value) {
                                queryDiv.find("#signBodyName").append("<option value='" + value.signingBodyId +
                                    "'>" + value.signBodyName + "</option>");
                            });
                            //金融机构数据表信息
                            $.each(response.data[0].institutionsList, function (index, value) {
                                queryDiv.find("#financialInstitutionsName").append("<option value='" + value.financialInstitutionsId +
                                    "'>" + value.financialInstitutionsName + "</option>");
                            });
                            $.each(response.data[0].fileNameList, function (index, value) {
                                queryDiv.find("#fileName").append("<option value='" + value.fileId +
                                    "'>" + value.fileName + "</option>");
                            });
                            /* //类别
                             $.each(response.data[0].fileList, function (index, value) {
                                 queryDiv.find("#fileType").append("<option value='" + value.fileTypeId +
                                     "'>" + value.fileTypeName + "</option>");
                             });
    
                             //审核类别
                             $.each(response.data[0].approveList, function (index, value) {
                                 queryDiv.find("#approveType").append("<option value='" + value.approveTypeId +
                                     "'>" + value.approveTypeName + "</option>");
                             });*/
    
    
                            //为编辑下拉框赋值
                            if (isNotNull(initData)) {
                                var response = ajax_jsonp_sync("/app/bl/bizapprovesaying/compile/", {"uuid": initData.uuid},"GET",null)
                                var info = response.responseJSON.data[0];
                                //将数据显示到指定区域
                                $.each(info, function (key, val) {
                                    var element = $("#bizApproveSayingEditAdminForm").find("textarea[id='" + key
                                        + "']");
                                    if (isNotEmptyDOM(element))
                                        setInputVal(element, val);
                                });
                                debugger
                                $("#bizApproveSayingEditAdminForm").find("#coreEnterpriseName").find("option[value='" + response.responseJSON.data[0].coreEnterpriseId + "']").attr("selected", true);
                                $("#bizApproveSayingEditAdminForm").find("#financialInstitutionsName").find("option[value='" + response.responseJSON.data[0].financialInstitutionsId + "']").attr("selected", true);
                                $("#bizApproveSayingEditAdminForm").find("#signBodyName").find("option[value='" + response.responseJSON.data[0].signingBodyId + "']").attr("selected", true);
                                $("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + response.responseJSON.data[0].fileId + "']").attr("selected", true);
    
                                        //   $("#bizApproveSayingEditAdminForm").find("#fileType").find("option[value='"+response.data[0].fileType+"']").attr("selected",true);
                                        // $("#bizApproveSayingEditAdminForm").find("#approveType").find("option[value='"+response.data[0].approveType+"']").attr("selected",true);
    
                                $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val(response.responseJSON.data[0].fileId);
                                var saying = $("#bizApproveSayingEditAdminForm").find("#saying").val();
                                        if(saying != null && saying != ""){
                                            var res = ajax_jsonp_sync("/app/bl/bizapprovesaying/querydata/", {"saying": saying},"GET",null)
                                            $("#bizApproveSayingEditAdminForm").find("#cuuid").val(res.responseJSON.data[0].uuid);
                                        }
                            }
    
                        }, null, "GET");
    
    
    
                    // 核心企业选择后,文件名需要联动选择
                    queryDiv.find("#coreEnterpriseName").on("change", function () {
                        //获取当前选中核心企业的值
                        var val = $(this).val();
                        if (!val) {
                            return;
                        }
                        //文件名信息显示
                        ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
                            {
                                "coreEnterpriseId": val,
                                "financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
                                "signingBodyId": queryDiv.find("#signBodyName").val(),
                                // "fileType": queryDiv.find("#fileType").val(),
                                // "approveType": queryDiv.find("#approveType").val()
                            }, function (response) {
                                if (!checkResponseData(response)
                                    || !isNotNull(response.data[0]))
                                    return;
                                //清空文件名下拉选框的值
                                queryDiv.find("#fileName").empty();
                                addOption(queryDiv.find("#fileName"), "请选择...", "");
                                //文件名
                                $.each(response.data[0].filenList, function (index, value) {
                                    queryDiv.find("#fileName").append("<option value='" + value.fileId +
                                        "'>" + value.fileName + "</option>");
                                });
                                $("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
                            }, null, "GET");
                    });
    
                    // 金融机构选择后,文件名需要联动选择
                    queryDiv.find("#financialInstitutionsName").on("change", function () {
                        //获取当前选中金融机构的值
                        var val = $(this).val();
                        if (!val) {
                            return;
                        }
                        //文件名信息显示
                        ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
                            {
                                "coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
                                "financialInstitutionsId": val,
                                "signingBodyId": queryDiv.find("#signBodyName").val(),
                                //  "fileType": queryDiv.find("#fileType").val(),
                                // "approveType": queryDiv.find("#approveType").val()
                            }, function (response) {
                                if (!checkResponseData(response)
                                    || !isNotNull(response.data[0]))
                                    return;
                                //清空文件名下拉选框的值
                                queryDiv.find("#fileName").empty();
                                addOption(queryDiv.find("#fileName"), "请选择...", "");
                                //文件名
                                $.each(response.data[0].filenList, function (index, value) {
                                    queryDiv.find("#fileName").append("<option value='" + value.fileId +
                                        "'>" + value.fileName + "</option>");
                                });
                                $("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
                            }, null, "GET");
                    });
    
                    // 签约主体选择后,文件名需要联动选择
                    queryDiv.find("#signBodyName").on("change", function () {
                        //获取当前选中签约主体的值
                        var val = $(this).val();
                        if (!val) {
                            return;
                        }
                        //文件名信息显示
                        ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
                            {
                                "coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
                                "financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
                                "signingBodyId": val,
                                // "fileType": queryDiv.find("#fileType").val(),
                                // "approveType": queryDiv.find("#approveType").val()
                            }, function (response) {
                                if (!checkResponseData(response)
                                    || !isNotNull(response.data[0]))
                                    return;
                                //清空文件名下拉选框的值
                                queryDiv.find("#fileName").empty();
                                addOption(queryDiv.find("#fileName"), "请选择...", "");
                                //文件名
                                $.each(response.data[0].filenList, function (index, value) {
                                    queryDiv.find("#fileName").append("<option value='" + value.fileId +
                                        "'>" + value.fileName + "</option>");
                                });
                                $("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
                            }, null, "GET");
                    });
                    // 文件类别选择后,文件名需要联动选择
                    queryDiv.find("#fileType").on("change", function () {
                        //获取当前选中文件类别的值
                        var val = $(this).val();
                        if (!val) {
                            return;
                        }
                        //类别选择
                        if (val == '01' || val == '03') {
                            queryDiv.find("#approveTypeDiv").css("display", "block");
                        } else {
                            queryDiv.find("#approveTypeDiv").css("display", "none");
                        }
                        //文件名信息显示
                        ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
                            {
                                "coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
                                "financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
                                "signingBodyId": queryDiv.find("#signBodyName").val(),
                                "fileType": val,
                                "approveType": queryDiv.find("#approveType").val()
                            }, function (response) {
                                if (!checkResponseData(response)
                                    || !isNotNull(response.data[0]))
                                    return;
                                //清空文件名下拉选框的值
                                queryDiv.find("#fileName").empty();
                                addOption(queryDiv.find("#fileName"), "请选择...", "");
                                //文件名
                                $.each(response.data[0].filenList, function (index, value) {
                                    queryDiv.find("#fileName").append("<option value='" + value.fileId +
                                        "'>" + value.fileName + "</option>");
                                });
                                $("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
                            }, null, "GET");
                    });
    
                    // 审核类别选择后,文件名需要联动选择
                    queryDiv.find("#approveType").on("change", function () {
                        //获取当前选中审核类别的值
                        var val = $(this).val();
                        if (!val) {
                            return;
                        }
                        //文件名信息显示
                        ajax_jsonp("app/bl/bizapprovesaying/getFileNameList",
                            {
                                "coreEnterpriseId": queryDiv.find("#coreEnterpriseName").val(),
                                "financialInstitutionsId": queryDiv.find("#financialInstitutionsName").val(),
                                "signingBodyId": queryDiv.find("#signBodyName").val(),
                                "fileType": queryDiv.find("#fileType").val(),
                                "approveType": val
                            }, function (response) {
                                if (!checkResponseData(response)
                                    || !isNotNull(response.data[0]))
                                    return;
                                //清空文件名下拉选框的值
                                queryDiv.find("#fileName").empty();
                                addOption(queryDiv.find("#fileName"), "请选择...", "");
                                //文件名
                                $.each(response.data[0].filenList, function (index, value) {
                                    queryDiv.find("#fileName").append("<option value='" + value.fileId +
                                        "'>" + value.fileName + "</option>");
                                });
                                $("#bizApproveSayingEditAdminForm").find("#fileName").find("option[value='" + $("#bizApproveSayingEditAdminForm").find("#fileNameHidden").val() + "']").attr("selected", true);
                            }, null, "GET");
    
                    });
    
    
                },//init() END
  • 相关阅读:
    linux系统调优工具
    搭建ceph分布式文件系统
    ansible管理windows主机
    jenkins结合ansible发布
    Linux系统安全配置
    tomcat 的安全配置预防后台被攻击
    【9】添加主页日志列表展示
    【8】添加新建/编辑博客逻辑
    【7】使用css/js/html模板来实现一个注册、登录和管理的功能
    Ubuntu下给Sublime Text 3添加用python3运行文件
  • 原文地址:https://www.cnblogs.com/xiaoniuniu886/p/9550470.html
Copyright © 2020-2023  润新知