EKP模板设置使用JSP片段,实现点击查询按钮弹出dialog.iframe弹出框,实现查询页面

参考JSP页面
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ include file="/sys/ui/jsp/common.jsp" %>
<%@page import="com.landray.kmss.util.ResourceUtil" %>
<script type="text/javascript">
    Com_IncludeFile("selectstockListdialog.js", '${KMSS_Parameter_ContextPath}km/asset/resource/', null, true);
</script>
<script type="text/javascript">
    var stockListIds = "";

    //填写的到货数量有校验,1.到货数量<=(采购数量-已到数量),即不能超出
    function calculate(value, obj) {
        var fdStockAmount = DocList_GetPreField(obj.parentNode, "fdStockAmount");//采购数量
        var fdReceiveAmount = DocList_GetPreField(obj.parentNode, "fdReceiveAmount");//已到数量
        if (fdStockAmount.value - fdReceiveAmount.value < value) {
            alert("<bean:message bundle='km-asset' key='kmAssetApplyInList.largeNumber'/>");
            obj.value = "";
        }
    }

    function checkCode(value, obj) {
        var url = "${KMSS_Parameter_ContextPath}km/asset/km_asset_card/kmAssetCard.do?method=checkUniqueCode";
        $.ajax({
            type: "post",
            url: url,
            data: {fdCode: value, fdCardId: null},
            async: false,    //用同步方式 
            success: function (data) {
                var results = eval("(" + data + ")");
                if (results['isExist'] == 'true') {
                    alert("<bean:message bundle='km-asset' key='kmAssetCard.import.fdCode.isExists'/>");
                    obj.value = "";
                }
            }
        });
    }


    function refreshTbIndex(tbId, index) {
        var optTB = document.getElementById(tbId);
        var tb_index = parseInt(index) + 1;
        for (var j = tb_index; j < optTB.rows.length; j++) {
            optTB.rows[j].cells[0].innerHTML = j;
        }
    }


    function DocList_DeleteRow_Asset(tbId, rowIndex) {
        var optTB = document.getElementById(tbId);
        var tbInfo = DocList_TableInfo[tbId];
        optTB.deleteRow(rowIndex);

        tbInfo.lastIndex--;
        for (var i = rowIndex; i < tbInfo.lastIndex; i++)
            DocListFunc_RefreshIndex(tbInfo, i);
    }

    //同时删除入库明细、采购明细
    function deleteRow(index) {

        optTR = DocListFunc_GetParentByTagName("TR");
        var optTB = DocListFunc_GetParentByTagName("TABLE", optTR);
        var rowIndex = Com_ArrayGetIndex(optTB.rows, optTR);
        var tb_index = parseInt(rowIndex) - 1;

        //从全局变量中删除指定明细ID
        var stockListId = document.getElementsByName("kmAssetApplyInListForms[" + tb_index + "].fdStockListId");
        if (stockListId != null && stockListId.length > 0) {
            stockListIds = stockListIds.replace(stockListId[0].value, "");
        }

        DocList_DeleteRow_Asset('TABLE_DocList_Stock', rowIndex);
        DocList_DeleteRow_Asset('TABLE_DocList_In', rowIndex);
        refreshTbIndex('TABLE_DocList_Stock', index);
        refreshTbIndex('TABLE_DocList_In', index);
    }

    seajs.use(['lui/dialog'], function (dialog) {
        window.dialog = dialog;
    });

    function showStockList() {
        var url = Com_GetCurDnsHost() + Com_Parameter.ContextPath + 'km/asset/km_asset_apply_stock_list/kmAssetApplyStockList.do?method=list&isDialog=0';
        dialog.iframe(url, "${lfn:message('km-asset:kmAssetApplyBase.selectAsset') }", function (ids) {
            if (ids != "" && ids != null) {
                var data = new KMSSData();
                var url = "${KMSS_Parameter_ContextPath}km/asset/km_asset_apply_stock_list/kmAssetApplyStockList.do?method=loadStockList&ids="
                    + ids;
                data.SendToUrl(url, function (data) {
                    var results = eval("(" + data.responseText + ")");
                    if (results.length > 0) {
                        for (var i = 0; i < results.length; i++) {
                            //判断指定明细是否已存在
                            if (stockListIds.indexOf(results[i].fdId, 0) == -1) {
                                //将明细ID存入全局字符串
                                stockListIds += results[i].fdId;
                                //自动带出全部采购明细信息
                                var content = new Array();
                                content.push(null);
                                content.push(results[i].stockFdNo);
                                content.push(results[i].fdName);
                                content.push(results[i].fdStandard);
                                content.push(results[i].fdMeasure);
                                content.push(results[i].fdPrice.toString());
                                content.push(results[i].fdStockAmount.toString());
                                content.push(results[i].fdReceiveAmount.toString());
                                content.push(results[i].fdStocker);
                                content.push(results[i].fdProvider);
                                content.push(results[i].fdDate);
                                //增加采购明细行
                                DocList_AddRow("TABLE_DocList_Stock", content);
                                //自动带出部分入库明细信息

                                /*
                                var optTB = document.getElementById("TABLE_DocList_In");
                                var oneRow = [];
                                oneRow["kmAssetApplyInListForms[!{index}].fdStockListId"]=results[i].fdId;
                                oneRow["kmAssetApplyInListForms[!{index}].fdStockNo"]=results[i].stockFdNo;
                                oneRow["kmAssetApplyInListForms[!{index}].fdName"]=results[i].fdName;
                                oneRow["kmAssetApplyInListForms[!{index}].fdStockAmount"]=results[i].fdStockAmount;
                                oneRow["kmAssetApplyInListForms[!{index}].fdReceiveAmount"]=results[i].fdReceiveAmount;
                                DocList_AddRow(optTB,null,oneRow); 
                                */

                                content = new Array();
                                content.push(null);
                                content.push("<input type='hidden' name='kmAssetApplyInListForms[!{index}].fdStockListId' value='" + results[i].fdId + "' /><input type='hidden' name='kmAssetApplyInListForms[!{index}].fdStockNo' value='" + results[i].stockFdNo + "' />" + results[i].stockFdNo);
                                content.push("<input type='hidden' name='kmAssetApplyInListForms[!{index}].fdName' value='" + results[i].fdName + "' />" + results[i].fdName);
                                content.push("<input type='hidden' name='kmAssetApplyInListForms[!{index}].fdStockAmount' value='" + results[i].fdStockAmount + "' />" + results[i].fdStockAmount);
                                content.push("<input type='hidden' name='kmAssetApplyInListForms[!{index}].fdReceiveAmount' value='" + results[i].fdReceiveAmount + "' />" + results[i].fdReceiveAmount);
                                //增加入库明细行
                                DocList_AddRow("TABLE_DocList_In", content);
                            }
                        }
                    }
                });
            } else {
                return false;
            }
        }, {width: 950, height: 550});
    }


    //选择采购明细
    function selectStockList() {
        showStockList();
    }
