qrydetaildateclassop.xml

图书管理系统

<?xml version="1.0" encoding="GB2312"?>
<!--侯文龙-->
<!--查询操作日期类型-->
<qrydetaildateclassOp.xml>
	<com.icbc.cte.base.CTEServerOperation id="qrydetaildateclassOp" operationContext="qrydetaildateclassCtx">  
	<refFormat name="jrFormat" refId="journalFmt" />
		<!--会话检查-->
		<opStep id="SessionCheckOpStep" timeout="1800000" on0Do="next" onOtherDo="setErrorPage"/>
        
        <opStep id="procedureAccessOpStep" alias="qrydetaildateclassSrv1" procedureDefine="qrydetaildateclassSrv1" on0Do="next" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="qrydetaildateclassSrv2" procedureDefine="qrydetaildateclassSrv2" on0Do="next" onOtherDo="setErrorPage"/>
        
		<!--查询数据-->
        		<opStep id="TranSwitchOpStep" alias="TranSwitchOpStep1" switch="opFlag"  on0Do="setReplyPage0" on1Do="setReplyPage0" onOtherDo="setErrorPage"/>

		<!--记录日志-->	
		<opStep id="journal" on0Do="next" on1Do="setErrorPage" succFormat="jrFormat" failFormat="jrFormat" />		
		<!--设定返回页面-->	
	 	<opStep id="setReplyPage" alias="setReplyPage0" onOtherDo="end" pageName="omps/regdateclass/qrydetaildateclass.jsp"/>
        <opStep id="setReplyPage" alias="setReplyPage1" onOtherDo="end" pageName="omps/regdateclass/editdetaildateclass.jsp"/>
        <opStep id="setReplyPage" alias="setReplyPage2" onOtherDo="end" pageName="omps/regdateclass/test.jsp"/>
		<opStep id="setErrorPage" pageName="error.jsp" onOtherDo="return"/>	 
	</com.icbc.cte.base.CTEServerOperation>
	
	<!--交易资源定义-->
		<context id="qrydetaildateclassCtx"  type="oper">
			<refKColl refId="qrydetaildateclassOpData"/>
	    	<refService refId="qrydetaildateclassOpSrv1" alias="qrydetaildateclassSrv1" type="proc"/>
            <refService refId="qrydetaildateclassOpSrv2" alias="qrydetaildateclassSrv2" type="proc"/> 
            
		</context>		
	<!--交易Data定义-->
	<kColl id="qrydetaildateclassOpData" dynamic="true">	
	<field id="ruleid"/>
	<field id="rulename"/>
	<field id="retCode"/>
     <field id="err_msg"/>
     <refData refId="irulelist"/>
     <refData refId="idatelist"/> 
     <refData refId="inewdatelist"/> 
     <refData refId="ideldatelist"/> 
         <!-- 返回操作组结果集定义 -->
	</kColl>
	<!--返回结果集-->
      <iColl id="idatelist" count="*">
	  <refData refId="kdatelist"/>
	</iColl>
		<kColl id="kdatelist">
	    <field id="u_dateid" />	              <!-- 创建人编号 -->
	    <field id="u_opdate" />
        <field id="u_state1" />	            <!-- 创建人名称 -->
	    </kColl>
<iColl id="inewdatelist" count="*">
	  <refData refId="knewdatelist"/>
	</iColl>
		<kColl id="knewdatelist">
	    <field id="u_opdate" />
        <field id="u_state1" />	            <!-- 创建人名称 -->
	    </kColl>
<iColl id="ideldatelist" count="*">
	  <refData refId="kdeldatelist"/>
	</iColl>
		<kColl id="kdeldatelist">
	    <field id="u_opdate" />
        <field id="u_state1" />	            
	    </kColl>	
   <iColl id="irulelist" count="*">
	  <refData refId="krulelist"/>
	</iColl>
	<kColl id="krulelist">
    <field id="ruleid"/>
	<field id="rulecode"/>
	<field id="rulename"/>
	<field id="describes"/>
	<field id="startdate"/>
	<field id="overdate"/>
    <field id="remark1"/>
    <field id="state1"/>
    <field id="maker1"/> 
    <field id="maker1id"/>       
    <field id="maker2"/> 
    <field id="last_editor_time"/>
    <field id="last_check_time"/>    
	</kColl>

	<!--交易引用service定义-->

	<JDBCProcedureDefine id="qrydetaildateclassOpSrv1" procedureName="OMPS_PAGE_REGDATACLASS.PROC_OMPS_QUYDETAILDATECLASS1" dbResource="ORACLEJDBC">
		<input>
          <param name="ruleid"/>		        	  <!--规则ID--> 
		</input>
		<result>
			<param name="retCode"/>
			<param name="err_msg"/>
		</result>
		<resultSet iCollName="irulelist" append="false">
          <param name="ruleid"/>                            <!-- 规则序列号-->
		  <param name="rulecode"/>				          <!-- 规则号 -->
          <param name="rulename"/>				          <!-- 规则名 -->
          <param name="describes"/>				          <!--描述 -->
          <param name="startdate"/>		              <!-- 开始时间 --> 
		  <param name="overdate"/>				          <!-- 结束时间 -->
          <param name="remark1"/>		                  <!-- 备注 --> 
          <param name="state1"/>
          <param name="maker1"/> 
          <param name="maker1id"/>  
          <param name="maker2"/>       
          <param name="last_editor_time"/>
          <param name="last_check_time"/>
        </resultSet>

		<errorMsgTable>
			<param returnValue="1" errorCode="20026"/>
			<param returnValue="-1" errorCode="20093"/>
		</errorMsgTable>
	</JDBCProcedureDefine>
<JDBCProcedureDefine id="qrydetaildateclassOpSrv2" procedureName="OMPS_PAGE_REGDATACLASS.PROC_OMPS_QUYDETAILDATECLASS2" dbResource="ORACLEJDBC">
		<input>
        <param name="ruleid"/>
		</input>
		<result>
			<param name="retCode"/>
			<param name="err_msg"/>
		</result>
		<resultSet iCollName="idatelist" append="false">
		    <param name="u_dateid" />	           
      		<param name="u_opdate" />
            <param name="u_state1" />
         </resultSet>
      <resultSet iCollName="inewdatelist" append="false">	           
      		<param name="u_opdate" />
            <param name="u_state1" /></resultSet>	
     <resultSet iCollName="ideldatelist" append="false">	           
      		<param name="u_opdate" />
            <param name="u_state1" />		           
    	</resultSet>
		<errorMsgTable errorMsgField="err_msg">
			<param returnValue="-1" errorCode="omps_100301"/>
		</errorMsgTable>		
	</JDBCProcedureDefine>	

</qrydetaildateclassOp.xml>