tbcms012.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 cmstbsreginf_acctno[33];
	short cmstbsreginf_acctno_id;
	char cmstbsreginf_inqpasswd[17];
	short cmstbsreginf_inqpasswd_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTBSREGINF \
		:cmstbsreginf_acctno:cmstbsreginf_acctno_id, \
		:cmstbsreginf_inqpasswd:cmstbsreginf_inqpasswd_id

#define UU_CMSTBSREGINF \
		acctno, \
		inqpasswd

#define WW_CMSTBSREGINF \
		:cmstbsreginf_acctno, \
		:cmstbsreginf_inqpasswd

struct cmstbsreginf
{
	char	acctno[33];
	char	inqpasswd[17];
};

void pubInitCmstbsreginf()
{
	memset( cmstbsreginf_acctno, 0x00, sizeof( cmstbsreginf_acctno ) ) ;
	cmstbsreginf_acctno_id = 0 ;
	memset( cmstbsreginf_inqpasswd, 0x00, sizeof( cmstbsreginf_inqpasswd ) ) ;
	cmstbsreginf_inqpasswd_id = 0 ;
}

void pubStoVCmstbsreginf( struct cmstbsreginf * pstCmstbsreginf )
{
	pubInitCmstbsreginf();
	if( !strlen( pstCmstbsreginf->acctno ) )
		strcpy( pstCmstbsreginf->acctno, " " );
	strcpy( cmstbsreginf_acctno, pstCmstbsreginf->acctno );
	if( !strlen( pstCmstbsreginf->inqpasswd ) )
		strcpy( pstCmstbsreginf->inqpasswd, " " );
	strcpy( cmstbsreginf_inqpasswd, pstCmstbsreginf->inqpasswd );
}

void pubVtoSCmstbsreginf( struct cmstbsreginf * pstCmstbsreginf )
{
	strcpy( pstCmstbsreginf->acctno, cmstbsreginf_acctno );
	strpack( pstCmstbsreginf->acctno );
	strcpy( pstCmstbsreginf->inqpasswd, cmstbsreginf_inqpasswd );
	strpack( pstCmstbsreginf->inqpasswd );
}

int pubReadCmstbsreginf( struct cmstbsreginf * pstCmstbsreginf )
{
	pubInitCmstbsreginf();
	pubStoVCmstbsreginf(pstCmstbsreginf);
	EXEC SQL SELECT * INTO RR_CMSTBSREGINF 
		FROM cmstbsreginf  
		WHERE  
		 acctno = :cmstbsreginf_acctno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmstbsreginf",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmstbsreginf(pstCmstbsreginf);
	return 0; 
} 
 
int pubModiCmstbsreginf( struct cmstbsreginf * pstCmstbsreginf )
{
	pubInitCmstbsreginf();
	pubStoVCmstbsreginf(pstCmstbsreginf);
	EXEC SQL UPDATE cmstbsreginf 
		SET ( UU_CMSTBSREGINF ) = ( WW_CMSTBSREGINF ) 
		WHERE  
		 acctno = :cmstbsreginf_acctno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmstbsreginf",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmstbsreginf( struct cmstbsreginf * pstCmstbsreginf )
{
	pubInitCmstbsreginf();
	pubStoVCmstbsreginf(pstCmstbsreginf);
	EXEC SQL INSERT INTO cmstbsreginf VALUES ( RR_CMSTBSREGINF ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmstbsreginf",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}