</script>
<tr>
    <td colspan="4">
        <table class="tb_normal" width=100% align="center">
            <tr>
                <%-- 申购明细标题 --%>
                <td colspan="2" class="td_normal_title" align="center">
                    <bean:message bundle="km-asset" key="table.kmAssetApplyStockList"/>
                </td>
            </tr>
            <%-- 搜索关联单 --%>
            <tr>
                <td width="15%"><bean:message bundle="km-asset" key="kmAssetApplyIn.relateStock"/></td>
                <td>
                    <input type="button" class="lui_form_button"
                           value="<bean:message bundle='km-asset' key='kmAssetApplyIn.searchStock'/>"
                           onclick="selectStockList();"/>
                </td>
            </tr>
        </table>

        <table class="tb_normal" width=100% id="TABLE_DocList_Stock" align="center">
            <tr align="center">
                <%--序号--%>
                <td class="td_normal_title" width=4%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdOrder"/>
                </td>
                <%--采购单号--%>
                <td class="td_normal_title" width=11%>
                    <bean:message bundle="km-asset" key="kmAssetApplyBase.fdNo"/>
                </td>
                <%--资产名称--%>
                <td class="td_normal_title" width=10%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdName"/>
                </td>
                <%--规格型号--%>
                <td class="td_normal_title" width=10%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdStandard"/>
                </td>
                <%--单位--%>
                <td class="td_normal_title" width=5%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdMeasure"/>
                </td>
                <%--单价--%>
                <td class="td_normal_title" width=5%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdPrice"/>
                </td>
                <%--采购数量--%>
                <td class="td_normal_title" width=7%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdStockAmount"/>
                </td>
                <%--已到数量--%>
                <td class="td_normal_title" width=7%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdReceiveAmount"/>
                </td>
                <%--采购人--%>
                <td class="td_normal_title" width=10%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdStocker"/>
                </td>
                <%--供应商--%>
                <td class="td_normal_title" width=11%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdProvider"/>
                </td>
                <%--采购日期--%>
                <td class="td_normal_title" width=15%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdStockDate"/>
                </td>
                <%--操作--%>
                <td class="td_normal_title" width="5%" align="center">
                    <bean:message bundle="km-asset" key="kmAssetApplyIn.operate"/>
                </td>
            </tr>

            <!-- 基准行 -->
            <tr KMSS_IsReferRow="1" style="display: none">
                <td KMSS_IsRowIndex="1" width="4%">!{index}
                </td>
                <td width="11%"></td>
                <td width="10%"></td>
                <td width="10%"></td>
                <td width="5%"></td>
                <td width="5%"></td>
                <td width="7%"></td>
                <td width="7%"></td>
                <td width="10%"></td>
                <td width="11%"></td>
                <td width="15%"></td>
                <!-- 删除 -->
                <td width="5%" align="center">
                    <a href="#" onclick="deleteRow('!{index}');" name="link_!{index}"><img
                            src="${KMSS_Parameter_StylePath}/icons/delete.gif" border="0"/></a>
                </td>
            </tr>

            <c:forEach items="${stockLists}" var="item" varStatus="vstatus">
                <tr KMSS_IsContentRow="1">
                    <td width="4%">
                        <script type="text/javascript">
                            stockListIds += "${item.fdId}";
                        </script>
                            ${vstatus.index+1}
                    </td>
                    <td width=11%>${item.fdAssetApplyStock.fdNo}</td>
                    <td width=10%>${item.fdName}</td>
                    <td width=10%>${item.fdStandard}</td>
                    <td width=5%>${item.fdMeasure}</td>
                    <td width=5%>${item.fdPrice}</td>
                    <td width=7%>${item.fdStockAmount}</td>
                    <td width=7%>${item.fdReceiveAmount}</td>
                    <td width=10%>${item.fdStocker.fdName}</td>
                    <td width=11%>${item.fdProvider.fdName}</td>
                    <td width=15%>
                        <kmss:showDate value="${item.fdStockDate}" type="date"/>
                    </td>
                    <td width="5%" align="center">
                        <a href="#" onclick="deleteRow(${vstatus.index});" name="link_${vstatus.index}"><img
                                src="${KMSS_Parameter_StylePath}/icons/delete.gif" border="0"/></a>
                    </td>
                </tr>
            </c:forEach>

        </table>
    </td>
