tbcms030.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 cmslmtm_cardno[20];
	short cmslmtm_cardno_id;
	char cmslmtm_trandate[11];
	short cmslmtm_trandate_id;
	long cmslmtm_serseqno;
	short cmslmtm_serseqno_id;
	char cmslmtm_vouchno[17];
	short cmslmtm_vouchno_id;
	char cmslmtm_acdcardno[20];
	short cmslmtm_acdcardno_id;
	char cmslmtm_idtype[3];
	short cmslmtm_idtype_id;
	char cmslmtm_idcode[21];
	short cmslmtm_idcode_id;
	char cmslmtm_custname[71];
	short cmslmtm_custname_id;
	char cmslmtm_issuebrc[10];
	short cmslmtm_issuebrc_id;
	char cmslmtm_teller[11];
	short cmslmtm_teller_id;
	char cmslmtm_cardkind[9];
	short cmslmtm_cardkind_id;
	char cmslmtm_lmtbrc[10];
	short cmslmtm_lmtbrc_id;
	char cmslmtm_lmtteller[11];
	short cmslmtm_lmtteller_id;
	char cmslmtm_lmtauthteller[11];
	short cmslmtm_lmtauthteller_id;
	char cmslmtm_trandevtype[3];
	short cmslmtm_trandevtype_id;
	char cmslmtm_ccy[4];
	short cmslmtm_ccy_id;
	long cmslmtm_period;
	short cmslmtm_period_id;
	double cmslmtm_cashlimitamt;
	short cmslmtm_cashlimitamt_id;
	double cmslmtm_depolimitamt;
	short cmslmtm_depolimitamt_id;
	double cmslmtm_conlimitamt;
	short cmslmtm_conlimitamt_id;
	double cmslmtm_tranoutlimitamt;
	short cmslmtm_tranoutlimitamt_id;
	long cmslmtm_cashlimittime;
	short cmslmtm_cashlimittime_id;
	long cmslmtm_depolimittime;
	short cmslmtm_depolimittime_id;
	long cmslmtm_conlimittime;
	short cmslmtm_conlimittime_id;
	long cmslmtm_tranoutlimittime;
	short cmslmtm_tranoutlimittime_id;
	double cmslmtm_lmtamt;
	short cmslmtm_lmtamt_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSLMTM \
		:cmslmtm_cardno:cmslmtm_cardno_id, \
		:cmslmtm_trandate:cmslmtm_trandate_id, \
		:cmslmtm_serseqno:cmslmtm_serseqno_id, \
		:cmslmtm_vouchno:cmslmtm_vouchno_id, \
		:cmslmtm_acdcardno:cmslmtm_acdcardno_id, \
		:cmslmtm_idtype:cmslmtm_idtype_id, \
		:cmslmtm_idcode:cmslmtm_idcode_id, \
		:cmslmtm_custname:cmslmtm_custname_id, \
		:cmslmtm_issuebrc:cmslmtm_issuebrc_id, \
		:cmslmtm_teller:cmslmtm_teller_id, \
		:cmslmtm_cardkind:cmslmtm_cardkind_id, \
		:cmslmtm_lmtbrc:cmslmtm_lmtbrc_id, \
		:cmslmtm_lmtteller:cmslmtm_lmtteller_id, \
		:cmslmtm_lmtauthteller:cmslmtm_lmtauthteller_id, \
		:cmslmtm_trandevtype:cmslmtm_trandevtype_id, \
		:cmslmtm_ccy:cmslmtm_ccy_id, \
		:cmslmtm_period:cmslmtm_period_id, \
		:cmslmtm_cashlimitamt:cmslmtm_cashlimitamt_id, \
		:cmslmtm_depolimitamt:cmslmtm_depolimitamt_id, \
		:cmslmtm_conlimitamt:cmslmtm_conlimitamt_id, \
		:cmslmtm_tranoutlimitamt:cmslmtm_tranoutlimitamt_id, \
		:cmslmtm_cashlimittime:cmslmtm_cashlimittime_id, \
		:cmslmtm_depolimittime:cmslmtm_depolimittime_id, \
		:cmslmtm_conlimittime:cmslmtm_conlimittime_id, \
		:cmslmtm_tranoutlimittime:cmslmtm_tranoutlimittime_id, \
		:cmslmtm_lmtamt:cmslmtm_lmtamt_id

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

