tbcms029.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 cmswritem_cardno[20];
	short cmswritem_cardno_id;
	char cmswritem_writedate[11];
	short cmswritem_writedate_id;
	long cmswritem_serseqno;
	short cmswritem_serseqno_id;
	char cmswritem_vouchno[17];
	short cmswritem_vouchno_id;
	char cmswritem_idtype[3];
	short cmswritem_idtype_id;
	char cmswritem_idcode[21];
	short cmswritem_idcode_id;
	char cmswritem_custname[71];
	short cmswritem_custname_id;
	char cmswritem_issuebrc[10];
	short cmswritem_issuebrc_id;
	char cmswritem_teller[11];
	short cmswritem_teller_id;
	char cmswritem_cardkind[9];
	short cmswritem_cardkind_id;
	char cmswritem_reason[41];
	short cmswritem_reason_id;
	char cmswritem_writebrc[10];
	short cmswritem_writebrc_id;
	char cmswritem_writeteller[11];
	short cmswritem_writeteller_id;
	char cmswritem_writeauthteller[11];
	short cmswritem_writeauthteller_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSWRITEM \
		:cmswritem_cardno:cmswritem_cardno_id, \
		:cmswritem_writedate:cmswritem_writedate_id, \
		:cmswritem_serseqno:cmswritem_serseqno_id, \
		:cmswritem_vouchno:cmswritem_vouchno_id, \
		:cmswritem_idtype:cmswritem_idtype_id, \
		:cmswritem_idcode:cmswritem_idcode_id, \
		:cmswritem_custname:cmswritem_custname_id, \
		:cmswritem_issuebrc:cmswritem_issuebrc_id, \
		:cmswritem_teller:cmswritem_teller_id, \
		:cmswritem_cardkind:cmswritem_cardkind_id, \
		:cmswritem_reason:cmswritem_reason_id, \
		:cmswritem_writebrc:cmswritem_writebrc_id, \
		:cmswritem_writeteller:cmswritem_writeteller_id, \
		:cmswritem_writeauthteller:cmswritem_writeauthteller_id

#define UU_CMSWRITEM \
		cardno, \
		writedate, \
		serseqno, \
		vouchno, \
		idtype, \
		idcode, \
		custname, \
		issuebrc, \
		teller, \
		cardkind, \
		reason, \
		writebrc, \
		writeteller, \
		writeauthteller

#define WW_CMSWRITEM \
		:cmswritem_cardno, \
		:cmswritem_writedate, \
		:cmswritem_serseqno, \
		:cmswritem_vouchno, \
		:cmswritem_idtype, \
		:cmswritem_idcode, \
		:cmswritem_custname, \
		:cmswritem_issuebrc, \
		:cmswritem_teller, \
		:cmswritem_cardkind, \
		:cmswritem_reason, \
		:cmswritem_writebrc, \
		:cmswritem_writeteller, \
		:cmswritem_writeauthteller

struct cmswritem
{
	char	cardno[20];
	char	writedate[11];
	long	serseqno;
	char	vouchno[17];
	char	idtype[3];
	char	idcode[21];
	char	custname[71];
	char	issuebrc[10];
	char	teller[11];
	char	cardkind[9];
	char	reason[41];
	char	writebrc[10];
	char	writeteller[11];
	char	writeauthteller[11];
};

void pubInitCmswritem()
{
	memset( cmswritem_cardno, 0x00, sizeof( cmswritem_cardno ) ) ;
	cmswritem_cardno_id = 0 ;
	memset( cmswritem_writedate, 0x00, sizeof( cmswritem_writedate ) ) ;
	cmswritem_writedate_id = 0 ;
	memset( &cmswritem_serseqno, 0x00, sizeof( cmswritem_serseqno ) ) ;
	cmswritem_serseqno_id = 0 ;
	memset( cmswritem_vouchno, 0x00, sizeof( cmswritem_vouchno ) ) ;
	cmswritem_vouchno_id = 0 ;
	memset( cmswritem_idtype, 0x00, sizeof( cmswritem_idtype ) ) ;
	cmswritem_idtype_id = 0 ;
	memset( cmswritem_idcode, 0x00, sizeof( cmswritem_idcode ) ) ;
	cmswritem_idcode_id = 0 ;
	memset( cmswritem_custname, 0x00, sizeof( cmswritem_custname ) ) ;
	cmswritem_custname_id = 0 ;
	memset( cmswritem_issuebrc, 0x00, sizeof( cmswritem_issuebrc ) ) ;
	cmswritem_issuebrc_id = 0 ;
	memset( cmswritem_teller, 0x00, sizeof( cmswritem_teller ) ) ;
	cmswritem_teller_id = 0 ;
	memset( cmswritem_cardkind, 0x00, sizeof( cmswritem_cardkind ) ) ;
	cmswritem_cardkind_id = 0 ;
	memset( cmswritem_reason, 0x00, sizeof( cmswritem_reason ) ) ;
	cmswritem_reason_id = 0 ;
	memset( cmswritem_writebrc, 0x00, sizeof( cmswritem_writebrc ) ) ;
	cmswritem_writebrc_id = 0 ;
	memset( cmswritem_writeteller, 0x00, sizeof( cmswritem_writeteller ) ) ;
	cmswritem_writeteller_id = 0 ;
	memset( cmswritem_writeauthteller, 0x00, sizeof( cmswritem_writeauthteller ) ) ;
	cmswritem_writeauthteller_id = 0 ;
}

