tbcms007.sqc

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

/*
** 注    意: 此文件由平台自动生成，禁止任何人以任何方式修改!
** 生成日期: 2004-9-1
** 版 本 号: V1.0.0
** 初始作者: ShiBin Hu
*/

#include	"sysdefine.h"
#include	"code.h"
#include	"attrdef.h"
#include	"revglob.h"
EXEC SQL INCLUDE sqlca;

EXEC SQL BEGIN DECLARE SECTION ;
	char cmsseqm_cardkind[9];
	short cmsseqm_cardkind_id;
	char cmsseqm_cardbin[7];
	short cmsseqm_cardbin_id;
	char cmsseqm_cardidkind[7];
	short cmsseqm_cardidkind_id;
	char cmsseqm_areacode[5];
	short cmsseqm_areacode_id;
	char cmsseqm_cardseqno[10];
	short cmsseqm_cardseqno_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSSEQM \
		:cmsseqm_cardkind:cmsseqm_cardkind_id, \
		:cmsseqm_cardbin:cmsseqm_cardbin_id, \
		:cmsseqm_cardidkind:cmsseqm_cardidkind_id, \
		:cmsseqm_areacode:cmsseqm_areacode_id, \
		:cmsseqm_cardseqno:cmsseqm_cardseqno_id

#define UU_CMSSEQM \
		cardkind, \
		cardbin, \
		cardidkind, \
		areacode, \
		cardseqno

#define WW_CMSSEQM \
		:cmsseqm_cardkind, \
		:cmsseqm_cardbin, \
		:cmsseqm_cardidkind, \
		:cmsseqm_areacode, \
		:cmsseqm_cardseqno

struct cmsseqm
{
	char	cardkind[9];
	char	cardbin[7];
	char	cardidkind[7];
	char	areacode[5];
	char	cardseqno[10];
};

void pubInitCmsseqm()
{
	memset( cmsseqm_cardkind, 0x00, sizeof( cmsseqm_cardkind ) ) ;
	cmsseqm_cardkind_id = 0 ;
	memset( cmsseqm_cardbin, 0x00, sizeof( cmsseqm_cardbin ) ) ;
	cmsseqm_cardbin_id = 0 ;
	memset( cmsseqm_cardidkind, 0x00, sizeof( cmsseqm_cardidkind ) ) ;
	cmsseqm_cardidkind_id = 0 ;
	memset( cmsseqm_areacode, 0x00, sizeof( cmsseqm_areacode ) ) ;
	cmsseqm_areacode_id = 0 ;
	memset( cmsseqm_cardseqno, 0x00, sizeof( cmsseqm_cardseqno ) ) ;
	cmsseqm_cardseqno_id = 0 ;
}

void pubStoVCmsseqm( struct cmsseqm * pstCmsseqm )
{
	pubInitCmsseqm();
	if( !strlen( pstCmsseqm->cardkind ) )
		strcpy( pstCmsseqm->cardkind, " " );
	strcpy( cmsseqm_cardkind, pstCmsseqm->cardkind );
	if( !strlen( pstCmsseqm->cardbin ) )
		strcpy( pstCmsseqm->cardbin, " " );
	strcpy( cmsseqm_cardbin, pstCmsseqm->cardbin );
	if( !strlen( pstCmsseqm->cardidkind ) )
		strcpy( pstCmsseqm->cardidkind, " " );
	strcpy( cmsseqm_cardidkind, pstCmsseqm->cardidkind );
	if( !strlen( pstCmsseqm->areacode ) )
		strcpy( pstCmsseqm->areacode, " " );
	strcpy( cmsseqm_areacode, pstCmsseqm->areacode );
	if( !strlen( pstCmsseqm->cardseqno ) )
		strcpy( pstCmsseqm->cardseqno, " " );
	strcpy( cmsseqm_cardseqno, pstCmsseqm->cardseqno );
}

void pubVtoSCmsseqm( struct cmsseqm * pstCmsseqm )
{
	strcpy( pstCmsseqm->cardkind, cmsseqm_cardkind );
	strpack( pstCmsseqm->cardkind );
	strcpy( pstCmsseqm->cardbin, cmsseqm_cardbin );
	strpack( pstCmsseqm->cardbin );
	strcpy( pstCmsseqm->cardidkind, cmsseqm_cardidkind );
	strpack( pstCmsseqm->cardidkind );
	strcpy( pstCmsseqm->areacode, cmsseqm_areacode );
	strpack( pstCmsseqm->areacode );
	strcpy( pstCmsseqm->cardseqno, cmsseqm_cardseqno );
	strpack( pstCmsseqm->cardseqno );
}



int pubReadCmsseqm( struct cmsseqm * pstCmsseqm )
{
	pubInitCmsseqm();
	pubStoVCmsseqm(pstCmsseqm);
	EXEC SQL SELECT * INTO RR_CMSSEQM 
		FROM cmsseqm  
		WHERE  
		 cardkind = :cmsseqm_cardkind and 
		 cardbin = :cmsseqm_cardbin and 
		 cardidkind = :cmsseqm_cardidkind and 
		 areacode = :cmsseqm_areacode  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999996" ); 
		/* 数据库读错误 */ 
		pubCrtRspInfo( "cmsseqm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	pubVtoSCmsseqm(pstCmsseqm);
	return 0; 
} 
 


int pubModiCmsseqm( struct cmsseqm * pstCmsseqm )
{
	pubInitCmsseqm();
	pubStoVCmsseqm(pstCmsseqm);
	EXEC SQL UPDATE cmsseqm 
		SET ( UU_CMSSEQM ) = ( WW_CMSSEQM ) 
		WHERE  
		 cardkind = :cmsseqm_cardkind and 
		 cardbin = :cmsseqm_cardbin and 
		 cardidkind = :cmsseqm_cardidkind and 
		 areacode = :cmsseqm_areacode  
		 ; 
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999997" ); 
		/* 数据库更新错误 */ 
		pubCrtRspInfo( "cmsseqm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}
  


int pubInstCmsseqm( struct cmsseqm * pstCmsseqm )
{
	pubInitCmsseqm();
	pubStoVCmsseqm(pstCmsseqm);
	EXEC SQL INSERT INTO cmsseqm VALUES ( RR_CMSSEQM ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsseqm",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}