</tr>

<%-- 分隔符 --%>
<tr>
    <td colspan="4">&nbsp;</td>
</tr>

<tr>
    <td colspan="4">
        <table class="tb_normal" width=100% align="center">
            <tr>
                <%-- 入库明细标题 --%>
                <td class="td_normal_title" align="center">
                    <bean:message bundle="km-asset" key="table.kmAssetApplyInList"/>
                </td>
            </tr>
        </table>

        <table class="tb_normal" width=100% id="TABLE_DocList_In" align="center">
            <tr align="center">
                <%--序号--%>
                <td class="td_normal_title" width=4%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdOrder"/>
                </td>
                <%--采购单号--%>
                <td class="td_normal_title" width=11%>
                    <bean:message bundle="km-asset" key="kmAssetApplyBase.fdNo"/>
                </td>
                <%--资产名称--%>
                <td class="td_normal_title" width=10%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdName"/>
                </td>
                <%--采购数量--%>
                <td class="td_normal_title" width=7%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdStockAmount"/>
                </td>
                <%--已到数量--%>
                <td class="td_normal_title" width=7%>
                    <bean:message bundle="km-asset" key="kmAssetApplyStockList.fdReceiveAmount"/>
                </td>
                <%--资产类别--%>
                <td class="td_normal_title" width=12%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdAssetCategory"/>
                </td>
                <%--资产序列号--%>
                <td class="td_normal_title" width=10%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdNo"/>
                </td>
                <%--资产编码,1:手动,2:自动--%>
                <td class="td_normal_title" width=15%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdCode"/>
                </td>
                <%--组织机构代码--%>
                <td class="td_normal_title" width=12%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdDeptCode"/>
                </td>
                <%--到货数量--%>
                <td class="td_normal_title" width=7%>
                    <bean:message bundle="km-asset" key="kmAssetApplyInList.fdInNum"/>
                </td>
                <%--操作--%>
                <td class="td_normal_title" width="5%" align="center">
                    <bean:message bundle="km-asset" key="kmAssetApplyIn.operate"/>
                </td>
            </tr>

            <!-- 基准行 -->
            <tr KMSS_IsReferRow="1" style="display: none">
                <td KMSS_IsRowIndex="1" width="4%"></td>
                <td width="11%">
                    <input type="hidden" name="kmAssetApplyInListForms[!{index}].fdStockListId"/>
                    <input type="text" readonly="readonly" name="kmAssetApplyInListForms[!{index}].fdStockNo"/>
                </td>
                <td width="10%">
                    <input type="text" readonly="readonly" name="kmAssetApplyInListForms[!{index}].fdName"/>
                </td>
                <td width="7%">
                    <input type="text" readonly="readonly" name="kmAssetApplyInListForms[!{index}].fdStockAmount"/>
                </td>
                <td width="7%">
                    <input type="text" readonly="readonly" name="kmAssetApplyInListForms[!{index}].fdReceiveAmount"/>
                </td>
                <td width="12%">
                    <input type="hidden" name="kmAssetApplyInListForms[!{index}].fdAssetCategoryId"/>
                    <DIV onclick="Dialog_SimpleCategory('com.landray.kmss.km.asset.model.KmAssetCategory','kmAssetApplyInListForms[!{index}].fdAssetCategoryId','kmAssetApplyInListForms[!{index}].fdAssetCategoryName',false);"
                         class=inputselectsgl style="WIDTH: 110px;float: left;clear: both;display:inline;">
                        <DIV class=input style="WIDTH: 105px">
                            <INPUT style="WIDTH: 100px" readonly="readonly"
                                   subject="<%=ResourceUtil.getString(request,"kmAssetApplyInList.fdAssetCategory","km-asset")%>"
                                   name="kmAssetApplyInListForms[!{index}].fdAssetCategoryName" validate="required">
                        </DIV>
                        <DIV class=selectitem isChannel="true">
                        </DIV>
                        <span class="txtstrong"
                              style="display:block;position:absolute;width: 15px;height:100%;left:115px;">*</span>
                    </DIV>
                </td>
                <td width="10%">
                    <xform:text property="kmAssetApplyInListForms[!{index}].fdNo" style="width:90%"/>
                </td>
                <td width="15%">
                    <c:if test="${codeRule == '1'}">
                        <xform:text property="kmAssetApplyInListForms[!{index}].fdCode" required="true"
                                    onValueChange="checkCode" style="width:90%"/>
                    </c:if>
                    <c:if test="${codeRule == '2'}">
                        <bean:message bundle="km-asset" key="kmAssetApplyInList.fdCodeAuto"/>
                    </c:if>
                </td>
                <td width="12%">
                    <xform:text property="kmAssetApplyInListForms[!{index}].fdDeptCode" style="width:90%"/>
                </td>
                <td width="7%">
                    <xform:text property="kmAssetApplyInListForms[!{index}].fdInNum"
                                subject='<%=ResourceUtil.getString(request,"kmAssetApplyInList.fdInNum","km-asset")%>'
                                required="true" style="width:80%" onValueChange="calculate"
                                validators="number scaleLength(0) digits"/>
                </td>
                <td width="5%" align="center">
                    <a href="#" onclick="deleteRow('!{index}');" name="link_!{index}"><img
                            src="${KMSS_Parameter_StylePath}/icons/delete.gif" border="0"/></a>
                </td>
            </tr>

            <c:forEach items="${kmAssetApplyInForm.kmAssetApplyInListForms}" var="item" varStatus="vstatus">
                <tr KMSS_IsContentRow="1">
                    <td width="4%">${vstatus.index+1}</td>
                    <td width=11%>
                            ${item.fdStockNo}
                        <input type="hidden" name="kmAssetApplyInListForms[${vstatus.index}].fdStockNo"
                               value="${item.fdStockNo}"/>
                        <input type="hidden" name="kmAssetApplyInListForms[${vstatus.index}].fdStockListId"
                               value="${item.fdStockListId}"/>
                    </td>
                    <td width=10%>
                            ${item.fdName}
                        <input type="hidden" name="kmAssetApplyInListForms[${vstatus.index}].fdName"
                               value="${item.fdName}"/>
                    </td>
                    <td width=7%>
                            ${item.fdStockAmount}
                        <input type="hidden" name="kmAssetApplyInListForms[${vstatus.index}].fdStockAmount"
                               value="${item.fdStockAmount}"/>
                    </td>
                    <td width=7%>
                            ${item.fdReceiveAmount}
                        <input type="hidden" name="kmAssetApplyInListForms[${vstatus.index}].fdReceiveAmount"
                               value="${item.fdReceiveAmount}"/>
                    </td>
                    <td width="12%">

                        <input type="hidden" name="kmAssetApplyInListForms[${vstatus.index}].fdAssetCategoryId"
                               value="${item.fdAssetCategoryId}"/>

                        <DIV onclick="Dialog_SimpleCategory('com.landray.kmss.km.asset.model.KmAssetCategory','kmAssetApplyInListForms[${vstatus.index}].fdAssetCategoryId','kmAssetApplyInListForms[${vstatus.index}].fdAssetCategoryName',false);"
                             class=inputselectsgl style="WIDTH: 110px">
                            <DIV class=input style="WIDTH: 105px">
                                <INPUT style="WIDTH: 100px" readonly="readonly"
                                       title="<%=ResourceUtil.getString(request,"kmAssetApplyInList.fdAssetCategory","km-asset")%>"
                                       name="kmAssetApplyInListForms[${vstatus.index}].fdAssetCategoryName"
                                       value="${item.fdAssetCategoryName}" validate="required" isChannel="true"></DIV>
                            <DIV class="selectitem" isChannel="true">
                            </DIV>
                        </DIV>
                    </td>
                    <td width=10%>
                        <xform:text property="kmAssetApplyInListForms[${vstatus.index}].fdNo" value="${item.fdNo}"
                                    style="width:90%"/>
                    </td>
                    <td width=15%>
                        <c:if test="${codeRule=='1'}">
                            <xform:text property="kmAssetApplyInListForms[${vstatus.index}].fdCode" required="true"
                                        value="${item.fdCode}" style="width:90%"/>
                        </c:if>
                        <c:if test="${codeRule=='2'}">
                            <bean:message bundle="km-asset" key="kmAssetApplyInList.fdCodeAuto"/>
                        </c:if>
                    </td>
                    <td width=12%>
                        <xform:text property="kmAssetApplyInListForms[${vstatus.index}].fdDeptCode"
                                    value="${item.fdDeptCode}" style="width:90%"/>
                    </td>
                    <td width=7%>
                        <xform:text property="kmAssetApplyInListForms[${vstatus.index}].fdInNum" value="${item.fdInNum}"
                                    subject='<%=ResourceUtil.getString(request,"kmAssetApplyInList.fdInNum","km-asset")%>'
                                    required="true" style="width:80%" onValueChange="calculate"
                                    validators="number scaleLength(0) digits"/>
                    </td>
                    <td width="5%" align="center">
                        <a href="#" onclick="deleteRow(${vstatus.index});" name="link_${vstatus.index}"><img
                                src="${KMSS_Parameter_StylePath}/icons/delete.gif" border="0"/></a>
                    </td>
                </tr>
            </c:forEach>
        </table>
    </td>
