tbcms004.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 cmsktlimt_cardkind[9];
	short cmsktlimt_cardkind_id;
	long cmsktlimt_serverlevel;
	short cmsktlimt_serverlevel_id;
	char cmsktlimt_trandevtype[3];
	short cmsktlimt_trandevtype_id;
	char cmsktlimt_ccy[4];
	short cmsktlimt_ccy_id;
	long cmsktlimt_period;
	short cmsktlimt_period_id;
	char cmsktlimt_sametrandevtype[3];
	short cmsktlimt_sametrandevtype_id;
	double cmsktlimt_cashlimitamt;
	short cmsktlimt_cashlimitamt_id;
	double cmsktlimt_depolimitamt;
	short cmsktlimt_depolimitamt_id;
	double cmsktlimt_conlimitamt;
	short cmsktlimt_conlimitamt_id;
	double cmsktlimt_tranoutlimitamt;
	short cmsktlimt_tranoutlimitamt_id;
	long cmsktlimt_cashlimittime;
	short cmsktlimt_cashlimittime_id;
	long cmsktlimt_depolimittime;
	short cmsktlimt_depolimittime_id;
	long cmsktlimt_conlimittime;
	short cmsktlimt_conlimittime_id;
	long cmsktlimt_tranoutlimittime;
	short cmsktlimt_tranoutlimittime_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSKTLIMT \
		:cmsktlimt_cardkind:cmsktlimt_cardkind_id, \
		:cmsktlimt_serverlevel:cmsktlimt_serverlevel_id, \
		:cmsktlimt_trandevtype:cmsktlimt_trandevtype_id, \
		:cmsktlimt_ccy:cmsktlimt_ccy_id, \
		:cmsktlimt_period:cmsktlimt_period_id, \
		:cmsktlimt_sametrandevtype:cmsktlimt_sametrandevtype_id, \
		:cmsktlimt_cashlimitamt:cmsktlimt_cashlimitamt_id, \
		:cmsktlimt_depolimitamt:cmsktlimt_depolimitamt_id, \
		:cmsktlimt_conlimitamt:cmsktlimt_conlimitamt_id, \
		:cmsktlimt_tranoutlimitamt:cmsktlimt_tranoutlimitamt_id, \
		:cmsktlimt_cashlimittime:cmsktlimt_cashlimittime_id, \
		:cmsktlimt_depolimittime:cmsktlimt_depolimittime_id, \
		:cmsktlimt_conlimittime:cmsktlimt_conlimittime_id, \
		:cmsktlimt_tranoutlimittime:cmsktlimt_tranoutlimittime_id

#define UU_CMSKTLIMT \
		cardkind, \
		serverlevel, \
		trandevtype, \
		ccy, \
		period, \
		sametrandevtype, \
		cashlimitamt, \
		depolimitamt, \
		conlimitamt, \
		tranoutlimitamt, \
		cashlimittime, \
		depolimittime, \
		conlimittime, \
		tranoutlimittime

#define WW_CMSKTLIMT \
		:cmsktlimt_cardkind, \
		:cmsktlimt_serverlevel, \
		:cmsktlimt_trandevtype, \
		:cmsktlimt_ccy, \
		:cmsktlimt_period, \
		:cmsktlimt_sametrandevtype, \
		:cmsktlimt_cashlimitamt, \
		:cmsktlimt_depolimitamt, \
		:cmsktlimt_conlimitamt, \
		:cmsktlimt_tranoutlimitamt, \
		:cmsktlimt_cashlimittime, \
		:cmsktlimt_depolimittime, \
		:cmsktlimt_conlimittime, \
		:cmsktlimt_tranoutlimittime

struct cmsktlimt
{
	char	cardkind[9];
	long	serverlevel;
	char	trandevtype[3];
	char	ccy[4];
	long	period;
	char	sametrandevtype[3];
	double	cashlimitamt;
	double	depolimitamt;
	double	conlimitamt;
	double	tranoutlimitamt;
	long	cashlimittime;
	long	depolimittime;
	long	conlimittime;
	long	tranoutlimittime;
};

