tbcms044.sqc

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

	strcpy( pstCmscardcancelt->cardkind, cmscardcancelt_cardkind );
	strpack( pstCmscardcancelt->cardkind );
	strcpy( pstCmscardcancelt->voukind, cmscardcancelt_voukind );
	strpack( pstCmscardcancelt->voukind );
	strcpy( pstCmscardcancelt->vouno, cmscardcancelt_vouno );
	strpack( pstCmscardcancelt->vouno );
	strcpy( pstCmscardcancelt->precharcode, cmscardcancelt_precharcode );
	strpack( pstCmscardcancelt->precharcode );
	strcpy( pstCmscardcancelt->vouchno, cmscardcancelt_vouchno );
	strpack( pstCmscardcancelt->vouchno );
	strcpy( pstCmscardcancelt->flag, cmscardcancelt_flag );
	strpack( pstCmscardcancelt->flag );
	strcpy( pstCmscardcancelt->cardflg, cmscardcancelt_cardflg );
	strpack( pstCmscardcancelt->cardflg );
	strcpy( pstCmscardcancelt->custname, cmscardcancelt_custname );
	strpack( pstCmscardcancelt->custname );
	strcpy( pstCmscardcancelt->idtype, cmscardcancelt_idtype );
	strpack( pstCmscardcancelt->idtype );
	strcpy( pstCmscardcancelt->idcode, cmscardcancelt_idcode );
	strpack( pstCmscardcancelt->idcode );
	strcpy( pstCmscardcancelt->cancelteller, cmscardcancelt_cancelteller );
	strpack( pstCmscardcancelt->cancelteller );
	strcpy( pstCmscardcancelt->cancelbrc, cmscardcancelt_cancelbrc );
	strpack( pstCmscardcancelt->cancelbrc );
	strcpy( pstCmscardcancelt->destroydate, cmscardcancelt_destroydate );
	strpack( pstCmscardcancelt->destroydate );
	strcpy( pstCmscardcancelt->destroyteller, cmscardcancelt_destroyteller );
	strpack( pstCmscardcancelt->destroyteller );
	strcpy( pstCmscardcancelt->destroybrc, cmscardcancelt_destroybrc );
	strpack( pstCmscardcancelt->destroybrc );
	strcpy( pstCmscardcancelt->destroyauthteller, cmscardcancelt_destroyauthteller );
	strpack( pstCmscardcancelt->destroyauthteller );
	strcpy( pstCmscardcancelt->batchno, cmscardcancelt_batchno );
	strpack( pstCmscardcancelt->batchno );
}

