tbcms032.sqc

一整套完整的银行卡系统源代码

	cmswrongnote_oldforwins_id = 0 ;
	memset( cmswrongnote_reason, 0x00, sizeof( cmswrongnote_reason ) ) ;
	cmswrongnote_reason_id = 0 ;
	memset( cmswrongnote_reasoncode, 0x00, sizeof( cmswrongnote_reasoncode ) ) ;
	cmswrongnote_reasoncode_id = 0 ;
	memset( cmswrongnote_devid, 0x00, sizeof( cmswrongnote_devid ) ) ;
	cmswrongnote_devid_id = 0 ;
	memset( cmswrongnote_mid, 0x00, sizeof( cmswrongnote_mid ) ) ;
	cmswrongnote_mid_id = 0 ;
	memset( cmswrongnote_mctmcc, 0x00, sizeof( cmswrongnote_mctmcc ) ) ;
	cmswrongnote_mctmcc_id = 0 ;
	memset( cmswrongnote_cardnoout, 0x00, sizeof( cmswrongnote_cardnoout ) ) ;
	cmswrongnote_cardnoout_id = 0 ;
	memset( cmswrongnote_cardnoin, 0x00, sizeof( cmswrongnote_cardnoin ) ) ;
	cmswrongnote_cardnoin_id = 0 ;
	memset( cmswrongnote_ccy, 0x00, sizeof( cmswrongnote_ccy ) ) ;
	cmswrongnote_ccy_id = 0 ;
}

