tbcms011.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 cmsttotal_cardno[20];
	short cmsttotal_cardno_id;
	char cmsttotal_trandevtype[3];
	short cmsttotal_trandevtype_id;
	char cmsttotal_ccy[4];
	short cmsttotal_ccy_id;
	long cmsttotal_period;
	short cmsttotal_period_id;
	double cmsttotal_withdrawamt;
	short cmsttotal_withdrawamt_id;
	double cmsttotal_depositamt;
	short cmsttotal_depositamt_id;
	double cmsttotal_conamt;
	short cmsttotal_conamt_id;
	double cmsttotal_tranoutamt;
	short cmsttotal_tranoutamt_id;
	double cmsttotal_traninamt;
	short cmsttotal_traninamt_id;
	long cmsttotal_withdrawtimes;
	short cmsttotal_withdrawtimes_id;
	long cmsttotal_deposittimes;
	short cmsttotal_deposittimes_id;
	long cmsttotal_contimes;
	short cmsttotal_contimes_id;
	long cmsttotal_tranouttimes;
	short cmsttotal_tranouttimes_id;
	long cmsttotal_tranintimes;
	short cmsttotal_tranintimes_id;
	char cmsttotal_startdate[11];
	short cmsttotal_startdate_id;
	char cmsttotal_enddate[11];
	short cmsttotal_enddate_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTTOTAL \
		:cmsttotal_cardno:cmsttotal_cardno_id, \
		:cmsttotal_trandevtype:cmsttotal_trandevtype_id, \
		:cmsttotal_ccy:cmsttotal_ccy_id, \
		:cmsttotal_period:cmsttotal_period_id, \
		:cmsttotal_withdrawamt:cmsttotal_withdrawamt_id, \
		:cmsttotal_depositamt:cmsttotal_depositamt_id, \
		:cmsttotal_conamt:cmsttotal_conamt_id, \
		:cmsttotal_tranoutamt:cmsttotal_tranoutamt_id, \
		:cmsttotal_traninamt:cmsttotal_traninamt_id, \
		:cmsttotal_withdrawtimes:cmsttotal_withdrawtimes_id, \
		:cmsttotal_deposittimes:cmsttotal_deposittimes_id, \
		:cmsttotal_contimes:cmsttotal_contimes_id, \
		:cmsttotal_tranouttimes:cmsttotal_tranouttimes_id, \
		:cmsttotal_tranintimes:cmsttotal_tranintimes_id, \
		:cmsttotal_startdate:cmsttotal_startdate_id, \
		:cmsttotal_enddate:cmsttotal_enddate_id

#define UU_CMSTTOTAL \
		cardno, \
		trandevtype, \
		ccy, \
		period, \
		withdrawamt, \
		depositamt, \
		conamt, \
		tranoutamt, \
		traninamt, \
		withdrawtimes, \
		deposittimes, \
		contimes, \
		tranouttimes, \
		tranintimes, \
		startdate, \
		enddate

#define WW_CMSTTOTAL \
		:cmsttotal_cardno, \
		:cmsttotal_trandevtype, \
		:cmsttotal_ccy, \
		:cmsttotal_period, \
		:cmsttotal_withdrawamt, \
		:cmsttotal_depositamt, \
		:cmsttotal_conamt, \
		:cmsttotal_tranoutamt, \
		:cmsttotal_traninamt, \
		:cmsttotal_withdrawtimes, \
		:cmsttotal_deposittimes, \
		:cmsttotal_contimes, \
		:cmsttotal_tranouttimes, \
		:cmsttotal_tranintimes, \
		:cmsttotal_startdate, \
		:cmsttotal_enddate

struct cmsttotal
{
	char	cardno[20];
	char	trandevtype[3];
	char	ccy[4];
	long	period;
	double	withdrawamt;
	double	depositamt;
	double	conamt;
	double	tranoutamt;
	double	traninamt;
	long	withdrawtimes;
	long	deposittimes;
	long	contimes;
	long	tranouttimes;
	long	tranintimes;
	char	startdate[11];
	char	enddate[11];
};

