tbcms019.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 cmspcdreg_aplydate[11];
	short cmspcdreg_aplydate_id;
	long cmspcdreg_serseqno;
	short cmspcdreg_serseqno_id;
	char cmspcdreg_vouchno[17];
	short cmspcdreg_vouchno_id;
	char cmspcdreg_wishdate[11];
	short cmspcdreg_wishdate_id;
	char cmspcdreg_aplybrc[10];
	short cmspcdreg_aplybrc_id;
	char cmspcdreg_aplyteller[11];
	short cmspcdreg_aplyteller_id;
	char cmspcdreg_authteller[11];
	short cmspcdreg_authteller_id;
	char cmspcdreg_cardkind[9];
	short cmspcdreg_cardkind_id;
	long cmspcdreg_aplynum;
	short cmspcdreg_aplynum_id;
	char cmspcdreg_scardno[20];
	short cmspcdreg_scardno_id;
	char cmspcdreg_ecardno[20];
	short cmspcdreg_ecardno_id;
	char cmspcdreg_voukind[4];
	short cmspcdreg_voukind_id;
	char cmspcdreg_svouno[21];
	short cmspcdreg_svouno_id;
	char cmspcdreg_evouno[21];
	short cmspcdreg_evouno_id;
	char cmspcdreg_custno[31];
	short cmspcdreg_custno_id;
	char cmspcdreg_custname[71];
	short cmspcdreg_custname_id;
	char cmspcdreg_aplyflg[2];
	short cmspcdreg_aplyflg_id;
	char cmspcdreg_dealdate[11];
	short cmspcdreg_dealdate_id;
	long cmspcdreg_dealseqno;
	short cmspcdreg_dealseqno_id;
	char cmspcdreg_applflg[2];
	short cmspcdreg_applflg_id;
	char cmspcdreg_processflg[2];
	short cmspcdreg_processflg_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSPCDREG \
		:cmspcdreg_aplydate:cmspcdreg_aplydate_id, \
		:cmspcdreg_serseqno:cmspcdreg_serseqno_id, \
		:cmspcdreg_vouchno:cmspcdreg_vouchno_id, \
		:cmspcdreg_wishdate:cmspcdreg_wishdate_id, \
		:cmspcdreg_aplybrc:cmspcdreg_aplybrc_id, \
		:cmspcdreg_aplyteller:cmspcdreg_aplyteller_id, \
		:cmspcdreg_authteller:cmspcdreg_authteller_id, \
		:cmspcdreg_cardkind:cmspcdreg_cardkind_id, \
		:cmspcdreg_aplynum:cmspcdreg_aplynum_id, \
		:cmspcdreg_scardno:cmspcdreg_scardno_id, \
		:cmspcdreg_ecardno:cmspcdreg_ecardno_id, \
		:cmspcdreg_voukind:cmspcdreg_voukind_id, \
		:cmspcdreg_svouno:cmspcdreg_svouno_id, \
		:cmspcdreg_evouno:cmspcdreg_evouno_id, \
		:cmspcdreg_custno:cmspcdreg_custno_id, \
		:cmspcdreg_custname:cmspcdreg_custname_id, \
		:cmspcdreg_aplyflg:cmspcdreg_aplyflg_id, \
		:cmspcdreg_dealdate:cmspcdreg_dealdate_id, \
		:cmspcdreg_dealseqno:cmspcdreg_dealseqno_id, \
		:cmspcdreg_applflg:cmspcdreg_applflg_id, \
		:cmspcdreg_processflg:cmspcdreg_processflg_id

#define UU_CMSPCDREG \
		aplydate, \
		serseqno, \
		vouchno, \
		wishdate, \
		aplybrc, \
		aplyteller, \
		authteller, \
		cardkind, \
		aplynum, \
		scardno, \
		ecardno, \
		voukind, \
		svouno, \
		evouno, \
		custno, \
		custname, \
		aplyflg, \
		dealdate, \
		dealseqno, \
		applflg, \
		processflg

