tbcms034.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 cmsfeenote_brc[10];
	short cmsfeenote_brc_id;
	char cmsfeenote_trandate[11];
	short cmsfeenote_trandate_id;
	long cmsfeenote_serseqno;
	short cmsfeenote_serseqno_id;
	char cmsfeenote_settledate[11];
	short cmsfeenote_settledate_id;
	char cmsfeenote_feecharacter[2];
	short cmsfeenote_feecharacter_id;
	char cmsfeenote_crdbcharacter[2];
	short cmsfeenote_crdbcharacter_id;
	char cmsfeenote_cardno[20];
	short cmsfeenote_cardno_id;
	double cmsfeenote_amount;
	short cmsfeenote_amount_id;
	char cmsfeenote_devtransdatetime[11];
	short cmsfeenote_devtransdatetime_id;
	char cmsfeenote_srvstan[7];
	short cmsfeenote_srvstan_id;
	char cmsfeenote_acqins[12];
	short cmsfeenote_acqins_id;
	char cmsfeenote_forwins[12];
	short cmsfeenote_forwins_id;
	char cmsfeenote_reason[256];
	short cmsfeenote_reason_id;
	char cmsfeenote_reasoncode[7];
	short cmsfeenote_reasoncode_id;
	char cmsfeenote_ccy[4];
	short cmsfeenote_ccy_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSFEENOTE \
		:cmsfeenote_brc:cmsfeenote_brc_id, \
		:cmsfeenote_trandate:cmsfeenote_trandate_id, \
		:cmsfeenote_serseqno:cmsfeenote_serseqno_id, \
		:cmsfeenote_settledate:cmsfeenote_settledate_id, \
		:cmsfeenote_feecharacter:cmsfeenote_feecharacter_id, \
		:cmsfeenote_crdbcharacter:cmsfeenote_crdbcharacter_id, \
		:cmsfeenote_cardno:cmsfeenote_cardno_id, \
		:cmsfeenote_amount:cmsfeenote_amount_id, \
		:cmsfeenote_devtransdatetime:cmsfeenote_devtransdatetime_id, \
		:cmsfeenote_srvstan:cmsfeenote_srvstan_id, \
		:cmsfeenote_acqins:cmsfeenote_acqins_id, \
		:cmsfeenote_forwins:cmsfeenote_forwins_id, \
		:cmsfeenote_reason:cmsfeenote_reason_id, \
		:cmsfeenote_reasoncode:cmsfeenote_reasoncode_id, \
		:cmsfeenote_ccy:cmsfeenote_ccy_id

#define UU_CMSFEENOTE \
		brc, \
		trandate, \
		serseqno, \
		settledate, \
		feecharacter, \
		crdbcharacter, \
		cardno, \
		amount, \
		devtransdatetime, \
		srvstan, \
		acqins, \
		forwins, \
		reason, \
		reasoncode, \
		ccy

#define WW_CMSFEENOTE \
		:cmsfeenote_brc, \
		:cmsfeenote_trandate, \
		:cmsfeenote_serseqno, \
		:cmsfeenote_settledate, \
		:cmsfeenote_feecharacter, \
		:cmsfeenote_crdbcharacter, \
		:cmsfeenote_cardno, \
		:cmsfeenote_amount, \
		:cmsfeenote_devtransdatetime, \
		:cmsfeenote_srvstan, \
		:cmsfeenote_acqins, \
		:cmsfeenote_forwins, \
		:cmsfeenote_reason, \
		:cmsfeenote_reasoncode, \
		:cmsfeenote_ccy

struct cmsfeenote
{
	char	brc[10];
	char	trandate[11];
	long	serseqno;
	char	settledate[11];
	char	feecharacter[2];
	char	crdbcharacter[2];
	char	cardno[20];
	double	amount;
	char	devtransdatetime[11];
	char	srvstan[7];
	char	acqins[12];
	char	forwins[12];
	char	reason[256];
	char	reasoncode[7];
	char	ccy[4];
};