void pubInitCmsttotal()
{
	memset( cmsttotal_cardno, 0x00, sizeof( cmsttotal_cardno ) ) ;
	cmsttotal_cardno_id = 0 ;
	memset( cmsttotal_trandevtype, 0x00, sizeof( cmsttotal_trandevtype ) ) ;
	cmsttotal_trandevtype_id = 0 ;
	memset( cmsttotal_ccy, 0x00, sizeof( cmsttotal_ccy ) ) ;
	cmsttotal_ccy_id = 0 ;
	memset( &cmsttotal_period, 0x00, sizeof( cmsttotal_period ) ) ;
	cmsttotal_period_id = 0 ;
	memset( &cmsttotal_withdrawamt, 0x00, sizeof( cmsttotal_withdrawamt ) ) ;
	cmsttotal_withdrawamt_id = 0 ;
	memset( &cmsttotal_depositamt, 0x00, sizeof( cmsttotal_depositamt ) ) ;
	cmsttotal_depositamt_id = 0 ;
	memset( &cmsttotal_conamt, 0x00, sizeof( cmsttotal_conamt ) ) ;
	cmsttotal_conamt_id = 0 ;
	memset( &cmsttotal_tranoutamt, 0x00, sizeof( cmsttotal_tranoutamt ) ) ;
	cmsttotal_tranoutamt_id = 0 ;
	memset( &cmsttotal_traninamt, 0x00, sizeof( cmsttotal_traninamt ) ) ;
	cmsttotal_traninamt_id = 0 ;
	memset( &cmsttotal_withdrawtimes, 0x00, sizeof( cmsttotal_withdrawtimes ) ) ;
	cmsttotal_withdrawtimes_id = 0 ;
	memset( &cmsttotal_deposittimes, 0x00, sizeof( cmsttotal_deposittimes ) ) ;
	cmsttotal_deposittimes_id = 0 ;
	memset( &cmsttotal_contimes, 0x00, sizeof( cmsttotal_contimes ) ) ;
	cmsttotal_contimes_id = 0 ;
	memset( &cmsttotal_tranouttimes, 0x00, sizeof( cmsttotal_tranouttimes ) ) ;
	cmsttotal_tranouttimes_id = 0 ;
	memset( &cmsttotal_tranintimes, 0x00, sizeof( cmsttotal_tranintimes ) ) ;
	cmsttotal_tranintimes_id = 0 ;
	memset( cmsttotal_startdate, 0x00, sizeof( cmsttotal_startdate ) ) ;
	cmsttotal_startdate_id = 0 ;
	memset( cmsttotal_enddate, 0x00, sizeof( cmsttotal_enddate ) ) ;
	cmsttotal_enddate_id = 0 ;
}

void pubStoVCmsttotal( struct cmsttotal * pstCmsttotal )
{
	pubInitCmsttotal();
	if( !strlen( pstCmsttotal->cardno ) )
		strcpy( pstCmsttotal->cardno, " " );
	strcpy( cmsttotal_cardno, pstCmsttotal->cardno );
	if( !strlen( pstCmsttotal->trandevtype ) )
		strcpy( pstCmsttotal->trandevtype, " " );
	strcpy( cmsttotal_trandevtype, pstCmsttotal->trandevtype );
	if( !strlen( pstCmsttotal->ccy ) )
		strcpy( pstCmsttotal->ccy, " " );
	strcpy( cmsttotal_ccy, pstCmsttotal->ccy );
	cmsttotal_period = pstCmsttotal->period ;
	cmsttotal_withdrawamt = pstCmsttotal->withdrawamt ;
	pubDround( &cmsttotal_withdrawamt, 2 );
	cmsttotal_depositamt = pstCmsttotal->depositamt ;
	pubDround( &cmsttotal_depositamt, 2 );
	cmsttotal_conamt = pstCmsttotal->conamt ;
	pubDround( &cmsttotal_conamt, 2 );
	cmsttotal_tranoutamt = pstCmsttotal->tranoutamt ;
	pubDround( &cmsttotal_tranoutamt, 2 );
	cmsttotal_traninamt = pstCmsttotal->traninamt ;
	pubDround( &cmsttotal_traninamt, 2 );
	cmsttotal_withdrawtimes = pstCmsttotal->withdrawtimes ;
	cmsttotal_deposittimes = pstCmsttotal->deposittimes ;
	cmsttotal_contimes = pstCmsttotal->contimes ;
	cmsttotal_tranouttimes = pstCmsttotal->tranouttimes ;
	cmsttotal_tranintimes = pstCmsttotal->tranintimes ;
	if( !strlen( pstCmsttotal->startdate ) )
		strcpy( pstCmsttotal->startdate, " " );
	strcpy( cmsttotal_startdate, pstCmsttotal->startdate );
	if( !strlen( pstCmsttotal->enddate ) )
		strcpy( pstCmsttotal->enddate, " " );
	strcpy( cmsttotal_enddate, pstCmsttotal->enddate );
}

