文件操作待整理

最新推荐文章于 2022-05-12 11:35:44 发布
最新推荐文章于 2022-05-12 11:35:44 发布
阅读量408 收藏
点赞数 2
分类专栏： IO java总结 文章标签： java IO
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/stairheaven/article/details/84489478
版权 

package test;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.RandomAccessFile;
import java.util.Date;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import org.apache.commons.io.FileUtils;

public class CopyOfBuildBPXML {
//	<xmlWrap > </xmlWrap > ------>  <xmlWrapBP>< /xmlWrapBP >
//	<xmlIColl> </xmlIColl> ------>  <xmlICollBP> < /xmlICollBP>
//	<xmlFullTag  ------>  <xmlFullTagBP
	static final String REGEX_BP = "xml(Wrap|IColl|FullTag])";
	static final String LINE_SEPARATOR = System.getProperty("line.separator"); // /r/n 回车换行
	/**
	 * @param args
	 * @throws IOException 
	 */
	public static void main(String[] args) throws IOException {

		String filePath = CopyOfBuildBPXML.class.getResource("").getPath()+"test.properties"; // 文件路径

		System.out.println(filePath);

		String inputFile = "C:/Documents and Settings/rdpc0545/桌面/社保二期/cb700410_socialInsurancePay_input.xml";
		String outputFile = "cb700410_socialInsurancePay_input" + (new Date().getTime()) + ".xml";

		//write(outputFile, read(inputFile)); // 读取修改文件

		//fileAppender(outputFile, "fileAppender 在文件前面追加内容 \n");// 在文件前面追加内容

		Pattern pattern = Pattern.compile(REGEX_BP);
		String txt = FileUtils.readFileToString(new File(inputFile));

		Matcher matcher = pattern.matcher(txt);

		while (matcher.find()) {
			String matchecText = matcher.group();
			int matchedFrom = matcher.start();
			int matchedTo = matcher.end();
			System.out.println("matched [" + matchecText + "] from [" + matchedFrom + "] to [" + matchedTo + "]" );
			//matcher.appendReplacement(txt, matchecText + "BP");
			String xxx = matcher.replaceAll(matchecText + "BP");
			System.out.println(xxx);
		}

	}



	/**
	 * 读取文件内容
	 * 
	 * @param inputFilePath
	 * @return
	 */
	public static String read(String inputFilePath) {
		BufferedReader in = null;
		String line = null;
		StringBuffer contexts = new StringBuffer();

		try {
			// 根据文件路径创建缓冲输入流
			in = new BufferedReader(new FileReader(inputFilePath));

			// 循环读取文件的每一行, 对需要修改的行进行修改, 放入缓冲对象中
			while ((line = in.readLine()) != null) {
				/**
				// 此处根据实际需要修改某些行的内容
				if(true){

				} else {// 如果不用修改, 则按原来的内容回写
					contexts.append(line);
				}
				*/
				contexts.append(line.replaceAll("xmlWrap", "xmlWrapBP").replaceAll("xmlIColl", "xmlICollBP").replaceAll("xmlFullTag", "xmlFullTagBP"));
				contexts.append(LINE_SEPARATOR);
			}
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			// 关闭流
			if (in != null) {
				try {
					in.close();
				} catch (IOException e) {
					in = null;
				}
			}
		}
		//System.out.println(contexts.toString());
		return contexts.toString();
	}

	/**
	 * 读取文件内容
	 * 
	 * @param inputFilePath
	 * @return
	 */
	public static String readFileToString(String inputFilePath) {
		BufferedReader in = null;
		String line = null;
		StringBuffer contexts = new StringBuffer();

		try {
			// 根据文件路径创建缓冲输入流
			in = new BufferedReader(new FileReader(inputFilePath));

			// 循环读取文件的每一行, 对需要修改的行进行修改, 放入缓冲对象中
			while ((line = in.readLine()) != null) {
				contexts.append(line).append(LINE_SEPARATOR);
			}
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			// 关闭流
			if (in != null) {
				try {
					in.close();
				} catch (IOException e) {
					in = null;
				}
			}
		}
		//System.out.println(contexts.toString());
		return contexts.toString();
	}


	/**
	 * 将内容写到文件中
	 * 
	 * @param outFilePath
	 * @param contents
	 */
	public static void write(String outputFilePath, String contents) {
		BufferedWriter out = null;

		try {
			// 根据文件路径创建缓冲输出流
			out = new BufferedWriter(new FileWriter(outputFilePath));
			// 将内容写入文件中
			out.write(contents);
			out.newLine();
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			// 关闭流
			if (out != null) {
				try {
					out.close();
				} catch (IOException e) {
					out = null;
				}
			}
		}
	}

	/**
	 * 将内容写到文件中
	 * 
	 * @param outFilePath
	 * @param contents
	 */
	public static void modifyFileContents(String inputFilePath, String outputFilePath,String regex,String replaceTo) {
		BufferedWriter out = null;

		try {
			// 根据文件路径创建缓冲输出流
			out = new BufferedWriter(new FileWriter(outputFilePath));

			Pattern pattern = Pattern.compile(regex);
			String txt = FileUtils.readFileToString(new File(inputFilePath));
			Matcher matcher = pattern.matcher(txt);

			String contents = null;
			String matchecText = null;
			int matchedFrom = 0;
			int matchedTo = 0;
			while (matcher.find()) {
				matchecText = matcher.group();
				matchedFrom = matcher.start();
				matchedTo = matcher.end();
				System.out.println("matched [" + matchecText + "] from [" + matchedFrom + "] to [" + matchedTo + "]" );
				//matcher.appendReplacement(txt, matchecText + "BP");
				contents = matcher.replaceAll(matchecText + "BP");
				System.out.println(contents);
			}

			// 将内容写入文件中
			out.write(contents);
			out.newLine();
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			// 关闭流
			if (out != null) {
				try {
					out.close();
				} catch (IOException e) {
					out = null;
				}
			}
		}
	}


}



<?xml version="1.0" encoding="GBK" ?>


