tbcms022.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 cmschgm_oldcardno[20];
	short cmschgm_oldcardno_id;
	char cmschgm_newcardno[20];
	short cmschgm_newcardno_id;
	char cmschgm_chgdate[11];
	short cmschgm_chgdate_id;
	long cmschgm_serseqno;
	short cmschgm_serseqno_id;
	char cmschgm_vouchno[17];
	short cmschgm_vouchno_id;
	char cmschgm_idtype[3];
	short cmschgm_idtype_id;
	char cmschgm_idcode[21];
	short cmschgm_idcode_id;
	char cmschgm_custname[71];
	short cmschgm_custname_id;
	char cmschgm_issuebrc[10];
	short cmschgm_issuebrc_id;
	char cmschgm_chgbrc[10];
	short cmschgm_chgbrc_id;
	char cmschgm_chgteller[11];
	short cmschgm_chgteller_id;
	char cmschgm_chgflg[2];
	short cmschgm_chgflg_id;
	char cmschgm_status[2];
	short cmschgm_status_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCHGM \
		:cmschgm_oldcardno:cmschgm_oldcardno_id, \
		:cmschgm_newcardno:cmschgm_newcardno_id, \
		:cmschgm_chgdate:cmschgm_chgdate_id, \
		:cmschgm_serseqno:cmschgm_serseqno_id, \
		:cmschgm_vouchno:cmschgm_vouchno_id, \
		:cmschgm_idtype:cmschgm_idtype_id, \
		:cmschgm_idcode:cmschgm_idcode_id, \
		:cmschgm_custname:cmschgm_custname_id, \
		:cmschgm_issuebrc:cmschgm_issuebrc_id, \
		:cmschgm_chgbrc:cmschgm_chgbrc_id, \
		:cmschgm_chgteller:cmschgm_chgteller_id, \
		:cmschgm_chgflg:cmschgm_chgflg_id, \
		:cmschgm_status:cmschgm_status_id

#define UU_CMSCHGM \
		oldcardno, \
		newcardno, \
		chgdate, \
		serseqno, \
		vouchno, \
		idtype, \
		idcode, \
		custname, \
		issuebrc, \
		chgbrc, \
		chgteller, \
		chgflg, \
		status

#define WW_CMSCHGM \
		:cmschgm_oldcardno, \
		:cmschgm_newcardno, \
		:cmschgm_chgdate, \
		:cmschgm_serseqno, \
		:cmschgm_vouchno, \
		:cmschgm_idtype, \
		:cmschgm_idcode, \
		:cmschgm_custname, \
		:cmschgm_issuebrc, \
		:cmschgm_chgbrc, \
		:cmschgm_chgteller, \
		:cmschgm_chgflg, \
		:cmschgm_status

struct cmschgm
{
	char	oldcardno[20];
	char	newcardno[20];
	char	chgdate[11];
	long	serseqno;
	char	vouchno[17];
	char	idtype[3];
	char	idcode[21];
	char	custname[71];
	char	issuebrc[10];
	char	chgbrc[10];
	char	chgteller[11];
	char	chgflg[2];
	char	status[2];
};

void pubInitCmschgm()
{
	memset( cmschgm_oldcardno, 0x00, sizeof( cmschgm_oldcardno ) ) ;
	cmschgm_oldcardno_id = 0 ;
	memset( cmschgm_newcardno, 0x00, sizeof( cmschgm_newcardno ) ) ;
	cmschgm_newcardno_id = 0 ;
	memset( cmschgm_chgdate, 0x00, sizeof( cmschgm_chgdate ) ) ;
	cmschgm_chgdate_id = 0 ;
	memset( &cmschgm_serseqno, 0x00, sizeof( cmschgm_serseqno ) ) ;
	cmschgm_serseqno_id = 0 ;
	memset( cmschgm_vouchno, 0x00, sizeof( cmschgm_vouchno ) ) ;
	cmschgm_vouchno_id = 0 ;
	memset( cmschgm_idtype, 0x00, sizeof( cmschgm_idtype ) ) ;
	cmschgm_idtype_id = 0 ;
	memset( cmschgm_idcode, 0x00, sizeof( cmschgm_idcode ) ) ;
	cmschgm_idcode_id = 0 ;
	memset( cmschgm_custname, 0x00, sizeof( cmschgm_custname ) ) ;
	cmschgm_custname_id = 0 ;
	memset( cmschgm_issuebrc, 0x00, sizeof( cmschgm_issuebrc ) ) ;
	cmschgm_issuebrc_id = 0 ;
	memset( cmschgm_chgbrc, 0x00, sizeof( cmschgm_chgbrc ) ) ;
	cmschgm_chgbrc_id = 0 ;
	memset( cmschgm_chgteller, 0x00, sizeof( cmschgm_chgteller ) ) ;
	cmschgm_chgteller_id = 0 ;
	memset( cmschgm_chgflg, 0x00, sizeof( cmschgm_chgflg ) ) ;
	cmschgm_chgflg_id = 0 ;
	memset( cmschgm_status, 0x00, sizeof( cmschgm_status ) ) ;
	cmschgm_status_id = 0 ;
}

