tbcms053.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 cmsintegrallmt_accummode[5];
	short cmsintegrallmt_accummode_id;
	char cmsintegrallmt_cdtrantype[4];
	short cmsintegrallmt_cdtrantype_id;
	char cmsintegrallmt_bussplace[3];
	short cmsintegrallmt_bussplace_id;
	char cmsintegrallmt_ccy[4];
	short cmsintegrallmt_ccy_id;
	double cmsintegrallmt_hortoveramt;
	short cmsintegrallmt_hortoveramt_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSINTEGRALLMT \
		:cmsintegrallmt_accummode:cmsintegrallmt_accummode_id, \
		:cmsintegrallmt_cdtrantype:cmsintegrallmt_cdtrantype_id, \
		:cmsintegrallmt_bussplace:cmsintegrallmt_bussplace_id, \
		:cmsintegrallmt_ccy:cmsintegrallmt_ccy_id, \
		:cmsintegrallmt_hortoveramt:cmsintegrallmt_hortoveramt_id

#define UU_CMSINTEGRALLMT \
		accummode, \
		cdtrantype, \
		bussplace, \
		ccy, \
		hortoveramt

#define WW_CMSINTEGRALLMT \
		:cmsintegrallmt_accummode, \
		:cmsintegrallmt_cdtrantype, \
		:cmsintegrallmt_bussplace, \
		:cmsintegrallmt_ccy, \
		:cmsintegrallmt_hortoveramt

struct cmsintegrallmt
{
	char	accummode[5];
	char	cdtrantype[4];
	char	bussplace[3];
	char	ccy[4];
	double	hortoveramt;
};

void pubInitCmsintegrallmt()
{
	memset( cmsintegrallmt_accummode, 0x00, sizeof( cmsintegrallmt_accummode ) ) ;
	cmsintegrallmt_accummode_id = 0 ;
	memset( cmsintegrallmt_cdtrantype, 0x00, sizeof( cmsintegrallmt_cdtrantype ) ) ;
	cmsintegrallmt_cdtrantype_id = 0 ;
	memset( cmsintegrallmt_bussplace, 0x00, sizeof( cmsintegrallmt_bussplace ) ) ;
	cmsintegrallmt_bussplace_id = 0 ;
	memset( cmsintegrallmt_ccy, 0x00, sizeof( cmsintegrallmt_ccy ) ) ;
	cmsintegrallmt_ccy_id = 0 ;
	memset( &cmsintegrallmt_hortoveramt, 0x00, sizeof( cmsintegrallmt_hortoveramt ) ) ;
	cmsintegrallmt_hortoveramt_id = 0 ;
}

void pubStoVCmsintegrallmt( struct cmsintegrallmt * pstCmsintegrallmt )
{
	pubInitCmsintegrallmt();
	if( !strlen( pstCmsintegrallmt->accummode ) )
		strcpy( pstCmsintegrallmt->accummode, " " );
	strcpy( cmsintegrallmt_accummode, pstCmsintegrallmt->accummode );
	if( !strlen( pstCmsintegrallmt->cdtrantype ) )
		strcpy( pstCmsintegrallmt->cdtrantype, " " );
	strcpy( cmsintegrallmt_cdtrantype, pstCmsintegrallmt->cdtrantype );
	if( !strlen( pstCmsintegrallmt->bussplace ) )
		strcpy( pstCmsintegrallmt->bussplace, " " );
	strcpy( cmsintegrallmt_bussplace, pstCmsintegrallmt->bussplace );
	if( !strlen( pstCmsintegrallmt->ccy ) )
		strcpy( pstCmsintegrallmt->ccy, " " );
	strcpy( cmsintegrallmt_ccy, pstCmsintegrallmt->ccy );
	cmsintegrallmt_hortoveramt = pstCmsintegrallmt->hortoveramt ;
	pubDround( &cmsintegrallmt_hortoveramt, 2 );
}

void pubVtoSCmsintegrallmt( struct cmsintegrallmt * pstCmsintegrallmt )
{
	strcpy( pstCmsintegrallmt->accummode, cmsintegrallmt_accummode );
	strpack( pstCmsintegrallmt->accummode );
	strcpy( pstCmsintegrallmt->cdtrantype, cmsintegrallmt_cdtrantype );
	strpack( pstCmsintegrallmt->cdtrantype );
	strcpy( pstCmsintegrallmt->bussplace, cmsintegrallmt_bussplace );
	strpack( pstCmsintegrallmt->bussplace );
	strcpy( pstCmsintegrallmt->ccy, cmsintegrallmt_ccy );
	strpack( pstCmsintegrallmt->ccy );
	pstCmsintegrallmt->hortoveramt = cmsintegrallmt_hortoveramt ;
	pubDround( &pstCmsintegrallmt->hortoveramt, 2 );
}

int pubReadCmsintegrallmt( struct cmsintegrallmt * pstCmsintegrallmt )
{
	pubInitCmsintegrallmt();
	pubStoVCmsintegrallmt(pstCmsintegrallmt);
	EXEC SQL SELECT * INTO RR_CMSINTEGRALLMT 
		FROM cmsintegrallmt  
		WHERE  
		 accummode = :cmsintegrallmt_accummode and 
		 cdtrantype = :cmsintegrallmt_cdtrantype and 
		 bussplace = :cmsintegrallmt_bussplace and 
		 ccy = :cmsintegrallmt_ccy  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsintegrallmt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsintegrallmt(pstCmsintegrallmt);
	return 0; 
} 
 
int pubModiCmsintegrallmt( struct cmsintegrallmt * pstCmsintegrallmt )
{
	pubInitCmsintegrallmt();
	pubStoVCmsintegrallmt(pstCmsintegrallmt);
	EXEC SQL UPDATE cmsintegrallmt 
		SET ( UU_CMSINTEGRALLMT ) = ( WW_CMSINTEGRALLMT ) 
		WHERE  
		 accummode = :cmsintegrallmt_accummode and 
		 cdtrantype = :cmsintegrallmt_cdtrantype and 
		 bussplace = :cmsintegrallmt_bussplace and 
		 ccy = :cmsintegrallmt_ccy  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsintegrallmt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsintegrallmt( struct cmsintegrallmt * pstCmsintegrallmt )
{
	pubInitCmsintegrallmt();
	pubStoVCmsintegrallmt(pstCmsintegrallmt);
	EXEC SQL INSERT INTO cmsintegrallmt VALUES ( RR_CMSINTEGRALLMT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsintegrallmt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}