tbcms040.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 cmsoperstat_trandate[11];
	short cmsoperstat_trandate_id;
	char cmsoperstat_cardkind[9];
	short cmsoperstat_cardkind_id;
	char cmsoperstat_ccy[4];
	short cmsoperstat_ccy_id;
	char cmsoperstat_trandevtype[3];
	short cmsoperstat_trandevtype_id;
	char cmsoperstat_devid[16];
	short cmsoperstat_devid_id;
	char cmsoperstat_trankind[4];
	short cmsoperstat_trankind_id;
	char cmsoperstat_trankindcomm[71];
	short cmsoperstat_trankindcomm_id;
	char cmsoperstat_cardkindcomm[31];
	short cmsoperstat_cardkindcomm_id;
	char cmsoperstat_ccycomm[71];
	short cmsoperstat_ccycomm_id;
	char cmsoperstat_trandevtypecomm[71];
	short cmsoperstat_trandevtypecomm_id;
	char cmsoperstat_brc[10];
	short cmsoperstat_brc_id;
	long cmsoperstat_cnt;
	short cmsoperstat_cnt_id;
	double cmsoperstat_amt;
	short cmsoperstat_amt_id;
	double cmsoperstat_fee;
	short cmsoperstat_fee_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSOPERSTAT \
		:cmsoperstat_trandate:cmsoperstat_trandate_id, \
		:cmsoperstat_cardkind:cmsoperstat_cardkind_id, \
		:cmsoperstat_ccy:cmsoperstat_ccy_id, \
		:cmsoperstat_trandevtype:cmsoperstat_trandevtype_id, \
		:cmsoperstat_devid:cmsoperstat_devid_id, \
		:cmsoperstat_trankind:cmsoperstat_trankind_id, \
		:cmsoperstat_trankindcomm:cmsoperstat_trankindcomm_id, \
		:cmsoperstat_cardkindcomm:cmsoperstat_cardkindcomm_id, \
		:cmsoperstat_ccycomm:cmsoperstat_ccycomm_id, \
		:cmsoperstat_trandevtypecomm:cmsoperstat_trandevtypecomm_id, \
		:cmsoperstat_brc:cmsoperstat_brc_id, \
		:cmsoperstat_cnt:cmsoperstat_cnt_id, \
		:cmsoperstat_amt:cmsoperstat_amt_id, \
		:cmsoperstat_fee:cmsoperstat_fee_id

#define UU_CMSOPERSTAT \
		trandate, \
		cardkind, \
		ccy, \
		trandevtype, \
		devid, \
		trankind, \
		trankindcomm, \
		cardkindcomm, \
		ccycomm, \
		trandevtypecomm, \
		brc, \
		cnt, \
		amt, \
		fee

#define WW_CMSOPERSTAT \
		:cmsoperstat_trandate, \
		:cmsoperstat_cardkind, \
		:cmsoperstat_ccy, \
		:cmsoperstat_trandevtype, \
		:cmsoperstat_devid, \
		:cmsoperstat_trankind, \
		:cmsoperstat_trankindcomm, \
		:cmsoperstat_cardkindcomm, \
		:cmsoperstat_ccycomm, \
		:cmsoperstat_trandevtypecomm, \
		:cmsoperstat_brc, \
		:cmsoperstat_cnt, \
		:cmsoperstat_amt, \
		:cmsoperstat_fee

struct cmsoperstat
{
	char	trandate[11];
	char	cardkind[9];
	char	ccy[4];
	char	trandevtype[3];
	char	devid[16];
	char	trankind[4];
	char	trankindcomm[71];
	char	cardkindcomm[31];
	char	ccycomm[71];
	char	trandevtypecomm[71];
	char	brc[10];
	long	cnt;
	double	amt;
	double	fee;
};

