cmgetdb.h

李刚 请赶快放开我的权限 我上载的源码都是很精湛的,请查阅,qing请加我 [e-mail]必要的话可以和我在线沟通

#ifndef READCIRCUIT_DATABASE
#define READCIRCUIT_DATABASE

#include "sys.h"
#include "utili.h"
#include "stdio.h"
#include "stdlib.h"
#include "sqlca.h"
#include "ufile.h"

#define READ_ALLDATA    10   

#define READ_LAPD_TYPE1 11
#define READ_LAPD_TYPE2 12
#define READ_LAPD_TYPE3 13
#define READ_LAPD_TYPE4 14



#define READ_ABIS_TYPE1 21
#define READ_ABIS_TYPE2 22
#define READ_ABIS_TYPE3 23
#define READ_ABIS_TYPE4 24
#define READ_ABIS_TYPE5 25
#define READ_ABIS_TYPE6 26
#define READ_ABIS_TYPE7 27

#define READ_A_TYPE1 31
#define READ_A_TYPE2 32
#define READ_A_TYPE3 33
#define READ_A_TYPE4 34
#define READ_A_TYPE5 35
#define READ_A_TYPE6 36


#define READ_HDLC_TYPE4 44
#define READ_HDLC_TYPE3 43
#define READ_HDLC_TYPE2 42
#define READ_HDLC_TYPE1 41




#define READ_N7PCM_TYPE1 51
#define READ_N7PCM_TYPE2 52

#define RESULT_OK                0
#define ERROR_COMMAND            1
#define ERROR_OPENPROFILE        2
#define ERROR_GETREGKEY_USER     3
#define ERROR_GETREGKEY_PASSWORD 4
#define ERROR_CLOSEPROFILE       5
#define ERROR_CONNECT_DB         6
#define ERROR_COMMAND_RULE       7
#define ERROR_NEW_FILE           8
 
class CReadCircuit{
public:
	CReadCircuit(CHAR* pUid,CHAR* pPassWd);
	~CReadCircuit(); 

	ReadBSCEFromDB();
	ReadRackFromDB();
	ReadShelfFromDB();
	ReadHWFromDB();

	ReadBoardFromDB();
	ReadCBoardFromDB();
	ReadPCMFromDB();
	ReadDSPFromDB();

	ReadModuleFromDB();
	ReadMUnitFromDB();
	ReadUnitFromDB();
	ReadBCHFromDB();

	ReadLapdFromDB();
	Read485FromDB();

	ReadBTrunkDB();
	ReadTCPoolDB();
	ReadATSCOMDB();
	ReadATrunkDB();

	ReadTSiteFromDB();
	ReadTRackFromDB();
	ReadTShelfFromDB();
	ReadTPanelFromDB();

	ReadTBoardFromDB();
	ReadTBIEPCMFromDB();
	ReadTDropComFromDB();

	ReadFSComFromDB();
	ReadNSComFromDB();
	ReadN7LinkFromDB();
	ReadTBIECOMFromDB(); 

	ReadR_TSCOMFromDB();
	ReadT_BIEDropPCM();
	ReadT_TRXMULFromDB();

	ReadR_BSCOM_Lapd();
	ReadR_BSCOM_MPMP();

	ReadR_ZTELAPDLINK();

	ReadR_SITELAPD();
	ReadR_BTRUNKTS();
	ReadR_PCMTS();
	ReadR_LAPDBCH();
	ReadR_PCMINFO();
	ReadR_ZTEBTS();
	ReadR_TRXPOS();
    ReadR_ZTESITE();

	ReadLapdFromDataBase1(WORD16 BscId);
	ReadLapdFromDataBase2(WORD16 BscId,WORD16 m_SiteId);
	ReadLapdFromDataBase3(WORD16 BscId,WORD16 m_SiteId,WORD16 m_BtsId);
	ReadLapdFromDataBase4(WORD16 BscId,WORD16 m_SiteId,WORD16 m_BtsId,WORD16 m_TrxId);


	ReadAFromDataBase1(WORD16 byBscId);
   	ReadAFromDataBase2(WORD16 byBscId,WORD16 byRackNo);
	ReadAFromDataBase3(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo);
	ReadAFromDataBase4(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo);
	ReadAFromDataBase5(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo,WORD16 byPcmNo);
	ReadAFromDataBase6(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo,WORD16 byPcmNo,WORD16 byTs);

	
	ReadAbisFromDataBase7(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo,WORD16 byPcmNo,WORD16 byTs,WORD16 wSubTs);
	ReadAbisFromDataBase6(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo,WORD16 byPcmNo,WORD16 byTs);
	ReadAbisFromDataBase5(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo,WORD16 byPcmNo);
	ReadAbisFromDataBase4(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo);
	ReadAbisFromDataBase3(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo);
	ReadAbisFromDataBase2(WORD16 byBscId,WORD16 byRackNo);
	ReadAbisFromDataBase1(WORD16 byBscId);
	
	ReadHDLCFromDataBase4(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo,WORD16 bySlotNo);
    ReadHDLCFromDataBase3(WORD16 byBscId,WORD16 byRackNo,WORD16 byShelfNo);
	ReadHDLCFromDataBase2(WORD16 byBscId,WORD16 byRackNo);
	ReadHDLCFromDataBase1(WORD16 byBscId);

	ReadN7FromDataBase1(WORD16 byBscId);
	ReadN7FromDataBase2(WORD16 byBscId,WORD16 byN7PCM);

	GetLapdLinkId(WORD32 iInstanceId);
private:
	WORD32 aiOutPut[10];//MAXNUM_RACK = 3 
	void    SqlError();
	int     strstr_cnt(const CHAR *string,const CHAR *substring);
    void    strdel_end(const CHAR *string);
	void    ListConvert(CHAR * Input,WORD16 iNum);
	
};

#endif