tbcms046.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 cmslimitreg_trandate[11];
	short cmslimitreg_trandate_id;
	long cmslimitreg_serseqno;
	short cmslimitreg_serseqno_id;
	char cmslimitreg_cdflg[2];
	short cmslimitreg_cdflg_id;
	char cmslimitreg_cardno[20];
	short cmslimitreg_cardno_id;
	char cmslimitreg_trandevtype[3];
	short cmslimitreg_trandevtype_id;
	char cmslimitreg_cdtrantype[4];
	short cmslimitreg_cdtrantype_id;
	char cmslimitreg_tranmode[2];
	short cmslimitreg_tranmode_id;
	char cmslimitreg_ccy[4];
	short cmslimitreg_ccy_id;
	char cmslimitreg_mctmcc[5];
	short cmslimitreg_mctmcc_id;
	char cmslimitreg_mid[16];
	short cmslimitreg_mid_id;
	double cmslimitreg_amount;
	short cmslimitreg_amount_id;
	char cmslimitreg_cardkind[9];
	short cmslimitreg_cardkind_id;
	char cmslimitreg_flag[2];
	short cmslimitreg_flag_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSLIMITREG \
		:cmslimitreg_trandate:cmslimitreg_trandate_id, \
		:cmslimitreg_serseqno:cmslimitreg_serseqno_id, \
		:cmslimitreg_cdflg:cmslimitreg_cdflg_id, \
		:cmslimitreg_cardno:cmslimitreg_cardno_id, \
		:cmslimitreg_trandevtype:cmslimitreg_trandevtype_id, \
		:cmslimitreg_cdtrantype:cmslimitreg_cdtrantype_id, \
		:cmslimitreg_tranmode:cmslimitreg_tranmode_id, \
		:cmslimitreg_ccy:cmslimitreg_ccy_id, \
		:cmslimitreg_mctmcc:cmslimitreg_mctmcc_id, \
		:cmslimitreg_mid:cmslimitreg_mid_id, \
		:cmslimitreg_amount:cmslimitreg_amount_id, \
		:cmslimitreg_cardkind:cmslimitreg_cardkind_id, \
		:cmslimitreg_flag:cmslimitreg_flag_id

#define UU_CMSLIMITREG \
		trandate, \
		serseqno, \
		cdflg, \
		cardno, \
		trandevtype, \
		cdtrantype, \
		tranmode, \
		ccy, \
		mctmcc, \
		mid, \
		amount, \
		cardkind, \
		flag

#define WW_CMSLIMITREG \
		:cmslimitreg_trandate, \
		:cmslimitreg_serseqno, \
		:cmslimitreg_cdflg, \
		:cmslimitreg_cardno, \
		:cmslimitreg_trandevtype, \
		:cmslimitreg_cdtrantype, \
		:cmslimitreg_tranmode, \
		:cmslimitreg_ccy, \
		:cmslimitreg_mctmcc, \
		:cmslimitreg_mid, \
		:cmslimitreg_amount, \
		:cmslimitreg_cardkind, \
		:cmslimitreg_flag

struct cmslimitreg
{
	char	trandate[11];
	long	serseqno;
	char	cdflg[2];
	char	cardno[20];
	char	trandevtype[3];
	char	cdtrantype[4];
	char	tranmode[2];
	char	ccy[4];
	char	mctmcc[5];
	char	mid[16];
	double	amount;
	char	cardkind[9];
	char	flag[2];
};

