tbcms049.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 cmsupayfeereg_settledate[11];
	short cmsupayfeereg_settledate_id;
	char cmsupayfeereg_brc[10];
	short cmsupayfeereg_brc_id;
	char cmsupayfeereg_trandevtype[3];
	short cmsupayfeereg_trandevtype_id;
	char cmsupayfeereg_trankind[4];
	short cmsupayfeereg_trankind_id;
	char cmsupayfeereg_ccy[4];
	short cmsupayfeereg_ccy_id;
	char cmsupayfeereg_trankindcomm[71];
	short cmsupayfeereg_trankindcomm_id;
	char cmsupayfeereg_ccycomm[71];
	short cmsupayfeereg_ccycomm_id;
	char cmsupayfeereg_trandevtypecomm[71];
	short cmsupayfeereg_trandevtypecomm_id;
	long cmsupayfeereg_cnt;
	short cmsupayfeereg_cnt_id;
	double cmsupayfeereg_amt;
	short cmsupayfeereg_amt_id;
	double cmsupayfeereg_fee;
	short cmsupayfeereg_fee_id;
	char cmsupayfeereg_trandate[11];
	short cmsupayfeereg_trandate_id;
	char cmsupayfeereg_oprbrc[10];
	short cmsupayfeereg_oprbrc_id;
	char cmsupayfeereg_oprteller[11];
	short cmsupayfeereg_oprteller_id;
	char cmsupayfeereg_validf[2];
	short cmsupayfeereg_validf_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSUPAYFEEREG \
		:cmsupayfeereg_settledate:cmsupayfeereg_settledate_id, \
		:cmsupayfeereg_brc:cmsupayfeereg_brc_id, \
		:cmsupayfeereg_trandevtype:cmsupayfeereg_trandevtype_id, \
		:cmsupayfeereg_trankind:cmsupayfeereg_trankind_id, \
		:cmsupayfeereg_ccy:cmsupayfeereg_ccy_id, \
		:cmsupayfeereg_trankindcomm:cmsupayfeereg_trankindcomm_id, \
		:cmsupayfeereg_ccycomm:cmsupayfeereg_ccycomm_id, \
		:cmsupayfeereg_trandevtypecomm:cmsupayfeereg_trandevtypecomm_id, \
		:cmsupayfeereg_cnt:cmsupayfeereg_cnt_id, \
		:cmsupayfeereg_amt:cmsupayfeereg_amt_id, \
		:cmsupayfeereg_fee:cmsupayfeereg_fee_id, \
		:cmsupayfeereg_trandate:cmsupayfeereg_trandate_id, \
		:cmsupayfeereg_oprbrc:cmsupayfeereg_oprbrc_id, \
		:cmsupayfeereg_oprteller:cmsupayfeereg_oprteller_id, \
		:cmsupayfeereg_validf:cmsupayfeereg_validf_id

#define UU_CMSUPAYFEEREG \
		settledate, \
		brc, \
		trandevtype, \
		trankind, \
		ccy, \
		trankindcomm, \
		ccycomm, \
		trandevtypecomm, \
		cnt, \
		amt, \
		fee, \
		trandate, \
		oprbrc, \
		oprteller, \
		validf

#define WW_CMSUPAYFEEREG \
		:cmsupayfeereg_settledate, \
		:cmsupayfeereg_brc, \
		:cmsupayfeereg_trandevtype, \
		:cmsupayfeereg_trankind, \
		:cmsupayfeereg_ccy, \
		:cmsupayfeereg_trankindcomm, \
		:cmsupayfeereg_ccycomm, \
		:cmsupayfeereg_trandevtypecomm, \
		:cmsupayfeereg_cnt, \
		:cmsupayfeereg_amt, \
		:cmsupayfeereg_fee, \
		:cmsupayfeereg_trandate, \
		:cmsupayfeereg_oprbrc, \
		:cmsupayfeereg_oprteller, \
		:cmsupayfeereg_validf

struct cmsupayfeereg
{
	char	settledate[11];
	char	brc[10];
	char	trandevtype[3];
	char	trankind[4];
	char	ccy[4];
	char	trankindcomm[71];
	char	ccycomm[71];
	char	trandevtypecomm[71];
	long	cnt;
	double	amt;
	double	fee;
	char	trandate[11];
	char	oprbrc[10];
	char	oprteller[11];
	char	validf[2];
};

