tbcms021.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 cmscardinfo_cardno[20];
	short cmscardinfo_cardno_id;
	char cmscardinfo_cardseqno[4];
	short cmscardinfo_cardseqno_id;
	char cmscardinfo_cardkind[9];
	short cmscardinfo_cardkind_id;
	long cmscardinfo_serverlevel;
	short cmscardinfo_serverlevel_id;
	char cmscardinfo_yearfeerank[5];
	short cmscardinfo_yearfeerank_id;
	char cmscardinfo_cardflg[2];
	short cmscardinfo_cardflg_id;
	char cmscardinfo_cardobject[2];
	short cmscardinfo_cardobject_id;
	char cmscardinfo_cardattr[2];
	short cmscardinfo_cardattr_id;
	char cmscardinfo_markflg[2];
	short cmscardinfo_markflg_id;
	char cmscardinfo_cardidkind[7];
	short cmscardinfo_cardidkind_id;
	char cmscardinfo_cardidkindcomm[31];
	short cmscardinfo_cardidkindcomm_id;
	char cmscardinfo_acctseqno[5];
	short cmscardinfo_acctseqno_id;
	char cmscardinfo_acctno[33];
	short cmscardinfo_acctno_id;
	char cmscardinfo_subacct[33];
	short cmscardinfo_subacct_id;
	char cmscardinfo_issuebrc[10];
	short cmscardinfo_issuebrc_id;
	char cmscardinfo_teller[11];
	short cmscardinfo_teller_id;
	char cmscardinfo_clsbrc[10];
	short cmscardinfo_clsbrc_id;
	char cmscardinfo_clsteller[11];
	short cmscardinfo_clsteller_id;
	char cmscardinfo_custno[31];
	short cmscardinfo_custno_id;
	char cmscardinfo_maincardno[20];
	short cmscardinfo_maincardno_id;
	char cmscardinfo_passwd[17];
	short cmscardinfo_passwd_id;
	long cmscardinfo_errnum;
	short cmscardinfo_errnum_id;
	long cmscardinfo_errnumtot;
	short cmscardinfo_errnumtot_id;
	char cmscardinfo_usedate[11];
	short cmscardinfo_usedate_id;
	char cmscardinfo_closedate[11];
	short cmscardinfo_closedate_id;
	char cmscardinfo_chgdate[11];
	short cmscardinfo_chgdate_id;
	char cmscardinfo_crdsts[2];
	short cmscardinfo_crdsts_id;
	char cmscardinfo_cardstat[21];
	short cmscardinfo_cardstat_id;
	long cmscardinfo_acdcnt;
	short cmscardinfo_acdcnt_id;
	double cmscardinfo_acdlmt;
	short cmscardinfo_acdlmt_id;
	double cmscardinfo_acduseamt;
	short cmscardinfo_acduseamt_id;
	char cmscardinfo_oldcardno[20];
	short cmscardinfo_oldcardno_id;
	char cmscardinfo_newcardno[20];
	short cmscardinfo_newcardno_id;
	char cmscardinfo_hasbankbook[2];
	short cmscardinfo_hasbankbook_id;
	char cmscardinfo_empflg[2];
	short cmscardinfo_empflg_id;
	char cmscardinfo_validdate[11];
	short cmscardinfo_validdate_id;
	char cmscardinfo_yfeeflag[2];
	short cmscardinfo_yfeeflag_id;
	char cmscardinfo_yfeeyear[5];
	short cmscardinfo_yfeeyear_id;
	double cmscardinfo_yfee;
	short cmscardinfo_yfee_id;
	double cmscardinfo_yfeebal;
	short cmscardinfo_yfeebal_id;
	char cmscardinfo_madfeeflag[2];
	short cmscardinfo_madfeeflag_id;
	char cmscardinfo_cardsn[20];
	short cmscardinfo_cardsn_id;
	char cmscardinfo_voukind[4];
	short cmscardinfo_voukind_id;
	char cmscardinfo_vouno[21];
	short cmscardinfo_vouno_id;
	char cmscardinfo_precharcode[7];
	short cmscardinfo_precharcode_id;
	char cmscardinfo_lastdate[11];
	short cmscardinfo_lastdate_id;
	char cmscardinfo_billway[2];
	short cmscardinfo_billway_id;
	char cmscardinfo_billaddtype[2];
	short cmscardinfo_billaddtype_id;
	char cmscardinfo_cardsrc[21];
	short cmscardinfo_cardsrc_id;
	double cmscardinfo_currbal;
	short cmscardinfo_currbal_id;
	double cmscardinfo_availbal;
	short cmscardinfo_availbal_id;
	char cmscardinfo_areacode[5];
	short cmscardinfo_areacode_id;
	char cmscardinfo_cardoffset[17];
	short cmscardinfo_cardoffset_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCARDINFO \
		:cmscardinfo_cardno:cmscardinfo_cardno_id, \
		:cmscardinfo_cardseqno:cmscardinfo_cardseqno_id, \
		:cmscardinfo_cardkind:cmscardinfo_cardkind_id, \
		:cmscardinfo_serverlevel:cmscardinfo_serverlevel_id, \
		:cmscardinfo_yearfeerank:cmscardinfo_yearfeerank_id, \
		:cmscardinfo_cardflg:cmscardinfo_cardflg_id, \
		:cmscardinfo_cardobject:cmscardinfo_cardobject_id, \
		:cmscardinfo_cardattr:cmscardinfo_cardattr_id, \
		:cmscardinfo_markflg:cmscardinfo_markflg_id, \
		:cmscardinfo_cardidkind:cmscardinfo_cardidkind_id, \
		:cmscardinfo_cardidkindcomm:cmscardinfo_cardidkindcomm_id, \
		:cmscardinfo_acctseqno:cmscardinfo_acctseqno_id, \
		:cmscardinfo_acctno:cmscardinfo_acctno_id, \
		:cmscardinfo_subacct:cmscardinfo_subacct_id, \
		:cmscardinfo_issuebrc:cmscardinfo_issuebrc_id, \
		:cmscardinfo_teller:cmscardinfo_teller_id, \
		:cmscardinfo_clsbrc:cmscardinfo_clsbrc_id, \
		:cmscardinfo_clsteller:cmscardinfo_clsteller_id, \
		:cmscardinfo_custno:cmscardinfo_custno_id, \
		:cmscardinfo_maincardno:cmscardinfo_maincardno_id, \
		:cmscardinfo_passwd:cmscardinfo_passwd_id, \
		:cmscardinfo_errnum:cmscardinfo_errnum_id, \
		:cmscardinfo_errnumtot:cmscardinfo_errnumtot_id, \
		:cmscardinfo_usedate:cmscardinfo_usedate_id, \
		:cmscardinfo_closedate:cmscardinfo_closedate_id, \
		:cmscardinfo_chgdate:cmscardinfo_chgdate_id, \
		:cmscardinfo_crdsts:cmscardinfo_crdsts_id, \
		:cmscardinfo_cardstat:cmscardinfo_cardstat_id, \
		:cmscardinfo_acdcnt:cmscardinfo_acdcnt_id, \
		:cmscardinfo_acdlmt:cmscardinfo_acdlmt_id, \
		:cmscardinfo_acduseamt:cmscardinfo_acduseamt_id, \
		:cmscardinfo_oldcardno:cmscardinfo_oldcardno_id, \
		:cmscardinfo_newcardno:cmscardinfo_newcardno_id, \
		:cmscardinfo_hasbankbook:cmscardinfo_hasbankbook_id, \
		:cmscardinfo_empflg:cmscardinfo_empflg_id, \
		:cmscardinfo_validdate:cmscardinfo_validdate_id, \
		:cmscardinfo_yfeeflag:cmscardinfo_yfeeflag_id, \
		:cmscardinfo_yfeeyear:cmscardinfo_yfeeyear_id, \
		:cmscardinfo_yfee:cmscardinfo_yfee_id, \
		:cmscardinfo_yfeebal:cmscardinfo_yfeebal_id, \
		:cmscardinfo_madfeeflag:cmscardinfo_madfeeflag_id, \
		:cmscardinfo_cardsn:cmscardinfo_cardsn_id, \
		:cmscardinfo_voukind:cmscardinfo_voukind_id, \
		:cmscardinfo_vouno:cmscardinfo_vouno_id, \
		:cmscardinfo_precharcode:cmscardinfo_precharcode_id, \
		:cmscardinfo_lastdate:cmscardinfo_lastdate_id, \
		:cmscardinfo_billway:cmscardinfo_billway_id, \
		:cmscardinfo_billaddtype:cmscardinfo_billaddtype_id, \
		:cmscardinfo_cardsrc:cmscardinfo_cardsrc_id, \
		:cmscardinfo_currbal:cmscardinfo_currbal_id, \
		:cmscardinfo_availbal:cmscardinfo_availbal_id, \
		:cmscardinfo_areacode:cmscardinfo_areacode_id, \
		:cmscardinfo_cardoffset:cmscardinfo_cardoffset_id