void pubInitCmslimitreg()
{
	memset( cmslimitreg_trandate, 0x00, sizeof( cmslimitreg_trandate ) ) ;
	cmslimitreg_trandate_id = 0 ;
	memset( &cmslimitreg_serseqno, 0x00, sizeof( cmslimitreg_serseqno ) ) ;
	cmslimitreg_serseqno_id = 0 ;
	memset( cmslimitreg_cdflg, 0x00, sizeof( cmslimitreg_cdflg ) ) ;
	cmslimitreg_cdflg_id = 0 ;
	memset( cmslimitreg_cardno, 0x00, sizeof( cmslimitreg_cardno ) ) ;
	cmslimitreg_cardno_id = 0 ;
	memset( cmslimitreg_trandevtype, 0x00, sizeof( cmslimitreg_trandevtype ) ) ;
	cmslimitreg_trandevtype_id = 0 ;
	memset( cmslimitreg_cdtrantype, 0x00, sizeof( cmslimitreg_cdtrantype ) ) ;
	cmslimitreg_cdtrantype_id = 0 ;
	memset( cmslimitreg_tranmode, 0x00, sizeof( cmslimitreg_tranmode ) ) ;
	cmslimitreg_tranmode_id = 0 ;
	memset( cmslimitreg_ccy, 0x00, sizeof( cmslimitreg_ccy ) ) ;
	cmslimitreg_ccy_id = 0 ;
	memset( cmslimitreg_mctmcc, 0x00, sizeof( cmslimitreg_mctmcc ) ) ;
	cmslimitreg_mctmcc_id = 0 ;
	memset( cmslimitreg_mid, 0x00, sizeof( cmslimitreg_mid ) ) ;
	cmslimitreg_mid_id = 0 ;
	memset( &cmslimitreg_amount, 0x00, sizeof( cmslimitreg_amount ) ) ;
	cmslimitreg_amount_id = 0 ;
	memset( cmslimitreg_cardkind, 0x00, sizeof( cmslimitreg_cardkind ) ) ;
	cmslimitreg_cardkind_id = 0 ;
	memset( cmslimitreg_flag, 0x00, sizeof( cmslimitreg_flag ) ) ;
	cmslimitreg_flag_id = 0 ;
}

void pubStoVCmslimitreg( struct cmslimitreg * pstCmslimitreg )
{
	pubInitCmslimitreg();
	if( !strlen( pstCmslimitreg->trandate ) )
		strcpy( pstCmslimitreg->trandate, " " );
	strcpy( cmslimitreg_trandate, pstCmslimitreg->trandate );
	cmslimitreg_serseqno = pstCmslimitreg->serseqno ;
	if( !strlen( pstCmslimitreg->cdflg ) )
		strcpy( pstCmslimitreg->cdflg, " " );
	strcpy( cmslimitreg_cdflg, pstCmslimitreg->cdflg );
	if( !strlen( pstCmslimitreg->cardno ) )
		strcpy( pstCmslimitreg->cardno, " " );
	strcpy( cmslimitreg_cardno, pstCmslimitreg->cardno );
	if( !strlen( pstCmslimitreg->trandevtype ) )
		strcpy( pstCmslimitreg->trandevtype, " " );
	strcpy( cmslimitreg_trandevtype, pstCmslimitreg->trandevtype );
	if( !strlen( pstCmslimitreg->cdtrantype ) )
		strcpy( pstCmslimitreg->cdtrantype, " " );
	strcpy( cmslimitreg_cdtrantype, pstCmslimitreg->cdtrantype );
	if( !strlen( pstCmslimitreg->tranmode ) )
		strcpy( pstCmslimitreg->tranmode, " " );
	strcpy( cmslimitreg_tranmode, pstCmslimitreg->tranmode );
	if( !strlen( pstCmslimitreg->ccy ) )
		strcpy( pstCmslimitreg->ccy, " " );
	strcpy( cmslimitreg_ccy, pstCmslimitreg->ccy );
	if( !strlen( pstCmslimitreg->mctmcc ) )
		strcpy( pstCmslimitreg->mctmcc, " " );
	strcpy( cmslimitreg_mctmcc, pstCmslimitreg->mctmcc );
	if( !strlen( pstCmslimitreg->mid ) )
		strcpy( pstCmslimitreg->mid, " " );
	strcpy( cmslimitreg_mid, pstCmslimitreg->mid );
	cmslimitreg_amount = pstCmslimitreg->amount ;
	pubDround( &cmslimitreg_amount, 2 );
	if( !strlen( pstCmslimitreg->cardkind ) )
		strcpy( pstCmslimitreg->cardkind, " " );
	strcpy( cmslimitreg_cardkind, pstCmslimitreg->cardkind );
	if( !strlen( pstCmslimitreg->flag ) )
		strcpy( pstCmslimitreg->flag, " " );
	strcpy( cmslimitreg_flag, pstCmslimitreg->flag );
}