<SelfDefinedOp.xml id="cb700410_socialInsurancePay_input">
	<EMPBusinessLogic id="cb700410_socialInsurancePay_input" operationContext="cb700410_socialInsurancePay_inputSrvCtx">
		<operation id="cb700410_inputList" name="经办页面初始化">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="hostNo"/>
				<field id="recordNum"/>
				<field id="firstKey"/>
				<field id="lastKey"/>
				<field id="pageMode"/>
				<field id="recordSize"/>
				<field id="currentPage"/>
				<field id="targetPage"/>
				<field id="std400flow"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="连接超时"/>
				<action id="EndAction2" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="通讯失败"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询三代客户号" sqlService="SQLExecService" refSQL="queryHostNo" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="SendXml2BpCompAction0"/>
				</action>
				<action id="CompareStringAction0" implClass="com.ecc.emp.action.CompareStringAction" label="比较客户签约信息是否有效" param2="RCDSTT" param1="RCDSTTVALID">
					<transition dest="CompareStringAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="EndAction3" result="notsign" implClass="com.ecc.emp.flow.EMPEndAction" label="客户未签约或签约信息无效"/>
				<action id="CompareStringAction1" implClass="com.ecc.emp.action.CompareStringAction" label="比较批扣代缴标志" param2="TRANFLAG" param1="TRANFLAGVALID">
					<transition dest="SendXml2BpCompAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="SendXml2BpCompAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" sendFormat="CPSSCQRYREQ" tranCode="CPSSCQRY" receiveFormat="CPSSCQRYRSP">
					<transition dest="CompareStringAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
				<action id="SendXml2BpCompAction1" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" label="社保缴费经办前查询" sendFormat="CPSSOQRYREQ" tranCode="CPSSOQRY" receiveFormat="CPSSOQRYRSP">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
			</flow>
		</operation>
		<operation id="cb700410_inputList_bak" name="经办页面初始化">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="hostNo"/>
				<field id="recordNum"/>
				<field id="firstKey"/>
				<field id="lastKey"/>
				<field id="pageMode"/>
				<field id="recordSize"/>
				<field id="currentPage"/>
				<field id="targetPage"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="连接超时"/>
				<action id="EndAction2" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="通讯失败"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询三代客户号" sqlService="SQLExecService" refSQL="queryHostNo" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="SendXml2BpCompAction0"/>
				</action>
				<action id="CompareStringAction0" implClass="com.ecc.emp.action.CompareStringAction" label="比较客户签约信息是否有效" param2="RCDSTT" param1="RCDSTTVALID">
					<transition dest="CompareStringAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="EndAction3" result="notsign" implClass="com.ecc.emp.flow.EMPEndAction" label="客户未签约或签约信息无效"/>
				<action id="CompareStringAction1" implClass="com.ecc.emp.action.CompareStringAction" label="比较批扣代缴标志" param2="TRANFLAG" param1="TRANFLAGVALID">
					<transition dest="SendXml2BpCompAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="SendXml2BpCompAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" sendFormat="CPSSCQRYREQ" tranCode="CPSSCQRY" receiveFormat="CPSSCQRYRSP">
					<transition dest="CompareStringAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
				<action id="SendXml2BpCompAction1" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" label="社保缴费经办前查询" sendFormat="CPSSOQRYREQ" tranCode="CPSSOQRY" receiveFormat="CPSSOQRYRSP">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
			</flow>
		</operation>
		<operation id="cb700410_inputInit" name="经办页面初始化">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="hostNo"/>
				<field id="recordNum"/>
				<field id="firstKey"/>
				<field id="lastKey"/>
				<field id="pageMode"/>
				<field id="recordSize"/>
				<field id="currentPage"/>
				<field id="targetPage"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="连接超时"/>
				<action id="EndAction2" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="通讯失败"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询三代客户号" sqlService="SQLExecService" refSQL="queryHostNo" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="SendXml2BpCompAction0"/>
				</action>
				<action id="CompareStringAction0" implClass="com.ecc.emp.action.CompareStringAction" label="比较客户签约信息是否有效" param2="RCDSTT" param1="RCDSTTVALID">
					<transition dest="CompareStringAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="EndAction3" result="notsign" implClass="com.ecc.emp.flow.EMPEndAction" label="客户未签约或签约信息无效"/>
				<action id="CompareStringAction1" implClass="com.ecc.emp.action.CompareStringAction" label="比较批扣代缴标志" param2="TRANFLAG" param1="TRANFLAGVALID">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="SendXml2BpCompAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" sendFormat="CPSSCQRYREQ" tranCode="CPSSCQRY" receiveFormat="CPSSCQRYRSP">
					<transition dest="CompareStringAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
			</flow>
		</operation>
		<operation id="cb700410_queryAccountBal" name="社保缴费账户余额查询">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="CSTRGSTNO"/>
				<field id="ACTACBL"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="TRNAMT"/>
				<field id="ACCNO"/>
				<field id="ACCNM"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="ID"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="BCNB"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询业务流程" sqlService="SQLExecService" refSQL="bsnFlowQrySqlDef" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="EndAction0" condition="($retValue='0') or ($retValue='2')"/>
					<transition dest="EndAction1"/>
				</action>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="查询失败" errorCode="EC17001"/>
			</flow>
		</operation>
		<operation id="cb700410_inputCfm" name="缴费信息确认">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="CSTRGSTNO"/>
				<field id="ACTACBL"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="TRNAMT"/>
				<field id="ACCNO"/>
				<field id="ACCNM"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="ID"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="BCNB"/>
				<field id="FLOWID"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="EndAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction"/>
			</flow>
		</operation>
		<operation id="cb700410_inputSave" name="保存社保缴费经办">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="CSTRGSTNO"/>
				<field id="ACTACBL"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="TRNAMT"/>
				<field id="ACCNO"/>
				<field id="ACCNM"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="ID"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="BCNB"/>
				<field id="FLOWID"/>
				<field id="TRNSUM"/>
				<field id="cipherText"/>
				<field id="plainText"/>
				<iColl id="userDataList">
					<kColl>
						<field id="ID"/>
						<field id="PREDATE"/>
						<field id="PRETIME"/>
						<field id="PURPOSE"/>
						<field id="PAYACC"/>
						<field id="PAYNM"/>
						<field id="FEEAREA"/>
						<field id="AREANAME"/>
						<field id="BSNTYPE"/>
						<field id="XZCODE"/>
						<field id="TRANFLOWNO"/>
						<field id="PAYAMT"/>
						<field id="SXAMT"/>
						<field id="MEDAMT"/>
						<field id="OGRACODE"/>
						<field id="FEEMONTH"/>
						<field id="YLAMT"/>
						<field id="LOSTAMT"/>
						<field id="INJUAMT"/>
						<field id="BORNAMT"/>
						<field id="YLTCTAMT"/>
						<field id="YLDWAMT"/>
						<field id="YLDEAMT"/>
						<field id="YLGRAMT"/>
						<field id="GFYLAMT"/>
						<field id="CHANNEL"/>
						<field id="BCNB"/>
						<field id="REM"/>
					</kColl>
				</iColl>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="VerifySigntureAction0"/>
				</action>
				<action id="SendXml2BpAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" label="社保缴费经办" sendFormat="CPSSPSUBREQ" sendListName="userDataList" tranCode="CPSSPSUB" receiveFormat="CPSSPSUBRSP">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction2"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction"/>
				<action id="VerifySigntureAction0" implClass="com.ecc.corporbank.action.VerifySignatureAction">
					<transition dest="SendXml2BpAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1"/>
				</action>
				<action id="EndAction1" result="fail" implClass="com.ecc.emp.flow.EMPEndAction" label="验签失败"/>
				<action id="EndAction2" result="fail" implClass="com.ecc.emp.flow.EMPEndAction"/>
			</flow>
		</operation>
		<refFormat name="0815reqFmt" refId="0815reqFmt"/>
		<refFormat name="0815rspFmt" refId="0815rspFmt"/>
		<refFormat name="CPSSOQRYREQ" refId="CPSSOQRYREQ"/>
		<refFormat name="CPSSOQRYRSP" refId="CPSSOQRYRSP"/>
		<refFormat name="EBQEYBALREQ" refId="EBQEYBALREQ"/>
		<refFormat name="EBQEYBALRSP" refId="EBQEYBALRSP"/>
		<refFormat name="CPSSCQRYREQ" refId="CPSSCQRYREQ"/>
		<refFormat name="CPSSCQRYRSP" refId="CPSSCQRYRSP"/>
		<refFormat name="CPSSPSUBREQ" refId="CPSSPSUBREQ"/>
		<refFormat name="CPSSPSUBRSP" refId="CPSSPSUBRSP"/>
	</EMPBusinessLogic>
	<context id="cb700410_socialInsurancePay_inputSrvCtx" parent="rootCtx" type="op">
		<refKColl refId="cb700410_socialInsurancePay_inputSrvData"/>
		<refService alias="queryHostNo" type="prv" refId="queryHostNo"/>
		<refService alias="bsnFlowQrySqlDef" type="prv" refId="bsnFlowQrySqlDef"/>
	</context>
	<kColl id="cb700410_socialInsurancePay_inputSrvData">
		<field id="errorCode"/>
		<field id="errorMsg"/>
		<field id="bsnCode"/>
		<field id="cstNo"/>
		<field id="oprNo"/>
		<field id="EMP_SID"/>
		<field id="loginName"/>
		<field id="oprType"/>
		<field id="session_certSerial"/>
		<field id="logonType"/>
		<field id="cstNmCn"/>
		<field id="oprName"/>
		<field id="hostNo"/>
		<field id="recordNum"/>
		<field id="currentPage" value="1"/>
		<field id="recordSize" value="10"/>
		<field id="firstKey"/>
		<field id="lastKey"/>
		<field id="pageMode"/>
		<field id="startDate"/>
		<field id="endDate"/>
		<field id="ACCNM"/>
		<field id="ACCNO"/>
		<field id="ACTACBL"/>
		<field id="AGREEFLAG"/>
		<field id="AGREEREM"/>
		<field id="AREANAME"/>
		<field id="AUDITFLAG   "/>
		<field id="BATNO"/>
		<field id="BCNB"/>
		<field id="BORNAMT"/>
		<field id="BSNTYPE"/>
		<field id="CHANNEL"/>
		<field id="CRYTYPE"/>
		<field id="CSTRGSTNO"/>
		<field id="EDAM"/>
		<field id="ENDDATE"/>
		<field id="ERRTOTALMONEY"/>
		<field id="ERRTOTALNUM"/>
		<field id="ESSACBL"/>
		<field id="ESSFZBL"/>
		<field id="ESSFZFG"/>
		<field id="FEEAREA"/>
		<field id="FEEMONTH"/>
		<field id="FLAG"/>
		<field id="FLOWID"/>
		<field id="GFYLAMT"/>
		<field id="HOSTNO"/>
		<field id="ID"/>
		<field id="INJUAMT"/>
		<field id="LASTOPRNO"/>
		<field id="LOSTAMT"/>
		<field id="LTMTRDT"/>
		<field id="MEDAMT"/>
		<field id="MOBILE"/>
		<field id="OGRACODE"/>
		<field id="OPRNM"/>
		<field id="OPRNO"/>
		<field id="ORDERNO"/>
		<field id="PAYACC"/>
		<field id="PAYAMT"/>
		<field id="PAYDATE"/>
		<field id="PAYNM"/>
		<field id="PAYSTT"/>
		<field id="PREDATE"/>
		<field id="PREFLG"/>
		<field id="PRETIME"/>
		<field id="PRINTTIME"/>
		<field id="PURPOSE"/>
		<field id="RCDNUM"/>
		<field id="RCDSTT"/>
		<field id="REM"/>
		<field id="RETCODE"/>
		<field id="SIGN    "/>
		<field id="SMTDATE"/>
		<field id="SMTTIME"/>
		<field id="STAM"/>
		<field id="STARTDATE"/>
		<field id="STARTNO"/>
		<field id="STT"/>
		<field id="SUBCHANNEL"/>
		<field id="SUCTOTALMONEY"/>
		<field id="SUCTOTALNUM"/>
		<field id="SUMAMT"/>
		<field id="SXAMT"/>
		<field id="TALNUM"/>
		<field id="TOTNUM"/>
		<field id="TRANFLAG"/>
		<field id="TRANFLOWNO"/>
		<field id="TRNAMT"/>
		<field id="TRNSUM"/>
		<field id="XZCODE"/>
		<field id="YLAMT"/>
		<field id="YLDEAMT"/>
		<field id="YLDWAMT"/>
		<field id="YLGRAMT"/>
		<field id="YLTCTAMT"/>
		<iColl id="userDataList">
			<kColl>
				<field id="ID"/>
				<field id="PREDATE"/>
				<field id="PRETIME"/>
				<field id="PURPOSE"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="CHANNEL"/>
				<field id="BCNB"/>
				<field id="REM"/>
			</kColl>
		</iColl>
		<iColl id="resultList">
			<kColl>
				<field id="CSTRGSTNO"/>
				<field id="BSNTYPE"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="XZCODE"/>
				<field id="PRINTTIME"/>
				<field id="PAYSTT"/>
				<field id="TRANFLOWNO"/>
				<field id="BCNB"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="SUBCHANNEL"/>
				<field id="PAYDATE"/>
				<field id="PAYACC"/>
			</kColl>
		</iColl>
		<iColl id="iFlowId">
			<kColl>
				<field id="flowId"/>
				<field id="flowNm"/>
				<field id="rcvLimit"/>
				<field id="level"/>
				<field id="amtDown"/>
				<field id="amtUp"/>
			</kColl>
		</iColl>
		<field id="RCDSTTVALID" value="1"/>
		<field id="cipherText"/>
		<field id="plainText"/>
		<iColl id="iresultList">
			<kColl>
				<field id="ID"/>
				<field id="FLAG"/>
			</kColl>
		</iColl>
		<field id="TRANFLAGVALID" value="0"/>
		<field id="targetPage"/>
		<field id="std400flow"/>
	</kColl>
	<SQLDefine id="queryHostNo" implClass="com.ecc.emp.jdbc.sql.SQLDefine" access="common" SQLStr="SELECT T.CCI_HOSTNO FROM cb_CST_INF T  WHERE T.CCI_CSTNO =? " sqlType="select">
		<input implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="cstNo"/>
		</input>
		<output implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="HOSTNO"/>
		</output>
	</SQLDefine>
	<SQLDefine id="bsnFlowQrySqlDef" implClass="com.ecc.emp.jdbc.sql.SQLDefine" iCollName="iFlowId" access="common" SQLStr="SELECT cb_cst_bsn.ccb_flowid, cb_cst_bsn.ccb_flownm, cb_cst_bsn.ccb_rcvlimit, ccb_amtdown, ccb_amtup FROM cb_cst_bsn, cb_bsn_opr, cb_bsn_acc WHERE cb_bsn_opr.cbo_oprno = ? AND cb_bsn_opr.cbo_flowid = cb_cst_bsn.ccb_flowid AND cbo_bsncode = 'CB700410' AND cbo_level = 0 AND cb_cst_bsn.ccb_stt = '0' AND cb_bsn_opr.cbo_bsncode = cb_cst_bsn.ccb_bsncode AND cba_flowid = cbo_flowid AND cba_accno = ?" sqlType="select">
		<input implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="oprNo"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="2" dataName="ACCNO"/>
		</input>
		<output implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="flowId" dataType="CHAR"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="2" dataName="flowNm" dataType="VARCHAR"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="3" dataName="rcvLimit" dataType="CHAR"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="4" dataName="amtDown"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="5" dataName="amtUp"/>
		</output>
	</SQLDefine>
	<fmtDef id="CPSSOQRYREQ">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="HOSTNO" tagName="HOSTNO"/>
				<xmlConstantTag tagName="BSNTYPE" value="0"/>
				<xmlFullTag dataName="std400flow" tagName="CPFLOWNO"/>
				<xmlFullTag dataName="FEEMONTH" tagName="FEEMONTH"/>
				<xmlFullTag dataName="STARTDATE" tagName="STARTDATE"/>
				<xmlFullTag dataName="ENDDATE" tagName="ENDDATE"/>
				<xmlConstantTag tagName="STARTNO" value="1"/>
				<xmlConstantTag tagName="RCDNUM" value="10"/>
				<xmlFullTag dataName="SUBCHANNEL" tagName="SUBCHANNEL"/>
				<xmlConstantTag tagName="PAYSTT" value="1"/>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="CPSSOQRYRSP">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTag dataName="recordNum" tagName="TOTNUM"/>
				<xmlIColl dataName="resultList" tagName="resultList">
					<xmlWrap tagName="row">
						<xmlFullTag dataName="CSTRGSTNO" tagName="CSTRGSTNO"/>
						<xmlFullTag dataName="BSNTYPE" tagName="BSNTYPE"/>
						<xmlFullTag dataName="SXAMT" tagName="SXAMT"/>
						<xmlFullTag dataName="MEDAMT" tagName="MEDAMT"/>
						<xmlFullTag dataName="OGRACODE" tagName="OGRACODE"/>
						<xmlFullTag dataName="FEEMONTH" tagName="FEEMONTH"/>
						<xmlFullTag dataName="YLAMT" tagName="YLAMT"/>
						<xmlFullTag dataName="LOSTAMT" tagName="LOSTAMT"/>
						<xmlFullTag dataName="INJUAMT" tagName="INJUAMT"/>
						<xmlFullTag dataName="BORNAMT" tagName="BORNAMT"/>
						<xmlFullTag dataName="YLTCTAMT" tagName="YLTCTAMT"/>
						<xmlFullTag dataName="YLDWAMT" tagName="YLDWAMT"/>
						<xmlFullTag dataName="YLDEAMT" tagName="YLDEAMT"/>
						<xmlFullTag dataName="YLGRAMT" tagName="YLGRAMT"/>
						<xmlFullTag dataName="GFYLAMT" tagName="GFYLAMT"/>
						<xmlFullTag dataName="XZCODE" tagName="XZCODE"/>
						<xmlFullTag dataName="PRINTTIME" tagName="PRINTTIME"/>
						<xmlFullTag dataName="PAYSTT" tagName="PAYSTT"/>
						<xmlFullTag dataName="TRANFLOWNO" tagName="TRANFLOWNO"/>
						<xmlFullTag dataName="BCNB" tagName="BCNB"/>
						<xmlFullTag dataName="FEEAREA" tagName="FEEAREA"/>
						<xmlFullTag dataName="AREANAME" tagName="AREANAME"/>
						<xmlFullTag dataName="HOSTNO" tagName="HOSTNO"/>
						<xmlFullTag dataName="SUMAMT" tagName="SUMAMT"/>
						<xmlFullTag dataName="SUBCHANNEL" tagName="SUBCHANNEL"/>
						<xmlFullTag dataName="PAYDATE" tagName="PAYDATE"/>
					</xmlWrap>
				</xmlIColl>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="EBQEYBALREQ">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="ACCNO" tagName="ACCNO"/>
				<xmlConstantTag tagName="CRYTYPE" value="01"/>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="EBQEYBALRSP">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTag dataName="FLAG" tagName="FLAG"/>
				<xmlFullTag dataName="ACCNO" tagName="ACCNO"/>
				<xmlFullTag dataName="LTMTRDT" tagName="LTMTRDT"/>
				<xmlFullTag dataName="ESSACBL" tagName="ESSACBL"/>
				<xmlFullTag dataName="ACTACBL" tagName="ACTACBL"/>
				<xmlFullTag dataName="ESSFZFG" tagName="ESSFZFG"/>
				<xmlFullTag dataName="ESSFZBL" tagName="ESSFZBL"/>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="CPSSCQRYREQ">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="HOSTNO" tagName="HOSTNO"/>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="CPSSCQRYRSP">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTag dataName="CSTRGSTNO" tagName="CSTRGSTNO"/>
				<xmlFullTag dataName="HOSTNO" tagName="HOSTNO"/>
				<xmlFullTag dataName="ACCNM" tagName="ACCNM"/>
				<xmlFullTag dataName="ACCNO" tagName="ACCNO"/>
				<xmlFullTag dataName="MOBILE" tagName="MOBILE"/>
				<xmlFullTag dataName="TRANFLAG" tagName="TRANFLAG"/>
				<xmlFullTag dataName="RCDSTT" tagName="RCDSTT"/>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="CPSSPSUBREQ">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="FLOWID" tagName="FLOWID"/>
				<xmlFullTag dataName="HOSTNO" tagName="HOSTNO"/>
				<xmlConstantTag tagName="TRNSUM" value="1"/>
				<xmlFullTag dataName="TRNAMT" tagName="TRNAMT"/>
				<xmlConstantTag tagName="CHANNEL" value="N"/>
				<xmlIColl dataName="userDataList" tagName="userDataList">
					<xmlWrap tagName="row">
						<xmlFullTag dataName="ID" tagName="ID"/>
						<xmlConstantTag tagName="PREFLG" value="0"/>
						<xmlFullTag dataName="PREDATE" tagName="PREDATE"/>
						<xmlFullTag dataName="PRETIME" tagName="PRETIME"/>
						<xmlFullTag dataName="PURPOSE" tagName="PURPOSE"/>
						<xmlFullTag dataName="PAYACC" tagName="PAYACC"/>
						<xmlFullTag dataName="PAYNM" tagName="PAYNM"/>
						<xmlFullTag dataName="FEEAREA" tagName="FEEAREA"/>
						<xmlFullTag dataName="AREANAME" tagName="AREANAME"/>
						<xmlFullTag dataName="BSNTYPE" tagName="BSNTYPE"/>
						<xmlFullTag dataName="XZCODE" tagName="XZCODE"/>
						<xmlFullTag dataName="TRANFLOWNO" tagName="TRANFLOWNO"/>
						<xmlFullTag dataName="PAYAMT" tagName="PAYAMT"/>
						<xmlFullTag dataName="SXAMT" tagName="SXAMT"/>
						<xmlFullTag dataName="MEDAMT" tagName="MEDAMT"/>
						<xmlFullTag dataName="OGRACODE" tagName="OGRACODE"/>
						<xmlFullTag dataName="FEEMONTH" tagName="FEEMONTH"/>
						<xmlFullTag dataName="YLAMT" tagName="YLAMT"/>
						<xmlFullTag dataName="LOSTAMT" tagName="LOSTAMT"/>
						<xmlFullTag dataName="INJUAMT" tagName="INJUAMT"/>
						<xmlFullTag dataName="BORNAMT" tagName="BORNAMT"/>
						<xmlFullTag dataName="YLTCTAMT" tagName="YLTCTAMT"/>
						<xmlFullTag dataName="YLDWAMT" tagName="YLDWAMT"/>
						<xmlFullTag dataName="YLDEAMT" tagName="YLDEAMT"/>
						<xmlFullTag dataName="YLGRAMT" tagName="YLGRAMT"/>
						<xmlFullTag dataName="GFYLAMT" tagName="GFYLAMT"/>
						<xmlFullTag dataName="BCNB" tagName="BCNB"/>
						<xmlFullTag dataName="REM" tagName="REM"/>
					</xmlWrap>
				</xmlIColl>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
	<fmtDef id="CPSSPSUBRSP">
		<xmlWrap>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrap tagName="stream">
				<xmlFullTag dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTag dataName="BATNO" tagName="BATNO"/>
				<xmlFullTag dataName="SUCTOTALNUM" tagName="SUCTOTALNUM"/>
				<xmlFullTag dataName="SUCTOTALMONEY" tagName="SUCTOTALMONEY"/>
				<xmlFullTag dataName="ERRTOTALNUM" tagName="ERRTOTALNUM"/>
				<xmlFullTag dataName="ERRTOTALMONEY" tagName="ERRTOTALMONEY"/>
				<xmlIColl dataName="iresultList" tagName="resultList">
					<xmlWrap tagName="row">
						<xmlFullTag dataName="ID" tagName="ID"/>
						<xmlFullTag dataName="FLAG" tagName="FLAG"/>
					</xmlWrap>
				</xmlIColl>
			</xmlWrap>
		</xmlWrap>
	</fmtDef>