void pubInitCmsktlimt()
{
	memset( cmsktlimt_cardkind, 0x00, sizeof( cmsktlimt_cardkind ) ) ;
	cmsktlimt_cardkind_id = 0 ;
	memset( &cmsktlimt_serverlevel, 0x00, sizeof( cmsktlimt_serverlevel ) ) ;
	cmsktlimt_serverlevel_id = 0 ;
	memset( cmsktlimt_trandevtype, 0x00, sizeof( cmsktlimt_trandevtype ) ) ;
	cmsktlimt_trandevtype_id = 0 ;
	memset( cmsktlimt_ccy, 0x00, sizeof( cmsktlimt_ccy ) ) ;
	cmsktlimt_ccy_id = 0 ;
	memset( &cmsktlimt_period, 0x00, sizeof( cmsktlimt_period ) ) ;
	cmsktlimt_period_id = 0 ;
	memset( cmsktlimt_sametrandevtype, 0x00, sizeof( cmsktlimt_sametrandevtype ) ) ;
	cmsktlimt_sametrandevtype_id = 0 ;
	memset( &cmsktlimt_cashlimitamt, 0x00, sizeof( cmsktlimt_cashlimitamt ) ) ;
	cmsktlimt_cashlimitamt_id = 0 ;
	memset( &cmsktlimt_depolimitamt, 0x00, sizeof( cmsktlimt_depolimitamt ) ) ;
	cmsktlimt_depolimitamt_id = 0 ;
	memset( &cmsktlimt_conlimitamt, 0x00, sizeof( cmsktlimt_conlimitamt ) ) ;
	cmsktlimt_conlimitamt_id = 0 ;
	memset( &cmsktlimt_tranoutlimitamt, 0x00, sizeof( cmsktlimt_tranoutlimitamt ) ) ;
	cmsktlimt_tranoutlimitamt_id = 0 ;
	memset( &cmsktlimt_cashlimittime, 0x00, sizeof( cmsktlimt_cashlimittime ) ) ;
	cmsktlimt_cashlimittime_id = 0 ;
	memset( &cmsktlimt_depolimittime, 0x00, sizeof( cmsktlimt_depolimittime ) ) ;
	cmsktlimt_depolimittime_id = 0 ;
	memset( &cmsktlimt_conlimittime, 0x00, sizeof( cmsktlimt_conlimittime ) ) ;
	cmsktlimt_conlimittime_id = 0 ;
	memset( &cmsktlimt_tranoutlimittime, 0x00, sizeof( cmsktlimt_tranoutlimittime ) ) ;
	cmsktlimt_tranoutlimittime_id = 0 ;
}

void pubStoVCmsktlimt( struct cmsktlimt * pstCmsktlimt )
{
	pubInitCmsktlimt();
	if( !strlen( pstCmsktlimt->cardkind ) )
		strcpy( pstCmsktlimt->cardkind, " " );
	strcpy( cmsktlimt_cardkind, pstCmsktlimt->cardkind );
	cmsktlimt_serverlevel = pstCmsktlimt->serverlevel ;
	if( !strlen( pstCmsktlimt->trandevtype ) )
		strcpy( pstCmsktlimt->trandevtype, " " );
	strcpy( cmsktlimt_trandevtype, pstCmsktlimt->trandevtype );
	if( !strlen( pstCmsktlimt->ccy ) )
		strcpy( pstCmsktlimt->ccy, " " );
	strcpy( cmsktlimt_ccy, pstCmsktlimt->ccy );
	cmsktlimt_period = pstCmsktlimt->period ;
	if( !strlen( pstCmsktlimt->sametrandevtype ) )
		strcpy( pstCmsktlimt->sametrandevtype, " " );
	strcpy( cmsktlimt_sametrandevtype, pstCmsktlimt->sametrandevtype );
	cmsktlimt_cashlimitamt = pstCmsktlimt->cashlimitamt ;
	pubDround( &cmsktlimt_cashlimitamt, 2 );
	cmsktlimt_depolimitamt = pstCmsktlimt->depolimitamt ;
	pubDround( &cmsktlimt_depolimitamt, 2 );
	cmsktlimt_conlimitamt = pstCmsktlimt->conlimitamt ;
	pubDround( &cmsktlimt_conlimitamt, 2 );
	cmsktlimt_tranoutlimitamt = pstCmsktlimt->tranoutlimitamt ;
	pubDround( &cmsktlimt_tranoutlimitamt, 2 );
	cmsktlimt_cashlimittime = pstCmsktlimt->cashlimittime ;
	cmsktlimt_depolimittime = pstCmsktlimt->depolimittime ;
	cmsktlimt_conlimittime = pstCmsktlimt->conlimittime ;
	cmsktlimt_tranoutlimittime = pstCmsktlimt->tranoutlimittime ;
}

