tbcms037.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 cmsreport01_trandate[11];
	short cmsreport01_trandate_id;
	char cmsreport01_brc[10];
	short cmsreport01_brc_id;
	char cmsreport01_cardkind[9];
	short cmsreport01_cardkind_id;
	char cmsreport01_ccy[4];
	short cmsreport01_ccy_id;
	char cmsreport01_mctmcc[5];
	short cmsreport01_mctmcc_id;
	char cmsreport01_mid[16];
	short cmsreport01_mid_id;
	char cmsreport01_frnttrancode[7];
	short cmsreport01_frnttrancode_id;
	char cmsreport01_cardtrantype[3];
	short cmsreport01_cardtrantype_id;
	char cmsreport01_cardtrantypecomm[71];
	short cmsreport01_cardtrantypecomm_id;
	char cmsreport01_ccycomm[71];
	short cmsreport01_ccycomm_id;
	char cmsreport01_mctname[71];
	short cmsreport01_mctname_id;
	char cmsreport01_cardkindcomm[31];
	short cmsreport01_cardkindcomm_id;
	char cmsreport01_frnttrancomm[71];
	short cmsreport01_frnttrancomm_id;
	char cmsreport01_opnflg[2];
	short cmsreport01_opnflg_id;
	long cmsreport01_count;
	short cmsreport01_count_id;
	double cmsreport01_amt;
	short cmsreport01_amt_id;
	double cmsreport01_fee;
	short cmsreport01_fee_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSREPORT01 \
		:cmsreport01_trandate:cmsreport01_trandate_id, \
		:cmsreport01_brc:cmsreport01_brc_id, \
		:cmsreport01_cardkind:cmsreport01_cardkind_id, \
		:cmsreport01_ccy:cmsreport01_ccy_id, \
		:cmsreport01_mctmcc:cmsreport01_mctmcc_id, \
		:cmsreport01_mid:cmsreport01_mid_id, \
		:cmsreport01_frnttrancode:cmsreport01_frnttrancode_id, \
		:cmsreport01_cardtrantype:cmsreport01_cardtrantype_id, \
		:cmsreport01_cardtrantypecomm:cmsreport01_cardtrantypecomm_id, \
		:cmsreport01_ccycomm:cmsreport01_ccycomm_id, \
		:cmsreport01_mctname:cmsreport01_mctname_id, \
		:cmsreport01_cardkindcomm:cmsreport01_cardkindcomm_id, \
		:cmsreport01_frnttrancomm:cmsreport01_frnttrancomm_id, \
		:cmsreport01_opnflg:cmsreport01_opnflg_id, \
		:cmsreport01_count:cmsreport01_count_id, \
		:cmsreport01_amt:cmsreport01_amt_id, \
		:cmsreport01_fee:cmsreport01_fee_id

#define UU_CMSREPORT01 \
		trandate, \
		brc, \
		cardkind, \
		ccy, \
		mctmcc, \
		mid, \
		frnttrancode, \
		cardtrantype, \
		cardtrantypecomm, \
		ccycomm, \
		mctname, \
		cardkindcomm, \
		frnttrancomm, \
		opnflg, \
		count, \
		amt, \
		fee

#define WW_CMSREPORT01 \
		:cmsreport01_trandate, \
		:cmsreport01_brc, \
		:cmsreport01_cardkind, \
		:cmsreport01_ccy, \
		:cmsreport01_mctmcc, \
		:cmsreport01_mid, \
		:cmsreport01_frnttrancode, \
		:cmsreport01_cardtrantype, \
		:cmsreport01_cardtrantypecomm, \
		:cmsreport01_ccycomm, \
		:cmsreport01_mctname, \
		:cmsreport01_cardkindcomm, \
		:cmsreport01_frnttrancomm, \
		:cmsreport01_opnflg, \
		:cmsreport01_count, \
		:cmsreport01_amt, \
		:cmsreport01_fee

struct cmsreport01
{
	char	trandate[11];
	char	brc[10];
	char	cardkind[9];
	char	ccy[4];
	char	mctmcc[5];
	char	mid[16];
	char	frnttrancode[7];
	char	cardtrantype[3];
	char	cardtrantypecomm[71];
	char	ccycomm[71];
	char	mctname[71];
	char	cardkindcomm[31];
	char	frnttrancomm[71];
	char	opnflg[2];
	long	count;
	double	amt;
	double	fee;
};

