tbcms020.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 cmscuststopm_maincardno[20];
	short cmscuststopm_maincardno_id;
	char cmscuststopm_accecardno[20];
	short cmscuststopm_accecardno_id;
	char cmscuststopm_stopdate[11];
	short cmscuststopm_stopdate_id;
	long cmscuststopm_stopserseqno;
	short cmscuststopm_stopserseqno_id;
	char cmscuststopm_vouchno[17];
	short cmscuststopm_vouchno_id;
	char cmscuststopm_idtype[3];
	short cmscuststopm_idtype_id;
	char cmscuststopm_idcode[21];
	short cmscuststopm_idcode_id;
	char cmscuststopm_custname[71];
	short cmscuststopm_custname_id;
	char cmscuststopm_stopteller[11];
	short cmscuststopm_stopteller_id;
	char cmscuststopm_authteller[11];
	short cmscuststopm_authteller_id;
	char cmscuststopm_stopbrc[10];
	short cmscuststopm_stopbrc_id;
	char cmscuststopm_stopreason[41];
	short cmscuststopm_stopreason_id;
	char cmscuststopm_stoptype[2];
	short cmscuststopm_stoptype_id;
	char cmscuststopm_stopstat[2];
	short cmscuststopm_stopstat_id;
	char cmscuststopm_cncldate[11];
	short cmscuststopm_cncldate_id;
	long cmscuststopm_cnclserseqno;
	short cmscuststopm_cnclserseqno_id;
	char cmscuststopm_cnclteller[11];
	short cmscuststopm_cnclteller_id;
	char cmscuststopm_cnclauthteller[11];
	short cmscuststopm_cnclauthteller_id;
	char cmscuststopm_cnclbrc[10];
	short cmscuststopm_cnclbrc_id;
	char cmscuststopm_cnclreason[41];
	short cmscuststopm_cnclreason_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCUSTSTOPM \
		:cmscuststopm_maincardno:cmscuststopm_maincardno_id, \
		:cmscuststopm_accecardno:cmscuststopm_accecardno_id, \
		:cmscuststopm_stopdate:cmscuststopm_stopdate_id, \
		:cmscuststopm_stopserseqno:cmscuststopm_stopserseqno_id, \
		:cmscuststopm_vouchno:cmscuststopm_vouchno_id, \
		:cmscuststopm_idtype:cmscuststopm_idtype_id, \
		:cmscuststopm_idcode:cmscuststopm_idcode_id, \
		:cmscuststopm_custname:cmscuststopm_custname_id, \
		:cmscuststopm_stopteller:cmscuststopm_stopteller_id, \
		:cmscuststopm_authteller:cmscuststopm_authteller_id, \
		:cmscuststopm_stopbrc:cmscuststopm_stopbrc_id, \
		:cmscuststopm_stopreason:cmscuststopm_stopreason_id, \
		:cmscuststopm_stoptype:cmscuststopm_stoptype_id, \
		:cmscuststopm_stopstat:cmscuststopm_stopstat_id, \
		:cmscuststopm_cncldate:cmscuststopm_cncldate_id, \
		:cmscuststopm_cnclserseqno:cmscuststopm_cnclserseqno_id, \
		:cmscuststopm_cnclteller:cmscuststopm_cnclteller_id, \
		:cmscuststopm_cnclauthteller:cmscuststopm_cnclauthteller_id, \
		:cmscuststopm_cnclbrc:cmscuststopm_cnclbrc_id, \
		:cmscuststopm_cnclreason:cmscuststopm_cnclreason_id

#define UU_CMSCUSTSTOPM \
		maincardno, \
		accecardno, \
		stopdate, \
		stopserseqno, \
		vouchno, \
		idtype, \
		idcode, \
		custname, \
		stopteller, \
		authteller, \
		stopbrc, \
		stopreason, \
		stoptype, \
		stopstat, \
		cncldate, \
		cnclserseqno, \
		cnclteller, \
		cnclauthteller, \
		cnclbrc, \
		cnclreason