void pubStoVCmswrongnote( struct cmswrongnote * pstCmswrongnote )
{
	pubInitCmswrongnote();
	if( !strlen( pstCmswrongnote->brc ) )
		strcpy( pstCmswrongnote->brc, " " );
	strcpy( cmswrongnote_brc, pstCmswrongnote->brc );
	if( !strlen( pstCmswrongnote->trandate ) )
		strcpy( pstCmswrongnote->trandate, " " );
	strcpy( cmswrongnote_trandate, pstCmswrongnote->trandate );
	cmswrongnote_serseqno = pstCmswrongnote->serseqno ;
	if( !strlen( pstCmswrongnote->settledate ) )
		strcpy( pstCmswrongnote->settledate, " " );
	strcpy( cmswrongnote_settledate, pstCmswrongnote->settledate );
	if( !strlen( pstCmswrongnote->wrongcharacter ) )
		strcpy( pstCmswrongnote->wrongcharacter, " " );
	strcpy( cmswrongnote_wrongcharacter, pstCmswrongnote->wrongcharacter );
	if( !strlen( pstCmswrongnote->wrongtranplace ) )
		strcpy( pstCmswrongnote->wrongtranplace, " " );
	strcpy( cmswrongnote_wrongtranplace, pstCmswrongnote->wrongtranplace );
	if( !strlen( pstCmswrongnote->wrongtype ) )
		strcpy( pstCmswrongnote->wrongtype, " " );
	strcpy( cmswrongnote_wrongtype, pstCmswrongnote->wrongtype );
	if( !strlen( pstCmswrongnote->cardno ) )
		strcpy( pstCmswrongnote->cardno, " " );
	strcpy( cmswrongnote_cardno, pstCmswrongnote->cardno );
	if( !strlen( pstCmswrongnote->devtransdatetime ) )
		strcpy( pstCmswrongnote->devtransdatetime, " " );
	strcpy( cmswrongnote_devtransdatetime, pstCmswrongnote->devtransdatetime );
	if( !strlen( pstCmswrongnote->srvstan ) )
		strcpy( pstCmswrongnote->srvstan, " " );
	strcpy( cmswrongnote_srvstan, pstCmswrongnote->srvstan );
	if( !strlen( pstCmswrongnote->acqins ) )
		strcpy( pstCmswrongnote->acqins, " " );
	strcpy( cmswrongnote_acqins, pstCmswrongnote->acqins );
	if( !strlen( pstCmswrongnote->forwins ) )
		strcpy( pstCmswrongnote->forwins, " " );
	strcpy( cmswrongnote_forwins, pstCmswrongnote->forwins );
	cmswrongnote_amount = pstCmswrongnote->amount ;
	pubDround( &cmswrongnote_amount, 2 );
	if( !strlen( pstCmswrongnote->oldtransdatetime ) )
		strcpy( pstCmswrongnote->oldtransdatetime, " " );
	strcpy( cmswrongnote_oldtransdatetime, pstCmswrongnote->oldtransdatetime );
	if( !strlen( pstCmswrongnote->oldsrvstan ) )
		strcpy( pstCmswrongnote->oldsrvstan, " " );
	strcpy( cmswrongnote_oldsrvstan, pstCmswrongnote->oldsrvstan );
	if( !strlen( pstCmswrongnote->oldacqins ) )
		strcpy( pstCmswrongnote->oldacqins, " " );
	strcpy( cmswrongnote_oldacqins, pstCmswrongnote->oldacqins );
	if( !strlen( pstCmswrongnote->oldforwins ) )
		strcpy( pstCmswrongnote->oldforwins, " " );
	strcpy( cmswrongnote_oldforwins, pstCmswrongnote->oldforwins );
	if( !strlen( pstCmswrongnote->reason ) )
		strcpy( pstCmswrongnote->reason, " " );
	strcpy( cmswrongnote_reason, pstCmswrongnote->reason );
	if( !strlen( pstCmswrongnote->reasoncode ) )
		strcpy( pstCmswrongnote->reasoncode, " " );
	strcpy( cmswrongnote_reasoncode, pstCmswrongnote->reasoncode );
	if( !strlen( pstCmswrongnote->devid ) )
		strcpy( pstCmswrongnote->devid, " " );
	strcpy( cmswrongnote_devid, pstCmswrongnote->devid );
	if( !strlen( pstCmswrongnote->mid ) )
		strcpy( pstCmswrongnote->mid, " " );
	strcpy( cmswrongnote_mid, pstCmswrongnote->mid );
	if( !strlen( pstCmswrongnote->mctmcc ) )
		strcpy( pstCmswrongnote->mctmcc, " " );
	strcpy( cmswrongnote_mctmcc, pstCmswrongnote->mctmcc );
	if( !strlen( pstCmswrongnote->cardnoout ) )
		strcpy( pstCmswrongnote->cardnoout, " " );
	strcpy( cmswrongnote_cardnoout, pstCmswrongnote->cardnoout );
	if( !strlen( pstCmswrongnote->cardnoin ) )
		strcpy( pstCmswrongnote->cardnoin, " " );
	strcpy( cmswrongnote_cardnoin, pstCmswrongnote->cardnoin );
	if( !strlen( pstCmswrongnote->ccy ) )
		strcpy( pstCmswrongnote->ccy, " " );
	strcpy( cmswrongnote_ccy, pstCmswrongnote->ccy );
}

