tbcms010.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 cmstlimt_cardno[20];
	short cmstlimt_cardno_id;
	char cmstlimt_trandevtype[3];
	short cmstlimt_trandevtype_id;
	char cmstlimt_ccy[4];
	short cmstlimt_ccy_id;
	long cmstlimt_period;
	short cmstlimt_period_id;
	double cmstlimt_cashlimitamt;
	short cmstlimt_cashlimitamt_id;
	double cmstlimt_depolimitamt;
	short cmstlimt_depolimitamt_id;
	double cmstlimt_conlimitamt;
	short cmstlimt_conlimitamt_id;
	double cmstlimt_tranoutlimitamt;
	short cmstlimt_tranoutlimitamt_id;
	long cmstlimt_cashlimittime;
	short cmstlimt_cashlimittime_id;
	long cmstlimt_depolimittime;
	short cmstlimt_depolimittime_id;
	long cmstlimt_conlimittime;
	short cmstlimt_conlimittime_id;
	long cmstlimt_tranoutlimittime;
	short cmstlimt_tranoutlimittime_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTLIMT \
		:cmstlimt_cardno:cmstlimt_cardno_id, \
		:cmstlimt_trandevtype:cmstlimt_trandevtype_id, \
		:cmstlimt_ccy:cmstlimt_ccy_id, \
		:cmstlimt_period:cmstlimt_period_id, \
		:cmstlimt_cashlimitamt:cmstlimt_cashlimitamt_id, \
		:cmstlimt_depolimitamt:cmstlimt_depolimitamt_id, \
		:cmstlimt_conlimitamt:cmstlimt_conlimitamt_id, \
		:cmstlimt_tranoutlimitamt:cmstlimt_tranoutlimitamt_id, \
		:cmstlimt_cashlimittime:cmstlimt_cashlimittime_id, \
		:cmstlimt_depolimittime:cmstlimt_depolimittime_id, \
		:cmstlimt_conlimittime:cmstlimt_conlimittime_id, \
		:cmstlimt_tranoutlimittime:cmstlimt_tranoutlimittime_id

#define UU_CMSTLIMT \
		cardno, \
		trandevtype, \
		ccy, \
		period, \
		cashlimitamt, \
		depolimitamt, \
		conlimitamt, \
		tranoutlimitamt, \
		cashlimittime, \
		depolimittime, \
		conlimittime, \
		tranoutlimittime

#define WW_CMSTLIMT \
		:cmstlimt_cardno, \
		:cmstlimt_trandevtype, \
		:cmstlimt_ccy, \
		:cmstlimt_period, \
		:cmstlimt_cashlimitamt, \
		:cmstlimt_depolimitamt, \
		:cmstlimt_conlimitamt, \
		:cmstlimt_tranoutlimitamt, \
		:cmstlimt_cashlimittime, \
		:cmstlimt_depolimittime, \
		:cmstlimt_conlimittime, \
		:cmstlimt_tranoutlimittime

struct cmstlimt
{
	char	cardno[20];
	char	trandevtype[3];
	char	ccy[4];
	long	period;
	double	cashlimitamt;
	double	depolimitamt;
	double	conlimitamt;
	double	tranoutlimitamt;
	long	cashlimittime;
	long	depolimittime;
	long	conlimittime;
	long	tranoutlimittime;
};

void pubInitCmstlimt()
{
	memset( cmstlimt_cardno, 0x00, sizeof( cmstlimt_cardno ) ) ;
	cmstlimt_cardno_id = 0 ;
	memset( cmstlimt_trandevtype, 0x00, sizeof( cmstlimt_trandevtype ) ) ;
	cmstlimt_trandevtype_id = 0 ;
	memset( cmstlimt_ccy, 0x00, sizeof( cmstlimt_ccy ) ) ;
	cmstlimt_ccy_id = 0 ;
	memset( &cmstlimt_period, 0x00, sizeof( cmstlimt_period ) ) ;
	cmstlimt_period_id = 0 ;
	memset( &cmstlimt_cashlimitamt, 0x00, sizeof( cmstlimt_cashlimitamt ) ) ;
	cmstlimt_cashlimitamt_id = 0 ;
	memset( &cmstlimt_depolimitamt, 0x00, sizeof( cmstlimt_depolimitamt ) ) ;
	cmstlimt_depolimitamt_id = 0 ;
	memset( &cmstlimt_conlimitamt, 0x00, sizeof( cmstlimt_conlimitamt ) ) ;
	cmstlimt_conlimitamt_id = 0 ;
	memset( &cmstlimt_tranoutlimitamt, 0x00, sizeof( cmstlimt_tranoutlimitamt ) ) ;
	cmstlimt_tranoutlimitamt_id = 0 ;
	memset( &cmstlimt_cashlimittime, 0x00, sizeof( cmstlimt_cashlimittime ) ) ;
	cmstlimt_cashlimittime_id = 0 ;
	memset( &cmstlimt_depolimittime, 0x00, sizeof( cmstlimt_depolimittime ) ) ;
	cmstlimt_depolimittime_id = 0 ;
	memset( &cmstlimt_conlimittime, 0x00, sizeof( cmstlimt_conlimittime ) ) ;
	cmstlimt_conlimittime_id = 0 ;
	memset( &cmstlimt_tranoutlimittime, 0x00, sizeof( cmstlimt_tranoutlimittime ) ) ;
	cmstlimt_tranoutlimittime_id = 0 ;
}

