cms637.sqc

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

/********************************************************************
 **   源码文件名称 : cms637.SQC
 **   所属子系统   : CMS 
 **   当前文件版本 : 1.0.0.0
 **   作        者 : xuliang 
 **   版本创建日期 : 2005/01/12
 **   功能描述     : 卡作废销毁登记簿查询
 **   修改记录     :
 **   修改人       修改日期     修改日期
*********************************************************************/
#include    "sysdefine.h"
#include    <stdio.h>
#include	"pubcom.h"
#include	"funcapi.h"

#include    "code.h"
#include    "attrdef.h"
#include    "cmscode.h"

#include	"cmscardcancelt.h"
#include 	"errlog.h"

EXEC SQL INCLUDE SQLCA;

/*******************************************************
**   函数名称: cms216037
**   功能描述：卡作废销毁登记簿查询
**   输入参数：
**
**   输出参数:
**
**   返回结果: 
**   作        者 : xuliang 
**   版本创建日期 : 2005/01/12
**   修改记录     :
**   修改人       修改日期     修改位置
*******************************************************/
int cms216037(pstPubcom)
struct          pubcom          *pstPubcom;
{
	FILE	*fp;							          /* 文件指针  	  */
	char	acBeginDate[ DATE_LEN + 1 ];              /* 起始日期     */
	char	acEndDate[ DATE_LEN + 1 ];                /* 终止日期     */
	char    acFlag[BIT2_LEN + 1 ];              /* 作废销毁标志        */
	char    acCancelBrc[BRC_LEN + 1 ];          /* 作废机构码          */  
	char    acDestroyBrc[BRC_LEN + 1];          /* 销毁机构码       */     

	char    acTableName[PRDCODE_LEN + 1];             /* 表名称 */
	char    acFileName[FILENAME_LEN + 1];             /* 文件名称 */

	char    acSelStr[ CONDITION_LEN + 1 ];
    char    acWhrStr[ CONDITION_LEN + 1 ];
    char    acWhrStr1[ CONDITION_LEN + 1 ];
    char    acWhrStr2[ CONDITION_LEN + 1 ];
    char    acWhrStr3[ CONDITION_LEN + 1 ];
    char    acWhrStr4[ CONDITION_LEN + 1 ];
    char    acWhrStr5[ CONDITION_LEN + 1 ];
    char    acWhrStr6[ CONDITION_LEN + 1 ];
    char    acWhrStr7[ CONDITION_LEN + 1 ];
    char    acWhrStr8[ CONDITION_LEN + 1 ];

    struct cmscardcancelt      stCmscardcancelt;    /* 卡作废销毁登记簿 */

	sprintf( g_acTrcMsg,"卡作废销毁登记簿查询开始");
	TRCLOG4

	memset( acBeginDate,   0x00, sizeof( acBeginDate ) );
	memset( acEndDate,	   0x00, sizeof( acEndDate ) );
	memset( acCancelBrc,   0x00, sizeof( acCancelBrc )   );  
	memset( acDestroyBrc,  0x00, sizeof( acDestroyBrc )  );  

    memset( acFileName,    0x00, sizeof( acFileName ) );
	memset( acTableName,   0x00, sizeof( acTableName ) );
	memset( acSelStr,0x00, sizeof( acSelStr ) );
	memset( acWhrStr,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr1,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr2,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr3,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr4,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr5,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr6,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr7,0x00, sizeof( acWhrStr ) );
	memset( acWhrStr8,0x00, sizeof( acWhrStr ) );
	memset( &stCmscardcancelt,  0x00, sizeof( struct cmscardcancelt ) );

    /* 取数据字典 */
    getstring( "BeginDate1", acBeginDate );
	getstring( "EndDate1", acEndDate);
	getstring( "Flag",          acFlag  ); 

    sprintf( g_acTrcMsg,"BeginDate[%s]EndDate[%s]",
                    	 acBeginDate,acEndDate );
	TRCLOG4


    /*检查交易机构是否为中心机构，如果是，则申请机构可以为空，否则当申请机构为空时，将交易机构付给申请机构 */
	if ( strcmp( pstPubcom->acBrcType, BRCTYPE_SITE)) /* 营业网点 */
	{
			sprintf( g_acTrcMsg,"[%s]", pstPubcom->acBrc );  
			TRCLOG4
	}
	if ( !strcmp( pstPubcom->acBrcType, BRCTYPE_SITE)) /* 营业网点 */
	{
		if (strlen(acCancelBrc) == 0)
		{
			sprintf( g_acTrcMsg,"acCancelBrc[%s]", pstPubcom->acBrc );  
			TRCLOG4
			strcpy( acCancelBrc, pstPubcom->acBrc );	
		}
		if (strlen(acDestroyBrc) == 0)
		{
			sprintf( g_acTrcMsg,"acDestroyBrc[%s]", pstPubcom->acBrc );  
			TRCLOG4
			strcpy( acDestroyBrc, pstPubcom->acBrc );	
		}
	}
	if(GenSqlCmd( "216037" , acSelStr ))
	{
		ERRLOG
		goto Exit;
	}