void pubInitCmsfeenote()
{
	memset( cmsfeenote_brc, 0x00, sizeof( cmsfeenote_brc ) ) ;
	cmsfeenote_brc_id = 0 ;
	memset( cmsfeenote_trandate, 0x00, sizeof( cmsfeenote_trandate ) ) ;
	cmsfeenote_trandate_id = 0 ;
	memset( &cmsfeenote_serseqno, 0x00, sizeof( cmsfeenote_serseqno ) ) ;
	cmsfeenote_serseqno_id = 0 ;
	memset( cmsfeenote_settledate, 0x00, sizeof( cmsfeenote_settledate ) ) ;
	cmsfeenote_settledate_id = 0 ;
	memset( cmsfeenote_feecharacter, 0x00, sizeof( cmsfeenote_feecharacter ) ) ;
	cmsfeenote_feecharacter_id = 0 ;
	memset( cmsfeenote_crdbcharacter, 0x00, sizeof( cmsfeenote_crdbcharacter ) ) ;
	cmsfeenote_crdbcharacter_id = 0 ;
	memset( cmsfeenote_cardno, 0x00, sizeof( cmsfeenote_cardno ) ) ;
	cmsfeenote_cardno_id = 0 ;
	memset( &cmsfeenote_amount, 0x00, sizeof( cmsfeenote_amount ) ) ;
	cmsfeenote_amount_id = 0 ;
	memset( cmsfeenote_devtransdatetime, 0x00, sizeof( cmsfeenote_devtransdatetime ) ) ;
	cmsfeenote_devtransdatetime_id = 0 ;
	memset( cmsfeenote_srvstan, 0x00, sizeof( cmsfeenote_srvstan ) ) ;
	cmsfeenote_srvstan_id = 0 ;
	memset( cmsfeenote_acqins, 0x00, sizeof( cmsfeenote_acqins ) ) ;
	cmsfeenote_acqins_id = 0 ;
	memset( cmsfeenote_forwins, 0x00, sizeof( cmsfeenote_forwins ) ) ;
	cmsfeenote_forwins_id = 0 ;
	memset( cmsfeenote_reason, 0x00, sizeof( cmsfeenote_reason ) ) ;
	cmsfeenote_reason_id = 0 ;
	memset( cmsfeenote_reasoncode, 0x00, sizeof( cmsfeenote_reasoncode ) ) ;
	cmsfeenote_reasoncode_id = 0 ;
	memset( cmsfeenote_ccy, 0x00, sizeof( cmsfeenote_ccy ) ) ;
	cmsfeenote_ccy_id = 0 ;
}

void pubStoVCmsfeenote( struct cmsfeenote * pstCmsfeenote )
{
	pubInitCmsfeenote();
	if( !strlen( pstCmsfeenote->brc ) )
		strcpy( pstCmsfeenote->brc, " " );
	strcpy( cmsfeenote_brc, pstCmsfeenote->brc );
	if( !strlen( pstCmsfeenote->trandate ) )
		strcpy( pstCmsfeenote->trandate, " " );
	strcpy( cmsfeenote_trandate, pstCmsfeenote->trandate );
	cmsfeenote_serseqno = pstCmsfeenote->serseqno ;
	if( !strlen( pstCmsfeenote->settledate ) )
		strcpy( pstCmsfeenote->settledate, " " );
	strcpy( cmsfeenote_settledate, pstCmsfeenote->settledate );
	if( !strlen( pstCmsfeenote->feecharacter ) )
		strcpy( pstCmsfeenote->feecharacter, " " );
	strcpy( cmsfeenote_feecharacter, pstCmsfeenote->feecharacter );
	if( !strlen( pstCmsfeenote->crdbcharacter ) )
		strcpy( pstCmsfeenote->crdbcharacter, " " );
	strcpy( cmsfeenote_crdbcharacter, pstCmsfeenote->crdbcharacter );
	if( !strlen( pstCmsfeenote->cardno ) )
		strcpy( pstCmsfeenote->cardno, " " );
	strcpy( cmsfeenote_cardno, pstCmsfeenote->cardno );
	cmsfeenote_amount = pstCmsfeenote->amount ;
	pubDround( &cmsfeenote_amount, 2 );
	if( !strlen( pstCmsfeenote->devtransdatetime ) )
		strcpy( pstCmsfeenote->devtransdatetime, " " );
	strcpy( cmsfeenote_devtransdatetime, pstCmsfeenote->devtransdatetime );
	if( !strlen( pstCmsfeenote->srvstan ) )
		strcpy( pstCmsfeenote->srvstan, " " );
	strcpy( cmsfeenote_srvstan, pstCmsfeenote->srvstan );
	if( !strlen( pstCmsfeenote->acqins ) )
		strcpy( pstCmsfeenote->acqins, " " );
	strcpy( cmsfeenote_acqins, pstCmsfeenote->acqins );
	if( !strlen( pstCmsfeenote->forwins ) )
		strcpy( pstCmsfeenote->forwins, " " );
	strcpy( cmsfeenote_forwins, pstCmsfeenote->forwins );
	if( !strlen( pstCmsfeenote->reason ) )
		strcpy( pstCmsfeenote->reason, " " );
	strcpy( cmsfeenote_reason, pstCmsfeenote->reason );
	if( !strlen( pstCmsfeenote->reasoncode ) )
		strcpy( pstCmsfeenote->reasoncode, " " );
	strcpy( cmsfeenote_reasoncode, pstCmsfeenote->reasoncode );
	if( !strlen( pstCmsfeenote->ccy ) )
		strcpy( pstCmsfeenote->ccy, " " );
	strcpy( cmsfeenote_ccy, pstCmsfeenote->ccy );
}

