tbcms054.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 cmsintegralmid_accummode[5];
	short cmsintegralmid_accummode_id;
	char cmsintegralmid_mid[16];
	short cmsintegralmid_mid_id;
	char cmsintegralmid_mctmcc[5];
	short cmsintegralmid_mctmcc_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSINTEGRALMID \
		:cmsintegralmid_accummode:cmsintegralmid_accummode_id, \
		:cmsintegralmid_mid:cmsintegralmid_mid_id, \
		:cmsintegralmid_mctmcc:cmsintegralmid_mctmcc_id

#define UU_CMSINTEGRALMID \
		accummode, \
		mid, \
		mctmcc

#define WW_CMSINTEGRALMID \
		:cmsintegralmid_accummode, \
		:cmsintegralmid_mid, \
		:cmsintegralmid_mctmcc

struct cmsintegralmid
{
	char	accummode[5];
	char	mid[16];
	char	mctmcc[5];
};

void pubInitCmsintegralmid()
{
	memset( cmsintegralmid_accummode, 0x00, sizeof( cmsintegralmid_accummode ) ) ;
	cmsintegralmid_accummode_id = 0 ;
	memset( cmsintegralmid_mid, 0x00, sizeof( cmsintegralmid_mid ) ) ;
	cmsintegralmid_mid_id = 0 ;
	memset( cmsintegralmid_mctmcc, 0x00, sizeof( cmsintegralmid_mctmcc ) ) ;
	cmsintegralmid_mctmcc_id = 0 ;
}

void pubStoVCmsintegralmid( struct cmsintegralmid * pstCmsintegralmid )
{
	pubInitCmsintegralmid();
	if( !strlen( pstCmsintegralmid->accummode ) )
		strcpy( pstCmsintegralmid->accummode, " " );
	strcpy( cmsintegralmid_accummode, pstCmsintegralmid->accummode );
	if( !strlen( pstCmsintegralmid->mid ) )
		strcpy( pstCmsintegralmid->mid, " " );
	strcpy( cmsintegralmid_mid, pstCmsintegralmid->mid );
	if( !strlen( pstCmsintegralmid->mctmcc ) )
		strcpy( pstCmsintegralmid->mctmcc, " " );
	strcpy( cmsintegralmid_mctmcc, pstCmsintegralmid->mctmcc );
}

void pubVtoSCmsintegralmid( struct cmsintegralmid * pstCmsintegralmid )
{
	strcpy( pstCmsintegralmid->accummode, cmsintegralmid_accummode );
	strpack( pstCmsintegralmid->accummode );
	strcpy( pstCmsintegralmid->mid, cmsintegralmid_mid );
	strpack( pstCmsintegralmid->mid );
	strcpy( pstCmsintegralmid->mctmcc, cmsintegralmid_mctmcc );
	strpack( pstCmsintegralmid->mctmcc );
}

int pubReadCmsintegralmid( struct cmsintegralmid * pstCmsintegralmid )
{
	pubInitCmsintegralmid();
	pubStoVCmsintegralmid(pstCmsintegralmid);
	EXEC SQL SELECT * INTO RR_CMSINTEGRALMID 
		FROM cmsintegralmid  
		WHERE  
		 accummode = :cmsintegralmid_accummode and 
		 mid = :cmsintegralmid_mid and 
		 mctmcc = :cmsintegralmid_mctmcc  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsintegralmid",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsintegralmid(pstCmsintegralmid);
	return 0; 
} 
 
int pubModiCmsintegralmid( struct cmsintegralmid * pstCmsintegralmid )
{
	pubInitCmsintegralmid();
	pubStoVCmsintegralmid(pstCmsintegralmid);
	EXEC SQL UPDATE cmsintegralmid 
		SET ( UU_CMSINTEGRALMID ) = ( WW_CMSINTEGRALMID ) 
		WHERE  
		 accummode = :cmsintegralmid_accummode and 
		 mid = :cmsintegralmid_mid and 
		 mctmcc = :cmsintegralmid_mctmcc  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsintegralmid",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsintegralmid( struct cmsintegralmid * pstCmsintegralmid )
{
	pubInitCmsintegralmid();
	pubStoVCmsintegralmid(pstCmsintegralmid);
	EXEC SQL INSERT INTO cmsintegralmid VALUES ( RR_CMSINTEGRALMID ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsintegralmid",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}