tbcms014.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 cmsvouseqno_voukind[4];
	short cmsvouseqno_voukind_id;
	char cmsvouseqno_precharcode[7];
	short cmsvouseqno_precharcode_id;
	char cmsvouseqno_vouseqno[21];
	short cmsvouseqno_vouseqno_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSVOUSEQNO \
		:cmsvouseqno_voukind:cmsvouseqno_voukind_id, \
		:cmsvouseqno_precharcode:cmsvouseqno_precharcode_id, \
		:cmsvouseqno_vouseqno:cmsvouseqno_vouseqno_id

#define UU_CMSVOUSEQNO \
		voukind, \
		precharcode, \
		vouseqno

#define WW_CMSVOUSEQNO \
		:cmsvouseqno_voukind, \
		:cmsvouseqno_precharcode, \
		:cmsvouseqno_vouseqno

struct cmsvouseqno
{
	char	voukind[4];
	char	precharcode[7];
	char	vouseqno[21];
};

void pubInitCmsvouseqno()
{
	memset( cmsvouseqno_voukind, 0x00, sizeof( cmsvouseqno_voukind ) ) ;
	cmsvouseqno_voukind_id = 0 ;
	memset( cmsvouseqno_precharcode, 0x00, sizeof( cmsvouseqno_precharcode ) ) ;
	cmsvouseqno_precharcode_id = 0 ;
	memset( cmsvouseqno_vouseqno, 0x00, sizeof( cmsvouseqno_vouseqno ) ) ;
	cmsvouseqno_vouseqno_id = 0 ;
}

void pubStoVCmsvouseqno( struct cmsvouseqno * pstCmsvouseqno )
{
	pubInitCmsvouseqno();
	if( !strlen( pstCmsvouseqno->voukind ) )
		strcpy( pstCmsvouseqno->voukind, " " );
	strcpy( cmsvouseqno_voukind, pstCmsvouseqno->voukind );
	if( !strlen( pstCmsvouseqno->precharcode ) )
		strcpy( pstCmsvouseqno->precharcode, " " );
	strcpy( cmsvouseqno_precharcode, pstCmsvouseqno->precharcode );
	if( !strlen( pstCmsvouseqno->vouseqno ) )
		strcpy( pstCmsvouseqno->vouseqno, " " );
	strcpy( cmsvouseqno_vouseqno, pstCmsvouseqno->vouseqno );
}

void pubVtoSCmsvouseqno( struct cmsvouseqno * pstCmsvouseqno )
{
	strcpy( pstCmsvouseqno->voukind, cmsvouseqno_voukind );
	strpack( pstCmsvouseqno->voukind );
	strcpy( pstCmsvouseqno->precharcode, cmsvouseqno_precharcode );
	strpack( pstCmsvouseqno->precharcode );
	strcpy( pstCmsvouseqno->vouseqno, cmsvouseqno_vouseqno );
	strpack( pstCmsvouseqno->vouseqno );
}



int pubReadCmsvouseqno( struct cmsvouseqno * pstCmsvouseqno )
{
	pubInitCmsvouseqno();
	pubStoVCmsvouseqno(pstCmsvouseqno);
	EXEC SQL SELECT * INTO RR_CMSVOUSEQNO 
		FROM cmsvouseqno  
		WHERE  
		 voukind = :cmsvouseqno_voukind and 
		 precharcode = :cmsvouseqno_precharcode  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsvouseqno",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsvouseqno(pstCmsvouseqno);
	return 0; 
} 
 


int pubModiCmsvouseqno( struct cmsvouseqno * pstCmsvouseqno )
{
	pubInitCmsvouseqno();
	pubStoVCmsvouseqno(pstCmsvouseqno);
	EXEC SQL UPDATE cmsvouseqno 
		SET ( UU_CMSVOUSEQNO ) = ( WW_CMSVOUSEQNO ) 
		WHERE  
		 voukind = :cmsvouseqno_voukind and 
		 precharcode = :cmsvouseqno_precharcode  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsvouseqno",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmsvouseqno( struct cmsvouseqno * pstCmsvouseqno )
{
	pubInitCmsvouseqno();
	pubStoVCmsvouseqno(pstCmsvouseqno);
	EXEC SQL INSERT INTO cmsvouseqno VALUES ( RR_CMSVOUSEQNO ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsvouseqno",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}