</tr>

JSP片段设置

<div id="tranDataDiv" style="display: none;">
	<input type="button" class="lui_form_button" value="查看消费明细"  onclick="selectTranData()">
</div>

<%
	/*当前登录人*/
	request.setAttribute("currentFdName", com.landray.kmss.util.UserUtil.getUser().getFdName());
	/*当前登录人岗位信息*/
	request.setAttribute("currentPostName", com.landray.kmss.sys.formula.provider.function.OrgFunction.getCurrentPost().getFdName());
%>

<script type="text/javascript">
//获取申请人姓名
var actChiNam = $form('fd_37e9a8e356e93e.name').val();

seajs.use(['lui/dialog'], function(dialog){
	window.dialog=dialog;
});

function showTranData(){
	var url=Com_GetCurDnsHost()+Com_Parameter.ContextPath + 'third/cmbchina/third_cmbchina_busitrandata/thirdCmbchinaBusitrandata.do?method=list&isDialog=0&actChiNam='+actChiNam;
	dialog.iframe(url,"交易数据查询","",{width:950,height:550});
}

function selectTranData(){
	showTranData();
}

var currentFdName = "<%=request.getAttribute("currentFdName").toString()%>";
var currentPostName = "<%=request.getAttribute("currentPostName").toString()%>";
if (actChiNam === currentFdName) {
	$("#tranDataDiv").css("display", "block");
} else if (/财务|会计/.test(currentPostName)) {
	$("#tranDataDiv").css("display", "block");
} else {
	$("#tranDataDiv").css("display", "none");
}