</SelfDefinedOp.xml>


<?xml version="1.0" encoding="GBK" ?>


<SelfDefinedOp.xml id="cb700410_socialInsurancePay_input">
	<EMPBusinessLogic id="cb700410_socialInsurancePay_input" operationContext="cb700410_socialInsurancePay_inputSrvCtx">
		<operation id="cb700410_inputList" name="经办页面初始化">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="hostNo"/>
				<field id="recordNum"/>
				<field id="firstKey"/>
				<field id="lastKey"/>
				<field id="pageMode"/>
				<field id="recordSize"/>
				<field id="currentPage"/>
				<field id="targetPage"/>
				<field id="std400flow"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="连接超时"/>
				<action id="EndAction2" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="通讯失败"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询三代客户号" sqlService="SQLExecService" refSQL="queryHostNo" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="SendXml2BpCompAction0"/>
				</action>
				<action id="CompareStringAction0" implClass="com.ecc.emp.action.CompareStringAction" label="比较客户签约信息是否有效" param2="RCDSTT" param1="RCDSTTVALID">
					<transition dest="CompareStringAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="EndAction3" result="notsign" implClass="com.ecc.emp.flow.EMPEndAction" label="客户未签约或签约信息无效"/>
				<action id="CompareStringAction1" implClass="com.ecc.emp.action.CompareStringAction" label="比较批扣代缴标志" param2="TRANFLAG" param1="TRANFLAGVALID">
					<transition dest="SendXml2BpCompAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="SendXml2BpCompAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" sendFormat="CPSSCQRYREQ" tranCode="CPSSCQRY" receiveFormat="CPSSCQRYRSP">
					<transition dest="CompareStringAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
				<action id="SendXml2BpCompAction1" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" label="社保缴费经办前查询" sendFormat="CPSSOQRYREQ" tranCode="CPSSOQRY" receiveFormat="CPSSOQRYRSP">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
			</flow>
		</operation>
		<operation id="cb700410_inputList_bak" name="经办页面初始化">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="hostNo"/>
				<field id="recordNum"/>
				<field id="firstKey"/>
				<field id="lastKey"/>
				<field id="pageMode"/>
				<field id="recordSize"/>
				<field id="currentPage"/>
				<field id="targetPage"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="连接超时"/>
				<action id="EndAction2" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="通讯失败"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询三代客户号" sqlService="SQLExecService" refSQL="queryHostNo" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="SendXml2BpCompAction0"/>
				</action>
				<action id="CompareStringAction0" implClass="com.ecc.emp.action.CompareStringAction" label="比较客户签约信息是否有效" param2="RCDSTT" param1="RCDSTTVALID">
					<transition dest="CompareStringAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="EndAction3" result="notsign" implClass="com.ecc.emp.flow.EMPEndAction" label="客户未签约或签约信息无效"/>
				<action id="CompareStringAction1" implClass="com.ecc.emp.action.CompareStringAction" label="比较批扣代缴标志" param2="TRANFLAG" param1="TRANFLAGVALID">
					<transition dest="SendXml2BpCompAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="SendXml2BpCompAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" sendFormat="CPSSCQRYREQ" tranCode="CPSSCQRY" receiveFormat="CPSSCQRYRSP">
					<transition dest="CompareStringAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
				<action id="SendXml2BpCompAction1" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" label="社保缴费经办前查询" sendFormat="CPSSOQRYREQ" tranCode="CPSSOQRY" receiveFormat="CPSSOQRYRSP">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
			</flow>
		</operation>
		<operation id="cb700410_inputInit" name="经办页面初始化">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="hostNo"/>
				<field id="recordNum"/>
				<field id="firstKey"/>
				<field id="lastKey"/>
				<field id="pageMode"/>
				<field id="recordSize"/>
				<field id="currentPage"/>
				<field id="targetPage"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="连接超时"/>
				<action id="EndAction2" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="通讯失败"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询三代客户号" sqlService="SQLExecService" refSQL="queryHostNo" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="SendXml2BpCompAction0"/>
				</action>
				<action id="CompareStringAction0" implClass="com.ecc.emp.action.CompareStringAction" label="比较客户签约信息是否有效" param2="RCDSTT" param1="RCDSTTVALID">
					<transition dest="CompareStringAction1" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="EndAction3" result="notsign" implClass="com.ecc.emp.flow.EMPEndAction" label="客户未签约或签约信息无效"/>
				<action id="CompareStringAction1" implClass="com.ecc.emp.action.CompareStringAction" label="比较批扣代缴标志" param2="TRANFLAG" param1="TRANFLAGVALID">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction3"/>
				</action>
				<action id="SendXml2BpCompAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" sendFormat="CPSSCQRYREQ" tranCode="CPSSCQRY" receiveFormat="CPSSCQRYRSP">
					<transition dest="CompareStringAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1" condition="$retValue='2'"/>
					<transition dest="EndAction2"/>
				</action>
			</flow>
		</operation>
		<operation id="cb700410_queryAccountBal" name="社保缴费账户余额查询">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="CSTRGSTNO"/>
				<field id="ACTACBL"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="TRNAMT"/>
				<field id="ACCNO"/>
				<field id="ACCNM"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="ID"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="BCNB"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="SQLExecAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction" label="成功"/>
				<action id="SQLExecAction0" implClass="com.ecc.emp.jdbc.sql.SQLExecAction" label="查询业务流程" sqlService="SQLExecService" refSQL="bsnFlowQrySqlDef" transactionType="TRX_REQUIRE_NEW" dataSource="DB2JDBC">
					<transition dest="EndAction0" condition="($retValue='0') or ($retValue='2')"/>
					<transition dest="EndAction1"/>
				</action>
				<action id="EndAction1" result="failed" implClass="com.ecc.emp.flow.EMPEndAction" label="查询失败" errorCode="EC17001"/>
			</flow>
		</operation>
		<operation id="cb700410_inputCfm" name="缴费信息确认">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="CSTRGSTNO"/>
				<field id="ACTACBL"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="TRNAMT"/>
				<field id="ACCNO"/>
				<field id="ACCNM"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="ID"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="BCNB"/>
				<field id="FLOWID"/>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="EndAction0"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction"/>
			</flow>
		</operation>
		<operation id="cb700410_inputSave" name="保存社保缴费经办">
			<input>
				<field id="bsnCode"/>
				<field id="cstNo"/>
				<field id="oprNo"/>
				<field id="EMP_SID"/>
				<field id="loginName"/>
				<field id="oprType"/>
				<field id="session_certSerial"/>
				<field id="logonType"/>
				<field id="cstNmCn"/>
				<field id="oprName"/>
				<field id="CSTRGSTNO"/>
				<field id="ACTACBL"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="TRNAMT"/>
				<field id="ACCNO"/>
				<field id="ACCNM"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="ID"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="BCNB"/>
				<field id="FLOWID"/>
				<field id="TRNSUM"/>
				<field id="cipherText"/>
				<field id="plainText"/>
				<iColl id="userDataList">
					<kColl>
						<field id="ID"/>
						<field id="PREDATE"/>
						<field id="PRETIME"/>
						<field id="PURPOSE"/>
						<field id="PAYACC"/>
						<field id="PAYNM"/>
						<field id="FEEAREA"/>
						<field id="AREANAME"/>
						<field id="BSNTYPE"/>
						<field id="XZCODE"/>
						<field id="TRANFLOWNO"/>
						<field id="PAYAMT"/>
						<field id="SXAMT"/>
						<field id="MEDAMT"/>
						<field id="OGRACODE"/>
						<field id="FEEMONTH"/>
						<field id="YLAMT"/>
						<field id="LOSTAMT"/>
						<field id="INJUAMT"/>
						<field id="BORNAMT"/>
						<field id="YLTCTAMT"/>
						<field id="YLDWAMT"/>
						<field id="YLDEAMT"/>
						<field id="YLGRAMT"/>
						<field id="GFYLAMT"/>
						<field id="CHANNEL"/>
						<field id="BCNB"/>
						<field id="REM"/>
					</kColl>
				</iColl>
			</input>
			<flow>
				<action id="StartAction0" implClass="com.ecc.emp.flow.EMPStartAction">
					<transition dest="VerifySigntureAction0"/>
				</action>
				<action id="SendXml2BpAction0" compMode="1" implClass="com.ecc.corporbank.action.SendXml2BpCompAction" label="社保缴费经办" sendFormat="CPSSPSUBREQ" sendListName="userDataList" tranCode="CPSSPSUB" receiveFormat="CPSSPSUBRSP">
					<transition dest="EndAction0" condition="$retValue='0'"/>
					<transition dest="EndAction2"/>
				</action>
				<action id="EndAction0" result="success" implClass="com.ecc.emp.flow.EMPEndAction"/>
				<action id="VerifySigntureAction0" implClass="com.ecc.corporbank.action.VerifySignatureAction">
					<transition dest="SendXml2BpAction0" condition="$retValue='0'"/>
					<transition dest="EndAction1"/>
				</action>
				<action id="EndAction1" result="fail" implClass="com.ecc.emp.flow.EMPEndAction" label="验签失败"/>
				<action id="EndAction2" result="fail" implClass="com.ecc.emp.flow.EMPEndAction"/>
			</flow>
		</operation>
		<refFormat name="0815reqFmt" refId="0815reqFmt"/>
		<refFormat name="0815rspFmt" refId="0815rspFmt"/>
		<refFormat name="CPSSOQRYREQ" refId="CPSSOQRYREQ"/>
		<refFormat name="CPSSOQRYRSP" refId="CPSSOQRYRSP"/>
		<refFormat name="EBQEYBALREQ" refId="EBQEYBALREQ"/>
		<refFormat name="EBQEYBALRSP" refId="EBQEYBALRSP"/>
		<refFormat name="CPSSCQRYREQ" refId="CPSSCQRYREQ"/>
		<refFormat name="CPSSCQRYRSP" refId="CPSSCQRYRSP"/>
		<refFormat name="CPSSPSUBREQ" refId="CPSSPSUBREQ"/>
		<refFormat name="CPSSPSUBRSP" refId="CPSSPSUBRSP"/>
	</EMPBusinessLogic>
	<context id="cb700410_socialInsurancePay_inputSrvCtx" parent="rootCtx" type="op">
		<refKColl refId="cb700410_socialInsurancePay_inputSrvData"/>
		<refService alias="queryHostNo" type="prv" refId="queryHostNo"/>
		<refService alias="bsnFlowQrySqlDef" type="prv" refId="bsnFlowQrySqlDef"/>
	</context>
	<kColl id="cb700410_socialInsurancePay_inputSrvData">
		<field id="errorCode"/>
		<field id="errorMsg"/>
		<field id="bsnCode"/>
		<field id="cstNo"/>
		<field id="oprNo"/>
		<field id="EMP_SID"/>
		<field id="loginName"/>
		<field id="oprType"/>
		<field id="session_certSerial"/>
		<field id="logonType"/>
		<field id="cstNmCn"/>
		<field id="oprName"/>
		<field id="hostNo"/>
		<field id="recordNum"/>
		<field id="currentPage" value="1"/>
		<field id="recordSize" value="10"/>
		<field id="firstKey"/>
		<field id="lastKey"/>
		<field id="pageMode"/>
		<field id="startDate"/>
		<field id="endDate"/>
		<field id="ACCNM"/>
		<field id="ACCNO"/>
		<field id="ACTACBL"/>
		<field id="AGREEFLAG"/>
		<field id="AGREEREM"/>
		<field id="AREANAME"/>
		<field id="AUDITFLAG   "/>
		<field id="BATNO"/>
		<field id="BCNB"/>
		<field id="BORNAMT"/>
		<field id="BSNTYPE"/>
		<field id="CHANNEL"/>
		<field id="CRYTYPE"/>
		<field id="CSTRGSTNO"/>
		<field id="EDAM"/>
		<field id="ENDDATE"/>
		<field id="ERRTOTALMONEY"/>
		<field id="ERRTOTALNUM"/>
		<field id="ESSACBL"/>
		<field id="ESSFZBL"/>
		<field id="ESSFZFG"/>
		<field id="FEEAREA"/>
		<field id="FEEMONTH"/>
		<field id="FLAG"/>
		<field id="FLOWID"/>
		<field id="GFYLAMT"/>
		<field id="HOSTNO"/>
		<field id="ID"/>
		<field id="INJUAMT"/>
		<field id="LASTOPRNO"/>
		<field id="LOSTAMT"/>
		<field id="LTMTRDT"/>
		<field id="MEDAMT"/>
		<field id="MOBILE"/>
		<field id="OGRACODE"/>
		<field id="OPRNM"/>
		<field id="OPRNO"/>
		<field id="ORDERNO"/>
		<field id="PAYACC"/>
		<field id="PAYAMT"/>
		<field id="PAYDATE"/>
		<field id="PAYNM"/>
		<field id="PAYSTT"/>
		<field id="PREDATE"/>
		<field id="PREFLG"/>
		<field id="PRETIME"/>
		<field id="PRINTTIME"/>
		<field id="PURPOSE"/>
		<field id="RCDNUM"/>
		<field id="RCDSTT"/>
		<field id="REM"/>
		<field id="RETCODE"/>
		<field id="SIGN    "/>
		<field id="SMTDATE"/>
		<field id="SMTTIME"/>
		<field id="STAM"/>
		<field id="STARTDATE"/>
		<field id="STARTNO"/>
		<field id="STT"/>
		<field id="SUBCHANNEL"/>
		<field id="SUCTOTALMONEY"/>
		<field id="SUCTOTALNUM"/>
		<field id="SUMAMT"/>
		<field id="SXAMT"/>
		<field id="TALNUM"/>
		<field id="TOTNUM"/>
		<field id="TRANFLAG"/>
		<field id="TRANFLOWNO"/>
		<field id="TRNAMT"/>
		<field id="TRNSUM"/>
		<field id="XZCODE"/>
		<field id="YLAMT"/>
		<field id="YLDEAMT"/>
		<field id="YLDWAMT"/>
		<field id="YLGRAMT"/>
		<field id="YLTCTAMT"/>
		<iColl id="userDataList">
			<kColl>
				<field id="ID"/>
				<field id="PREDATE"/>
				<field id="PRETIME"/>
				<field id="PURPOSE"/>
				<field id="PAYACC"/>
				<field id="PAYNM"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="BSNTYPE"/>
				<field id="XZCODE"/>
				<field id="TRANFLOWNO"/>
				<field id="PAYAMT"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="CHANNEL"/>
				<field id="BCNB"/>
				<field id="REM"/>
			</kColl>
		</iColl>
		<iColl id="resultList">
			<kColl>
				<field id="CSTRGSTNO"/>
				<field id="BSNTYPE"/>
				<field id="SXAMT"/>
				<field id="MEDAMT"/>
				<field id="OGRACODE"/>
				<field id="FEEMONTH"/>
				<field id="YLAMT"/>
				<field id="LOSTAMT"/>
				<field id="INJUAMT"/>
				<field id="BORNAMT"/>
				<field id="YLTCTAMT"/>
				<field id="YLDWAMT"/>
				<field id="YLDEAMT"/>
				<field id="YLGRAMT"/>
				<field id="GFYLAMT"/>
				<field id="XZCODE"/>
				<field id="PRINTTIME"/>
				<field id="PAYSTT"/>
				<field id="TRANFLOWNO"/>
				<field id="BCNB"/>
				<field id="FEEAREA"/>
				<field id="AREANAME"/>
				<field id="HOSTNO"/>
				<field id="SUMAMT"/>
				<field id="SUBCHANNEL"/>
				<field id="PAYDATE"/>
				<field id="PAYACC"/>
			</kColl>
		</iColl>
		<iColl id="iFlowId">
			<kColl>
				<field id="flowId"/>
				<field id="flowNm"/>
				<field id="rcvLimit"/>
				<field id="level"/>
				<field id="amtDown"/>
				<field id="amtUp"/>
			</kColl>
		</iColl>
		<field id="RCDSTTVALID" value="1"/>
		<field id="cipherText"/>
		<field id="plainText"/>
		<iColl id="iresultList">
			<kColl>
				<field id="ID"/>
				<field id="FLAG"/>
			</kColl>
		</iColl>
		<field id="TRANFLAGVALID" value="0"/>
		<field id="targetPage"/>
		<field id="std400flow"/>
	</kColl>
	<SQLDefine id="queryHostNo" implClass="com.ecc.emp.jdbc.sql.SQLDefine" access="common" SQLStr="SELECT T.CCI_HOSTNO FROM cb_CST_INF T  WHERE T.CCI_CSTNO =? " sqlType="select">
		<input implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="cstNo"/>
		</input>
		<output implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="HOSTNO"/>
		</output>
	</SQLDefine>
	<SQLDefine id="bsnFlowQrySqlDef" implClass="com.ecc.emp.jdbc.sql.SQLDefine" iCollName="iFlowId" access="common" SQLStr="SELECT cb_cst_bsn.ccb_flowid, cb_cst_bsn.ccb_flownm, cb_cst_bsn.ccb_rcvlimit, ccb_amtdown, ccb_amtup FROM cb_cst_bsn, cb_bsn_opr, cb_bsn_acc WHERE cb_bsn_opr.cbo_oprno = ? AND cb_bsn_opr.cbo_flowid = cb_cst_bsn.ccb_flowid AND cbo_bsncode = 'CB700410' AND cbo_level = 0 AND cb_cst_bsn.ccb_stt = '0' AND cb_bsn_opr.cbo_bsncode = cb_cst_bsn.ccb_bsncode AND cba_flowid = cbo_flowid AND cba_accno = ?" sqlType="select">
		<input implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="oprNo"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="2" dataName="ACCNO"/>
		</input>
		<output implClass="com.ecc.emp.jdbc.sql.SQLParameterCollection">
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="1" dataName="flowId" dataType="CHAR"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="2" dataName="flowNm" dataType="VARCHAR"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="3" dataName="rcvLimit" dataType="CHAR"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="4" dataName="amtDown"/>
			<param implClass="com.ecc.emp.jdbc.sql.SQLParameter" idx="5" dataName="amtUp"/>
		</output>
	</SQLDefine>
	<fmtDef id="CPSSOQRYREQ">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="HOSTNO" tagName="HOSTNO"/>
				<xmlConstantTag tagName="BSNTYPE" value="0"/>
				<xmlFullTagBP dataName="std400flow" tagName="CPFLOWNO"/>
				<xmlFullTagBP dataName="FEEMONTH" tagName="FEEMONTH"/>
				<xmlFullTagBP dataName="STARTDATE" tagName="STARTDATE"/>
				<xmlFullTagBP dataName="ENDDATE" tagName="ENDDATE"/>
				<xmlConstantTag tagName="STARTNO" value="1"/>
				<xmlConstantTag tagName="RCDNUM" value="10"/>
				<xmlFullTagBP dataName="SUBCHANNEL" tagName="SUBCHANNEL"/>
				<xmlConstantTag tagName="PAYSTT" value="1"/>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="CPSSOQRYRSP">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTagBP dataName="recordNum" tagName="TOTNUM"/>
				<xmlICollBP dataName="resultList" tagName="resultList">
					<xmlWrapBP tagName="row">
						<xmlFullTagBP dataName="CSTRGSTNO" tagName="CSTRGSTNO"/>
						<xmlFullTagBP dataName="BSNTYPE" tagName="BSNTYPE"/>
						<xmlFullTagBP dataName="SXAMT" tagName="SXAMT"/>
						<xmlFullTagBP dataName="MEDAMT" tagName="MEDAMT"/>
						<xmlFullTagBP dataName="OGRACODE" tagName="OGRACODE"/>
						<xmlFullTagBP dataName="FEEMONTH" tagName="FEEMONTH"/>
						<xmlFullTagBP dataName="YLAMT" tagName="YLAMT"/>
						<xmlFullTagBP dataName="LOSTAMT" tagName="LOSTAMT"/>
						<xmlFullTagBP dataName="INJUAMT" tagName="INJUAMT"/>
						<xmlFullTagBP dataName="BORNAMT" tagName="BORNAMT"/>
						<xmlFullTagBP dataName="YLTCTAMT" tagName="YLTCTAMT"/>
						<xmlFullTagBP dataName="YLDWAMT" tagName="YLDWAMT"/>
						<xmlFullTagBP dataName="YLDEAMT" tagName="YLDEAMT"/>
						<xmlFullTagBP dataName="YLGRAMT" tagName="YLGRAMT"/>
						<xmlFullTagBP dataName="GFYLAMT" tagName="GFYLAMT"/>
						<xmlFullTagBP dataName="XZCODE" tagName="XZCODE"/>
						<xmlFullTagBP dataName="PRINTTIME" tagName="PRINTTIME"/>
						<xmlFullTagBP dataName="PAYSTT" tagName="PAYSTT"/>
						<xmlFullTagBP dataName="TRANFLOWNO" tagName="TRANFLOWNO"/>
						<xmlFullTagBP dataName="BCNB" tagName="BCNB"/>
						<xmlFullTagBP dataName="FEEAREA" tagName="FEEAREA"/>
						<xmlFullTagBP dataName="AREANAME" tagName="AREANAME"/>
						<xmlFullTagBP dataName="HOSTNO" tagName="HOSTNO"/>
						<xmlFullTagBP dataName="SUMAMT" tagName="SUMAMT"/>
						<xmlFullTagBP dataName="SUBCHANNEL" tagName="SUBCHANNEL"/>
						<xmlFullTagBP dataName="PAYDATE" tagName="PAYDATE"/>
					</xmlWrapBP>
				</xmlICollBP>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="EBQEYBALREQ">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="ACCNO" tagName="ACCNO"/>
				<xmlConstantTag tagName="CRYTYPE" value="01"/>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="EBQEYBALRSP">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTagBP dataName="FLAG" tagName="FLAG"/>
				<xmlFullTagBP dataName="ACCNO" tagName="ACCNO"/>
				<xmlFullTagBP dataName="LTMTRDT" tagName="LTMTRDT"/>
				<xmlFullTagBP dataName="ESSACBL" tagName="ESSACBL"/>
				<xmlFullTagBP dataName="ACTACBL" tagName="ACTACBL"/>
				<xmlFullTagBP dataName="ESSFZFG" tagName="ESSFZFG"/>
				<xmlFullTagBP dataName="ESSFZBL" tagName="ESSFZBL"/>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="CPSSCQRYREQ">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="HOSTNO" tagName="HOSTNO"/>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="CPSSCQRYRSP">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTagBP dataName="CSTRGSTNO" tagName="CSTRGSTNO"/>
				<xmlFullTagBP dataName="HOSTNO" tagName="HOSTNO"/>
				<xmlFullTagBP dataName="ACCNM" tagName="ACCNM"/>
				<xmlFullTagBP dataName="ACCNO" tagName="ACCNO"/>
				<xmlFullTagBP dataName="MOBILE" tagName="MOBILE"/>
				<xmlFullTagBP dataName="TRANFLAG" tagName="TRANFLAG"/>
				<xmlFullTagBP dataName="RCDSTT" tagName="RCDSTT"/>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="CPSSPSUBREQ">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="FLOWID" tagName="FLOWID"/>
				<xmlFullTagBP dataName="HOSTNO" tagName="HOSTNO"/>
				<xmlConstantTag tagName="TRNSUM" value="1"/>
				<xmlFullTagBP dataName="TRNAMT" tagName="TRNAMT"/>
				<xmlConstantTag tagName="CHANNEL" value="N"/>
				<xmlICollBP dataName="userDataList" tagName="userDataList">
					<xmlWrapBP tagName="row">
						<xmlFullTagBP dataName="ID" tagName="ID"/>
						<xmlConstantTag tagName="PREFLG" value="0"/>
						<xmlFullTagBP dataName="PREDATE" tagName="PREDATE"/>
						<xmlFullTagBP dataName="PRETIME" tagName="PRETIME"/>
						<xmlFullTagBP dataName="PURPOSE" tagName="PURPOSE"/>
						<xmlFullTagBP dataName="PAYACC" tagName="PAYACC"/>
						<xmlFullTagBP dataName="PAYNM" tagName="PAYNM"/>
						<xmlFullTagBP dataName="FEEAREA" tagName="FEEAREA"/>
						<xmlFullTagBP dataName="AREANAME" tagName="AREANAME"/>
						<xmlFullTagBP dataName="BSNTYPE" tagName="BSNTYPE"/>
						<xmlFullTagBP dataName="XZCODE" tagName="XZCODE"/>
						<xmlFullTagBP dataName="TRANFLOWNO" tagName="TRANFLOWNO"/>
						<xmlFullTagBP dataName="PAYAMT" tagName="PAYAMT"/>
						<xmlFullTagBP dataName="SXAMT" tagName="SXAMT"/>
						<xmlFullTagBP dataName="MEDAMT" tagName="MEDAMT"/>
						<xmlFullTagBP dataName="OGRACODE" tagName="OGRACODE"/>
						<xmlFullTagBP dataName="FEEMONTH" tagName="FEEMONTH"/>
						<xmlFullTagBP dataName="YLAMT" tagName="YLAMT"/>
						<xmlFullTagBP dataName="LOSTAMT" tagName="LOSTAMT"/>
						<xmlFullTagBP dataName="INJUAMT" tagName="INJUAMT"/>
						<xmlFullTagBP dataName="BORNAMT" tagName="BORNAMT"/>
						<xmlFullTagBP dataName="YLTCTAMT" tagName="YLTCTAMT"/>
						<xmlFullTagBP dataName="YLDWAMT" tagName="YLDWAMT"/>
						<xmlFullTagBP dataName="YLDEAMT" tagName="YLDEAMT"/>
						<xmlFullTagBP dataName="YLGRAMT" tagName="YLGRAMT"/>
						<xmlFullTagBP dataName="GFYLAMT" tagName="GFYLAMT"/>
						<xmlFullTagBP dataName="BCNB" tagName="BCNB"/>
						<xmlFullTagBP dataName="REM" tagName="REM"/>
					</xmlWrapBP>
				</xmlICollBP>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
	<fmtDef id="CPSSPSUBRSP">
		<xmlWrapBP>
			<xmlHead version="1.0" encoding="gb2312"/>
			<xmlWrapBP tagName="stream">
				<xmlFullTagBP dataName="RETCODE" tagName="RETCODE"/>
				<xmlFullTagBP dataName="BATNO" tagName="BATNO"/>
				<xmlFullTagBP dataName="SUCTOTALNUM" tagName="SUCTOTALNUM"/>
				<xmlFullTagBP dataName="SUCTOTALMONEY" tagName="SUCTOTALMONEY"/>
				<xmlFullTagBP dataName="ERRTOTALNUM" tagName="ERRTOTALNUM"/>
				<xmlFullTagBP dataName="ERRTOTALMONEY" tagName="ERRTOTALMONEY"/>
				<xmlICollBP dataName="iresultList" tagName="resultList">
					<xmlWrapBP tagName="row">
						<xmlFullTagBP dataName="ID" tagName="ID"/>
						<xmlFullTagBP dataName="FLAG" tagName="FLAG"/>
					</xmlWrapBP>
				</xmlICollBP>
			</xmlWrapBP>
		</xmlWrapBP>
	</fmtDef>
