tbcms017.sqc

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

	if( !strlen( pstCmstxdethis->acctseqno1 ) )
		strcpy( pstCmstxdethis->acctseqno1, " " );
	strcpy( cmstxdethis_acctseqno1, pstCmstxdethis->acctseqno1 );
	if( !strlen( pstCmstxdethis->issuebrc1 ) )
		strcpy( pstCmstxdethis->issuebrc1, " " );
	strcpy( cmstxdethis_issuebrc1, pstCmstxdethis->issuebrc1 );
	cmstxdethis_serverlevel1 = pstCmstxdethis->serverlevel1 ;
	if( !strlen( pstCmstxdethis->cardno2 ) )
		strcpy( pstCmstxdethis->cardno2, " " );
	strcpy( cmstxdethis_cardno2, pstCmstxdethis->cardno2 );
	if( !strlen( pstCmstxdethis->acctno2 ) )
		strcpy( pstCmstxdethis->acctno2, " " );
	strcpy( cmstxdethis_acctno2, pstCmstxdethis->acctno2 );
	if( !strlen( pstCmstxdethis->subacct2 ) )
		strcpy( pstCmstxdethis->subacct2, " " );
	strcpy( cmstxdethis_subacct2, pstCmstxdethis->subacct2 );
	if( !strlen( pstCmstxdethis->acctseqno2 ) )
		strcpy( pstCmstxdethis->acctseqno2, " " );
	strcpy( cmstxdethis_acctseqno2, pstCmstxdethis->acctseqno2 );
	if( !strlen( pstCmstxdethis->issuebrc2 ) )
		strcpy( pstCmstxdethis->issuebrc2, " " );
	strcpy( cmstxdethis_issuebrc2, pstCmstxdethis->issuebrc2 );
	cmstxdethis_serverlevel2 = pstCmstxdethis->serverlevel2 ;
	cmstxdethis_tranamt = pstCmstxdethis->tranamt ;
	pubDround( &cmstxdethis_tranamt, 2 );
	if( !strlen( pstCmstxdethis->ccy ) )
		strcpy( pstCmstxdethis->ccy, " " );
	strcpy( cmstxdethis_ccy, pstCmstxdethis->ccy );
	cmstxdethis_amt2 = pstCmstxdethis->amt2 ;
	pubDround( &cmstxdethis_amt2, 2 );
	if( !strlen( pstCmstxdethis->ccy2 ) )
		strcpy( pstCmstxdethis->ccy2, " " );
	strcpy( cmstxdethis_ccy2, pstCmstxdethis->ccy2 );
	cmstxdethis_amt3 = pstCmstxdethis->amt3 ;
	pubDround( &cmstxdethis_amt3, 2 );
	if( !strlen( pstCmstxdethis->ccy3 ) )
		strcpy( pstCmstxdethis->ccy3, " " );
	strcpy( cmstxdethis_ccy3, pstCmstxdethis->ccy3 );
	if( !strlen( pstCmstxdethis->trandevtype ) )
		strcpy( pstCmstxdethis->trandevtype, " " );
	strcpy( cmstxdethis_trandevtype, pstCmstxdethis->trandevtype );
	if( !strlen( pstCmstxdethis->trandevtypecomm ) )
		strcpy( pstCmstxdethis->trandevtypecomm, " " );
	strcpy( cmstxdethis_trandevtypecomm, pstCmstxdethis->trandevtypecomm );
	if( !strlen( pstCmstxdethis->cardtrantype ) )
		strcpy( pstCmstxdethis->cardtrantype, " " );
	strcpy( cmstxdethis_cardtrantype, pstCmstxdethis->cardtrantype );
	if( !strlen( pstCmstxdethis->cardtrantypecomm ) )
		strcpy( pstCmstxdethis->cardtrantypecomm, " " );
	strcpy( cmstxdethis_cardtrantypecomm, pstCmstxdethis->cardtrantypecomm );
	if( !strlen( pstCmstxdethis->trankind ) )
		strcpy( pstCmstxdethis->trankind, " " );
	strcpy( cmstxdethis_trankind, pstCmstxdethis->trankind );
	if( !strlen( pstCmstxdethis->trankindcomm ) )
		strcpy( pstCmstxdethis->trankindcomm, " " );
	strcpy( cmstxdethis_trankindcomm, pstCmstxdethis->trankindcomm );
	if( !strlen( pstCmstxdethis->mid ) )
		strcpy( pstCmstxdethis->mid, " " );
	strcpy( cmstxdethis_mid, pstCmstxdethis->mid );
	if( !strlen( pstCmstxdethis->mctmcc ) )
		strcpy( pstCmstxdethis->mctmcc, " " );
	strcpy( cmstxdethis_mctmcc, pstCmstxdethis->mctmcc );
	if( !strlen( pstCmstxdethis->devid ) )
		strcpy( pstCmstxdethis->devid, " " );
	strcpy( cmstxdethis_devid, pstCmstxdethis->devid );
	if( !strlen( pstCmstxdethis->validf ) )
		strcpy( pstCmstxdethis->validf, " " );
	strcpy( cmstxdethis_validf, pstCmstxdethis->validf );
	cmstxdethis_delaychg = pstCmstxdethis->delaychg ;
	pubDround( &cmstxdethis_delaychg, 2 );
	cmstxdethis_bankgetfee = pstCmstxdethis->bankgetfee ;
	pubDround( &cmstxdethis_bankgetfee, 2 );
	cmstxdethis_custsharefee = pstCmstxdethis->custsharefee ;
	pubDround( &cmstxdethis_custsharefee, 2 );
	cmstxdethis_banksharefee = pstCmstxdethis->banksharefee ;
	pubDround( &cmstxdethis_banksharefee, 2 );
	cmstxdethis_bankassfee = pstCmstxdethis->bankassfee ;
	pubDround( &cmstxdethis_bankassfee, 2 );
	cmstxdethis_bankpayfee = pstCmstxdethis->bankpayfee ;
	pubDround( &cmstxdethis_bankpayfee, 2 );
	cmstxdethis_assfee1 = pstCmstxdethis->assfee1 ;
	pubDround( &cmstxdethis_assfee1, 2 );
	cmstxdethis_assfee2 = pstCmstxdethis->assfee2 ;
	pubDround( &cmstxdethis_assfee2, 2 );
	if( !strlen( pstCmstxdethis->devstan ) )
		strcpy( pstCmstxdethis->devstan, " " );
	strcpy( cmstxdethis_devstan, pstCmstxdethis->devstan );
	if( !strlen( pstCmstxdethis->devdatetime ) )
		strcpy( pstCmstxdethis->devdatetime, " " );
	strcpy( cmstxdethis_devdatetime, pstCmstxdethis->devdatetime );
	if( !strlen( pstCmstxdethis->devacqins ) )
		strcpy( pstCmstxdethis->devacqins, " " );
	strcpy( cmstxdethis_devacqins, pstCmstxdethis->devacqins );
	if( !strlen( pstCmstxdethis->devforwins ) )
		strcpy( pstCmstxdethis->devforwins, " " );
	strcpy( cmstxdethis_devforwins, pstCmstxdethis->devforwins );
	if( !strlen( pstCmstxdethis->authcode ) )
		strcpy( pstCmstxdethis->authcode, " " );
	strcpy( cmstxdethis_authcode, pstCmstxdethis->authcode );
	if( !strlen( pstCmstxdethis->authenddate ) )
		strcpy( pstCmstxdethis->authenddate, " " );
	strcpy( cmstxdethis_authenddate, pstCmstxdethis->authenddate );
	cmstxdethis_authamt = pstCmstxdethis->authamt ;
	pubDround( &cmstxdethis_authamt, 2 );
	if( !strlen( pstCmstxdethis->text ) )
		strcpy( pstCmstxdethis->text, " " );
	strcpy( cmstxdethis_text, pstCmstxdethis->text );
}

