tbcms051.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 cmsyearcfg_yearfeerank[5];
	short cmsyearcfg_yearfeerank_id;
	char cmsyearcfg_yearfeerankcomm[41];
	short cmsyearcfg_yearfeerankcomm_id;
	double cmsyearcfg_mcardinitfee;
	short cmsyearcfg_mcardinitfee_id;
	double cmsyearcfg_fcardinitfee;
	short cmsyearcfg_fcardinitfee_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSYEARCFG \
		:cmsyearcfg_yearfeerank:cmsyearcfg_yearfeerank_id, \
		:cmsyearcfg_yearfeerankcomm:cmsyearcfg_yearfeerankcomm_id, \
		:cmsyearcfg_mcardinitfee:cmsyearcfg_mcardinitfee_id, \
		:cmsyearcfg_fcardinitfee:cmsyearcfg_fcardinitfee_id

#define UU_CMSYEARCFG \
		yearfeerank, \
		yearfeerankcomm, \
		mcardinitfee, \
		fcardinitfee

#define WW_CMSYEARCFG \
		:cmsyearcfg_yearfeerank, \
		:cmsyearcfg_yearfeerankcomm, \
		:cmsyearcfg_mcardinitfee, \
		:cmsyearcfg_fcardinitfee

struct cmsyearcfg
{
	char	yearfeerank[5];
	char	yearfeerankcomm[41];
	double	mcardinitfee;
	double	fcardinitfee;
};

void pubInitCmsyearcfg()
{
	memset( cmsyearcfg_yearfeerank, 0x00, sizeof( cmsyearcfg_yearfeerank ) ) ;
	cmsyearcfg_yearfeerank_id = 0 ;
	memset( cmsyearcfg_yearfeerankcomm, 0x00, sizeof( cmsyearcfg_yearfeerankcomm ) ) ;
	cmsyearcfg_yearfeerankcomm_id = 0 ;
	memset( &cmsyearcfg_mcardinitfee, 0x00, sizeof( cmsyearcfg_mcardinitfee ) ) ;
	cmsyearcfg_mcardinitfee_id = 0 ;
	memset( &cmsyearcfg_fcardinitfee, 0x00, sizeof( cmsyearcfg_fcardinitfee ) ) ;
	cmsyearcfg_fcardinitfee_id = 0 ;
}

void pubStoVCmsyearcfg( struct cmsyearcfg * pstCmsyearcfg )
{
	pubInitCmsyearcfg();
	if( !strlen( pstCmsyearcfg->yearfeerank ) )
		strcpy( pstCmsyearcfg->yearfeerank, " " );
	strcpy( cmsyearcfg_yearfeerank, pstCmsyearcfg->yearfeerank );
	if( !strlen( pstCmsyearcfg->yearfeerankcomm ) )
		strcpy( pstCmsyearcfg->yearfeerankcomm, " " );
	strcpy( cmsyearcfg_yearfeerankcomm, pstCmsyearcfg->yearfeerankcomm );
	cmsyearcfg_mcardinitfee = pstCmsyearcfg->mcardinitfee ;
	pubDround( &cmsyearcfg_mcardinitfee, 2 );
	cmsyearcfg_fcardinitfee = pstCmsyearcfg->fcardinitfee ;
	pubDround( &cmsyearcfg_fcardinitfee, 2 );
}

void pubVtoSCmsyearcfg( struct cmsyearcfg * pstCmsyearcfg )
{
	strcpy( pstCmsyearcfg->yearfeerank, cmsyearcfg_yearfeerank );
	strpack( pstCmsyearcfg->yearfeerank );
	strcpy( pstCmsyearcfg->yearfeerankcomm, cmsyearcfg_yearfeerankcomm );
	strpack( pstCmsyearcfg->yearfeerankcomm );
	pstCmsyearcfg->mcardinitfee = cmsyearcfg_mcardinitfee ;
	pubDround( &pstCmsyearcfg->mcardinitfee, 2 );
	pstCmsyearcfg->fcardinitfee = cmsyearcfg_fcardinitfee ;
	pubDround( &pstCmsyearcfg->fcardinitfee, 2 );
}



int pubReadCmsyearcfg( struct cmsyearcfg * pstCmsyearcfg )
{
	pubInitCmsyearcfg();
	pubStoVCmsyearcfg(pstCmsyearcfg);
	EXEC SQL SELECT * INTO RR_CMSYEARCFG 
		FROM cmsyearcfg  
		WHERE  
		 yearfeerank = :cmsyearcfg_yearfeerank  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsyearcfg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsyearcfg(pstCmsyearcfg);
	return 0; 
} 
 


int pubModiCmsyearcfg( struct cmsyearcfg * pstCmsyearcfg )
{
	pubInitCmsyearcfg();
	pubStoVCmsyearcfg(pstCmsyearcfg);
	EXEC SQL UPDATE cmsyearcfg 
		SET ( UU_CMSYEARCFG ) = ( WW_CMSYEARCFG ) 
		WHERE  
		 yearfeerank = :cmsyearcfg_yearfeerank  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsyearcfg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmsyearcfg( struct cmsyearcfg * pstCmsyearcfg )
{
	pubInitCmsyearcfg();
	pubStoVCmsyearcfg(pstCmsyearcfg);
	EXEC SQL INSERT INTO cmsyearcfg VALUES ( RR_CMSYEARCFG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsyearcfg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
} 
void pubTracCmsyearcfg( struct cmsyearcfg * pstCmsyearcfg )
{
	sprintf( g_acTrcMsg, "cmsyearcfg:yearfeerank=[%s]", pstCmsyearcfg->yearfeerank );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmsyearcfg:yearfeerankcomm=[%s]", pstCmsyearcfg->yearfeerankcomm );
	TRCLOG1
	pubDround( &(pstCmsyearcfg->mcardinitfee), 2 );
	sprintf( g_acTrcMsg, "cmsyearcfg:mcardinitfee=[%.2lf]", pstCmsyearcfg->mcardinitfee) ;
	TRCLOG1
	pubDround( &(pstCmsyearcfg->fcardinitfee), 2 );
	sprintf( g_acTrcMsg, "cmsyearcfg:fcardinitfee=[%.2lf]", pstCmsyearcfg->fcardinitfee) ;
	TRCLOG1
}