tbcms027.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 cmsauthlog_trandate[11];
	short cmsauthlog_trandate_id;
	long cmsauthlog_serseqno;
	short cmsauthlog_serseqno_id;
	char cmsauthlog_trantime[7];
	short cmsauthlog_trantime_id;
	char cmsauthlog_devid[16];
	short cmsauthlog_devid_id;
	char cmsauthlog_devstan[7];
	short cmsauthlog_devstan_id;
	char cmsauthlog_devno[9];
	short cmsauthlog_devno_id;
	char cmsauthlog_mid[16];
	short cmsauthlog_mid_id;
	char cmsauthlog_devteller[11];
	short cmsauthlog_devteller_id;
	char cmsauthlog_devbrc[10];
	short cmsauthlog_devbrc_id;
	char cmsauthlog_cardno[20];
	short cmsauthlog_cardno_id;
	char cmsauthlog_issuebrc[10];
	short cmsauthlog_issuebrc_id;
	char cmsauthlog_acctno[33];
	short cmsauthlog_acctno_id;
	char cmsauthlog_subacct[33];
	short cmsauthlog_subacct_id;
	char cmsauthlog_ccy[4];
	short cmsauthlog_ccy_id;
	double cmsauthlog_tranamt;
	short cmsauthlog_tranamt_id;
	double cmsauthlog_actualamt;
	short cmsauthlog_actualamt_id;
	char cmsauthlog_authno[7];
	short cmsauthlog_authno_id;
	char cmsauthlog_authkind[2];
	short cmsauthlog_authkind_id;
	char cmsauthlog_description[41];
	short cmsauthlog_description_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSAUTHLOG \
		:cmsauthlog_trandate:cmsauthlog_trandate_id, \
		:cmsauthlog_serseqno:cmsauthlog_serseqno_id, \
		:cmsauthlog_trantime:cmsauthlog_trantime_id, \
		:cmsauthlog_devid:cmsauthlog_devid_id, \
		:cmsauthlog_devstan:cmsauthlog_devstan_id, \
		:cmsauthlog_devno:cmsauthlog_devno_id, \
		:cmsauthlog_mid:cmsauthlog_mid_id, \
		:cmsauthlog_devteller:cmsauthlog_devteller_id, \
		:cmsauthlog_devbrc:cmsauthlog_devbrc_id, \
		:cmsauthlog_cardno:cmsauthlog_cardno_id, \
		:cmsauthlog_issuebrc:cmsauthlog_issuebrc_id, \
		:cmsauthlog_acctno:cmsauthlog_acctno_id, \
		:cmsauthlog_subacct:cmsauthlog_subacct_id, \
		:cmsauthlog_ccy:cmsauthlog_ccy_id, \
		:cmsauthlog_tranamt:cmsauthlog_tranamt_id, \
		:cmsauthlog_actualamt:cmsauthlog_actualamt_id, \
		:cmsauthlog_authno:cmsauthlog_authno_id, \
		:cmsauthlog_authkind:cmsauthlog_authkind_id, \
		:cmsauthlog_description:cmsauthlog_description_id

#define UU_CMSAUTHLOG \
		trandate, \
		serseqno, \
		trantime, \
		devid, \
		devstan, \
		devno, \
		mid, \
		devteller, \
		devbrc, \
		cardno, \
		issuebrc, \
		acctno, \
		subacct, \
		ccy, \
		tranamt, \
		actualamt, \
		authno, \
		authkind, \
		description

#define WW_CMSAUTHLOG \
		:cmsauthlog_trandate, \
		:cmsauthlog_serseqno, \
		:cmsauthlog_trantime, \
		:cmsauthlog_devid, \
		:cmsauthlog_devstan, \
		:cmsauthlog_devno, \
		:cmsauthlog_mid, \
		:cmsauthlog_devteller, \
		:cmsauthlog_devbrc, \
		:cmsauthlog_cardno, \
		:cmsauthlog_issuebrc, \
		:cmsauthlog_acctno, \
		:cmsauthlog_subacct, \
		:cmsauthlog_ccy, \
		:cmsauthlog_tranamt, \
		:cmsauthlog_actualamt, \
		:cmsauthlog_authno, \
		:cmsauthlog_authkind, \
		:cmsauthlog_description