#define WW_CMSCUSTSTOPM \
		:cmscuststopm_maincardno, \
		:cmscuststopm_accecardno, \
		:cmscuststopm_stopdate, \
		:cmscuststopm_stopserseqno, \
		:cmscuststopm_vouchno, \
		:cmscuststopm_idtype, \
		:cmscuststopm_idcode, \
		:cmscuststopm_custname, \
		:cmscuststopm_stopteller, \
		:cmscuststopm_authteller, \
		:cmscuststopm_stopbrc, \
		:cmscuststopm_stopreason, \
		:cmscuststopm_stoptype, \
		:cmscuststopm_stopstat, \
		:cmscuststopm_cncldate, \
		:cmscuststopm_cnclserseqno, \
		:cmscuststopm_cnclteller, \
		:cmscuststopm_cnclauthteller, \
		:cmscuststopm_cnclbrc, \
		:cmscuststopm_cnclreason

struct cmscuststopm
{
	char	maincardno[20];
	char	accecardno[20];
	char	stopdate[11];
	long	stopserseqno;
	char	vouchno[17];
	char	idtype[3];
	char	idcode[21];
	char	custname[71];
	char	stopteller[11];
	char	authteller[11];
	char	stopbrc[10];
	char	stopreason[41];
	char	stoptype[2];
	char	stopstat[2];
	char	cncldate[11];
	long	cnclserseqno;
	char	cnclteller[11];
	char	cnclauthteller[11];
	char	cnclbrc[10];
	char	cnclreason[41];
};

void pubInitCmscuststopm()
{
	memset( cmscuststopm_maincardno, 0x00, sizeof( cmscuststopm_maincardno ) ) ;
	cmscuststopm_maincardno_id = 0 ;
	memset( cmscuststopm_accecardno, 0x00, sizeof( cmscuststopm_accecardno ) ) ;
	cmscuststopm_accecardno_id = 0 ;
	memset( cmscuststopm_stopdate, 0x00, sizeof( cmscuststopm_stopdate ) ) ;
	cmscuststopm_stopdate_id = 0 ;
	memset( &cmscuststopm_stopserseqno, 0x00, sizeof( cmscuststopm_stopserseqno ) ) ;
	cmscuststopm_stopserseqno_id = 0 ;
	memset( cmscuststopm_vouchno, 0x00, sizeof( cmscuststopm_vouchno ) ) ;
	cmscuststopm_vouchno_id = 0 ;
	memset( cmscuststopm_idtype, 0x00, sizeof( cmscuststopm_idtype ) ) ;
	cmscuststopm_idtype_id = 0 ;
	memset( cmscuststopm_idcode, 0x00, sizeof( cmscuststopm_idcode ) ) ;
	cmscuststopm_idcode_id = 0 ;
	memset( cmscuststopm_custname, 0x00, sizeof( cmscuststopm_custname ) ) ;
	cmscuststopm_custname_id = 0 ;
	memset( cmscuststopm_stopteller, 0x00, sizeof( cmscuststopm_stopteller ) ) ;
	cmscuststopm_stopteller_id = 0 ;
	memset( cmscuststopm_authteller, 0x00, sizeof( cmscuststopm_authteller ) ) ;
	cmscuststopm_authteller_id = 0 ;
	memset( cmscuststopm_stopbrc, 0x00, sizeof( cmscuststopm_stopbrc ) ) ;
	cmscuststopm_stopbrc_id = 0 ;
	memset( cmscuststopm_stopreason, 0x00, sizeof( cmscuststopm_stopreason ) ) ;
	cmscuststopm_stopreason_id = 0 ;
	memset( cmscuststopm_stoptype, 0x00, sizeof( cmscuststopm_stoptype ) ) ;
	cmscuststopm_stoptype_id = 0 ;
	memset( cmscuststopm_stopstat, 0x00, sizeof( cmscuststopm_stopstat ) ) ;
	cmscuststopm_stopstat_id = 0 ;
	memset( cmscuststopm_cncldate, 0x00, sizeof( cmscuststopm_cncldate ) ) ;
	cmscuststopm_cncldate_id = 0 ;
	memset( &cmscuststopm_cnclserseqno, 0x00, sizeof( cmscuststopm_cnclserseqno ) ) ;
	cmscuststopm_cnclserseqno_id = 0 ;
	memset( cmscuststopm_cnclteller, 0x00, sizeof( cmscuststopm_cnclteller ) ) ;
	cmscuststopm_cnclteller_id = 0 ;
	memset( cmscuststopm_cnclauthteller, 0x00, sizeof( cmscuststopm_cnclauthteller ) ) ;
	cmscuststopm_cnclauthteller_id = 0 ;
	memset( cmscuststopm_cnclbrc, 0x00, sizeof( cmscuststopm_cnclbrc ) ) ;
	cmscuststopm_cnclbrc_id = 0 ;
	memset( cmscuststopm_cnclreason, 0x00, sizeof( cmscuststopm_cnclreason ) ) ;
	cmscuststopm_cnclreason_id = 0 ;
}

