tbcms033.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 cmsejectnote_brc[10];
	short cmsejectnote_brc_id;
	char cmsejectnote_trandate[11];
	short cmsejectnote_trandate_id;
	long cmsejectnote_serseqno;
	short cmsejectnote_serseqno_id;
	char cmsejectnote_settledate[11];
	short cmsejectnote_settledate_id;
	double cmsejectnote_ejectamt;
	short cmsejectnote_ejectamt_id;
	char cmsejectnote_cardno[20];
	short cmsejectnote_cardno_id;
	char cmsejectnote_devtransdatetime[11];
	short cmsejectnote_devtransdatetime_id;
	char cmsejectnote_srvstan[7];
	short cmsejectnote_srvstan_id;
	char cmsejectnote_acqins[12];
	short cmsejectnote_acqins_id;
	char cmsejectnote_forwins[12];
	short cmsejectnote_forwins_id;
	char cmsejectnote_mid[16];
	short cmsejectnote_mid_id;
	char cmsejectnote_devid[16];
	short cmsejectnote_devid_id;
	char cmsejectnote_ccy[4];
	short cmsejectnote_ccy_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSEJECTNOTE \
		:cmsejectnote_brc:cmsejectnote_brc_id, \
		:cmsejectnote_trandate:cmsejectnote_trandate_id, \
		:cmsejectnote_serseqno:cmsejectnote_serseqno_id, \
		:cmsejectnote_settledate:cmsejectnote_settledate_id, \
		:cmsejectnote_ejectamt:cmsejectnote_ejectamt_id, \
		:cmsejectnote_cardno:cmsejectnote_cardno_id, \
		:cmsejectnote_devtransdatetime:cmsejectnote_devtransdatetime_id, \
		:cmsejectnote_srvstan:cmsejectnote_srvstan_id, \
		:cmsejectnote_acqins:cmsejectnote_acqins_id, \
		:cmsejectnote_forwins:cmsejectnote_forwins_id, \
		:cmsejectnote_mid:cmsejectnote_mid_id, \
		:cmsejectnote_devid:cmsejectnote_devid_id, \
		:cmsejectnote_ccy:cmsejectnote_ccy_id

#define UU_CMSEJECTNOTE \
		brc, \
		trandate, \
		serseqno, \
		settledate, \
		ejectamt, \
		cardno, \
		devtransdatetime, \
		srvstan, \
		acqins, \
		forwins, \
		mid, \
		devid, \
		ccy

#define WW_CMSEJECTNOTE \
		:cmsejectnote_brc, \
		:cmsejectnote_trandate, \
		:cmsejectnote_serseqno, \
		:cmsejectnote_settledate, \
		:cmsejectnote_ejectamt, \
		:cmsejectnote_cardno, \
		:cmsejectnote_devtransdatetime, \
		:cmsejectnote_srvstan, \
		:cmsejectnote_acqins, \
		:cmsejectnote_forwins, \
		:cmsejectnote_mid, \
		:cmsejectnote_devid, \
		:cmsejectnote_ccy

struct cmsejectnote
{
	char	brc[10];
	char	trandate[11];
	long	serseqno;
	char	settledate[11];
	double	ejectamt;
	char	cardno[20];
	char	devtransdatetime[11];
	char	srvstan[7];
	char	acqins[12];
	char	forwins[12];
	char	mid[16];
	char	devid[16];
	char	ccy[4];
};

void pubInitCmsejectnote()
{
	memset( cmsejectnote_brc, 0x00, sizeof( cmsejectnote_brc ) ) ;
	cmsejectnote_brc_id = 0 ;
	memset( cmsejectnote_trandate, 0x00, sizeof( cmsejectnote_trandate ) ) ;
	cmsejectnote_trandate_id = 0 ;
	memset( &cmsejectnote_serseqno, 0x00, sizeof( cmsejectnote_serseqno ) ) ;
	cmsejectnote_serseqno_id = 0 ;
	memset( cmsejectnote_settledate, 0x00, sizeof( cmsejectnote_settledate ) ) ;
	cmsejectnote_settledate_id = 0 ;
	memset( &cmsejectnote_ejectamt, 0x00, sizeof( cmsejectnote_ejectamt ) ) ;
	cmsejectnote_ejectamt_id = 0 ;
	memset( cmsejectnote_cardno, 0x00, sizeof( cmsejectnote_cardno ) ) ;
	cmsejectnote_cardno_id = 0 ;
	memset( cmsejectnote_devtransdatetime, 0x00, sizeof( cmsejectnote_devtransdatetime ) ) ;
	cmsejectnote_devtransdatetime_id = 0 ;
	memset( cmsejectnote_srvstan, 0x00, sizeof( cmsejectnote_srvstan ) ) ;
	cmsejectnote_srvstan_id = 0 ;
	memset( cmsejectnote_acqins, 0x00, sizeof( cmsejectnote_acqins ) ) ;
	cmsejectnote_acqins_id = 0 ;
	memset( cmsejectnote_forwins, 0x00, sizeof( cmsejectnote_forwins ) ) ;
	cmsejectnote_forwins_id = 0 ;
	memset( cmsejectnote_mid, 0x00, sizeof( cmsejectnote_mid ) ) ;
	cmsejectnote_mid_id = 0 ;
	memset( cmsejectnote_devid, 0x00, sizeof( cmsejectnote_devid ) ) ;
	cmsejectnote_devid_id = 0 ;
	memset( cmsejectnote_ccy, 0x00, sizeof( cmsejectnote_ccy ) ) ;
	cmsejectnote_ccy_id = 0 ;
}