void pubVtoSCmsttotal( struct cmsttotal * pstCmsttotal )
{
	strcpy( pstCmsttotal->cardno, cmsttotal_cardno );
	strpack( pstCmsttotal->cardno );
	strcpy( pstCmsttotal->trandevtype, cmsttotal_trandevtype );
	strpack( pstCmsttotal->trandevtype );
	strcpy( pstCmsttotal->ccy, cmsttotal_ccy );
	strpack( pstCmsttotal->ccy );
	pstCmsttotal->period = cmsttotal_period ;
	pstCmsttotal->withdrawamt = cmsttotal_withdrawamt ;
	pubDround( &pstCmsttotal->withdrawamt, 2 );
	pstCmsttotal->depositamt = cmsttotal_depositamt ;
	pubDround( &pstCmsttotal->depositamt, 2 );
	pstCmsttotal->conamt = cmsttotal_conamt ;
	pubDround( &pstCmsttotal->conamt, 2 );
	pstCmsttotal->tranoutamt = cmsttotal_tranoutamt ;
	pubDround( &pstCmsttotal->tranoutamt, 2 );
	pstCmsttotal->traninamt = cmsttotal_traninamt ;
	pubDround( &pstCmsttotal->traninamt, 2 );
	pstCmsttotal->withdrawtimes = cmsttotal_withdrawtimes ;
	pstCmsttotal->deposittimes = cmsttotal_deposittimes ;
	pstCmsttotal->contimes = cmsttotal_contimes ;
	pstCmsttotal->tranouttimes = cmsttotal_tranouttimes ;
	pstCmsttotal->tranintimes = cmsttotal_tranintimes ;
	strcpy( pstCmsttotal->startdate, cmsttotal_startdate );
	strpack( pstCmsttotal->startdate );
	strcpy( pstCmsttotal->enddate, cmsttotal_enddate );
	strpack( pstCmsttotal->enddate );
}

int pubReadCmsttotal( struct cmsttotal * pstCmsttotal )
{
	pubInitCmsttotal();
	pubStoVCmsttotal(pstCmsttotal);
	EXEC SQL SELECT * INTO RR_CMSTTOTAL 
		FROM cmsttotal  
		WHERE  
		 cardno = :cmsttotal_cardno and 
		 trandevtype = :cmsttotal_trandevtype and 
		 ccy = :cmsttotal_ccy and 
		 period = :cmsttotal_period and 
		 startdate = :cmsttotal_startdate  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsttotal",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsttotal(pstCmsttotal);
	return 0; 
} 
 
int pubModiCmsttotal( struct cmsttotal * pstCmsttotal )
{
	pubInitCmsttotal();
	pubStoVCmsttotal(pstCmsttotal);
	EXEC SQL UPDATE cmsttotal 
		SET ( UU_CMSTTOTAL ) = ( WW_CMSTTOTAL ) 
		WHERE  
		 cardno = :cmsttotal_cardno and 
		 trandevtype = :cmsttotal_trandevtype and 
		 ccy = :cmsttotal_ccy and 
		 period = :cmsttotal_period and 
		 startdate = :cmsttotal_startdate  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsttotal",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsttotal( struct cmsttotal * pstCmsttotal )
{
	pubInitCmsttotal();
	pubStoVCmsttotal(pstCmsttotal);
	EXEC SQL INSERT INTO cmsttotal VALUES ( RR_CMSTTOTAL ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsttotal",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}