tbcms035.sqc

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

	cmsmerchantinfo_lowlimit_id = 0 ;
	memset( &cmsmerchantinfo_highlimit, 0x00, sizeof( cmsmerchantinfo_highlimit ) ) ;
	cmsmerchantinfo_highlimit_id = 0 ;
	memset( cmsmerchantinfo_rakeoffflg, 0x00, sizeof( cmsmerchantinfo_rakeoffflg ) ) ;
	cmsmerchantinfo_rakeoffflg_id = 0 ;
	memset( cmsmerchantinfo_opnflg, 0x00, sizeof( cmsmerchantinfo_opnflg ) ) ;
	cmsmerchantinfo_opnflg_id = 0 ;
	memset( cmsmerchantinfo_settleaccno, 0x00, sizeof( cmsmerchantinfo_settleaccno ) ) ;
	cmsmerchantinfo_settleaccno_id = 0 ;
	memset( cmsmerchantinfo_opnbankname, 0x00, sizeof( cmsmerchantinfo_opnbankname ) ) ;
	cmsmerchantinfo_opnbankname_id = 0 ;
	memset( cmsmerchantinfo_opnbankexchcode, 0x00, sizeof( cmsmerchantinfo_opnbankexchcode ) ) ;
	cmsmerchantinfo_opnbankexchcode_id = 0 ;
	memset( cmsmerchantinfo_mctflg, 0x00, sizeof( cmsmerchantinfo_mctflg ) ) ;
	cmsmerchantinfo_mctflg_id = 0 ;
	memset( cmsmerchantinfo_description, 0x00, sizeof( cmsmerchantinfo_description ) ) ;
	cmsmerchantinfo_description_id = 0 ;
}