</script>

Action处理
package com.landray.kmss.third.cmbchina.actions;

import com.landray.kmss.common.actions.ExtendAction;
import com.landray.kmss.common.actions.RequestContext;
import com.landray.kmss.common.dao.HQLInfo;
import com.landray.kmss.common.forms.IExtendForm;
import com.landray.kmss.common.service.IBaseService;
import com.landray.kmss.third.cmbchina.forms.ThirdCmbchinaBusitrandataForm;
import com.landray.kmss.third.cmbchina.service.IThirdCmbchinaBusitrandataService;
import com.landray.kmss.util.StringUtil;
import com.landray.kmss.web.action.ActionForm;
import com.landray.kmss.web.action.ActionForward;
import com.landray.kmss.web.action.ActionMapping;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

/**
 * 招商银行新商务卡交易数据 Action
 */
public class ThirdCmbchinaBusitrandataAction extends ExtendAction {

    private IThirdCmbchinaBusitrandataService thirdCmbchinaBusitrandataService;

    public IBaseService getServiceImp(HttpServletRequest request) {
        if (thirdCmbchinaBusitrandataService == null) {
            thirdCmbchinaBusitrandataService = (IThirdCmbchinaBusitrandataService) getBean("thirdCmbchinaBusitrandataService");
        }
        return thirdCmbchinaBusitrandataService;
    }

