tbcms057.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 cmschoosereg_trandate[11];
	short cmschoosereg_trandate_id;
	long cmschoosereg_serseqno;
	short cmschoosereg_serseqno_id;
	char cmschoosereg_brc[10];
	short cmschoosereg_brc_id;
	char cmschoosereg_teller[11];
	short cmschoosereg_teller_id;
	char cmschoosereg_cardkind[9];
	short cmschoosereg_cardkind_id;
	char cmschoosereg_vouno[21];
	short cmschoosereg_vouno_id;
	long cmschoosereg_cardseqno;
	short cmschoosereg_cardseqno_id;
	char cmschoosereg_areacode[5];
	short cmschoosereg_areacode_id;
	char cmschoosereg_voukind[4];
	short cmschoosereg_voukind_id;
	char cmschoosereg_precharcode[7];
	short cmschoosereg_precharcode_id;
	char cmschoosereg_cardno[20];
	short cmschoosereg_cardno_id;
	char cmschoosereg_customid[31];
	short cmschoosereg_customid_id;
	char cmschoosereg_customname[71];
	short cmschoosereg_customname_id;
	char cmschoosereg_validf[2];
	short cmschoosereg_validf_id;
	char cmschoosereg_note[51];
	short cmschoosereg_note_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCHOOSEREG \
		:cmschoosereg_trandate:cmschoosereg_trandate_id, \
		:cmschoosereg_serseqno:cmschoosereg_serseqno_id, \
		:cmschoosereg_brc:cmschoosereg_brc_id, \
		:cmschoosereg_teller:cmschoosereg_teller_id, \
		:cmschoosereg_cardkind:cmschoosereg_cardkind_id, \
		:cmschoosereg_vouno:cmschoosereg_vouno_id, \
		:cmschoosereg_cardseqno:cmschoosereg_cardseqno_id, \
		:cmschoosereg_areacode:cmschoosereg_areacode_id, \
		:cmschoosereg_voukind:cmschoosereg_voukind_id, \
		:cmschoosereg_precharcode:cmschoosereg_precharcode_id, \
		:cmschoosereg_cardno:cmschoosereg_cardno_id, \
		:cmschoosereg_customid:cmschoosereg_customid_id, \
		:cmschoosereg_customname:cmschoosereg_customname_id, \
		:cmschoosereg_validf:cmschoosereg_validf_id, \
		:cmschoosereg_note:cmschoosereg_note_id

#define UU_CMSCHOOSEREG \
		trandate, \
		serseqno, \
		brc, \
		teller, \
		cardkind, \
		vouno, \
		cardseqno, \
		areacode, \
		voukind, \
		precharcode, \
		cardno, \
		customid, \
		customname, \
		validf, \
		note

#define WW_CMSCHOOSEREG \
		:cmschoosereg_trandate, \
		:cmschoosereg_serseqno, \
		:cmschoosereg_brc, \
		:cmschoosereg_teller, \
		:cmschoosereg_cardkind, \
		:cmschoosereg_vouno, \
		:cmschoosereg_cardseqno, \
		:cmschoosereg_areacode, \
		:cmschoosereg_voukind, \
		:cmschoosereg_precharcode, \
		:cmschoosereg_cardno, \
		:cmschoosereg_customid, \
		:cmschoosereg_customname, \
		:cmschoosereg_validf, \
		:cmschoosereg_note

struct cmschoosereg
{
	char	trandate[11];
	long	serseqno;
	char	brc[10];
	char	teller[11];
	char	cardkind[9];
	char	vouno[21];
	long	cardseqno;
	char	areacode[5];
	char	voukind[4];
	char	precharcode[7];
	char	cardno[20];
	char	customid[31];
	char	customname[71];
	char	validf[2];
	char	note[51];
};

