tbcms003.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 cmscurprd_cardkind[9];
	short cmscurprd_cardkind_id;
	char cmscurprd_ccy[4];
	short cmscurprd_ccy_id;
	char cmscurprd_prdcod[8];
	short cmscurprd_prdcod_id;
	long cmscurprd_acctnum;
	short cmscurprd_acctnum_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCURPRD \
		:cmscurprd_cardkind:cmscurprd_cardkind_id, \
		:cmscurprd_ccy:cmscurprd_ccy_id, \
		:cmscurprd_prdcod:cmscurprd_prdcod_id, \
		:cmscurprd_acctnum:cmscurprd_acctnum_id

#define UU_CMSCURPRD \
		cardkind, \
		ccy, \
		prdcod, \
		acctnum

#define WW_CMSCURPRD \
		:cmscurprd_cardkind, \
		:cmscurprd_ccy, \
		:cmscurprd_prdcod, \
		:cmscurprd_acctnum

struct cmscurprd
{
	char	cardkind[9];
	char	ccy[4];
	char	prdcod[8];
	long	acctnum;
};

void pubInitCmscurprd()
{
	memset( cmscurprd_cardkind, 0x00, sizeof( cmscurprd_cardkind ) ) ;
	cmscurprd_cardkind_id = 0 ;
	memset( cmscurprd_ccy, 0x00, sizeof( cmscurprd_ccy ) ) ;
	cmscurprd_ccy_id = 0 ;
	memset( cmscurprd_prdcod, 0x00, sizeof( cmscurprd_prdcod ) ) ;
	cmscurprd_prdcod_id = 0 ;
	memset( &cmscurprd_acctnum, 0x00, sizeof( cmscurprd_acctnum ) ) ;
	cmscurprd_acctnum_id = 0 ;
}

void pubStoVCmscurprd( struct cmscurprd * pstCmscurprd )
{
	pubInitCmscurprd();
	if( !strlen( pstCmscurprd->cardkind ) )
		strcpy( pstCmscurprd->cardkind, " " );
	strcpy( cmscurprd_cardkind, pstCmscurprd->cardkind );
	if( !strlen( pstCmscurprd->ccy ) )
		strcpy( pstCmscurprd->ccy, " " );
	strcpy( cmscurprd_ccy, pstCmscurprd->ccy );
	if( !strlen( pstCmscurprd->prdcod ) )
		strcpy( pstCmscurprd->prdcod, " " );
	strcpy( cmscurprd_prdcod, pstCmscurprd->prdcod );
	cmscurprd_acctnum = pstCmscurprd->acctnum ;
}

void pubVtoSCmscurprd( struct cmscurprd * pstCmscurprd )
{
	strcpy( pstCmscurprd->cardkind, cmscurprd_cardkind );
	strpack( pstCmscurprd->cardkind );
	strcpy( pstCmscurprd->ccy, cmscurprd_ccy );
	strpack( pstCmscurprd->ccy );
	strcpy( pstCmscurprd->prdcod, cmscurprd_prdcod );
	strpack( pstCmscurprd->prdcod );
	pstCmscurprd->acctnum = cmscurprd_acctnum ;
}

int pubReadCmscurprd( struct cmscurprd * pstCmscurprd )
{
	pubInitCmscurprd();
	pubStoVCmscurprd(pstCmscurprd);
	EXEC SQL SELECT * INTO RR_CMSCURPRD 
		FROM cmscurprd  
		WHERE  
		 cardkind = :cmscurprd_cardkind and 
		 ccy = :cmscurprd_ccy and 
		 prdcod = :cmscurprd_prdcod  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscurprd",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscurprd(pstCmscurprd);
	return 0; 
} 
 
int pubModiCmscurprd( struct cmscurprd * pstCmscurprd )
{
	pubInitCmscurprd();
	pubStoVCmscurprd(pstCmscurprd);
	EXEC SQL UPDATE cmscurprd 
		SET ( UU_CMSCURPRD ) = ( WW_CMSCURPRD ) 
		WHERE  
		 cardkind = :cmscurprd_cardkind and 
		 ccy = :cmscurprd_ccy and 
		 prdcod = :cmscurprd_prdcod  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscurprd",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmscurprd( struct cmscurprd * pstCmscurprd )
{
	pubInitCmscurprd();
	pubStoVCmscurprd(pstCmscurprd);
	EXEC SQL INSERT INTO cmscurprd VALUES ( RR_CMSCURPRD ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscurprd",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}