tbcms008.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 cmsseqno_cardno[20];
	short cmsseqno_cardno_id;
	char cmsseqno_seqno[5];
	short cmsseqno_seqno_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSSEQNO \
		:cmsseqno_cardno:cmsseqno_cardno_id, \
		:cmsseqno_seqno:cmsseqno_seqno_id

#define UU_CMSSEQNO \
		cardno, \
		seqno

#define WW_CMSSEQNO \
		:cmsseqno_cardno, \
		:cmsseqno_seqno

struct cmsseqno
{
	char	cardno[20];
	char	seqno[5];
};

void pubInitCmsseqno()
{
	memset( cmsseqno_cardno, 0x00, sizeof( cmsseqno_cardno ) ) ;
	cmsseqno_cardno_id = 0 ;
	memset( cmsseqno_seqno, 0x00, sizeof( cmsseqno_seqno ) ) ;
	cmsseqno_seqno_id = 0 ;
}

void pubStoVCmsseqno( struct cmsseqno * pstCmsseqno )
{
	pubInitCmsseqno();
	if( !strlen( pstCmsseqno->cardno ) )
		strcpy( pstCmsseqno->cardno, " " );
	strcpy( cmsseqno_cardno, pstCmsseqno->cardno );
	if( !strlen( pstCmsseqno->seqno ) )
		strcpy( pstCmsseqno->seqno, " " );
	strcpy( cmsseqno_seqno, pstCmsseqno->seqno );
}

void pubVtoSCmsseqno( struct cmsseqno * pstCmsseqno )
{
	strcpy( pstCmsseqno->cardno, cmsseqno_cardno );
	strpack( pstCmsseqno->cardno );
	strcpy( pstCmsseqno->seqno, cmsseqno_seqno );
	strpack( pstCmsseqno->seqno );
}

int pubCallCmsseqno( struct cmsseqno * pstCmsseqno , int iMode )
{
	pubInitCmsseqno();
	pubStoVCmsseqno(pstCmsseqno);
	if ( iMode == 1 )
	{
		#ifdef V_DB2
		EXEC SQL CALL cmsseqno_insert( 
										:cmsseqno_cardno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		#endif 

		#ifdef V_INFORMIX
		EXEC SQL EXECUTE PROCEDURE cmsseqno_insert( 
										:cmsseqno_cardno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		g_lRegSeqNo++; 

		#endif 

		if ( SQLCODE ) 
		{ 
			strcpy( g_acRspCode, "999971" ); 
			/* 存储过程调用错误 */ 
			pubCrtRspInfo( "cmsseqno_insert",SQLCODE ); 
			pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
			return -1; 
		}
	}

	if ( iMode == 2 )
	{
		#ifdef V_DB2
		EXEC SQL CALL cmsseqno_update( 
										:cmsseqno_cardno, 
										:cmsseqno_cardno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		#endif 

		#ifdef V_INFORMIX
		EXEC SQL EXECUTE PROCEDURE cmsseqno_update( 
										:cmsseqno_cardno, 
										:cmsseqno_cardno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		g_lRegSeqNo++; 

		#endif 

		if ( SQLCODE ) 
		{ 
			strcpy( g_acRspCode, "999971" ); 
			/* 存储过程调用错误 */ 
			pubCrtRspInfo( "cmsseqno_update",SQLCODE ); 
			pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
			return -1; 
		}
	}
	return 0; 
}
  
int pubReadCmsseqno( struct cmsseqno * pstCmsseqno )
{
	pubInitCmsseqno();
	pubStoVCmsseqno(pstCmsseqno);
	EXEC SQL SELECT * INTO RR_CMSSEQNO 
		FROM cmsseqno  
		WHERE  
		 cardno = :cmsseqno_cardno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsseqno",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsseqno(pstCmsseqno);
	return 0; 
} 
 
int pubModiCmsseqno( struct cmsseqno * pstCmsseqno )
{
	if ( pubCallCmsseqno( pstCmsseqno, 2 ) )
	{ 
		/* 存储过程调用错误 */ 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}
	pubInitCmsseqno();
	pubStoVCmsseqno(pstCmsseqno);
	EXEC SQL UPDATE cmsseqno 
		SET ( UU_CMSSEQNO ) = ( WW_CMSSEQNO ) 
		WHERE  
		 cardno = :cmsseqno_cardno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsseqno",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsseqno( struct cmsseqno * pstCmsseqno )
{
	pubInitCmsseqno();
	pubStoVCmsseqno(pstCmsseqno);
	EXEC SQL INSERT INTO cmsseqno VALUES ( RR_CMSSEQNO ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsseqno",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	if ( pubCallCmsseqno( pstCmsseqno, 1 ) )
	{ 
		/* 存储过程调用错误 */ 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}
	return 0; 
}