void pubInitCmschoosereg()
{
	memset( cmschoosereg_trandate, 0x00, sizeof( cmschoosereg_trandate ) ) ;
	cmschoosereg_trandate_id = 0 ;
	memset( &cmschoosereg_serseqno, 0x00, sizeof( cmschoosereg_serseqno ) ) ;
	cmschoosereg_serseqno_id = 0 ;
	memset( cmschoosereg_brc, 0x00, sizeof( cmschoosereg_brc ) ) ;
	cmschoosereg_brc_id = 0 ;
	memset( cmschoosereg_teller, 0x00, sizeof( cmschoosereg_teller ) ) ;
	cmschoosereg_teller_id = 0 ;
	memset( cmschoosereg_cardkind, 0x00, sizeof( cmschoosereg_cardkind ) ) ;
	cmschoosereg_cardkind_id = 0 ;
	memset( cmschoosereg_vouno, 0x00, sizeof( cmschoosereg_vouno ) ) ;
	cmschoosereg_vouno_id = 0 ;
	memset( &cmschoosereg_cardseqno, 0x00, sizeof( cmschoosereg_cardseqno ) ) ;
	cmschoosereg_cardseqno_id = 0 ;
	memset( cmschoosereg_areacode, 0x00, sizeof( cmschoosereg_areacode ) ) ;
	cmschoosereg_areacode_id = 0 ;
	memset( cmschoosereg_voukind, 0x00, sizeof( cmschoosereg_voukind ) ) ;
	cmschoosereg_voukind_id = 0 ;
	memset( cmschoosereg_precharcode, 0x00, sizeof( cmschoosereg_precharcode ) ) ;
	cmschoosereg_precharcode_id = 0 ;
	memset( cmschoosereg_cardno, 0x00, sizeof( cmschoosereg_cardno ) ) ;
	cmschoosereg_cardno_id = 0 ;
	memset( cmschoosereg_customid, 0x00, sizeof( cmschoosereg_customid ) ) ;
	cmschoosereg_customid_id = 0 ;
	memset( cmschoosereg_customname, 0x00, sizeof( cmschoosereg_customname ) ) ;
	cmschoosereg_customname_id = 0 ;
	memset( cmschoosereg_validf, 0x00, sizeof( cmschoosereg_validf ) ) ;
	cmschoosereg_validf_id = 0 ;
	memset( cmschoosereg_note, 0x00, sizeof( cmschoosereg_note ) ) ;
	cmschoosereg_note_id = 0 ;
}

void pubStoVCmschoosereg( struct cmschoosereg * pstCmschoosereg )
{
	pubInitCmschoosereg();
	if( !strlen( pstCmschoosereg->trandate ) )
		strcpy( pstCmschoosereg->trandate, " " );
	strcpy( cmschoosereg_trandate, pstCmschoosereg->trandate );
	cmschoosereg_serseqno = pstCmschoosereg->serseqno ;
	if( !strlen( pstCmschoosereg->brc ) )
		strcpy( pstCmschoosereg->brc, " " );
	strcpy( cmschoosereg_brc, pstCmschoosereg->brc );
	if( !strlen( pstCmschoosereg->teller ) )
		strcpy( pstCmschoosereg->teller, " " );
	strcpy( cmschoosereg_teller, pstCmschoosereg->teller );
	if( !strlen( pstCmschoosereg->cardkind ) )
		strcpy( pstCmschoosereg->cardkind, " " );
	strcpy( cmschoosereg_cardkind, pstCmschoosereg->cardkind );
	if( !strlen( pstCmschoosereg->vouno ) )
		strcpy( pstCmschoosereg->vouno, " " );
	strcpy( cmschoosereg_vouno, pstCmschoosereg->vouno );
	cmschoosereg_cardseqno = pstCmschoosereg->cardseqno ;
	if( !strlen( pstCmschoosereg->areacode ) )
		strcpy( pstCmschoosereg->areacode, " " );
	strcpy( cmschoosereg_areacode, pstCmschoosereg->areacode );
	if( !strlen( pstCmschoosereg->voukind ) )
		strcpy( pstCmschoosereg->voukind, " " );
	strcpy( cmschoosereg_voukind, pstCmschoosereg->voukind );
	if( !strlen( pstCmschoosereg->precharcode ) )
		strcpy( pstCmschoosereg->precharcode, " " );
	strcpy( cmschoosereg_precharcode, pstCmschoosereg->precharcode );
	if( !strlen( pstCmschoosereg->cardno ) )
		strcpy( pstCmschoosereg->cardno, " " );
	strcpy( cmschoosereg_cardno, pstCmschoosereg->cardno );
	if( !strlen( pstCmschoosereg->customid ) )
		strcpy( pstCmschoosereg->customid, " " );
	strcpy( cmschoosereg_customid, pstCmschoosereg->customid );
	if( !strlen( pstCmschoosereg->customname ) )
		strcpy( pstCmschoosereg->customname, " " );
	strcpy( cmschoosereg_customname, pstCmschoosereg->customname );
	if( !strlen( pstCmschoosereg->validf ) )
		strcpy( pstCmschoosereg->validf, " " );
	strcpy( cmschoosereg_validf, pstCmschoosereg->validf );
	if( !strlen( pstCmschoosereg->note ) )
		strcpy( pstCmschoosereg->note, " " );
	strcpy( cmschoosereg_note, pstCmschoosereg->note );
}