void pubStoVCmsmerchantinfo( struct cmsmerchantinfo * pstCmsmerchantinfo )
{
	pubInitCmsmerchantinfo();
	if( !strlen( pstCmsmerchantinfo->mid ) )
		strcpy( pstCmsmerchantinfo->mid, " " );
	strcpy( cmsmerchantinfo_mid, pstCmsmerchantinfo->mid );
	if( !strlen( pstCmsmerchantinfo->mctname ) )
		strcpy( pstCmsmerchantinfo->mctname, " " );
	strcpy( cmsmerchantinfo_mctname, pstCmsmerchantinfo->mctname );
	if( !strlen( pstCmsmerchantinfo->mctmcc ) )
		strcpy( pstCmsmerchantinfo->mctmcc, " " );
	strcpy( cmsmerchantinfo_mctmcc, pstCmsmerchantinfo->mctmcc );
	if( !strlen( pstCmsmerchantinfo->goingteleno ) )
		strcpy( pstCmsmerchantinfo->goingteleno, " " );
	strcpy( cmsmerchantinfo_goingteleno, pstCmsmerchantinfo->goingteleno );
	if( !strlen( pstCmsmerchantinfo->conperidtype ) )
		strcpy( pstCmsmerchantinfo->conperidtype, " " );
	strcpy( cmsmerchantinfo_conperidtype, pstCmsmerchantinfo->conperidtype );
	if( !strlen( pstCmsmerchantinfo->conperidcode ) )
		strcpy( pstCmsmerchantinfo->conperidcode, " " );
	strcpy( cmsmerchantinfo_conperidcode, pstCmsmerchantinfo->conperidcode );
	if( !strlen( pstCmsmerchantinfo->conpername ) )
		strcpy( pstCmsmerchantinfo->conpername, " " );
	strcpy( cmsmerchantinfo_conpername, pstCmsmerchantinfo->conpername );
	if( !strlen( pstCmsmerchantinfo->conperteleno ) )
		strcpy( pstCmsmerchantinfo->conperteleno, " " );
	strcpy( cmsmerchantinfo_conperteleno, pstCmsmerchantinfo->conperteleno );
	if( !strlen( pstCmsmerchantinfo->conpermobno ) )
		strcpy( pstCmsmerchantinfo->conpermobno, " " );
	strcpy( cmsmerchantinfo_conpermobno, pstCmsmerchantinfo->conpermobno );
	if( !strlen( pstCmsmerchantinfo->conperbpno ) )
		strcpy( pstCmsmerchantinfo->conperbpno, " " );
	strcpy( cmsmerchantinfo_conperbpno, pstCmsmerchantinfo->conperbpno );
	if( !strlen( pstCmsmerchantinfo->mctaddress ) )
		strcpy( pstCmsmerchantinfo->mctaddress, " " );
	strcpy( cmsmerchantinfo_mctaddress, pstCmsmerchantinfo->mctaddress );
	if( !strlen( pstCmsmerchantinfo->midaccno ) )
		strcpy( pstCmsmerchantinfo->midaccno, " " );
	strcpy( cmsmerchantinfo_midaccno, pstCmsmerchantinfo->midaccno );
	if( !strlen( pstCmsmerchantinfo->brc ) )
		strcpy( pstCmsmerchantinfo->brc, " " );
	strcpy( cmsmerchantinfo_brc, pstCmsmerchantinfo->brc );
	cmsmerchantinfo_rakeoffratefix = pstCmsmerchantinfo->rakeoffratefix ;
	pubDround( &cmsmerchantinfo_rakeoffratefix, 4 );
	cmsmerchantinfo_rakeofffix = pstCmsmerchantinfo->rakeofffix ;
	pubDround( &cmsmerchantinfo_rakeofffix, 2 );
	cmsmerchantinfo_lowlimit = pstCmsmerchantinfo->lowlimit ;
	pubDround( &cmsmerchantinfo_lowlimit, 2 );
	cmsmerchantinfo_highlimit = pstCmsmerchantinfo->highlimit ;
	pubDround( &cmsmerchantinfo_highlimit, 2 );
	if( !strlen( pstCmsmerchantinfo->rakeoffflg ) )
		strcpy( pstCmsmerchantinfo->rakeoffflg, " " );
	strcpy( cmsmerchantinfo_rakeoffflg, pstCmsmerchantinfo->rakeoffflg );
	if( !strlen( pstCmsmerchantinfo->opnflg ) )
		strcpy( pstCmsmerchantinfo->opnflg, " " );
	strcpy( cmsmerchantinfo_opnflg, pstCmsmerchantinfo->opnflg );
	if( !strlen( pstCmsmerchantinfo->settleaccno ) )
		strcpy( pstCmsmerchantinfo->settleaccno, " " );
	strcpy( cmsmerchantinfo_settleaccno, pstCmsmerchantinfo->settleaccno );
	if( !strlen( pstCmsmerchantinfo->opnbankname ) )
		strcpy( pstCmsmerchantinfo->opnbankname, " " );
	strcpy( cmsmerchantinfo_opnbankname, pstCmsmerchantinfo->opnbankname );
	if( !strlen( pstCmsmerchantinfo->opnbankexchcode ) )
		strcpy( pstCmsmerchantinfo->opnbankexchcode, " " );
	strcpy( cmsmerchantinfo_opnbankexchcode, pstCmsmerchantinfo->opnbankexchcode );
	if( !strlen( pstCmsmerchantinfo->mctflg ) )
		strcpy( pstCmsmerchantinfo->mctflg, " " );
	strcpy( cmsmerchantinfo_mctflg, pstCmsmerchantinfo->mctflg );
	if( !strlen( pstCmsmerchantinfo->description ) )
		strcpy( pstCmsmerchantinfo->description, " " );
	strcpy( cmsmerchantinfo_description, pstCmsmerchantinfo->description );
}