void pubInitCmsreport01()
{
	memset( cmsreport01_trandate, 0x00, sizeof( cmsreport01_trandate ) ) ;
	cmsreport01_trandate_id = 0 ;
	memset( cmsreport01_brc, 0x00, sizeof( cmsreport01_brc ) ) ;
	cmsreport01_brc_id = 0 ;
	memset( cmsreport01_cardkind, 0x00, sizeof( cmsreport01_cardkind ) ) ;
	cmsreport01_cardkind_id = 0 ;
	memset( cmsreport01_ccy, 0x00, sizeof( cmsreport01_ccy ) ) ;
	cmsreport01_ccy_id = 0 ;
	memset( cmsreport01_mctmcc, 0x00, sizeof( cmsreport01_mctmcc ) ) ;
	cmsreport01_mctmcc_id = 0 ;
	memset( cmsreport01_mid, 0x00, sizeof( cmsreport01_mid ) ) ;
	cmsreport01_mid_id = 0 ;
	memset( cmsreport01_frnttrancode, 0x00, sizeof( cmsreport01_frnttrancode ) ) ;
	cmsreport01_frnttrancode_id = 0 ;
	memset( cmsreport01_cardtrantype, 0x00, sizeof( cmsreport01_cardtrantype ) ) ;
	cmsreport01_cardtrantype_id = 0 ;
	memset( cmsreport01_cardtrantypecomm, 0x00, sizeof( cmsreport01_cardtrantypecomm ) ) ;
	cmsreport01_cardtrantypecomm_id = 0 ;
	memset( cmsreport01_ccycomm, 0x00, sizeof( cmsreport01_ccycomm ) ) ;
	cmsreport01_ccycomm_id = 0 ;
	memset( cmsreport01_mctname, 0x00, sizeof( cmsreport01_mctname ) ) ;
	cmsreport01_mctname_id = 0 ;
	memset( cmsreport01_cardkindcomm, 0x00, sizeof( cmsreport01_cardkindcomm ) ) ;
	cmsreport01_cardkindcomm_id = 0 ;
	memset( cmsreport01_frnttrancomm, 0x00, sizeof( cmsreport01_frnttrancomm ) ) ;
	cmsreport01_frnttrancomm_id = 0 ;
	memset( cmsreport01_opnflg, 0x00, sizeof( cmsreport01_opnflg ) ) ;
	cmsreport01_opnflg_id = 0 ;
	memset( &cmsreport01_count, 0x00, sizeof( cmsreport01_count ) ) ;
	cmsreport01_count_id = 0 ;
	memset( &cmsreport01_amt, 0x00, sizeof( cmsreport01_amt ) ) ;
	cmsreport01_amt_id = 0 ;
	memset( &cmsreport01_fee, 0x00, sizeof( cmsreport01_fee ) ) ;
	cmsreport01_fee_id = 0 ;
}

void pubStoVCmsreport01( struct cmsreport01 * pstCmsreport01 )
{
	pubInitCmsreport01();
	if( !strlen( pstCmsreport01->trandate ) )
		strcpy( pstCmsreport01->trandate, " " );
	strcpy( cmsreport01_trandate, pstCmsreport01->trandate );
	if( !strlen( pstCmsreport01->brc ) )
		strcpy( pstCmsreport01->brc, " " );
	strcpy( cmsreport01_brc, pstCmsreport01->brc );
	if( !strlen( pstCmsreport01->cardkind ) )
		strcpy( pstCmsreport01->cardkind, " " );
	strcpy( cmsreport01_cardkind, pstCmsreport01->cardkind );
	if( !strlen( pstCmsreport01->ccy ) )
		strcpy( pstCmsreport01->ccy, " " );
	strcpy( cmsreport01_ccy, pstCmsreport01->ccy );
	if( !strlen( pstCmsreport01->mctmcc ) )
		strcpy( pstCmsreport01->mctmcc, " " );
	strcpy( cmsreport01_mctmcc, pstCmsreport01->mctmcc );
	if( !strlen( pstCmsreport01->mid ) )
		strcpy( pstCmsreport01->mid, " " );
	strcpy( cmsreport01_mid, pstCmsreport01->mid );
	if( !strlen( pstCmsreport01->frnttrancode ) )
		strcpy( pstCmsreport01->frnttrancode, " " );
	strcpy( cmsreport01_frnttrancode, pstCmsreport01->frnttrancode );
	if( !strlen( pstCmsreport01->cardtrantype ) )
		strcpy( pstCmsreport01->cardtrantype, " " );
	strcpy( cmsreport01_cardtrantype, pstCmsreport01->cardtrantype );
	if( !strlen( pstCmsreport01->cardtrantypecomm ) )
		strcpy( pstCmsreport01->cardtrantypecomm, " " );
	strcpy( cmsreport01_cardtrantypecomm, pstCmsreport01->cardtrantypecomm );
	if( !strlen( pstCmsreport01->ccycomm ) )
		strcpy( pstCmsreport01->ccycomm, " " );
	strcpy( cmsreport01_ccycomm, pstCmsreport01->ccycomm );
	if( !strlen( pstCmsreport01->mctname ) )
		strcpy( pstCmsreport01->mctname, " " );
	strcpy( cmsreport01_mctname, pstCmsreport01->mctname );
	if( !strlen( pstCmsreport01->cardkindcomm ) )
		strcpy( pstCmsreport01->cardkindcomm, " " );
	strcpy( cmsreport01_cardkindcomm, pstCmsreport01->cardkindcomm );
	if( !strlen( pstCmsreport01->frnttrancomm ) )
		strcpy( pstCmsreport01->frnttrancomm, " " );
	strcpy( cmsreport01_frnttrancomm, pstCmsreport01->frnttrancomm );
	if( !strlen( pstCmsreport01->opnflg ) )
		strcpy( pstCmsreport01->opnflg, " " );
	strcpy( cmsreport01_opnflg, pstCmsreport01->opnflg );
	cmsreport01_count = pstCmsreport01->count ;
	cmsreport01_amt = pstCmsreport01->amt ;
	pubDround( &cmsreport01_amt, 2 );
	cmsreport01_fee = pstCmsreport01->fee ;
	pubDround( &cmsreport01_fee, 2 );
}

