tbcms050.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 cmsyearfeem_cardkind[9];
	short cmsyearfeem_cardkind_id;
	long cmsyearfeem_serverlevel;
	short cmsyearfeem_serverlevel_id;
	char cmsyearfeem_yearfeerank[5];
	short cmsyearfeem_yearfeerank_id;
	char cmsyearfeem_getfeetype[2];
	short cmsyearfeem_getfeetype_id;
	char cmsyearfeem_getinitfeedate[5];
	short cmsyearfeem_getinitfeedate_id;
	char cmsyearfeem_initfeedatemark[2];
	short cmsyearfeem_initfeedatemark_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSYEARFEEM \
		:cmsyearfeem_cardkind:cmsyearfeem_cardkind_id, \
		:cmsyearfeem_serverlevel:cmsyearfeem_serverlevel_id, \
		:cmsyearfeem_yearfeerank:cmsyearfeem_yearfeerank_id, \
		:cmsyearfeem_getfeetype:cmsyearfeem_getfeetype_id, \
		:cmsyearfeem_getinitfeedate:cmsyearfeem_getinitfeedate_id, \
		:cmsyearfeem_initfeedatemark:cmsyearfeem_initfeedatemark_id

#define UU_CMSYEARFEEM \
		cardkind, \
		serverlevel, \
		yearfeerank, \
		getfeetype, \
		getinitfeedate, \
		initfeedatemark

#define WW_CMSYEARFEEM \
		:cmsyearfeem_cardkind, \
		:cmsyearfeem_serverlevel, \
		:cmsyearfeem_yearfeerank, \
		:cmsyearfeem_getfeetype, \
		:cmsyearfeem_getinitfeedate, \
		:cmsyearfeem_initfeedatemark

struct cmsyearfeem
{
	char	cardkind[9];
	long	serverlevel;
	char	yearfeerank[5];
	char	getfeetype[2];
	char	getinitfeedate[5];
	char	initfeedatemark[2];
};

void pubInitCmsyearfeem()
{
	memset( cmsyearfeem_cardkind, 0x00, sizeof( cmsyearfeem_cardkind ) ) ;
	cmsyearfeem_cardkind_id = 0 ;
	memset( &cmsyearfeem_serverlevel, 0x00, sizeof( cmsyearfeem_serverlevel ) ) ;
	cmsyearfeem_serverlevel_id = 0 ;
	memset( cmsyearfeem_yearfeerank, 0x00, sizeof( cmsyearfeem_yearfeerank ) ) ;
	cmsyearfeem_yearfeerank_id = 0 ;
	memset( cmsyearfeem_getfeetype, 0x00, sizeof( cmsyearfeem_getfeetype ) ) ;
	cmsyearfeem_getfeetype_id = 0 ;
	memset( cmsyearfeem_getinitfeedate, 0x00, sizeof( cmsyearfeem_getinitfeedate ) ) ;
	cmsyearfeem_getinitfeedate_id = 0 ;
	memset( cmsyearfeem_initfeedatemark, 0x00, sizeof( cmsyearfeem_initfeedatemark ) ) ;
	cmsyearfeem_initfeedatemark_id = 0 ;
}

void pubStoVCmsyearfeem( struct cmsyearfeem * pstCmsyearfeem )
{
	pubInitCmsyearfeem();
	if( !strlen( pstCmsyearfeem->cardkind ) )
		strcpy( pstCmsyearfeem->cardkind, " " );
	strcpy( cmsyearfeem_cardkind, pstCmsyearfeem->cardkind );
	cmsyearfeem_serverlevel = pstCmsyearfeem->serverlevel ;
	if( !strlen( pstCmsyearfeem->yearfeerank ) )
		strcpy( pstCmsyearfeem->yearfeerank, " " );
	strcpy( cmsyearfeem_yearfeerank, pstCmsyearfeem->yearfeerank );
	if( !strlen( pstCmsyearfeem->getfeetype ) )
		strcpy( pstCmsyearfeem->getfeetype, " " );
	strcpy( cmsyearfeem_getfeetype, pstCmsyearfeem->getfeetype );
	if( !strlen( pstCmsyearfeem->getinitfeedate ) )
		strcpy( pstCmsyearfeem->getinitfeedate, " " );
	strcpy( cmsyearfeem_getinitfeedate, pstCmsyearfeem->getinitfeedate );
	if( !strlen( pstCmsyearfeem->initfeedatemark ) )
		strcpy( pstCmsyearfeem->initfeedatemark, " " );
	strcpy( cmsyearfeem_initfeedatemark, pstCmsyearfeem->initfeedatemark );
}

