tbcms036.sqc

一整套完整的银行卡系统源代码

/*
** 注    意: 此文件由平台自动生成，禁止任何人以任何方式修改!
** 生成日期: 2004-9-1
** 版 本 号: V1.0.0
** 初始作者: ShiBin Hu
*/

#include	"sysdefine.h"
#include	"code.h"
#include	"attrdef.h"
EXEC SQL INCLUDE sqlca;

EXEC SQL BEGIN DECLARE SECTION ;
	char cmssuspectm_cardno[20];
	short cmssuspectm_cardno_id;
	char cmssuspectm_trandate[11];
	short cmssuspectm_trandate_id;
	long cmssuspectm_serseqno;
	short cmssuspectm_serseqno_id;
	char cmssuspectm_vouchno[17];
	short cmssuspectm_vouchno_id;
	char cmssuspectm_idtype[3];
	short cmssuspectm_idtype_id;
	char cmssuspectm_idcode[21];
	short cmssuspectm_idcode_id;
	char cmssuspectm_custname[71];
	short cmssuspectm_custname_id;
	char cmssuspectm_issuebrc[10];
	short cmssuspectm_issuebrc_id;
	char cmssuspectm_teller[11];
	short cmssuspectm_teller_id;
	char cmssuspectm_cardkind[9];
	short cmssuspectm_cardkind_id;
	char cmssuspectm_status[2];
	short cmssuspectm_status_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSSUSPECTM \
		:cmssuspectm_cardno:cmssuspectm_cardno_id, \
		:cmssuspectm_trandate:cmssuspectm_trandate_id, \
		:cmssuspectm_serseqno:cmssuspectm_serseqno_id, \
		:cmssuspectm_vouchno:cmssuspectm_vouchno_id, \
		:cmssuspectm_idtype:cmssuspectm_idtype_id, \
		:cmssuspectm_idcode:cmssuspectm_idcode_id, \
		:cmssuspectm_custname:cmssuspectm_custname_id, \
		:cmssuspectm_issuebrc:cmssuspectm_issuebrc_id, \
		:cmssuspectm_teller:cmssuspectm_teller_id, \
		:cmssuspectm_cardkind:cmssuspectm_cardkind_id, \
		:cmssuspectm_status:cmssuspectm_status_id

#define UU_CMSSUSPECTM \
		cardno, \
		trandate, \
		serseqno, \
		vouchno, \
		idtype, \
		idcode, \
		custname, \
		issuebrc, \
		teller, \
		cardkind, \
		status

#define WW_CMSSUSPECTM \
		:cmssuspectm_cardno, \
		:cmssuspectm_trandate, \
		:cmssuspectm_serseqno, \
		:cmssuspectm_vouchno, \
		:cmssuspectm_idtype, \
		:cmssuspectm_idcode, \
		:cmssuspectm_custname, \
		:cmssuspectm_issuebrc, \
		:cmssuspectm_teller, \
		:cmssuspectm_cardkind, \
		:cmssuspectm_status

