tbcms035.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 cmsmerchantinfo_mid[16];
	short cmsmerchantinfo_mid_id;
	char cmsmerchantinfo_mctname[71];
	short cmsmerchantinfo_mctname_id;
	char cmsmerchantinfo_mctmcc[5];
	short cmsmerchantinfo_mctmcc_id;
	char cmsmerchantinfo_goingteleno[21];
	short cmsmerchantinfo_goingteleno_id;
	char cmsmerchantinfo_conperidtype[3];
	short cmsmerchantinfo_conperidtype_id;
	char cmsmerchantinfo_conperidcode[21];
	short cmsmerchantinfo_conperidcode_id;
	char cmsmerchantinfo_conpername[71];
	short cmsmerchantinfo_conpername_id;
	char cmsmerchantinfo_conperteleno[21];
	short cmsmerchantinfo_conperteleno_id;
	char cmsmerchantinfo_conpermobno[21];
	short cmsmerchantinfo_conpermobno_id;
	char cmsmerchantinfo_conperbpno[21];
	short cmsmerchantinfo_conperbpno_id;
	char cmsmerchantinfo_mctaddress[61];
	short cmsmerchantinfo_mctaddress_id;
	char cmsmerchantinfo_midaccno[33];
	short cmsmerchantinfo_midaccno_id;
	char cmsmerchantinfo_brc[10];
	short cmsmerchantinfo_brc_id;
	double cmsmerchantinfo_rakeoffratefix;
	short cmsmerchantinfo_rakeoffratefix_id;
	double cmsmerchantinfo_rakeofffix;
	short cmsmerchantinfo_rakeofffix_id;
	double cmsmerchantinfo_lowlimit;
	short cmsmerchantinfo_lowlimit_id;
	double cmsmerchantinfo_highlimit;
	short cmsmerchantinfo_highlimit_id;
	char cmsmerchantinfo_rakeoffflg[2];
	short cmsmerchantinfo_rakeoffflg_id;
	char cmsmerchantinfo_opnflg[2];
	short cmsmerchantinfo_opnflg_id;
	char cmsmerchantinfo_settleaccno[33];
	short cmsmerchantinfo_settleaccno_id;
	char cmsmerchantinfo_opnbankname[71];
	short cmsmerchantinfo_opnbankname_id;
	char cmsmerchantinfo_opnbankexchcode[7];
	short cmsmerchantinfo_opnbankexchcode_id;
	char cmsmerchantinfo_mctflg[2];
	short cmsmerchantinfo_mctflg_id;
	char cmsmerchantinfo_description[41];
	short cmsmerchantinfo_description_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSMERCHANTINFO \
		:cmsmerchantinfo_mid:cmsmerchantinfo_mid_id, \
		:cmsmerchantinfo_mctname:cmsmerchantinfo_mctname_id, \
		:cmsmerchantinfo_mctmcc:cmsmerchantinfo_mctmcc_id, \
		:cmsmerchantinfo_goingteleno:cmsmerchantinfo_goingteleno_id, \
		:cmsmerchantinfo_conperidtype:cmsmerchantinfo_conperidtype_id, \
		:cmsmerchantinfo_conperidcode:cmsmerchantinfo_conperidcode_id, \
		:cmsmerchantinfo_conpername:cmsmerchantinfo_conpername_id, \
		:cmsmerchantinfo_conperteleno:cmsmerchantinfo_conperteleno_id, \
		:cmsmerchantinfo_conpermobno:cmsmerchantinfo_conpermobno_id, \
		:cmsmerchantinfo_conperbpno:cmsmerchantinfo_conperbpno_id, \
		:cmsmerchantinfo_mctaddress:cmsmerchantinfo_mctaddress_id, \
		:cmsmerchantinfo_midaccno:cmsmerchantinfo_midaccno_id, \
		:cmsmerchantinfo_brc:cmsmerchantinfo_brc_id, \
		:cmsmerchantinfo_rakeoffratefix:cmsmerchantinfo_rakeoffratefix_id, \
		:cmsmerchantinfo_rakeofffix:cmsmerchantinfo_rakeofffix_id, \
		:cmsmerchantinfo_lowlimit:cmsmerchantinfo_lowlimit_id, \
		:cmsmerchantinfo_highlimit:cmsmerchantinfo_highlimit_id, \
		:cmsmerchantinfo_rakeoffflg:cmsmerchantinfo_rakeoffflg_id, \
		:cmsmerchantinfo_opnflg:cmsmerchantinfo_opnflg_id, \
		:cmsmerchantinfo_settleaccno:cmsmerchantinfo_settleaccno_id, \
		:cmsmerchantinfo_opnbankname:cmsmerchantinfo_opnbankname_id, \
		:cmsmerchantinfo_opnbankexchcode:cmsmerchantinfo_opnbankexchcode_id, \
		:cmsmerchantinfo_mctflg:cmsmerchantinfo_mctflg_id, \
		:cmsmerchantinfo_description:cmsmerchantinfo_description_id

#define UU_CMSMERCHANTINFO \
		mid, \
		mctname, \
		mctmcc, \
		goingteleno, \
		conperidtype, \
		conperidcode, \
		conpername, \
		conperteleno, \
		conpermobno, \
		conperbpno, \
		mctaddress, \
		midaccno, \
		brc, \
		rakeoffratefix, \
		rakeofffix, \
		lowlimit, \
		highlimit, \
		rakeoffflg, \
		opnflg, \
		settleaccno, \
		opnbankname, \
		opnbankexchcode, \
		mctflg, \
		description

