tbcms023.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 cmsholdm_cardno[20];
	short cmsholdm_cardno_id;
	char cmsholdm_holddate[11];
	short cmsholdm_holddate_id;
	long cmsholdm_serseqno;
	short cmsholdm_serseqno_id;
	char cmsholdm_vouchno[17];
	short cmsholdm_vouchno_id;
	char cmsholdm_retflag[2];
	short cmsholdm_retflag_id;
	char cmsholdm_holdbrc[10];
	short cmsholdm_holdbrc_id;
	char cmsholdm_holdteller[11];
	short cmsholdm_holdteller_id;
	char cmsholdm_holdreason[2];
	short cmsholdm_holdreason_id;
	char cmsholdm_retdate[11];
	short cmsholdm_retdate_id;
	char cmsholdm_retbrc[10];
	short cmsholdm_retbrc_id;
	char cmsholdm_retteller[11];
	short cmsholdm_retteller_id;
	char cmsholdm_authteller[11];
	short cmsholdm_authteller_id;
	long cmsholdm_retserseqno;
	short cmsholdm_retserseqno_id;
	char cmsholdm_retobrname[71];
	short cmsholdm_retobrname_id;
	char cmsholdm_retoname[71];
	short cmsholdm_retoname_id;
	char cmsholdm_retoidtype[3];
	short cmsholdm_retoidtype_id;
	char cmsholdm_retoidcode[21];
	short cmsholdm_retoidcode_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSHOLDM \
		:cmsholdm_cardno:cmsholdm_cardno_id, \
		:cmsholdm_holddate:cmsholdm_holddate_id, \
		:cmsholdm_serseqno:cmsholdm_serseqno_id, \
		:cmsholdm_vouchno:cmsholdm_vouchno_id, \
		:cmsholdm_retflag:cmsholdm_retflag_id, \
		:cmsholdm_holdbrc:cmsholdm_holdbrc_id, \
		:cmsholdm_holdteller:cmsholdm_holdteller_id, \
		:cmsholdm_holdreason:cmsholdm_holdreason_id, \
		:cmsholdm_retdate:cmsholdm_retdate_id, \
		:cmsholdm_retbrc:cmsholdm_retbrc_id, \
		:cmsholdm_retteller:cmsholdm_retteller_id, \
		:cmsholdm_authteller:cmsholdm_authteller_id, \
		:cmsholdm_retserseqno:cmsholdm_retserseqno_id, \
		:cmsholdm_retobrname:cmsholdm_retobrname_id, \
		:cmsholdm_retoname:cmsholdm_retoname_id, \
		:cmsholdm_retoidtype:cmsholdm_retoidtype_id, \
		:cmsholdm_retoidcode:cmsholdm_retoidcode_id

#define UU_CMSHOLDM \
		cardno, \
		holddate, \
		serseqno, \
		vouchno, \
		retflag, \
		holdbrc, \
		holdteller, \
		holdreason, \
		retdate, \
		retbrc, \
		retteller, \
		authteller, \
		retserseqno, \
		retobrname, \
		retoname, \
		retoidtype, \
		retoidcode

#define WW_CMSHOLDM \
		:cmsholdm_cardno, \
		:cmsholdm_holddate, \
		:cmsholdm_serseqno, \
		:cmsholdm_vouchno, \
		:cmsholdm_retflag, \
		:cmsholdm_holdbrc, \
		:cmsholdm_holdteller, \
		:cmsholdm_holdreason, \
		:cmsholdm_retdate, \
		:cmsholdm_retbrc, \
		:cmsholdm_retteller, \
		:cmsholdm_authteller, \
		:cmsholdm_retserseqno, \
		:cmsholdm_retobrname, \
		:cmsholdm_retoname, \
		:cmsholdm_retoidtype, \
		:cmsholdm_retoidcode

struct cmsholdm
{
	char	cardno[20];
	char	holddate[11];
	long	serseqno;
	char	vouchno[17];
	char	retflag[2];
	char	holdbrc[10];
	char	holdteller[11];
	char	holdreason[2];
	char	retdate[11];
	char	retbrc[10];
	char	retteller[11];
	char	authteller[11];
	long	retserseqno;
	char	retobrname[71];
	char	retoname[71];
	char	retoidtype[3];
	char	retoidcode[21];
};

