tbcms042.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 cmschannel_trandevtype[3];
	short cmschannel_trandevtype_id;
	char cmschannel_name[71];
	short cmschannel_name_id;
	char cmschannel_optrandevtype[3];
	short cmschannel_optrandevtype_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSCHANNEL \
		:cmschannel_trandevtype:cmschannel_trandevtype_id, \
		:cmschannel_name:cmschannel_name_id, \
		:cmschannel_optrandevtype:cmschannel_optrandevtype_id

#define UU_CMSCHANNEL \
		trandevtype, \
		name, \
		optrandevtype

#define WW_CMSCHANNEL \
		:cmschannel_trandevtype, \
		:cmschannel_name, \
		:cmschannel_optrandevtype

struct cmschannel
{
	char	trandevtype[3];
	char	name[71];
	char	optrandevtype[3];
};

void pubInitCmschannel()
{
	memset( cmschannel_trandevtype, 0x00, sizeof( cmschannel_trandevtype ) ) ;
	cmschannel_trandevtype_id = 0 ;
	memset( cmschannel_name, 0x00, sizeof( cmschannel_name ) ) ;
	cmschannel_name_id = 0 ;
	memset( cmschannel_optrandevtype, 0x00, sizeof( cmschannel_optrandevtype ) ) ;
	cmschannel_optrandevtype_id = 0 ;
}

void pubStoVCmschannel( struct cmschannel * pstCmschannel )
{
	pubInitCmschannel();
	if( !strlen( pstCmschannel->trandevtype ) )
		strcpy( pstCmschannel->trandevtype, " " );
	strcpy( cmschannel_trandevtype, pstCmschannel->trandevtype );
	if( !strlen( pstCmschannel->name ) )
		strcpy( pstCmschannel->name, " " );
	strcpy( cmschannel_name, pstCmschannel->name );
	if( !strlen( pstCmschannel->optrandevtype ) )
		strcpy( pstCmschannel->optrandevtype, " " );
	strcpy( cmschannel_optrandevtype, pstCmschannel->optrandevtype );
}

void pubVtoSCmschannel( struct cmschannel * pstCmschannel )
{
	strcpy( pstCmschannel->trandevtype, cmschannel_trandevtype );
	strpack( pstCmschannel->trandevtype );
	strcpy( pstCmschannel->name, cmschannel_name );
	strpack( pstCmschannel->name );
	strcpy( pstCmschannel->optrandevtype, cmschannel_optrandevtype );
	strpack( pstCmschannel->optrandevtype );
}

int pubReadCmschannel( struct cmschannel * pstCmschannel )
{
	pubInitCmschannel();
	pubStoVCmschannel(pstCmschannel);
	EXEC SQL SELECT * INTO RR_CMSCHANNEL 
		FROM cmschannel  
		WHERE  
		 trandevtype = :cmschannel_trandevtype  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmschannel",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmschannel(pstCmschannel);
	return 0; 
} 
 
int pubModiCmschannel( struct cmschannel * pstCmschannel )
{
	pubInitCmschannel();
	pubStoVCmschannel(pstCmschannel);
	EXEC SQL UPDATE cmschannel 
		SET ( UU_CMSCHANNEL ) = ( WW_CMSCHANNEL ) 
		WHERE  
		 trandevtype = :cmschannel_trandevtype  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmschannel",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmschannel( struct cmschannel * pstCmschannel )
{
	pubInitCmschannel();
	pubStoVCmschannel(pstCmschannel);
	EXEC SQL INSERT INTO cmschannel VALUES ( RR_CMSCHANNEL ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmschannel",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}