#define WW_CMSPCDREG \
		:cmspcdreg_aplydate, \
		:cmspcdreg_serseqno, \
		:cmspcdreg_vouchno, \
		:cmspcdreg_wishdate, \
		:cmspcdreg_aplybrc, \
		:cmspcdreg_aplyteller, \
		:cmspcdreg_authteller, \
		:cmspcdreg_cardkind, \
		:cmspcdreg_aplynum, \
		:cmspcdreg_scardno, \
		:cmspcdreg_ecardno, \
		:cmspcdreg_voukind, \
		:cmspcdreg_svouno, \
		:cmspcdreg_evouno, \
		:cmspcdreg_custno, \
		:cmspcdreg_custname, \
		:cmspcdreg_aplyflg, \
		:cmspcdreg_dealdate, \
		:cmspcdreg_dealseqno, \
		:cmspcdreg_applflg, \
		:cmspcdreg_processflg

struct cmspcdreg
{
	char	aplydate[11];
	long	serseqno;
	char	vouchno[17];
	char	wishdate[11];
	char	aplybrc[10];
	char	aplyteller[11];
	char	authteller[11];
	char	cardkind[9];
	long	aplynum;
	char	scardno[20];
	char	ecardno[20];
	char	voukind[4];
	char	svouno[21];
	char	evouno[21];
	char	custno[31];
	char	custname[71];
	char	aplyflg[2];
	char	dealdate[11];
	long	dealseqno;
	char	applflg[2];
	char	processflg[2];
};

void pubInitCmspcdreg()
{
	memset( cmspcdreg_aplydate, 0x00, sizeof( cmspcdreg_aplydate ) ) ;
	cmspcdreg_aplydate_id = 0 ;
	memset( &cmspcdreg_serseqno, 0x00, sizeof( cmspcdreg_serseqno ) ) ;
	cmspcdreg_serseqno_id = 0 ;
	memset( cmspcdreg_vouchno, 0x00, sizeof( cmspcdreg_vouchno ) ) ;
	cmspcdreg_vouchno_id = 0 ;
	memset( cmspcdreg_wishdate, 0x00, sizeof( cmspcdreg_wishdate ) ) ;
	cmspcdreg_wishdate_id = 0 ;
	memset( cmspcdreg_aplybrc, 0x00, sizeof( cmspcdreg_aplybrc ) ) ;
	cmspcdreg_aplybrc_id = 0 ;
	memset( cmspcdreg_aplyteller, 0x00, sizeof( cmspcdreg_aplyteller ) ) ;
	cmspcdreg_aplyteller_id = 0 ;
	memset( cmspcdreg_authteller, 0x00, sizeof( cmspcdreg_authteller ) ) ;
	cmspcdreg_authteller_id = 0 ;
	memset( cmspcdreg_cardkind, 0x00, sizeof( cmspcdreg_cardkind ) ) ;
	cmspcdreg_cardkind_id = 0 ;
	memset( &cmspcdreg_aplynum, 0x00, sizeof( cmspcdreg_aplynum ) ) ;
	cmspcdreg_aplynum_id = 0 ;
	memset( cmspcdreg_scardno, 0x00, sizeof( cmspcdreg_scardno ) ) ;
	cmspcdreg_scardno_id = 0 ;
	memset( cmspcdreg_ecardno, 0x00, sizeof( cmspcdreg_ecardno ) ) ;
	cmspcdreg_ecardno_id = 0 ;
	memset( cmspcdreg_voukind, 0x00, sizeof( cmspcdreg_voukind ) ) ;
	cmspcdreg_voukind_id = 0 ;
	memset( cmspcdreg_svouno, 0x00, sizeof( cmspcdreg_svouno ) ) ;
	cmspcdreg_svouno_id = 0 ;
	memset( cmspcdreg_evouno, 0x00, sizeof( cmspcdreg_evouno ) ) ;
	cmspcdreg_evouno_id = 0 ;
	memset( cmspcdreg_custno, 0x00, sizeof( cmspcdreg_custno ) ) ;
	cmspcdreg_custno_id = 0 ;
	memset( cmspcdreg_custname, 0x00, sizeof( cmspcdreg_custname ) ) ;
	cmspcdreg_custname_id = 0 ;
	memset( cmspcdreg_aplyflg, 0x00, sizeof( cmspcdreg_aplyflg ) ) ;
	cmspcdreg_aplyflg_id = 0 ;
	memset( cmspcdreg_dealdate, 0x00, sizeof( cmspcdreg_dealdate ) ) ;
	cmspcdreg_dealdate_id = 0 ;
	memset( &cmspcdreg_dealseqno, 0x00, sizeof( cmspcdreg_dealseqno ) ) ;
	cmspcdreg_dealseqno_id = 0 ;
	memset( cmspcdreg_applflg, 0x00, sizeof( cmspcdreg_applflg ) ) ;
	cmspcdreg_applflg_id = 0 ;
	memset( cmspcdreg_processflg, 0x00, sizeof( cmspcdreg_processflg ) ) ;
	cmspcdreg_processflg_id = 0 ;
}