void pubVtoSCmswrongnote( struct cmswrongnote * pstCmswrongnote )
{
	strcpy( pstCmswrongnote->brc, cmswrongnote_brc );
	strpack( pstCmswrongnote->brc );
	strcpy( pstCmswrongnote->trandate, cmswrongnote_trandate );
	strpack( pstCmswrongnote->trandate );
	pstCmswrongnote->serseqno = cmswrongnote_serseqno ;
	strcpy( pstCmswrongnote->settledate, cmswrongnote_settledate );
	strpack( pstCmswrongnote->settledate );
	strcpy( pstCmswrongnote->wrongcharacter, cmswrongnote_wrongcharacter );
	strpack( pstCmswrongnote->wrongcharacter );
	strcpy( pstCmswrongnote->wrongtranplace, cmswrongnote_wrongtranplace );
	strpack( pstCmswrongnote->wrongtranplace );
	strcpy( pstCmswrongnote->wrongtype, cmswrongnote_wrongtype );
	strpack( pstCmswrongnote->wrongtype );
	strcpy( pstCmswrongnote->cardno, cmswrongnote_cardno );
	strpack( pstCmswrongnote->cardno );
	strcpy( pstCmswrongnote->devtransdatetime, cmswrongnote_devtransdatetime );
	strpack( pstCmswrongnote->devtransdatetime );
	strcpy( pstCmswrongnote->srvstan, cmswrongnote_srvstan );
	strpack( pstCmswrongnote->srvstan );
	strcpy( pstCmswrongnote->acqins, cmswrongnote_acqins );
	strpack( pstCmswrongnote->acqins );
	strcpy( pstCmswrongnote->forwins, cmswrongnote_forwins );
	strpack( pstCmswrongnote->forwins );
	pstCmswrongnote->amount = cmswrongnote_amount ;
	pubDround( &pstCmswrongnote->amount, 2 );
	strcpy( pstCmswrongnote->oldtransdatetime, cmswrongnote_oldtransdatetime );
	strpack( pstCmswrongnote->oldtransdatetime );
	strcpy( pstCmswrongnote->oldsrvstan, cmswrongnote_oldsrvstan );
	strpack( pstCmswrongnote->oldsrvstan );
	strcpy( pstCmswrongnote->oldacqins, cmswrongnote_oldacqins );
	strpack( pstCmswrongnote->oldacqins );
	strcpy( pstCmswrongnote->oldforwins, cmswrongnote_oldforwins );
	strpack( pstCmswrongnote->oldforwins );
	strcpy( pstCmswrongnote->reason, cmswrongnote_reason );
	strpack( pstCmswrongnote->reason );
	strcpy( pstCmswrongnote->reasoncode, cmswrongnote_reasoncode );
	strpack( pstCmswrongnote->reasoncode );
	strcpy( pstCmswrongnote->devid, cmswrongnote_devid );
	strpack( pstCmswrongnote->devid );
	strcpy( pstCmswrongnote->mid, cmswrongnote_mid );
	strpack( pstCmswrongnote->mid );
	strcpy( pstCmswrongnote->mctmcc, cmswrongnote_mctmcc );
	strpack( pstCmswrongnote->mctmcc );
	strcpy( pstCmswrongnote->cardnoout, cmswrongnote_cardnoout );
	strpack( pstCmswrongnote->cardnoout );
	strcpy( pstCmswrongnote->cardnoin, cmswrongnote_cardnoin );
	strpack( pstCmswrongnote->cardnoin );
	strcpy( pstCmswrongnote->ccy, cmswrongnote_ccy );
	strpack( pstCmswrongnote->ccy );
}

int pubReadCmswrongnote( struct cmswrongnote * pstCmswrongnote )
{
	pubInitCmswrongnote();
	pubStoVCmswrongnote(pstCmswrongnote);
	EXEC SQL SELECT * INTO RR_CMSWRONGNOTE 
		FROM cmswrongnote  
		WHERE  
		 brc = :cmswrongnote_brc and 
		 trandate = :cmswrongnote_trandate and 
		 serseqno = :cmswrongnote_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmswrongnote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmswrongnote(pstCmswrongnote);
	return 0; 
} 
 
int pubModiCmswrongnote( struct cmswrongnote * pstCmswrongnote )
{
	pubInitCmswrongnote();
	pubStoVCmswrongnote(pstCmswrongnote);
	EXEC SQL UPDATE cmswrongnote 
		SET ( UU_CMSWRONGNOTE ) = ( WW_CMSWRONGNOTE ) 
		WHERE  
		 brc = :cmswrongnote_brc and 
		 trandate = :cmswrongnote_trandate and 
		 serseqno = :cmswrongnote_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmswrongnote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmswrongnote( struct cmswrongnote * pstCmswrongnote )
{
	pubInitCmswrongnote();
	pubStoVCmswrongnote(pstCmswrongnote);
	EXEC SQL INSERT INTO cmswrongnote VALUES ( RR_CMSWRONGNOTE ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmswrongnote",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}