void pubVtoSCmsfeenote( struct cmsfeenote * pstCmsfeenote )
{
	strcpy( pstCmsfeenote->brc, cmsfeenote_brc );
	strpack( pstCmsfeenote->brc );
	strcpy( pstCmsfeenote->trandate, cmsfeenote_trandate );
	strpack( pstCmsfeenote->trandate );
	pstCmsfeenote->serseqno = cmsfeenote_serseqno ;
	strcpy( pstCmsfeenote->settledate, cmsfeenote_settledate );
	strpack( pstCmsfeenote->settledate );
	strcpy( pstCmsfeenote->feecharacter, cmsfeenote_feecharacter );
	strpack( pstCmsfeenote->feecharacter );
	strcpy( pstCmsfeenote->crdbcharacter, cmsfeenote_crdbcharacter );
	strpack( pstCmsfeenote->crdbcharacter );
	strcpy( pstCmsfeenote->cardno, cmsfeenote_cardno );
	strpack( pstCmsfeenote->cardno );
	pstCmsfeenote->amount = cmsfeenote_amount ;
	pubDround( &pstCmsfeenote->amount, 2 );
	strcpy( pstCmsfeenote->devtransdatetime, cmsfeenote_devtransdatetime );
	strpack( pstCmsfeenote->devtransdatetime );
	strcpy( pstCmsfeenote->srvstan, cmsfeenote_srvstan );
	strpack( pstCmsfeenote->srvstan );
	strcpy( pstCmsfeenote->acqins, cmsfeenote_acqins );
	strpack( pstCmsfeenote->acqins );
	strcpy( pstCmsfeenote->forwins, cmsfeenote_forwins );
	strpack( pstCmsfeenote->forwins );
	strcpy( pstCmsfeenote->reason, cmsfeenote_reason );
	strpack( pstCmsfeenote->reason );
	strcpy( pstCmsfeenote->reasoncode, cmsfeenote_reasoncode );
	strpack( pstCmsfeenote->reasoncode );
	strcpy( pstCmsfeenote->ccy, cmsfeenote_ccy );
	strpack( pstCmsfeenote->ccy );
}

int pubReadCmsfeenote( struct cmsfeenote * pstCmsfeenote )
{
	pubInitCmsfeenote();
	pubStoVCmsfeenote(pstCmsfeenote);
	EXEC SQL SELECT * INTO RR_CMSFEENOTE 
		FROM cmsfeenote  
		WHERE  
		 brc = :cmsfeenote_brc and 
		 trandate = :cmsfeenote_trandate and 
		 serseqno = :cmsfeenote_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsfeenote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsfeenote(pstCmsfeenote);
	return 0; 
} 
 
int pubModiCmsfeenote( struct cmsfeenote * pstCmsfeenote )
{
	pubInitCmsfeenote();
	pubStoVCmsfeenote(pstCmsfeenote);
	EXEC SQL UPDATE cmsfeenote 
		SET ( UU_CMSFEENOTE ) = ( WW_CMSFEENOTE ) 
		WHERE  
		 brc = :cmsfeenote_brc and 
		 trandate = :cmsfeenote_trandate and 
		 serseqno = :cmsfeenote_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsfeenote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsfeenote( struct cmsfeenote * pstCmsfeenote )
{
	pubInitCmsfeenote();
	pubStoVCmsfeenote(pstCmsfeenote);
	EXEC SQL INSERT INTO cmsfeenote VALUES ( RR_CMSFEENOTE ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsfeenote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}