tbcms017.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 cmstxdethis_trandate[11];
	short cmstxdethis_trandate_id;
	long cmstxdethis_serseqno;
	short cmstxdethis_serseqno_id;
	char cmstxdethis_teller[11];
	short cmstxdethis_teller_id;
	char cmstxdethis_brc[10];
	short cmstxdethis_brc_id;
	char cmstxdethis_frnttrandate[11];
	short cmstxdethis_frnttrandate_id;
	char cmstxdethis_frnttime[7];
	short cmstxdethis_frnttime_id;
	char cmstxdethis_frntstan[9];
	short cmstxdethis_frntstan_id;
	char cmstxdethis_frntno[9];
	short cmstxdethis_frntno_id;
	char cmstxdethis_frntdate[11];
	short cmstxdethis_frntdate_id;
	char cmstxdethis_frnttrancode[7];
	short cmstxdethis_frnttrancode_id;
	char cmstxdethis_frnttrancomm[71];
	short cmstxdethis_frnttrancomm_id;
	char cmstxdethis_settledate[11];
	short cmstxdethis_settledate_id;
	char cmstxdethis_origfrntstan[9];
	short cmstxdethis_origfrntstan_id;
	char cmstxdethis_seqno[7];
	short cmstxdethis_seqno_id;
	char cmstxdethis_subseqno[7];
	short cmstxdethis_subseqno_id;
	char cmstxdethis_operkind[5];
	short cmstxdethis_operkind_id;
	char cmstxdethis_opflag[2];
	short cmstxdethis_opflag_id;
	char cmstxdethis_trancode[7];
	short cmstxdethis_trancode_id;
	char cmstxdethis_cardno1[33];
	short cmstxdethis_cardno1_id;
	char cmstxdethis_acctno1[33];
	short cmstxdethis_acctno1_id;
	char cmstxdethis_subacct1[33];
	short cmstxdethis_subacct1_id;
	char cmstxdethis_acctseqno1[5];
	short cmstxdethis_acctseqno1_id;
	char cmstxdethis_issuebrc1[10];
	short cmstxdethis_issuebrc1_id;
	long cmstxdethis_serverlevel1;
	short cmstxdethis_serverlevel1_id;
	char cmstxdethis_cardno2[33];
	short cmstxdethis_cardno2_id;
	char cmstxdethis_acctno2[33];
	short cmstxdethis_acctno2_id;
	char cmstxdethis_subacct2[33];
	short cmstxdethis_subacct2_id;
	char cmstxdethis_acctseqno2[5];
	short cmstxdethis_acctseqno2_id;
	char cmstxdethis_issuebrc2[10];
	short cmstxdethis_issuebrc2_id;
	long cmstxdethis_serverlevel2;
	short cmstxdethis_serverlevel2_id;
	double cmstxdethis_tranamt;
	short cmstxdethis_tranamt_id;
	char cmstxdethis_ccy[4];
	short cmstxdethis_ccy_id;
	double cmstxdethis_amt2;
	short cmstxdethis_amt2_id;
	char cmstxdethis_ccy2[4];
	short cmstxdethis_ccy2_id;
	double cmstxdethis_amt3;
	short cmstxdethis_amt3_id;
	char cmstxdethis_ccy3[4];
	short cmstxdethis_ccy3_id;
	char cmstxdethis_trandevtype[3];
	short cmstxdethis_trandevtype_id;
	char cmstxdethis_trandevtypecomm[71];
	short cmstxdethis_trandevtypecomm_id;
	char cmstxdethis_cardtrantype[3];
	short cmstxdethis_cardtrantype_id;
	char cmstxdethis_cardtrantypecomm[71];
	short cmstxdethis_cardtrantypecomm_id;
	char cmstxdethis_trankind[4];
	short cmstxdethis_trankind_id;
	char cmstxdethis_trankindcomm[71];
	short cmstxdethis_trankindcomm_id;
	char cmstxdethis_mid[16];
	short cmstxdethis_mid_id;
	char cmstxdethis_mctmcc[5];
	short cmstxdethis_mctmcc_id;
	char cmstxdethis_devid[16];
	short cmstxdethis_devid_id;
	char cmstxdethis_validf[2];
	short cmstxdethis_validf_id;
	double cmstxdethis_delaychg;
	short cmstxdethis_delaychg_id;
	double cmstxdethis_bankgetfee;
	short cmstxdethis_bankgetfee_id;
	double cmstxdethis_custsharefee;
	short cmstxdethis_custsharefee_id;
	double cmstxdethis_banksharefee;
	short cmstxdethis_banksharefee_id;
	double cmstxdethis_bankassfee;
	short cmstxdethis_bankassfee_id;
	double cmstxdethis_bankpayfee;
	short cmstxdethis_bankpayfee_id;
	double cmstxdethis_assfee1;
	short cmstxdethis_assfee1_id;
	double cmstxdethis_assfee2;
	short cmstxdethis_assfee2_id;
	char cmstxdethis_devstan[9];
	short cmstxdethis_devstan_id;
	char cmstxdethis_devdatetime[11];
	short cmstxdethis_devdatetime_id;
	char cmstxdethis_devacqins[12];
	short cmstxdethis_devacqins_id;
	char cmstxdethis_devforwins[12];
	short cmstxdethis_devforwins_id;
	char cmstxdethis_authcode[7];
	short cmstxdethis_authcode_id;
	char cmstxdethis_authenddate[11];
	short cmstxdethis_authenddate_id;
	double cmstxdethis_authamt;
	short cmstxdethis_authamt_id;
	char cmstxdethis_text[129];
	short cmstxdethis_text_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTXDETHIS \
		:cmstxdethis_trandate:cmstxdethis_trandate_id, \
		:cmstxdethis_serseqno:cmstxdethis_serseqno_id, \
		:cmstxdethis_teller:cmstxdethis_teller_id, \
		:cmstxdethis_brc:cmstxdethis_brc_id, \
		:cmstxdethis_frnttrandate:cmstxdethis_frnttrandate_id, \
		:cmstxdethis_frnttime:cmstxdethis_frnttime_id, \
		:cmstxdethis_frntstan:cmstxdethis_frntstan_id, \
		:cmstxdethis_frntno:cmstxdethis_frntno_id, \
		:cmstxdethis_frntdate:cmstxdethis_frntdate_id, \
		:cmstxdethis_frnttrancode:cmstxdethis_frnttrancode_id, \
		:cmstxdethis_frnttrancomm:cmstxdethis_frnttrancomm_id, \
		:cmstxdethis_settledate:cmstxdethis_settledate_id, \
		:cmstxdethis_origfrntstan:cmstxdethis_origfrntstan_id, \
		:cmstxdethis_seqno:cmstxdethis_seqno_id, \
		:cmstxdethis_subseqno:cmstxdethis_subseqno_id, \
		:cmstxdethis_operkind:cmstxdethis_operkind_id, \
		:cmstxdethis_opflag:cmstxdethis_opflag_id, \
		:cmstxdethis_trancode:cmstxdethis_trancode_id, \
		:cmstxdethis_cardno1:cmstxdethis_cardno1_id, \
		:cmstxdethis_acctno1:cmstxdethis_acctno1_id, \
		:cmstxdethis_subacct1:cmstxdethis_subacct1_id, \
		:cmstxdethis_acctseqno1:cmstxdethis_acctseqno1_id, \
		:cmstxdethis_issuebrc1:cmstxdethis_issuebrc1_id, \
		:cmstxdethis_serverlevel1:cmstxdethis_serverlevel1_id, \
		:cmstxdethis_cardno2:cmstxdethis_cardno2_id, \
		:cmstxdethis_acctno2:cmstxdethis_acctno2_id, \
		:cmstxdethis_subacct2:cmstxdethis_subacct2_id, \
		:cmstxdethis_acctseqno2:cmstxdethis_acctseqno2_id, \
		:cmstxdethis_issuebrc2:cmstxdethis_issuebrc2_id, \
		:cmstxdethis_serverlevel2:cmstxdethis_serverlevel2_id, \
		:cmstxdethis_tranamt:cmstxdethis_tranamt_id, \
		:cmstxdethis_ccy:cmstxdethis_ccy_id, \
		:cmstxdethis_amt2:cmstxdethis_amt2_id, \
		:cmstxdethis_ccy2:cmstxdethis_ccy2_id, \
		:cmstxdethis_amt3:cmstxdethis_amt3_id, \
		:cmstxdethis_ccy3:cmstxdethis_ccy3_id, \
		:cmstxdethis_trandevtype:cmstxdethis_trandevtype_id, \
		:cmstxdethis_trandevtypecomm:cmstxdethis_trandevtypecomm_id, \
		:cmstxdethis_cardtrantype:cmstxdethis_cardtrantype_id, \
		:cmstxdethis_cardtrantypecomm:cmstxdethis_cardtrantypecomm_id, \
		:cmstxdethis_trankind:cmstxdethis_trankind_id, \
		:cmstxdethis_trankindcomm:cmstxdethis_trankindcomm_id, \
		:cmstxdethis_mid:cmstxdethis_mid_id, \
		:cmstxdethis_mctmcc:cmstxdethis_mctmcc_id, \
		:cmstxdethis_devid:cmstxdethis_devid_id, \
		:cmstxdethis_validf:cmstxdethis_validf_id, \
		:cmstxdethis_delaychg:cmstxdethis_delaychg_id, \
		:cmstxdethis_bankgetfee:cmstxdethis_bankgetfee_id, \
		:cmstxdethis_custsharefee:cmstxdethis_custsharefee_id, \
		:cmstxdethis_banksharefee:cmstxdethis_banksharefee_id, \
		:cmstxdethis_bankassfee:cmstxdethis_bankassfee_id, \
		:cmstxdethis_bankpayfee:cmstxdethis_bankpayfee_id, \
		:cmstxdethis_assfee1:cmstxdethis_assfee1_id, \
		:cmstxdethis_assfee2:cmstxdethis_assfee2_id, \
		:cmstxdethis_devstan:cmstxdethis_devstan_id, \
		:cmstxdethis_devdatetime:cmstxdethis_devdatetime_id, \
		:cmstxdethis_devacqins:cmstxdethis_devacqins_id, \
		:cmstxdethis_devforwins:cmstxdethis_devforwins_id, \
		:cmstxdethis_authcode:cmstxdethis_authcode_id, \
		:cmstxdethis_authenddate:cmstxdethis_authenddate_id, \
		:cmstxdethis_authamt:cmstxdethis_authamt_id, \
		:cmstxdethis_text:cmstxdethis_text_id

#define UU_CMSTXDETHIS \
		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_CMSTXDETHIS \
		:cmstxdethis_trandate, \
		:cmstxdethis_serseqno, \
		:cmstxdethis_teller, \
		:cmstxdethis_brc, \
		:cmstxdethis_frnttrandate, \
		:cmstxdethis_frnttime, \
		:cmstxdethis_frntstan, \
		:cmstxdethis_frntno, \
		:cmstxdethis_frntdate, \
		:cmstxdethis_frnttrancode, \
		:cmstxdethis_frnttrancomm, \
		:cmstxdethis_settledate, \
		:cmstxdethis_origfrntstan, \
		:cmstxdethis_seqno, \
		:cmstxdethis_subseqno, \
		:cmstxdethis_operkind, \
		:cmstxdethis_opflag, \
		:cmstxdethis_trancode, \
		:cmstxdethis_cardno1, \
		:cmstxdethis_acctno1, \
		:cmstxdethis_subacct1, \
		:cmstxdethis_acctseqno1, \
		:cmstxdethis_issuebrc1, \
		:cmstxdethis_serverlevel1, \
		:cmstxdethis_cardno2, \
		:cmstxdethis_acctno2, \