tbcms047.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 cmstellerlog_trandate[11];
	short cmstellerlog_trandate_id;
	long cmstellerlog_serseqno;
	short cmstellerlog_serseqno_id;
	char cmstellerlog_channelid[3];
	short cmstellerlog_channelid_id;
	long cmstellerlog_termseq;
	short cmstellerlog_termseq_id;
	char cmstellerlog_trancode[7];
	short cmstellerlog_trancode_id;
	char cmstellerlog_tranname[41];
	short cmstellerlog_tranname_id;
	char cmstellerlog_brccode[10];
	short cmstellerlog_brccode_id;
	char cmstellerlog_teller[7];
	short cmstellerlog_teller_id;
	char cmstellerlog_ateller[7];
	short cmstellerlog_ateller_id;
	char cmstellerlog_trantime[27];
	short cmstellerlog_trantime_id;
	char cmstellerlog_rteller[7];
	short cmstellerlog_rteller_id;
	char cmstellerlog_checktime[27];
	short cmstellerlog_checktime_id;
	char cmstellerlog_canceltime[27];
	short cmstellerlog_canceltime_id;
	double cmstellerlog_amt1;
	short cmstellerlog_amt1_id;
	double cmstellerlog_amt2;
	short cmstellerlog_amt2_id;
	char cmstellerlog_flag1[2];
	short cmstellerlog_flag1_id;
	char cmstellerlog_flag2[2];
	short cmstellerlog_flag2_id;
	char cmstellerlog_memo[41];
	short cmstellerlog_memo_id;
	char cmstellerlog_rspcode[9];
	short cmstellerlog_rspcode_id;
	char cmstellerlog_desc[81];
	short cmstellerlog_desc_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTELLERLOG \
		:cmstellerlog_trandate:cmstellerlog_trandate_id, \
		:cmstellerlog_serseqno:cmstellerlog_serseqno_id, \
		:cmstellerlog_channelid:cmstellerlog_channelid_id, \
		:cmstellerlog_termseq:cmstellerlog_termseq_id, \
		:cmstellerlog_trancode:cmstellerlog_trancode_id, \
		:cmstellerlog_tranname:cmstellerlog_tranname_id, \
		:cmstellerlog_brccode:cmstellerlog_brccode_id, \
		:cmstellerlog_teller:cmstellerlog_teller_id, \
		:cmstellerlog_ateller:cmstellerlog_ateller_id, \
		:cmstellerlog_trantime:cmstellerlog_trantime_id, \
		:cmstellerlog_rteller:cmstellerlog_rteller_id, \
		:cmstellerlog_checktime:cmstellerlog_checktime_id, \
		:cmstellerlog_canceltime:cmstellerlog_canceltime_id, \
		:cmstellerlog_amt1:cmstellerlog_amt1_id, \
		:cmstellerlog_amt2:cmstellerlog_amt2_id, \
		:cmstellerlog_flag1:cmstellerlog_flag1_id, \
		:cmstellerlog_flag2:cmstellerlog_flag2_id, \
		:cmstellerlog_memo:cmstellerlog_memo_id, \
		:cmstellerlog_rspcode:cmstellerlog_rspcode_id, \
		:cmstellerlog_desc:cmstellerlog_desc_id

#define UU_CMSTELLERLOG \
		trandate, \
		serseqno, \
		channelid, \
		termseq, \
		trancode, \
		tranname, \
		brccode, \
		teller, \
		ateller, \
		trantime, \
		rteller, \
		checktime, \
		canceltime, \
		amt1, \
		amt2, \
		flag1, \
		flag2, \
		memo, \
		rspcode, \
		desc

#define WW_CMSTELLERLOG \
		:cmstellerlog_trandate, \
		:cmstellerlog_serseqno, \
		:cmstellerlog_channelid, \
		:cmstellerlog_termseq, \
		:cmstellerlog_trancode, \
		:cmstellerlog_tranname, \
		:cmstellerlog_brccode, \
		:cmstellerlog_teller, \
		:cmstellerlog_ateller, \
		:cmstellerlog_trantime, \
		:cmstellerlog_rteller, \
		:cmstellerlog_checktime, \
		:cmstellerlog_canceltime, \
		:cmstellerlog_amt1, \
		:cmstellerlog_amt2, \
		:cmstellerlog_flag1, \
		:cmstellerlog_flag2, \
		:cmstellerlog_memo, \
		:cmstellerlog_rspcode, \
		:cmstellerlog_desc

struct cmstellerlog
{
	char	trandate[11];
	long	serseqno;
	char	channelid[3];
	long	termseq;
	char	trancode[7];
	char	tranname[41];
	char	brccode[10];
	char	teller[7];
	char	ateller[7];
	char	trantime[27];
	char	rteller[7];
	char	checktime[27];
	char	canceltime[27];
	double	amt1;
	double	amt2;
	char	flag1[2];
	char	flag2[2];
	char	memo[41];
	char	rspcode[9];
	char	desc[81];
};