void pubStoVCmstlimt( struct cmstlimt * pstCmstlimt )
{
	pubInitCmstlimt();
	if( !strlen( pstCmstlimt->cardno ) )
		strcpy( pstCmstlimt->cardno, " " );
	strcpy( cmstlimt_cardno, pstCmstlimt->cardno );
	if( !strlen( pstCmstlimt->trandevtype ) )
		strcpy( pstCmstlimt->trandevtype, " " );
	strcpy( cmstlimt_trandevtype, pstCmstlimt->trandevtype );
	if( !strlen( pstCmstlimt->ccy ) )
		strcpy( pstCmstlimt->ccy, " " );
	strcpy( cmstlimt_ccy, pstCmstlimt->ccy );
	cmstlimt_period = pstCmstlimt->period ;
	cmstlimt_cashlimitamt = pstCmstlimt->cashlimitamt ;
	pubDround( &cmstlimt_cashlimitamt, 2 );
	cmstlimt_depolimitamt = pstCmstlimt->depolimitamt ;
	pubDround( &cmstlimt_depolimitamt, 2 );
	cmstlimt_conlimitamt = pstCmstlimt->conlimitamt ;
	pubDround( &cmstlimt_conlimitamt, 2 );
	cmstlimt_tranoutlimitamt = pstCmstlimt->tranoutlimitamt ;
	pubDround( &cmstlimt_tranoutlimitamt, 2 );
	cmstlimt_cashlimittime = pstCmstlimt->cashlimittime ;
	cmstlimt_depolimittime = pstCmstlimt->depolimittime ;
	cmstlimt_conlimittime = pstCmstlimt->conlimittime ;
	cmstlimt_tranoutlimittime = pstCmstlimt->tranoutlimittime ;
}

void pubVtoSCmstlimt( struct cmstlimt * pstCmstlimt )
{
	strcpy( pstCmstlimt->cardno, cmstlimt_cardno );
	strpack( pstCmstlimt->cardno );
	strcpy( pstCmstlimt->trandevtype, cmstlimt_trandevtype );
	strpack( pstCmstlimt->trandevtype );
	strcpy( pstCmstlimt->ccy, cmstlimt_ccy );
	strpack( pstCmstlimt->ccy );
	pstCmstlimt->period = cmstlimt_period ;
	pstCmstlimt->cashlimitamt = cmstlimt_cashlimitamt ;
	pubDround( &pstCmstlimt->cashlimitamt, 2 );
	pstCmstlimt->depolimitamt = cmstlimt_depolimitamt ;
	pubDround( &pstCmstlimt->depolimitamt, 2 );
	pstCmstlimt->conlimitamt = cmstlimt_conlimitamt ;
	pubDround( &pstCmstlimt->conlimitamt, 2 );
	pstCmstlimt->tranoutlimitamt = cmstlimt_tranoutlimitamt ;
	pubDround( &pstCmstlimt->tranoutlimitamt, 2 );
	pstCmstlimt->cashlimittime = cmstlimt_cashlimittime ;
	pstCmstlimt->depolimittime = cmstlimt_depolimittime ;
	pstCmstlimt->conlimittime = cmstlimt_conlimittime ;
	pstCmstlimt->tranoutlimittime = cmstlimt_tranoutlimittime ;
}

int pubReadCmstlimt( struct cmstlimt * pstCmstlimt )
{
	pubInitCmstlimt();
	pubStoVCmstlimt(pstCmstlimt);
	EXEC SQL SELECT * INTO RR_CMSTLIMT 
		FROM cmstlimt  
		WHERE  
		 cardno = :cmstlimt_cardno and 
		 ccy = :cmstlimt_ccy and 
		 period = :cmstlimt_period and 
		 trandevtype = :cmstlimt_trandevtype  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmstlimt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmstlimt(pstCmstlimt);
	return 0; 
} 
 
int pubModiCmstlimt( struct cmstlimt * pstCmstlimt )
{
	pubInitCmstlimt();
	pubStoVCmstlimt(pstCmstlimt);
	EXEC SQL UPDATE cmstlimt 
		SET ( UU_CMSTLIMT ) = ( WW_CMSTLIMT ) 
		WHERE  
		 cardno = :cmstlimt_cardno and 
		 ccy = :cmstlimt_ccy and 
		 period = :cmstlimt_period and 
		 trandevtype = :cmstlimt_trandevtype  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmstlimt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmstlimt( struct cmstlimt * pstCmstlimt )
{
	pubInitCmstlimt();
	pubStoVCmstlimt(pstCmstlimt);
	EXEC SQL INSERT INTO cmstlimt VALUES ( RR_CMSTLIMT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmstlimt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}