tbcms025.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 cmsmkfile_aplybrc[10];
	short cmsmkfile_aplybrc_id;
	char cmsmkfile_aplydate[11];
	short cmsmkfile_aplydate_id;
	char cmsmkfile_makedate[11];
	short cmsmkfile_makedate_id;
	long cmsmkfile_serseqno;
	short cmsmkfile_serseqno_id;
	char cmsmkfile_cardphysort[2];
	short cmsmkfile_cardphysort_id;
	char cmsmkfile_cardno[20];
	short cmsmkfile_cardno_id;
	char cmsmkfile_voukind[4];
	short cmsmkfile_voukind_id;
	char cmsmkfile_vouno[21];
	short cmsmkfile_vouno_id;
	char cmsmkfile_cardkind[9];
	short cmsmkfile_cardkind_id;
	char cmsmkfile_aplyflg[2];
	short cmsmkfile_aplyflg_id;
	char cmsmkfile_encpin[17];
	short cmsmkfile_encpin_id;
	char cmsmkfile_encinqpin[17];
	short cmsmkfile_encinqpin_id;
	char cmsmkfile_cardappr[151];
	short cmsmkfile_cardappr_id;
	char cmsmkfile_track1msg[51];
	short cmsmkfile_track1msg_id;
	char cmsmkfile_track2msg[51];
	short cmsmkfile_track2msg_id;
	char cmsmkfile_track3msg[151];
	short cmsmkfile_track3msg_id;
	char cmsmkfile_icmsg[251];
	short cmsmkfile_icmsg_id;
	char cmsmkfile_cardcenterbrc[10];
	short cmsmkfile_cardcenterbrc_id;
	char cmsmkfile_makediskflg[2];
	short cmsmkfile_makediskflg_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSMKFILE \
		:cmsmkfile_aplybrc:cmsmkfile_aplybrc_id, \
		:cmsmkfile_aplydate:cmsmkfile_aplydate_id, \
		:cmsmkfile_makedate:cmsmkfile_makedate_id, \
		:cmsmkfile_serseqno:cmsmkfile_serseqno_id, \
		:cmsmkfile_cardphysort:cmsmkfile_cardphysort_id, \
		:cmsmkfile_cardno:cmsmkfile_cardno_id, \
		:cmsmkfile_voukind:cmsmkfile_voukind_id, \
		:cmsmkfile_vouno:cmsmkfile_vouno_id, \
		:cmsmkfile_cardkind:cmsmkfile_cardkind_id, \
		:cmsmkfile_aplyflg:cmsmkfile_aplyflg_id, \
		:cmsmkfile_encpin:cmsmkfile_encpin_id, \
		:cmsmkfile_encinqpin:cmsmkfile_encinqpin_id, \
		:cmsmkfile_cardappr:cmsmkfile_cardappr_id, \
		:cmsmkfile_track1msg:cmsmkfile_track1msg_id, \
		:cmsmkfile_track2msg:cmsmkfile_track2msg_id, \
		:cmsmkfile_track3msg:cmsmkfile_track3msg_id, \
		:cmsmkfile_icmsg:cmsmkfile_icmsg_id, \
		:cmsmkfile_cardcenterbrc:cmsmkfile_cardcenterbrc_id, \
		:cmsmkfile_makediskflg:cmsmkfile_makediskflg_id

#define UU_CMSMKFILE \
		aplybrc, \
		aplydate, \
		makedate, \
		serseqno, \
		cardphysort, \
		cardno, \
		voukind, \
		vouno, \
		cardkind, \
		aplyflg, \
		encpin, \
		encinqpin, \
		cardappr, \
		track1msg, \
		track2msg, \
		track3msg, \
		icmsg, \
		cardcenterbrc, \
		makediskflg

