tbcms055.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 cmsaccumresult_cardno[20];
	short cmsaccumresult_cardno_id;
	char cmsaccumresult_accummode[5];
	short cmsaccumresult_accummode_id;
	char cmsaccumresult_accumbegdate[11];
	short cmsaccumresult_accumbegdate_id;
	char cmsaccumresult_accumenddate[11];
	short cmsaccumresult_accumenddate_id;
	char cmsaccumresult_ccy[4];
	short cmsaccumresult_ccy_id;
	char cmsaccumresult_issuebrc[10];
	short cmsaccumresult_issuebrc_id;
	char cmsaccumresult_custno[31];
	short cmsaccumresult_custno_id;
	long cmsaccumresult_accumvalue;
	short cmsaccumresult_accumvalue_id;
	long cmsaccumresult_totaccumvalue;
	short cmsaccumresult_totaccumvalue_id;
	char cmsaccumresult_accumflag[2];
	short cmsaccumresult_accumflag_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSACCUMRESULT \
		:cmsaccumresult_cardno:cmsaccumresult_cardno_id, \
		:cmsaccumresult_accummode:cmsaccumresult_accummode_id, \
		:cmsaccumresult_accumbegdate:cmsaccumresult_accumbegdate_id, \
		:cmsaccumresult_accumenddate:cmsaccumresult_accumenddate_id, \
		:cmsaccumresult_ccy:cmsaccumresult_ccy_id, \
		:cmsaccumresult_issuebrc:cmsaccumresult_issuebrc_id, \
		:cmsaccumresult_custno:cmsaccumresult_custno_id, \
		:cmsaccumresult_accumvalue:cmsaccumresult_accumvalue_id, \
		:cmsaccumresult_totaccumvalue:cmsaccumresult_totaccumvalue_id, \
		:cmsaccumresult_accumflag:cmsaccumresult_accumflag_id

#define UU_CMSACCUMRESULT \
		cardno, \
		accummode, \
		accumbegdate, \
		accumenddate, \
		ccy, \
		issuebrc, \
		custno, \
		accumvalue, \
		totaccumvalue, \
		accumflag

#define WW_CMSACCUMRESULT \
		:cmsaccumresult_cardno, \
		:cmsaccumresult_accummode, \
		:cmsaccumresult_accumbegdate, \
		:cmsaccumresult_accumenddate, \
		:cmsaccumresult_ccy, \
		:cmsaccumresult_issuebrc, \
		:cmsaccumresult_custno, \
		:cmsaccumresult_accumvalue, \
		:cmsaccumresult_totaccumvalue, \
		:cmsaccumresult_accumflag

struct cmsaccumresult
{
	char	cardno[20];
	char	accummode[5];
	char	accumbegdate[11];
	char	accumenddate[11];
	char	ccy[4];
	char	issuebrc[10];
	char	custno[31];
	long	accumvalue;
	long	totaccumvalue;
	char	accumflag[2];
};

void pubInitCmsaccumresult()
{
	memset( cmsaccumresult_cardno, 0x00, sizeof( cmsaccumresult_cardno ) ) ;
	cmsaccumresult_cardno_id = 0 ;
	memset( cmsaccumresult_accummode, 0x00, sizeof( cmsaccumresult_accummode ) ) ;
	cmsaccumresult_accummode_id = 0 ;
	memset( cmsaccumresult_accumbegdate, 0x00, sizeof( cmsaccumresult_accumbegdate ) ) ;
	cmsaccumresult_accumbegdate_id = 0 ;
	memset( cmsaccumresult_accumenddate, 0x00, sizeof( cmsaccumresult_accumenddate ) ) ;
	cmsaccumresult_accumenddate_id = 0 ;
	memset( cmsaccumresult_ccy, 0x00, sizeof( cmsaccumresult_ccy ) ) ;
	cmsaccumresult_ccy_id = 0 ;
	memset( cmsaccumresult_issuebrc, 0x00, sizeof( cmsaccumresult_issuebrc ) ) ;
	cmsaccumresult_issuebrc_id = 0 ;
	memset( cmsaccumresult_custno, 0x00, sizeof( cmsaccumresult_custno ) ) ;
	cmsaccumresult_custno_id = 0 ;
	memset( &cmsaccumresult_accumvalue, 0x00, sizeof( cmsaccumresult_accumvalue ) ) ;
	cmsaccumresult_accumvalue_id = 0 ;
	memset( &cmsaccumresult_totaccumvalue, 0x00, sizeof( cmsaccumresult_totaccumvalue ) ) ;
	cmsaccumresult_totaccumvalue_id = 0 ;
	memset( cmsaccumresult_accumflag, 0x00, sizeof( cmsaccumresult_accumflag ) ) ;
	cmsaccumresult_accumflag_id = 0 ;
}