void pubInitCmsholdm()
{
	memset( cmsholdm_cardno, 0x00, sizeof( cmsholdm_cardno ) ) ;
	cmsholdm_cardno_id = 0 ;
	memset( cmsholdm_holddate, 0x00, sizeof( cmsholdm_holddate ) ) ;
	cmsholdm_holddate_id = 0 ;
	memset( &cmsholdm_serseqno, 0x00, sizeof( cmsholdm_serseqno ) ) ;
	cmsholdm_serseqno_id = 0 ;
	memset( cmsholdm_vouchno, 0x00, sizeof( cmsholdm_vouchno ) ) ;
	cmsholdm_vouchno_id = 0 ;
	memset( cmsholdm_retflag, 0x00, sizeof( cmsholdm_retflag ) ) ;
	cmsholdm_retflag_id = 0 ;
	memset( cmsholdm_holdbrc, 0x00, sizeof( cmsholdm_holdbrc ) ) ;
	cmsholdm_holdbrc_id = 0 ;
	memset( cmsholdm_holdteller, 0x00, sizeof( cmsholdm_holdteller ) ) ;
	cmsholdm_holdteller_id = 0 ;
	memset( cmsholdm_holdreason, 0x00, sizeof( cmsholdm_holdreason ) ) ;
	cmsholdm_holdreason_id = 0 ;
	memset( cmsholdm_retdate, 0x00, sizeof( cmsholdm_retdate ) ) ;
	cmsholdm_retdate_id = 0 ;
	memset( cmsholdm_retbrc, 0x00, sizeof( cmsholdm_retbrc ) ) ;
	cmsholdm_retbrc_id = 0 ;
	memset( cmsholdm_retteller, 0x00, sizeof( cmsholdm_retteller ) ) ;
	cmsholdm_retteller_id = 0 ;
	memset( cmsholdm_authteller, 0x00, sizeof( cmsholdm_authteller ) ) ;
	cmsholdm_authteller_id = 0 ;
	memset( &cmsholdm_retserseqno, 0x00, sizeof( cmsholdm_retserseqno ) ) ;
	cmsholdm_retserseqno_id = 0 ;
	memset( cmsholdm_retobrname, 0x00, sizeof( cmsholdm_retobrname ) ) ;
	cmsholdm_retobrname_id = 0 ;
	memset( cmsholdm_retoname, 0x00, sizeof( cmsholdm_retoname ) ) ;
	cmsholdm_retoname_id = 0 ;
	memset( cmsholdm_retoidtype, 0x00, sizeof( cmsholdm_retoidtype ) ) ;
	cmsholdm_retoidtype_id = 0 ;
	memset( cmsholdm_retoidcode, 0x00, sizeof( cmsholdm_retoidcode ) ) ;
	cmsholdm_retoidcode_id = 0 ;
}

void pubStoVCmsholdm( struct cmsholdm * pstCmsholdm )
{
	pubInitCmsholdm();
	if( !strlen( pstCmsholdm->cardno ) )
		strcpy( pstCmsholdm->cardno, " " );
	strcpy( cmsholdm_cardno, pstCmsholdm->cardno );
	if( !strlen( pstCmsholdm->holddate ) )
		strcpy( pstCmsholdm->holddate, " " );
	strcpy( cmsholdm_holddate, pstCmsholdm->holddate );
	cmsholdm_serseqno = pstCmsholdm->serseqno ;
	if( !strlen( pstCmsholdm->vouchno ) )
		strcpy( pstCmsholdm->vouchno, " " );
	strcpy( cmsholdm_vouchno, pstCmsholdm->vouchno );
	if( !strlen( pstCmsholdm->retflag ) )
		strcpy( pstCmsholdm->retflag, " " );
	strcpy( cmsholdm_retflag, pstCmsholdm->retflag );
	if( !strlen( pstCmsholdm->holdbrc ) )
		strcpy( pstCmsholdm->holdbrc, " " );
	strcpy( cmsholdm_holdbrc, pstCmsholdm->holdbrc );
	if( !strlen( pstCmsholdm->holdteller ) )
		strcpy( pstCmsholdm->holdteller, " " );
	strcpy( cmsholdm_holdteller, pstCmsholdm->holdteller );
	if( !strlen( pstCmsholdm->holdreason ) )
		strcpy( pstCmsholdm->holdreason, " " );
	strcpy( cmsholdm_holdreason, pstCmsholdm->holdreason );
	if( !strlen( pstCmsholdm->retdate ) )
		strcpy( pstCmsholdm->retdate, " " );
	strcpy( cmsholdm_retdate, pstCmsholdm->retdate );
	if( !strlen( pstCmsholdm->retbrc ) )
		strcpy( pstCmsholdm->retbrc, " " );
	strcpy( cmsholdm_retbrc, pstCmsholdm->retbrc );
	if( !strlen( pstCmsholdm->retteller ) )
		strcpy( pstCmsholdm->retteller, " " );
	strcpy( cmsholdm_retteller, pstCmsholdm->retteller );
	if( !strlen( pstCmsholdm->authteller ) )
		strcpy( pstCmsholdm->authteller, " " );
	strcpy( cmsholdm_authteller, pstCmsholdm->authteller );
	cmsholdm_retserseqno = pstCmsholdm->retserseqno ;
	if( !strlen( pstCmsholdm->retobrname ) )
		strcpy( pstCmsholdm->retobrname, " " );
	strcpy( cmsholdm_retobrname, pstCmsholdm->retobrname );
	if( !strlen( pstCmsholdm->retoname ) )
		strcpy( pstCmsholdm->retoname, " " );
	strcpy( cmsholdm_retoname, pstCmsholdm->retoname );
	if( !strlen( pstCmsholdm->retoidtype ) )
		strcpy( pstCmsholdm->retoidtype, " " );
	strcpy( cmsholdm_retoidtype, pstCmsholdm->retoidtype );
	if( !strlen( pstCmsholdm->retoidcode ) )
		strcpy( pstCmsholdm->retoidcode, " " );
	strcpy( cmsholdm_retoidcode, pstCmsholdm->retoidcode );
}