	if ( strlen ( acFlag ) > 0 ) 
	{
		sprintf( acWhrStr, " where 1=1");

		if ( acFlag[0] == '0' ) 
		{
			if ( strcmp ( acBeginDate, INITDATE ) )
			{
				sprintf( acWhrStr+strlen(acWhrStr), " and canceldate >= '%s'",  acBeginDate );
			}

			if ( strcmp ( acEndDate, INITDATE ) )
			{
				sprintf( acWhrStr+strlen(acWhrStr), " and canceldate <= '%s'",  acEndDate );
			}
		}
		if ( acFlag[0] == '1' ) 
		{
			if ( strcmp ( acBeginDate, INITDATE ) )
			{
				sprintf( acWhrStr+strlen(acWhrStr), " and destroydate >= '%s'",  acBeginDate );
			}

			if ( strcmp ( acEndDate, INITDATE ) )
			{
				sprintf( acWhrStr+strlen(acWhrStr), " and destroydate <= '%s'",  acEndDate );
			}
		}
        sprintf( acWhrStr+strlen(acWhrStr), " and flag = '%s'" ,  acFlag);

		if ( acFlag[0] == '0' && strlen( acCancelBrc ) > 0 )
		{
       		sprintf( acWhrStr+strlen(acWhrStr), " and cancelbrc = '%s'" ,  acCancelBrc);
    	}

		if ( acFlag[0] == '1' && strlen( acDestroyBrc ) > 0 )
		{
       		sprintf( acWhrStr+strlen(acWhrStr), " and destroybrc = '%s'" ,  acDestroyBrc);
    	}
		sprintf( acWhrStr+strlen(acWhrStr), " ORDER BY cancelbrc, destroybrc, cardno DESC" );
	}
	else
	{
		sprintf( acWhrStr1, " where 1=1");

		if ( strcmp ( acBeginDate, INITDATE ) )
		{
			sprintf( acWhrStr3, " canceldate >= '%s'",  acBeginDate );
			sprintf( acWhrStr5, " destroydate >= '%s'",  acBeginDate );
		}
		if ( strcmp ( acEndDate, INITDATE ) )
		{
			sprintf( acWhrStr4, " canceldate <= '%s'",  acEndDate );
			sprintf( acWhrStr6, " destroydate <= '%s'",  acEndDate );
		}
		if ( !strcmp( pstPubcom->acBrcType, BRCTYPE_SITE)) /* 营业网点 */
		{
       		sprintf( acWhrStr7, " and (cancelbrc = '%s' or destroybrc = '%s')" , acCancelBrc,acDestroyBrc);
		}
		sprintf( acWhrStr8, " ORDER BY cancelbrc, destroybrc, cardno DESC" );
		if (( strcmp ( acBeginDate, INITDATE ) ) && ( !strcmp ( acEndDate, INITDATE ) ))
		{
			sprintf( acWhrStr, "%s %s and ( %s or %s )%s%s",acWhrStr1,acWhrStr2,acWhrStr3,acWhrStr5,acWhrStr7,acWhrStr8 );
		}
		if (( !strcmp ( acBeginDate, INITDATE ) ) && ( strcmp ( acEndDate, INITDATE ) ))
		{
			sprintf( acWhrStr, "%s %s and ( %s or %s )%s%s",acWhrStr1,acWhrStr2,acWhrStr4,acWhrStr6,acWhrStr7,acWhrStr8 );
		}
		if (( strcmp ( acBeginDate, INITDATE ) ) && ( strcmp ( acEndDate, INITDATE ) ))
		{
			sprintf( acWhrStr, "%s %s and (( %s and %s )or( %s and %s ))%s%s",acWhrStr1,
				acWhrStr2,acWhrStr3,acWhrStr4,acWhrStr5,acWhrStr6,acWhrStr7,acWhrStr8 );
		}
		if (( !strcmp ( acBeginDate, INITDATE ) ) && ( !strcmp ( acEndDate, INITDATE ) ))
		{
			sprintf( acWhrStr, "%s %s %s%s",acWhrStr1,acWhrStr2,acWhrStr7,acWhrStr8 );
		}
	}

	strcpy( acTableName, "cms637" );
	sprintf(acFileName, "%s%s%s", acTableName, pstPubcom->acBrc,pstPubcom->acTeller);

	fp = (FILE *)BeginFile( pstPubcom, acFileName );
	if ( fp == NULL )
	{
		strcpy( g_acRspMsg, "打开文件句柄出错!" );
		pubCrtRspInfo( );
		ERRLOG
		goto Exit;
	}

	/*组织查询字典*/
	if (GetInqDict( fp , "216037" ))
	{
		ERRLOG
		goto Exit;
	}

	/* 准备数据 */
	sprintf( g_acTrcMsg, "%s%s" ,acSelStr,acWhrStr);
	TRCLOG3

	if ( DBSelect( "cmscardcancelt", acSelStr ,acWhrStr , fp ) )
	{
		ERRLOG
		goto Exit;
	}
    /* 出口赋值 */ 
Exit:
	EndFile( fp );

	if( !strcmp( g_acRspCode, RSP_OK ) )
	{
		SetInqFormid(pstPubcom, "216037") ; 
		sprintf( g_acTrcMsg,"卡作废销毁登记簿查询正常结束");
		TRCLOG4
		return SUCCESS;
    }
	else 
	{
		sprintf( g_acTrcMsg,"卡作废销毁登记簿查询打印失败");
		TRCLOG4
		return FAILED ;
	}
}