tbcms002.sqc

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

	cmscardkind_lasttrandate_id = 0 ;
	memset( cmscardkind_teller, 0x00, sizeof( cmscardkind_teller ) ) ;
	cmscardkind_teller_id = 0 ;
}

void pubStoVCmscardkind( struct cmscardkind * pstCmscardkind )
{
	pubInitCmscardkind();
	if( !strlen( pstCmscardkind->cardkind ) )
		strcpy( pstCmscardkind->cardkind, " " );
	strcpy( cmscardkind_cardkind, pstCmscardkind->cardkind );
	if( !strlen( pstCmscardkind->cardbin ) )
		strcpy( pstCmscardkind->cardbin, " " );
	strcpy( cmscardkind_cardbin, pstCmscardkind->cardbin );
	if( !strlen( pstCmscardkind->ruleseqno ) )
		strcpy( pstCmscardkind->ruleseqno, " " );
	strcpy( cmscardkind_ruleseqno, pstCmscardkind->ruleseqno );
	if( !strlen( pstCmscardkind->voukind ) )
		strcpy( pstCmscardkind->voukind, " " );
	strcpy( cmscardkind_voukind, pstCmscardkind->voukind );
	if( !strlen( pstCmscardkind->blankvoukind ) )
		strcpy( pstCmscardkind->blankvoukind, " " );
	strcpy( cmscardkind_blankvoukind, pstCmscardkind->blankvoukind );
	if( !strlen( pstCmscardkind->yearfeerank ) )
		strcpy( pstCmscardkind->yearfeerank, " " );
	strcpy( cmscardkind_yearfeerank, pstCmscardkind->yearfeerank );
	if( !strlen( pstCmscardkind->enableflg ) )
		strcpy( pstCmscardkind->enableflg, " " );
	strcpy( cmscardkind_enableflg, pstCmscardkind->enableflg );
	if( !strlen( pstCmscardkind->seqflag ) )
		strcpy( pstCmscardkind->seqflag, " " );
	strcpy( cmscardkind_seqflag, pstCmscardkind->seqflag );
	if( !strlen( pstCmscardkind->beginseq ) )
		strcpy( pstCmscardkind->beginseq, " " );
	strcpy( cmscardkind_beginseq, pstCmscardkind->beginseq );
	if( !strlen( pstCmscardkind->endseq ) )
		strcpy( pstCmscardkind->endseq, " " );
	strcpy( cmscardkind_endseq, pstCmscardkind->endseq );
	if( !strlen( pstCmscardkind->cardidkind ) )
		strcpy( pstCmscardkind->cardidkind, " " );
	strcpy( cmscardkind_cardidkind, pstCmscardkind->cardidkind );
	if( !strlen( pstCmscardkind->cardidkindcomm ) )
		strcpy( pstCmscardkind->cardidkindcomm, " " );
	strcpy( cmscardkind_cardidkindcomm, pstCmscardkind->cardidkindcomm );
	cmscardkind_aplyfee = pstCmscardkind->aplyfee ;
	pubDround( &cmscardkind_aplyfee, 2 );
	if( !strlen( pstCmscardkind->cardkindcomm ) )
		strcpy( pstCmscardkind->cardkindcomm, " " );
	strcpy( cmscardkind_cardkindcomm, pstCmscardkind->cardkindcomm );
	if( !strlen( pstCmscardkind->setbrc ) )
		strcpy( pstCmscardkind->setbrc, " " );
	strcpy( cmscardkind_setbrc, pstCmscardkind->setbrc );
	if( !strlen( pstCmscardkind->cardphysort ) )
		strcpy( pstCmscardkind->cardphysort, " " );
	strcpy( cmscardkind_cardphysort, pstCmscardkind->cardphysort );
	if( !strlen( pstCmscardkind->cardattr ) )
		strcpy( pstCmscardkind->cardattr, " " );
	strcpy( cmscardkind_cardattr, pstCmscardkind->cardattr );
	if( !strlen( pstCmscardkind->cardattrcomm ) )
		strcpy( pstCmscardkind->cardattrcomm, " " );
	strcpy( cmscardkind_cardattrcomm, pstCmscardkind->cardattrcomm );
	if( !strlen( pstCmscardkind->cardflg ) )
		strcpy( pstCmscardkind->cardflg, " " );
	strcpy( cmscardkind_cardflg, pstCmscardkind->cardflg );
	if( !strlen( pstCmscardkind->clsdsten ) )
		strcpy( pstCmscardkind->clsdsten, " " );
	strcpy( cmscardkind_clsdsten, pstCmscardkind->clsdsten );
	if( !strlen( pstCmscardkind->trancodeset ) )
		strcpy( pstCmscardkind->trancodeset, " " );
	strcpy( cmscardkind_trancodeset, pstCmscardkind->trancodeset );
	cmscardkind_exdate = pstCmscardkind->exdate ;
	cmscardkind_maxnum = pstCmscardkind->maxnum ;
	cmscardkind_fmaxnum = pstCmscardkind->fmaxnum ;
	cmscardkind_atmerrnum = pstCmscardkind->atmerrnum ;
	cmscardkind_totalerrnum = pstCmscardkind->totalerrnum ;
	if( !strlen( pstCmscardkind->issdate ) )
		strcpy( pstCmscardkind->issdate, " " );
	strcpy( cmscardkind_issdate, pstCmscardkind->issdate );
	if( !strlen( pstCmscardkind->ccy ) )
		strcpy( pstCmscardkind->ccy, " " );
	strcpy( cmscardkind_ccy, pstCmscardkind->ccy );
	if( !strlen( pstCmscardkind->prdcod ) )
		strcpy( pstCmscardkind->prdcod, " " );
	strcpy( cmscardkind_prdcod, pstCmscardkind->prdcod );
	if( !strlen( pstCmscardkind->pswdmark ) )
		strcpy( pstCmscardkind->pswdmark, " " );
	strcpy( cmscardkind_pswdmark, pstCmscardkind->pswdmark );
	if( !strlen( pstCmscardkind->lostmark ) )
		strcpy( pstCmscardkind->lostmark, " " );
	strcpy( cmscardkind_lostmark, pstCmscardkind->lostmark );
	if( !strlen( pstCmscardkind->prtpswdenvelop ) )
		strcpy( pstCmscardkind->prtpswdenvelop, " " );
	strcpy( cmscardkind_prtpswdenvelop, pstCmscardkind->prtpswdenvelop );
	if( !strlen( pstCmscardkind->setfixexdate ) )
		strcpy( pstCmscardkind->setfixexdate, " " );
	strcpy( cmscardkind_setfixexdate, pstCmscardkind->setfixexdate );
	if( !strlen( pstCmscardkind->fixexdate ) )
		strcpy( pstCmscardkind->fixexdate, " " );
	strcpy( cmscardkind_fixexdate, pstCmscardkind->fixexdate );
	if( !strlen( pstCmscardkind->markflg ) )
		strcpy( pstCmscardkind->markflg, " " );
	strcpy( cmscardkind_markflg, pstCmscardkind->markflg );
	if( !strlen( pstCmscardkind->cardobject ) )
		strcpy( pstCmscardkind->cardobject, " " );
	strcpy( cmscardkind_cardobject, pstCmscardkind->cardobject );
	cmscardkind_edbal = pstCmscardkind->edbal ;
	pubDround( &cmscardkind_edbal, 2 );
	cmscardkind_epbal = pstCmscardkind->epbal ;
	pubDround( &cmscardkind_epbal, 2 );
	cmscardkind_minbal = pstCmscardkind->minbal ;
	pubDround( &cmscardkind_minbal, 2 );
	if( !strlen( pstCmscardkind->mid ) )
		strcpy( pstCmscardkind->mid, " " );
	strcpy( cmscardkind_mid, pstCmscardkind->mid );
	if( !strlen( pstCmscardkind->lasttrandate ) )
		strcpy( pstCmscardkind->lasttrandate, " " );
	strcpy( cmscardkind_lasttrandate, pstCmscardkind->lasttrandate );
	if( !strlen( pstCmscardkind->teller ) )
		strcpy( pstCmscardkind->teller, " " );
	strcpy( cmscardkind_teller, pstCmscardkind->teller );
}