int pubCallCmscardcancelt( struct cmscardcancelt * pstCmscardcancelt , int iMode )
{
	pubInitCmscardcancelt();
	pubStoVCmscardcancelt(pstCmscardcancelt);
	if ( iMode == 1 )
	{
		#ifdef V_DB2
		EXEC SQL CALL cmscardcancelt_insert( 
										:cmscardcancelt_cardno, 
										:cmscardcancelt_voukind, 
										:cmscardcancelt_precharcode, 
										:cmscardcancelt_vouno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		#endif 

		#ifdef V_INFORMIX
		EXEC SQL EXECUTE PROCEDURE cmscardcancelt_insert( 
										:cmscardcancelt_cardno, 
										:cmscardcancelt_voukind, 
										:cmscardcancelt_precharcode, 
										:cmscardcancelt_vouno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		g_lRegSeqNo++; 

		#endif 

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

	if ( iMode == 2 )
	{
		#ifdef V_DB2
		EXEC SQL CALL cmscardcancelt_update( 
										:cmscardcancelt_cardno, 
										:cmscardcancelt_cardno, 
										:cmscardcancelt_voukind, 
										:cmscardcancelt_voukind, 
										:cmscardcancelt_precharcode, 
										:cmscardcancelt_precharcode, 
										:cmscardcancelt_vouno, 
										:cmscardcancelt_vouno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		#endif 

		#ifdef V_INFORMIX
		EXEC SQL EXECUTE PROCEDURE cmscardcancelt_update( 
										:cmscardcancelt_cardno, 
										:cmscardcancelt_cardno, 
										:cmscardcancelt_voukind, 
										:cmscardcancelt_voukind, 
										:cmscardcancelt_precharcode, 
										:cmscardcancelt_precharcode, 
										:cmscardcancelt_vouno, 
										:cmscardcancelt_vouno, 
										:g_acRevBrc, 
										:g_lSerSeqNo, 
										:g_acTranDate, 
										:g_lRegSeqNo, 
										:g_lRegSeqNo 
										); 
		g_lRegSeqNo++; 

		#endif 

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


int pubReadCmscardcancelt( struct cmscardcancelt * pstCmscardcancelt )
{
	pubInitCmscardcancelt();
	pubStoVCmscardcancelt(pstCmscardcancelt);
	EXEC SQL SELECT * INTO RR_CMSCARDCANCELT 
		FROM cmscardcancelt  
		WHERE  
		 cardno = :cmscardcancelt_cardno and 
		 voukind = :cmscardcancelt_voukind and 
		 precharcode = :cmscardcancelt_precharcode and 
		 vouno = :cmscardcancelt_vouno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmscardcancelt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmscardcancelt(pstCmscardcancelt);
	return 0; 
} 
 


int pubModiCmscardcancelt( struct cmscardcancelt * pstCmscardcancelt )
{
	if ( pubCallCmscardcancelt( pstCmscardcancelt, 2 ) )
	{ 
		/* 存储过程调用错误 */ 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}
	pubInitCmscardcancelt();
	pubStoVCmscardcancelt(pstCmscardcancelt);
	EXEC SQL UPDATE cmscardcancelt 
		SET ( UU_CMSCARDCANCELT ) = ( WW_CMSCARDCANCELT ) 
		WHERE  
		 cardno = :cmscardcancelt_cardno and 
		 voukind = :cmscardcancelt_voukind and 
		 precharcode = :cmscardcancelt_precharcode and 
		 vouno = :cmscardcancelt_vouno  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmscardcancelt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmscardcancelt( struct cmscardcancelt * pstCmscardcancelt )
{
	pubInitCmscardcancelt();
	pubStoVCmscardcancelt(pstCmscardcancelt);
	EXEC SQL INSERT INTO cmscardcancelt VALUES ( RR_CMSCARDCANCELT ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmscardcancelt",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	if ( pubCallCmscardcancelt( pstCmscardcancelt, 1 ) )
	{ 
		/* 存储过程调用错误 */ 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}
	return 0; 
} 
void pubTracCmscardcancelt( struct cmscardcancelt * pstCmscardcancelt )
{
	sprintf( g_acTrcMsg, "cmscardcancelt:canceldate=[%s]", pstCmscardcancelt->canceldate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:serseqno=[%d]", pstCmscardcancelt->serseqno) ;
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:cardno=[%s]", pstCmscardcancelt->cardno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:cardkind=[%s]", pstCmscardcancelt->cardkind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:voukind=[%s]", pstCmscardcancelt->voukind );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:vouno=[%s]", pstCmscardcancelt->vouno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:precharcode=[%s]", pstCmscardcancelt->precharcode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:vouchno=[%s]", pstCmscardcancelt->vouchno );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:flag=[%s]", pstCmscardcancelt->flag );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:cardflg=[%s]", pstCmscardcancelt->cardflg );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:custname=[%s]", pstCmscardcancelt->custname );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:idtype=[%s]", pstCmscardcancelt->idtype );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:idcode=[%s]", pstCmscardcancelt->idcode );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:cancelteller=[%s]", pstCmscardcancelt->cancelteller );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:cancelbrc=[%s]", pstCmscardcancelt->cancelbrc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:destroydate=[%s]", pstCmscardcancelt->destroydate );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:destroyteller=[%s]", pstCmscardcancelt->destroyteller );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:destroybrc=[%s]", pstCmscardcancelt->destroybrc );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:destroyauthteller=[%s]", pstCmscardcancelt->destroyauthteller );
	TRCLOG1
	sprintf( g_acTrcMsg, "cmscardcancelt:batchno=[%s]", pstCmscardcancelt->batchno );
	TRCLOG1
}