tbcms018.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 cmsacctm_cardno[20];
	short cmsacctm_cardno_id;
	char cmsacctm_acctseqno[5];
	short cmsacctm_acctseqno_id;
	char cmsacctm_busskind[6];
	short cmsacctm_busskind_id;
	char cmsacctm_ccy[4];
	short cmsacctm_ccy_id;
	char cmsacctm_prdcod[8];
	short cmsacctm_prdcod_id;
	char cmsacctm_acctno[33];
	short cmsacctm_acctno_id;
	char cmsacctm_subsys[4];
	short cmsacctm_subsys_id;
	char cmsacctm_subacct[33];
	short cmsacctm_subacct_id;
	char cmsacctm_accowner[2];
	short cmsacctm_accowner_id;
	char cmsacctm_custno[31];
	short cmsacctm_custno_id;
	char cmsacctm_issuedate[11];
	short cmsacctm_issuedate_id;
	char cmsacctm_issuebrc[10];
	short cmsacctm_issuebrc_id;
	char cmsacctm_issueteller[11];
	short cmsacctm_issueteller_id;
	char cmsacctm_closedate[11];
	short cmsacctm_closedate_id;
	char cmsacctm_closebrc[10];
	short cmsacctm_closebrc_id;
	char cmsacctm_closeteller[11];
	short cmsacctm_closeteller_id;
	char cmsacctm_cardbookflag[2];
	short cmsacctm_cardbookflag_id;
	char cmsacctm_status[2];
	short cmsacctm_status_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSACCTM \
		:cmsacctm_cardno:cmsacctm_cardno_id, \
		:cmsacctm_acctseqno:cmsacctm_acctseqno_id, \
		:cmsacctm_busskind:cmsacctm_busskind_id, \
		:cmsacctm_ccy:cmsacctm_ccy_id, \
		:cmsacctm_prdcod:cmsacctm_prdcod_id, \
		:cmsacctm_acctno:cmsacctm_acctno_id, \
		:cmsacctm_subsys:cmsacctm_subsys_id, \
		:cmsacctm_subacct:cmsacctm_subacct_id, \
		:cmsacctm_accowner:cmsacctm_accowner_id, \
		:cmsacctm_custno:cmsacctm_custno_id, \
		:cmsacctm_issuedate:cmsacctm_issuedate_id, \
		:cmsacctm_issuebrc:cmsacctm_issuebrc_id, \
		:cmsacctm_issueteller:cmsacctm_issueteller_id, \
		:cmsacctm_closedate:cmsacctm_closedate_id, \
		:cmsacctm_closebrc:cmsacctm_closebrc_id, \
		:cmsacctm_closeteller:cmsacctm_closeteller_id, \
		:cmsacctm_cardbookflag:cmsacctm_cardbookflag_id, \
		:cmsacctm_status:cmsacctm_status_id

#define UU_CMSACCTM \
		cardno, \
		acctseqno, \
		busskind, \
		ccy, \
		prdcod, \
		acctno, \
		subsys, \
		subacct, \
		accowner, \
		custno, \
		issuedate, \
		issuebrc, \
		issueteller, \
		closedate, \
		closebrc, \
		closeteller, \
		cardbookflag, \
		status

#define WW_CMSACCTM \
		:cmsacctm_cardno, \
		:cmsacctm_acctseqno, \
		:cmsacctm_busskind, \
		:cmsacctm_ccy, \
		:cmsacctm_prdcod, \
		:cmsacctm_acctno, \
		:cmsacctm_subsys, \
		:cmsacctm_subacct, \
		:cmsacctm_accowner, \
		:cmsacctm_custno, \
		:cmsacctm_issuedate, \
		:cmsacctm_issuebrc, \
		:cmsacctm_issueteller, \
		:cmsacctm_closedate, \
		:cmsacctm_closebrc, \
		:cmsacctm_closeteller, \
		:cmsacctm_cardbookflag, \
		:cmsacctm_status

