tbcms016.sqc

一整套完整的银行卡系统源代码

/*
** 注    意: 此文件由平台自动生成，禁止任何人以任何方式修改!
** 生成日期: 2004-9-1
** 版 本 号: V1.0.0
** 初始作者: ShiBin Hu
*/

#include	"sysdefine.h"
#include	"code.h"
#include	"attrdef.h"
#include	"revglob.h"
EXEC SQL INCLUDE sqlca;

EXEC SQL BEGIN DECLARE SECTION ;
	char cmstxdet_trandate[11];
	short cmstxdet_trandate_id;
	long cmstxdet_serseqno;
	short cmstxdet_serseqno_id;
	char cmstxdet_teller[11];
	short cmstxdet_teller_id;
	char cmstxdet_brc[10];
	short cmstxdet_brc_id;
	char cmstxdet_frnttrandate[11];
	short cmstxdet_frnttrandate_id;
	char cmstxdet_frnttime[7];
	short cmstxdet_frnttime_id;
	char cmstxdet_frntstan[9];
	short cmstxdet_frntstan_id;
	char cmstxdet_frntno[9];
	short cmstxdet_frntno_id;
	char cmstxdet_frntdate[11];
	short cmstxdet_frntdate_id;
	char cmstxdet_frnttrancode[7];
	short cmstxdet_frnttrancode_id;
	char cmstxdet_frnttrancomm[71];
	short cmstxdet_frnttrancomm_id;
	char cmstxdet_settledate[11];
	short cmstxdet_settledate_id;
	char cmstxdet_origfrntstan[9];
	short cmstxdet_origfrntstan_id;
	char cmstxdet_seqno[7];
	short cmstxdet_seqno_id;
	char cmstxdet_subseqno[7];
	short cmstxdet_subseqno_id;
	char cmstxdet_operkind[5];
	short cmstxdet_operkind_id;
	char cmstxdet_opflag[2];
	short cmstxdet_opflag_id;
	char cmstxdet_trancode[7];
	short cmstxdet_trancode_id;
	char cmstxdet_cardno1[33];
	short cmstxdet_cardno1_id;
	char cmstxdet_acctno1[33];
	short cmstxdet_acctno1_id;
	char cmstxdet_subacct1[33];
	short cmstxdet_subacct1_id;
	char cmstxdet_acctseqno1[5];
	short cmstxdet_acctseqno1_id;
	char cmstxdet_issuebrc1[10];
	short cmstxdet_issuebrc1_id;
	long cmstxdet_serverlevel1;
	short cmstxdet_serverlevel1_id;
	char cmstxdet_cardno2[33];
	short cmstxdet_cardno2_id;
	char cmstxdet_acctno2[33];
	short cmstxdet_acctno2_id;
	char cmstxdet_subacct2[33];
	short cmstxdet_subacct2_id;
	char cmstxdet_acctseqno2[5];
	short cmstxdet_acctseqno2_id;
	char cmstxdet_issuebrc2[10];
	short cmstxdet_issuebrc2_id;
	long cmstxdet_serverlevel2;
	short cmstxdet_serverlevel2_id;
	double cmstxdet_tranamt;
	short cmstxdet_tranamt_id;
	char cmstxdet_ccy[4];
	short cmstxdet_ccy_id;
	double cmstxdet_amt2;
	short cmstxdet_amt2_id;
	char cmstxdet_ccy2[4];
	short cmstxdet_ccy2_id;
	double cmstxdet_amt3;
	short cmstxdet_amt3_id;
	char cmstxdet_ccy3[4];
	short cmstxdet_ccy3_id;
	char cmstxdet_trandevtype[3];
	short cmstxdet_trandevtype_id;
	char cmstxdet_trandevtypecomm[71];
	short cmstxdet_trandevtypecomm_id;
	char cmstxdet_cardtrantype[3];
	short cmstxdet_cardtrantype_id;
	char cmstxdet_cardtrantypecomm[71];
	short cmstxdet_cardtrantypecomm_id;
	char cmstxdet_trankind[4];
	short cmstxdet_trankind_id;
	char cmstxdet_trankindcomm[71];
	short cmstxdet_trankindcomm_id;
	char cmstxdet_mid[16];
	short cmstxdet_mid_id;
	char cmstxdet_mctmcc[5];
	short cmstxdet_mctmcc_id;
	char cmstxdet_devid[16];
	short cmstxdet_devid_id;
	char cmstxdet_validf[2];
	short cmstxdet_validf_id;
	double cmstxdet_delaychg;
	short cmstxdet_delaychg_id;
	double cmstxdet_bankgetfee;
	short cmstxdet_bankgetfee_id;
	double cmstxdet_custsharefee;
	short cmstxdet_custsharefee_id;
	double cmstxdet_banksharefee;
	short cmstxdet_banksharefee_id;
	double cmstxdet_bankassfee;
	short cmstxdet_bankassfee_id;
	double cmstxdet_bankpayfee;
	short cmstxdet_bankpayfee_id;
	double cmstxdet_assfee1;
	short cmstxdet_assfee1_id;
	double cmstxdet_assfee2;
	short cmstxdet_assfee2_id;
	char cmstxdet_devstan[9];
	short cmstxdet_devstan_id;
	char cmstxdet_devdatetime[11];
	short cmstxdet_devdatetime_id;
	char cmstxdet_devacqins[12];
	short cmstxdet_devacqins_id;
	char cmstxdet_devforwins[12];
	short cmstxdet_devforwins_id;
	char cmstxdet_authcode[7];
	short cmstxdet_authcode_id;
	char cmstxdet_authenddate[11];
	short cmstxdet_authenddate_id;
	double cmstxdet_authamt;
	short cmstxdet_authamt_id;
	char cmstxdet_text[129];
	short cmstxdet_text_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTXDET \
		:cmstxdet_trandate:cmstxdet_trandate_id, \
		:cmstxdet_serseqno:cmstxdet_serseqno_id, \
		:cmstxdet_teller:cmstxdet_teller_id, \
		:cmstxdet_brc:cmstxdet_brc_id, \
		:cmstxdet_frnttrandate:cmstxdet_frnttrandate_id, \
		:cmstxdet_frnttime:cmstxdet_frnttime_id, \
		:cmstxdet_frntstan:cmstxdet_frntstan_id, \
		:cmstxdet_frntno:cmstxdet_frntno_id, \
		:cmstxdet_frntdate:cmstxdet_frntdate_id, \
		:cmstxdet_frnttrancode:cmstxdet_frnttrancode_id, \
		:cmstxdet_frnttrancomm:cmstxdet_frnttrancomm_id, \
		:cmstxdet_settledate:cmstxdet_settledate_id, \
		:cmstxdet_origfrntstan:cmstxdet_origfrntstan_id, \
		:cmstxdet_seqno:cmstxdet_seqno_id, \
		:cmstxdet_subseqno:cmstxdet_subseqno_id, \
		:cmstxdet_operkind:cmstxdet_operkind_id, \
		:cmstxdet_opflag:cmstxdet_opflag_id, \
		:cmstxdet_trancode:cmstxdet_trancode_id, \
		:cmstxdet_cardno1:cmstxdet_cardno1_id, \
		:cmstxdet_acctno1:cmstxdet_acctno1_id, \
		:cmstxdet_subacct1:cmstxdet_subacct1_id, \
		:cmstxdet_acctseqno1:cmstxdet_acctseqno1_id, \
		:cmstxdet_issuebrc1:cmstxdet_issuebrc1_id, \
		:cmstxdet_serverlevel1:cmstxdet_serverlevel1_id, \
		:cmstxdet_cardno2:cmstxdet_cardno2_id, \
		:cmstxdet_acctno2:cmstxdet_acctno2_id, \
		:cmstxdet_subacct2:cmstxdet_subacct2_id, \
		:cmstxdet_acctseqno2:cmstxdet_acctseqno2_id, \
		:cmstxdet_issuebrc2:cmstxdet_issuebrc2_id, \
		:cmstxdet_serverlevel2:cmstxdet_serverlevel2_id, \
		:cmstxdet_tranamt:cmstxdet_tranamt_id, \
		:cmstxdet_ccy:cmstxdet_ccy_id, \
		:cmstxdet_amt2:cmstxdet_amt2_id, \
		:cmstxdet_ccy2:cmstxdet_ccy2_id, \
		:cmstxdet_amt3:cmstxdet_amt3_id, \
		:cmstxdet_ccy3:cmstxdet_ccy3_id, \
		:cmstxdet_trandevtype:cmstxdet_trandevtype_id, \
		:cmstxdet_trandevtypecomm:cmstxdet_trandevtypecomm_id, \
		:cmstxdet_cardtrantype:cmstxdet_cardtrantype_id, \
		:cmstxdet_cardtrantypecomm:cmstxdet_cardtrantypecomm_id, \
		:cmstxdet_trankind:cmstxdet_trankind_id, \
		:cmstxdet_trankindcomm:cmstxdet_trankindcomm_id, \
		:cmstxdet_mid:cmstxdet_mid_id, \
		:cmstxdet_mctmcc:cmstxdet_mctmcc_id, \
		:cmstxdet_devid:cmstxdet_devid_id, \
		:cmstxdet_validf:cmstxdet_validf_id, \
		:cmstxdet_delaychg:cmstxdet_delaychg_id, \
		:cmstxdet_bankgetfee:cmstxdet_bankgetfee_id, \
		:cmstxdet_custsharefee:cmstxdet_custsharefee_id, \
		:cmstxdet_banksharefee:cmstxdet_banksharefee_id, \
		:cmstxdet_bankassfee:cmstxdet_bankassfee_id, \
		:cmstxdet_bankpayfee:cmstxdet_bankpayfee_id, \
		:cmstxdet_assfee1:cmstxdet_assfee1_id, \
		:cmstxdet_assfee2:cmstxdet_assfee2_id, \
		:cmstxdet_devstan:cmstxdet_devstan_id, \
		:cmstxdet_devdatetime:cmstxdet_devdatetime_id, \
		:cmstxdet_devacqins:cmstxdet_devacqins_id, \
		:cmstxdet_devforwins:cmstxdet_devforwins_id, \
		:cmstxdet_authcode:cmstxdet_authcode_id, \
		:cmstxdet_authenddate:cmstxdet_authenddate_id, \
		:cmstxdet_authamt:cmstxdet_authamt_id, \
		:cmstxdet_text:cmstxdet_text_id