void pubInitCmsupayfeereg()
{
	memset( cmsupayfeereg_settledate, 0x00, sizeof( cmsupayfeereg_settledate ) ) ;
	cmsupayfeereg_settledate_id = 0 ;
	memset( cmsupayfeereg_brc, 0x00, sizeof( cmsupayfeereg_brc ) ) ;
	cmsupayfeereg_brc_id = 0 ;
	memset( cmsupayfeereg_trandevtype, 0x00, sizeof( cmsupayfeereg_trandevtype ) ) ;
	cmsupayfeereg_trandevtype_id = 0 ;
	memset( cmsupayfeereg_trankind, 0x00, sizeof( cmsupayfeereg_trankind ) ) ;
	cmsupayfeereg_trankind_id = 0 ;
	memset( cmsupayfeereg_ccy, 0x00, sizeof( cmsupayfeereg_ccy ) ) ;
	cmsupayfeereg_ccy_id = 0 ;
	memset( cmsupayfeereg_trankindcomm, 0x00, sizeof( cmsupayfeereg_trankindcomm ) ) ;
	cmsupayfeereg_trankindcomm_id = 0 ;
	memset( cmsupayfeereg_ccycomm, 0x00, sizeof( cmsupayfeereg_ccycomm ) ) ;
	cmsupayfeereg_ccycomm_id = 0 ;
	memset( cmsupayfeereg_trandevtypecomm, 0x00, sizeof( cmsupayfeereg_trandevtypecomm ) ) ;
	cmsupayfeereg_trandevtypecomm_id = 0 ;
	memset( &cmsupayfeereg_cnt, 0x00, sizeof( cmsupayfeereg_cnt ) ) ;
	cmsupayfeereg_cnt_id = 0 ;
	memset( &cmsupayfeereg_amt, 0x00, sizeof( cmsupayfeereg_amt ) ) ;
	cmsupayfeereg_amt_id = 0 ;
	memset( &cmsupayfeereg_fee, 0x00, sizeof( cmsupayfeereg_fee ) ) ;
	cmsupayfeereg_fee_id = 0 ;
	memset( cmsupayfeereg_trandate, 0x00, sizeof( cmsupayfeereg_trandate ) ) ;
	cmsupayfeereg_trandate_id = 0 ;
	memset( cmsupayfeereg_oprbrc, 0x00, sizeof( cmsupayfeereg_oprbrc ) ) ;
	cmsupayfeereg_oprbrc_id = 0 ;
	memset( cmsupayfeereg_oprteller, 0x00, sizeof( cmsupayfeereg_oprteller ) ) ;
	cmsupayfeereg_oprteller_id = 0 ;
	memset( cmsupayfeereg_validf, 0x00, sizeof( cmsupayfeereg_validf ) ) ;
	cmsupayfeereg_validf_id = 0 ;
}

void pubStoVCmsupayfeereg( struct cmsupayfeereg * pstCmsupayfeereg )
{
	pubInitCmsupayfeereg();
	if( !strlen( pstCmsupayfeereg->settledate ) )
		strcpy( pstCmsupayfeereg->settledate, " " );
	strcpy( cmsupayfeereg_settledate, pstCmsupayfeereg->settledate );
	if( !strlen( pstCmsupayfeereg->brc ) )
		strcpy( pstCmsupayfeereg->brc, " " );
	strcpy( cmsupayfeereg_brc, pstCmsupayfeereg->brc );
	if( !strlen( pstCmsupayfeereg->trandevtype ) )
		strcpy( pstCmsupayfeereg->trandevtype, " " );
	strcpy( cmsupayfeereg_trandevtype, pstCmsupayfeereg->trandevtype );
	if( !strlen( pstCmsupayfeereg->trankind ) )
		strcpy( pstCmsupayfeereg->trankind, " " );
	strcpy( cmsupayfeereg_trankind, pstCmsupayfeereg->trankind );
	if( !strlen( pstCmsupayfeereg->ccy ) )
		strcpy( pstCmsupayfeereg->ccy, " " );
	strcpy( cmsupayfeereg_ccy, pstCmsupayfeereg->ccy );
	if( !strlen( pstCmsupayfeereg->trankindcomm ) )
		strcpy( pstCmsupayfeereg->trankindcomm, " " );
	strcpy( cmsupayfeereg_trankindcomm, pstCmsupayfeereg->trankindcomm );
	if( !strlen( pstCmsupayfeereg->ccycomm ) )
		strcpy( pstCmsupayfeereg->ccycomm, " " );
	strcpy( cmsupayfeereg_ccycomm, pstCmsupayfeereg->ccycomm );
	if( !strlen( pstCmsupayfeereg->trandevtypecomm ) )
		strcpy( pstCmsupayfeereg->trandevtypecomm, " " );
	strcpy( cmsupayfeereg_trandevtypecomm, pstCmsupayfeereg->trandevtypecomm );
	cmsupayfeereg_cnt = pstCmsupayfeereg->cnt ;
	cmsupayfeereg_amt = pstCmsupayfeereg->amt ;
	pubDround( &cmsupayfeereg_amt, 2 );
	cmsupayfeereg_fee = pstCmsupayfeereg->fee ;
	pubDround( &cmsupayfeereg_fee, 2 );
	if( !strlen( pstCmsupayfeereg->trandate ) )
		strcpy( pstCmsupayfeereg->trandate, " " );
	strcpy( cmsupayfeereg_trandate, pstCmsupayfeereg->trandate );
	if( !strlen( pstCmsupayfeereg->oprbrc ) )
		strcpy( pstCmsupayfeereg->oprbrc, " " );
	strcpy( cmsupayfeereg_oprbrc, pstCmsupayfeereg->oprbrc );
	if( !strlen( pstCmsupayfeereg->oprteller ) )
		strcpy( pstCmsupayfeereg->oprteller, " " );
	strcpy( cmsupayfeereg_oprteller, pstCmsupayfeereg->oprteller );
	if( !strlen( pstCmsupayfeereg->validf ) )
		strcpy( pstCmsupayfeereg->validf, " " );
	strcpy( cmsupayfeereg_validf, pstCmsupayfeereg->validf );
}

