cms606.sqc

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

/********************************************************************
**   源码文件名称 : cms606.SQC
**   所属子系统   : CMS
**   当前文件版本 : 4.0.0.0
**   作者         : ZhouR
**   版本创建日期 : 2004/09/xx
**   功能描述     : 卡片信息表查询
**   修改记录     :
**   修改人       修改日期     修改日期
*********************************************************************/
#include "code.h"
#include "attrdef.h"
#include "sysdef.h"
#include "pubcom.h"
#include "cmscode.h"
#include <stdio.h>
#include <fcntl.h>

#include "cmscardinfo.h"
#include "cmscardkind.h"
#include "pubinq.h"
EXEC SQL INCLUDE SQLCA;
/*******************************************************
**   函数名称: cms216006
**   功能描述：卡片信息表查询
**   输入参数：
**             acCardNo  ----  卡号
**   输出参数:
**             
**   返回结果: 0： 签约  －1： 失败    1： 未签约
**   作        者 : ZhouR
**   版本创建日期 : 2004/09/20
**   修改记录     :
**   修改人       修改日期     修改位置
*******************************************************/

int cms216006( PUBCOM *pstPubcom )
{
	/*定义局部变量*/
	struct	cmscardinfo			stCmsCardInfo;	/* 卡片信息表 */
	struct	cmscardkind			stCmsCardKind;	/* 卡片种类表 */
	BASESUBACCTINFO          stDpsAccInfo;      /* 静态表       */
	char    acCardNo[CARDNO_LEN + 1];   	    /* 卡号 */
	char    acCardKind[CARDKIND_LEN + 1];   	/* 卡号 */
	char    acCardStat[MEMO60_LEN + 1]; 	  	/* 卡状态中文信息 */
	char                *   pcCardKind;         /* 卡片种类 */
	int    iRtn;

	strcpy( g_acTrcMsg, "子交易: 卡片信息表查询子交易开始.." );
	TRCLOG4

	/* 初始化 */
	memset( &stCmsCardInfo,		0x00,	sizeof( struct cmscardinfo ) );
	memset( &stCmsCardKind,		0x00,	sizeof( struct cmscardkind ) );
	memset( &stDpsAccInfo,      0x00,   sizeof( BASESUBACCTINFO ) );
	memset( acCardStat, 		0x00, 	sizeof( acCardStat ) );
	memset( acCardNo,        	0x00,   sizeof( acCardNo ) );

    /* 取数据字典值 */
	getstring( "CardNo",	acCardNo	);

	sprintf( g_acTrcMsg,"CardNo[%s]",acCardNo );
	TRCLOG3

	/* 从卡片信息表获取纪录 */
	if( cmsApiGetCmsCardInfo( acCardNo, &stCmsCardInfo ) )
	{
		strcpy( g_acTrcMsg, "子交易: 卡片信息表查询子交易失败.." );
		TRCLOG4;
		ERRLOG
		return FAILED;
	}
	strcpy( g_acTrcMsg, "stCmsCardInfo" );
	TRCLOG3;

	/* 转换卡状态  */
	strcpy( acCardStat, cmsConvertCardStat( stCmsCardInfo.cardstat ) );
	strcpy( g_acTrcMsg, acCardStat );
	TRCLOG3;

	/*取卡片种类表*/
	strcpy( acCardKind, stCmsCardInfo.cardkind );
	if( cmsApiGetCmsCardKind( acCardKind, &stCmsCardKind ) )
	{
		sprintf(g_acRspCode,"999996");
        pubCrtRspInfo( "cmscardkind", SQLCODE );
		ERRLOG
		strcpy( g_acRspMsg, "取卡片种类表失败..." );
		TRCLOG4;
		return FAILED;
	}

	/* 按客户账号和款项代码获取账户信息 DPS API */
	sprintf( g_acTrcMsg,"stCmsCardInfo.acctno[%s]stCmsCardInfo.subacct[%s]",
			stCmsCardInfo.acctno,stCmsCardInfo.subacct);
	TRCLOG3

	memset( &stDpsAccInfo,      0x00,   sizeof( BASESUBACCTINFO ) );
	iRtn = InqBaseSubAcct(  pstPubcom,
							stCmsCardInfo.cardno,
							"",
							"",
							"1100000000000000", "0","0",
							&stDpsAccInfo);
	if (iRtn)
	{
		strcpy( g_acRspCode, RSP_OK );
	}

	/* 子交易出口 */
	setstring( "CardNo",     stCmsCardInfo.cardno );     /*卡号*/
	setstring( "CardKind",   stCmsCardInfo.cardkind );   /*卡片种类*/
	setstring( "CardFlg",    stCmsCardInfo.cardflg );    /*卡片标志*/
	setstring( "CardObject", stCmsCardInfo.cardobject ); /*发卡对象*/
	setstring( "CardAttr",   stCmsCardInfo.cardattr );   /*卡片属性代码*/
	setstring( "CardIdKind", stCmsCardInfo.cardidkind );   /*卡片识别种类代码*/
	setstring( "CardIdKindComm", stCmsCardInfo.cardidkindcomm );   /*卡片识别种类代码*/
	setstring( "MarkFlg",    stCmsCardInfo.markflg );    /*记名卡/非记名卡标志*/
	setstring( "AcctNo",     stCmsCardInfo.acctno );     /*卡内活期结算主帐户*/
	setstring( "SubAcct",    stCmsCardInfo.subacct );    /*款项代码*/
	setstring( "Brc1", 		 stCmsCardInfo.issuebrc );   /*发卡机构码*/
	setstring( "Teller1", 	 stCmsCardInfo.teller );     /*发卡交易柜员*/
	setstring( "CustomId", 	 stCmsCardInfo.custno );     /*客户号*/
	setstring( "CardNo1", 	 stCmsCardInfo.maincardno ); /*主卡卡号*/
	setint( "Times", 		 &stCmsCardInfo.errnum ); 	 /*密码错误次数*/
	setint( "Times1", 	 	 &stCmsCardInfo.errnumtot);  /*密码错误总次数*/
	setstring( "BeginDate1", stCmsCardInfo.usedate); 	 /*启用日期*/
	setstring( "EndDate1",   stCmsCardInfo.closedate); 	 /*销卡日期*/
	setstring( "BeginDate2", stCmsCardInfo.chgdate); 	 /*状态修改日期*/
	setstring( "LastDate", stCmsCardInfo.lastdate); 	 /*上笔日期*/
	setstring( "CrdSts", 	 stCmsCardInfo.crdsts); 	 /*卡片状态*/
	setstring( "CardStat", 	 acCardStat); 				 /*卡状态*/
	setint( "Times2", 		 &stCmsCardInfo.acdcnt); 	 /*附卡张数*/
	setdouble( "Amt1", 		 &stCmsCardInfo.acdlmt); 	 /*附卡交易限额*/
	setdouble( "Amt2", 		 &stCmsCardInfo.acduseamt);  /*附卡已用金额*/
	setstring( "CardNo2", 	 stCmsCardInfo.oldcardno); 	 /*旧卡号*/
	setstring( "CardNo3", 	 stCmsCardInfo.newcardno); 	 /*新卡号*/
	setstring( "BookFlag",	 stCmsCardInfo.hasbankbook); /*有折标志*/
	setstring( "EndDate2",   stCmsCardInfo.validdate);   /*卡有效期*/
	setstring( "YFeeFlag",   stCmsCardInfo.yfeeflag);    /*是否要缴年费*/
	setstring( "FeeYear",    stCmsCardInfo.yfeeyear);    /*已收取年费的年份*/
	setstring( "YFeeRank",    stCmsCardInfo.yearfeerank);    /*年费级别*/
	setdouble( "Amt3",       &stCmsCardInfo.yfee);  	 /*指定年费金额*/
	setdouble( "Amt4", 		 &stCmsCardInfo.yfeebal);  	 /*未交年费总计*/
	setstring( "VouKind", 	 stCmsCardInfo.voukind); 	 /*凭证种类*/
	setstring( "VouNo", 	 stCmsCardInfo.vouno); 		 /*凭证号码*/
	setstring( "BillWay", 	 stCmsCardInfo.billway); 	 /*对帐单处理方式*/
	setstring( "AddressType",stCmsCardInfo.billaddtype); /*对帐单邮寄地址类型*/
	setstring( "AreaCode",	 stCmsCardInfo.areacode); 	 /*地区代码*/
	setstring( "CardKindComm",stCmsCardKind.cardkindcomm);/*卡片种类说明*/
	setstring( "IdType",	 stDpsAccInfo.acIdType );		 /*证件类型*/
	setstring( "IdNo",		 stDpsAccInfo.acIdNo );		 /*证件号码*/
	setstring( "CustName",	 stDpsAccInfo.acCustomName );	 /*客户名称*/

	strcpy( g_acTrcMsg, "子交易: 卡片信息表查询结束.." );
	TRCLOG4

	strcpy( g_acRspCode,  RSP_OK );

	return SUCCESS;
}