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
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步