struct cmsacctm
{
	char	cardno[20];
	char	acctseqno[5];
	char	busskind[6];
	char	ccy[4];
	char	prdcod[8];
	char	acctno[33];
	char	subsys[4];
	char	subacct[33];
	char	accowner[2];
	char	custno[31];
	char	issuedate[11];
	char	issuebrc[10];
	char	issueteller[11];
	char	closedate[11];
	char	closebrc[10];
	char	closeteller[11];
	char	cardbookflag[2];
	char	status[2];
};

void pubInitCmsacctm()
{
	memset( cmsacctm_cardno, 0x00, sizeof( cmsacctm_cardno ) ) ;
	cmsacctm_cardno_id = 0 ;
	memset( cmsacctm_acctseqno, 0x00, sizeof( cmsacctm_acctseqno ) ) ;
	cmsacctm_acctseqno_id = 0 ;
	memset( cmsacctm_busskind, 0x00, sizeof( cmsacctm_busskind ) ) ;
	cmsacctm_busskind_id = 0 ;
	memset( cmsacctm_ccy, 0x00, sizeof( cmsacctm_ccy ) ) ;
	cmsacctm_ccy_id = 0 ;
	memset( cmsacctm_prdcod, 0x00, sizeof( cmsacctm_prdcod ) ) ;
	cmsacctm_prdcod_id = 0 ;
	memset( cmsacctm_acctno, 0x00, sizeof( cmsacctm_acctno ) ) ;
	cmsacctm_acctno_id = 0 ;
	memset( cmsacctm_subsys, 0x00, sizeof( cmsacctm_subsys ) ) ;
	cmsacctm_subsys_id = 0 ;
	memset( cmsacctm_subacct, 0x00, sizeof( cmsacctm_subacct ) ) ;
	cmsacctm_subacct_id = 0 ;
	memset( cmsacctm_accowner, 0x00, sizeof( cmsacctm_accowner ) ) ;
	cmsacctm_accowner_id = 0 ;
	memset( cmsacctm_custno, 0x00, sizeof( cmsacctm_custno ) ) ;
	cmsacctm_custno_id = 0 ;
	memset( cmsacctm_issuedate, 0x00, sizeof( cmsacctm_issuedate ) ) ;
	cmsacctm_issuedate_id = 0 ;
	memset( cmsacctm_issuebrc, 0x00, sizeof( cmsacctm_issuebrc ) ) ;
	cmsacctm_issuebrc_id = 0 ;
	memset( cmsacctm_issueteller, 0x00, sizeof( cmsacctm_issueteller ) ) ;
	cmsacctm_issueteller_id = 0 ;
	memset( cmsacctm_closedate, 0x00, sizeof( cmsacctm_closedate ) ) ;
	cmsacctm_closedate_id = 0 ;
	memset( cmsacctm_closebrc, 0x00, sizeof( cmsacctm_closebrc ) ) ;
	cmsacctm_closebrc_id = 0 ;
	memset( cmsacctm_closeteller, 0x00, sizeof( cmsacctm_closeteller ) ) ;
	cmsacctm_closeteller_id = 0 ;
	memset( cmsacctm_cardbookflag, 0x00, sizeof( cmsacctm_cardbookflag ) ) ;
	cmsacctm_cardbookflag_id = 0 ;
	memset( cmsacctm_status, 0x00, sizeof( cmsacctm_status ) ) ;
	cmsacctm_status_id = 0 ;
}

