tbcms026.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 cmshismkfile_aplybrc[10];
	short cmshismkfile_aplybrc_id;
	char cmshismkfile_aplydate[11];
	short cmshismkfile_aplydate_id;
	char cmshismkfile_makedate[11];
	short cmshismkfile_makedate_id;
	long cmshismkfile_serseqno;
	short cmshismkfile_serseqno_id;
	char cmshismkfile_cardphysort[2];
	short cmshismkfile_cardphysort_id;
	char cmshismkfile_cardno[20];
	short cmshismkfile_cardno_id;
	char cmshismkfile_voukind[4];
	short cmshismkfile_voukind_id;
	char cmshismkfile_vouno[21];
	short cmshismkfile_vouno_id;
	char cmshismkfile_cardkind[9];
	short cmshismkfile_cardkind_id;
	char cmshismkfile_aplyflg[2];
	short cmshismkfile_aplyflg_id;
	char cmshismkfile_encpin[17];
	short cmshismkfile_encpin_id;
	char cmshismkfile_encinqpin[17];
	short cmshismkfile_encinqpin_id;
	char cmshismkfile_cardappr[151];
	short cmshismkfile_cardappr_id;
	char cmshismkfile_track1msg[51];
	short cmshismkfile_track1msg_id;
	char cmshismkfile_track2msg[51];
	short cmshismkfile_track2msg_id;
	char cmshismkfile_track3msg[151];
	short cmshismkfile_track3msg_id;
	char cmshismkfile_icmsg[251];
	short cmshismkfile_icmsg_id;
	char cmshismkfile_cardcenterbrc[10];
	short cmshismkfile_cardcenterbrc_id;
	char cmshismkfile_makediskflg[2];
	short cmshismkfile_makediskflg_id;
EXEC SQL END DECLARE SECTION ;

#define RR_CMSHISMKFILE \
		:cmshismkfile_aplybrc:cmshismkfile_aplybrc_id, \
		:cmshismkfile_aplydate:cmshismkfile_aplydate_id, \
		:cmshismkfile_makedate:cmshismkfile_makedate_id, \
		:cmshismkfile_serseqno:cmshismkfile_serseqno_id, \
		:cmshismkfile_cardphysort:cmshismkfile_cardphysort_id, \
		:cmshismkfile_cardno:cmshismkfile_cardno_id, \
		:cmshismkfile_voukind:cmshismkfile_voukind_id, \
		:cmshismkfile_vouno:cmshismkfile_vouno_id, \
		:cmshismkfile_cardkind:cmshismkfile_cardkind_id, \
		:cmshismkfile_aplyflg:cmshismkfile_aplyflg_id, \
		:cmshismkfile_encpin:cmshismkfile_encpin_id, \
		:cmshismkfile_encinqpin:cmshismkfile_encinqpin_id, \
		:cmshismkfile_cardappr:cmshismkfile_cardappr_id, \
		:cmshismkfile_track1msg:cmshismkfile_track1msg_id, \
		:cmshismkfile_track2msg:cmshismkfile_track2msg_id, \
		:cmshismkfile_track3msg:cmshismkfile_track3msg_id, \
		:cmshismkfile_icmsg:cmshismkfile_icmsg_id, \
		:cmshismkfile_cardcenterbrc:cmshismkfile_cardcenterbrc_id, \
		:cmshismkfile_makediskflg:cmshismkfile_makediskflg_id

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

#define WW_CMSHISMKFILE \
		:cmshismkfile_aplybrc, \
		:cmshismkfile_aplydate, \
		:cmshismkfile_makedate, \
		:cmshismkfile_serseqno, \
		:cmshismkfile_cardphysort, \
		:cmshismkfile_cardno, \
		:cmshismkfile_voukind, \
		:cmshismkfile_vouno, \
		:cmshismkfile_cardkind, \
		:cmshismkfile_aplyflg, \
		:cmshismkfile_encpin, \
		:cmshismkfile_encinqpin, \
		:cmshismkfile_cardappr, \
		:cmshismkfile_track1msg, \
		:cmshismkfile_track2msg, \
		:cmshismkfile_track3msg, \
		:cmshismkfile_icmsg, \
		:cmshismkfile_cardcenterbrc, \
		:cmshismkfile_makediskflg

