tbcms002.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 cmscardkind_cardkind[9];
	short cmscardkind_cardkind_id;
	char cmscardkind_cardbin[7];
	short cmscardkind_cardbin_id;
	char cmscardkind_ruleseqno[5];
	short cmscardkind_ruleseqno_id;
	char cmscardkind_voukind[4];
	short cmscardkind_voukind_id;
	char cmscardkind_blankvoukind[4];
	short cmscardkind_blankvoukind_id;
	char cmscardkind_yearfeerank[5];
	short cmscardkind_yearfeerank_id;
	char cmscardkind_enableflg[2];
	short cmscardkind_enableflg_id;
	char cmscardkind_seqflag[2];
	short cmscardkind_seqflag_id;
	char cmscardkind_beginseq[13];
	short cmscardkind_beginseq_id;
	char cmscardkind_endseq[13];
	short cmscardkind_endseq_id;
	char cmscardkind_cardidkind[7];
	short cmscardkind_cardidkind_id;
	char cmscardkind_cardidkindcomm[31];
	short cmscardkind_cardidkindcomm_id;
	double cmscardkind_aplyfee;
	short cmscardkind_aplyfee_id;
	char cmscardkind_cardkindcomm[31];
	short cmscardkind_cardkindcomm_id;
	char cmscardkind_setbrc[10];
	short cmscardkind_setbrc_id;
	char cmscardkind_cardphysort[2];
	short cmscardkind_cardphysort_id;
	char cmscardkind_cardattr[2];
	short cmscardkind_cardattr_id;
	char cmscardkind_cardattrcomm[31];
	short cmscardkind_cardattrcomm_id;
	char cmscardkind_cardflg[2];
	short cmscardkind_cardflg_id;
	char cmscardkind_clsdsten[4];
	short cmscardkind_clsdsten_id;
	char cmscardkind_trancodeset[5];
	short cmscardkind_trancodeset_id;
	long cmscardkind_exdate;
	short cmscardkind_exdate_id;
	long cmscardkind_maxnum;
	short cmscardkind_maxnum_id;
	long cmscardkind_fmaxnum;
	short cmscardkind_fmaxnum_id;
	long cmscardkind_atmerrnum;
	short cmscardkind_atmerrnum_id;
	long cmscardkind_totalerrnum;
	short cmscardkind_totalerrnum_id;
	char cmscardkind_issdate[11];
	short cmscardkind_issdate_id;
	char cmscardkind_ccy[4];
	short cmscardkind_ccy_id;
	char cmscardkind_prdcod[8];
	short cmscardkind_prdcod_id;
	char cmscardkind_pswdmark[2];
	short cmscardkind_pswdmark_id;
	char cmscardkind_lostmark[2];
	short cmscardkind_lostmark_id;
	char cmscardkind_prtpswdenvelop[2];
	short cmscardkind_prtpswdenvelop_id;
	char cmscardkind_setfixexdate[2];
	short cmscardkind_setfixexdate_id;
	char cmscardkind_fixexdate[11];
	short cmscardkind_fixexdate_id;
	char cmscardkind_markflg[2];
	short cmscardkind_markflg_id;
	char cmscardkind_cardobject[2];
	short cmscardkind_cardobject_id;
	double cmscardkind_edbal;
	short cmscardkind_edbal_id;
	double cmscardkind_epbal;
	short cmscardkind_epbal_id;
	double cmscardkind_minbal;
	short cmscardkind_minbal_id;
	char cmscardkind_mid[16];
	short cmscardkind_mid_id;
	char cmscardkind_lasttrandate[11];
	short cmscardkind_lasttrandate_id;
	char cmscardkind_teller[11];
	short cmscardkind_teller_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCARDKIND \
		:cmscardkind_cardkind:cmscardkind_cardkind_id, \
		:cmscardkind_cardbin:cmscardkind_cardbin_id, \
		:cmscardkind_ruleseqno:cmscardkind_ruleseqno_id, \
		:cmscardkind_voukind:cmscardkind_voukind_id, \
		:cmscardkind_blankvoukind:cmscardkind_blankvoukind_id, \
		:cmscardkind_yearfeerank:cmscardkind_yearfeerank_id, \
		:cmscardkind_enableflg:cmscardkind_enableflg_id, \
		:cmscardkind_seqflag:cmscardkind_seqflag_id, \
		:cmscardkind_beginseq:cmscardkind_beginseq_id, \
		:cmscardkind_endseq:cmscardkind_endseq_id, \
		:cmscardkind_cardidkind:cmscardkind_cardidkind_id, \
		:cmscardkind_cardidkindcomm:cmscardkind_cardidkindcomm_id, \
		:cmscardkind_aplyfee:cmscardkind_aplyfee_id, \
		:cmscardkind_cardkindcomm:cmscardkind_cardkindcomm_id, \
		:cmscardkind_setbrc:cmscardkind_setbrc_id, \
		:cmscardkind_cardphysort:cmscardkind_cardphysort_id, \
		:cmscardkind_cardattr:cmscardkind_cardattr_id, \
		:cmscardkind_cardattrcomm:cmscardkind_cardattrcomm_id, \
		:cmscardkind_cardflg:cmscardkind_cardflg_id, \
		:cmscardkind_clsdsten:cmscardkind_clsdsten_id, \
		:cmscardkind_trancodeset:cmscardkind_trancodeset_id, \
		:cmscardkind_exdate:cmscardkind_exdate_id, \
		:cmscardkind_maxnum:cmscardkind_maxnum_id, \
		:cmscardkind_fmaxnum:cmscardkind_fmaxnum_id, \
		:cmscardkind_atmerrnum:cmscardkind_atmerrnum_id, \
		:cmscardkind_totalerrnum:cmscardkind_totalerrnum_id, \
		:cmscardkind_issdate:cmscardkind_issdate_id, \
		:cmscardkind_ccy:cmscardkind_ccy_id, \
		:cmscardkind_prdcod:cmscardkind_prdcod_id, \
		:cmscardkind_pswdmark:cmscardkind_pswdmark_id, \
		:cmscardkind_lostmark:cmscardkind_lostmark_id, \
		:cmscardkind_prtpswdenvelop:cmscardkind_prtpswdenvelop_id, \
		:cmscardkind_setfixexdate:cmscardkind_setfixexdate_id, \
		:cmscardkind_fixexdate:cmscardkind_fixexdate_id, \
		:cmscardkind_markflg:cmscardkind_markflg_id, \
		:cmscardkind_cardobject:cmscardkind_cardobject_id, \
		:cmscardkind_edbal:cmscardkind_edbal_id, \
		:cmscardkind_epbal:cmscardkind_epbal_id, \
		:cmscardkind_minbal:cmscardkind_minbal_id, \
		:cmscardkind_mid:cmscardkind_mid_id, \
		:cmscardkind_lasttrandate:cmscardkind_lasttrandate_id, \
		:cmscardkind_teller:cmscardkind_teller_id