void pubVtoSCmslimitreg( struct cmslimitreg * pstCmslimitreg )
{
	strcpy( pstCmslimitreg->trandate, cmslimitreg_trandate );
	strpack( pstCmslimitreg->trandate );
	pstCmslimitreg->serseqno = cmslimitreg_serseqno ;
	strcpy( pstCmslimitreg->cdflg, cmslimitreg_cdflg );
	strpack( pstCmslimitreg->cdflg );
	strcpy( pstCmslimitreg->cardno, cmslimitreg_cardno );
	strpack( pstCmslimitreg->cardno );
	strcpy( pstCmslimitreg->trandevtype, cmslimitreg_trandevtype );
	strpack( pstCmslimitreg->trandevtype );
	strcpy( pstCmslimitreg->cdtrantype, cmslimitreg_cdtrantype );
	strpack( pstCmslimitreg->cdtrantype );
	strcpy( pstCmslimitreg->tranmode, cmslimitreg_tranmode );
	strpack( pstCmslimitreg->tranmode );
	strcpy( pstCmslimitreg->ccy, cmslimitreg_ccy );
	strpack( pstCmslimitreg->ccy );
	strcpy( pstCmslimitreg->mctmcc, cmslimitreg_mctmcc );
	strpack( pstCmslimitreg->mctmcc );
	strcpy( pstCmslimitreg->mid, cmslimitreg_mid );
	strpack( pstCmslimitreg->mid );
	pstCmslimitreg->amount = cmslimitreg_amount ;
	pubDround( &pstCmslimitreg->amount, 2 );
	strcpy( pstCmslimitreg->cardkind, cmslimitreg_cardkind );
	strpack( pstCmslimitreg->cardkind );
	strcpy( pstCmslimitreg->flag, cmslimitreg_flag );
	strpack( pstCmslimitreg->flag );
}

int pubInstCmslimitreg( struct cmslimitreg * pstCmslimitreg )
{
	pubInitCmslimitreg();
	pubStoVCmslimitreg(pstCmslimitreg);
	EXEC SQL INSERT INTO cmslimitreg VALUES ( RR_CMSLIMITREG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmslimitreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
} 
void pubTracCmslimitreg( struct cmslimitreg * pstCmslimitreg )
{
	sprintf( g_acTrcMsg, "cmslimitreg:trandate=[%s]", pstCmslimitreg->trandate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:serseqno=[%d]", pstCmslimitreg->serseqno) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:cdflg=[%s]", pstCmslimitreg->cdflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:cardno=[%s]", pstCmslimitreg->cardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:trandevtype=[%s]", pstCmslimitreg->trandevtype );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:cdtrantype=[%s]", pstCmslimitreg->cdtrantype );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:tranmode=[%s]", pstCmslimitreg->tranmode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:ccy=[%s]", pstCmslimitreg->ccy );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:mctmcc=[%s]", pstCmslimitreg->mctmcc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:mid=[%s]", pstCmslimitreg->mid );
	TRCLOG1
	pubDround( &(pstCmslimitreg->amount), 2 );
	sprintf( g_acTrcMsg, "cmslimitreg:amount=[%.2lf]", pstCmslimitreg->amount) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:cardkind=[%s]", pstCmslimitreg->cardkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmslimitreg:flag=[%s]", pstCmslimitreg->flag );
	TRCLOG1
}