#define WW_CMSMKFILE \
		:cmsmkfile_aplybrc, \
		:cmsmkfile_aplydate, \
		:cmsmkfile_makedate, \
		:cmsmkfile_serseqno, \
		:cmsmkfile_cardphysort, \
		:cmsmkfile_cardno, \
		:cmsmkfile_voukind, \
		:cmsmkfile_vouno, \
		:cmsmkfile_cardkind, \
		:cmsmkfile_aplyflg, \
		:cmsmkfile_encpin, \
		:cmsmkfile_encinqpin, \
		:cmsmkfile_cardappr, \
		:cmsmkfile_track1msg, \
		:cmsmkfile_track2msg, \
		:cmsmkfile_track3msg, \
		:cmsmkfile_icmsg, \
		:cmsmkfile_cardcenterbrc, \
		:cmsmkfile_makediskflg

struct cmsmkfile
{
	char	aplybrc[10];
	char	aplydate[11];
	char	makedate[11];
	long	serseqno;
	char	cardphysort[2];
	char	cardno[20];
	char	voukind[4];
	char	vouno[21];
	char	cardkind[9];
	char	aplyflg[2];
	char	encpin[17];
	char	encinqpin[17];
	char	cardappr[151];
	char	track1msg[51];
	char	track2msg[51];
	char	track3msg[151];
	char	icmsg[251];
	char	cardcenterbrc[10];
	char	makediskflg[2];
};

void pubInitCmsmkfile()
{
	memset( cmsmkfile_aplybrc, 0x00, sizeof( cmsmkfile_aplybrc ) ) ;
	cmsmkfile_aplybrc_id = 0 ;
	memset( cmsmkfile_aplydate, 0x00, sizeof( cmsmkfile_aplydate ) ) ;
	cmsmkfile_aplydate_id = 0 ;
	memset( cmsmkfile_makedate, 0x00, sizeof( cmsmkfile_makedate ) ) ;
	cmsmkfile_makedate_id = 0 ;
	memset( &cmsmkfile_serseqno, 0x00, sizeof( cmsmkfile_serseqno ) ) ;
	cmsmkfile_serseqno_id = 0 ;
	memset( cmsmkfile_cardphysort, 0x00, sizeof( cmsmkfile_cardphysort ) ) ;
	cmsmkfile_cardphysort_id = 0 ;
	memset( cmsmkfile_cardno, 0x00, sizeof( cmsmkfile_cardno ) ) ;
	cmsmkfile_cardno_id = 0 ;
	memset( cmsmkfile_voukind, 0x00, sizeof( cmsmkfile_voukind ) ) ;
	cmsmkfile_voukind_id = 0 ;
	memset( cmsmkfile_vouno, 0x00, sizeof( cmsmkfile_vouno ) ) ;
	cmsmkfile_vouno_id = 0 ;
	memset( cmsmkfile_cardkind, 0x00, sizeof( cmsmkfile_cardkind ) ) ;
	cmsmkfile_cardkind_id = 0 ;
	memset( cmsmkfile_aplyflg, 0x00, sizeof( cmsmkfile_aplyflg ) ) ;
	cmsmkfile_aplyflg_id = 0 ;
	memset( cmsmkfile_encpin, 0x00, sizeof( cmsmkfile_encpin ) ) ;
	cmsmkfile_encpin_id = 0 ;
	memset( cmsmkfile_encinqpin, 0x00, sizeof( cmsmkfile_encinqpin ) ) ;
	cmsmkfile_encinqpin_id = 0 ;
	memset( cmsmkfile_cardappr, 0x00, sizeof( cmsmkfile_cardappr ) ) ;
	cmsmkfile_cardappr_id = 0 ;
	memset( cmsmkfile_track1msg, 0x00, sizeof( cmsmkfile_track1msg ) ) ;
	cmsmkfile_track1msg_id = 0 ;
	memset( cmsmkfile_track2msg, 0x00, sizeof( cmsmkfile_track2msg ) ) ;
	cmsmkfile_track2msg_id = 0 ;
	memset( cmsmkfile_track3msg, 0x00, sizeof( cmsmkfile_track3msg ) ) ;
	cmsmkfile_track3msg_id = 0 ;
	memset( cmsmkfile_icmsg, 0x00, sizeof( cmsmkfile_icmsg ) ) ;
	cmsmkfile_icmsg_id = 0 ;
	memset( cmsmkfile_cardcenterbrc, 0x00, sizeof( cmsmkfile_cardcenterbrc ) ) ;
	cmsmkfile_cardcenterbrc_id = 0 ;
	memset( cmsmkfile_makediskflg, 0x00, sizeof( cmsmkfile_makediskflg ) ) ;
	cmsmkfile_makediskflg_id = 0 ;
}