void pubStoVCmschgm( struct cmschgm * pstCmschgm )
{
	pubInitCmschgm();
	if( !strlen( pstCmschgm->oldcardno ) )
		strcpy( pstCmschgm->oldcardno, " " );
	strcpy( cmschgm_oldcardno, pstCmschgm->oldcardno );
	if( !strlen( pstCmschgm->newcardno ) )
		strcpy( pstCmschgm->newcardno, " " );
	strcpy( cmschgm_newcardno, pstCmschgm->newcardno );
	if( !strlen( pstCmschgm->chgdate ) )
		strcpy( pstCmschgm->chgdate, " " );
	strcpy( cmschgm_chgdate, pstCmschgm->chgdate );
	cmschgm_serseqno = pstCmschgm->serseqno ;
	if( !strlen( pstCmschgm->vouchno ) )
		strcpy( pstCmschgm->vouchno, " " );
	strcpy( cmschgm_vouchno, pstCmschgm->vouchno );
	if( !strlen( pstCmschgm->idtype ) )
		strcpy( pstCmschgm->idtype, " " );
	strcpy( cmschgm_idtype, pstCmschgm->idtype );
	if( !strlen( pstCmschgm->idcode ) )
		strcpy( pstCmschgm->idcode, " " );
	strcpy( cmschgm_idcode, pstCmschgm->idcode );
	if( !strlen( pstCmschgm->custname ) )
		strcpy( pstCmschgm->custname, " " );
	strcpy( cmschgm_custname, pstCmschgm->custname );
	if( !strlen( pstCmschgm->issuebrc ) )
		strcpy( pstCmschgm->issuebrc, " " );
	strcpy( cmschgm_issuebrc, pstCmschgm->issuebrc );
	if( !strlen( pstCmschgm->chgbrc ) )
		strcpy( pstCmschgm->chgbrc, " " );
	strcpy( cmschgm_chgbrc, pstCmschgm->chgbrc );
	if( !strlen( pstCmschgm->chgteller ) )
		strcpy( pstCmschgm->chgteller, " " );
	strcpy( cmschgm_chgteller, pstCmschgm->chgteller );
	if( !strlen( pstCmschgm->chgflg ) )
		strcpy( pstCmschgm->chgflg, " " );
	strcpy( cmschgm_chgflg, pstCmschgm->chgflg );
	if( !strlen( pstCmschgm->status ) )
		strcpy( pstCmschgm->status, " " );
	strcpy( cmschgm_status, pstCmschgm->status );
}

void pubVtoSCmschgm( struct cmschgm * pstCmschgm )
{
	strcpy( pstCmschgm->oldcardno, cmschgm_oldcardno );
	strpack( pstCmschgm->oldcardno );
	strcpy( pstCmschgm->newcardno, cmschgm_newcardno );
	strpack( pstCmschgm->newcardno );
	strcpy( pstCmschgm->chgdate, cmschgm_chgdate );
	strpack( pstCmschgm->chgdate );
	pstCmschgm->serseqno = cmschgm_serseqno ;
	strcpy( pstCmschgm->vouchno, cmschgm_vouchno );
	strpack( pstCmschgm->vouchno );
	strcpy( pstCmschgm->idtype, cmschgm_idtype );
	strpack( pstCmschgm->idtype );
	strcpy( pstCmschgm->idcode, cmschgm_idcode );
	strpack( pstCmschgm->idcode );
	strcpy( pstCmschgm->custname, cmschgm_custname );
	strpack( pstCmschgm->custname );
	strcpy( pstCmschgm->issuebrc, cmschgm_issuebrc );
	strpack( pstCmschgm->issuebrc );
	strcpy( pstCmschgm->chgbrc, cmschgm_chgbrc );
	strpack( pstCmschgm->chgbrc );
	strcpy( pstCmschgm->chgteller, cmschgm_chgteller );
	strpack( pstCmschgm->chgteller );
	strcpy( pstCmschgm->chgflg, cmschgm_chgflg );
	strpack( pstCmschgm->chgflg );
	strcpy( pstCmschgm->status, cmschgm_status );
	strpack( pstCmschgm->status );
}

int pubReadCmschgm( struct cmschgm * pstCmschgm )
{
	pubInitCmschgm();
	pubStoVCmschgm(pstCmschgm);
	EXEC SQL SELECT * INTO RR_CMSCHGM 
		FROM cmschgm  
		WHERE  
		 oldcardno = :cmschgm_oldcardno and 
		 chgdate = :cmschgm_chgdate and 
		 serseqno = :cmschgm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmschgm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmschgm(pstCmschgm);
	return 0; 
} 
 
int pubModiCmschgm( struct cmschgm * pstCmschgm )
{
	pubInitCmschgm();
	pubStoVCmschgm(pstCmschgm);
	EXEC SQL UPDATE cmschgm 
		SET ( UU_CMSCHGM ) = ( WW_CMSCHGM ) 
		WHERE  
		 oldcardno = :cmschgm_oldcardno and 
		 chgdate = :cmschgm_chgdate and 
		 serseqno = :cmschgm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmschgm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmschgm( struct cmschgm * pstCmschgm )
{
	pubInitCmschgm();
	pubStoVCmschgm(pstCmschgm);
	EXEC SQL INSERT INTO cmschgm VALUES ( RR_CMSCHGM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmschgm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}