void pubVtoSCmschoosereg( struct cmschoosereg * pstCmschoosereg )
{
	strcpy( pstCmschoosereg->trandate, cmschoosereg_trandate );
	strpack( pstCmschoosereg->trandate );
	pstCmschoosereg->serseqno = cmschoosereg_serseqno ;
	strcpy( pstCmschoosereg->brc, cmschoosereg_brc );
	strpack( pstCmschoosereg->brc );
	strcpy( pstCmschoosereg->teller, cmschoosereg_teller );
	strpack( pstCmschoosereg->teller );
	strcpy( pstCmschoosereg->cardkind, cmschoosereg_cardkind );
	strpack( pstCmschoosereg->cardkind );
	strcpy( pstCmschoosereg->vouno, cmschoosereg_vouno );
	strpack( pstCmschoosereg->vouno );
	pstCmschoosereg->cardseqno = cmschoosereg_cardseqno ;
	strcpy( pstCmschoosereg->areacode, cmschoosereg_areacode );
	strpack( pstCmschoosereg->areacode );
	strcpy( pstCmschoosereg->voukind, cmschoosereg_voukind );
	strpack( pstCmschoosereg->voukind );
	strcpy( pstCmschoosereg->precharcode, cmschoosereg_precharcode );
	strpack( pstCmschoosereg->precharcode );
	strcpy( pstCmschoosereg->cardno, cmschoosereg_cardno );
	strpack( pstCmschoosereg->cardno );
	strcpy( pstCmschoosereg->customid, cmschoosereg_customid );
	strpack( pstCmschoosereg->customid );
	strcpy( pstCmschoosereg->customname, cmschoosereg_customname );
	strpack( pstCmschoosereg->customname );
	strcpy( pstCmschoosereg->validf, cmschoosereg_validf );
	strpack( pstCmschoosereg->validf );
	strcpy( pstCmschoosereg->note, cmschoosereg_note );
	strpack( pstCmschoosereg->note );
}



int pubReadCmschoosereg( struct cmschoosereg * pstCmschoosereg )
{
	pubInitCmschoosereg();
	pubStoVCmschoosereg(pstCmschoosereg);
	EXEC SQL SELECT * INTO RR_CMSCHOOSEREG 
		FROM cmschoosereg  
		WHERE  
		 trandate = :cmschoosereg_trandate and 
		 serseqno = :cmschoosereg_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmschoosereg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmschoosereg(pstCmschoosereg);
	return 0; 
} 
 


int pubModiCmschoosereg( struct cmschoosereg * pstCmschoosereg )
{
	pubInitCmschoosereg();
	pubStoVCmschoosereg(pstCmschoosereg);
	EXEC SQL UPDATE cmschoosereg 
		SET ( UU_CMSCHOOSEREG ) = ( WW_CMSCHOOSEREG ) 
		WHERE  
		 trandate = :cmschoosereg_trandate and 
		 serseqno = :cmschoosereg_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmschoosereg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmschoosereg( struct cmschoosereg * pstCmschoosereg )
{
	pubInitCmschoosereg();
	pubStoVCmschoosereg(pstCmschoosereg);
	EXEC SQL INSERT INTO cmschoosereg VALUES ( RR_CMSCHOOSEREG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmschoosereg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
} 
void pubTracCmschoosereg( struct cmschoosereg * pstCmschoosereg )
{
	sprintf( g_acTrcMsg, "cmschoosereg:trandate=[%s]", pstCmschoosereg->trandate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:serseqno=[%d]", pstCmschoosereg->serseqno) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:brc=[%s]", pstCmschoosereg->brc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:teller=[%s]", pstCmschoosereg->teller );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:cardkind=[%s]", pstCmschoosereg->cardkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:vouno=[%s]", pstCmschoosereg->vouno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:cardseqno=[%d]", pstCmschoosereg->cardseqno) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:areacode=[%s]", pstCmschoosereg->areacode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:voukind=[%s]", pstCmschoosereg->voukind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:precharcode=[%s]", pstCmschoosereg->precharcode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:cardno=[%s]", pstCmschoosereg->cardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:customid=[%s]", pstCmschoosereg->customid );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:customname=[%s]", pstCmschoosereg->customname );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:validf=[%s]", pstCmschoosereg->validf );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmschoosereg:note=[%s]", pstCmschoosereg->note );
	TRCLOG1
}