tbcms006.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 cmsckmidref_cardkind[9];
	short cmsckmidref_cardkind_id;
	char cmsckmidref_mid[16];
	short cmsckmidref_mid_id;
	char cmsckmidref_memo[41];
	short cmsckmidref_memo_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCKMIDREF \
		:cmsckmidref_cardkind:cmsckmidref_cardkind_id, \
		:cmsckmidref_mid:cmsckmidref_mid_id, \
		:cmsckmidref_memo:cmsckmidref_memo_id

#define UU_CMSCKMIDREF \
		cardkind, \
		mid, \
		memo

#define WW_CMSCKMIDREF \
		:cmsckmidref_cardkind, \
		:cmsckmidref_mid, \
		:cmsckmidref_memo

struct cmsckmidref
{
	char	cardkind[9];
	char	mid[16];
	char	memo[41];
};

void pubInitCmsckmidref()
{
	memset( cmsckmidref_cardkind, 0x00, sizeof( cmsckmidref_cardkind ) ) ;
	cmsckmidref_cardkind_id = 0 ;
	memset( cmsckmidref_mid, 0x00, sizeof( cmsckmidref_mid ) ) ;
	cmsckmidref_mid_id = 0 ;
	memset( cmsckmidref_memo, 0x00, sizeof( cmsckmidref_memo ) ) ;
	cmsckmidref_memo_id = 0 ;
}

void pubStoVCmsckmidref( struct cmsckmidref * pstCmsckmidref )
{
	pubInitCmsckmidref();
	if( !strlen( pstCmsckmidref->cardkind ) )
		strcpy( pstCmsckmidref->cardkind, " " );
	strcpy( cmsckmidref_cardkind, pstCmsckmidref->cardkind );
	if( !strlen( pstCmsckmidref->mid ) )
		strcpy( pstCmsckmidref->mid, " " );
	strcpy( cmsckmidref_mid, pstCmsckmidref->mid );
	if( !strlen( pstCmsckmidref->memo ) )
		strcpy( pstCmsckmidref->memo, " " );
	strcpy( cmsckmidref_memo, pstCmsckmidref->memo );
}

void pubVtoSCmsckmidref( struct cmsckmidref * pstCmsckmidref )
{
	strcpy( pstCmsckmidref->cardkind, cmsckmidref_cardkind );
	strpack( pstCmsckmidref->cardkind );
	strcpy( pstCmsckmidref->mid, cmsckmidref_mid );
	strpack( pstCmsckmidref->mid );
	strcpy( pstCmsckmidref->memo, cmsckmidref_memo );
	strpack( pstCmsckmidref->memo );
}

int pubReadCmsckmidref( struct cmsckmidref * pstCmsckmidref )
{
	pubInitCmsckmidref();
	pubStoVCmsckmidref(pstCmsckmidref);
	EXEC SQL SELECT * INTO RR_CMSCKMIDREF 
		FROM cmsckmidref  
		WHERE  
		 cardkind = :cmsckmidref_cardkind and 
		 mid = :cmsckmidref_mid  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsckmidref",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsckmidref(pstCmsckmidref);
	return 0; 
} 
 
int pubModiCmsckmidref( struct cmsckmidref * pstCmsckmidref )
{
	pubInitCmsckmidref();
	pubStoVCmsckmidref(pstCmsckmidref);
	EXEC SQL UPDATE cmsckmidref 
		SET ( UU_CMSCKMIDREF ) = ( WW_CMSCKMIDREF ) 
		WHERE  
		 cardkind = :cmsckmidref_cardkind and 
		 mid = :cmsckmidref_mid  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsckmidref",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsckmidref( struct cmsckmidref * pstCmsckmidref )
{
	pubInitCmsckmidref();
	pubStoVCmsckmidref(pstCmsckmidref);
	EXEC SQL INSERT INTO cmsckmidref VALUES ( RR_CMSCKMIDREF ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsckmidref",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}