#define WW_CMSLMTM \
		:cmslmtm_cardno, \
		:cmslmtm_trandate, \
		:cmslmtm_serseqno, \
		:cmslmtm_vouchno, \
		:cmslmtm_acdcardno, \
		:cmslmtm_idtype, \
		:cmslmtm_idcode, \
		:cmslmtm_custname, \
		:cmslmtm_issuebrc, \
		:cmslmtm_teller, \
		:cmslmtm_cardkind, \
		:cmslmtm_lmtbrc, \
		:cmslmtm_lmtteller, \
		:cmslmtm_lmtauthteller, \
		:cmslmtm_trandevtype, \
		:cmslmtm_ccy, \
		:cmslmtm_period, \
		:cmslmtm_cashlimitamt, \
		:cmslmtm_depolimitamt, \
		:cmslmtm_conlimitamt, \
		:cmslmtm_tranoutlimitamt, \
		:cmslmtm_cashlimittime, \
		:cmslmtm_depolimittime, \
		:cmslmtm_conlimittime, \
		:cmslmtm_tranoutlimittime, \
		:cmslmtm_lmtamt

struct cmslmtm
{
	char	cardno[20];
	char	trandate[11];
	long	serseqno;
	char	vouchno[17];
	char	acdcardno[20];
	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];
	char	trandevtype[3];
	char	ccy[4];
	long	period;
	double	cashlimitamt;
	double	depolimitamt;
	double	conlimitamt;
	double	tranoutlimitamt;
	long	cashlimittime;
	long	depolimittime;
	long	conlimittime;
	long	tranoutlimittime;
	double	lmtamt;
};

