tbcms028.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 cmslockm_cardno[20];
	short cmslockm_cardno_id;
	char cmslockm_lockdate[11];
	short cmslockm_lockdate_id;
	long cmslockm_serseqno;
	short cmslockm_serseqno_id;
	char cmslockm_vouchno[17];
	short cmslockm_vouchno_id;
	char cmslockm_issuebrc[10];
	short cmslockm_issuebrc_id;
	char cmslockm_teller[11];
	short cmslockm_teller_id;
	char cmslockm_cardkind[9];
	short cmslockm_cardkind_id;
	char cmslockm_reason[41];
	short cmslockm_reason_id;
	char cmslockm_cncldate[11];
	short cmslockm_cncldate_id;
	char cmslockm_cnclbrc[10];
	short cmslockm_cnclbrc_id;
	char cmslockm_cnclteller[11];
	short cmslockm_cnclteller_id;
	long cmslockm_cnclserseqno;
	short cmslockm_cnclserseqno_id;
	char cmslockm_cnclauthteller[11];
	short cmslockm_cnclauthteller_id;
	char cmslockm_lockstat[2];
	short cmslockm_lockstat_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSLOCKM \
		:cmslockm_cardno:cmslockm_cardno_id, \
		:cmslockm_lockdate:cmslockm_lockdate_id, \
		:cmslockm_serseqno:cmslockm_serseqno_id, \
		:cmslockm_vouchno:cmslockm_vouchno_id, \
		:cmslockm_issuebrc:cmslockm_issuebrc_id, \
		:cmslockm_teller:cmslockm_teller_id, \
		:cmslockm_cardkind:cmslockm_cardkind_id, \
		:cmslockm_reason:cmslockm_reason_id, \
		:cmslockm_cncldate:cmslockm_cncldate_id, \
		:cmslockm_cnclbrc:cmslockm_cnclbrc_id, \
		:cmslockm_cnclteller:cmslockm_cnclteller_id, \
		:cmslockm_cnclserseqno:cmslockm_cnclserseqno_id, \
		:cmslockm_cnclauthteller:cmslockm_cnclauthteller_id, \
		:cmslockm_lockstat:cmslockm_lockstat_id

#define UU_CMSLOCKM \
		cardno, \
		lockdate, \
		serseqno, \
		vouchno, \
		issuebrc, \
		teller, \
		cardkind, \
		reason, \
		cncldate, \
		cnclbrc, \
		cnclteller, \
		cnclserseqno, \
		cnclauthteller, \
		lockstat

#define WW_CMSLOCKM \
		:cmslockm_cardno, \
		:cmslockm_lockdate, \
		:cmslockm_serseqno, \
		:cmslockm_vouchno, \
		:cmslockm_issuebrc, \
		:cmslockm_teller, \
		:cmslockm_cardkind, \
		:cmslockm_reason, \
		:cmslockm_cncldate, \
		:cmslockm_cnclbrc, \
		:cmslockm_cnclteller, \
		:cmslockm_cnclserseqno, \
		:cmslockm_cnclauthteller, \
		:cmslockm_lockstat

struct cmslockm
{
	char	cardno[20];
	char	lockdate[11];
	long	serseqno;
	char	vouchno[17];
	char	issuebrc[10];
	char	teller[11];
	char	cardkind[9];
	char	reason[41];
	char	cncldate[11];
	char	cnclbrc[10];
	char	cnclteller[11];
	long	cnclserseqno;
	char	cnclauthteller[11];
	char	lockstat[2];
};

void pubInitCmslockm()
{
	memset( cmslockm_cardno, 0x00, sizeof( cmslockm_cardno ) ) ;
	cmslockm_cardno_id = 0 ;
	memset( cmslockm_lockdate, 0x00, sizeof( cmslockm_lockdate ) ) ;
	cmslockm_lockdate_id = 0 ;
	memset( &cmslockm_serseqno, 0x00, sizeof( cmslockm_serseqno ) ) ;
	cmslockm_serseqno_id = 0 ;
	memset( cmslockm_vouchno, 0x00, sizeof( cmslockm_vouchno ) ) ;
	cmslockm_vouchno_id = 0 ;
	memset( cmslockm_issuebrc, 0x00, sizeof( cmslockm_issuebrc ) ) ;
	cmslockm_issuebrc_id = 0 ;
	memset( cmslockm_teller, 0x00, sizeof( cmslockm_teller ) ) ;
	cmslockm_teller_id = 0 ;
	memset( cmslockm_cardkind, 0x00, sizeof( cmslockm_cardkind ) ) ;
	cmslockm_cardkind_id = 0 ;
	memset( cmslockm_reason, 0x00, sizeof( cmslockm_reason ) ) ;
	cmslockm_reason_id = 0 ;
	memset( cmslockm_cncldate, 0x00, sizeof( cmslockm_cncldate ) ) ;
	cmslockm_cncldate_id = 0 ;
	memset( cmslockm_cnclbrc, 0x00, sizeof( cmslockm_cnclbrc ) ) ;
	cmslockm_cnclbrc_id = 0 ;
	memset( cmslockm_cnclteller, 0x00, sizeof( cmslockm_cnclteller ) ) ;
	cmslockm_cnclteller_id = 0 ;
	memset( &cmslockm_cnclserseqno, 0x00, sizeof( cmslockm_cnclserseqno ) ) ;
	cmslockm_cnclserseqno_id = 0 ;
	memset( cmslockm_cnclauthteller, 0x00, sizeof( cmslockm_cnclauthteller ) ) ;
	cmslockm_cnclauthteller_id = 0 ;
	memset( cmslockm_lockstat, 0x00, sizeof( cmslockm_lockstat ) ) ;
	cmslockm_lockstat_id = 0 ;
}