void pubStoVCmsejectnote( struct cmsejectnote * pstCmsejectnote )
{
	pubInitCmsejectnote();
	if( !strlen( pstCmsejectnote->brc ) )
		strcpy( pstCmsejectnote->brc, " " );
	strcpy( cmsejectnote_brc, pstCmsejectnote->brc );
	if( !strlen( pstCmsejectnote->trandate ) )
		strcpy( pstCmsejectnote->trandate, " " );
	strcpy( cmsejectnote_trandate, pstCmsejectnote->trandate );
	cmsejectnote_serseqno = pstCmsejectnote->serseqno ;
	if( !strlen( pstCmsejectnote->settledate ) )
		strcpy( pstCmsejectnote->settledate, " " );
	strcpy( cmsejectnote_settledate, pstCmsejectnote->settledate );
	cmsejectnote_ejectamt = pstCmsejectnote->ejectamt ;
	pubDround( &cmsejectnote_ejectamt, 2 );
	if( !strlen( pstCmsejectnote->cardno ) )
		strcpy( pstCmsejectnote->cardno, " " );
	strcpy( cmsejectnote_cardno, pstCmsejectnote->cardno );
	if( !strlen( pstCmsejectnote->devtransdatetime ) )
		strcpy( pstCmsejectnote->devtransdatetime, " " );
	strcpy( cmsejectnote_devtransdatetime, pstCmsejectnote->devtransdatetime );
	if( !strlen( pstCmsejectnote->srvstan ) )
		strcpy( pstCmsejectnote->srvstan, " " );
	strcpy( cmsejectnote_srvstan, pstCmsejectnote->srvstan );
	if( !strlen( pstCmsejectnote->acqins ) )
		strcpy( pstCmsejectnote->acqins, " " );
	strcpy( cmsejectnote_acqins, pstCmsejectnote->acqins );
	if( !strlen( pstCmsejectnote->forwins ) )
		strcpy( pstCmsejectnote->forwins, " " );
	strcpy( cmsejectnote_forwins, pstCmsejectnote->forwins );
	if( !strlen( pstCmsejectnote->mid ) )
		strcpy( pstCmsejectnote->mid, " " );
	strcpy( cmsejectnote_mid, pstCmsejectnote->mid );
	if( !strlen( pstCmsejectnote->devid ) )
		strcpy( pstCmsejectnote->devid, " " );
	strcpy( cmsejectnote_devid, pstCmsejectnote->devid );
	if( !strlen( pstCmsejectnote->ccy ) )
		strcpy( pstCmsejectnote->ccy, " " );
	strcpy( cmsejectnote_ccy, pstCmsejectnote->ccy );
}

void pubVtoSCmsejectnote( struct cmsejectnote * pstCmsejectnote )
{
	strcpy( pstCmsejectnote->brc, cmsejectnote_brc );
	strpack( pstCmsejectnote->brc );
	strcpy( pstCmsejectnote->trandate, cmsejectnote_trandate );
	strpack( pstCmsejectnote->trandate );
	pstCmsejectnote->serseqno = cmsejectnote_serseqno ;
	strcpy( pstCmsejectnote->settledate, cmsejectnote_settledate );
	strpack( pstCmsejectnote->settledate );
	pstCmsejectnote->ejectamt = cmsejectnote_ejectamt ;
	pubDround( &pstCmsejectnote->ejectamt, 2 );
	strcpy( pstCmsejectnote->cardno, cmsejectnote_cardno );
	strpack( pstCmsejectnote->cardno );
	strcpy( pstCmsejectnote->devtransdatetime, cmsejectnote_devtransdatetime );
	strpack( pstCmsejectnote->devtransdatetime );
	strcpy( pstCmsejectnote->srvstan, cmsejectnote_srvstan );
	strpack( pstCmsejectnote->srvstan );
	strcpy( pstCmsejectnote->acqins, cmsejectnote_acqins );
	strpack( pstCmsejectnote->acqins );
	strcpy( pstCmsejectnote->forwins, cmsejectnote_forwins );
	strpack( pstCmsejectnote->forwins );
	strcpy( pstCmsejectnote->mid, cmsejectnote_mid );
	strpack( pstCmsejectnote->mid );
	strcpy( pstCmsejectnote->devid, cmsejectnote_devid );
	strpack( pstCmsejectnote->devid );
	strcpy( pstCmsejectnote->ccy, cmsejectnote_ccy );
	strpack( pstCmsejectnote->ccy );
}

int pubReadCmsejectnote( struct cmsejectnote * pstCmsejectnote )
{
	pubInitCmsejectnote();
	pubStoVCmsejectnote(pstCmsejectnote);
	EXEC SQL SELECT * INTO RR_CMSEJECTNOTE 
		FROM cmsejectnote  
		WHERE  
		 brc = :cmsejectnote_brc and 
		 trandate = :cmsejectnote_trandate and 
		 serseqno = :cmsejectnote_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsejectnote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsejectnote(pstCmsejectnote);
	return 0; 
} 
 
int pubModiCmsejectnote( struct cmsejectnote * pstCmsejectnote )
{
	pubInitCmsejectnote();
	pubStoVCmsejectnote(pstCmsejectnote);
	EXEC SQL UPDATE cmsejectnote 
		SET ( UU_CMSEJECTNOTE ) = ( WW_CMSEJECTNOTE ) 
		WHERE  
		 brc = :cmsejectnote_brc and 
		 trandate = :cmsejectnote_trandate and 
		 serseqno = :cmsejectnote_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsejectnote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsejectnote( struct cmsejectnote * pstCmsejectnote )
{
	pubInitCmsejectnote();
	pubStoVCmsejectnote(pstCmsejectnote);
	EXEC SQL INSERT INTO cmsejectnote VALUES ( RR_CMSEJECTNOTE ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsejectnote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}