#define UU_CMSCARDINFO \
		cardno, \
		cardseqno, \
		cardkind, \
		serverlevel, \
		yearfeerank, \
		cardflg, \
		cardobject, \
		cardattr, \
		markflg, \
		cardidkind, \
		cardidkindcomm, \
		acctseqno, \
		acctno, \
		subacct, \
		issuebrc, \
		teller, \
		clsbrc, \
		clsteller, \
		custno, \
		maincardno, \
		passwd, \
		errnum, \
		errnumtot, \
		usedate, \
		closedate, \
		chgdate, \
		crdsts, \
		cardstat, \
		acdcnt, \
		acdlmt, \
		acduseamt, \
		oldcardno, \
		newcardno, \
		hasbankbook, \
		empflg, \
		validdate, \
		yfeeflag, \
		yfeeyear, \
		yfee, \
		yfeebal, \
		madfeeflag, \
		cardsn, \
		voukind, \
		vouno, \
		precharcode, \
		lastdate, \
		billway, \
		billaddtype, \
		cardsrc, \
		currbal, \
		availbal, \
		areacode, \
		cardoffset

#define WW_CMSCARDINFO \
		:cmscardinfo_cardno, \
		:cmscardinfo_cardseqno, \
		:cmscardinfo_cardkind, \
		:cmscardinfo_serverlevel, \
		:cmscardinfo_yearfeerank, \
		:cmscardinfo_cardflg, \
		:cmscardinfo_cardobject, \
		:cmscardinfo_cardattr, \
		:cmscardinfo_markflg, \
		:cmscardinfo_cardidkind, \
		:cmscardinfo_cardidkindcomm, \
		:cmscardinfo_acctseqno, \
		:cmscardinfo_acctno, \
		:cmscardinfo_subacct, \
		:cmscardinfo_issuebrc, \
		:cmscardinfo_teller, \
		:cmscardinfo_clsbrc, \
		:cmscardinfo_clsteller, \
		:cmscardinfo_custno, \
		:cmscardinfo_maincardno, \
		:cmscardinfo_passwd, \
		:cmscardinfo_errnum, \
		:cmscardinfo_errnumtot, \
		:cmscardinfo_usedate, \
		:cmscardinfo_closedate, \
		:cmscardinfo_chgdate, \
		:cmscardinfo_crdsts, \
		:cmscardinfo_cardstat, \
		:cmscardinfo_acdcnt, \
		:cmscardinfo_acdlmt, \
		:cmscardinfo_acduseamt, \
		:cmscardinfo_oldcardno, \
		:cmscardinfo_newcardno, \
		:cmscardinfo_hasbankbook, \
		:cmscardinfo_empflg, \
		:cmscardinfo_validdate, \
		:cmscardinfo_yfeeflag, \
		:cmscardinfo_yfeeyear, \
		:cmscardinfo_yfee, \
		:cmscardinfo_yfeebal, \
		:cmscardinfo_madfeeflag, \
		:cmscardinfo_cardsn, \
		:cmscardinfo_voukind, \
		:cmscardinfo_vouno, \
		:cmscardinfo_precharcode, \
		:cmscardinfo_lastdate, \
		:cmscardinfo_billway, \
		:cmscardinfo_billaddtype, \
		:cmscardinfo_cardsrc, \
		:cmscardinfo_currbal, \
		:cmscardinfo_availbal, \
		:cmscardinfo_areacode, \
		:cmscardinfo_cardoffset

struct cmscardinfo
{
	char	cardno[20];
	char	cardseqno[4];
	char	cardkind[9];
	long	serverlevel;
	char	yearfeerank[5];
	char	cardflg[2];
	char	cardobject[2];
	char	cardattr[2];