#define UU_CMSCARDKIND \
		cardkind, \
		cardbin, \
		ruleseqno, \
		voukind, \
		blankvoukind, \
		yearfeerank, \
		enableflg, \
		seqflag, \
		beginseq, \
		endseq, \
		cardidkind, \
		cardidkindcomm, \
		aplyfee, \
		cardkindcomm, \
		setbrc, \
		cardphysort, \
		cardattr, \
		cardattrcomm, \
		cardflg, \
		clsdsten, \
		trancodeset, \
		exdate, \
		maxnum, \
		fmaxnum, \
		atmerrnum, \
		totalerrnum, \
		issdate, \
		ccy, \
		prdcod, \
		pswdmark, \
		lostmark, \
		prtpswdenvelop, \
		setfixexdate, \
		fixexdate, \
		markflg, \
		cardobject, \
		edbal, \
		epbal, \
		minbal, \
		mid, \
		lasttrandate, \
		teller

#define WW_CMSCARDKIND \
		:cmscardkind_cardkind, \
		:cmscardkind_cardbin, \
		:cmscardkind_ruleseqno, \
		:cmscardkind_voukind, \
		:cmscardkind_blankvoukind, \
		:cmscardkind_yearfeerank, \
		:cmscardkind_enableflg, \
		:cmscardkind_seqflag, \
		:cmscardkind_beginseq, \
		:cmscardkind_endseq, \
		:cmscardkind_cardidkind, \
		:cmscardkind_cardidkindcomm, \
		:cmscardkind_aplyfee, \
		:cmscardkind_cardkindcomm, \
		:cmscardkind_setbrc, \
		:cmscardkind_cardphysort, \
		:cmscardkind_cardattr, \
		:cmscardkind_cardattrcomm, \
		:cmscardkind_cardflg, \
		:cmscardkind_clsdsten, \
		:cmscardkind_trancodeset, \
		:cmscardkind_exdate, \
		:cmscardkind_maxnum, \
		:cmscardkind_fmaxnum, \
		:cmscardkind_atmerrnum, \
		:cmscardkind_totalerrnum, \
		:cmscardkind_issdate, \
		:cmscardkind_ccy, \
		:cmscardkind_prdcod, \
		:cmscardkind_pswdmark, \
		:cmscardkind_lostmark, \
		:cmscardkind_prtpswdenvelop, \
		:cmscardkind_setfixexdate, \
		:cmscardkind_fixexdate, \
		:cmscardkind_markflg, \
		:cmscardkind_cardobject, \
		:cmscardkind_edbal, \
		:cmscardkind_epbal, \
		:cmscardkind_minbal, \
		:cmscardkind_mid, \
		:cmscardkind_lasttrandate, \
		:cmscardkind_teller