void pubVtoSCmsmerchantinfo( struct cmsmerchantinfo * pstCmsmerchantinfo )
{
	strcpy( pstCmsmerchantinfo->mid, cmsmerchantinfo_mid );
	strpack( pstCmsmerchantinfo->mid );
	strcpy( pstCmsmerchantinfo->mctname, cmsmerchantinfo_mctname );
	strpack( pstCmsmerchantinfo->mctname );
	strcpy( pstCmsmerchantinfo->mctmcc, cmsmerchantinfo_mctmcc );
	strpack( pstCmsmerchantinfo->mctmcc );
	strcpy( pstCmsmerchantinfo->goingteleno, cmsmerchantinfo_goingteleno );
	strpack( pstCmsmerchantinfo->goingteleno );
	strcpy( pstCmsmerchantinfo->conperidtype, cmsmerchantinfo_conperidtype );
	strpack( pstCmsmerchantinfo->conperidtype );
	strcpy( pstCmsmerchantinfo->conperidcode, cmsmerchantinfo_conperidcode );
	strpack( pstCmsmerchantinfo->conperidcode );
	strcpy( pstCmsmerchantinfo->conpername, cmsmerchantinfo_conpername );
	strpack( pstCmsmerchantinfo->conpername );
	strcpy( pstCmsmerchantinfo->conperteleno, cmsmerchantinfo_conperteleno );
	strpack( pstCmsmerchantinfo->conperteleno );
	strcpy( pstCmsmerchantinfo->conpermobno, cmsmerchantinfo_conpermobno );
	strpack( pstCmsmerchantinfo->conpermobno );
	strcpy( pstCmsmerchantinfo->conperbpno, cmsmerchantinfo_conperbpno );
	strpack( pstCmsmerchantinfo->conperbpno );
	strcpy( pstCmsmerchantinfo->mctaddress, cmsmerchantinfo_mctaddress );
	strpack( pstCmsmerchantinfo->mctaddress );
	strcpy( pstCmsmerchantinfo->midaccno, cmsmerchantinfo_midaccno );
	strpack( pstCmsmerchantinfo->midaccno );
	strcpy( pstCmsmerchantinfo->brc, cmsmerchantinfo_brc );
	strpack( pstCmsmerchantinfo->brc );
	pstCmsmerchantinfo->rakeoffratefix = cmsmerchantinfo_rakeoffratefix ;
	pubDround( &pstCmsmerchantinfo->rakeoffratefix, 4 );
	pstCmsmerchantinfo->rakeofffix = cmsmerchantinfo_rakeofffix ;
	pubDround( &pstCmsmerchantinfo->rakeofffix, 2 );
	pstCmsmerchantinfo->lowlimit = cmsmerchantinfo_lowlimit ;
	pubDround( &pstCmsmerchantinfo->lowlimit, 2 );
	pstCmsmerchantinfo->highlimit = cmsmerchantinfo_highlimit ;
	pubDround( &pstCmsmerchantinfo->highlimit, 2 );
	strcpy( pstCmsmerchantinfo->rakeoffflg, cmsmerchantinfo_rakeoffflg );
	strpack( pstCmsmerchantinfo->rakeoffflg );
	strcpy( pstCmsmerchantinfo->opnflg, cmsmerchantinfo_opnflg );
	strpack( pstCmsmerchantinfo->opnflg );
	strcpy( pstCmsmerchantinfo->settleaccno, cmsmerchantinfo_settleaccno );
	strpack( pstCmsmerchantinfo->settleaccno );
	strcpy( pstCmsmerchantinfo->opnbankname, cmsmerchantinfo_opnbankname );
	strpack( pstCmsmerchantinfo->opnbankname );
	strcpy( pstCmsmerchantinfo->opnbankexchcode, cmsmerchantinfo_opnbankexchcode );
	strpack( pstCmsmerchantinfo->opnbankexchcode );
	strcpy( pstCmsmerchantinfo->mctflg, cmsmerchantinfo_mctflg );
	strpack( pstCmsmerchantinfo->mctflg );
	strcpy( pstCmsmerchantinfo->description, cmsmerchantinfo_description );
	strpack( pstCmsmerchantinfo->description );
}

int pubReadCmsmerchantinfo( struct cmsmerchantinfo * pstCmsmerchantinfo )
{
	pubInitCmsmerchantinfo();
	pubStoVCmsmerchantinfo(pstCmsmerchantinfo);
	EXEC SQL SELECT * INTO RR_CMSMERCHANTINFO 
		FROM cmsmerchantinfo  
		WHERE  
		 mid = :cmsmerchantinfo_mid  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsmerchantinfo",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsmerchantinfo(pstCmsmerchantinfo);
	return 0; 
} 
 
int pubModiCmsmerchantinfo( struct cmsmerchantinfo * pstCmsmerchantinfo )
{
	pubInitCmsmerchantinfo();
	pubStoVCmsmerchantinfo(pstCmsmerchantinfo);
	EXEC SQL UPDATE cmsmerchantinfo 
		SET ( UU_CMSMERCHANTINFO ) = ( WW_CMSMERCHANTINFO ) 
		WHERE  
		 mid = :cmsmerchantinfo_mid  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsmerchantinfo",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  
int pubInstCmsmerchantinfo( struct cmsmerchantinfo * pstCmsmerchantinfo )
{
	pubInitCmsmerchantinfo();
	pubStoVCmsmerchantinfo(pstCmsmerchantinfo);
	EXEC SQL INSERT INTO cmsmerchantinfo VALUES ( RR_CMSMERCHANTINFO ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsmerchantinfo",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}