tbcms015.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 cmsbussprd_busskind[6];
	short cmsbussprd_busskind_id;
	char cmsbussprd_prdcod[8];
	short cmsbussprd_prdcod_id;
	char cmsbussprd_description[41];
	short cmsbussprd_description_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSBUSSPRD \
		:cmsbussprd_busskind:cmsbussprd_busskind_id, \
		:cmsbussprd_prdcod:cmsbussprd_prdcod_id, \
		:cmsbussprd_description:cmsbussprd_description_id

#define UU_CMSBUSSPRD \
		busskind, \
		prdcod, \
		description

#define WW_CMSBUSSPRD \
		:cmsbussprd_busskind, \
		:cmsbussprd_prdcod, \
		:cmsbussprd_description

struct cmsbussprd
{
	char	busskind[6];
	char	prdcod[8];
	char	description[41];
};

void pubInitCmsbussprd()
{
	memset( cmsbussprd_busskind, 0x00, sizeof( cmsbussprd_busskind ) ) ;
	cmsbussprd_busskind_id = 0 ;
	memset( cmsbussprd_prdcod, 0x00, sizeof( cmsbussprd_prdcod ) ) ;
	cmsbussprd_prdcod_id = 0 ;
	memset( cmsbussprd_description, 0x00, sizeof( cmsbussprd_description ) ) ;
	cmsbussprd_description_id = 0 ;
}

void pubStoVCmsbussprd( struct cmsbussprd * pstCmsbussprd )
{
	pubInitCmsbussprd();
	if( !strlen( pstCmsbussprd->busskind ) )
		strcpy( pstCmsbussprd->busskind, " " );
	strcpy( cmsbussprd_busskind, pstCmsbussprd->busskind );
	if( !strlen( pstCmsbussprd->prdcod ) )
		strcpy( pstCmsbussprd->prdcod, " " );
	strcpy( cmsbussprd_prdcod, pstCmsbussprd->prdcod );
	if( !strlen( pstCmsbussprd->description ) )
		strcpy( pstCmsbussprd->description, " " );
	strcpy( cmsbussprd_description, pstCmsbussprd->description );
}

void pubVtoSCmsbussprd( struct cmsbussprd * pstCmsbussprd )
{
	strcpy( pstCmsbussprd->busskind, cmsbussprd_busskind );
	strpack( pstCmsbussprd->busskind );
	strcpy( pstCmsbussprd->prdcod, cmsbussprd_prdcod );
	strpack( pstCmsbussprd->prdcod );
	strcpy( pstCmsbussprd->description, cmsbussprd_description );
	strpack( pstCmsbussprd->description );
}

int pubReadCmsbussprd( struct cmsbussprd * pstCmsbussprd )
{
	pubInitCmsbussprd();
	pubStoVCmsbussprd(pstCmsbussprd);
	EXEC SQL SELECT * INTO RR_CMSBUSSPRD 
		FROM cmsbussprd  
		WHERE  
		 busskind = :cmsbussprd_busskind  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsbussprd",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsbussprd(pstCmsbussprd);
	return 0; 
} 
 
int pubModiCmsbussprd( struct cmsbussprd * pstCmsbussprd )
{
	pubInitCmsbussprd();
	pubStoVCmsbussprd(pstCmsbussprd);
	EXEC SQL UPDATE cmsbussprd 
		SET ( UU_CMSBUSSPRD ) = ( WW_CMSBUSSPRD ) 
		WHERE  
		 busskind = :cmsbussprd_busskind  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsbussprd",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsbussprd( struct cmsbussprd * pstCmsbussprd )
{
	pubInitCmsbussprd();
	pubStoVCmsbussprd(pstCmsbussprd);
	EXEC SQL INSERT INTO cmsbussprd VALUES ( RR_CMSBUSSPRD ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsbussprd",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}