void pubInitCmslmtm()
{
	memset( cmslmtm_cardno, 0x00, sizeof( cmslmtm_cardno ) ) ;
	cmslmtm_cardno_id = 0 ;
	memset( cmslmtm_trandate, 0x00, sizeof( cmslmtm_trandate ) ) ;
	cmslmtm_trandate_id = 0 ;
	memset( &cmslmtm_serseqno, 0x00, sizeof( cmslmtm_serseqno ) ) ;
	cmslmtm_serseqno_id = 0 ;
	memset( cmslmtm_vouchno, 0x00, sizeof( cmslmtm_vouchno ) ) ;
	cmslmtm_vouchno_id = 0 ;
	memset( cmslmtm_acdcardno, 0x00, sizeof( cmslmtm_acdcardno ) ) ;
	cmslmtm_acdcardno_id = 0 ;
	memset( cmslmtm_idtype, 0x00, sizeof( cmslmtm_idtype ) ) ;
	cmslmtm_idtype_id = 0 ;
	memset( cmslmtm_idcode, 0x00, sizeof( cmslmtm_idcode ) ) ;
	cmslmtm_idcode_id = 0 ;
	memset( cmslmtm_custname, 0x00, sizeof( cmslmtm_custname ) ) ;
	cmslmtm_custname_id = 0 ;
	memset( cmslmtm_issuebrc, 0x00, sizeof( cmslmtm_issuebrc ) ) ;
	cmslmtm_issuebrc_id = 0 ;
	memset( cmslmtm_teller, 0x00, sizeof( cmslmtm_teller ) ) ;
	cmslmtm_teller_id = 0 ;
	memset( cmslmtm_cardkind, 0x00, sizeof( cmslmtm_cardkind ) ) ;
	cmslmtm_cardkind_id = 0 ;
	memset( cmslmtm_lmtbrc, 0x00, sizeof( cmslmtm_lmtbrc ) ) ;
	cmslmtm_lmtbrc_id = 0 ;
	memset( cmslmtm_lmtteller, 0x00, sizeof( cmslmtm_lmtteller ) ) ;
	cmslmtm_lmtteller_id = 0 ;
	memset( cmslmtm_lmtauthteller, 0x00, sizeof( cmslmtm_lmtauthteller ) ) ;
	cmslmtm_lmtauthteller_id = 0 ;
	memset( cmslmtm_trandevtype, 0x00, sizeof( cmslmtm_trandevtype ) ) ;
	cmslmtm_trandevtype_id = 0 ;
	memset( cmslmtm_ccy, 0x00, sizeof( cmslmtm_ccy ) ) ;
	cmslmtm_ccy_id = 0 ;
	memset( &cmslmtm_period, 0x00, sizeof( cmslmtm_period ) ) ;
	cmslmtm_period_id = 0 ;
	memset( &cmslmtm_cashlimitamt, 0x00, sizeof( cmslmtm_cashlimitamt ) ) ;
	cmslmtm_cashlimitamt_id = 0 ;
	memset( &cmslmtm_depolimitamt, 0x00, sizeof( cmslmtm_depolimitamt ) ) ;
	cmslmtm_depolimitamt_id = 0 ;
	memset( &cmslmtm_conlimitamt, 0x00, sizeof( cmslmtm_conlimitamt ) ) ;
	cmslmtm_conlimitamt_id = 0 ;
	memset( &cmslmtm_tranoutlimitamt, 0x00, sizeof( cmslmtm_tranoutlimitamt ) ) ;
	cmslmtm_tranoutlimitamt_id = 0 ;
	memset( &cmslmtm_cashlimittime, 0x00, sizeof( cmslmtm_cashlimittime ) ) ;
	cmslmtm_cashlimittime_id = 0 ;
	memset( &cmslmtm_depolimittime, 0x00, sizeof( cmslmtm_depolimittime ) ) ;
	cmslmtm_depolimittime_id = 0 ;
	memset( &cmslmtm_conlimittime, 0x00, sizeof( cmslmtm_conlimittime ) ) ;
	cmslmtm_conlimittime_id = 0 ;
	memset( &cmslmtm_tranoutlimittime, 0x00, sizeof( cmslmtm_tranoutlimittime ) ) ;
	cmslmtm_tranoutlimittime_id = 0 ;
	memset( &cmslmtm_lmtamt, 0x00, sizeof( cmslmtm_lmtamt ) ) ;
	cmslmtm_lmtamt_id = 0 ;
}