void pubStoVCmscuststopm( struct cmscuststopm * pstCmscuststopm )
{
	pubInitCmscuststopm();
	if( !strlen( pstCmscuststopm->maincardno ) )
		strcpy( pstCmscuststopm->maincardno, " " );
	strcpy( cmscuststopm_maincardno, pstCmscuststopm->maincardno );
	if( !strlen( pstCmscuststopm->accecardno ) )
		strcpy( pstCmscuststopm->accecardno, " " );
	strcpy( cmscuststopm_accecardno, pstCmscuststopm->accecardno );
	if( !strlen( pstCmscuststopm->stopdate ) )
		strcpy( pstCmscuststopm->stopdate, " " );
	strcpy( cmscuststopm_stopdate, pstCmscuststopm->stopdate );
	cmscuststopm_stopserseqno = pstCmscuststopm->stopserseqno ;
	if( !strlen( pstCmscuststopm->vouchno ) )
		strcpy( pstCmscuststopm->vouchno, " " );
	strcpy( cmscuststopm_vouchno, pstCmscuststopm->vouchno );
	if( !strlen( pstCmscuststopm->idtype ) )
		strcpy( pstCmscuststopm->idtype, " " );
	strcpy( cmscuststopm_idtype, pstCmscuststopm->idtype );
	if( !strlen( pstCmscuststopm->idcode ) )
		strcpy( pstCmscuststopm->idcode, " " );
	strcpy( cmscuststopm_idcode, pstCmscuststopm->idcode );
	if( !strlen( pstCmscuststopm->custname ) )
		strcpy( pstCmscuststopm->custname, " " );
	strcpy( cmscuststopm_custname, pstCmscuststopm->custname );
	if( !strlen( pstCmscuststopm->stopteller ) )
		strcpy( pstCmscuststopm->stopteller, " " );
	strcpy( cmscuststopm_stopteller, pstCmscuststopm->stopteller );
	if( !strlen( pstCmscuststopm->authteller ) )
		strcpy( pstCmscuststopm->authteller, " " );
	strcpy( cmscuststopm_authteller, pstCmscuststopm->authteller );
	if( !strlen( pstCmscuststopm->stopbrc ) )
		strcpy( pstCmscuststopm->stopbrc, " " );
	strcpy( cmscuststopm_stopbrc, pstCmscuststopm->stopbrc );
	if( !strlen( pstCmscuststopm->stopreason ) )
		strcpy( pstCmscuststopm->stopreason, " " );
	strcpy( cmscuststopm_stopreason, pstCmscuststopm->stopreason );
	if( !strlen( pstCmscuststopm->stoptype ) )
		strcpy( pstCmscuststopm->stoptype, " " );
	strcpy( cmscuststopm_stoptype, pstCmscuststopm->stoptype );
	if( !strlen( pstCmscuststopm->stopstat ) )
		strcpy( pstCmscuststopm->stopstat, " " );
	strcpy( cmscuststopm_stopstat, pstCmscuststopm->stopstat );
	if( !strlen( pstCmscuststopm->cncldate ) )
		strcpy( pstCmscuststopm->cncldate, " " );
	strcpy( cmscuststopm_cncldate, pstCmscuststopm->cncldate );
	cmscuststopm_cnclserseqno = pstCmscuststopm->cnclserseqno ;
	if( !strlen( pstCmscuststopm->cnclteller ) )
		strcpy( pstCmscuststopm->cnclteller, " " );
	strcpy( cmscuststopm_cnclteller, pstCmscuststopm->cnclteller );
	if( !strlen( pstCmscuststopm->cnclauthteller ) )
		strcpy( pstCmscuststopm->cnclauthteller, " " );
	strcpy( cmscuststopm_cnclauthteller, pstCmscuststopm->cnclauthteller );
	if( !strlen( pstCmscuststopm->cnclbrc ) )
		strcpy( pstCmscuststopm->cnclbrc, " " );
	strcpy( cmscuststopm_cnclbrc, pstCmscuststopm->cnclbrc );
	if( !strlen( pstCmscuststopm->cnclreason ) )
		strcpy( pstCmscuststopm->cnclreason, " " );
	strcpy( cmscuststopm_cnclreason, pstCmscuststopm->cnclreason );
}