void pubStoVCmswritem( struct cmswritem * pstCmswritem )
{
	pubInitCmswritem();
	if( !strlen( pstCmswritem->cardno ) )
		strcpy( pstCmswritem->cardno, " " );
	strcpy( cmswritem_cardno, pstCmswritem->cardno );
	if( !strlen( pstCmswritem->writedate ) )
		strcpy( pstCmswritem->writedate, " " );
	strcpy( cmswritem_writedate, pstCmswritem->writedate );
	cmswritem_serseqno = pstCmswritem->serseqno ;
	if( !strlen( pstCmswritem->vouchno ) )
		strcpy( pstCmswritem->vouchno, " " );
	strcpy( cmswritem_vouchno, pstCmswritem->vouchno );
	if( !strlen( pstCmswritem->idtype ) )
		strcpy( pstCmswritem->idtype, " " );
	strcpy( cmswritem_idtype, pstCmswritem->idtype );
	if( !strlen( pstCmswritem->idcode ) )
		strcpy( pstCmswritem->idcode, " " );
	strcpy( cmswritem_idcode, pstCmswritem->idcode );
	if( !strlen( pstCmswritem->custname ) )
		strcpy( pstCmswritem->custname, " " );
	strcpy( cmswritem_custname, pstCmswritem->custname );
	if( !strlen( pstCmswritem->issuebrc ) )
		strcpy( pstCmswritem->issuebrc, " " );
	strcpy( cmswritem_issuebrc, pstCmswritem->issuebrc );
	if( !strlen( pstCmswritem->teller ) )
		strcpy( pstCmswritem->teller, " " );
	strcpy( cmswritem_teller, pstCmswritem->teller );
	if( !strlen( pstCmswritem->cardkind ) )
		strcpy( pstCmswritem->cardkind, " " );
	strcpy( cmswritem_cardkind, pstCmswritem->cardkind );
	if( !strlen( pstCmswritem->reason ) )
		strcpy( pstCmswritem->reason, " " );
	strcpy( cmswritem_reason, pstCmswritem->reason );
	if( !strlen( pstCmswritem->writebrc ) )
		strcpy( pstCmswritem->writebrc, " " );
	strcpy( cmswritem_writebrc, pstCmswritem->writebrc );
	if( !strlen( pstCmswritem->writeteller ) )
		strcpy( pstCmswritem->writeteller, " " );
	strcpy( cmswritem_writeteller, pstCmswritem->writeteller );
	if( !strlen( pstCmswritem->writeauthteller ) )
		strcpy( pstCmswritem->writeauthteller, " " );
	strcpy( cmswritem_writeauthteller, pstCmswritem->writeauthteller );
}

void pubVtoSCmswritem( struct cmswritem * pstCmswritem )
{
	strcpy( pstCmswritem->cardno, cmswritem_cardno );
	strpack( pstCmswritem->cardno );
	strcpy( pstCmswritem->writedate, cmswritem_writedate );
	strpack( pstCmswritem->writedate );
	pstCmswritem->serseqno = cmswritem_serseqno ;
	strcpy( pstCmswritem->vouchno, cmswritem_vouchno );
	strpack( pstCmswritem->vouchno );
	strcpy( pstCmswritem->idtype, cmswritem_idtype );
	strpack( pstCmswritem->idtype );
	strcpy( pstCmswritem->idcode, cmswritem_idcode );
	strpack( pstCmswritem->idcode );
	strcpy( pstCmswritem->custname, cmswritem_custname );
	strpack( pstCmswritem->custname );
	strcpy( pstCmswritem->issuebrc, cmswritem_issuebrc );
	strpack( pstCmswritem->issuebrc );
	strcpy( pstCmswritem->teller, cmswritem_teller );
	strpack( pstCmswritem->teller );
	strcpy( pstCmswritem->cardkind, cmswritem_cardkind );
	strpack( pstCmswritem->cardkind );
	strcpy( pstCmswritem->reason, cmswritem_reason );
	strpack( pstCmswritem->reason );
	strcpy( pstCmswritem->writebrc, cmswritem_writebrc );
	strpack( pstCmswritem->writebrc );
	strcpy( pstCmswritem->writeteller, cmswritem_writeteller );
	strpack( pstCmswritem->writeteller );
	strcpy( pstCmswritem->writeauthteller, cmswritem_writeauthteller );
	strpack( pstCmswritem->writeauthteller );
}

int pubReadCmswritem( struct cmswritem * pstCmswritem )
{
	pubInitCmswritem();
	pubStoVCmswritem(pstCmswritem);
	EXEC SQL SELECT * INTO RR_CMSWRITEM 
		FROM cmswritem  
		WHERE  
		 cardno = :cmswritem_cardno and 
		 writedate = :cmswritem_writedate and 
		 serseqno = :cmswritem_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmswritem",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmswritem(pstCmswritem);
	return 0; 
} 
 
int pubModiCmswritem( struct cmswritem * pstCmswritem )
{
	pubInitCmswritem();
	pubStoVCmswritem(pstCmswritem);
	EXEC SQL UPDATE cmswritem 
		SET ( UU_CMSWRITEM ) = ( WW_CMSWRITEM ) 
		WHERE  
		 cardno = :cmswritem_cardno and 
		 writedate = :cmswritem_writedate and 
		 serseqno = :cmswritem_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmswritem",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmswritem( struct cmswritem * pstCmswritem )
{
	pubInitCmswritem();
	pubStoVCmswritem(pstCmswritem);
	EXEC SQL INSERT INTO cmswritem VALUES ( RR_CMSWRITEM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmswritem",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}