void pubStoVCmspcdreg( struct cmspcdreg * pstCmspcdreg )
{
	pubInitCmspcdreg();
	if( !strlen( pstCmspcdreg->aplydate ) )
		strcpy( pstCmspcdreg->aplydate, " " );
	strcpy( cmspcdreg_aplydate, pstCmspcdreg->aplydate );
	cmspcdreg_serseqno = pstCmspcdreg->serseqno ;
	if( !strlen( pstCmspcdreg->vouchno ) )
		strcpy( pstCmspcdreg->vouchno, " " );
	strcpy( cmspcdreg_vouchno, pstCmspcdreg->vouchno );
	if( !strlen( pstCmspcdreg->wishdate ) )
		strcpy( pstCmspcdreg->wishdate, " " );
	strcpy( cmspcdreg_wishdate, pstCmspcdreg->wishdate );
	if( !strlen( pstCmspcdreg->aplybrc ) )
		strcpy( pstCmspcdreg->aplybrc, " " );
	strcpy( cmspcdreg_aplybrc, pstCmspcdreg->aplybrc );
	if( !strlen( pstCmspcdreg->aplyteller ) )
		strcpy( pstCmspcdreg->aplyteller, " " );
	strcpy( cmspcdreg_aplyteller, pstCmspcdreg->aplyteller );
	if( !strlen( pstCmspcdreg->authteller ) )
		strcpy( pstCmspcdreg->authteller, " " );
	strcpy( cmspcdreg_authteller, pstCmspcdreg->authteller );
	if( !strlen( pstCmspcdreg->cardkind ) )
		strcpy( pstCmspcdreg->cardkind, " " );
	strcpy( cmspcdreg_cardkind, pstCmspcdreg->cardkind );
	cmspcdreg_aplynum = pstCmspcdreg->aplynum ;
	if( !strlen( pstCmspcdreg->scardno ) )
		strcpy( pstCmspcdreg->scardno, " " );
	strcpy( cmspcdreg_scardno, pstCmspcdreg->scardno );
	if( !strlen( pstCmspcdreg->ecardno ) )
		strcpy( pstCmspcdreg->ecardno, " " );
	strcpy( cmspcdreg_ecardno, pstCmspcdreg->ecardno );
	if( !strlen( pstCmspcdreg->voukind ) )
		strcpy( pstCmspcdreg->voukind, " " );
	strcpy( cmspcdreg_voukind, pstCmspcdreg->voukind );
	if( !strlen( pstCmspcdreg->svouno ) )
		strcpy( pstCmspcdreg->svouno, " " );
	strcpy( cmspcdreg_svouno, pstCmspcdreg->svouno );
	if( !strlen( pstCmspcdreg->evouno ) )
		strcpy( pstCmspcdreg->evouno, " " );
	strcpy( cmspcdreg_evouno, pstCmspcdreg->evouno );
	if( !strlen( pstCmspcdreg->custno ) )
		strcpy( pstCmspcdreg->custno, " " );
	strcpy( cmspcdreg_custno, pstCmspcdreg->custno );
	if( !strlen( pstCmspcdreg->custname ) )
		strcpy( pstCmspcdreg->custname, " " );
	strcpy( cmspcdreg_custname, pstCmspcdreg->custname );
	if( !strlen( pstCmspcdreg->aplyflg ) )
		strcpy( pstCmspcdreg->aplyflg, " " );
	strcpy( cmspcdreg_aplyflg, pstCmspcdreg->aplyflg );
	if( !strlen( pstCmspcdreg->dealdate ) )
		strcpy( pstCmspcdreg->dealdate, " " );
	strcpy( cmspcdreg_dealdate, pstCmspcdreg->dealdate );
	cmspcdreg_dealseqno = pstCmspcdreg->dealseqno ;
	if( !strlen( pstCmspcdreg->applflg ) )
		strcpy( pstCmspcdreg->applflg, " " );
	strcpy( cmspcdreg_applflg, pstCmspcdreg->applflg );
	if( !strlen( pstCmspcdreg->processflg ) )
		strcpy( pstCmspcdreg->processflg, " " );
	strcpy( cmspcdreg_processflg, pstCmspcdreg->processflg );
}