void pubStoVCmsacctm( struct cmsacctm * pstCmsacctm )
{
	pubInitCmsacctm();
	if( !strlen( pstCmsacctm->cardno ) )
		strcpy( pstCmsacctm->cardno, " " );
	strcpy( cmsacctm_cardno, pstCmsacctm->cardno );
	if( !strlen( pstCmsacctm->acctseqno ) )
		strcpy( pstCmsacctm->acctseqno, " " );
	strcpy( cmsacctm_acctseqno, pstCmsacctm->acctseqno );
	if( !strlen( pstCmsacctm->busskind ) )
		strcpy( pstCmsacctm->busskind, " " );
	strcpy( cmsacctm_busskind, pstCmsacctm->busskind );
	if( !strlen( pstCmsacctm->ccy ) )
		strcpy( pstCmsacctm->ccy, " " );
	strcpy( cmsacctm_ccy, pstCmsacctm->ccy );
	if( !strlen( pstCmsacctm->prdcod ) )
		strcpy( pstCmsacctm->prdcod, " " );
	strcpy( cmsacctm_prdcod, pstCmsacctm->prdcod );
	if( !strlen( pstCmsacctm->acctno ) )
		strcpy( pstCmsacctm->acctno, " " );
	strcpy( cmsacctm_acctno, pstCmsacctm->acctno );
	if( !strlen( pstCmsacctm->subsys ) )
		strcpy( pstCmsacctm->subsys, " " );
	strcpy( cmsacctm_subsys, pstCmsacctm->subsys );
	if( !strlen( pstCmsacctm->subacct ) )
		strcpy( pstCmsacctm->subacct, " " );
	strcpy( cmsacctm_subacct, pstCmsacctm->subacct );
	if( !strlen( pstCmsacctm->accowner ) )
		strcpy( pstCmsacctm->accowner, " " );
	strcpy( cmsacctm_accowner, pstCmsacctm->accowner );
	if( !strlen( pstCmsacctm->custno ) )
		strcpy( pstCmsacctm->custno, " " );
	strcpy( cmsacctm_custno, pstCmsacctm->custno );
	if( !strlen( pstCmsacctm->issuedate ) )
		strcpy( pstCmsacctm->issuedate, " " );
	strcpy( cmsacctm_issuedate, pstCmsacctm->issuedate );
	if( !strlen( pstCmsacctm->issuebrc ) )
		strcpy( pstCmsacctm->issuebrc, " " );
	strcpy( cmsacctm_issuebrc, pstCmsacctm->issuebrc );
	if( !strlen( pstCmsacctm->issueteller ) )
		strcpy( pstCmsacctm->issueteller, " " );
	strcpy( cmsacctm_issueteller, pstCmsacctm->issueteller );
	if( !strlen( pstCmsacctm->closedate ) )
		strcpy( pstCmsacctm->closedate, " " );
	strcpy( cmsacctm_closedate, pstCmsacctm->closedate );
	if( !strlen( pstCmsacctm->closebrc ) )
		strcpy( pstCmsacctm->closebrc, " " );
	strcpy( cmsacctm_closebrc, pstCmsacctm->closebrc );
	if( !strlen( pstCmsacctm->closeteller ) )
		strcpy( pstCmsacctm->closeteller, " " );
	strcpy( cmsacctm_closeteller, pstCmsacctm->closeteller );
	if( !strlen( pstCmsacctm->cardbookflag ) )
		strcpy( pstCmsacctm->cardbookflag, " " );
	strcpy( cmsacctm_cardbookflag, pstCmsacctm->cardbookflag );
	if( !strlen( pstCmsacctm->status ) )
		strcpy( pstCmsacctm->status, " " );
	strcpy( cmsacctm_status, pstCmsacctm->status );
}

