addqrydetaildateclassop.xml

图书管理系统

<?xml version="1.0" encoding="GB2312"?>
<!--侯文龙-->
<!--查询详细操作日期类型-->
<addqrydetaildateclassOp.xml>
	<com.icbc.cte.base.CTEServerOperation id="addqrydetaildateclassOp" operationContext="addqrydetaildateclassCtx">  
	<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="modify" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="addqrydetaildateclassSrv1" procedureDefine="addqrydetaildateclassSrv1" on0Do="next" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="addqrydetaildateclassSrv2" procedureDefine="addqrydetaildateclassSrv2" on0Do="setReplyPage0" onOtherDo="setErrorPage"/>
        <opStep id="procedureAccessOpStep" alias="modify" procedureDefine="modify" on0Do="setReplyPage1" 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/addqrydetaildateclass.jsp"/>
        <opStep id="setReplyPage" alias="setReplyPage1" onOtherDo="end" pageName="omps/regdateclass/modifyregdateok.jsp"/>	
        <opStep id="setReplyPage" alias="setReplyPage2" onOtherDo="end" pageName="omps/test.jsp"/>
		<opStep id="setErrorPage" pageName="error.jsp" onOtherDo="return"/>	 
	</com.icbc.cte.base.CTEServerOperation>
	
	<!--交易资源定义-->
		<context id="addqrydetaildateclassCtx"  type="oper">
			<refKColl refId="addqrydetaildateclassOpData"/>
	    	<refService refId="addqrydetaildateclassOpSrv1" alias="addqrydetaildateclassSrv1" type="proc"/>
            <refService refId="addqrydetaildateclassOpSrv2" alias="addqrydetaildateclassSrv2" type="proc"/> 
            <refService refId="modify" alias="modify" type="proc"/>
		</context>		
	<!--交易Data定义-->
	<kColl id="addqrydetaildateclassOpData" dynamic="true">	
	<field id="ruleid"/>
	<field id="rulename"/>
    <field id="datestr1"/>
    <field id="datestr2"/>
    <field id="datestr3"/>
     <field id="startdate"/>
    <field id="overdate"/>
    <field id="maker1"/>
    <field id="p_rulename"/>
    <field id="p_rulecode"/>
    <field id="p_startdate"/>
    <field id="p_maker"/>
	<field id="retCode"/>
     <field id="err_msg"/>
     <refData refId="irulelist"/>
     <refData refId="idatelist"/>        <!-- 返回操作组结果集定义 -->
	</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="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="addqrydetaildateclassOpSrv1" 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="addqrydetaildateclassOpSrv2" procedureName="OMPS_PAGE_REGDATACLASS.PROC_OMPS_QUYDETAILDATECLASS3" 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>
		<errorMsgTable errorMsgField="err_msg">
			<param returnValue="-1" errorCode="omps_100301"/>
		</errorMsgTable>		
	</JDBCProcedureDefine>	
<JDBCProcedureDefine id="modify" procedureName="OMPS_PAGE_REGDATACLASS.PROC_OMPS_UPDATEREGDATE1" dbResource="ORACLEJDBC">
		<input>
           <param name="ruleid"/>
		   <param name="datestr1"/>
           <param name="datestr2"/>
           <param name="datestr3"/> 
		   <param name="startdate"/>
		   <param name="overdate"/>
		   <param name="remark1"/>   	 
	        <param name="maker1"/>
            <param name="state1"/>
		</input>
		<result>
			<param name="retCode"/>
			<param name="err_msg"/>
		</result>
		<errorMsgTable>
			<param returnValue="1" errorCode="20026"/>
			<param returnValue="-1" errorCode="20093"/>
		</errorMsgTable>
	</JDBCProcedureDefine>
</addqrydetaildateclassOp.xml>