void pubVtoSCmscuststopm( struct cmscuststopm * pstCmscuststopm )
{
	strcpy( pstCmscuststopm->maincardno, cmscuststopm_maincardno );
	strpack( pstCmscuststopm->maincardno );
	strcpy( pstCmscuststopm->accecardno, cmscuststopm_accecardno );
	strpack( pstCmscuststopm->accecardno );
	strcpy( pstCmscuststopm->stopdate, cmscuststopm_stopdate );
	strpack( pstCmscuststopm->stopdate );
	pstCmscuststopm->stopserseqno = cmscuststopm_stopserseqno ;
	strcpy( pstCmscuststopm->vouchno, cmscuststopm_vouchno );
	strpack( pstCmscuststopm->vouchno );
	strcpy( pstCmscuststopm->idtype, cmscuststopm_idtype );
	strpack( pstCmscuststopm->idtype );
	strcpy( pstCmscuststopm->idcode, cmscuststopm_idcode );
	strpack( pstCmscuststopm->idcode );
	strcpy( pstCmscuststopm->custname, cmscuststopm_custname );
	strpack( pstCmscuststopm->custname );
	strcpy( pstCmscuststopm->stopteller, cmscuststopm_stopteller );
	strpack( pstCmscuststopm->stopteller );
	strcpy( pstCmscuststopm->authteller, cmscuststopm_authteller );
	strpack( pstCmscuststopm->authteller );
	strcpy( pstCmscuststopm->stopbrc, cmscuststopm_stopbrc );
	strpack( pstCmscuststopm->stopbrc );
	strcpy( pstCmscuststopm->stopreason, cmscuststopm_stopreason );
	strpack( pstCmscuststopm->stopreason );
	strcpy( pstCmscuststopm->stoptype, cmscuststopm_stoptype );
	strpack( pstCmscuststopm->stoptype );
	strcpy( pstCmscuststopm->stopstat, cmscuststopm_stopstat );
	strpack( pstCmscuststopm->stopstat );
	strcpy( pstCmscuststopm->cncldate, cmscuststopm_cncldate );
	strpack( pstCmscuststopm->cncldate );
	pstCmscuststopm->cnclserseqno = cmscuststopm_cnclserseqno ;
	strcpy( pstCmscuststopm->cnclteller, cmscuststopm_cnclteller );
	strpack( pstCmscuststopm->cnclteller );
	strcpy( pstCmscuststopm->cnclauthteller, cmscuststopm_cnclauthteller );
	strpack( pstCmscuststopm->cnclauthteller );
	strcpy( pstCmscuststopm->cnclbrc, cmscuststopm_cnclbrc );
	strpack( pstCmscuststopm->cnclbrc );
	strcpy( pstCmscuststopm->cnclreason, cmscuststopm_cnclreason );
	strpack( pstCmscuststopm->cnclreason );
}

int pubReadCmscuststopm( struct cmscuststopm * pstCmscuststopm )
{
	pubInitCmscuststopm();
	pubStoVCmscuststopm(pstCmscuststopm);
	EXEC SQL SELECT * INTO RR_CMSCUSTSTOPM 
		FROM cmscuststopm  
		WHERE  
		 maincardno = :cmscuststopm_maincardno and 
		 accecardno = :cmscuststopm_accecardno and 
		 stopdate = :cmscuststopm_stopdate and 
		 stopserseqno = :cmscuststopm_stopserseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscuststopm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscuststopm(pstCmscuststopm);
	return 0; 
} 
 
int pubModiCmscuststopm( struct cmscuststopm * pstCmscuststopm )
{
	pubInitCmscuststopm();
	pubStoVCmscuststopm(pstCmscuststopm);
	EXEC SQL UPDATE cmscuststopm 
		SET ( UU_CMSCUSTSTOPM ) = ( WW_CMSCUSTSTOPM ) 
		WHERE  
		 maincardno = :cmscuststopm_maincardno and 
		 accecardno = :cmscuststopm_accecardno and 
		 stopdate = :cmscuststopm_stopdate and 
		 stopserseqno = :cmscuststopm_stopserseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscuststopm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmscuststopm( struct cmscuststopm * pstCmscuststopm )
{
	pubInitCmscuststopm();
	pubStoVCmscuststopm(pstCmscuststopm);
	EXEC SQL INSERT INTO cmscuststopm VALUES ( RR_CMSCUSTSTOPM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscuststopm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}