void pubStoVCmsmkfile( struct cmsmkfile * pstCmsmkfile )
{
	pubInitCmsmkfile();
	if( !strlen( pstCmsmkfile->aplybrc ) )
		strcpy( pstCmsmkfile->aplybrc, " " );
	strcpy( cmsmkfile_aplybrc, pstCmsmkfile->aplybrc );
	if( !strlen( pstCmsmkfile->aplydate ) )
		strcpy( pstCmsmkfile->aplydate, " " );
	strcpy( cmsmkfile_aplydate, pstCmsmkfile->aplydate );
	if( !strlen( pstCmsmkfile->makedate ) )
		strcpy( pstCmsmkfile->makedate, " " );
	strcpy( cmsmkfile_makedate, pstCmsmkfile->makedate );
	cmsmkfile_serseqno = pstCmsmkfile->serseqno ;
	if( !strlen( pstCmsmkfile->cardphysort ) )
		strcpy( pstCmsmkfile->cardphysort, " " );
	strcpy( cmsmkfile_cardphysort, pstCmsmkfile->cardphysort );
	if( !strlen( pstCmsmkfile->cardno ) )
		strcpy( pstCmsmkfile->cardno, " " );
	strcpy( cmsmkfile_cardno, pstCmsmkfile->cardno );
	if( !strlen( pstCmsmkfile->voukind ) )
		strcpy( pstCmsmkfile->voukind, " " );
	strcpy( cmsmkfile_voukind, pstCmsmkfile->voukind );
	if( !strlen( pstCmsmkfile->vouno ) )
		strcpy( pstCmsmkfile->vouno, " " );
	strcpy( cmsmkfile_vouno, pstCmsmkfile->vouno );
	if( !strlen( pstCmsmkfile->cardkind ) )
		strcpy( pstCmsmkfile->cardkind, " " );
	strcpy( cmsmkfile_cardkind, pstCmsmkfile->cardkind );
	if( !strlen( pstCmsmkfile->aplyflg ) )
		strcpy( pstCmsmkfile->aplyflg, " " );
	strcpy( cmsmkfile_aplyflg, pstCmsmkfile->aplyflg );
	if( !strlen( pstCmsmkfile->encpin ) )
		strcpy( pstCmsmkfile->encpin, " " );
	strcpy( cmsmkfile_encpin, pstCmsmkfile->encpin );
	if( !strlen( pstCmsmkfile->encinqpin ) )
		strcpy( pstCmsmkfile->encinqpin, " " );
	strcpy( cmsmkfile_encinqpin, pstCmsmkfile->encinqpin );
	if( !strlen( pstCmsmkfile->cardappr ) )
		strcpy( pstCmsmkfile->cardappr, " " );
	strcpy( cmsmkfile_cardappr, pstCmsmkfile->cardappr );
	if( !strlen( pstCmsmkfile->track1msg ) )
		strcpy( pstCmsmkfile->track1msg, " " );
	strcpy( cmsmkfile_track1msg, pstCmsmkfile->track1msg );
	if( !strlen( pstCmsmkfile->track2msg ) )
		strcpy( pstCmsmkfile->track2msg, " " );
	strcpy( cmsmkfile_track2msg, pstCmsmkfile->track2msg );
	if( !strlen( pstCmsmkfile->track3msg ) )
		strcpy( pstCmsmkfile->track3msg, " " );
	strcpy( cmsmkfile_track3msg, pstCmsmkfile->track3msg );
	if( !strlen( pstCmsmkfile->icmsg ) )
		strcpy( pstCmsmkfile->icmsg, " " );
	strcpy( cmsmkfile_icmsg, pstCmsmkfile->icmsg );
	if( !strlen( pstCmsmkfile->cardcenterbrc ) )
		strcpy( pstCmsmkfile->cardcenterbrc, " " );
	strcpy( cmsmkfile_cardcenterbrc, pstCmsmkfile->cardcenterbrc );
	if( !strlen( pstCmsmkfile->makediskflg ) )
		strcpy( pstCmsmkfile->makediskflg, " " );
	strcpy( cmsmkfile_makediskflg, pstCmsmkfile->makediskflg );
}