void pubVtoSCmspcdreg( struct cmspcdreg * pstCmspcdreg )
{
	strcpy( pstCmspcdreg->aplydate, cmspcdreg_aplydate );
	strpack( pstCmspcdreg->aplydate );
	pstCmspcdreg->serseqno = cmspcdreg_serseqno ;
	strcpy( pstCmspcdreg->vouchno, cmspcdreg_vouchno );
	strpack( pstCmspcdreg->vouchno );
	strcpy( pstCmspcdreg->wishdate, cmspcdreg_wishdate );
	strpack( pstCmspcdreg->wishdate );
	strcpy( pstCmspcdreg->aplybrc, cmspcdreg_aplybrc );
	strpack( pstCmspcdreg->aplybrc );
	strcpy( pstCmspcdreg->aplyteller, cmspcdreg_aplyteller );
	strpack( pstCmspcdreg->aplyteller );
	strcpy( pstCmspcdreg->authteller, cmspcdreg_authteller );
	strpack( pstCmspcdreg->authteller );
	strcpy( pstCmspcdreg->cardkind, cmspcdreg_cardkind );
	strpack( pstCmspcdreg->cardkind );
	pstCmspcdreg->aplynum = cmspcdreg_aplynum ;
	strcpy( pstCmspcdreg->scardno, cmspcdreg_scardno );
	strpack( pstCmspcdreg->scardno );
	strcpy( pstCmspcdreg->ecardno, cmspcdreg_ecardno );
	strpack( pstCmspcdreg->ecardno );
	strcpy( pstCmspcdreg->voukind, cmspcdreg_voukind );
	strpack( pstCmspcdreg->voukind );
	strcpy( pstCmspcdreg->svouno, cmspcdreg_svouno );
	strpack( pstCmspcdreg->svouno );
	strcpy( pstCmspcdreg->evouno, cmspcdreg_evouno );
	strpack( pstCmspcdreg->evouno );
	strcpy( pstCmspcdreg->custno, cmspcdreg_custno );
	strpack( pstCmspcdreg->custno );
	strcpy( pstCmspcdreg->custname, cmspcdreg_custname );
	strpack( pstCmspcdreg->custname );
	strcpy( pstCmspcdreg->aplyflg, cmspcdreg_aplyflg );
	strpack( pstCmspcdreg->aplyflg );
	strcpy( pstCmspcdreg->dealdate, cmspcdreg_dealdate );
	strpack( pstCmspcdreg->dealdate );
	pstCmspcdreg->dealseqno = cmspcdreg_dealseqno ;
	strcpy( pstCmspcdreg->applflg, cmspcdreg_applflg );
	strpack( pstCmspcdreg->applflg );
	strcpy( pstCmspcdreg->processflg, cmspcdreg_processflg );
	strpack( pstCmspcdreg->processflg );
}

int pubReadCmspcdreg( struct cmspcdreg * pstCmspcdreg )
{
	pubInitCmspcdreg();
	pubStoVCmspcdreg(pstCmspcdreg);
	EXEC SQL SELECT * INTO RR_CMSPCDREG 
		FROM cmspcdreg  
		WHERE  
		 aplydate = :cmspcdreg_aplydate and 
		 serseqno = :cmspcdreg_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmspcdreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmspcdreg(pstCmspcdreg);
	return 0; 
} 
 
int pubModiCmspcdreg( struct cmspcdreg * pstCmspcdreg )
{
	pubInitCmspcdreg();
	pubStoVCmspcdreg(pstCmspcdreg);
	EXEC SQL UPDATE cmspcdreg 
		SET ( UU_CMSPCDREG ) = ( WW_CMSPCDREG ) 
		WHERE  
		 aplydate = :cmspcdreg_aplydate and 
		 serseqno = :cmspcdreg_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmspcdreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmspcdreg( struct cmspcdreg * pstCmspcdreg )
{
	pubInitCmspcdreg();
	pubStoVCmspcdreg(pstCmspcdreg);
	EXEC SQL INSERT INTO cmspcdreg VALUES ( RR_CMSPCDREG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmspcdreg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}