</SelfDefinedOp.xml>
stairheaven
关注
专栏目录
Actual Practise : Row_Number() over(partition by colnum1 order by colnum2 ) as No - 7
SuperBadBoy Test Road
04-13 1718
Let us see a requirement : we need show the Max(ID) of each loan record however each loan has one more records. How will we do? The best and the first way is :Let me show you by Row_Number() Ov
使用C语言操作文件的基本函数整理
09-03
`open()`函数是更通用的文件操作函数，它允许更多的文件操作选项。`open()`函数有两种形式： ```c int open(const char *pathname, int flags); int open(const char *pathname, int flags, mode_t mode); ``` `...
初步认识下Oracel的ROW_NUMBER()Over(partition by order by )
Loong
04-24 1万+
-----删除重复数据 delete from cwgs.loan_buy_extendopr  where oprno in (select oprno           from (select d.oprno,                        d.y_contno,                        row_number() over(partition
DB2字符串处理（一）
weixin_34221775的博客
08-24 605
在DB2查询时，遇到需要将用户名字符串与一个字段记录的中间部分进行匹配的情况，因用户名长度不一，故不便用substring之类函数处理，后综合运用DB2自带的LEFT和LENGTH函数解决。 eg：用户名变量为OPRNO，对应表中字段名为Recomm_ID,形式为TJD（定长）+XXX（用户名、不定长）+20100824090910（定长），查...
C#代码优化方案--使用try catch时不要吃掉你的异常
个人成长记录
01-09 1225
在我们实际开发过程中，一个程序总是调用了很多的方法来实现各种业务需求，我们无法预料到会不会有什么莫名其妙的原因导致某个方法出现异常，同时又觉得这一次异常不应该导致整个程序无法继续运行下去，那么我们会使用try-catch代码块。 如果你是个经验老道的开发者，那么你肯定写过或者是见过只在try里面编写代码，却不在catch里做任何处理的try-catch块。 像是这样： ...
ArcgisOpr CXX0030
冷月宫主的专栏
09-01 2004
这个错误我是找了好多天才找到了   AE（ArcgisEngine）在用VC环境进行开发时，对license的初始化失败， 并在VC的编译输出窗口中提示Could not bind to a valid ArcGIS installation 是因为VC没找到Arcgis Engine的安装位置，参考官网的介绍（好不容易找到的） http://help.arcgis.
操作系统文件管理实验报告(1).doc
12-22
操作系统文件管理实验报告 本实验报告主要介绍了操作系统文件管理的实验过程和结果，涵盖了文件和文件夹的管理、控制面板的设置、Windows 附件的使用等内容。通过实验，掌握了包括文件的管理、控制面板的设置、...
BAT批处理脚本-文件相关操作-批量重命名.zip
最新发布
12-26
这在日常工作中非常常见，例如整理照片、文档或任何其他需要统一命名规则的文件集合。 批量重命名脚本的核心原理是利用Windows命令行工具（CMD）中的REN（rename）命令。REN命令允许用户将一个或多个文件从旧名称...
操作系统概念复习整理笔记
01-04
操作系统概念复习整理笔记 操作系统是计算机系统中的一个系统软件，它管理和控制计算机系统中的资源。操作系统是用户和计算机之间的接口，也是程序和数据结构的集合。操作系统的主要功能是管理计算机系统中的资源，...
C#将文件复制到指定文件夹并整理
09-03
在C#编程中，文件操作是一项常见的任务，包括复制、移动和组织文件。本篇文章主要探讨如何使用C#将文件复制到指定的文件夹并按照时间顺序进行归档。首先，我们将分析一个简单的示例代码，然后介绍两种不同的实现方法...
ROW_NUMBER() OVER函数的基本用法用法
马金波
08-29 6351
语法：ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)例子：row_number() OVER (PARTITION BY COL1 ORDER BY COL2) 表示根据COL1分组，在分组内部根据 COL2排序，而此函数计算的值就表示每组内部排序后的顺序编号（组内连续的唯一的)row_number() 简单易懂的案例
row_number() OVER(PARTITION BY)
热门推荐
あずにゃん梓喵的博客
03-12 13万+
row_number()排序函数 统计每个部门薪资最高的员工信息（同一个部门的员工按照薪资进行降序排序） 第一种写法：row_number() over(partition by 一个或多个分组列 order by 一个或多个排序列 asc/desc) as 别名 //如果不写asc/desc的话，默认为asc 第二种写法：row_number() over...
OVER(PARTITION BY)函数用法
weixin_34273046的博客
10-26 3805
 2010年10月26日OVER(PARTITION BY)函数介绍开窗函数               Oracle从8.1.6开始提供分析函数，分析函数用于计算基于组的某种聚合值，它和聚合函数的不同之处是：对于每个组返回多行，而聚合函数对于每个组只返回一行。      开窗函数指定了分析函数工作的数据窗口大小，这个数据窗口大小可能会随着行的变化而变化，举例如下：1：over后的写法：     ...
select row_number() over (order by ItemID asc) as RowIndex
u012083407的博客
03-05 2966
在使用select row_number() over (order by 字段名 asc) as RowIndex进行分页的时候必须要嵌套在一个select from 语句里面使用，如
找bug
jzl110的博客
12-17 681
      哪里出的bug，问题就在哪里，这次遇到的问题也是这样，但是这次的bug找的有点曲折，首先项目上线已经一年多了，从来没有出现过一次提交，在审批表里边插入过两条除主键不同外完全相同的数据，通过询问使用方是不是进行过连续点击两次提交按钮的情况，对方肯定的说只提交了一次,那么问题就很棘手了，由于提交涉及到一个流程引擎的插件，我被误导的分析插件是不是出了问题，但是插件封装的很严实，分析插件代码不...
SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7
weixin_30737433的博客
08-01 705
错误描述日志： com.ecc.liana.exception.TranFailException: com.ecc.emp.jdbc.EMPJDBCException: Failed to execute procedure[ED_PCKG_LOGON_USER_LOGON]! caused by: DB2 SQL Er ror: SQLCODE=-668, SQLSTATE=57016, ...
XMLTag详解
sunxiaopengsun的专栏
02-05 4820
无论是XMLAttribute还是XMLTag类，都有OSQueueElem fElem成员变量。该变量在构造函数中fElem = this，默认调用了OSQueueElem的构造函数：使得fEnclosingObject指向this。也就是说,XMLAttribute中的fElem::fEnclosingObject指向XMLAttribute，XMLTag中的fElem::fEnclosing
XML解析库 lxml 教程(二)
jianghuixin
10-28 364
Element 类 本篇文章和上一篇文章主要介绍Element对象的操作 字典接口 在 XML 或 HTML 中每一个标签都有属性, Element类通过字典接口支持属性 创建带有属性的Element对象 from lxml import etree # 带属性的 Element root = etree.Element("root", name="root", **{"class": "main"}) # 转化为 XML 标签 root_s = etree.tostring(root).decode
＜transition＞标签的使用
qq_46302247的博客
05-12 4857
参考;https://blog.csdn.net/weixin_43853746/article/details/107051185 vue提供的wrapper包装组件——transition，在包裹的元素中，有涉及到v-if，,v-show, 动态组件,组件根节点,，都会给它们添加进入/离开的过渡效果。。 name属性值： fade 淡入淡出 提供 el-fade-in-linear 和 el-fade-in 两种效果。 zoom 缩放 提供 el-zoom-in-center，el-zoom-in-t
电脑待机蓝屏解决攻略
检查硬盘是否有错误，执行磁盘检查工具，并定期整理磁盘碎片，以保持硬盘健康。 9. 系统散热： 使用系统监控工具检查CPU和硬盘的温度，确保系统散热良好。散热问题可能导致系统不稳定，不仅仅是待机蓝屏。 10. ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值