void pubStoVCmslockm( struct cmslockm * pstCmslockm )
{
	pubInitCmslockm();
	if( !strlen( pstCmslockm->cardno ) )
		strcpy( pstCmslockm->cardno, " " );
	strcpy( cmslockm_cardno, pstCmslockm->cardno );
	if( !strlen( pstCmslockm->lockdate ) )
		strcpy( pstCmslockm->lockdate, " " );
	strcpy( cmslockm_lockdate, pstCmslockm->lockdate );
	cmslockm_serseqno = pstCmslockm->serseqno ;
	if( !strlen( pstCmslockm->vouchno ) )
		strcpy( pstCmslockm->vouchno, " " );
	strcpy( cmslockm_vouchno, pstCmslockm->vouchno );
	if( !strlen( pstCmslockm->issuebrc ) )
		strcpy( pstCmslockm->issuebrc, " " );
	strcpy( cmslockm_issuebrc, pstCmslockm->issuebrc );
	if( !strlen( pstCmslockm->teller ) )
		strcpy( pstCmslockm->teller, " " );
	strcpy( cmslockm_teller, pstCmslockm->teller );
	if( !strlen( pstCmslockm->cardkind ) )
		strcpy( pstCmslockm->cardkind, " " );
	strcpy( cmslockm_cardkind, pstCmslockm->cardkind );
	if( !strlen( pstCmslockm->reason ) )
		strcpy( pstCmslockm->reason, " " );
	strcpy( cmslockm_reason, pstCmslockm->reason );
	if( !strlen( pstCmslockm->cncldate ) )
		strcpy( pstCmslockm->cncldate, " " );
	strcpy( cmslockm_cncldate, pstCmslockm->cncldate );
	if( !strlen( pstCmslockm->cnclbrc ) )
		strcpy( pstCmslockm->cnclbrc, " " );
	strcpy( cmslockm_cnclbrc, pstCmslockm->cnclbrc );
	if( !strlen( pstCmslockm->cnclteller ) )
		strcpy( pstCmslockm->cnclteller, " " );
	strcpy( cmslockm_cnclteller, pstCmslockm->cnclteller );
	cmslockm_cnclserseqno = pstCmslockm->cnclserseqno ;
	if( !strlen( pstCmslockm->cnclauthteller ) )
		strcpy( pstCmslockm->cnclauthteller, " " );
	strcpy( cmslockm_cnclauthteller, pstCmslockm->cnclauthteller );
	if( !strlen( pstCmslockm->lockstat ) )
		strcpy( pstCmslockm->lockstat, " " );
	strcpy( cmslockm_lockstat, pstCmslockm->lockstat );
}

void pubVtoSCmslockm( struct cmslockm * pstCmslockm )
{
	strcpy( pstCmslockm->cardno, cmslockm_cardno );
	strpack( pstCmslockm->cardno );
	strcpy( pstCmslockm->lockdate, cmslockm_lockdate );
	strpack( pstCmslockm->lockdate );
	pstCmslockm->serseqno = cmslockm_serseqno ;
	strcpy( pstCmslockm->vouchno, cmslockm_vouchno );
	strpack( pstCmslockm->vouchno );
	strcpy( pstCmslockm->issuebrc, cmslockm_issuebrc );
	strpack( pstCmslockm->issuebrc );
	strcpy( pstCmslockm->teller, cmslockm_teller );
	strpack( pstCmslockm->teller );
	strcpy( pstCmslockm->cardkind, cmslockm_cardkind );
	strpack( pstCmslockm->cardkind );
	strcpy( pstCmslockm->reason, cmslockm_reason );
	strpack( pstCmslockm->reason );
	strcpy( pstCmslockm->cncldate, cmslockm_cncldate );
	strpack( pstCmslockm->cncldate );
	strcpy( pstCmslockm->cnclbrc, cmslockm_cnclbrc );
	strpack( pstCmslockm->cnclbrc );
	strcpy( pstCmslockm->cnclteller, cmslockm_cnclteller );
	strpack( pstCmslockm->cnclteller );
	pstCmslockm->cnclserseqno = cmslockm_cnclserseqno ;
	strcpy( pstCmslockm->cnclauthteller, cmslockm_cnclauthteller );
	strpack( pstCmslockm->cnclauthteller );
	strcpy( pstCmslockm->lockstat, cmslockm_lockstat );
	strpack( pstCmslockm->lockstat );
}

int pubReadCmslockm( struct cmslockm * pstCmslockm )
{
	pubInitCmslockm();
	pubStoVCmslockm(pstCmslockm);
	EXEC SQL SELECT * INTO RR_CMSLOCKM 
		FROM cmslockm  
		WHERE  
		 cardno = :cmslockm_cardno and 
		 lockdate = :cmslockm_lockdate and 
		 serseqno = :cmslockm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmslockm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmslockm(pstCmslockm);
	return 0; 
} 
 
int pubModiCmslockm( struct cmslockm * pstCmslockm )
{
	pubInitCmslockm();
	pubStoVCmslockm(pstCmslockm);
	EXEC SQL UPDATE cmslockm 
		SET ( UU_CMSLOCKM ) = ( WW_CMSLOCKM ) 
		WHERE  
		 cardno = :cmslockm_cardno and 
		 lockdate = :cmslockm_lockdate and 
		 serseqno = :cmslockm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmslockm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmslockm( struct cmslockm * pstCmslockm )
{
	pubInitCmslockm();
	pubStoVCmslockm(pstCmslockm);
	EXEC SQL INSERT INTO cmslockm VALUES ( RR_CMSLOCKM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmslockm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}