    public void changeFindPageHQLInfo(HttpServletRequest request, HQLInfo hqlInfo) throws Exception {
        /*HQLHelper.by(request).buildHQLInfo(hqlInfo, ThirdCmbchinaBusitrandata.class);
        hqlInfo.setOrderBy(getFindPageOrderBy(request, hqlInfo.getOrderBy()));
        com.landray.kmss.third.cmbchina.util.ThirdCmbchinaUtil.buildHqlInfoDate(hqlInfo, request, com.landray.kmss.third.cmbchina.model.ThirdCmbchinaBusitrandata.class);
        com.landray.kmss.third.cmbchina.util.ThirdCmbchinaUtil.buildHqlInfoModel(hqlInfo, request);*/


        //根据条件查询招商银行新商务卡交易数据
        super.changeFindPageHQLInfo(request, hqlInfo);
        String isDialog = request.getParameter("isDialog");
        if ("0".equals(isDialog)) {
            //持卡人姓名
            String actChiNam = request.getParameter("actChiNam");
            if (StringUtil.isNotNull(actChiNam) && !"undefined".equals(actChiNam)) {
                String where = StringUtil.linkString(hqlInfo.getWhereBlock(), " and ", " 1 = 1 ");
                where += " and thirdCmbchinaBusitrandata.actChiNam = :actChiNam";
                hqlInfo.setParameter("actChiNam", actChiNam);
                //入账日期开始
                String posDateStart = request.getParameter("posDateStart");
                if (StringUtil.isNotNull(posDateStart)) {
                    where += " and thirdCmbchinaBusitrandata.trsDte >= :posDateStart";
                    hqlInfo.setParameter("posDateStart", posDateStart);
                }
                //入账日期结束
                String posDateEnd = request.getParameter("posDateEnd");
                if (StringUtil.isNotNull(posDateStart)) {
                    where += " and thirdCmbchinaBusitrandata.trsDte <= :posDateEnd";
                    hqlInfo.setParameter("posDateEnd", posDateEnd);
                }
                if (StringUtil.isNull(posDateStart) && StringUtil.isNull(posDateEnd)) {
                    //默认带出当月数据
                    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
                    Calendar calendar = Calendar.getInstance();
                    // 设置为本月第一天
                    calendar.set(Calendar.DAY_OF_MONTH, 1);
                    Date firstDayOfMonth = calendar.getTime();
                    // 设置为本月最后一天
                    calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
                    Date lastDayOfMonth = calendar.getTime();
                    //转换格式
                    String startTime = dateFormat.format(firstDayOfMonth);
                    String endTime = dateFormat.format(lastDayOfMonth);
                    where += " and thirdCmbchinaBusitrandata.trsDte >= :startTime and thirdCmbchinaBusitrandata.trsDte <= :endTime ";
                    hqlInfo.setParameter("startTime", startTime);
                    hqlInfo.setParameter("endTime", endTime);
                }
                hqlInfo.setWhereBlock(where);
            }
        }
    }