void pubVtoSCmsyearfeem( struct cmsyearfeem * pstCmsyearfeem )
{
	strcpy( pstCmsyearfeem->cardkind, cmsyearfeem_cardkind );
	strpack( pstCmsyearfeem->cardkind );
	pstCmsyearfeem->serverlevel = cmsyearfeem_serverlevel ;
	strcpy( pstCmsyearfeem->yearfeerank, cmsyearfeem_yearfeerank );
	strpack( pstCmsyearfeem->yearfeerank );
	strcpy( pstCmsyearfeem->getfeetype, cmsyearfeem_getfeetype );
	strpack( pstCmsyearfeem->getfeetype );
	strcpy( pstCmsyearfeem->getinitfeedate, cmsyearfeem_getinitfeedate );
	strpack( pstCmsyearfeem->getinitfeedate );
	strcpy( pstCmsyearfeem->initfeedatemark, cmsyearfeem_initfeedatemark );
	strpack( pstCmsyearfeem->initfeedatemark );
}



int pubReadCmsyearfeem( struct cmsyearfeem * pstCmsyearfeem )
{
	pubInitCmsyearfeem();
	pubStoVCmsyearfeem(pstCmsyearfeem);
	EXEC SQL SELECT * INTO RR_CMSYEARFEEM 
		FROM cmsyearfeem  
		WHERE  
		 cardkind = :cmsyearfeem_cardkind and 
		 serverlevel = :cmsyearfeem_serverlevel and 
		 yearfeerank = :cmsyearfeem_yearfeerank  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsyearfeem",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsyearfeem(pstCmsyearfeem);
	return 0; 
} 
 


int pubModiCmsyearfeem( struct cmsyearfeem * pstCmsyearfeem )
{
	pubInitCmsyearfeem();
	pubStoVCmsyearfeem(pstCmsyearfeem);
	EXEC SQL UPDATE cmsyearfeem 
		SET ( UU_CMSYEARFEEM ) = ( WW_CMSYEARFEEM ) 
		WHERE  
		 cardkind = :cmsyearfeem_cardkind and 
		 serverlevel = :cmsyearfeem_serverlevel and 
		 yearfeerank = :cmsyearfeem_yearfeerank  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsyearfeem",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmsyearfeem( struct cmsyearfeem * pstCmsyearfeem )
{
	pubInitCmsyearfeem();
	pubStoVCmsyearfeem(pstCmsyearfeem);
	EXEC SQL INSERT INTO cmsyearfeem VALUES ( RR_CMSYEARFEEM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsyearfeem",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
} 
void pubTracCmsyearfeem( struct cmsyearfeem * pstCmsyearfeem )
{
	sprintf( g_acTrcMsg, "cmsyearfeem:cardkind=[%s]", pstCmsyearfeem->cardkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmsyearfeem:serverlevel=[%d]", pstCmsyearfeem->serverlevel) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmsyearfeem:yearfeerank=[%s]", pstCmsyearfeem->yearfeerank );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmsyearfeem:getfeetype=[%s]", pstCmsyearfeem->getfeetype );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmsyearfeem:getinitfeedate=[%s]", pstCmsyearfeem->getinitfeedate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmsyearfeem:initfeedatemark=[%s]", pstCmsyearfeem->initfeedatemark );
	TRCLOG1
}