tbcms052.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 cmsintegralcfg_accummode[5];
	short cmsintegralcfg_accummode_id;
	char cmsintegralcfg_desc[71];
	short cmsintegralcfg_desc_id;
	char cmsintegralcfg_setdate[11];
	short cmsintegralcfg_setdate_id;
	char cmsintegralcfg_setbrc[10];
	short cmsintegralcfg_setbrc_id;
	char cmsintegralcfg_setteller[11];
	short cmsintegralcfg_setteller_id;
	long cmsintegralcfg_begnum;
	short cmsintegralcfg_begnum_id;
	char cmsintegralcfg_accumtype[2];
	short cmsintegralcfg_accumtype_id;
	char cmsintegralcfg_accumbegdate[11];
	short cmsintegralcfg_accumbegdate_id;
	char cmsintegralcfg_accumenddate[11];
	short cmsintegralcfg_accumenddate_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSINTEGRALCFG \
		:cmsintegralcfg_accummode:cmsintegralcfg_accummode_id, \
		:cmsintegralcfg_desc:cmsintegralcfg_desc_id, \
		:cmsintegralcfg_setdate:cmsintegralcfg_setdate_id, \
		:cmsintegralcfg_setbrc:cmsintegralcfg_setbrc_id, \
		:cmsintegralcfg_setteller:cmsintegralcfg_setteller_id, \
		:cmsintegralcfg_begnum:cmsintegralcfg_begnum_id, \
		:cmsintegralcfg_accumtype:cmsintegralcfg_accumtype_id, \
		:cmsintegralcfg_accumbegdate:cmsintegralcfg_accumbegdate_id, \
		:cmsintegralcfg_accumenddate:cmsintegralcfg_accumenddate_id

#define UU_CMSINTEGRALCFG \
		accummode, \
		desc, \
		setdate, \
		setbrc, \
		setteller, \
		begnum, \
		accumtype, \
		accumbegdate, \
		accumenddate

#define WW_CMSINTEGRALCFG \
		:cmsintegralcfg_accummode, \
		:cmsintegralcfg_desc, \
		:cmsintegralcfg_setdate, \
		:cmsintegralcfg_setbrc, \
		:cmsintegralcfg_setteller, \
		:cmsintegralcfg_begnum, \
		:cmsintegralcfg_accumtype, \
		:cmsintegralcfg_accumbegdate, \
		:cmsintegralcfg_accumenddate

struct cmsintegralcfg
{
	char	accummode[5];
	char	desc[71];
	char	setdate[11];
	char	setbrc[10];
	char	setteller[11];
	long	begnum;
	char	accumtype[2];
	char	accumbegdate[11];
	char	accumenddate[11];
};

void pubInitCmsintegralcfg()
{
	memset( cmsintegralcfg_accummode, 0x00, sizeof( cmsintegralcfg_accummode ) ) ;
	cmsintegralcfg_accummode_id = 0 ;
	memset( cmsintegralcfg_desc, 0x00, sizeof( cmsintegralcfg_desc ) ) ;
	cmsintegralcfg_desc_id = 0 ;
	memset( cmsintegralcfg_setdate, 0x00, sizeof( cmsintegralcfg_setdate ) ) ;
	cmsintegralcfg_setdate_id = 0 ;
	memset( cmsintegralcfg_setbrc, 0x00, sizeof( cmsintegralcfg_setbrc ) ) ;
	cmsintegralcfg_setbrc_id = 0 ;
	memset( cmsintegralcfg_setteller, 0x00, sizeof( cmsintegralcfg_setteller ) ) ;
	cmsintegralcfg_setteller_id = 0 ;
	memset( &cmsintegralcfg_begnum, 0x00, sizeof( cmsintegralcfg_begnum ) ) ;
	cmsintegralcfg_begnum_id = 0 ;
	memset( cmsintegralcfg_accumtype, 0x00, sizeof( cmsintegralcfg_accumtype ) ) ;
	cmsintegralcfg_accumtype_id = 0 ;
	memset( cmsintegralcfg_accumbegdate, 0x00, sizeof( cmsintegralcfg_accumbegdate ) ) ;
	cmsintegralcfg_accumbegdate_id = 0 ;
	memset( cmsintegralcfg_accumenddate, 0x00, sizeof( cmsintegralcfg_accumenddate ) ) ;
	cmsintegralcfg_accumenddate_id = 0 ;
}