void pubStoVCmslmtm( struct cmslmtm * pstCmslmtm )
{
	pubInitCmslmtm();
	if( !strlen( pstCmslmtm->cardno ) )
		strcpy( pstCmslmtm->cardno, " " );
	strcpy( cmslmtm_cardno, pstCmslmtm->cardno );
	if( !strlen( pstCmslmtm->trandate ) )
		strcpy( pstCmslmtm->trandate, " " );
	strcpy( cmslmtm_trandate, pstCmslmtm->trandate );
	cmslmtm_serseqno = pstCmslmtm->serseqno ;
	if( !strlen( pstCmslmtm->vouchno ) )
		strcpy( pstCmslmtm->vouchno, " " );
	strcpy( cmslmtm_vouchno, pstCmslmtm->vouchno );
	if( !strlen( pstCmslmtm->acdcardno ) )
		strcpy( pstCmslmtm->acdcardno, " " );
	strcpy( cmslmtm_acdcardno, pstCmslmtm->acdcardno );
	if( !strlen( pstCmslmtm->idtype ) )
		strcpy( pstCmslmtm->idtype, " " );
	strcpy( cmslmtm_idtype, pstCmslmtm->idtype );
	if( !strlen( pstCmslmtm->idcode ) )
		strcpy( pstCmslmtm->idcode, " " );
	strcpy( cmslmtm_idcode, pstCmslmtm->idcode );
	if( !strlen( pstCmslmtm->custname ) )
		strcpy( pstCmslmtm->custname, " " );
	strcpy( cmslmtm_custname, pstCmslmtm->custname );
	if( !strlen( pstCmslmtm->issuebrc ) )
		strcpy( pstCmslmtm->issuebrc, " " );
	strcpy( cmslmtm_issuebrc, pstCmslmtm->issuebrc );
	if( !strlen( pstCmslmtm->teller ) )
		strcpy( pstCmslmtm->teller, " " );
	strcpy( cmslmtm_teller, pstCmslmtm->teller );
	if( !strlen( pstCmslmtm->cardkind ) )
		strcpy( pstCmslmtm->cardkind, " " );
	strcpy( cmslmtm_cardkind, pstCmslmtm->cardkind );
	if( !strlen( pstCmslmtm->lmtbrc ) )
		strcpy( pstCmslmtm->lmtbrc, " " );
	strcpy( cmslmtm_lmtbrc, pstCmslmtm->lmtbrc );
	if( !strlen( pstCmslmtm->lmtteller ) )
		strcpy( pstCmslmtm->lmtteller, " " );
	strcpy( cmslmtm_lmtteller, pstCmslmtm->lmtteller );
	if( !strlen( pstCmslmtm->lmtauthteller ) )
		strcpy( pstCmslmtm->lmtauthteller, " " );
	strcpy( cmslmtm_lmtauthteller, pstCmslmtm->lmtauthteller );
	if( !strlen( pstCmslmtm->trandevtype ) )
		strcpy( pstCmslmtm->trandevtype, " " );
	strcpy( cmslmtm_trandevtype, pstCmslmtm->trandevtype );
	if( !strlen( pstCmslmtm->ccy ) )
		strcpy( pstCmslmtm->ccy, " " );
	strcpy( cmslmtm_ccy, pstCmslmtm->ccy );
	cmslmtm_period = pstCmslmtm->period ;
	cmslmtm_cashlimitamt = pstCmslmtm->cashlimitamt ;
	pubDround( &cmslmtm_cashlimitamt, 2 );
	cmslmtm_depolimitamt = pstCmslmtm->depolimitamt ;
	pubDround( &cmslmtm_depolimitamt, 2 );
	cmslmtm_conlimitamt = pstCmslmtm->conlimitamt ;
	pubDround( &cmslmtm_conlimitamt, 2 );
	cmslmtm_tranoutlimitamt = pstCmslmtm->tranoutlimitamt ;
	pubDround( &cmslmtm_tranoutlimitamt, 2 );
	cmslmtm_cashlimittime = pstCmslmtm->cashlimittime ;
	cmslmtm_depolimittime = pstCmslmtm->depolimittime ;
	cmslmtm_conlimittime = pstCmslmtm->conlimittime ;
	cmslmtm_tranoutlimittime = pstCmslmtm->tranoutlimittime ;
	cmslmtm_lmtamt = pstCmslmtm->lmtamt ;
	pubDround( &cmslmtm_lmtamt, 2 );
}