void pubVtoSCmsreport01( struct cmsreport01 * pstCmsreport01 )
{
	strcpy( pstCmsreport01->trandate, cmsreport01_trandate );
	strpack( pstCmsreport01->trandate );
	strcpy( pstCmsreport01->brc, cmsreport01_brc );
	strpack( pstCmsreport01->brc );
	strcpy( pstCmsreport01->cardkind, cmsreport01_cardkind );
	strpack( pstCmsreport01->cardkind );
	strcpy( pstCmsreport01->ccy, cmsreport01_ccy );
	strpack( pstCmsreport01->ccy );
	strcpy( pstCmsreport01->mctmcc, cmsreport01_mctmcc );
	strpack( pstCmsreport01->mctmcc );
	strcpy( pstCmsreport01->mid, cmsreport01_mid );
	strpack( pstCmsreport01->mid );
	strcpy( pstCmsreport01->frnttrancode, cmsreport01_frnttrancode );
	strpack( pstCmsreport01->frnttrancode );
	strcpy( pstCmsreport01->cardtrantype, cmsreport01_cardtrantype );
	strpack( pstCmsreport01->cardtrantype );
	strcpy( pstCmsreport01->cardtrantypecomm, cmsreport01_cardtrantypecomm );
	strpack( pstCmsreport01->cardtrantypecomm );
	strcpy( pstCmsreport01->ccycomm, cmsreport01_ccycomm );
	strpack( pstCmsreport01->ccycomm );
	strcpy( pstCmsreport01->mctname, cmsreport01_mctname );
	strpack( pstCmsreport01->mctname );
	strcpy( pstCmsreport01->cardkindcomm, cmsreport01_cardkindcomm );
	strpack( pstCmsreport01->cardkindcomm );
	strcpy( pstCmsreport01->frnttrancomm, cmsreport01_frnttrancomm );
	strpack( pstCmsreport01->frnttrancomm );
	strcpy( pstCmsreport01->opnflg, cmsreport01_opnflg );
	strpack( pstCmsreport01->opnflg );
	pstCmsreport01->count = cmsreport01_count ;
	pstCmsreport01->amt = cmsreport01_amt ;
	pubDround( &pstCmsreport01->amt, 2 );
	pstCmsreport01->fee = cmsreport01_fee ;
	pubDround( &pstCmsreport01->fee, 2 );
}

int pubReadCmsreport01( struct cmsreport01 * pstCmsreport01 )
{
	pubInitCmsreport01();
	pubStoVCmsreport01(pstCmsreport01);
	EXEC SQL SELECT * INTO RR_CMSREPORT01 
		FROM cmsreport01  
		WHERE  
		 trandate = :cmsreport01_trandate and 
		 brc = :cmsreport01_brc and 
		 cardkind = :cmsreport01_cardkind and 
		 ccy = :cmsreport01_ccy and 
		 mctmcc = :cmsreport01_mctmcc and 
		 mid = :cmsreport01_mid and 
		 frnttrancode = :cmsreport01_frnttrancode and 
		 cardtrantype = :cmsreport01_cardtrantype  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsreport01",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsreport01(pstCmsreport01);
	return 0; 
} 
 
int pubModiCmsreport01( struct cmsreport01 * pstCmsreport01 )
{
	pubInitCmsreport01();
	pubStoVCmsreport01(pstCmsreport01);
	EXEC SQL UPDATE cmsreport01 
		SET ( UU_CMSREPORT01 ) = ( WW_CMSREPORT01 ) 
		WHERE  
		 trandate = :cmsreport01_trandate and 
		 brc = :cmsreport01_brc and 
		 cardkind = :cmsreport01_cardkind and 
		 ccy = :cmsreport01_ccy and 
		 mctmcc = :cmsreport01_mctmcc and 
		 mid = :cmsreport01_mid and 
		 frnttrancode = :cmsreport01_frnttrancode and 
		 cardtrantype = :cmsreport01_cardtrantype  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsreport01",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsreport01( struct cmsreport01 * pstCmsreport01 )
{
	pubInitCmsreport01();
	pubStoVCmsreport01(pstCmsreport01);
	EXEC SQL INSERT INTO cmsreport01 VALUES ( RR_CMSREPORT01 ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsreport01",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}