qrycheckdetaildateclassop.xml

图书管理系统

<?xml version="1.0" encoding="GB2312"?>
<!--侯文龙-->
<!--查询操作日期类型-->
<qrycheckdetaildateclassOp.xml>
	<com.icbc.cte.base.CTEServerOperation id="qrycheckdetaildateclassOp" operationContext="qrycheckdetaildateclassCtx">  
	<refFormat name="jrFormat" refId="journalFmt" />
		<!--会话检查-->
		<opStep id="SessionCheckOpStep" timeout="1800000" on0Do="next" onOtherDo="setErrorPage"/>
         <opStep id="TranSwitchOpStep" alias="TranSwitchOpStep2" switch="opFlag"  on0Do="next" on1Do="next" on4Do="modifyremark" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="qrycheckdetaildateclassSrv1" procedureDefine="qrycheckdetaildateclassSrv1" on0Do="next" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="qrycheckdetaildateclassSrv2" procedureDefine="qrycheckdetaildateclassSrv2" on0Do="setReplyPage0" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="modifyremark" procedureDefine="modifyremark" on0Do="qrycheckdetaildateclassSrv1" onOtherDo="setErrorPage"/>
		<!--查询数据-->
		
		<!--记录日志-->	
		<opStep id="journal" on0Do="next" on1Do="setErrorPage" succFormat="jrFormat" failFormat="jrFormat" />		
		<!--设定返回页面-->	
	 	<opStep id="setReplyPage" alias="setReplyPage0" onOtherDo="end" pageName="omps/regdateclass/checkdetaildateclass.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="qrycheckdetaildateclassCtx"  type="oper">
			<refKColl refId="qrycheckdetaildateclassOpData"/>
	    	<refService refId="qrycheckdetaildateclassOpSrv1" alias="qrycheckdetaildateclassSrv1" type="proc"/>
            <refService refId="qrycheckdetaildateclassOpSrv2" alias="qrycheckdetaildateclassSrv2" type="proc"/> 
             <refService refId="modifyremark" alias="modifyremark" type="proc"/>
		</context>		
	<!--交易Data定义-->
	<kColl id="qrycheckdetaildateclassOpData" dynamic="true">	
	<field id="ruleid"/>
  <field id="rulecode"/>
    <field id="rulename"/>
    <field id="startdate"/>
    <field id="overdate"/>
    <field id="remark1"/>
    <field id="maker"/>
    <field id="p_rulename"/>
    <field id="p_rulecode"/>
    <field id="p_startdate"/>
    <field id="p_maker"/>
     <field id="p_state1"/>
	<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="qrycheckdetaildateclassOpSrv1" 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="qrycheckdetaildateclassOpSrv2" 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>	
<JDBCProcedureDefine id="modifyremark" procedureName="OMPS_PAGE_REGDATACLASS.PROC_OMPS_UPDATEREMARK1" dbResource="ORACLEJDBC">
		<input>
          <param name="ruleid"/>		        	  <!--编制人-->
	      <param name="remark1"/>
		</input>
		<result>
			<param name="retCode"/>
			<param name="err_msg"/>
		</result>
		<errorMsgTable>
			<param returnValue="1" errorCode="20026"/>
			<param returnValue="-1" errorCode="20093"/>
		</errorMsgTable>
	</JDBCProcedureDefine>
</qrycheckdetaildateclassOp.xml>