void pubStoVCmsintegralcfg( struct cmsintegralcfg * pstCmsintegralcfg )
{
	pubInitCmsintegralcfg();
	if( !strlen( pstCmsintegralcfg->accummode ) )
		strcpy( pstCmsintegralcfg->accummode, " " );
	strcpy( cmsintegralcfg_accummode, pstCmsintegralcfg->accummode );
	if( !strlen( pstCmsintegralcfg->desc ) )
		strcpy( pstCmsintegralcfg->desc, " " );
	strcpy( cmsintegralcfg_desc, pstCmsintegralcfg->desc );
	if( !strlen( pstCmsintegralcfg->setdate ) )
		strcpy( pstCmsintegralcfg->setdate, " " );
	strcpy( cmsintegralcfg_setdate, pstCmsintegralcfg->setdate );
	if( !strlen( pstCmsintegralcfg->setbrc ) )
		strcpy( pstCmsintegralcfg->setbrc, " " );
	strcpy( cmsintegralcfg_setbrc, pstCmsintegralcfg->setbrc );
	if( !strlen( pstCmsintegralcfg->setteller ) )
		strcpy( pstCmsintegralcfg->setteller, " " );
	strcpy( cmsintegralcfg_setteller, pstCmsintegralcfg->setteller );
	cmsintegralcfg_begnum = pstCmsintegralcfg->begnum ;
	if( !strlen( pstCmsintegralcfg->accumtype ) )
		strcpy( pstCmsintegralcfg->accumtype, " " );
	strcpy( cmsintegralcfg_accumtype, pstCmsintegralcfg->accumtype );
	if( !strlen( pstCmsintegralcfg->accumbegdate ) )
		strcpy( pstCmsintegralcfg->accumbegdate, " " );
	strcpy( cmsintegralcfg_accumbegdate, pstCmsintegralcfg->accumbegdate );
	if( !strlen( pstCmsintegralcfg->accumenddate ) )
		strcpy( pstCmsintegralcfg->accumenddate, " " );
	strcpy( cmsintegralcfg_accumenddate, pstCmsintegralcfg->accumenddate );
}

void pubVtoSCmsintegralcfg( struct cmsintegralcfg * pstCmsintegralcfg )
{
	strcpy( pstCmsintegralcfg->accummode, cmsintegralcfg_accummode );
	strpack( pstCmsintegralcfg->accummode );
	strcpy( pstCmsintegralcfg->desc, cmsintegralcfg_desc );
	strpack( pstCmsintegralcfg->desc );
	strcpy( pstCmsintegralcfg->setdate, cmsintegralcfg_setdate );
	strpack( pstCmsintegralcfg->setdate );
	strcpy( pstCmsintegralcfg->setbrc, cmsintegralcfg_setbrc );
	strpack( pstCmsintegralcfg->setbrc );
	strcpy( pstCmsintegralcfg->setteller, cmsintegralcfg_setteller );
	strpack( pstCmsintegralcfg->setteller );
	pstCmsintegralcfg->begnum = cmsintegralcfg_begnum ;
	strcpy( pstCmsintegralcfg->accumtype, cmsintegralcfg_accumtype );
	strpack( pstCmsintegralcfg->accumtype );
	strcpy( pstCmsintegralcfg->accumbegdate, cmsintegralcfg_accumbegdate );
	strpack( pstCmsintegralcfg->accumbegdate );
	strcpy( pstCmsintegralcfg->accumenddate, cmsintegralcfg_accumenddate );
	strpack( pstCmsintegralcfg->accumenddate );
}

int pubReadCmsintegralcfg( struct cmsintegralcfg * pstCmsintegralcfg )
{
	pubInitCmsintegralcfg();
	pubStoVCmsintegralcfg(pstCmsintegralcfg);
	EXEC SQL SELECT * INTO RR_CMSINTEGRALCFG 
		FROM cmsintegralcfg  
		WHERE  
		 accummode = :cmsintegralcfg_accummode  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsintegralcfg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsintegralcfg(pstCmsintegralcfg);
	return 0; 
} 
 
int pubModiCmsintegralcfg( struct cmsintegralcfg * pstCmsintegralcfg )
{
	pubInitCmsintegralcfg();
	pubStoVCmsintegralcfg(pstCmsintegralcfg);
	EXEC SQL UPDATE cmsintegralcfg 
		SET ( UU_CMSINTEGRALCFG ) = ( WW_CMSINTEGRALCFG ) 
		WHERE  
		 accummode = :cmsintegralcfg_accummode  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsintegralcfg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsintegralcfg( struct cmsintegralcfg * pstCmsintegralcfg )
{
	pubInitCmsintegralcfg();
	pubStoVCmsintegralcfg(pstCmsintegralcfg);
	EXEC SQL INSERT INTO cmsintegralcfg VALUES ( RR_CMSINTEGRALCFG ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsintegralcfg",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}