Jeecg 自定义查询条件 Input 及 datagrid 表格带参刷新

╰半橙微兮° 2024-04-18 19:47 67阅读 0赞

根据需求 ，原本的t:datagrid 标签封装的查询 条件满足不了，所有自己自定义了查询 ，因为jeecg 封装的有点狠，一时毫无头绪。所以自定义了 查询条件。

重要一点还是操作：esayui 的 datagrid

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
    <%@include file="/context/mytags.jsp" %>
    <t:base type="jquery,easyui,tools,DatePicker"></t:base>
    <div style="width:1300px; height: 90px">
        <table style="position: center; margin: 0px, 20px, 16px, 48px; position: relative; left: 5px; top: 20px;">
            <tr>
                <td style="width: 250px">
                    <div class="form">
                        <label class="Validform_label">网站url：</label>
                        <input type="text" id="url" name="url">
                    </div>
                </td>
                <td style="width: 250px">
                    <div class="form">
                        <label class="Validform_label">网站名称：</label>
                        <input type="text" id="urlName" name="urlName">
                    </div>
                </td>
    
                <td style="width: 250px">
                    <div class="form">
                        <label class="Validform_label">网站类型：</label>
                        <input type="text" id="urlType" name="urlType">
                    </div>
                </td>
                <td style="width: 300px">
                    <div class="form">
                        <label class="Validform_label">统一社会信用代码：</label>
                        <input type="text" id="uscCode" name="uscCode">
                    </div>
                </td>
    
    
                <td style="width: 200px">
                    <a href="#" class="easyui-linkbutton" plain="true"
                       icon="icon-search" id="departSearch"
                       οnclick="SelectResult()">查询</a>
                    <a href="#" class="easyui-linkbutton" plain="true"
                       icon="icon-redo" id="departRedo" οnclick="callbackClean()">重置</a>
                </td>
            </tr>
            <tr>
                <td style="width: 250px">
                    <div class="form">
                        <label class="Validform_label">市场主体类型：</label>
                        <input type="text" id="subjectType" name="subjectType">
                    </div>
                </td>
                <td style="width: 400px">
                    <div class="form">
                        <label class="Validform_label">管辖单位：</label>
                        <input id="departname" name="departname"   οnclick="openDepartmentSelect()"
                               type="text" readonly="readonly" class="inputxt" datatype="*"
                               value="${departname}" /> <input id="domination" name="domination"
                                                               type="hidden" value="${departid}" />
                    </div>
                </td>
            </tr>
        </table>
    </div>
    <div class="easyui-layout" style="height: 90%">
        <div region="center" style="padding:0px;border:0px">
            <t:datagrid name="operateSubList" checkbox="true" pagination="true" fitColumns="true" title=""
                        actionUrl="operateSubCtrl.do?datagrid" idField="id" sortName="createDate" fit="true"
                        queryMode="group">
                <t:dgCol title="主键" field="id" hidden="true" queryMode="group" width="120"></t:dgCol>
                <t:dgCol title="网站URL" field="url" query="false" url="{url}" queryMode="single" width="220"></t:dgCol>
                <t:dgCol title="网站名称" field="urlName" query="false" queryMode="single" width="220"></t:dgCol>
                <t:dgCol title="网站类型" field="urlType" query="false" dictionary="strategic_goal" width="80"></t:dgCol>
                <t:dgCol title="企业名称" field="enterpriseName" queryMode="group" width="180"></t:dgCol>
                <t:dgCol title="所属平台" field="platformName" queryMode="group" width="80"></t:dgCol>
                <t:dgCol title="统一社会信用代码" field="uscCode" query="false" queryMode="single" width="120"></t:dgCol>
                <t:dgCol title="登记机关" field="regorgCn" queryMode="group" width="220"></t:dgCol>
                <t:dgCol title="管辖单位" field="dominationCn" queryMode="single" query="false" funname="openwindow"
                         width="220"></t:dgCol>
                <t:dgCol title="市场主体类型" field="subjectType" dictionary="subject_type" query="false" queryMode="single"
                         width="80"></t:dgCol>
                <t:dgCol title="操作" field="opt" width="100"></t:dgCol>
                <t:dgOpenOpt title="管理标签" url="operateSubCtrl.do?goTagging&id={id}" urlclass="ace_button"
                             urlfont="fa-tags" openModel="OpenWin" width="1970" height="900"></t:dgOpenOpt>
                <%--<t:dgOpenOpt title="管理标签"
                            url="operateSubCtrl.do?goTagging&id={id}"
                            urlclass="ace_button" urlfont="fa-tags" openModel="OpenWin"  width="100%" height="100%"/>--%>
                <t:dgToolBar title="查看" icon="icon-search" url="operateSubCtrl.do?goUpdate" funname="detail" width="100%"
                             height="100% "></t:dgToolBar>
                <%--<t:dgToolBar title="管理标签" icon="icon-edit" url="operateSubCtrl.do?goTagging" funname="detail" width="100%"
                             height="100% "></t:dgToolBar>--%>
            </t:datagrid>
        </div>
    </div>
    <script type="text/javascript">
    
    
    //重置刷新 表格
        function callbackClean() {
            $('#url').val('');
            $('#urlName').val('');
            $('#urlType').val('');
            $('#uscCode').val('');
            $('#subjectType').val('');
            $('#domination').val('');
            $('#departname').val('');
            $('#operateSubList').datagrid( {queryParams: {
                    domination: '',
            }});
            $('#operateSubList').datagrid('load');
        }
    
    //查询  带参
        function SelectResult() {
            var url = $.trim($("#url").val());
            var urlName = $("#urlName").val();
            var urlType = $("#urlType").val();
            var uscCode = $("#uscCode").val();
            var subjectType = $("#subjectType").val();
            var domination = $("#domination").val();
            //带参数刷新datagrid
            $('#operateSubList').datagrid({
                queryParams: {
                    url: url,
                    urlName: urlName,
                    urlType: urlType,
                    uscCode: uscCode,
                    subjectType: subjectType,
                    domination: domination,
                }
            });
        }
    
    </script>