void pubInitCmsoperstat()
{
	memset( cmsoperstat_trandate, 0x00, sizeof( cmsoperstat_trandate ) ) ;
	cmsoperstat_trandate_id = 0 ;
	memset( cmsoperstat_cardkind, 0x00, sizeof( cmsoperstat_cardkind ) ) ;
	cmsoperstat_cardkind_id = 0 ;
	memset( cmsoperstat_ccy, 0x00, sizeof( cmsoperstat_ccy ) ) ;
	cmsoperstat_ccy_id = 0 ;
	memset( cmsoperstat_trandevtype, 0x00, sizeof( cmsoperstat_trandevtype ) ) ;
	cmsoperstat_trandevtype_id = 0 ;
	memset( cmsoperstat_devid, 0x00, sizeof( cmsoperstat_devid ) ) ;
	cmsoperstat_devid_id = 0 ;
	memset( cmsoperstat_trankind, 0x00, sizeof( cmsoperstat_trankind ) ) ;
	cmsoperstat_trankind_id = 0 ;
	memset( cmsoperstat_trankindcomm, 0x00, sizeof( cmsoperstat_trankindcomm ) ) ;
	cmsoperstat_trankindcomm_id = 0 ;
	memset( cmsoperstat_cardkindcomm, 0x00, sizeof( cmsoperstat_cardkindcomm ) ) ;
	cmsoperstat_cardkindcomm_id = 0 ;
	memset( cmsoperstat_ccycomm, 0x00, sizeof( cmsoperstat_ccycomm ) ) ;
	cmsoperstat_ccycomm_id = 0 ;
	memset( cmsoperstat_trandevtypecomm, 0x00, sizeof( cmsoperstat_trandevtypecomm ) ) ;
	cmsoperstat_trandevtypecomm_id = 0 ;
	memset( cmsoperstat_brc, 0x00, sizeof( cmsoperstat_brc ) ) ;
	cmsoperstat_brc_id = 0 ;
	memset( &cmsoperstat_cnt, 0x00, sizeof( cmsoperstat_cnt ) ) ;
	cmsoperstat_cnt_id = 0 ;
	memset( &cmsoperstat_amt, 0x00, sizeof( cmsoperstat_amt ) ) ;
	cmsoperstat_amt_id = 0 ;
	memset( &cmsoperstat_fee, 0x00, sizeof( cmsoperstat_fee ) ) ;
	cmsoperstat_fee_id = 0 ;
}

void pubStoVCmsoperstat( struct cmsoperstat * pstCmsoperstat )
{
	pubInitCmsoperstat();
	if( !strlen( pstCmsoperstat->trandate ) )
		strcpy( pstCmsoperstat->trandate, " " );
	strcpy( cmsoperstat_trandate, pstCmsoperstat->trandate );
	if( !strlen( pstCmsoperstat->cardkind ) )
		strcpy( pstCmsoperstat->cardkind, " " );
	strcpy( cmsoperstat_cardkind, pstCmsoperstat->cardkind );
	if( !strlen( pstCmsoperstat->ccy ) )
		strcpy( pstCmsoperstat->ccy, " " );
	strcpy( cmsoperstat_ccy, pstCmsoperstat->ccy );
	if( !strlen( pstCmsoperstat->trandevtype ) )
		strcpy( pstCmsoperstat->trandevtype, " " );
	strcpy( cmsoperstat_trandevtype, pstCmsoperstat->trandevtype );
	if( !strlen( pstCmsoperstat->devid ) )
		strcpy( pstCmsoperstat->devid, " " );
	strcpy( cmsoperstat_devid, pstCmsoperstat->devid );
	if( !strlen( pstCmsoperstat->trankind ) )
		strcpy( pstCmsoperstat->trankind, " " );
	strcpy( cmsoperstat_trankind, pstCmsoperstat->trankind );
	if( !strlen( pstCmsoperstat->trankindcomm ) )
		strcpy( pstCmsoperstat->trankindcomm, " " );
	strcpy( cmsoperstat_trankindcomm, pstCmsoperstat->trankindcomm );
	if( !strlen( pstCmsoperstat->cardkindcomm ) )
		strcpy( pstCmsoperstat->cardkindcomm, " " );
	strcpy( cmsoperstat_cardkindcomm, pstCmsoperstat->cardkindcomm );
	if( !strlen( pstCmsoperstat->ccycomm ) )
		strcpy( pstCmsoperstat->ccycomm, " " );
	strcpy( cmsoperstat_ccycomm, pstCmsoperstat->ccycomm );
	if( !strlen( pstCmsoperstat->trandevtypecomm ) )
		strcpy( pstCmsoperstat->trandevtypecomm, " " );
	strcpy( cmsoperstat_trandevtypecomm, pstCmsoperstat->trandevtypecomm );
	if( !strlen( pstCmsoperstat->brc ) )
		strcpy( pstCmsoperstat->brc, " " );
	strcpy( cmsoperstat_brc, pstCmsoperstat->brc );
	cmsoperstat_cnt = pstCmsoperstat->cnt ;
	cmsoperstat_amt = pstCmsoperstat->amt ;
	pubDround( &cmsoperstat_amt, 2 );
	cmsoperstat_fee = pstCmsoperstat->fee ;
	pubDround( &cmsoperstat_fee, 2 );
}