struct cmsauthlog
{
	char	trandate[11];
	long	serseqno;
	char	trantime[7];
	char	devid[16];
	char	devstan[7];
	char	devno[9];
	char	mid[16];
	char	devteller[11];
	char	devbrc[10];
	char	cardno[20];
	char	issuebrc[10];
	char	acctno[33];
	char	subacct[33];
	char	ccy[4];
	double	tranamt;
	double	actualamt;
	char	authno[7];
	char	authkind[2];
	char	description[41];
};

void pubInitCmsauthlog()
{
	memset( cmsauthlog_trandate, 0x00, sizeof( cmsauthlog_trandate ) ) ;
	cmsauthlog_trandate_id = 0 ;
	memset( &cmsauthlog_serseqno, 0x00, sizeof( cmsauthlog_serseqno ) ) ;
	cmsauthlog_serseqno_id = 0 ;
	memset( cmsauthlog_trantime, 0x00, sizeof( cmsauthlog_trantime ) ) ;
	cmsauthlog_trantime_id = 0 ;
	memset( cmsauthlog_devid, 0x00, sizeof( cmsauthlog_devid ) ) ;
	cmsauthlog_devid_id = 0 ;
	memset( cmsauthlog_devstan, 0x00, sizeof( cmsauthlog_devstan ) ) ;
	cmsauthlog_devstan_id = 0 ;
	memset( cmsauthlog_devno, 0x00, sizeof( cmsauthlog_devno ) ) ;
	cmsauthlog_devno_id = 0 ;
	memset( cmsauthlog_mid, 0x00, sizeof( cmsauthlog_mid ) ) ;
	cmsauthlog_mid_id = 0 ;
	memset( cmsauthlog_devteller, 0x00, sizeof( cmsauthlog_devteller ) ) ;
	cmsauthlog_devteller_id = 0 ;
	memset( cmsauthlog_devbrc, 0x00, sizeof( cmsauthlog_devbrc ) ) ;
	cmsauthlog_devbrc_id = 0 ;
	memset( cmsauthlog_cardno, 0x00, sizeof( cmsauthlog_cardno ) ) ;
	cmsauthlog_cardno_id = 0 ;
	memset( cmsauthlog_issuebrc, 0x00, sizeof( cmsauthlog_issuebrc ) ) ;
	cmsauthlog_issuebrc_id = 0 ;
	memset( cmsauthlog_acctno, 0x00, sizeof( cmsauthlog_acctno ) ) ;
	cmsauthlog_acctno_id = 0 ;
	memset( cmsauthlog_subacct, 0x00, sizeof( cmsauthlog_subacct ) ) ;
	cmsauthlog_subacct_id = 0 ;
	memset( cmsauthlog_ccy, 0x00, sizeof( cmsauthlog_ccy ) ) ;
	cmsauthlog_ccy_id = 0 ;
	memset( &cmsauthlog_tranamt, 0x00, sizeof( cmsauthlog_tranamt ) ) ;
	cmsauthlog_tranamt_id = 0 ;
	memset( &cmsauthlog_actualamt, 0x00, sizeof( cmsauthlog_actualamt ) ) ;
	cmsauthlog_actualamt_id = 0 ;
	memset( cmsauthlog_authno, 0x00, sizeof( cmsauthlog_authno ) ) ;
	cmsauthlog_authno_id = 0 ;
	memset( cmsauthlog_authkind, 0x00, sizeof( cmsauthlog_authkind ) ) ;
	cmsauthlog_authkind_id = 0 ;
	memset( cmsauthlog_description, 0x00, sizeof( cmsauthlog_description ) ) ;
	cmsauthlog_description_id = 0 ;
}