struct cmscardkind
{
	char	cardkind[9];
	char	cardbin[7];
	char	ruleseqno[5];
	char	voukind[4];
	char	blankvoukind[4];
	char	yearfeerank[5];
	char	enableflg[2];
	char	seqflag[2];
	char	beginseq[13];
	char	endseq[13];
	char	cardidkind[7];
	char	cardidkindcomm[31];
	double	aplyfee;
	char	cardkindcomm[31];
	char	setbrc[10];
	char	cardphysort[2];
	char	cardattr[2];
	char	cardattrcomm[31];
	char	cardflg[2];
	char	clsdsten[4];
	char	trancodeset[5];
	long	exdate;
	long	maxnum;
	long	fmaxnum;
	long	atmerrnum;
	long	totalerrnum;
	char	issdate[11];
	char	ccy[4];
	char	prdcod[8];
	char	pswdmark[2];
	char	lostmark[2];
	char	prtpswdenvelop[2];
	char	setfixexdate[2];
	char	fixexdate[11];
	char	markflg[2];
	char	cardobject[2];
	double	edbal;
	double	epbal;
	double	minbal;
	char	mid[16];
	char	lasttrandate[11];
	char	teller[11];
};

void pubInitCmscardkind()
{
	memset( cmscardkind_cardkind, 0x00, sizeof( cmscardkind_cardkind ) ) ;
	cmscardkind_cardkind_id = 0 ;
	memset( cmscardkind_cardbin, 0x00, sizeof( cmscardkind_cardbin ) ) ;
	cmscardkind_cardbin_id = 0 ;
	memset( cmscardkind_ruleseqno, 0x00, sizeof( cmscardkind_ruleseqno ) ) ;
	cmscardkind_ruleseqno_id = 0 ;
	memset( cmscardkind_voukind, 0x00, sizeof( cmscardkind_voukind ) ) ;
	cmscardkind_voukind_id = 0 ;
	memset( cmscardkind_blankvoukind, 0x00, sizeof( cmscardkind_blankvoukind ) ) ;
	cmscardkind_blankvoukind_id = 0 ;
	memset( cmscardkind_yearfeerank, 0x00, sizeof( cmscardkind_yearfeerank ) ) ;
	cmscardkind_yearfeerank_id = 0 ;
	memset( cmscardkind_enableflg, 0x00, sizeof( cmscardkind_enableflg ) ) ;
	cmscardkind_enableflg_id = 0 ;
	memset( cmscardkind_seqflag, 0x00, sizeof( cmscardkind_seqflag ) ) ;
	cmscardkind_seqflag_id = 0 ;
	memset( cmscardkind_beginseq, 0x00, sizeof( cmscardkind_beginseq ) ) ;
	cmscardkind_beginseq_id = 0 ;
	memset( cmscardkind_endseq, 0x00, sizeof( cmscardkind_endseq ) ) ;
	cmscardkind_endseq_id = 0 ;
	memset( cmscardkind_cardidkind, 0x00, sizeof( cmscardkind_cardidkind ) ) ;
	cmscardkind_cardidkind_id = 0 ;
	memset( cmscardkind_cardidkindcomm, 0x00, sizeof( cmscardkind_cardidkindcomm ) ) ;
	cmscardkind_cardidkindcomm_id = 0 ;
	memset( &cmscardkind_aplyfee, 0x00, sizeof( cmscardkind_aplyfee ) ) ;
	cmscardkind_aplyfee_id = 0 ;
	memset( cmscardkind_cardkindcomm, 0x00, sizeof( cmscardkind_cardkindcomm ) ) ;
	cmscardkind_cardkindcomm_id = 0 ;
	memset( cmscardkind_setbrc, 0x00, sizeof( cmscardkind_setbrc ) ) ;
	cmscardkind_setbrc_id = 0 ;
	memset( cmscardkind_cardphysort, 0x00, sizeof( cmscardkind_cardphysort ) ) ;
	cmscardkind_cardphysort_id = 0 ;
	memset( cmscardkind_cardattr, 0x00, sizeof( cmscardkind_cardattr ) ) ;
	cmscardkind_cardattr_id = 0 ;
	memset( cmscardkind_cardattrcomm, 0x00, sizeof( cmscardkind_cardattrcomm ) ) ;
	cmscardkind_cardattrcomm_id = 0 ;
	memset( cmscardkind_cardflg, 0x00, sizeof( cmscardkind_cardflg ) ) ;
	cmscardkind_cardflg_id = 0 ;
	memset( cmscardkind_clsdsten, 0x00, sizeof( cmscardkind_clsdsten ) ) ;
	cmscardkind_clsdsten_id = 0 ;
	memset( cmscardkind_trancodeset, 0x00, sizeof( cmscardkind_trancodeset ) ) ;
	cmscardkind_trancodeset_id = 0 ;
	memset( &cmscardkind_exdate, 0x00, sizeof( cmscardkind_exdate ) ) ;
	cmscardkind_exdate_id = 0 ;
	memset( &cmscardkind_maxnum, 0x00, sizeof( cmscardkind_maxnum ) ) ;
	cmscardkind_maxnum_id = 0 ;
	memset( &cmscardkind_fmaxnum, 0x00, sizeof( cmscardkind_fmaxnum ) ) ;
	cmscardkind_fmaxnum_id = 0 ;
	memset( &cmscardkind_atmerrnum, 0x00, sizeof( cmscardkind_atmerrnum ) ) ;
	cmscardkind_atmerrnum_id = 0 ;
	memset( &cmscardkind_totalerrnum, 0x00, sizeof( cmscardkind_totalerrnum ) ) ;
	cmscardkind_totalerrnum_id = 0 ;
	memset( cmscardkind_issdate, 0x00, sizeof( cmscardkind_issdate ) ) ;
	cmscardkind_issdate_id = 0 ;
	memset( cmscardkind_ccy, 0x00, sizeof( cmscardkind_ccy ) ) ;
	cmscardkind_ccy_id = 0 ;
	memset( cmscardkind_prdcod, 0x00, sizeof( cmscardkind_prdcod ) ) ;
	cmscardkind_prdcod_id = 0 ;
	memset( cmscardkind_pswdmark, 0x00, sizeof( cmscardkind_pswdmark ) ) ;
	cmscardkind_pswdmark_id = 0 ;
	memset( cmscardkind_lostmark, 0x00, sizeof( cmscardkind_lostmark ) ) ;
	cmscardkind_lostmark_id = 0 ;
	memset( cmscardkind_prtpswdenvelop, 0x00, sizeof( cmscardkind_prtpswdenvelop ) ) ;
	cmscardkind_prtpswdenvelop_id = 0 ;
	memset( cmscardkind_setfixexdate, 0x00, sizeof( cmscardkind_setfixexdate ) ) ;
	cmscardkind_setfixexdate_id = 0 ;
	memset( cmscardkind_fixexdate, 0x00, sizeof( cmscardkind_fixexdate ) ) ;
	cmscardkind_fixexdate_id = 0 ;
	memset( cmscardkind_markflg, 0x00, sizeof( cmscardkind_markflg ) ) ;
	cmscardkind_markflg_id = 0 ;
	memset( cmscardkind_cardobject, 0x00, sizeof( cmscardkind_cardobject ) ) ;
	cmscardkind_cardobject_id = 0 ;
	memset( &cmscardkind_edbal, 0x00, sizeof( cmscardkind_edbal ) ) ;
	cmscardkind_edbal_id = 0 ;
	memset( &cmscardkind_epbal, 0x00, sizeof( cmscardkind_epbal ) ) ;
	cmscardkind_epbal_id = 0 ;
	memset( &cmscardkind_minbal, 0x00, sizeof( cmscardkind_minbal ) ) ;
	cmscardkind_minbal_id = 0 ;
	memset( cmscardkind_mid, 0x00, sizeof( cmscardkind_mid ) ) ;
	cmscardkind_mid_id = 0 ;
	memset( cmscardkind_lasttrandate, 0x00, sizeof( cmscardkind_lasttrandate ) ) ;