struct cmshismkfile
{
	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 pubInitCmshismkfile()
{
	memset( cmshismkfile_aplybrc, 0x00, sizeof( cmshismkfile_aplybrc ) ) ;
	cmshismkfile_aplybrc_id = 0 ;
	memset( cmshismkfile_aplydate, 0x00, sizeof( cmshismkfile_aplydate ) ) ;
	cmshismkfile_aplydate_id = 0 ;
	memset( cmshismkfile_makedate, 0x00, sizeof( cmshismkfile_makedate ) ) ;
	cmshismkfile_makedate_id = 0 ;
	memset( &cmshismkfile_serseqno, 0x00, sizeof( cmshismkfile_serseqno ) ) ;
	cmshismkfile_serseqno_id = 0 ;
	memset( cmshismkfile_cardphysort, 0x00, sizeof( cmshismkfile_cardphysort ) ) ;
	cmshismkfile_cardphysort_id = 0 ;
	memset( cmshismkfile_cardno, 0x00, sizeof( cmshismkfile_cardno ) ) ;
	cmshismkfile_cardno_id = 0 ;
	memset( cmshismkfile_voukind, 0x00, sizeof( cmshismkfile_voukind ) ) ;
	cmshismkfile_voukind_id = 0 ;
	memset( cmshismkfile_vouno, 0x00, sizeof( cmshismkfile_vouno ) ) ;
	cmshismkfile_vouno_id = 0 ;
	memset( cmshismkfile_cardkind, 0x00, sizeof( cmshismkfile_cardkind ) ) ;
	cmshismkfile_cardkind_id = 0 ;
	memset( cmshismkfile_aplyflg, 0x00, sizeof( cmshismkfile_aplyflg ) ) ;
	cmshismkfile_aplyflg_id = 0 ;
	memset( cmshismkfile_encpin, 0x00, sizeof( cmshismkfile_encpin ) ) ;
	cmshismkfile_encpin_id = 0 ;
	memset( cmshismkfile_encinqpin, 0x00, sizeof( cmshismkfile_encinqpin ) ) ;
	cmshismkfile_encinqpin_id = 0 ;
	memset( cmshismkfile_cardappr, 0x00, sizeof( cmshismkfile_cardappr ) ) ;
	cmshismkfile_cardappr_id = 0 ;
	memset( cmshismkfile_track1msg, 0x00, sizeof( cmshismkfile_track1msg ) ) ;
	cmshismkfile_track1msg_id = 0 ;
	memset( cmshismkfile_track2msg, 0x00, sizeof( cmshismkfile_track2msg ) ) ;
	cmshismkfile_track2msg_id = 0 ;
	memset( cmshismkfile_track3msg, 0x00, sizeof( cmshismkfile_track3msg ) ) ;
	cmshismkfile_track3msg_id = 0 ;
	memset( cmshismkfile_icmsg, 0x00, sizeof( cmshismkfile_icmsg ) ) ;
	cmshismkfile_icmsg_id = 0 ;
	memset( cmshismkfile_cardcenterbrc, 0x00, sizeof( cmshismkfile_cardcenterbrc ) ) ;
	cmshismkfile_cardcenterbrc_id = 0 ;
	memset( cmshismkfile_makediskflg, 0x00, sizeof( cmshismkfile_makediskflg ) ) ;
	cmshismkfile_makediskflg_id = 0 ;
}

void pubStoVCmshismkfile( struct cmshismkfile * pstCmshismkfile )
{
	pubInitCmshismkfile();
	if( !strlen( pstCmshismkfile->aplybrc ) )
		strcpy( pstCmshismkfile->aplybrc, " " );
	strcpy( cmshismkfile_aplybrc, pstCmshismkfile->aplybrc );
	if( !strlen( pstCmshismkfile->aplydate ) )
		strcpy( pstCmshismkfile->aplydate, " " );
	strcpy( cmshismkfile_aplydate, pstCmshismkfile->aplydate );
	if( !strlen( pstCmshismkfile->makedate ) )
		strcpy( pstCmshismkfile->makedate, " " );
	strcpy( cmshismkfile_makedate, pstCmshismkfile->makedate );
	cmshismkfile_serseqno = pstCmshismkfile->serseqno ;
	if( !strlen( pstCmshismkfile->cardphysort ) )
		strcpy( pstCmshismkfile->cardphysort, " " );
	strcpy( cmshismkfile_cardphysort, pstCmshismkfile->cardphysort );
	if( !strlen( pstCmshismkfile->cardno ) )
		strcpy( pstCmshismkfile->cardno, " " );
	strcpy( cmshismkfile_cardno, pstCmshismkfile->cardno );
	if( !strlen( pstCmshismkfile->voukind ) )
		strcpy( pstCmshismkfile->voukind, " " );
	strcpy( cmshismkfile_voukind, pstCmshismkfile->voukind );
	if( !strlen( pstCmshismkfile->vouno ) )
		strcpy( pstCmshismkfile->vouno, " " );
	strcpy( cmshismkfile_vouno, pstCmshismkfile->vouno );
	if( !strlen( pstCmshismkfile->cardkind ) )
		strcpy( pstCmshismkfile->cardkind, " " );
	strcpy( cmshismkfile_cardkind, pstCmshismkfile->cardkind );
	if( !strlen( pstCmshismkfile->aplyflg ) )
		strcpy( pstCmshismkfile->aplyflg, " " );
	strcpy( cmshismkfile_aplyflg, pstCmshismkfile->aplyflg );
	if( !strlen( pstCmshismkfile->encpin ) )
		strcpy( pstCmshismkfile->encpin, " " );
	strcpy( cmshismkfile_encpin, pstCmshismkfile->encpin );
	if( !strlen( pstCmshismkfile->encinqpin ) )
		strcpy( pstCmshismkfile->encinqpin, " " );
	strcpy( cmshismkfile_encinqpin, pstCmshismkfile->encinqpin );
	if( !strlen( pstCmshismkfile->cardappr ) )
		strcpy( pstCmshismkfile->cardappr, " " );
	strcpy( cmshismkfile_cardappr, pstCmshismkfile->cardappr );
	if( !strlen( pstCmshismkfile->track1msg ) )
		strcpy( pstCmshismkfile->track1msg, " " );
	strcpy( cmshismkfile_track1msg, pstCmshismkfile->track1msg );
	if( !strlen( pstCmshismkfile->track2msg ) )
		strcpy( pstCmshismkfile->track2msg, " " );
	strcpy( cmshismkfile_track2msg, pstCmshismkfile->track2msg );
	if( !strlen( pstCmshismkfile->track3msg ) )
		strcpy( pstCmshismkfile->track3msg, " " );
	strcpy( cmshismkfile_track3msg, pstCmshismkfile->track3msg );
	if( !strlen( pstCmshismkfile->icmsg ) )
		strcpy( pstCmshismkfile->icmsg, " " );
	strcpy( cmshismkfile_icmsg, pstCmshismkfile->icmsg );
	if( !strlen( pstCmshismkfile->cardcenterbrc ) )
		strcpy( pstCmshismkfile->cardcenterbrc, " " );
	strcpy( cmshismkfile_cardcenterbrc, pstCmshismkfile->cardcenterbrc );
	if( !strlen( pstCmshismkfile->makediskflg ) )
		strcpy( pstCmshismkfile->makediskflg, " " );
	strcpy( cmshismkfile_makediskflg, pstCmshismkfile->makediskflg );
}

void pubVtoSCmshismkfile( struct cmshismkfile * pstCmshismkfile )
{
	strcpy( pstCmshismkfile->aplybrc, cmshismkfile_aplybrc );
	strpack( pstCmshismkfile->aplybrc );
	strcpy( pstCmshismkfile->aplydate, cmshismkfile_aplydate );
	strpack( pstCmshismkfile->aplydate );
	strcpy( pstCmshismkfile->makedate, cmshismkfile_makedate );
	strpack( pstCmshismkfile->makedate );
	pstCmshismkfile->serseqno = cmshismkfile_serseqno ;
	strcpy( pstCmshismkfile->cardphysort, cmshismkfile_cardphysort );
	strpack( pstCmshismkfile->cardphysort );
	strcpy( pstCmshismkfile->cardno, cmshismkfile_cardno );
	strpack( pstCmshismkfile->cardno );
	strcpy( pstCmshismkfile->voukind, cmshismkfile_voukind );
	strpack( pstCmshismkfile->voukind );
	strcpy( pstCmshismkfile->vouno, cmshismkfile_vouno );
	strpack( pstCmshismkfile->vouno );
	strcpy( pstCmshismkfile->cardkind, cmshismkfile_cardkind );
	strpack( pstCmshismkfile->cardkind );
	strcpy( pstCmshismkfile->aplyflg, cmshismkfile_aplyflg );
	strpack( pstCmshismkfile->aplyflg );
	strcpy( pstCmshismkfile->encpin, cmshismkfile_encpin );
	strpack( pstCmshismkfile->encpin );
	strcpy( pstCmshismkfile->encinqpin, cmshismkfile_encinqpin );
	strpack( pstCmshismkfile->encinqpin );
	strcpy( pstCmshismkfile->cardappr, cmshismkfile_cardappr );
	strpack( pstCmshismkfile->cardappr );
	strcpy( pstCmshismkfile->track1msg, cmshismkfile_track1msg );
	strpack( pstCmshismkfile->track1msg );
	strcpy( pstCmshismkfile->track2msg, cmshismkfile_track2msg );
	strpack( pstCmshismkfile->track2msg );
	strcpy( pstCmshismkfile->track3msg, cmshismkfile_track3msg );
	strpack( pstCmshismkfile->track3msg );
	strcpy( pstCmshismkfile->icmsg, cmshismkfile_icmsg );
	strpack( pstCmshismkfile->icmsg );
	strcpy( pstCmshismkfile->cardcenterbrc, cmshismkfile_cardcenterbrc );
	strpack( pstCmshismkfile->cardcenterbrc );
	strcpy( pstCmshismkfile->makediskflg, cmshismkfile_makediskflg );
	strpack( pstCmshismkfile->makediskflg );
}

int pubInstCmshismkfile( struct cmshismkfile * pstCmshismkfile )
{
	pubInitCmshismkfile();
	pubStoVCmshismkfile(pstCmshismkfile);
	EXEC SQL INSERT INTO cmshismkfile VALUES ( RR_CMSHISMKFILE ) ;
	if ( SQLCODE ) 
	{ 
		strcpy( g_acRspCode, "999998" ); 
		/* 数据库插入错误 */ 
		pubCrtRspInfo( "cmshismkfile",SQLCODE ); 
		pubErrLog( __LINE__, __FILE__, g_acRspMsg ); 
		return -1; 
	}; 
	return 0; 
}