void pubVtoSCmsoperstat( struct cmsoperstat * pstCmsoperstat )
{
	strcpy( pstCmsoperstat->trandate, cmsoperstat_trandate );
	strpack( pstCmsoperstat->trandate );
	strcpy( pstCmsoperstat->cardkind, cmsoperstat_cardkind );
	strpack( pstCmsoperstat->cardkind );
	strcpy( pstCmsoperstat->ccy, cmsoperstat_ccy );
	strpack( pstCmsoperstat->ccy );
	strcpy( pstCmsoperstat->trandevtype, cmsoperstat_trandevtype );
	strpack( pstCmsoperstat->trandevtype );
	strcpy( pstCmsoperstat->devid, cmsoperstat_devid );
	strpack( pstCmsoperstat->devid );
	strcpy( pstCmsoperstat->trankind, cmsoperstat_trankind );
	strpack( pstCmsoperstat->trankind );
	strcpy( pstCmsoperstat->trankindcomm, cmsoperstat_trankindcomm );
	strpack( pstCmsoperstat->trankindcomm );
	strcpy( pstCmsoperstat->cardkindcomm, cmsoperstat_cardkindcomm );
	strpack( pstCmsoperstat->cardkindcomm );
	strcpy( pstCmsoperstat->ccycomm, cmsoperstat_ccycomm );
	strpack( pstCmsoperstat->ccycomm );
	strcpy( pstCmsoperstat->trandevtypecomm, cmsoperstat_trandevtypecomm );
	strpack( pstCmsoperstat->trandevtypecomm );
	strcpy( pstCmsoperstat->brc, cmsoperstat_brc );
	strpack( pstCmsoperstat->brc );
	pstCmsoperstat->cnt = cmsoperstat_cnt ;
	pstCmsoperstat->amt = cmsoperstat_amt ;
	pubDround( &pstCmsoperstat->amt, 2 );
	pstCmsoperstat->fee = cmsoperstat_fee ;
	pubDround( &pstCmsoperstat->fee, 2 );
}

int pubReadCmsoperstat( struct cmsoperstat * pstCmsoperstat )
{
	pubInitCmsoperstat();
	pubStoVCmsoperstat(pstCmsoperstat);
	EXEC SQL SELECT * INTO RR_CMSOPERSTAT 
		FROM cmsoperstat  
		WHERE  
		 trandate = :cmsoperstat_trandate and 
		 cardkind = :cmsoperstat_cardkind and 
		 ccy = :cmsoperstat_ccy and 
		 trandevtype = :cmsoperstat_trandevtype and 
		 devid = :cmsoperstat_devid and 
		 trankind = :cmsoperstat_trankind  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsoperstat",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsoperstat(pstCmsoperstat);
	return 0; 
} 
 
int pubModiCmsoperstat( struct cmsoperstat * pstCmsoperstat )
{
	pubInitCmsoperstat();
	pubStoVCmsoperstat(pstCmsoperstat);
	EXEC SQL UPDATE cmsoperstat 
		SET ( UU_CMSOPERSTAT ) = ( WW_CMSOPERSTAT ) 
		WHERE  
		 trandate = :cmsoperstat_trandate and 
		 cardkind = :cmsoperstat_cardkind and 
		 ccy = :cmsoperstat_ccy and 
		 trandevtype = :cmsoperstat_trandevtype and 
		 devid = :cmsoperstat_devid and 
		 trankind = :cmsoperstat_trankind  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsoperstat",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsoperstat( struct cmsoperstat * pstCmsoperstat )
{
	pubInitCmsoperstat();
	pubStoVCmsoperstat(pstCmsoperstat);
	EXEC SQL INSERT INTO cmsoperstat VALUES ( RR_CMSOPERSTAT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsoperstat",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}