void pubInitCmstellerlog()
{
	memset( cmstellerlog_trandate, 0x00, sizeof( cmstellerlog_trandate ) ) ;
	cmstellerlog_trandate_id = 0 ;
	memset( &cmstellerlog_serseqno, 0x00, sizeof( cmstellerlog_serseqno ) ) ;
	cmstellerlog_serseqno_id = 0 ;
	memset( cmstellerlog_channelid, 0x00, sizeof( cmstellerlog_channelid ) ) ;
	cmstellerlog_channelid_id = 0 ;
	memset( &cmstellerlog_termseq, 0x00, sizeof( cmstellerlog_termseq ) ) ;
	cmstellerlog_termseq_id = 0 ;
	memset( cmstellerlog_trancode, 0x00, sizeof( cmstellerlog_trancode ) ) ;
	cmstellerlog_trancode_id = 0 ;
	memset( cmstellerlog_tranname, 0x00, sizeof( cmstellerlog_tranname ) ) ;
	cmstellerlog_tranname_id = 0 ;
	memset( cmstellerlog_brccode, 0x00, sizeof( cmstellerlog_brccode ) ) ;
	cmstellerlog_brccode_id = 0 ;
	memset( cmstellerlog_teller, 0x00, sizeof( cmstellerlog_teller ) ) ;
	cmstellerlog_teller_id = 0 ;
	memset( cmstellerlog_ateller, 0x00, sizeof( cmstellerlog_ateller ) ) ;
	cmstellerlog_ateller_id = 0 ;
	memset( cmstellerlog_trantime, 0x00, sizeof( cmstellerlog_trantime ) ) ;
	cmstellerlog_trantime_id = 0 ;
	memset( cmstellerlog_rteller, 0x00, sizeof( cmstellerlog_rteller ) ) ;
	cmstellerlog_rteller_id = 0 ;
	memset( cmstellerlog_checktime, 0x00, sizeof( cmstellerlog_checktime ) ) ;
	cmstellerlog_checktime_id = 0 ;
	memset( cmstellerlog_canceltime, 0x00, sizeof( cmstellerlog_canceltime ) ) ;
	cmstellerlog_canceltime_id = 0 ;
	memset( &cmstellerlog_amt1, 0x00, sizeof( cmstellerlog_amt1 ) ) ;
	cmstellerlog_amt1_id = 0 ;
	memset( &cmstellerlog_amt2, 0x00, sizeof( cmstellerlog_amt2 ) ) ;
	cmstellerlog_amt2_id = 0 ;
	memset( cmstellerlog_flag1, 0x00, sizeof( cmstellerlog_flag1 ) ) ;
	cmstellerlog_flag1_id = 0 ;
	memset( cmstellerlog_flag2, 0x00, sizeof( cmstellerlog_flag2 ) ) ;
	cmstellerlog_flag2_id = 0 ;
	memset( cmstellerlog_memo, 0x00, sizeof( cmstellerlog_memo ) ) ;
	cmstellerlog_memo_id = 0 ;
	memset( cmstellerlog_rspcode, 0x00, sizeof( cmstellerlog_rspcode ) ) ;
	cmstellerlog_rspcode_id = 0 ;
	memset( cmstellerlog_desc, 0x00, sizeof( cmstellerlog_desc ) ) ;
	cmstellerlog_desc_id = 0 ;
}

