tbcms031.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 cmstlimtm_cardno[20];
	short cmstlimtm_cardno_id;
	char cmstlimtm_trandate[11];
	short cmstlimtm_trandate_id;
	long cmstlimtm_serseqno;
	short cmstlimtm_serseqno_id;
	char cmstlimtm_vouchno[17];
	short cmstlimtm_vouchno_id;
	char cmstlimtm_trandevtype[3];
	short cmstlimtm_trandevtype_id;
	char cmstlimtm_ccy[4];
	short cmstlimtm_ccy_id;
	long cmstlimtm_period;
	short cmstlimtm_period_id;
	double cmstlimtm_cashlimitamt;
	short cmstlimtm_cashlimitamt_id;
	double cmstlimtm_depolimitamt;
	short cmstlimtm_depolimitamt_id;
	double cmstlimtm_conlimitamt;
	short cmstlimtm_conlimitamt_id;
	double cmstlimtm_tranoutlimitamt;
	short cmstlimtm_tranoutlimitamt_id;
	long cmstlimtm_cashlimittime;
	short cmstlimtm_cashlimittime_id;
	long cmstlimtm_depolimittime;
	short cmstlimtm_depolimittime_id;
	long cmstlimtm_conlimittime;
	short cmstlimtm_conlimittime_id;
	long cmstlimtm_tranoutlimittime;
	short cmstlimtm_tranoutlimittime_id;
	char cmstlimtm_idtype[3];
	short cmstlimtm_idtype_id;
	char cmstlimtm_idcode[21];
	short cmstlimtm_idcode_id;
	char cmstlimtm_custname[71];
	short cmstlimtm_custname_id;
	char cmstlimtm_issuebrc[10];
	short cmstlimtm_issuebrc_id;
	char cmstlimtm_teller[11];
	short cmstlimtm_teller_id;
	char cmstlimtm_cardkind[9];
	short cmstlimtm_cardkind_id;
	char cmstlimtm_lmtbrc[10];
	short cmstlimtm_lmtbrc_id;
	char cmstlimtm_lmtteller[11];
	short cmstlimtm_lmtteller_id;
	char cmstlimtm_lmtauthteller[11];
	short cmstlimtm_lmtauthteller_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTLIMTM \
		:cmstlimtm_cardno:cmstlimtm_cardno_id, \
		:cmstlimtm_trandate:cmstlimtm_trandate_id, \
		:cmstlimtm_serseqno:cmstlimtm_serseqno_id, \
		:cmstlimtm_vouchno:cmstlimtm_vouchno_id, \
		:cmstlimtm_trandevtype:cmstlimtm_trandevtype_id, \
		:cmstlimtm_ccy:cmstlimtm_ccy_id, \
		:cmstlimtm_period:cmstlimtm_period_id, \
		:cmstlimtm_cashlimitamt:cmstlimtm_cashlimitamt_id, \
		:cmstlimtm_depolimitamt:cmstlimtm_depolimitamt_id, \
		:cmstlimtm_conlimitamt:cmstlimtm_conlimitamt_id, \
		:cmstlimtm_tranoutlimitamt:cmstlimtm_tranoutlimitamt_id, \
		:cmstlimtm_cashlimittime:cmstlimtm_cashlimittime_id, \
		:cmstlimtm_depolimittime:cmstlimtm_depolimittime_id, \
		:cmstlimtm_conlimittime:cmstlimtm_conlimittime_id, \
		:cmstlimtm_tranoutlimittime:cmstlimtm_tranoutlimittime_id, \
		:cmstlimtm_idtype:cmstlimtm_idtype_id, \
		:cmstlimtm_idcode:cmstlimtm_idcode_id, \
		:cmstlimtm_custname:cmstlimtm_custname_id, \
		:cmstlimtm_issuebrc:cmstlimtm_issuebrc_id, \
		:cmstlimtm_teller:cmstlimtm_teller_id, \
		:cmstlimtm_cardkind:cmstlimtm_cardkind_id, \
		:cmstlimtm_lmtbrc:cmstlimtm_lmtbrc_id, \
		:cmstlimtm_lmtteller:cmstlimtm_lmtteller_id, \
		:cmstlimtm_lmtauthteller:cmstlimtm_lmtauthteller_id