void pubVtoSCmsacctm( struct cmsacctm * pstCmsacctm )
{
	strcpy( pstCmsacctm->cardno, cmsacctm_cardno );
	strpack( pstCmsacctm->cardno );
	strcpy( pstCmsacctm->acctseqno, cmsacctm_acctseqno );
	strpack( pstCmsacctm->acctseqno );
	strcpy( pstCmsacctm->busskind, cmsacctm_busskind );
	strpack( pstCmsacctm->busskind );
	strcpy( pstCmsacctm->ccy, cmsacctm_ccy );
	strpack( pstCmsacctm->ccy );
	strcpy( pstCmsacctm->prdcod, cmsacctm_prdcod );
	strpack( pstCmsacctm->prdcod );
	strcpy( pstCmsacctm->acctno, cmsacctm_acctno );
	strpack( pstCmsacctm->acctno );
	strcpy( pstCmsacctm->subsys, cmsacctm_subsys );
	strpack( pstCmsacctm->subsys );
	strcpy( pstCmsacctm->subacct, cmsacctm_subacct );
	strpack( pstCmsacctm->subacct );
	strcpy( pstCmsacctm->accowner, cmsacctm_accowner );
	strpack( pstCmsacctm->accowner );
	strcpy( pstCmsacctm->custno, cmsacctm_custno );
	strpack( pstCmsacctm->custno );
	strcpy( pstCmsacctm->issuedate, cmsacctm_issuedate );
	strpack( pstCmsacctm->issuedate );
	strcpy( pstCmsacctm->issuebrc, cmsacctm_issuebrc );
	strpack( pstCmsacctm->issuebrc );
	strcpy( pstCmsacctm->issueteller, cmsacctm_issueteller );
	strpack( pstCmsacctm->issueteller );
	strcpy( pstCmsacctm->closedate, cmsacctm_closedate );
	strpack( pstCmsacctm->closedate );
	strcpy( pstCmsacctm->closebrc, cmsacctm_closebrc );
	strpack( pstCmsacctm->closebrc );
	strcpy( pstCmsacctm->closeteller, cmsacctm_closeteller );
	strpack( pstCmsacctm->closeteller );
	strcpy( pstCmsacctm->cardbookflag, cmsacctm_cardbookflag );
	strpack( pstCmsacctm->cardbookflag );
	strcpy( pstCmsacctm->status, cmsacctm_status );
	strpack( pstCmsacctm->status );
}

int pubCallCmsacctm( struct cmsacctm * pstCmsacctm , int iMode )
{
	pubInitCmsacctm();
	pubStoVCmsacctm(pstCmsacctm);
	if ( iMode == 1 )
	{
		#ifdef V_DB2
		EXEC SQL CALL cmsacctm_insert( 
										:cmsacctm_cardno, 
										:cmsacctm_acctseqno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		#endif 

		#ifdef V_INFORMIX
		EXEC SQL EXECUTE PROCEDURE cmsacctm_insert( 
										:cmsacctm_cardno, 
										:cmsacctm_acctseqno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		g_lRegSeqNo++; 

		#endif 

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

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

		#ifdef V_INFORMIX
		EXEC SQL EXECUTE PROCEDURE cmsacctm_update( 
										:cmsacctm_cardno, 
										:cmsacctm_cardno, 
										:cmsacctm_acctseqno, 
										:cmsacctm_acctseqno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		g_lRegSeqNo++; 

		#endif 

		if ( SQLCODE ) 
		{ 
			strcpy( g_acRspCode, "999971" ); 
			/* 存储过程调用错误 */ 
			pubCrtRspInfo( "cmsacctm_update",SQLCODE ); 
			pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
			return -1; 
		}
	}
	return 0; 
}
  
int pubReadCmsacctm( struct cmsacctm * pstCmsacctm )
{
	pubInitCmsacctm();
	pubStoVCmsacctm(pstCmsacctm);
	EXEC SQL SELECT * INTO RR_CMSACCTM 
		FROM cmsacctm  
		WHERE  
		 cardno = :cmsacctm_cardno and 
		 acctseqno = :cmsacctm_acctseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsacctm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsacctm(pstCmsacctm);
	return 0; 
} 
 
int pubModiCmsacctm( struct cmsacctm * pstCmsacctm )
{
	if ( pubCallCmsacctm( pstCmsacctm, 2 ) )
	{ 
		/* 存储过程调用错误 */ 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}
	pubInitCmsacctm();
	pubStoVCmsacctm(pstCmsacctm);
	EXEC SQL UPDATE cmsacctm 
		SET ( UU_CMSACCTM ) = ( WW_CMSACCTM ) 
		WHERE  
		 cardno = :cmsacctm_cardno and 
		 acctseqno = :cmsacctm_acctseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsacctm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsacctm( struct cmsacctm * pstCmsacctm )
{
	pubInitCmsacctm();
	pubStoVCmsacctm(pstCmsacctm);
	EXEC SQL INSERT INTO cmsacctm VALUES ( RR_CMSACCTM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsacctm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	if ( pubCallCmsacctm( pstCmsacctm, 1 ) )
	{ 
		/* 存储过程调用错误 */ 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}
	return 0; 
}