void pubVtoSCmscardkind( struct cmscardkind * pstCmscardkind )
{
	strcpy( pstCmscardkind->cardkind, cmscardkind_cardkind );
	strpack( pstCmscardkind->cardkind );
	strcpy( pstCmscardkind->cardbin, cmscardkind_cardbin );
	strpack( pstCmscardkind->cardbin );
	strcpy( pstCmscardkind->ruleseqno, cmscardkind_ruleseqno );
	strpack( pstCmscardkind->ruleseqno );
	strcpy( pstCmscardkind->voukind, cmscardkind_voukind );
	strpack( pstCmscardkind->voukind );
	strcpy( pstCmscardkind->blankvoukind, cmscardkind_blankvoukind );
	strpack( pstCmscardkind->blankvoukind );
	strcpy( pstCmscardkind->yearfeerank, cmscardkind_yearfeerank );
	strpack( pstCmscardkind->yearfeerank );
	strcpy( pstCmscardkind->enableflg, cmscardkind_enableflg );
	strpack( pstCmscardkind->enableflg );
	strcpy( pstCmscardkind->seqflag, cmscardkind_seqflag );
	strpack( pstCmscardkind->seqflag );
	strcpy( pstCmscardkind->beginseq, cmscardkind_beginseq );
	strpack( pstCmscardkind->beginseq );
	strcpy( pstCmscardkind->endseq, cmscardkind_endseq );
	strpack( pstCmscardkind->endseq );
	strcpy( pstCmscardkind->cardidkind, cmscardkind_cardidkind );
	strpack( pstCmscardkind->cardidkind );
	strcpy( pstCmscardkind->cardidkindcomm, cmscardkind_cardidkindcomm );
	strpack( pstCmscardkind->cardidkindcomm );
	pstCmscardkind->aplyfee = cmscardkind_aplyfee ;
	pubDround( &pstCmscardkind->aplyfee, 2 );
	strcpy( pstCmscardkind->cardkindcomm, cmscardkind_cardkindcomm );
	strpack( pstCmscardkind->cardkindcomm );
	strcpy( pstCmscardkind->setbrc, cmscardkind_setbrc );
	strpack( pstCmscardkind->setbrc );
	strcpy( pstCmscardkind->cardphysort, cmscardkind_cardphysort );
	strpack( pstCmscardkind->cardphysort );
	strcpy( pstCmscardkind->cardattr, cmscardkind_cardattr );
	strpack( pstCmscardkind->cardattr );
	strcpy( pstCmscardkind->cardattrcomm, cmscardkind_cardattrcomm );
	strpack( pstCmscardkind->cardattrcomm );
	strcpy( pstCmscardkind->cardflg, cmscardkind_cardflg );
	strpack( pstCmscardkind->cardflg );
	strcpy( pstCmscardkind->clsdsten, cmscardkind_clsdsten );
	strpack( pstCmscardkind->clsdsten );
	strcpy( pstCmscardkind->trancodeset, cmscardkind_trancodeset );
	strpack( pstCmscardkind->trancodeset );
	pstCmscardkind->exdate = cmscardkind_exdate ;
	pstCmscardkind->maxnum = cmscardkind_maxnum ;
	pstCmscardkind->fmaxnum = cmscardkind_fmaxnum ;
	pstCmscardkind->atmerrnum = cmscardkind_atmerrnum ;
	pstCmscardkind->totalerrnum = cmscardkind_totalerrnum ;
	strcpy( pstCmscardkind->issdate, cmscardkind_issdate );
	strpack( pstCmscardkind->issdate );
	strcpy( pstCmscardkind->ccy, cmscardkind_ccy );
	strpack( pstCmscardkind->ccy );
	strcpy( pstCmscardkind->prdcod, cmscardkind_prdcod );
	strpack( pstCmscardkind->prdcod );
	strcpy( pstCmscardkind->pswdmark, cmscardkind_pswdmark );
	strpack( pstCmscardkind->pswdmark );
	strcpy( pstCmscardkind->lostmark, cmscardkind_lostmark );
	strpack( pstCmscardkind->lostmark );
	strcpy( pstCmscardkind->prtpswdenvelop, cmscardkind_prtpswdenvelop );
	strpack( pstCmscardkind->prtpswdenvelop );
	strcpy( pstCmscardkind->setfixexdate, cmscardkind_setfixexdate );
	strpack( pstCmscardkind->setfixexdate );
	strcpy( pstCmscardkind->fixexdate, cmscardkind_fixexdate );
	strpack( pstCmscardkind->fixexdate );
	strcpy( pstCmscardkind->markflg, cmscardkind_markflg );
	strpack( pstCmscardkind->markflg );
	strcpy( pstCmscardkind->cardobject, cmscardkind_cardobject );
	strpack( pstCmscardkind->cardobject );
	pstCmscardkind->edbal = cmscardkind_edbal ;
	pubDround( &pstCmscardkind->edbal, 2 );
	pstCmscardkind->epbal = cmscardkind_epbal ;
	pubDround( &pstCmscardkind->epbal, 2 );
	pstCmscardkind->minbal = cmscardkind_minbal ;
	pubDround( &pstCmscardkind->minbal, 2 );
	strcpy( pstCmscardkind->mid, cmscardkind_mid );
	strpack( pstCmscardkind->mid );
	strcpy( pstCmscardkind->lasttrandate, cmscardkind_lasttrandate );
	strpack( pstCmscardkind->lasttrandate );
	strcpy( pstCmscardkind->teller, cmscardkind_teller );
	strpack( pstCmscardkind->teller );
}