struct cmssuspectm
{
	char	cardno[20];
	char	trandate[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	status[2];
};

void pubInitCmssuspectm()
{
	memset( cmssuspectm_cardno, 0x00, sizeof( cmssuspectm_cardno ) ) ;
	cmssuspectm_cardno_id = 0 ;
	memset( cmssuspectm_trandate, 0x00, sizeof( cmssuspectm_trandate ) ) ;
	cmssuspectm_trandate_id = 0 ;
	memset( &cmssuspectm_serseqno, 0x00, sizeof( cmssuspectm_serseqno ) ) ;
	cmssuspectm_serseqno_id = 0 ;
	memset( cmssuspectm_vouchno, 0x00, sizeof( cmssuspectm_vouchno ) ) ;
	cmssuspectm_vouchno_id = 0 ;
	memset( cmssuspectm_idtype, 0x00, sizeof( cmssuspectm_idtype ) ) ;
	cmssuspectm_idtype_id = 0 ;
	memset( cmssuspectm_idcode, 0x00, sizeof( cmssuspectm_idcode ) ) ;
	cmssuspectm_idcode_id = 0 ;
	memset( cmssuspectm_custname, 0x00, sizeof( cmssuspectm_custname ) ) ;
	cmssuspectm_custname_id = 0 ;
	memset( cmssuspectm_issuebrc, 0x00, sizeof( cmssuspectm_issuebrc ) ) ;
	cmssuspectm_issuebrc_id = 0 ;
	memset( cmssuspectm_teller, 0x00, sizeof( cmssuspectm_teller ) ) ;
	cmssuspectm_teller_id = 0 ;
	memset( cmssuspectm_cardkind, 0x00, sizeof( cmssuspectm_cardkind ) ) ;
	cmssuspectm_cardkind_id = 0 ;
	memset( cmssuspectm_status, 0x00, sizeof( cmssuspectm_status ) ) ;
	cmssuspectm_status_id = 0 ;
}

void pubStoVCmssuspectm( struct cmssuspectm * pstCmssuspectm )
{
	pubInitCmssuspectm();
	if( !strlen( pstCmssuspectm->cardno ) )
		strcpy( pstCmssuspectm->cardno, " " );
	strcpy( cmssuspectm_cardno, pstCmssuspectm->cardno );
	if( !strlen( pstCmssuspectm->trandate ) )
		strcpy( pstCmssuspectm->trandate, " " );
	strcpy( cmssuspectm_trandate, pstCmssuspectm->trandate );
	cmssuspectm_serseqno = pstCmssuspectm->serseqno ;
	if( !strlen( pstCmssuspectm->vouchno ) )
		strcpy( pstCmssuspectm->vouchno, " " );
	strcpy( cmssuspectm_vouchno, pstCmssuspectm->vouchno );
	if( !strlen( pstCmssuspectm->idtype ) )
		strcpy( pstCmssuspectm->idtype, " " );
	strcpy( cmssuspectm_idtype, pstCmssuspectm->idtype );
	if( !strlen( pstCmssuspectm->idcode ) )
		strcpy( pstCmssuspectm->idcode, " " );
	strcpy( cmssuspectm_idcode, pstCmssuspectm->idcode );
	if( !strlen( pstCmssuspectm->custname ) )
		strcpy( pstCmssuspectm->custname, " " );
	strcpy( cmssuspectm_custname, pstCmssuspectm->custname );
	if( !strlen( pstCmssuspectm->issuebrc ) )
		strcpy( pstCmssuspectm->issuebrc, " " );
	strcpy( cmssuspectm_issuebrc, pstCmssuspectm->issuebrc );
	if( !strlen( pstCmssuspectm->teller ) )
		strcpy( pstCmssuspectm->teller, " " );
	strcpy( cmssuspectm_teller, pstCmssuspectm->teller );
	if( !strlen( pstCmssuspectm->cardkind ) )
		strcpy( pstCmssuspectm->cardkind, " " );
	strcpy( cmssuspectm_cardkind, pstCmssuspectm->cardkind );
	if( !strlen( pstCmssuspectm->status ) )
		strcpy( pstCmssuspectm->status, " " );
	strcpy( cmssuspectm_status, pstCmssuspectm->status );
}

void pubVtoSCmssuspectm( struct cmssuspectm * pstCmssuspectm )
{
	strcpy( pstCmssuspectm->cardno, cmssuspectm_cardno );
	strpack( pstCmssuspectm->cardno );
	strcpy( pstCmssuspectm->trandate, cmssuspectm_trandate );
	strpack( pstCmssuspectm->trandate );
	pstCmssuspectm->serseqno = cmssuspectm_serseqno ;
	strcpy( pstCmssuspectm->vouchno, cmssuspectm_vouchno );
	strpack( pstCmssuspectm->vouchno );
	strcpy( pstCmssuspectm->idtype, cmssuspectm_idtype );
	strpack( pstCmssuspectm->idtype );
	strcpy( pstCmssuspectm->idcode, cmssuspectm_idcode );
	strpack( pstCmssuspectm->idcode );
	strcpy( pstCmssuspectm->custname, cmssuspectm_custname );
	strpack( pstCmssuspectm->custname );
	strcpy( pstCmssuspectm->issuebrc, cmssuspectm_issuebrc );
	strpack( pstCmssuspectm->issuebrc );
	strcpy( pstCmssuspectm->teller, cmssuspectm_teller );
	strpack( pstCmssuspectm->teller );
	strcpy( pstCmssuspectm->cardkind, cmssuspectm_cardkind );
	strpack( pstCmssuspectm->cardkind );
	strcpy( pstCmssuspectm->status, cmssuspectm_status );
	strpack( pstCmssuspectm->status );
}

int pubReadCmssuspectm( struct cmssuspectm * pstCmssuspectm )
{
	pubInitCmssuspectm();
	pubStoVCmssuspectm(pstCmssuspectm);
	EXEC SQL SELECT * INTO RR_CMSSUSPECTM 
		FROM cmssuspectm  
		WHERE  
		 cardno = :cmssuspectm_cardno and 
		 trandate = :cmssuspectm_trandate and 
		 serseqno = :cmssuspectm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmssuspectm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmssuspectm(pstCmssuspectm);
	return 0; 
} 
 
int pubModiCmssuspectm( struct cmssuspectm * pstCmssuspectm )
{
	pubInitCmssuspectm();
	pubStoVCmssuspectm(pstCmssuspectm);
	EXEC SQL UPDATE cmssuspectm 
		SET ( UU_CMSSUSPECTM ) = ( WW_CMSSUSPECTM ) 
		WHERE  
		 cardno = :cmssuspectm_cardno and 
		 trandate = :cmssuspectm_trandate and 
		 serseqno = :cmssuspectm_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmssuspectm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmssuspectm( struct cmssuspectm * pstCmssuspectm )
{
	pubInitCmssuspectm();
	pubStoVCmssuspectm(pstCmssuspectm);
	EXEC SQL INSERT INTO cmssuspectm VALUES ( RR_CMSSUSPECTM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmssuspectm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}