tbcms041.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 cmstxconf_txid[7];
	short cmstxconf_txid_id;
	long cmstxconf_seqno;
	short cmstxconf_seqno_id;
	char cmstxconf_fieldname[21];
	short cmstxconf_fieldname_id;
	char cmstxconf_fieldtype[2];
	short cmstxconf_fieldtype_id;
	char cmstxconf_dictcode[33];
	short cmstxconf_dictcode_id;
	char cmstxconf_dicttype[2];
	short cmstxconf_dicttype_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSTXCONF \
		:cmstxconf_txid:cmstxconf_txid_id, \
		:cmstxconf_seqno:cmstxconf_seqno_id, \
		:cmstxconf_fieldname:cmstxconf_fieldname_id, \
		:cmstxconf_fieldtype:cmstxconf_fieldtype_id, \
		:cmstxconf_dictcode:cmstxconf_dictcode_id, \
		:cmstxconf_dicttype:cmstxconf_dicttype_id

#define UU_CMSTXCONF \
		txid, \
		seqno, \
		fieldname, \
		fieldtype, \
		dictcode, \
		dicttype

#define WW_CMSTXCONF \
		:cmstxconf_txid, \
		:cmstxconf_seqno, \
		:cmstxconf_fieldname, \
		:cmstxconf_fieldtype, \
		:cmstxconf_dictcode, \
		:cmstxconf_dicttype

struct cmstxconf
{
	char	txid[7];
	long	seqno;
	char	fieldname[21];
	char	fieldtype[2];
	char	dictcode[33];
	char	dicttype[2];
};

void pubInitCmstxconf()
{
	memset( cmstxconf_txid, 0x00, sizeof( cmstxconf_txid ) ) ;
	cmstxconf_txid_id = 0 ;
	memset( &cmstxconf_seqno, 0x00, sizeof( cmstxconf_seqno ) ) ;
	cmstxconf_seqno_id = 0 ;
	memset( cmstxconf_fieldname, 0x00, sizeof( cmstxconf_fieldname ) ) ;
	cmstxconf_fieldname_id = 0 ;
	memset( cmstxconf_fieldtype, 0x00, sizeof( cmstxconf_fieldtype ) ) ;
	cmstxconf_fieldtype_id = 0 ;
	memset( cmstxconf_dictcode, 0x00, sizeof( cmstxconf_dictcode ) ) ;
	cmstxconf_dictcode_id = 0 ;
	memset( cmstxconf_dicttype, 0x00, sizeof( cmstxconf_dicttype ) ) ;
	cmstxconf_dicttype_id = 0 ;
}

void pubStoVCmstxconf( struct cmstxconf * pstCmstxconf )
{
	pubInitCmstxconf();
	if( !strlen( pstCmstxconf->txid ) )
		strcpy( pstCmstxconf->txid, " " );
	strcpy( cmstxconf_txid, pstCmstxconf->txid );
	cmstxconf_seqno = pstCmstxconf->seqno ;
	if( !strlen( pstCmstxconf->fieldname ) )
		strcpy( pstCmstxconf->fieldname, " " );
	strcpy( cmstxconf_fieldname, pstCmstxconf->fieldname );
	if( !strlen( pstCmstxconf->fieldtype ) )
		strcpy( pstCmstxconf->fieldtype, " " );
	strcpy( cmstxconf_fieldtype, pstCmstxconf->fieldtype );
	if( !strlen( pstCmstxconf->dictcode ) )
		strcpy( pstCmstxconf->dictcode, " " );
	strcpy( cmstxconf_dictcode, pstCmstxconf->dictcode );
	if( !strlen( pstCmstxconf->dicttype ) )
		strcpy( pstCmstxconf->dicttype, " " );
	strcpy( cmstxconf_dicttype, pstCmstxconf->dicttype );
}

void pubVtoSCmstxconf( struct cmstxconf * pstCmstxconf )
{
	strcpy( pstCmstxconf->txid, cmstxconf_txid );
	strpack( pstCmstxconf->txid );
	pstCmstxconf->seqno = cmstxconf_seqno ;
	strcpy( pstCmstxconf->fieldname, cmstxconf_fieldname );
	strpack( pstCmstxconf->fieldname );
	strcpy( pstCmstxconf->fieldtype, cmstxconf_fieldtype );
	strpack( pstCmstxconf->fieldtype );
	strcpy( pstCmstxconf->dictcode, cmstxconf_dictcode );
	strpack( pstCmstxconf->dictcode );
	strcpy( pstCmstxconf->dicttype, cmstxconf_dicttype );
	strpack( pstCmstxconf->dicttype );
}

int pubReadCmstxconf( struct cmstxconf * pstCmstxconf )
{
	pubInitCmstxconf();
	pubStoVCmstxconf(pstCmstxconf);
	EXEC SQL SELECT * INTO RR_CMSTXCONF 
		FROM cmstxconf  
		WHERE  
		 txid = :cmstxconf_txid and 
		 seqno = :cmstxconf_seqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmstxconf",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmstxconf(pstCmstxconf);
	return 0; 
} 
 
int pubModiCmstxconf( struct cmstxconf * pstCmstxconf )
{
	pubInitCmstxconf();
	pubStoVCmstxconf(pstCmstxconf);
	EXEC SQL UPDATE cmstxconf 
		SET ( UU_CMSTXCONF ) = ( WW_CMSTXCONF ) 
		WHERE  
		 txid = :cmstxconf_txid and 
		 seqno = :cmstxconf_seqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmstxconf",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmstxconf( struct cmstxconf * pstCmstxconf )
{
	pubInitCmstxconf();
	pubStoVCmstxconf(pstCmstxconf);
	EXEC SQL INSERT INTO cmstxconf VALUES ( RR_CMSTXCONF ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmstxconf",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}