#define WW_CMSMERCHANTINFO \
		:cmsmerchantinfo_mid, \
		:cmsmerchantinfo_mctname, \
		:cmsmerchantinfo_mctmcc, \
		:cmsmerchantinfo_goingteleno, \
		:cmsmerchantinfo_conperidtype, \
		:cmsmerchantinfo_conperidcode, \
		:cmsmerchantinfo_conpername, \
		:cmsmerchantinfo_conperteleno, \
		:cmsmerchantinfo_conpermobno, \
		:cmsmerchantinfo_conperbpno, \
		:cmsmerchantinfo_mctaddress, \
		:cmsmerchantinfo_midaccno, \
		:cmsmerchantinfo_brc, \
		:cmsmerchantinfo_rakeoffratefix, \
		:cmsmerchantinfo_rakeofffix, \
		:cmsmerchantinfo_lowlimit, \
		:cmsmerchantinfo_highlimit, \
		:cmsmerchantinfo_rakeoffflg, \
		:cmsmerchantinfo_opnflg, \
		:cmsmerchantinfo_settleaccno, \
		:cmsmerchantinfo_opnbankname, \
		:cmsmerchantinfo_opnbankexchcode, \
		:cmsmerchantinfo_mctflg, \
		:cmsmerchantinfo_description

struct cmsmerchantinfo
{
	char	mid[16];
	char	mctname[71];
	char	mctmcc[5];
	char	goingteleno[21];
	char	conperidtype[3];
	char	conperidcode[21];
	char	conpername[71];
	char	conperteleno[21];
	char	conpermobno[21];
	char	conperbpno[21];
	char	mctaddress[61];
	char	midaccno[33];
	char	brc[10];
	double	rakeoffratefix;
	double	rakeofffix;
	double	lowlimit;
	double	highlimit;
	char	rakeoffflg[2];
	char	opnflg[2];
	char	settleaccno[33];
	char	opnbankname[71];
	char	opnbankexchcode[7];
	char	mctflg[2];
	char	description[41];
};

void pubInitCmsmerchantinfo()
{
	memset( cmsmerchantinfo_mid, 0x00, sizeof( cmsmerchantinfo_mid ) ) ;
	cmsmerchantinfo_mid_id = 0 ;
	memset( cmsmerchantinfo_mctname, 0x00, sizeof( cmsmerchantinfo_mctname ) ) ;
	cmsmerchantinfo_mctname_id = 0 ;
	memset( cmsmerchantinfo_mctmcc, 0x00, sizeof( cmsmerchantinfo_mctmcc ) ) ;
	cmsmerchantinfo_mctmcc_id = 0 ;
	memset( cmsmerchantinfo_goingteleno, 0x00, sizeof( cmsmerchantinfo_goingteleno ) ) ;
	cmsmerchantinfo_goingteleno_id = 0 ;
	memset( cmsmerchantinfo_conperidtype, 0x00, sizeof( cmsmerchantinfo_conperidtype ) ) ;
	cmsmerchantinfo_conperidtype_id = 0 ;
	memset( cmsmerchantinfo_conperidcode, 0x00, sizeof( cmsmerchantinfo_conperidcode ) ) ;
	cmsmerchantinfo_conperidcode_id = 0 ;
	memset( cmsmerchantinfo_conpername, 0x00, sizeof( cmsmerchantinfo_conpername ) ) ;
	cmsmerchantinfo_conpername_id = 0 ;
	memset( cmsmerchantinfo_conperteleno, 0x00, sizeof( cmsmerchantinfo_conperteleno ) ) ;
	cmsmerchantinfo_conperteleno_id = 0 ;
	memset( cmsmerchantinfo_conpermobno, 0x00, sizeof( cmsmerchantinfo_conpermobno ) ) ;
	cmsmerchantinfo_conpermobno_id = 0 ;
	memset( cmsmerchantinfo_conperbpno, 0x00, sizeof( cmsmerchantinfo_conperbpno ) ) ;
	cmsmerchantinfo_conperbpno_id = 0 ;
	memset( cmsmerchantinfo_mctaddress, 0x00, sizeof( cmsmerchantinfo_mctaddress ) ) ;
	cmsmerchantinfo_mctaddress_id = 0 ;
	memset( cmsmerchantinfo_midaccno, 0x00, sizeof( cmsmerchantinfo_midaccno ) ) ;
	cmsmerchantinfo_midaccno_id = 0 ;
	memset( cmsmerchantinfo_brc, 0x00, sizeof( cmsmerchantinfo_brc ) ) ;
	cmsmerchantinfo_brc_id = 0 ;
	memset( &cmsmerchantinfo_rakeoffratefix, 0x00, sizeof( cmsmerchantinfo_rakeoffratefix ) ) ;
	cmsmerchantinfo_rakeoffratefix_id = 0 ;
	memset( &cmsmerchantinfo_rakeofffix, 0x00, sizeof( cmsmerchantinfo_rakeofffix ) ) ;
	cmsmerchantinfo_rakeofffix_id = 0 ;
	memset( &cmsmerchantinfo_lowlimit, 0x00, sizeof( cmsmerchantinfo_lowlimit ) ) ;