#define UU_CMSTXDET \
		trandate, \
		serseqno, \
		teller, \
		brc, \
		frnttrandate, \
		frnttime, \
		frntstan, \
		frntno, \
		frntdate, \
		frnttrancode, \
		frnttrancomm, \
		settledate, \
		origfrntstan, \
		seqno, \
		subseqno, \
		operkind, \
		opflag, \
		trancode, \
		cardno1, \
		acctno1, \
		subacct1, \
		acctseqno1, \
		issuebrc1, \
		serverlevel1, \
		cardno2, \
		acctno2, \
		subacct2, \
		acctseqno2, \
		issuebrc2, \
		serverlevel2, \
		tranamt, \
		ccy, \
		amt2, \
		ccy2, \
		amt3, \
		ccy3, \
		trandevtype, \
		trandevtypecomm, \
		cardtrantype, \
		cardtrantypecomm, \
		trankind, \
		trankindcomm, \
		mid, \
		mctmcc, \
		devid, \
		validf, \
		delaychg, \
		bankgetfee, \
		custsharefee, \
		banksharefee, \
		bankassfee, \
		bankpayfee, \
		assfee1, \
		assfee2, \
		devstan, \
		devdatetime, \
		devacqins, \
		devforwins, \
		authcode, \
		authenddate, \
		authamt, \
		text

