genrpt.pc

unix后台c代码

#include <stdio.h>
#include <ctype.h>

/*	monitor */
#include "monitor.h"
#include "sqlcommon.h"
#include <signal.h>



char gsPartID[9] = "";

char gsRbs[9] = "rbs06";


void catchsig_term(int sig)
{
	char		buffer[255];
	pid_t		pid;
	siginfo_t	siginfo;
	int nSid, nSerial;

	cmsprintf(2,0,"%s","生成报表中间表程序发生异常，程序退出................................FALSE!");
			
	DisconnectMonitor(PS_ABORT);
	exit(0);
}



int main(int argc,char * argv[])
{
	int cGet;
	char sUserName[50], sPassWord[50], sDbLink[50];
	char sBusiness[20];
	int iAppID;
	
	signal(SIGTERM,catchsig_term);
	signal(SIGKILL,catchsig_term);
	signal(SIGSEGV,catchsig_term);
	signal(SIGQUIT,catchsig_term);
	signal(SIGTERM,catchsig_term);
	signal(SIGABRT,catchsig_term);
	signal(SIGSTOP,catchsig_term);
	signal(SIGINT,catchsig_term);
	cmsprintf(0,0,"%s\n","生成报表中间表程序模块开始运行………….................OK!");


	ConnectedDB();

/*	if(ConnectMonitor(APPID_PREPROCESS)<0){
		printf("connect reject\n");
		return -1;
	}
	cmsprintf(0,0,"连接监控成功!\n");
*/	
	
		
	if (ProduceReptTable() == FALSE){
		printf("生成报表中间表错误，程序非正常终止\n"); 
		cmsprintf(1,1, "%s\n","生成报表中间表完成，程序非正常终止......");
		DisconnectMonitor(PS_ABORT);
		exit(1);
	}	
	
	EXEC SQL COMMIT;
		
	printf("生成报表中间表完成，程序正常终止\n"); 
	cmsprintf(0,0, "生成报表中间表完成，程序正常终止......");
	return 0;
	
	
}	


int ProduceReptTable()
{

	int iErrCode;
	char sMsg[1024];
	
	printf("开始生成REPT_QFZL表...... \n");	
	cmsprintf(0,0, "开始生成REPT_QFZL表...... \n");
	
	EXEC SQL EXECUTE
		BEGIN
			proc_rept_qfzl(:iErrCode, :sMsg);
		END;
	END-EXEC;

	if (iErrCode != 0){
		printf("生成REPT_QFZL表错误，结果 %d \n", iErrCode); 
		cmsprintf(1,1, "%s : %s\n","生成REPT_QFZL表错误，错误为", sMsg);
		
		return FALSE;
	}
	else{
		printf("生成REPT_QFZL表完成\n"); 
		cmsprintf(0,0, "%s\n","生成REPT_QFZL表完成......");
	}
	

	EXEC SQL COMMIT;	

	printf("开始生成REPT_ACCTFEE表...... \n");	
	cmsprintf(0,0, "开始生成REPT_ACCTFEE表...... \n");
	
	EXEC SQL EXECUTE
		BEGIN
			proc_rept_acctfee(:iErrCode, :sMsg);
		END;
	END-EXEC;

	if (iErrCode != 0){
		printf("生成REPT_ACCTFEE表错误，结果 %d \n", iErrCode); 
		cmsprintf(1,1, "%s : %s\n","生成REPT_ACCTFEE表错误，错误为", sMsg);
		
		return FALSE;
	}
	else{
		printf("生成REPT_ACCTFEE表完成\n"); 
		cmsprintf(0,0, "%s\n","生成REPT_ACCTFEE表完成......");
	}
	

	EXEC SQL COMMIT;	
	
	
	return TRUE;
}


void MainQuit(int iSigno)
{
	int nSid, nSerial;
	
	printf("signo:%d catched, program is aborted !\n",iSigno);
		
	exit(1);
}