void pubVtoSCmsmkfile( struct cmsmkfile * pstCmsmkfile )
{
	strcpy( pstCmsmkfile->aplybrc, cmsmkfile_aplybrc );
	strpack( pstCmsmkfile->aplybrc );
	strcpy( pstCmsmkfile->aplydate, cmsmkfile_aplydate );
	strpack( pstCmsmkfile->aplydate );
	strcpy( pstCmsmkfile->makedate, cmsmkfile_makedate );
	strpack( pstCmsmkfile->makedate );
	pstCmsmkfile->serseqno = cmsmkfile_serseqno ;
	strcpy( pstCmsmkfile->cardphysort, cmsmkfile_cardphysort );
	strpack( pstCmsmkfile->cardphysort );
	strcpy( pstCmsmkfile->cardno, cmsmkfile_cardno );
	strpack( pstCmsmkfile->cardno );
	strcpy( pstCmsmkfile->voukind, cmsmkfile_voukind );
	strpack( pstCmsmkfile->voukind );
	strcpy( pstCmsmkfile->vouno, cmsmkfile_vouno );
	strpack( pstCmsmkfile->vouno );
	strcpy( pstCmsmkfile->cardkind, cmsmkfile_cardkind );
	strpack( pstCmsmkfile->cardkind );
	strcpy( pstCmsmkfile->aplyflg, cmsmkfile_aplyflg );
	strpack( pstCmsmkfile->aplyflg );
	strcpy( pstCmsmkfile->encpin, cmsmkfile_encpin );
	strpack( pstCmsmkfile->encpin );
	strcpy( pstCmsmkfile->encinqpin, cmsmkfile_encinqpin );
	strpack( pstCmsmkfile->encinqpin );
	strcpy( pstCmsmkfile->cardappr, cmsmkfile_cardappr );
	strpack( pstCmsmkfile->cardappr );
	strcpy( pstCmsmkfile->track1msg, cmsmkfile_track1msg );
	strpack( pstCmsmkfile->track1msg );
	strcpy( pstCmsmkfile->track2msg, cmsmkfile_track2msg );
	strpack( pstCmsmkfile->track2msg );
	strcpy( pstCmsmkfile->track3msg, cmsmkfile_track3msg );
	strpack( pstCmsmkfile->track3msg );
	strcpy( pstCmsmkfile->icmsg, cmsmkfile_icmsg );
	strpack( pstCmsmkfile->icmsg );
	strcpy( pstCmsmkfile->cardcenterbrc, cmsmkfile_cardcenterbrc );
	strpack( pstCmsmkfile->cardcenterbrc );
	strcpy( pstCmsmkfile->makediskflg, cmsmkfile_makediskflg );
	strpack( pstCmsmkfile->makediskflg );
}

int pubInstCmsmkfile( struct cmsmkfile * pstCmsmkfile )
{
	pubInitCmsmkfile();
	pubStoVCmsmkfile(pstCmsmkfile);
	EXEC SQL INSERT INTO cmsmkfile VALUES ( RR_CMSMKFILE ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmsmkfile",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}