int pubReadCmscardkind( struct cmscardkind * pstCmscardkind )
{
	pubInitCmscardkind();
	pubStoVCmscardkind(pstCmscardkind);
	EXEC SQL SELECT * INTO RR_CMSCARDKIND 
		FROM cmscardkind  
		WHERE  
		 cardkind = :cmscardkind_cardkind  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscardkind",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscardkind(pstCmscardkind);
	return 0; 
} 
 


int pubModiCmscardkind( struct cmscardkind * pstCmscardkind )
{
	pubInitCmscardkind();
	pubStoVCmscardkind(pstCmscardkind);
	EXEC SQL UPDATE cmscardkind 
		SET ( UU_CMSCARDKIND ) = ( WW_CMSCARDKIND ) 
		WHERE  
		 cardkind = :cmscardkind_cardkind  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscardkind",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmscardkind( struct cmscardkind * pstCmscardkind )
{
	pubInitCmscardkind();
	pubStoVCmscardkind(pstCmscardkind);
	EXEC SQL INSERT INTO cmscardkind VALUES ( RR_CMSCARDKIND ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscardkind",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
} 
void pubTracCmscardkind( struct cmscardkind * pstCmscardkind )
{
	sprintf( g_acTrcMsg, "cmscardkind:cardkind=[%s]", pstCmscardkind->cardkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardbin=[%s]", pstCmscardkind->cardbin );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:ruleseqno=[%s]", pstCmscardkind->ruleseqno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:voukind=[%s]", pstCmscardkind->voukind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:blankvoukind=[%s]", pstCmscardkind->blankvoukind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:yearfeerank=[%s]", pstCmscardkind->yearfeerank );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:enableflg=[%s]", pstCmscardkind->enableflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:seqflag=[%s]", pstCmscardkind->seqflag );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:beginseq=[%s]", pstCmscardkind->beginseq );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:endseq=[%s]", pstCmscardkind->endseq );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardidkind=[%s]", pstCmscardkind->cardidkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardidkindcomm=[%s]", pstCmscardkind->cardidkindcomm );
	TRCLOG1
	pubDround( &(pstCmscardkind->aplyfee), 2 );
	sprintf( g_acTrcMsg, "cmscardkind:aplyfee=[%.2lf]", pstCmscardkind->aplyfee) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardkindcomm=[%s]", pstCmscardkind->cardkindcomm );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:setbrc=[%s]", pstCmscardkind->setbrc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardphysort=[%s]", pstCmscardkind->cardphysort );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardattr=[%s]", pstCmscardkind->cardattr );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardattrcomm=[%s]", pstCmscardkind->cardattrcomm );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardflg=[%s]", pstCmscardkind->cardflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:clsdsten=[%s]", pstCmscardkind->clsdsten );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:trancodeset=[%s]", pstCmscardkind->trancodeset );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:exdate=[%d]", pstCmscardkind->exdate) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:maxnum=[%d]", pstCmscardkind->maxnum) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:fmaxnum=[%d]", pstCmscardkind->fmaxnum) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:atmerrnum=[%d]", pstCmscardkind->atmerrnum) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:totalerrnum=[%d]", pstCmscardkind->totalerrnum) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:issdate=[%s]", pstCmscardkind->issdate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:ccy=[%s]", pstCmscardkind->ccy );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:prdcod=[%s]", pstCmscardkind->prdcod );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:pswdmark=[%s]", pstCmscardkind->pswdmark );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:lostmark=[%s]", pstCmscardkind->lostmark );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:prtpswdenvelop=[%s]", pstCmscardkind->prtpswdenvelop );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:setfixexdate=[%s]", pstCmscardkind->setfixexdate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:fixexdate=[%s]", pstCmscardkind->fixexdate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:markflg=[%s]", pstCmscardkind->markflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:cardobject=[%s]", pstCmscardkind->cardobject );
	TRCLOG1
	pubDround( &(pstCmscardkind->edbal), 2 );
	sprintf( g_acTrcMsg, "cmscardkind:edbal=[%.2lf]", pstCmscardkind->edbal) ;
	TRCLOG1
	pubDround( &(pstCmscardkind->epbal), 2 );
	sprintf( g_acTrcMsg, "cmscardkind:epbal=[%.2lf]", pstCmscardkind->epbal) ;
	TRCLOG1
	pubDround( &(pstCmscardkind->minbal), 2 );
	sprintf( g_acTrcMsg, "cmscardkind:minbal=[%.2lf]", pstCmscardkind->minbal) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:mid=[%s]", pstCmscardkind->mid );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:lasttrandate=[%s]", pstCmscardkind->lasttrandate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardkind:teller=[%s]", pstCmscardkind->teller );
	TRCLOG1
}