文件操作待整理

最新推荐文章于 2022-12-12 15:32:20 发布
最新推荐文章于 2022-12-12 15:32:20 发布
阅读量421 收藏
点赞数 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
关注
专栏目录
使用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
Actual Practise : Row_Number() over(partition by colnum1 order by colnum2 ) as No - 7
SuperBadBoy Test Road
04-13 1747
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
mysql order by + limit 效率低下问题
全绽开发工程师的博客
11-12 975
原SQL语句 SELECT tf.* FROM tran_flow tf WHERE TTF_GRPID = '0073' AND TTF_OPRNO = 'cs5' And TTF_BSNCODE = '0101' AND LEFT('20220120', 8) <= LEFT(TTF_SUBMITTIME, 8) AND LEFT('20230120', 8) >= LEFT(TTF_SUBMITTIME, 8) AND (case when '' = '' then 1 = 1 els
pono2的html5无法显示,www.peliculasporno.net
热门推荐
weixin_32602879的博客
07-19 2万+
Domain Name: PELICULASPORNO.NETRegistry Domain ID: 417471116_DOMAIN_NET-VRSNRegistrar WHOIS Server: whois.enom.comRegistrar URL: http://www.enom.comUpdated Date: 2020-03-21T08:21:01ZCreation Date: 200...
row_number() over(partition by over 。。。order by。。。）
zhaotingting686的博客
01-09 385
取分组排序中每组的第一行。。
BAT批处理脚本-文件相关操作-批量重命名.zip
最新发布
12-26
这在日常工作中非常常见，例如整理照片、文档或任何其他需要统一命名规则的文件集合。 批量重命名脚本的核心原理是利用Windows命令行工具（CMD）中的REN（rename）命令。REN命令允许用户将一个或多个文件从旧名称...
操作系统概念复习整理笔记
01-04
操作系统概念复习整理笔记 操作系统是计算机系统中的一个系统软件，它管理和控制计算机系统中的资源。操作系统是用户和计算机之间的接口，也是程序和数据结构的集合。操作系统的主要功能是管理计算机系统中的资源，...
Python文本文件的合并操作方法代码实例
09-17
最后，我们需要调用 `text_file_merger` 函数，并传入包含待合并文件的目录路径。 ```python directory_path = r"D:\日志文件" # 示例中的文件路径 text_file_merger(directory_path) ``` #### 四、代码解析 - **...
操作系统整理资料
12-22
### 操作系统整理资料 #### 重要知识点概览 本篇整理资料主要围绕大学操作系统考试的关键概念和原理展开，深入探讨了操作系统的定义、历史、特征、主要功能以及微内核与客户服务器模式等核心议题。同时，针对进程...
DB2字符串处理（一）
weixin_34221775的博客
08-24 626
在DB2查询时，遇到需要将用户名字符串与一个字段记录的中间部分进行匹配的情况，因用户名长度不一，故不便用substring之类函数处理，后综合运用DB2自带的LEFT和LENGTH函数解决。 eg：用户名变量为OPRNO，对应表中字段名为Recomm_ID,形式为TJD（定长）+XXX（用户名、不定长）+20100824090910（定长），查...
QM Bites – Order Your Includes (Twice Over)
GODCUPID的专栏
06-30 675
Header includes can be a shambles. Matthew Wilson encourages us to bring some order to the chaos. TL;DR Order includes in groups of descending specificity and lexicographically within groupsBite Con
mybatisPlus中MetaObjectHandler使用
fangchen1007的博客
12-12 1680
MetaObjectHandler接口扩展使用
C#代码优化方案--使用try catch时不要吃掉你的异常
个人成长记录
01-09 1252
在我们实际开发过程中，一个程序总是调用了很多的方法来实现各种业务需求，我们无法预料到会不会有什么莫名其妙的原因导致某个方法出现异常，同时又觉得这一次异常不应该导致整个程序无法继续运行下去，那么我们会使用try-catch代码块。 如果你是个经验老道的开发者，那么你肯定写过或者是见过只在try里面编写代码，却不在catch里做任何处理的try-catch块。 像是这样： ...
SM2258XT量产工具下载及错误代码及中文翻译
m0_55207244的博客
04-29 1万+
数据来源SM2258XT_SNK-BiCS3_PKGS1022A_FWS1022A0，给后来者一些查到的错误代码和翻译，以备不时之需。 SM2258XT：不支持外置缓存，性能稳定。SM2256K的成功让慧荣找到了方向，很快慧荣就推出了更加成熟的SM2258XT、SM2258H，一举奠定了其在SSD消费市场的主流地位。 SM2258H、SM2258XT作为消费级SATA SSD主控，它们使得TLC /3D TLC 闪存的SSD能够具有更长的使用寿命，更稳定的读写性能，堪称消费级SATA SSD主控里的经典，
select row_number() over (order by [COLLECTORID]) as no,'26','01',GETDATE(),[COLLECTORID],'0'
July15的博客
03-23 729
select  row_number() over (order by [COLLECTORID]) as no,'26','01',GETDATE(),[COLLECTORID],'0' from GDKY_HB_XTXT_Base_TDD.[dbo].BAS_HECM_COLLECTOR
ArcgisOpr CXX0030
冷月宫主的专栏
09-01 2144
这个错误我是找了好多天才找到了   AE（ArcgisEngine）在用VC环境进行开发时，对license的初始化失败， 并在VC的编译输出窗口中提示Could not bind to a valid ArcGIS installation 是因为VC没找到Arcgis Engine的安装位置，参考官网的介绍（好不容易找到的） http://help.arcgis.
利用row_number() ，over和partition by 语句来操作指定字段重复的数据
SilentJhin
05-21 2200
软件：sql server 2014 核心语句： select row_number() over ( partition by 重复字段 order by 排序字段 ) as flag, * from 表名 1 准备语句： drop table eDelRepeatData create table eDelRepeatData ( ID int identity(1,1...
select row_number() over (order by ItemID asc) as RowIndex
u012083407的博客
03-05 2988
在使用select row_number() over (order by 字段名 asc) as RowIndex进行分页的时候必须要嵌套在一个select from 语句里面使用，如
Python实现高效文件整理与管理工具
源路径指的是待整理的文件所在的文件夹，目标路径则是文件整理后存放的位置。接着，用户可以根据需要在界面中设置图片、视频、音乐等分类，这些分类通过在目标路径中创建对应的文件夹来实现。此外，用户可以使用加...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值