    public ActionForm createNewForm(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
        ThirdCmbchinaBusitrandataForm thirdCmbchinaBusitrandataForm = (ThirdCmbchinaBusitrandataForm) super.createNewForm(mapping, form, request, response);
        ((IThirdCmbchinaBusitrandataService) getServiceImp(request)).initFormSetting((IExtendForm) form, new RequestContext(request));
        return thirdCmbchinaBusitrandataForm;
    }

    /**
     * @param mapping
     * @param form
     * @param request
     * @param response
     * @return com.landray.kmss.web.action.ActionForward
     * @description: 招商银行新商务卡交易数据查询dialog展示方式
     * @date: 2023/10/25
     */
    @Override
    public ActionForward list(ActionMapping mapping, ActionForm form,
                              HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        ActionForward list = super.list(mapping, form, request, response);

        if ("0".equals(request.getParameter("isDialog"))) {
            //获取传递的申请人姓名
            String actChiNam = request.getParameter("actChiNam");
            if (StringUtil.isNotNull(actChiNam)) {
                request.setAttribute("actChiNam", actChiNam);
            }
            return getActionForward("listTrandataDialog", mapping, form, request,
                    response);
        }
        return list;
    }


}

路径映射配置
<?xml version="1.0" encoding="UTF-8"?>
<beans
        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"
        xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <bean
            class="com.landray.kmss.third.cmbchina.actions.ThirdCmbchinaBusicardinfoAction"
            parent="KmssBaseAction"
            name="/third/cmbchina/third_cmbchina_busicardinfo/thirdCmbchinaBusicardinfo.do"
            lazy-init="true">
        <property
                name="formType"
                value="com.landray.kmss.third.cmbchina.forms.ThirdCmbchinaBusicardinfoForm"/>
        <property
                name="forwards">
            <map/>
        </property>
    </bean>
    <bean
            class="com.landray.kmss.third.cmbchina.actions.ThirdCmbchinaBusitrandataAction"
            parent="KmssBaseAction"
            name="/third/cmbchina/third_cmbchina_busitrandata/thirdCmbchinaBusitrandata.do"
            lazy-init="true">
        <property
                name="formType"
                value="com.landray.kmss.third.cmbchina.forms.ThirdCmbchinaBusitrandataForm"/>
        <property
                name="forwards">
            <map>
                <!--新增-招商银行新商务卡交易数据查询展示映射-开始-->
                <entry
                        key="listTrandataDialog"
                        value="/third/cmbchina/third_cmbchina_busitrandata/thirdCmbchinaBusitrandata_listDialog.jsp"/>
                <!--新增-招商银行新商务卡交易数据查询展示映射-结束-->
            </map>
        </property>
    </bean>
    <bean
            class="com.landray.kmss.third.cmbchina.actions.ThirdCmbchinaParamapAction"
            parent="KmssBaseAction"
            name="/third/cmbchina/third_cmbchina_paramap/thirdCmbchinaParamap.do"
            lazy-init="true">
        <property
                name="formType"
                value="com.landray.kmss.third.cmbchina.forms.ThirdCmbchinaParamapForm"/>
        <property
                name="forwards">
            <map/>
        </property>
    </bean>
</beans>