void pubVtoSCmslmtm( struct cmslmtm * pstCmslmtm )
{
	strcpy( pstCmslmtm->cardno, cmslmtm_cardno );
	strpack( pstCmslmtm->cardno );
	strcpy( pstCmslmtm->trandate, cmslmtm_trandate );
	strpack( pstCmslmtm->trandate );
	pstCmslmtm->serseqno = cmslmtm_serseqno ;
	strcpy( pstCmslmtm->vouchno, cmslmtm_vouchno );
	strpack( pstCmslmtm->vouchno );
	strcpy( pstCmslmtm->acdcardno, cmslmtm_acdcardno );
	strpack( pstCmslmtm->acdcardno );
	strcpy( pstCmslmtm->idtype, cmslmtm_idtype );
	strpack( pstCmslmtm->idtype );
	strcpy( pstCmslmtm->idcode, cmslmtm_idcode );
	strpack( pstCmslmtm->idcode );
	strcpy( pstCmslmtm->custname, cmslmtm_custname );
	strpack( pstCmslmtm->custname );
	strcpy( pstCmslmtm->issuebrc, cmslmtm_issuebrc );
	strpack( pstCmslmtm->issuebrc );
	strcpy( pstCmslmtm->teller, cmslmtm_teller );
	strpack( pstCmslmtm->teller );
	strcpy( pstCmslmtm->cardkind, cmslmtm_cardkind );
	strpack( pstCmslmtm->cardkind );
	strcpy( pstCmslmtm->lmtbrc, cmslmtm_lmtbrc );
	strpack( pstCmslmtm->lmtbrc );
	strcpy( pstCmslmtm->lmtteller, cmslmtm_lmtteller );
	strpack( pstCmslmtm->lmtteller );
	strcpy( pstCmslmtm->lmtauthteller, cmslmtm_lmtauthteller );
	strpack( pstCmslmtm->lmtauthteller );
	strcpy( pstCmslmtm->trandevtype, cmslmtm_trandevtype );
	strpack( pstCmslmtm->trandevtype );
	strcpy( pstCmslmtm->ccy, cmslmtm_ccy );
	strpack( pstCmslmtm->ccy );
	pstCmslmtm->period = cmslmtm_period ;
	pstCmslmtm->cashlimitamt = cmslmtm_cashlimitamt ;
	pubDround( &pstCmslmtm->cashlimitamt, 2 );
	pstCmslmtm->depolimitamt = cmslmtm_depolimitamt ;
	pubDround( &pstCmslmtm->depolimitamt, 2 );
	pstCmslmtm->conlimitamt = cmslmtm_conlimitamt ;
	pubDround( &pstCmslmtm->conlimitamt, 2 );
	pstCmslmtm->tranoutlimitamt = cmslmtm_tranoutlimitamt ;
	pubDround( &pstCmslmtm->tranoutlimitamt, 2 );
	pstCmslmtm->cashlimittime = cmslmtm_cashlimittime ;
	pstCmslmtm->depolimittime = cmslmtm_depolimittime ;
	pstCmslmtm->conlimittime = cmslmtm_conlimittime ;
	pstCmslmtm->tranoutlimittime = cmslmtm_tranoutlimittime ;
	pstCmslmtm->lmtamt = cmslmtm_lmtamt ;
	pubDround( &pstCmslmtm->lmtamt, 2 );
}

int pubReadCmslmtm( struct cmslmtm * pstCmslmtm )
{
	pubInitCmslmtm();
	pubStoVCmslmtm(pstCmslmtm);
	EXEC SQL SELECT * INTO RR_CMSLMTM 
		FROM cmslmtm  
		WHERE  
		 cardno = :cmslmtm_cardno and 
		 trandate = :cmslmtm_trandate and 
		 serseqno = :cmslmtm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmslmtm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmslmtm(pstCmslmtm);
	return 0; 
} 
 
int pubModiCmslmtm( struct cmslmtm * pstCmslmtm )
{
	pubInitCmslmtm();
	pubStoVCmslmtm(pstCmslmtm);
	EXEC SQL UPDATE cmslmtm 
		SET ( UU_CMSLMTM ) = ( WW_CMSLMTM ) 
		WHERE  
		 cardno = :cmslmtm_cardno and 
		 trandate = :cmslmtm_trandate and 
		 serseqno = :cmslmtm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmslmtm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmslmtm( struct cmslmtm * pstCmslmtm )
{
	pubInitCmslmtm();
	pubStoVCmslmtm(pstCmslmtm);
	EXEC SQL INSERT INTO cmslmtm VALUES ( RR_CMSLMTM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmslmtm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}