#define WW_CMSTXDET \
		:cmstxdet_trandate, \
		:cmstxdet_serseqno, \
		:cmstxdet_teller, \
		:cmstxdet_brc, \
		:cmstxdet_frnttrandate, \
		:cmstxdet_frnttime, \
		:cmstxdet_frntstan, \
		:cmstxdet_frntno, \
		:cmstxdet_frntdate, \
		:cmstxdet_frnttrancode, \
		:cmstxdet_frnttrancomm, \
		:cmstxdet_settledate, \
		:cmstxdet_origfrntstan, \
		:cmstxdet_seqno, \
		:cmstxdet_subseqno, \
		:cmstxdet_operkind, \
		:cmstxdet_opflag, \
		:cmstxdet_trancode, \
		:cmstxdet_cardno1, \
		:cmstxdet_acctno1, \
		:cmstxdet_subacct1, \
		:cmstxdet_acctseqno1, \
		:cmstxdet_issuebrc1, \
		:cmstxdet_serverlevel1, \
		:cmstxdet_cardno2, \
		:cmstxdet_acctno2, \
		:cmstxdet_subacct2, \
		:cmstxdet_acctseqno2, \
		:cmstxdet_issuebrc2, \
		:cmstxdet_serverlevel2, \
		:cmstxdet_tranamt, \
		:cmstxdet_ccy, \
		:cmstxdet_amt2, \
		:cmstxdet_ccy2, \
		:cmstxdet_amt3, \
		:cmstxdet_ccy3, \
		:cmstxdet_trandevtype, \
		:cmstxdet_trandevtypecomm, \
		:cmstxdet_cardtrantype, \
		:cmstxdet_cardtrantypecomm, \
		:cmstxdet_trankind, \
		:cmstxdet_trankindcomm, \
		:cmstxdet_mid, \
		:cmstxdet_mctmcc, \
		:cmstxdet_devid, \
		:cmstxdet_validf, \
		:cmstxdet_delaychg, \
		:cmstxdet_bankgetfee, \
		:cmstxdet_custsharefee, \
		:cmstxdet_banksharefee, \
		:cmstxdet_bankassfee, \
		:cmstxdet_bankpayfee, \
		:cmstxdet_assfee1, \
		:cmstxdet_assfee2, \
		:cmstxdet_devstan, \
		:cmstxdet_devdatetime, \
		:cmstxdet_devacqins, \
		:cmstxdet_devforwins, \
		:cmstxdet_authcode, \
		:cmstxdet_authenddate, \
		:cmstxdet_authamt, \
		:cmstxdet_text

