tbcms045.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 cmscardkindlmt_cardkind[9];
	short cmscardkindlmt_cardkind_id;
	char cmscardkindlmt_cdtrantype[4];
	short cmscardkindlmt_cdtrantype_id;
	char cmscardkindlmt_bussplace[3];
	short cmscardkindlmt_bussplace_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCARDKINDLMT \
		:cmscardkindlmt_cardkind:cmscardkindlmt_cardkind_id, \
		:cmscardkindlmt_cdtrantype:cmscardkindlmt_cdtrantype_id, \
		:cmscardkindlmt_bussplace:cmscardkindlmt_bussplace_id

#define UU_CMSCARDKINDLMT \
		cardkind, \
		cdtrantype, \
		bussplace

#define WW_CMSCARDKINDLMT \
		:cmscardkindlmt_cardkind, \
		:cmscardkindlmt_cdtrantype, \
		:cmscardkindlmt_bussplace

struct cmscardkindlmt
{
	char	cardkind[9];
	char	cdtrantype[4];
	char	bussplace[3];
};

void pubInitCmscardkindlmt()
{
	memset( cmscardkindlmt_cardkind, 0x00, sizeof( cmscardkindlmt_cardkind ) ) ;
	cmscardkindlmt_cardkind_id = 0 ;
	memset( cmscardkindlmt_cdtrantype, 0x00, sizeof( cmscardkindlmt_cdtrantype ) ) ;
	cmscardkindlmt_cdtrantype_id = 0 ;
	memset( cmscardkindlmt_bussplace, 0x00, sizeof( cmscardkindlmt_bussplace ) ) ;
	cmscardkindlmt_bussplace_id = 0 ;
}

void pubStoVCmscardkindlmt( struct cmscardkindlmt * pstCmscardkindlmt )
{
	pubInitCmscardkindlmt();
	if( !strlen( pstCmscardkindlmt->cardkind ) )
		strcpy( pstCmscardkindlmt->cardkind, " " );
	strcpy( cmscardkindlmt_cardkind, pstCmscardkindlmt->cardkind );
	if( !strlen( pstCmscardkindlmt->cdtrantype ) )
		strcpy( pstCmscardkindlmt->cdtrantype, " " );
	strcpy( cmscardkindlmt_cdtrantype, pstCmscardkindlmt->cdtrantype );
	if( !strlen( pstCmscardkindlmt->bussplace ) )
		strcpy( pstCmscardkindlmt->bussplace, " " );
	strcpy( cmscardkindlmt_bussplace, pstCmscardkindlmt->bussplace );
}

void pubVtoSCmscardkindlmt( struct cmscardkindlmt * pstCmscardkindlmt )
{
	strcpy( pstCmscardkindlmt->cardkind, cmscardkindlmt_cardkind );
	strpack( pstCmscardkindlmt->cardkind );
	strcpy( pstCmscardkindlmt->cdtrantype, cmscardkindlmt_cdtrantype );
	strpack( pstCmscardkindlmt->cdtrantype );
	strcpy( pstCmscardkindlmt->bussplace, cmscardkindlmt_bussplace );
	strpack( pstCmscardkindlmt->bussplace );
}

int pubReadCmscardkindlmt( struct cmscardkindlmt * pstCmscardkindlmt )
{
	pubInitCmscardkindlmt();
	pubStoVCmscardkindlmt(pstCmscardkindlmt);
	EXEC SQL SELECT * INTO RR_CMSCARDKINDLMT 
		FROM cmscardkindlmt  
		WHERE  
		 cardkind = :cmscardkindlmt_cardkind and 
		 cdtrantype = :cmscardkindlmt_cdtrantype and 
		 bussplace = :cmscardkindlmt_bussplace  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscardkindlmt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscardkindlmt(pstCmscardkindlmt);
	return 0; 
} 
 
int pubModiCmscardkindlmt( struct cmscardkindlmt * pstCmscardkindlmt )
{
	pubInitCmscardkindlmt();
	pubStoVCmscardkindlmt(pstCmscardkindlmt);
	EXEC SQL UPDATE cmscardkindlmt 
		SET ( UU_CMSCARDKINDLMT ) = ( WW_CMSCARDKINDLMT ) 
		WHERE  
		 cardkind = :cmscardkindlmt_cardkind and 
		 cdtrantype = :cmscardkindlmt_cdtrantype and 
		 bussplace = :cmscardkindlmt_bussplace  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscardkindlmt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmscardkindlmt( struct cmscardkindlmt * pstCmscardkindlmt )
{
	pubInitCmscardkindlmt();
	pubStoVCmscardkindlmt(pstCmscardkindlmt);
	EXEC SQL INSERT INTO cmscardkindlmt VALUES ( RR_CMSCARDKINDLMT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscardkindlmt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}