tbcms021.sqc

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

	cmscardinfo_availbal = pstCmscardinfo->availbal ;
	pubDround( &cmscardinfo_availbal, 2 );
	if( !strlen( pstCmscardinfo->areacode ) )
		strcpy( pstCmscardinfo->areacode, " " );
	strcpy( cmscardinfo_areacode, pstCmscardinfo->areacode );
	if( !strlen( pstCmscardinfo->cardoffset ) )
		strcpy( pstCmscardinfo->cardoffset, " " );
	strcpy( cmscardinfo_cardoffset, pstCmscardinfo->cardoffset );
}

void pubVtoSCmscardinfo( struct cmscardinfo * pstCmscardinfo )
{
	strcpy( pstCmscardinfo->cardno, cmscardinfo_cardno );
	strpack( pstCmscardinfo->cardno );
	strcpy( pstCmscardinfo->cardseqno, cmscardinfo_cardseqno );
	strpack( pstCmscardinfo->cardseqno );
	strcpy( pstCmscardinfo->cardkind, cmscardinfo_cardkind );
	strpack( pstCmscardinfo->cardkind );
	pstCmscardinfo->serverlevel = cmscardinfo_serverlevel ;
	strcpy( pstCmscardinfo->yearfeerank, cmscardinfo_yearfeerank );
	strpack( pstCmscardinfo->yearfeerank );
	strcpy( pstCmscardinfo->cardflg, cmscardinfo_cardflg );
	strpack( pstCmscardinfo->cardflg );
	strcpy( pstCmscardinfo->cardobject, cmscardinfo_cardobject );
	strpack( pstCmscardinfo->cardobject );
	strcpy( pstCmscardinfo->cardattr, cmscardinfo_cardattr );
	strpack( pstCmscardinfo->cardattr );
	strcpy( pstCmscardinfo->markflg, cmscardinfo_markflg );
	strpack( pstCmscardinfo->markflg );
	strcpy( pstCmscardinfo->cardidkind, cmscardinfo_cardidkind );
	strpack( pstCmscardinfo->cardidkind );
	strcpy( pstCmscardinfo->cardidkindcomm, cmscardinfo_cardidkindcomm );
	strpack( pstCmscardinfo->cardidkindcomm );
	strcpy( pstCmscardinfo->acctseqno, cmscardinfo_acctseqno );
	strpack( pstCmscardinfo->acctseqno );
	strcpy( pstCmscardinfo->acctno, cmscardinfo_acctno );
	strpack( pstCmscardinfo->acctno );
	strcpy( pstCmscardinfo->subacct, cmscardinfo_subacct );
	strpack( pstCmscardinfo->subacct );
	strcpy( pstCmscardinfo->issuebrc, cmscardinfo_issuebrc );
	strpack( pstCmscardinfo->issuebrc );
	strcpy( pstCmscardinfo->teller, cmscardinfo_teller );
	strpack( pstCmscardinfo->teller );
	strcpy( pstCmscardinfo->clsbrc, cmscardinfo_clsbrc );
	strpack( pstCmscardinfo->clsbrc );
	strcpy( pstCmscardinfo->clsteller, cmscardinfo_clsteller );
	strpack( pstCmscardinfo->clsteller );
	strcpy( pstCmscardinfo->custno, cmscardinfo_custno );
	strpack( pstCmscardinfo->custno );
	strcpy( pstCmscardinfo->maincardno, cmscardinfo_maincardno );
	strpack( pstCmscardinfo->maincardno );
	strcpy( pstCmscardinfo->passwd, cmscardinfo_passwd );
	strpack( pstCmscardinfo->passwd );
	pstCmscardinfo->errnum = cmscardinfo_errnum ;
	pstCmscardinfo->errnumtot = cmscardinfo_errnumtot ;
	strcpy( pstCmscardinfo->usedate, cmscardinfo_usedate );
	strpack( pstCmscardinfo->usedate );
	strcpy( pstCmscardinfo->closedate, cmscardinfo_closedate );
	strpack( pstCmscardinfo->closedate );
	strcpy( pstCmscardinfo->chgdate, cmscardinfo_chgdate );
	strpack( pstCmscardinfo->chgdate );
	strcpy( pstCmscardinfo->crdsts, cmscardinfo_crdsts );
	strpack( pstCmscardinfo->crdsts );
	strcpy( pstCmscardinfo->cardstat, cmscardinfo_cardstat );
	strpack( pstCmscardinfo->cardstat );
	pstCmscardinfo->acdcnt = cmscardinfo_acdcnt ;
	pstCmscardinfo->acdlmt = cmscardinfo_acdlmt ;
	pubDround( &pstCmscardinfo->acdlmt, 2 );
	pstCmscardinfo->acduseamt = cmscardinfo_acduseamt ;
	pubDround( &pstCmscardinfo->acduseamt, 2 );
	strcpy( pstCmscardinfo->oldcardno, cmscardinfo_oldcardno );
	strpack( pstCmscardinfo->oldcardno );
	strcpy( pstCmscardinfo->newcardno, cmscardinfo_newcardno );
	strpack( pstCmscardinfo->newcardno );
	strcpy( pstCmscardinfo->hasbankbook, cmscardinfo_hasbankbook );
	strpack( pstCmscardinfo->hasbankbook );
	strcpy( pstCmscardinfo->empflg, cmscardinfo_empflg );
	strpack( pstCmscardinfo->empflg );
	strcpy( pstCmscardinfo->validdate, cmscardinfo_validdate );
	strpack( pstCmscardinfo->validdate );
	strcpy( pstCmscardinfo->yfeeflag, cmscardinfo_yfeeflag );
	strpack( pstCmscardinfo->yfeeflag );
	strcpy( pstCmscardinfo->yfeeyear, cmscardinfo_yfeeyear );
	strpack( pstCmscardinfo->yfeeyear );
	pstCmscardinfo->yfee = cmscardinfo_yfee ;
	pubDround( &pstCmscardinfo->yfee, 2 );
	pstCmscardinfo->yfeebal = cmscardinfo_yfeebal ;
	pubDround( &pstCmscardinfo->yfeebal, 2 );
	strcpy( pstCmscardinfo->madfeeflag, cmscardinfo_madfeeflag );
	strpack( pstCmscardinfo->madfeeflag );
	strcpy( pstCmscardinfo->cardsn, cmscardinfo_cardsn );
	strpack( pstCmscardinfo->cardsn );
	strcpy( pstCmscardinfo->voukind, cmscardinfo_voukind );
	strpack( pstCmscardinfo->voukind );
	strcpy( pstCmscardinfo->vouno, cmscardinfo_vouno );
	strpack( pstCmscardinfo->vouno );
	strcpy( pstCmscardinfo->precharcode, cmscardinfo_precharcode );
	strpack( pstCmscardinfo->precharcode );
	strcpy( pstCmscardinfo->lastdate, cmscardinfo_lastdate );
	strpack( pstCmscardinfo->lastdate );
	strcpy( pstCmscardinfo->billway, cmscardinfo_billway );
	strpack( pstCmscardinfo->billway );
	strcpy( pstCmscardinfo->billaddtype, cmscardinfo_billaddtype );
	strpack( pstCmscardinfo->billaddtype );
	strcpy( pstCmscardinfo->cardsrc, cmscardinfo_cardsrc );
	strpack( pstCmscardinfo->cardsrc );
	pstCmscardinfo->currbal = cmscardinfo_currbal ;
	pubDround( &pstCmscardinfo->currbal, 2 );
	pstCmscardinfo->availbal = cmscardinfo_availbal ;
	pubDround( &pstCmscardinfo->availbal, 2 );
	strcpy( pstCmscardinfo->areacode, cmscardinfo_areacode );
	strpack( pstCmscardinfo->areacode );
	strcpy( pstCmscardinfo->cardoffset, cmscardinfo_cardoffset );
	strpack( pstCmscardinfo->cardoffset );
}