#define UU_CMSTLIMTM \
		cardno, \
		trandate, \
		serseqno, \
		vouchno, \
		trandevtype, \
		ccy, \
		period, \
		cashlimitamt, \
		depolimitamt, \
		conlimitamt, \
		tranoutlimitamt, \
		cashlimittime, \
		depolimittime, \
		conlimittime, \
		tranoutlimittime, \
		idtype, \
		idcode, \
		custname, \
		issuebrc, \
		teller, \
		cardkind, \
		lmtbrc, \
		lmtteller, \
		lmtauthteller

#define WW_CMSTLIMTM \
		:cmstlimtm_cardno, \
		:cmstlimtm_trandate, \
		:cmstlimtm_serseqno, \
		:cmstlimtm_vouchno, \
		:cmstlimtm_trandevtype, \
		:cmstlimtm_ccy, \
		:cmstlimtm_period, \
		:cmstlimtm_cashlimitamt, \
		:cmstlimtm_depolimitamt, \
		:cmstlimtm_conlimitamt, \
		:cmstlimtm_tranoutlimitamt, \
		:cmstlimtm_cashlimittime, \
		:cmstlimtm_depolimittime, \
		:cmstlimtm_conlimittime, \
		:cmstlimtm_tranoutlimittime, \
		:cmstlimtm_idtype, \
		:cmstlimtm_idcode, \
		:cmstlimtm_custname, \
		:cmstlimtm_issuebrc, \
		:cmstlimtm_teller, \
		:cmstlimtm_cardkind, \
		:cmstlimtm_lmtbrc, \
		:cmstlimtm_lmtteller, \
		:cmstlimtm_lmtauthteller

struct cmstlimtm
{
	char	cardno[20];
	char	trandate[11];
	long	serseqno;
	char	vouchno[17];
	char	trandevtype[3];
	char	ccy[4];
	long	period;
	double	cashlimitamt;
	double	depolimitamt;
	double	conlimitamt;
	double	tranoutlimitamt;
	long	cashlimittime;
	long	depolimittime;
	long	conlimittime;
	long	tranoutlimittime;
	char	idtype[3];
	char	idcode[21];
	char	custname[71];
	char	issuebrc[10];
	char	teller[11];
	char	cardkind[9];
	char	lmtbrc[10];
	char	lmtteller[11];
	char	lmtauthteller[11];
};

