tbcms056.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 cmscheckreg_trandate[11];
	short cmscheckreg_trandate_id;
	char cmscheckreg_cardkind[9];
	short cmscheckreg_cardkind_id;
	char cmscheckreg_ccy[4];
	short cmscheckreg_ccy_id;
	char cmscheckreg_trandevtype[3];
	short cmscheckreg_trandevtype_id;
	char cmscheckreg_tottrankind[4];
	short cmscheckreg_tottrankind_id;
	char cmscheckreg_brc[10];
	short cmscheckreg_brc_id;
	char cmscheckreg_brc1[10];
	short cmscheckreg_brc1_id;
	double cmscheckreg_tranamt;
	short cmscheckreg_tranamt_id;
	char cmscheckreg_validf[2];
	short cmscheckreg_validf_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCHECKREG \
		:cmscheckreg_trandate:cmscheckreg_trandate_id, \
		:cmscheckreg_cardkind:cmscheckreg_cardkind_id, \
		:cmscheckreg_ccy:cmscheckreg_ccy_id, \
		:cmscheckreg_trandevtype:cmscheckreg_trandevtype_id, \
		:cmscheckreg_tottrankind:cmscheckreg_tottrankind_id, \
		:cmscheckreg_brc:cmscheckreg_brc_id, \
		:cmscheckreg_brc1:cmscheckreg_brc1_id, \
		:cmscheckreg_tranamt:cmscheckreg_tranamt_id, \
		:cmscheckreg_validf:cmscheckreg_validf_id

#define UU_CMSCHECKREG \
		trandate, \
		cardkind, \
		ccy, \
		trandevtype, \
		tottrankind, \
		brc, \
		brc1, \
		tranamt, \
		validf

#define WW_CMSCHECKREG \
		:cmscheckreg_trandate, \
		:cmscheckreg_cardkind, \
		:cmscheckreg_ccy, \
		:cmscheckreg_trandevtype, \
		:cmscheckreg_tottrankind, \
		:cmscheckreg_brc, \
		:cmscheckreg_brc1, \
		:cmscheckreg_tranamt, \
		:cmscheckreg_validf

struct cmscheckreg
{
	char	trandate[11];
	char	cardkind[9];
	char	ccy[4];
	char	trandevtype[3];
	char	tottrankind[4];
	char	brc[10];
	char	brc1[10];
	double	tranamt;
	char	validf[2];
};

void pubInitCmscheckreg()
{
	memset( cmscheckreg_trandate, 0x00, sizeof( cmscheckreg_trandate ) ) ;
	cmscheckreg_trandate_id = 0 ;
	memset( cmscheckreg_cardkind, 0x00, sizeof( cmscheckreg_cardkind ) ) ;
	cmscheckreg_cardkind_id = 0 ;
	memset( cmscheckreg_ccy, 0x00, sizeof( cmscheckreg_ccy ) ) ;
	cmscheckreg_ccy_id = 0 ;
	memset( cmscheckreg_trandevtype, 0x00, sizeof( cmscheckreg_trandevtype ) ) ;
	cmscheckreg_trandevtype_id = 0 ;
	memset( cmscheckreg_tottrankind, 0x00, sizeof( cmscheckreg_tottrankind ) ) ;
	cmscheckreg_tottrankind_id = 0 ;
	memset( cmscheckreg_brc, 0x00, sizeof( cmscheckreg_brc ) ) ;
	cmscheckreg_brc_id = 0 ;
	memset( cmscheckreg_brc1, 0x00, sizeof( cmscheckreg_brc1 ) ) ;
	cmscheckreg_brc1_id = 0 ;
	memset( &cmscheckreg_tranamt, 0x00, sizeof( cmscheckreg_tranamt ) ) ;
	cmscheckreg_tranamt_id = 0 ;
	memset( cmscheckreg_validf, 0x00, sizeof( cmscheckreg_validf ) ) ;
	cmscheckreg_validf_id = 0 ;
}