void pubVtoSCmsholdm( struct cmsholdm * pstCmsholdm )
{
	strcpy( pstCmsholdm->cardno, cmsholdm_cardno );
	strpack( pstCmsholdm->cardno );
	strcpy( pstCmsholdm->holddate, cmsholdm_holddate );
	strpack( pstCmsholdm->holddate );
	pstCmsholdm->serseqno = cmsholdm_serseqno ;
	strcpy( pstCmsholdm->vouchno, cmsholdm_vouchno );
	strpack( pstCmsholdm->vouchno );
	strcpy( pstCmsholdm->retflag, cmsholdm_retflag );
	strpack( pstCmsholdm->retflag );
	strcpy( pstCmsholdm->holdbrc, cmsholdm_holdbrc );
	strpack( pstCmsholdm->holdbrc );
	strcpy( pstCmsholdm->holdteller, cmsholdm_holdteller );
	strpack( pstCmsholdm->holdteller );
	strcpy( pstCmsholdm->holdreason, cmsholdm_holdreason );
	strpack( pstCmsholdm->holdreason );
	strcpy( pstCmsholdm->retdate, cmsholdm_retdate );
	strpack( pstCmsholdm->retdate );
	strcpy( pstCmsholdm->retbrc, cmsholdm_retbrc );
	strpack( pstCmsholdm->retbrc );
	strcpy( pstCmsholdm->retteller, cmsholdm_retteller );
	strpack( pstCmsholdm->retteller );
	strcpy( pstCmsholdm->authteller, cmsholdm_authteller );
	strpack( pstCmsholdm->authteller );
	pstCmsholdm->retserseqno = cmsholdm_retserseqno ;
	strcpy( pstCmsholdm->retobrname, cmsholdm_retobrname );
	strpack( pstCmsholdm->retobrname );
	strcpy( pstCmsholdm->retoname, cmsholdm_retoname );
	strpack( pstCmsholdm->retoname );
	strcpy( pstCmsholdm->retoidtype, cmsholdm_retoidtype );
	strpack( pstCmsholdm->retoidtype );
	strcpy( pstCmsholdm->retoidcode, cmsholdm_retoidcode );
	strpack( pstCmsholdm->retoidcode );
}

int pubReadCmsholdm( struct cmsholdm * pstCmsholdm )
{
	pubInitCmsholdm();
	pubStoVCmsholdm(pstCmsholdm);
	EXEC SQL SELECT * INTO RR_CMSHOLDM 
		FROM cmsholdm  
		WHERE  
		 cardno = :cmsholdm_cardno and 
		 holddate = :cmsholdm_holddate and 
		 serseqno = :cmsholdm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsholdm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsholdm(pstCmsholdm);
	return 0; 
} 
 
int pubModiCmsholdm( struct cmsholdm * pstCmsholdm )
{
	pubInitCmsholdm();
	pubStoVCmsholdm(pstCmsholdm);
	EXEC SQL UPDATE cmsholdm 
		SET ( UU_CMSHOLDM ) = ( WW_CMSHOLDM ) 
		WHERE  
		 cardno = :cmsholdm_cardno and 
		 holddate = :cmsholdm_holddate and 
		 serseqno = :cmsholdm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsholdm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsholdm( struct cmsholdm * pstCmsholdm )
{
	pubInitCmsholdm();
	pubStoVCmsholdm(pstCmsholdm);
	EXEC SQL INSERT INTO cmsholdm VALUES ( RR_CMSHOLDM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsholdm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}