void pubInitCmstlimtm()
{
	memset( cmstlimtm_cardno, 0x00, sizeof( cmstlimtm_cardno ) ) ;
	cmstlimtm_cardno_id = 0 ;
	memset( cmstlimtm_trandate, 0x00, sizeof( cmstlimtm_trandate ) ) ;
	cmstlimtm_trandate_id = 0 ;
	memset( &cmstlimtm_serseqno, 0x00, sizeof( cmstlimtm_serseqno ) ) ;
	cmstlimtm_serseqno_id = 0 ;
	memset( cmstlimtm_vouchno, 0x00, sizeof( cmstlimtm_vouchno ) ) ;
	cmstlimtm_vouchno_id = 0 ;
	memset( cmstlimtm_trandevtype, 0x00, sizeof( cmstlimtm_trandevtype ) ) ;
	cmstlimtm_trandevtype_id = 0 ;
	memset( cmstlimtm_ccy, 0x00, sizeof( cmstlimtm_ccy ) ) ;
	cmstlimtm_ccy_id = 0 ;
	memset( &cmstlimtm_period, 0x00, sizeof( cmstlimtm_period ) ) ;
	cmstlimtm_period_id = 0 ;
	memset( &cmstlimtm_cashlimitamt, 0x00, sizeof( cmstlimtm_cashlimitamt ) ) ;
	cmstlimtm_cashlimitamt_id = 0 ;
	memset( &cmstlimtm_depolimitamt, 0x00, sizeof( cmstlimtm_depolimitamt ) ) ;
	cmstlimtm_depolimitamt_id = 0 ;
	memset( &cmstlimtm_conlimitamt, 0x00, sizeof( cmstlimtm_conlimitamt ) ) ;
	cmstlimtm_conlimitamt_id = 0 ;
	memset( &cmstlimtm_tranoutlimitamt, 0x00, sizeof( cmstlimtm_tranoutlimitamt ) ) ;
	cmstlimtm_tranoutlimitamt_id = 0 ;
	memset( &cmstlimtm_cashlimittime, 0x00, sizeof( cmstlimtm_cashlimittime ) ) ;
	cmstlimtm_cashlimittime_id = 0 ;
	memset( &cmstlimtm_depolimittime, 0x00, sizeof( cmstlimtm_depolimittime ) ) ;
	cmstlimtm_depolimittime_id = 0 ;
	memset( &cmstlimtm_conlimittime, 0x00, sizeof( cmstlimtm_conlimittime ) ) ;
	cmstlimtm_conlimittime_id = 0 ;
	memset( &cmstlimtm_tranoutlimittime, 0x00, sizeof( cmstlimtm_tranoutlimittime ) ) ;
	cmstlimtm_tranoutlimittime_id = 0 ;
	memset( cmstlimtm_idtype, 0x00, sizeof( cmstlimtm_idtype ) ) ;
	cmstlimtm_idtype_id = 0 ;
	memset( cmstlimtm_idcode, 0x00, sizeof( cmstlimtm_idcode ) ) ;
	cmstlimtm_idcode_id = 0 ;
	memset( cmstlimtm_custname, 0x00, sizeof( cmstlimtm_custname ) ) ;
	cmstlimtm_custname_id = 0 ;
	memset( cmstlimtm_issuebrc, 0x00, sizeof( cmstlimtm_issuebrc ) ) ;
	cmstlimtm_issuebrc_id = 0 ;
	memset( cmstlimtm_teller, 0x00, sizeof( cmstlimtm_teller ) ) ;
	cmstlimtm_teller_id = 0 ;
	memset( cmstlimtm_cardkind, 0x00, sizeof( cmstlimtm_cardkind ) ) ;
	cmstlimtm_cardkind_id = 0 ;
	memset( cmstlimtm_lmtbrc, 0x00, sizeof( cmstlimtm_lmtbrc ) ) ;
	cmstlimtm_lmtbrc_id = 0 ;
	memset( cmstlimtm_lmtteller, 0x00, sizeof( cmstlimtm_lmtteller ) ) ;
	cmstlimtm_lmtteller_id = 0 ;
	memset( cmstlimtm_lmtauthteller, 0x00, sizeof( cmstlimtm_lmtauthteller ) ) ;
	cmstlimtm_lmtauthteller_id = 0 ;
}

