tbcms009.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 cmscuscdnum_custno[31];
	short cmscuscdnum_custno_id;
	char cmscuscdnum_cardkind[9];
	short cmscuscdnum_cardkind_id;
	char cmscuscdnum_cardflg[2];
	short cmscuscdnum_cardflg_id;
	long cmscuscdnum_crdnum;
	short cmscuscdnum_crdnum_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCUSCDNUM \
		:cmscuscdnum_custno:cmscuscdnum_custno_id, \
		:cmscuscdnum_cardkind:cmscuscdnum_cardkind_id, \
		:cmscuscdnum_cardflg:cmscuscdnum_cardflg_id, \
		:cmscuscdnum_crdnum:cmscuscdnum_crdnum_id

#define UU_CMSCUSCDNUM \
		custno, \
		cardkind, \
		cardflg, \
		crdnum

#define WW_CMSCUSCDNUM \
		:cmscuscdnum_custno, \
		:cmscuscdnum_cardkind, \
		:cmscuscdnum_cardflg, \
		:cmscuscdnum_crdnum

struct cmscuscdnum
{
	char	custno[31];
	char	cardkind[9];
	char	cardflg[2];
	long	crdnum;
};

void pubInitCmscuscdnum()
{
	memset( cmscuscdnum_custno, 0x00, sizeof( cmscuscdnum_custno ) ) ;
	cmscuscdnum_custno_id = 0 ;
	memset( cmscuscdnum_cardkind, 0x00, sizeof( cmscuscdnum_cardkind ) ) ;
	cmscuscdnum_cardkind_id = 0 ;
	memset( cmscuscdnum_cardflg, 0x00, sizeof( cmscuscdnum_cardflg ) ) ;
	cmscuscdnum_cardflg_id = 0 ;
	memset( &cmscuscdnum_crdnum, 0x00, sizeof( cmscuscdnum_crdnum ) ) ;
	cmscuscdnum_crdnum_id = 0 ;
}

void pubStoVCmscuscdnum( struct cmscuscdnum * pstCmscuscdnum )
{
	pubInitCmscuscdnum();
	if( !strlen( pstCmscuscdnum->custno ) )
		strcpy( pstCmscuscdnum->custno, " " );
	strcpy( cmscuscdnum_custno, pstCmscuscdnum->custno );
	if( !strlen( pstCmscuscdnum->cardkind ) )
		strcpy( pstCmscuscdnum->cardkind, " " );
	strcpy( cmscuscdnum_cardkind, pstCmscuscdnum->cardkind );
	if( !strlen( pstCmscuscdnum->cardflg ) )
		strcpy( pstCmscuscdnum->cardflg, " " );
	strcpy( cmscuscdnum_cardflg, pstCmscuscdnum->cardflg );
	cmscuscdnum_crdnum = pstCmscuscdnum->crdnum ;
}

void pubVtoSCmscuscdnum( struct cmscuscdnum * pstCmscuscdnum )
{
	strcpy( pstCmscuscdnum->custno, cmscuscdnum_custno );
	strpack( pstCmscuscdnum->custno );
	strcpy( pstCmscuscdnum->cardkind, cmscuscdnum_cardkind );
	strpack( pstCmscuscdnum->cardkind );
	strcpy( pstCmscuscdnum->cardflg, cmscuscdnum_cardflg );
	strpack( pstCmscuscdnum->cardflg );
	pstCmscuscdnum->crdnum = cmscuscdnum_crdnum ;
}

int pubReadCmscuscdnum( struct cmscuscdnum * pstCmscuscdnum )
{
	pubInitCmscuscdnum();
	pubStoVCmscuscdnum(pstCmscuscdnum);
	EXEC SQL SELECT * INTO RR_CMSCUSCDNUM 
		FROM cmscuscdnum  
		WHERE  
		 custno = :cmscuscdnum_custno and 
		 cardkind = :cmscuscdnum_cardkind and 
		 cardflg = :cmscuscdnum_cardflg  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscuscdnum",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscuscdnum(pstCmscuscdnum);
	return 0; 
} 
 
int pubModiCmscuscdnum( struct cmscuscdnum * pstCmscuscdnum )
{
	pubInitCmscuscdnum();
	pubStoVCmscuscdnum(pstCmscuscdnum);
	EXEC SQL UPDATE cmscuscdnum 
		SET ( UU_CMSCUSCDNUM ) = ( WW_CMSCUSCDNUM ) 
		WHERE  
		 custno = :cmscuscdnum_custno and 
		 cardkind = :cmscuscdnum_cardkind and 
		 cardflg = :cmscuscdnum_cardflg  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscuscdnum",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmscuscdnum( struct cmscuscdnum * pstCmscuscdnum )
{
	pubInitCmscuscdnum();
	pubStoVCmscuscdnum(pstCmscuscdnum);
	EXEC SQL INSERT INTO cmscuscdnum VALUES ( RR_CMSCUSCDNUM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscuscdnum",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}