int pubReadCmscardinfo( struct cmscardinfo * pstCmscardinfo )
{
	pubInitCmscardinfo();
	pubStoVCmscardinfo(pstCmscardinfo);
	EXEC SQL SELECT * INTO RR_CMSCARDINFO 
		FROM cmscardinfo  
		WHERE  
		 cardno = :cmscardinfo_cardno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscardinfo",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscardinfo(pstCmscardinfo);
	return 0; 
} 
 


int pubModiCmscardinfo( struct cmscardinfo * pstCmscardinfo )
{
	pubInitCmscardinfo();
	pubStoVCmscardinfo(pstCmscardinfo);
	EXEC SQL UPDATE cmscardinfo 
		SET ( UU_CMSCARDINFO ) = ( WW_CMSCARDINFO ) 
		WHERE  
		 cardno = :cmscardinfo_cardno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscardinfo",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmscardinfo( struct cmscardinfo * pstCmscardinfo )
{
	pubInitCmscardinfo();
	pubStoVCmscardinfo(pstCmscardinfo);
	EXEC SQL INSERT INTO cmscardinfo VALUES ( RR_CMSCARDINFO ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscardinfo",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
} 
void pubTracCmscardinfo( struct cmscardinfo * pstCmscardinfo )
{
	sprintf( g_acTrcMsg, "cmscardinfo:cardno=[%s]", pstCmscardinfo->cardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardseqno=[%s]", pstCmscardinfo->cardseqno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardkind=[%s]", pstCmscardinfo->cardkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:serverlevel=[%d]", pstCmscardinfo->serverlevel) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:yearfeerank=[%s]", pstCmscardinfo->yearfeerank );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardflg=[%s]", pstCmscardinfo->cardflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardobject=[%s]", pstCmscardinfo->cardobject );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardattr=[%s]", pstCmscardinfo->cardattr );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:markflg=[%s]", pstCmscardinfo->markflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardidkind=[%s]", pstCmscardinfo->cardidkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardidkindcomm=[%s]", pstCmscardinfo->cardidkindcomm );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:acctseqno=[%s]", pstCmscardinfo->acctseqno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:acctno=[%s]", pstCmscardinfo->acctno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:subacct=[%s]", pstCmscardinfo->subacct );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:issuebrc=[%s]", pstCmscardinfo->issuebrc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:teller=[%s]", pstCmscardinfo->teller );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:clsbrc=[%s]", pstCmscardinfo->clsbrc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:clsteller=[%s]", pstCmscardinfo->clsteller );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:custno=[%s]", pstCmscardinfo->custno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:maincardno=[%s]", pstCmscardinfo->maincardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:passwd=[%s]", pstCmscardinfo->passwd );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:errnum=[%d]", pstCmscardinfo->errnum) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:errnumtot=[%d]", pstCmscardinfo->errnumtot) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:usedate=[%s]", pstCmscardinfo->usedate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:closedate=[%s]", pstCmscardinfo->closedate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:chgdate=[%s]", pstCmscardinfo->chgdate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:crdsts=[%s]", pstCmscardinfo->crdsts );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardstat=[%s]", pstCmscardinfo->cardstat );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:acdcnt=[%d]", pstCmscardinfo->acdcnt) ;
	TRCLOG1
	pubDround( &(pstCmscardinfo->acdlmt), 2 );
	sprintf( g_acTrcMsg, "cmscardinfo:acdlmt=[%.2lf]", pstCmscardinfo->acdlmt) ;
	TRCLOG1
	pubDround( &(pstCmscardinfo->acduseamt), 2 );
	sprintf( g_acTrcMsg, "cmscardinfo:acduseamt=[%.2lf]", pstCmscardinfo->acduseamt) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:oldcardno=[%s]", pstCmscardinfo->oldcardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:newcardno=[%s]", pstCmscardinfo->newcardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:hasbankbook=[%s]", pstCmscardinfo->hasbankbook );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:empflg=[%s]", pstCmscardinfo->empflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:validdate=[%s]", pstCmscardinfo->validdate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:yfeeflag=[%s]", pstCmscardinfo->yfeeflag );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:yfeeyear=[%s]", pstCmscardinfo->yfeeyear );
	TRCLOG1
	pubDround( &(pstCmscardinfo->yfee), 2 );
	sprintf( g_acTrcMsg, "cmscardinfo:yfee=[%.2lf]", pstCmscardinfo->yfee) ;
	TRCLOG1
	pubDround( &(pstCmscardinfo->yfeebal), 2 );
	sprintf( g_acTrcMsg, "cmscardinfo:yfeebal=[%.2lf]", pstCmscardinfo->yfeebal) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:madfeeflag=[%s]", pstCmscardinfo->madfeeflag );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardsn=[%s]", pstCmscardinfo->cardsn );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:voukind=[%s]", pstCmscardinfo->voukind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:vouno=[%s]", pstCmscardinfo->vouno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:precharcode=[%s]", pstCmscardinfo->precharcode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:lastdate=[%s]", pstCmscardinfo->lastdate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:billway=[%s]", pstCmscardinfo->billway );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:billaddtype=[%s]", pstCmscardinfo->billaddtype );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardsrc=[%s]", pstCmscardinfo->cardsrc );
	TRCLOG1
	pubDround( &(pstCmscardinfo->currbal), 2 );
	sprintf( g_acTrcMsg, "cmscardinfo:currbal=[%.2lf]", pstCmscardinfo->currbal) ;
	TRCLOG1
	pubDround( &(pstCmscardinfo->availbal), 2 );
	sprintf( g_acTrcMsg, "cmscardinfo:availbal=[%.2lf]", pstCmscardinfo->availbal) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:areacode=[%s]", pstCmscardinfo->areacode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardinfo:cardoffset=[%s]", pstCmscardinfo->cardoffset );
	TRCLOG1
}