void pubStoVCmscheckreg( struct cmscheckreg * pstCmscheckreg )
{
	pubInitCmscheckreg();
	if( !strlen( pstCmscheckreg->trandate ) )
		strcpy( pstCmscheckreg->trandate, " " );
	strcpy( cmscheckreg_trandate, pstCmscheckreg->trandate );
	if( !strlen( pstCmscheckreg->cardkind ) )
		strcpy( pstCmscheckreg->cardkind, " " );
	strcpy( cmscheckreg_cardkind, pstCmscheckreg->cardkind );
	if( !strlen( pstCmscheckreg->ccy ) )
		strcpy( pstCmscheckreg->ccy, " " );
	strcpy( cmscheckreg_ccy, pstCmscheckreg->ccy );
	if( !strlen( pstCmscheckreg->trandevtype ) )
		strcpy( pstCmscheckreg->trandevtype, " " );
	strcpy( cmscheckreg_trandevtype, pstCmscheckreg->trandevtype );
	if( !strlen( pstCmscheckreg->tottrankind ) )
		strcpy( pstCmscheckreg->tottrankind, " " );
	strcpy( cmscheckreg_tottrankind, pstCmscheckreg->tottrankind );
	if( !strlen( pstCmscheckreg->brc ) )
		strcpy( pstCmscheckreg->brc, " " );
	strcpy( cmscheckreg_brc, pstCmscheckreg->brc );
	if( !strlen( pstCmscheckreg->brc1 ) )
		strcpy( pstCmscheckreg->brc1, " " );
	strcpy( cmscheckreg_brc1, pstCmscheckreg->brc1 );
	cmscheckreg_tranamt = pstCmscheckreg->tranamt ;
	pubDround( &cmscheckreg_tranamt, 2 );
	if( !strlen( pstCmscheckreg->validf ) )
		strcpy( pstCmscheckreg->validf, " " );
	strcpy( cmscheckreg_validf, pstCmscheckreg->validf );
}

void pubVtoSCmscheckreg( struct cmscheckreg * pstCmscheckreg )
{
	strcpy( pstCmscheckreg->trandate, cmscheckreg_trandate );
	strpack( pstCmscheckreg->trandate );
	strcpy( pstCmscheckreg->cardkind, cmscheckreg_cardkind );
	strpack( pstCmscheckreg->cardkind );
	strcpy( pstCmscheckreg->ccy, cmscheckreg_ccy );
	strpack( pstCmscheckreg->ccy );
	strcpy( pstCmscheckreg->trandevtype, cmscheckreg_trandevtype );
	strpack( pstCmscheckreg->trandevtype );
	strcpy( pstCmscheckreg->tottrankind, cmscheckreg_tottrankind );
	strpack( pstCmscheckreg->tottrankind );
	strcpy( pstCmscheckreg->brc, cmscheckreg_brc );
	strpack( pstCmscheckreg->brc );
	strcpy( pstCmscheckreg->brc1, cmscheckreg_brc1 );
	strpack( pstCmscheckreg->brc1 );
	pstCmscheckreg->tranamt = cmscheckreg_tranamt ;
	pubDround( &pstCmscheckreg->tranamt, 2 );
	strcpy( pstCmscheckreg->validf, cmscheckreg_validf );
	strpack( pstCmscheckreg->validf );
}



int pubReadCmscheckreg( struct cmscheckreg * pstCmscheckreg )
{
	pubInitCmscheckreg();
	pubStoVCmscheckreg(pstCmscheckreg);
	EXEC SQL SELECT * INTO RR_CMSCHECKREG 
		FROM cmscheckreg  
		WHERE  
		 trandate = :cmscheckreg_trandate and 
		 cardkind = :cmscheckreg_cardkind and 
		 ccy = :cmscheckreg_ccy and 
		 trandevtype = :cmscheckreg_trandevtype and 
		 tottrankind = :cmscheckreg_tottrankind and 
		 brc = :cmscheckreg_brc  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscheckreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscheckreg(pstCmscheckreg);
	return 0; 
} 
 


int pubModiCmscheckreg( struct cmscheckreg * pstCmscheckreg )
{
	pubInitCmscheckreg();
	pubStoVCmscheckreg(pstCmscheckreg);
	EXEC SQL UPDATE cmscheckreg 
		SET ( UU_CMSCHECKREG ) = ( WW_CMSCHECKREG ) 
		WHERE  
		 trandate = :cmscheckreg_trandate and 
		 cardkind = :cmscheckreg_cardkind and 
		 ccy = :cmscheckreg_ccy and 
		 trandevtype = :cmscheckreg_trandevtype and 
		 tottrankind = :cmscheckreg_tottrankind and 
		 brc = :cmscheckreg_brc  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscheckreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmscheckreg( struct cmscheckreg * pstCmscheckreg )
{
	pubInitCmscheckreg();
	pubStoVCmscheckreg(pstCmscheckreg);
	EXEC SQL INSERT INTO cmscheckreg VALUES ( RR_CMSCHECKREG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscheckreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}