void pubVtoSCmsktlimt( struct cmsktlimt * pstCmsktlimt )
{
	strcpy( pstCmsktlimt->cardkind, cmsktlimt_cardkind );
	strpack( pstCmsktlimt->cardkind );
	pstCmsktlimt->serverlevel = cmsktlimt_serverlevel ;
	strcpy( pstCmsktlimt->trandevtype, cmsktlimt_trandevtype );
	strpack( pstCmsktlimt->trandevtype );
	strcpy( pstCmsktlimt->ccy, cmsktlimt_ccy );
	strpack( pstCmsktlimt->ccy );
	pstCmsktlimt->period = cmsktlimt_period ;
	strcpy( pstCmsktlimt->sametrandevtype, cmsktlimt_sametrandevtype );
	strpack( pstCmsktlimt->sametrandevtype );
	pstCmsktlimt->cashlimitamt = cmsktlimt_cashlimitamt ;
	pubDround( &pstCmsktlimt->cashlimitamt, 2 );
	pstCmsktlimt->depolimitamt = cmsktlimt_depolimitamt ;
	pubDround( &pstCmsktlimt->depolimitamt, 2 );
	pstCmsktlimt->conlimitamt = cmsktlimt_conlimitamt ;
	pubDround( &pstCmsktlimt->conlimitamt, 2 );
	pstCmsktlimt->tranoutlimitamt = cmsktlimt_tranoutlimitamt ;
	pubDround( &pstCmsktlimt->tranoutlimitamt, 2 );
	pstCmsktlimt->cashlimittime = cmsktlimt_cashlimittime ;
	pstCmsktlimt->depolimittime = cmsktlimt_depolimittime ;
	pstCmsktlimt->conlimittime = cmsktlimt_conlimittime ;
	pstCmsktlimt->tranoutlimittime = cmsktlimt_tranoutlimittime ;
}

int pubReadCmsktlimt( struct cmsktlimt * pstCmsktlimt )
{
	pubInitCmsktlimt();
	pubStoVCmsktlimt(pstCmsktlimt);
	EXEC SQL SELECT * INTO RR_CMSKTLIMT 
		FROM cmsktlimt  
		WHERE  
		 cardkind = :cmsktlimt_cardkind and 
		 serverlevel = :cmsktlimt_serverlevel and 
		 trandevtype = :cmsktlimt_trandevtype and 
		 ccy = :cmsktlimt_ccy and 
		 period = :cmsktlimt_period  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsktlimt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsktlimt(pstCmsktlimt);
	return 0; 
} 
 
int pubModiCmsktlimt( struct cmsktlimt * pstCmsktlimt )
{
	pubInitCmsktlimt();
	pubStoVCmsktlimt(pstCmsktlimt);
	EXEC SQL UPDATE cmsktlimt 
		SET ( UU_CMSKTLIMT ) = ( WW_CMSKTLIMT ) 
		WHERE  
		 cardkind = :cmsktlimt_cardkind and 
		 serverlevel = :cmsktlimt_serverlevel and 
		 trandevtype = :cmsktlimt_trandevtype and 
		 ccy = :cmsktlimt_ccy and 
		 period = :cmsktlimt_period  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsktlimt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsktlimt( struct cmsktlimt * pstCmsktlimt )
{
	pubInitCmsktlimt();
	pubStoVCmsktlimt(pstCmsktlimt);
	EXEC SQL INSERT INTO cmsktlimt VALUES ( RR_CMSKTLIMT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsktlimt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}