void pubStoVCmsauthlog( struct cmsauthlog * pstCmsauthlog )
{
	pubInitCmsauthlog();
	if( !strlen( pstCmsauthlog->trandate ) )
		strcpy( pstCmsauthlog->trandate, " " );
	strcpy( cmsauthlog_trandate, pstCmsauthlog->trandate );
	cmsauthlog_serseqno = pstCmsauthlog->serseqno ;
	if( !strlen( pstCmsauthlog->trantime ) )
		strcpy( pstCmsauthlog->trantime, " " );
	strcpy( cmsauthlog_trantime, pstCmsauthlog->trantime );
	if( !strlen( pstCmsauthlog->devid ) )
		strcpy( pstCmsauthlog->devid, " " );
	strcpy( cmsauthlog_devid, pstCmsauthlog->devid );
	if( !strlen( pstCmsauthlog->devstan ) )
		strcpy( pstCmsauthlog->devstan, " " );
	strcpy( cmsauthlog_devstan, pstCmsauthlog->devstan );
	if( !strlen( pstCmsauthlog->devno ) )
		strcpy( pstCmsauthlog->devno, " " );
	strcpy( cmsauthlog_devno, pstCmsauthlog->devno );
	if( !strlen( pstCmsauthlog->mid ) )
		strcpy( pstCmsauthlog->mid, " " );
	strcpy( cmsauthlog_mid, pstCmsauthlog->mid );
	if( !strlen( pstCmsauthlog->devteller ) )
		strcpy( pstCmsauthlog->devteller, " " );
	strcpy( cmsauthlog_devteller, pstCmsauthlog->devteller );
	if( !strlen( pstCmsauthlog->devbrc ) )
		strcpy( pstCmsauthlog->devbrc, " " );
	strcpy( cmsauthlog_devbrc, pstCmsauthlog->devbrc );
	if( !strlen( pstCmsauthlog->cardno ) )
		strcpy( pstCmsauthlog->cardno, " " );
	strcpy( cmsauthlog_cardno, pstCmsauthlog->cardno );
	if( !strlen( pstCmsauthlog->issuebrc ) )
		strcpy( pstCmsauthlog->issuebrc, " " );
	strcpy( cmsauthlog_issuebrc, pstCmsauthlog->issuebrc );
	if( !strlen( pstCmsauthlog->acctno ) )
		strcpy( pstCmsauthlog->acctno, " " );
	strcpy( cmsauthlog_acctno, pstCmsauthlog->acctno );
	if( !strlen( pstCmsauthlog->subacct ) )
		strcpy( pstCmsauthlog->subacct, " " );
	strcpy( cmsauthlog_subacct, pstCmsauthlog->subacct );
	if( !strlen( pstCmsauthlog->ccy ) )
		strcpy( pstCmsauthlog->ccy, " " );
	strcpy( cmsauthlog_ccy, pstCmsauthlog->ccy );
	cmsauthlog_tranamt = pstCmsauthlog->tranamt ;
	pubDround( &cmsauthlog_tranamt, 2 );
	cmsauthlog_actualamt = pstCmsauthlog->actualamt ;
	pubDround( &cmsauthlog_actualamt, 2 );
	if( !strlen( pstCmsauthlog->authno ) )
		strcpy( pstCmsauthlog->authno, " " );
	strcpy( cmsauthlog_authno, pstCmsauthlog->authno );
	if( !strlen( pstCmsauthlog->authkind ) )
		strcpy( pstCmsauthlog->authkind, " " );
	strcpy( cmsauthlog_authkind, pstCmsauthlog->authkind );
	if( !strlen( pstCmsauthlog->description ) )
		strcpy( pstCmsauthlog->description, " " );
	strcpy( cmsauthlog_description, pstCmsauthlog->description );
}