struct cmstxdet
{
	char	trandate[11];
	long	serseqno;
	char	teller[11];
	char	brc[10];
	char	frnttrandate[11];
	char	frnttime[7];
	char	frntstan[9];
	char	frntno[9];
	char	frntdate[11];
	char	frnttrancode[7];
	char	frnttrancomm[71];
	char	settledate[11];
	char	origfrntstan[9];
	char	seqno[7];
	char	subseqno[7];
	char	operkind[5];
	char	opflag[2];
	char	trancode[7];
	char	cardno1[33];
	char	acctno1[33];
	char	subacct1[33];
	char	acctseqno1[5];
	char	issuebrc1[10];
	long	serverlevel1;
	char	cardno2[33];
	char	acctno2[33];
	char	subacct2[33];
	char	acctseqno2[5];
	char	issuebrc2[10];
	long	serverlevel2;
	double	tranamt;
	char	ccy[4];
	double	amt2;
	char	ccy2[4];
	double	amt3;
	char	ccy3[4];
	char	trandevtype[3];
	char	trandevtypecomm[71];
	char	cardtrantype[3];
	char	cardtrantypecomm[71];
	char	trankind[4];
	char	trankindcomm[71];
	char	mid[16];
	char	mctmcc[5];
	char	devid[16];
	char	validf[2];
	double	delaychg;
	double	bankgetfee;
	double	custsharefee;
	double	banksharefee;
	double	bankassfee;
	double	bankpayfee;
	double	assfee1;
	double	assfee2;
	char	devstan[9];
	char	devdatetime[11];
	char	devacqins[12];
	char	devforwins[12];
	char	authcode[7];
	char	authenddate[11];
	double	authamt;
	char	text[129];
};