void pubStoVCmstlimtm( struct cmstlimtm * pstCmstlimtm )
{
	pubInitCmstlimtm();
	if( !strlen( pstCmstlimtm->cardno ) )
		strcpy( pstCmstlimtm->cardno, " " );
	strcpy( cmstlimtm_cardno, pstCmstlimtm->cardno );
	if( !strlen( pstCmstlimtm->trandate ) )
		strcpy( pstCmstlimtm->trandate, " " );
	strcpy( cmstlimtm_trandate, pstCmstlimtm->trandate );
	cmstlimtm_serseqno = pstCmstlimtm->serseqno ;
	if( !strlen( pstCmstlimtm->vouchno ) )
		strcpy( pstCmstlimtm->vouchno, " " );
	strcpy( cmstlimtm_vouchno, pstCmstlimtm->vouchno );
	if( !strlen( pstCmstlimtm->trandevtype ) )
		strcpy( pstCmstlimtm->trandevtype, " " );
	strcpy( cmstlimtm_trandevtype, pstCmstlimtm->trandevtype );
	if( !strlen( pstCmstlimtm->ccy ) )
		strcpy( pstCmstlimtm->ccy, " " );
	strcpy( cmstlimtm_ccy, pstCmstlimtm->ccy );
	cmstlimtm_period = pstCmstlimtm->period ;
	cmstlimtm_cashlimitamt = pstCmstlimtm->cashlimitamt ;
	pubDround( &cmstlimtm_cashlimitamt, 2 );
	cmstlimtm_depolimitamt = pstCmstlimtm->depolimitamt ;
	pubDround( &cmstlimtm_depolimitamt, 2 );
	cmstlimtm_conlimitamt = pstCmstlimtm->conlimitamt ;
	pubDround( &cmstlimtm_conlimitamt, 2 );
	cmstlimtm_tranoutlimitamt = pstCmstlimtm->tranoutlimitamt ;
	pubDround( &cmstlimtm_tranoutlimitamt, 2 );
	cmstlimtm_cashlimittime = pstCmstlimtm->cashlimittime ;
	cmstlimtm_depolimittime = pstCmstlimtm->depolimittime ;
	cmstlimtm_conlimittime = pstCmstlimtm->conlimittime ;
	cmstlimtm_tranoutlimittime = pstCmstlimtm->tranoutlimittime ;
	if( !strlen( pstCmstlimtm->idtype ) )
		strcpy( pstCmstlimtm->idtype, " " );
	strcpy( cmstlimtm_idtype, pstCmstlimtm->idtype );
	if( !strlen( pstCmstlimtm->idcode ) )
		strcpy( pstCmstlimtm->idcode, " " );
	strcpy( cmstlimtm_idcode, pstCmstlimtm->idcode );
	if( !strlen( pstCmstlimtm->custname ) )
		strcpy( pstCmstlimtm->custname, " " );
	strcpy( cmstlimtm_custname, pstCmstlimtm->custname );
	if( !strlen( pstCmstlimtm->issuebrc ) )
		strcpy( pstCmstlimtm->issuebrc, " " );
	strcpy( cmstlimtm_issuebrc, pstCmstlimtm->issuebrc );
	if( !strlen( pstCmstlimtm->teller ) )
		strcpy( pstCmstlimtm->teller, " " );
	strcpy( cmstlimtm_teller, pstCmstlimtm->teller );
	if( !strlen( pstCmstlimtm->cardkind ) )
		strcpy( pstCmstlimtm->cardkind, " " );
	strcpy( cmstlimtm_cardkind, pstCmstlimtm->cardkind );
	if( !strlen( pstCmstlimtm->lmtbrc ) )
		strcpy( pstCmstlimtm->lmtbrc, " " );
	strcpy( cmstlimtm_lmtbrc, pstCmstlimtm->lmtbrc );
	if( !strlen( pstCmstlimtm->lmtteller ) )
		strcpy( pstCmstlimtm->lmtteller, " " );
	strcpy( cmstlimtm_lmtteller, pstCmstlimtm->lmtteller );
	if( !strlen( pstCmstlimtm->lmtauthteller ) )
		strcpy( pstCmstlimtm->lmtauthteller, " " );
	strcpy( cmstlimtm_lmtauthteller, pstCmstlimtm->lmtauthteller );
}