跳转页面展示(thirdCmbchinaBusitrandata_listDialog.jsp)
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ include file="/resource/jsp/list_top.jsp" %>
<%@ include file="/sys/ui/jsp/common.jsp" %>
<template:include ref="default.simple" sidebar="auto">
    <template:replace name="body">
        <script language="JavaScript">
            seajs.use(['theme!form']);
        </script>
        <script type="text/javascript">
            window.onload = function () {
                var posDateStart = Com_GetUrlParameter(location.href, 'posDateStart');
                var posDateEnd = Com_GetUrlParameter(location.href, 'posDateEnd');
                if (posDateStart != null && posDateStart != '') {
                    document.getElementById("posDateStart").value = posDateStart;
                } else if (posDateEnd != null && posDateEnd != '') {
                    document.getElementById("posDateEnd").value = posDateEnd;
                }
            };

            function dosearch() {
                var actChiNam = $("#actChiNam").val();
                var posDateStart = document.getElementById("posDateStart").value;
                var posDateEnd = document.getElementById("posDateEnd").value;
                window.location.href = "${KMSS_Parameter_ContextPath}third/cmbchina/third_cmbchina_busitrandata/thirdCmbchinaBusitrandata.do?" +
                    "method=list&isDialog=0&actChiNam=" + actChiNam + "&posDateStart=" + posDateStart + "&posDateEnd=" + posDateEnd;
                $("#posDateStart").val("");
                $("#posDateEnd").val("");
            }
        </script>
        <p class="txttitle"><bean:message bundle="third-cmbchina" key="table.thirdCmbchinaBusitrandata"/></p>
        <div class="input_search" style="border:0">
                <%--申请人信息--%>
            <input type="hidden" id="actChiNam" name="actChiNam" value="${actChiNam}">

            <label>请输入开始交易日期:</label>
            <xform:datetime property="actNum" dateTimeType="date" showStatus="edit"
                            htmlElementProperties=" id='posDateStart' "/>

            <label>请输入结束交易日期:</label>
            <xform:datetime property="acctNbr" dateTimeType="date" showStatus="edit"
                            htmlElementProperties=" id='posDateEnd' "/>

            <input type="button" class="btnopt" value="<bean:message key="button.search"/>" onclick="dosearch();">
        </div>
        <html:form action="/third/cmbchina/third_cmbchina_busitrandata/thirdCmbchinaBusitrandata.do">

            <c:if test="${queryPage.totalrows==0}">
                <%@ include file="/resource/jsp/list_norecord.jsp" %>
            </c:if>
            <c:if test="${queryPage.totalrows>0}">
                <%@ include file="/resource/jsp/list_pagenav_top.jsp" %>
                <table id="List_ViewTable">
                    <tr>
                        <sunbor:columnHead htmlTag="td">
                            <td width="40pt">
                                <bean:message key="page.serial"/>
                            </td>
                            <%--账单日--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.bilDate">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.bilDate"/>
                            </sunbor:column>
                            <%--持卡人中文名--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.actChiNam">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.actChiNam"/>
                            </sunbor:column>
                            <%--交易日期--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.trsDte">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.trsDte"/>
                            </sunbor:column>
                            <%--交易时间--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.trxTim">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.trxTim"/>
                            </sunbor:column>
                            <%--交易金额--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.oriCurAmt">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.oriCurAmt"/>
                            </sunbor:column>
                            <%--交易币种--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.oriCurCod">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.oriCurCod"/>
                            </sunbor:column>
                            <%--商户名称--%>
                            <sunbor:column property="thirdCmbchinaBusitrandata.acpName">
                                <bean:message bundle="third-cmbchina" key="thirdCmbchinaBusitrandata.acpName"/>
                            </sunbor:column>
                        </sunbor:columnHead>
                    </tr>
                    <c:forEach items="${queryPage.list}" var="thirdCmbchinaBusitrandata" varStatus="vstatus">
                        <tr>
                            <td>
                                    ${vstatus.index+1}
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.bilDate}"/>
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.actChiNam}"/>
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.trsDte}"/>
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.trxTim}"/>
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.oriCurAmt}"/>
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.oriCurCod}"/>
                            </td>
                            <td>
                                <c:out value="${thirdCmbchinaBusitrandata.acpName}"/>
                            </td>
                        </tr>
                    </c:forEach>
                </table>
                <%@ include file="/resource/jsp/list_pagenav_down.jsp" %>
            </c:if>
        </html:form>
        <%@ include file="/resource/jsp/list_down.jsp" %>
    </template:replace>
</template:include>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值