void pubVtoSCmstxdethis( struct cmstxdethis * pstCmstxdethis )
{
	strcpy( pstCmstxdethis->trandate, cmstxdethis_trandate );
	strpack( pstCmstxdethis->trandate );
	pstCmstxdethis->serseqno = cmstxdethis_serseqno ;
	strcpy( pstCmstxdethis->teller, cmstxdethis_teller );
	strpack( pstCmstxdethis->teller );
	strcpy( pstCmstxdethis->brc, cmstxdethis_brc );
	strpack( pstCmstxdethis->brc );
	strcpy( pstCmstxdethis->frnttrandate, cmstxdethis_frnttrandate );
	strpack( pstCmstxdethis->frnttrandate );
	strcpy( pstCmstxdethis->frnttime, cmstxdethis_frnttime );
	strpack( pstCmstxdethis->frnttime );
	strcpy( pstCmstxdethis->frntstan, cmstxdethis_frntstan );
	strpack( pstCmstxdethis->frntstan );
	strcpy( pstCmstxdethis->frntno, cmstxdethis_frntno );
	strpack( pstCmstxdethis->frntno );
	strcpy( pstCmstxdethis->frntdate, cmstxdethis_frntdate );
	strpack( pstCmstxdethis->frntdate );
	strcpy( pstCmstxdethis->frnttrancode, cmstxdethis_frnttrancode );
	strpack( pstCmstxdethis->frnttrancode );
	strcpy( pstCmstxdethis->frnttrancomm, cmstxdethis_frnttrancomm );
	strpack( pstCmstxdethis->frnttrancomm );
	strcpy( pstCmstxdethis->settledate, cmstxdethis_settledate );
	strpack( pstCmstxdethis->settledate );
	strcpy( pstCmstxdethis->origfrntstan, cmstxdethis_origfrntstan );
	strpack( pstCmstxdethis->origfrntstan );
	strcpy( pstCmstxdethis->seqno, cmstxdethis_seqno );
	strpack( pstCmstxdethis->seqno );
	strcpy( pstCmstxdethis->subseqno, cmstxdethis_subseqno );
	strpack( pstCmstxdethis->subseqno );
	strcpy( pstCmstxdethis->operkind, cmstxdethis_operkind );
	strpack( pstCmstxdethis->operkind );
	strcpy( pstCmstxdethis->opflag, cmstxdethis_opflag );
	strpack( pstCmstxdethis->opflag );
	strcpy( pstCmstxdethis->trancode, cmstxdethis_trancode );
	strpack( pstCmstxdethis->trancode );
	strcpy( pstCmstxdethis->cardno1, cmstxdethis_cardno1 );
	strpack( pstCmstxdethis->cardno1 );
	strcpy( pstCmstxdethis->acctno1, cmstxdethis_acctno1 );
	strpack( pstCmstxdethis->acctno1 );
	strcpy( pstCmstxdethis->subacct1, cmstxdethis_subacct1 );
	strpack( pstCmstxdethis->subacct1 );
	strcpy( pstCmstxdethis->acctseqno1, cmstxdethis_acctseqno1 );
	strpack( pstCmstxdethis->acctseqno1 );
	strcpy( pstCmstxdethis->issuebrc1, cmstxdethis_issuebrc1 );
	strpack( pstCmstxdethis->issuebrc1 );
	pstCmstxdethis->serverlevel1 = cmstxdethis_serverlevel1 ;
	strcpy( pstCmstxdethis->cardno2, cmstxdethis_cardno2 );
	strpack( pstCmstxdethis->cardno2 );
	strcpy( pstCmstxdethis->acctno2, cmstxdethis_acctno2 );
	strpack( pstCmstxdethis->acctno2 );
	strcpy( pstCmstxdethis->subacct2, cmstxdethis_subacct2 );
	strpack( pstCmstxdethis->subacct2 );
	strcpy( pstCmstxdethis->acctseqno2, cmstxdethis_acctseqno2 );
	strpack( pstCmstxdethis->acctseqno2 );
	strcpy( pstCmstxdethis->issuebrc2, cmstxdethis_issuebrc2 );
	strpack( pstCmstxdethis->issuebrc2 );
	pstCmstxdethis->serverlevel2 = cmstxdethis_serverlevel2 ;
	pstCmstxdethis->tranamt = cmstxdethis_tranamt ;
	pubDround( &pstCmstxdethis->tranamt, 2 );
	strcpy( pstCmstxdethis->ccy, cmstxdethis_ccy );
	strpack( pstCmstxdethis->ccy );
	pstCmstxdethis->amt2 = cmstxdethis_amt2 ;
	pubDround( &pstCmstxdethis->amt2, 2 );
	strcpy( pstCmstxdethis->ccy2, cmstxdethis_ccy2 );
	strpack( pstCmstxdethis->ccy2 );
	pstCmstxdethis->amt3 = cmstxdethis_amt3 ;
	pubDround( &pstCmstxdethis->amt3, 2 );
	strcpy( pstCmstxdethis->ccy3, cmstxdethis_ccy3 );
	strpack( pstCmstxdethis->ccy3 );
	strcpy( pstCmstxdethis->trandevtype, cmstxdethis_trandevtype );
	strpack( pstCmstxdethis->trandevtype );
	strcpy( pstCmstxdethis->trandevtypecomm, cmstxdethis_trandevtypecomm );
	strpack( pstCmstxdethis->trandevtypecomm );
	strcpy( pstCmstxdethis->cardtrantype, cmstxdethis_cardtrantype );
	strpack( pstCmstxdethis->cardtrantype );
	strcpy( pstCmstxdethis->cardtrantypecomm, cmstxdethis_cardtrantypecomm );
	strpack( pstCmstxdethis->cardtrantypecomm );
	strcpy( pstCmstxdethis->trankind, cmstxdethis_trankind );
	strpack( pstCmstxdethis->trankind );
	strcpy( pstCmstxdethis->trankindcomm, cmstxdethis_trankindcomm );
	strpack( pstCmstxdethis->trankindcomm );
	strcpy( pstCmstxdethis->mid, cmstxdethis_mid );
	strpack( pstCmstxdethis->mid );
	strcpy( pstCmstxdethis->mctmcc, cmstxdethis_mctmcc );
	strpack( pstCmstxdethis->mctmcc );
	strcpy( pstCmstxdethis->devid, cmstxdethis_devid );
	strpack( pstCmstxdethis->devid );
	strcpy( pstCmstxdethis->validf, cmstxdethis_validf );
	strpack( pstCmstxdethis->validf );
	pstCmstxdethis->delaychg = cmstxdethis_delaychg ;
	pubDround( &pstCmstxdethis->delaychg, 2 );
	pstCmstxdethis->bankgetfee = cmstxdethis_bankgetfee ;
	pubDround( &pstCmstxdethis->bankgetfee, 2 );
	pstCmstxdethis->custsharefee = cmstxdethis_custsharefee ;
	pubDround( &pstCmstxdethis->custsharefee, 2 );
	pstCmstxdethis->banksharefee = cmstxdethis_banksharefee ;
	pubDround( &pstCmstxdethis->banksharefee, 2 );
	pstCmstxdethis->bankassfee = cmstxdethis_bankassfee ;
	pubDround( &pstCmstxdethis->bankassfee, 2 );
	pstCmstxdethis->bankpayfee = cmstxdethis_bankpayfee ;
	pubDround( &pstCmstxdethis->bankpayfee, 2 );
	pstCmstxdethis->assfee1 = cmstxdethis_assfee1 ;
	pubDround( &pstCmstxdethis->assfee1, 2 );
	pstCmstxdethis->assfee2 = cmstxdethis_assfee2 ;
	pubDround( &pstCmstxdethis->assfee2, 2 );
	strcpy( pstCmstxdethis->devstan, cmstxdethis_devstan );
	strpack( pstCmstxdethis->devstan );
	strcpy( pstCmstxdethis->devdatetime, cmstxdethis_devdatetime );
	strpack( pstCmstxdethis->devdatetime );
	strcpy( pstCmstxdethis->devacqins, cmstxdethis_devacqins );
	strpack( pstCmstxdethis->devacqins );
	strcpy( pstCmstxdethis->devforwins, cmstxdethis_devforwins );
	strpack( pstCmstxdethis->devforwins );
	strcpy( pstCmstxdethis->authcode, cmstxdethis_authcode );
	strpack( pstCmstxdethis->authcode );
	strcpy( pstCmstxdethis->authenddate, cmstxdethis_authenddate );
	strpack( pstCmstxdethis->authenddate );
	pstCmstxdethis->authamt = cmstxdethis_authamt ;
	pubDround( &pstCmstxdethis->authamt, 2 );
	strcpy( pstCmstxdethis->text, cmstxdethis_text );
	strpack( pstCmstxdethis->text );
}