void pubStoVCmsaccumresult( struct cmsaccumresult * pstCmsaccumresult )
{
	pubInitCmsaccumresult();
	if( !strlen( pstCmsaccumresult->cardno ) )
		strcpy( pstCmsaccumresult->cardno, " " );
	strcpy( cmsaccumresult_cardno, pstCmsaccumresult->cardno );
	if( !strlen( pstCmsaccumresult->accummode ) )
		strcpy( pstCmsaccumresult->accummode, " " );
	strcpy( cmsaccumresult_accummode, pstCmsaccumresult->accummode );
	if( !strlen( pstCmsaccumresult->accumbegdate ) )
		strcpy( pstCmsaccumresult->accumbegdate, " " );
	strcpy( cmsaccumresult_accumbegdate, pstCmsaccumresult->accumbegdate );
	if( !strlen( pstCmsaccumresult->accumenddate ) )
		strcpy( pstCmsaccumresult->accumenddate, " " );
	strcpy( cmsaccumresult_accumenddate, pstCmsaccumresult->accumenddate );
	if( !strlen( pstCmsaccumresult->ccy ) )
		strcpy( pstCmsaccumresult->ccy, " " );
	strcpy( cmsaccumresult_ccy, pstCmsaccumresult->ccy );
	if( !strlen( pstCmsaccumresult->issuebrc ) )
		strcpy( pstCmsaccumresult->issuebrc, " " );
	strcpy( cmsaccumresult_issuebrc, pstCmsaccumresult->issuebrc );
	if( !strlen( pstCmsaccumresult->custno ) )
		strcpy( pstCmsaccumresult->custno, " " );
	strcpy( cmsaccumresult_custno, pstCmsaccumresult->custno );
	cmsaccumresult_accumvalue = pstCmsaccumresult->accumvalue ;
	cmsaccumresult_totaccumvalue = pstCmsaccumresult->totaccumvalue ;
	if( !strlen( pstCmsaccumresult->accumflag ) )
		strcpy( pstCmsaccumresult->accumflag, " " );
	strcpy( cmsaccumresult_accumflag, pstCmsaccumresult->accumflag );
}

void pubVtoSCmsaccumresult( struct cmsaccumresult * pstCmsaccumresult )
{
	strcpy( pstCmsaccumresult->cardno, cmsaccumresult_cardno );
	strpack( pstCmsaccumresult->cardno );
	strcpy( pstCmsaccumresult->accummode, cmsaccumresult_accummode );
	strpack( pstCmsaccumresult->accummode );
	strcpy( pstCmsaccumresult->accumbegdate, cmsaccumresult_accumbegdate );
	strpack( pstCmsaccumresult->accumbegdate );
	strcpy( pstCmsaccumresult->accumenddate, cmsaccumresult_accumenddate );
	strpack( pstCmsaccumresult->accumenddate );
	strcpy( pstCmsaccumresult->ccy, cmsaccumresult_ccy );
	strpack( pstCmsaccumresult->ccy );
	strcpy( pstCmsaccumresult->issuebrc, cmsaccumresult_issuebrc );
	strpack( pstCmsaccumresult->issuebrc );
	strcpy( pstCmsaccumresult->custno, cmsaccumresult_custno );
	strpack( pstCmsaccumresult->custno );
	pstCmsaccumresult->accumvalue = cmsaccumresult_accumvalue ;
	pstCmsaccumresult->totaccumvalue = cmsaccumresult_totaccumvalue ;
	strcpy( pstCmsaccumresult->accumflag, cmsaccumresult_accumflag );
	strpack( pstCmsaccumresult->accumflag );
}

int pubReadCmsaccumresult( struct cmsaccumresult * pstCmsaccumresult )
{
	pubInitCmsaccumresult();
	pubStoVCmsaccumresult(pstCmsaccumresult);
	EXEC SQL SELECT * INTO RR_CMSACCUMRESULT 
		FROM cmsaccumresult  
		WHERE  
		 cardno = :cmsaccumresult_cardno and 
		 accummode = :cmsaccumresult_accummode and 
		 accumbegdate = :cmsaccumresult_accumbegdate and 
		 accumenddate = :cmsaccumresult_accumenddate and 
		 ccy = :cmsaccumresult_ccy  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsaccumresult",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsaccumresult(pstCmsaccumresult);
	return 0; 
} 
 
int pubModiCmsaccumresult( struct cmsaccumresult * pstCmsaccumresult )
{
	pubInitCmsaccumresult();
	pubStoVCmsaccumresult(pstCmsaccumresult);
	EXEC SQL UPDATE cmsaccumresult 
		SET ( UU_CMSACCUMRESULT ) = ( WW_CMSACCUMRESULT ) 
		WHERE  
		 cardno = :cmsaccumresult_cardno and 
		 accummode = :cmsaccumresult_accummode and 
		 accumbegdate = :cmsaccumresult_accumbegdate and 
		 accumenddate = :cmsaccumresult_accumenddate and 
		 ccy = :cmsaccumresult_ccy  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsaccumresult",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsaccumresult( struct cmsaccumresult * pstCmsaccumresult )
{
	pubInitCmsaccumresult();
	pubStoVCmsaccumresult(pstCmsaccumresult);
	EXEC SQL INSERT INTO cmsaccumresult VALUES ( RR_CMSACCUMRESULT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsaccumresult",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}