void pubStoVCmstellerlog( struct cmstellerlog * pstCmstellerlog )
{
	pubInitCmstellerlog();
	if( !strlen( pstCmstellerlog->trandate ) )
		strcpy( pstCmstellerlog->trandate, " " );
	strcpy( cmstellerlog_trandate, pstCmstellerlog->trandate );
	cmstellerlog_serseqno = pstCmstellerlog->serseqno ;
	if( !strlen( pstCmstellerlog->channelid ) )
		strcpy( pstCmstellerlog->channelid, " " );
	strcpy( cmstellerlog_channelid, pstCmstellerlog->channelid );
	cmstellerlog_termseq = pstCmstellerlog->termseq ;
	if( !strlen( pstCmstellerlog->trancode ) )
		strcpy( pstCmstellerlog->trancode, " " );
	strcpy( cmstellerlog_trancode, pstCmstellerlog->trancode );
	if( !strlen( pstCmstellerlog->tranname ) )
		strcpy( pstCmstellerlog->tranname, " " );
	strcpy( cmstellerlog_tranname, pstCmstellerlog->tranname );
	if( !strlen( pstCmstellerlog->brccode ) )
		strcpy( pstCmstellerlog->brccode, " " );
	strcpy( cmstellerlog_brccode, pstCmstellerlog->brccode );
	if( !strlen( pstCmstellerlog->teller ) )
		strcpy( pstCmstellerlog->teller, " " );
	strcpy( cmstellerlog_teller, pstCmstellerlog->teller );
	if( !strlen( pstCmstellerlog->ateller ) )
		strcpy( pstCmstellerlog->ateller, " " );
	strcpy( cmstellerlog_ateller, pstCmstellerlog->ateller );
	if( !strlen( pstCmstellerlog->trantime ) )
		strcpy( pstCmstellerlog->trantime, " " );
	strcpy( cmstellerlog_trantime, pstCmstellerlog->trantime );
	if( !strlen( pstCmstellerlog->rteller ) )
		strcpy( pstCmstellerlog->rteller, " " );
	strcpy( cmstellerlog_rteller, pstCmstellerlog->rteller );
	if( !strlen( pstCmstellerlog->checktime ) )
		strcpy( pstCmstellerlog->checktime, " " );
	strcpy( cmstellerlog_checktime, pstCmstellerlog->checktime );
	if( !strlen( pstCmstellerlog->canceltime ) )
		strcpy( pstCmstellerlog->canceltime, " " );
	strcpy( cmstellerlog_canceltime, pstCmstellerlog->canceltime );
	cmstellerlog_amt1 = pstCmstellerlog->amt1 ;
	pubDround( &cmstellerlog_amt1, 2 );
	cmstellerlog_amt2 = pstCmstellerlog->amt2 ;
	pubDround( &cmstellerlog_amt2, 2 );
	if( !strlen( pstCmstellerlog->flag1 ) )
		strcpy( pstCmstellerlog->flag1, " " );
	strcpy( cmstellerlog_flag1, pstCmstellerlog->flag1 );
	if( !strlen( pstCmstellerlog->flag2 ) )
		strcpy( pstCmstellerlog->flag2, " " );
	strcpy( cmstellerlog_flag2, pstCmstellerlog->flag2 );
	if( !strlen( pstCmstellerlog->memo ) )
		strcpy( pstCmstellerlog->memo, " " );
	strcpy( cmstellerlog_memo, pstCmstellerlog->memo );
	if( !strlen( pstCmstellerlog->rspcode ) )
		strcpy( pstCmstellerlog->rspcode, " " );
	strcpy( cmstellerlog_rspcode, pstCmstellerlog->rspcode );
	if( !strlen( pstCmstellerlog->desc ) )
		strcpy( pstCmstellerlog->desc, " " );
	strcpy( cmstellerlog_desc, pstCmstellerlog->desc );
}

void pubVtoSCmstellerlog( struct cmstellerlog * pstCmstellerlog )
{
	strcpy( pstCmstellerlog->trandate, cmstellerlog_trandate );
	strpack( pstCmstellerlog->trandate );
	pstCmstellerlog->serseqno = cmstellerlog_serseqno ;
	strcpy( pstCmstellerlog->channelid, cmstellerlog_channelid );
	strpack( pstCmstellerlog->channelid );
	pstCmstellerlog->termseq = cmstellerlog_termseq ;
	strcpy( pstCmstellerlog->trancode, cmstellerlog_trancode );
	strpack( pstCmstellerlog->trancode );
	strcpy( pstCmstellerlog->tranname, cmstellerlog_tranname );
	strpack( pstCmstellerlog->tranname );
	strcpy( pstCmstellerlog->brccode, cmstellerlog_brccode );
	strpack( pstCmstellerlog->brccode );
	strcpy( pstCmstellerlog->teller, cmstellerlog_teller );
	strpack( pstCmstellerlog->teller );
	strcpy( pstCmstellerlog->ateller, cmstellerlog_ateller );
	strpack( pstCmstellerlog->ateller );
	strcpy( pstCmstellerlog->trantime, cmstellerlog_trantime );
	strpack( pstCmstellerlog->trantime );
	strcpy( pstCmstellerlog->rteller, cmstellerlog_rteller );
	strpack( pstCmstellerlog->rteller );
	strcpy( pstCmstellerlog->checktime, cmstellerlog_checktime );
	strpack( pstCmstellerlog->checktime );
	strcpy( pstCmstellerlog->canceltime, cmstellerlog_canceltime );
	strpack( pstCmstellerlog->canceltime );
	pstCmstellerlog->amt1 = cmstellerlog_amt1 ;
	pubDround( &pstCmstellerlog->amt1, 2 );
	pstCmstellerlog->amt2 = cmstellerlog_amt2 ;
	pubDround( &pstCmstellerlog->amt2, 2 );
	strcpy( pstCmstellerlog->flag1, cmstellerlog_flag1 );
	strpack( pstCmstellerlog->flag1 );
	strcpy( pstCmstellerlog->flag2, cmstellerlog_flag2 );
	strpack( pstCmstellerlog->flag2 );
	strcpy( pstCmstellerlog->memo, cmstellerlog_memo );
	strpack( pstCmstellerlog->memo );
	strcpy( pstCmstellerlog->rspcode, cmstellerlog_rspcode );
	strpack( pstCmstellerlog->rspcode );
	strcpy( pstCmstellerlog->desc, cmstellerlog_desc );
	strpack( pstCmstellerlog->desc );
}

int pubInstCmstellerlog( struct cmstellerlog * pstCmstellerlog )
{
	pubInitCmstellerlog();
	pubStoVCmstellerlog(pstCmstellerlog);
	EXEC SQL INSERT INTO cmstellerlog VALUES ( RR_CMSTELLERLOG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmstellerlog",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}