void pubVtoSCmstlimtm( struct cmstlimtm * pstCmstlimtm )
{
	strcpy( pstCmstlimtm->cardno, cmstlimtm_cardno );
	strpack( pstCmstlimtm->cardno );
	strcpy( pstCmstlimtm->trandate, cmstlimtm_trandate );
	strpack( pstCmstlimtm->trandate );
	pstCmstlimtm->serseqno = cmstlimtm_serseqno ;
	strcpy( pstCmstlimtm->vouchno, cmstlimtm_vouchno );
	strpack( pstCmstlimtm->vouchno );
	strcpy( pstCmstlimtm->trandevtype, cmstlimtm_trandevtype );
	strpack( pstCmstlimtm->trandevtype );
	strcpy( pstCmstlimtm->ccy, cmstlimtm_ccy );
	strpack( pstCmstlimtm->ccy );
	pstCmstlimtm->period = cmstlimtm_period ;
	pstCmstlimtm->cashlimitamt = cmstlimtm_cashlimitamt ;
	pubDround( &pstCmstlimtm->cashlimitamt, 2 );
	pstCmstlimtm->depolimitamt = cmstlimtm_depolimitamt ;
	pubDround( &pstCmstlimtm->depolimitamt, 2 );
	pstCmstlimtm->conlimitamt = cmstlimtm_conlimitamt ;
	pubDround( &pstCmstlimtm->conlimitamt, 2 );
	pstCmstlimtm->tranoutlimitamt = cmstlimtm_tranoutlimitamt ;
	pubDround( &pstCmstlimtm->tranoutlimitamt, 2 );
	pstCmstlimtm->cashlimittime = cmstlimtm_cashlimittime ;
	pstCmstlimtm->depolimittime = cmstlimtm_depolimittime ;
	pstCmstlimtm->conlimittime = cmstlimtm_conlimittime ;
	pstCmstlimtm->tranoutlimittime = cmstlimtm_tranoutlimittime ;
	strcpy( pstCmstlimtm->idtype, cmstlimtm_idtype );
	strpack( pstCmstlimtm->idtype );
	strcpy( pstCmstlimtm->idcode, cmstlimtm_idcode );
	strpack( pstCmstlimtm->idcode );
	strcpy( pstCmstlimtm->custname, cmstlimtm_custname );
	strpack( pstCmstlimtm->custname );
	strcpy( pstCmstlimtm->issuebrc, cmstlimtm_issuebrc );
	strpack( pstCmstlimtm->issuebrc );
	strcpy( pstCmstlimtm->teller, cmstlimtm_teller );
	strpack( pstCmstlimtm->teller );
	strcpy( pstCmstlimtm->cardkind, cmstlimtm_cardkind );
	strpack( pstCmstlimtm->cardkind );
	strcpy( pstCmstlimtm->lmtbrc, cmstlimtm_lmtbrc );
	strpack( pstCmstlimtm->lmtbrc );
	strcpy( pstCmstlimtm->lmtteller, cmstlimtm_lmtteller );
	strpack( pstCmstlimtm->lmtteller );
	strcpy( pstCmstlimtm->lmtauthteller, cmstlimtm_lmtauthteller );
	strpack( pstCmstlimtm->lmtauthteller );
}

int pubReadCmstlimtm( struct cmstlimtm * pstCmstlimtm )
{
	pubInitCmstlimtm();
	pubStoVCmstlimtm(pstCmstlimtm);
	EXEC SQL SELECT * INTO RR_CMSTLIMTM 
		FROM cmstlimtm  
		WHERE  
		 cardno = :cmstlimtm_cardno and 
		 trandate = :cmstlimtm_trandate and 
		 serseqno = :cmstlimtm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmstlimtm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmstlimtm(pstCmstlimtm);
	return 0; 
} 
 
int pubModiCmstlimtm( struct cmstlimtm * pstCmstlimtm )
{
	pubInitCmstlimtm();
	pubStoVCmstlimtm(pstCmstlimtm);
	EXEC SQL UPDATE cmstlimtm 
		SET ( UU_CMSTLIMTM ) = ( WW_CMSTLIMTM ) 
		WHERE  
		 cardno = :cmstlimtm_cardno and 
		 trandate = :cmstlimtm_trandate and 
		 serseqno = :cmstlimtm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmstlimtm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmstlimtm( struct cmstlimtm * pstCmstlimtm )
{
	pubInitCmstlimtm();
	pubStoVCmstlimtm(pstCmstlimtm);
	EXEC SQL INSERT INTO cmstlimtm VALUES ( RR_CMSTLIMTM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmstlimtm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}