void pubVtoSCmsauthlog( struct cmsauthlog * pstCmsauthlog )
{
	strcpy( pstCmsauthlog->trandate, cmsauthlog_trandate );
	strpack( pstCmsauthlog->trandate );
	pstCmsauthlog->serseqno = cmsauthlog_serseqno ;
	strcpy( pstCmsauthlog->trantime, cmsauthlog_trantime );
	strpack( pstCmsauthlog->trantime );
	strcpy( pstCmsauthlog->devid, cmsauthlog_devid );
	strpack( pstCmsauthlog->devid );
	strcpy( pstCmsauthlog->devstan, cmsauthlog_devstan );
	strpack( pstCmsauthlog->devstan );
	strcpy( pstCmsauthlog->devno, cmsauthlog_devno );
	strpack( pstCmsauthlog->devno );
	strcpy( pstCmsauthlog->mid, cmsauthlog_mid );
	strpack( pstCmsauthlog->mid );
	strcpy( pstCmsauthlog->devteller, cmsauthlog_devteller );
	strpack( pstCmsauthlog->devteller );
	strcpy( pstCmsauthlog->devbrc, cmsauthlog_devbrc );
	strpack( pstCmsauthlog->devbrc );
	strcpy( pstCmsauthlog->cardno, cmsauthlog_cardno );
	strpack( pstCmsauthlog->cardno );
	strcpy( pstCmsauthlog->issuebrc, cmsauthlog_issuebrc );
	strpack( pstCmsauthlog->issuebrc );
	strcpy( pstCmsauthlog->acctno, cmsauthlog_acctno );
	strpack( pstCmsauthlog->acctno );
	strcpy( pstCmsauthlog->subacct, cmsauthlog_subacct );
	strpack( pstCmsauthlog->subacct );
	strcpy( pstCmsauthlog->ccy, cmsauthlog_ccy );
	strpack( pstCmsauthlog->ccy );
	pstCmsauthlog->tranamt = cmsauthlog_tranamt ;
	pubDround( &pstCmsauthlog->tranamt, 2 );
	pstCmsauthlog->actualamt = cmsauthlog_actualamt ;
	pubDround( &pstCmsauthlog->actualamt, 2 );
	strcpy( pstCmsauthlog->authno, cmsauthlog_authno );
	strpack( pstCmsauthlog->authno );
	strcpy( pstCmsauthlog->authkind, cmsauthlog_authkind );
	strpack( pstCmsauthlog->authkind );
	strcpy( pstCmsauthlog->description, cmsauthlog_description );
	strpack( pstCmsauthlog->description );
}

int pubReadCmsauthlog( struct cmsauthlog * pstCmsauthlog )
{
	pubInitCmsauthlog();
	pubStoVCmsauthlog(pstCmsauthlog);
	EXEC SQL SELECT * INTO RR_CMSAUTHLOG 
		FROM cmsauthlog  
		WHERE  
		 cardno = :cmsauthlog_cardno and 
		 authno = :cmsauthlog_authno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsauthlog",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsauthlog(pstCmsauthlog);
	return 0; 
} 
 
int pubModiCmsauthlog( struct cmsauthlog * pstCmsauthlog )
{
	pubInitCmsauthlog();
	pubStoVCmsauthlog(pstCmsauthlog);
	EXEC SQL UPDATE cmsauthlog 
		SET ( UU_CMSAUTHLOG ) = ( WW_CMSAUTHLOG ) 
		WHERE  
		 cardno = :cmsauthlog_cardno and 
		 authno = :cmsauthlog_authno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsauthlog",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsauthlog( struct cmsauthlog * pstCmsauthlog )
{
	pubInitCmsauthlog();
	pubStoVCmsauthlog(pstCmsauthlog);
	EXEC SQL INSERT INTO cmsauthlog VALUES ( RR_CMSAUTHLOG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsauthlog",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}