int pubReadCmstxdethis( struct cmstxdethis * pstCmstxdethis )
{
	pubInitCmstxdethis();
	pubStoVCmstxdethis(pstCmstxdethis);
	EXEC SQL SELECT * INTO RR_CMSTXDETHIS 
		FROM cmstxdethis  
		WHERE  
		 trandate = :cmstxdethis_trandate and 
		 serseqno = :cmstxdethis_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmstxdethis",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmstxdethis(pstCmstxdethis);
	return 0; 
} 
 
int pubModiCmstxdethis( struct cmstxdethis * pstCmstxdethis )
{
	pubInitCmstxdethis();
	pubStoVCmstxdethis(pstCmstxdethis);
	EXEC SQL UPDATE cmstxdethis 
		SET ( UU_CMSTXDETHIS ) = ( WW_CMSTXDETHIS ) 
		WHERE  
		 trandate = :cmstxdethis_trandate and 
		 serseqno = :cmstxdethis_serseqno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmstxdethis",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmstxdethis( struct cmstxdethis * pstCmstxdethis )
{
	pubInitCmstxdethis();
	pubStoVCmstxdethis(pstCmstxdethis);
	EXEC SQL INSERT INTO cmstxdethis VALUES ( RR_CMSTXDETHIS ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmstxdethis",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}