void pubVtoSCmsupayfeereg( struct cmsupayfeereg * pstCmsupayfeereg )
{
	strcpy( pstCmsupayfeereg->settledate, cmsupayfeereg_settledate );
	strpack( pstCmsupayfeereg->settledate );
	strcpy( pstCmsupayfeereg->brc, cmsupayfeereg_brc );
	strpack( pstCmsupayfeereg->brc );
	strcpy( pstCmsupayfeereg->trandevtype, cmsupayfeereg_trandevtype );
	strpack( pstCmsupayfeereg->trandevtype );
	strcpy( pstCmsupayfeereg->trankind, cmsupayfeereg_trankind );
	strpack( pstCmsupayfeereg->trankind );
	strcpy( pstCmsupayfeereg->ccy, cmsupayfeereg_ccy );
	strpack( pstCmsupayfeereg->ccy );
	strcpy( pstCmsupayfeereg->trankindcomm, cmsupayfeereg_trankindcomm );
	strpack( pstCmsupayfeereg->trankindcomm );
	strcpy( pstCmsupayfeereg->ccycomm, cmsupayfeereg_ccycomm );
	strpack( pstCmsupayfeereg->ccycomm );
	strcpy( pstCmsupayfeereg->trandevtypecomm, cmsupayfeereg_trandevtypecomm );
	strpack( pstCmsupayfeereg->trandevtypecomm );
	pstCmsupayfeereg->cnt = cmsupayfeereg_cnt ;
	pstCmsupayfeereg->amt = cmsupayfeereg_amt ;
	pubDround( &pstCmsupayfeereg->amt, 2 );
	pstCmsupayfeereg->fee = cmsupayfeereg_fee ;
	pubDround( &pstCmsupayfeereg->fee, 2 );
	strcpy( pstCmsupayfeereg->trandate, cmsupayfeereg_trandate );
	strpack( pstCmsupayfeereg->trandate );
	strcpy( pstCmsupayfeereg->oprbrc, cmsupayfeereg_oprbrc );
	strpack( pstCmsupayfeereg->oprbrc );
	strcpy( pstCmsupayfeereg->oprteller, cmsupayfeereg_oprteller );
	strpack( pstCmsupayfeereg->oprteller );
	strcpy( pstCmsupayfeereg->validf, cmsupayfeereg_validf );
	strpack( pstCmsupayfeereg->validf );
}

int pubReadCmsupayfeereg( struct cmsupayfeereg * pstCmsupayfeereg )
{
	pubInitCmsupayfeereg();
	pubStoVCmsupayfeereg(pstCmsupayfeereg);
	EXEC SQL SELECT * INTO RR_CMSUPAYFEEREG 
		FROM cmsupayfeereg  
		WHERE  
		 settledate = :cmsupayfeereg_settledate and 
		 brc = :cmsupayfeereg_brc and 
		 trandevtype = :cmsupayfeereg_trandevtype and 
		 trankind = :cmsupayfeereg_trankind and 
		 ccy = :cmsupayfeereg_ccy  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsupayfeereg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsupayfeereg(pstCmsupayfeereg);
	return 0; 
} 
 
int pubModiCmsupayfeereg( struct cmsupayfeereg * pstCmsupayfeereg )
{
	pubInitCmsupayfeereg();
	pubStoVCmsupayfeereg(pstCmsupayfeereg);
	EXEC SQL UPDATE cmsupayfeereg 
		SET ( UU_CMSUPAYFEEREG ) = ( WW_CMSUPAYFEEREG ) 
		WHERE  
		 settledate = :cmsupayfeereg_settledate and 
		 brc = :cmsupayfeereg_brc and 
		 trandevtype = :cmsupayfeereg_trandevtype and 
		 trankind = :cmsupayfeereg_trankind and 
		 ccy = :cmsupayfeereg_ccy  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsupayfeereg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsupayfeereg( struct cmsupayfeereg * pstCmsupayfeereg )
{
	pubInitCmsupayfeereg();
	pubStoVCmsupayfeereg(pstCmsupayfeereg);
	EXEC SQL INSERT INTO cmsupayfeereg VALUES ( RR_CMSUPAYFEEREG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsupayfeereg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}