easyui combobox 下拉框后台列表查询

最新推荐文章于 2021-03-19 14:29:15 发布

原创最新推荐文章于 2021-03-19 14:29:15 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

编程技术同时被 2 个专栏收录

107 篇文章

订阅专栏

easyui

27 篇文章

订阅专栏

本文介绍了一种使用Action类进行合同号查询并将其与前端组件结合，实现动态选择和显示合同号的方法。包括SQL查询、JS操作DOM元素及数据绑定等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

action 类：

     public String findContractNo() {
        DataResponse dataResponse = new DataResponse();
        List<Map<String, Object>> list = contractInvoiceService
                .findContractNo();
        if (list == null) {
            list = new ArrayList<Map<String, Object>>();
        }
        List<Map<String, Object>> listCombox = new ArrayList<Map<String, Object>>();
        if (list.size() > 0) {
            for (int i = 0; i < list.size(); i++) {
                Map<String, Object> map = list.get(i);
                map.put("contractNo", map.get("contractNo"));
                listCombox.add(map);
            }
        }
        dataResponse.setRows(listCombox);
        setJsonString(dataResponse.toString());
        return SUCCESS;
    }

js:

$('#cont').combobox({
        url : base+"/desktop/cs/contract-invoice/findContractNo.action?t=" + new Date().getTime(),
        mode : 'remote',
        panelHeight:"auto",
        valueField:"id",
        textField:"contractNo",
        loadFilter : function(data) {
            return data.rows;
        },
        onSelect:function(rec){
             var tr_id = $('#cont').combobox('getValue');

             var val = $('#cont').combobox('getText');
             var split = val.split("-");
                 for(var i = 0;i<split.length;i++){
                     $('#'+contrNo).val(split[0]);
                     $('#'+res_id).val(split[1]);
                     $('#'+hisp_id).val(split[2]);
                     $('#'+doctor).val(split[3]);
                     $('#'+depment_id).val(split[4]);
                     $('#'+emplyee_id).val(split[5]);
                 };
           }
      });

jsp:


 <td align="right" style="width:2400px" ><label><b>添加合同号</b></label></td>
                        <td colspan='14' align="left"><input type="text" id="cont" name="cont" style="width:600px;height:20px;border: 1px solid #a4bed4"/></td>
                    </tr>

sql:

SELECT con.id,CONCAT(con.contract_no,'-',con.name,'-',ch.name,'-',cdr.name,'-',cd.name,'-',ie.name) as contractNo
        from contract con
        LEFT JOIN crm_department cd
        on con.dept_id = cd.id
         LEFT JOIN crm_hospital ch
        on ch.id = cd.hospital_id
        left join crm_doctor cdr
           on con.customer_id = cdr.id
            left join  id_employee ie
        on con.employee_id =ie.id