void pubInitCmstxdet()
{
	memset( cmstxdet_trandate, 0x00, sizeof( cmstxdet_trandate ) ) ;
	cmstxdet_trandate_id = 0 ;
	memset( &cmstxdet_serseqno, 0x00, sizeof( cmstxdet_serseqno ) ) ;
	cmstxdet_serseqno_id = 0 ;
	memset( cmstxdet_teller, 0x00, sizeof( cmstxdet_teller ) ) ;
	cmstxdet_teller_id = 0 ;
	memset( cmstxdet_brc, 0x00, sizeof( cmstxdet_brc ) ) ;
	cmstxdet_brc_id = 0 ;
	memset( cmstxdet_frnttrandate, 0x00, sizeof( cmstxdet_frnttrandate ) ) ;
	cmstxdet_frnttrandate_id = 0 ;
	memset( cmstxdet_frnttime, 0x00, sizeof( cmstxdet_frnttime ) ) ;
	cmstxdet_frnttime_id = 0 ;
	memset( cmstxdet_frntstan, 0x00, sizeof( cmstxdet_frntstan ) ) ;
	cmstxdet_frntstan_id = 0 ;
	memset( cmstxdet_frntno, 0x00, sizeof( cmstxdet_frntno ) ) ;
	cmstxdet_frntno_id = 0 ;
	memset( cmstxdet_frntdate, 0x00, sizeof( cmstxdet_frntdate ) ) ;
	cmstxdet_frntdate_id = 0 ;
	memset( cmstxdet_frnttrancode, 0x00, sizeof( cmstxdet_frnttrancode ) ) ;
	cmstxdet_frnttrancode_id = 0 ;
	memset( cmstxdet_frnttrancomm, 0x00, sizeof( cmstxdet_frnttrancomm ) ) ;
	cmstxdet_frnttrancomm_id = 0 ;
	memset( cmstxdet_settledate, 0x00, sizeof( cmstxdet_settledate ) ) ;
	cmstxdet_settledate_id = 0 ;
	memset( cmstxdet_origfrntstan, 0x00, sizeof( cmstxdet_origfrntstan ) ) ;
	cmstxdet_origfrntstan_id = 0 ;
	memset( cmstxdet_seqno, 0x00, sizeof( cmstxdet_seqno ) ) ;
	cmstxdet_seqno_id = 0 ;
	memset( cmstxdet_subseqno, 0x00, sizeof( cmstxdet_subseqno ) ) ;
	cmstxdet_subseqno_id = 0 ;
	memset( cmstxdet_operkind, 0x00, sizeof( cmstxdet_operkind ) ) ;
	cmstxdet_operkind_id = 0 ;
	memset( cmstxdet_opflag, 0x00, sizeof( cmstxdet_opflag ) ) ;
	cmstxdet_opflag_id = 0 ;
	memset( cmstxdet_trancode, 0x00, sizeof( cmstxdet_trancode ) ) ;
	cmstxdet_trancode_id = 0 ;
	memset( cmstxdet_cardno1, 0x00, sizeof( cmstxdet_cardno1 ) ) ;
	cmstxdet_cardno1_id = 0 ;
	memset( cmstxdet_acctno1, 0x00, sizeof( cmstxdet_acctno1 ) ) ;
	cmstxdet_acctno1_id = 0 ;
	memset( cmstxdet_subacct1, 0x00, sizeof( cmstxdet_subacct1 ) ) ;
	cmstxdet_subacct1_id = 0 ;