cmgetdb.pc

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

/******************************************************************************
模块名         :  OMC-R 2.0
文件名         :  showcfg.cpp
相关文件       :
文件实现功能   :  显示地面资源固定接续关系
作者           :  lichunlan
版本           :  V1.0
-------------------------------------------------------------------------------
修改记录 : 
日  期        版本        修改人        修改内容 
2001-02-20    1.0                       创建 
******************************************************************************/
#include "cmgetdb.h"
extern DllExport VOID oceTraceOn(VOID);

WORD16 wBscId;
WORD16 wSiteId;
WORD16 wBtsId;
WORD16 wTrxId;
WORD16 wType;
WORD16 wRackNo;
WORD16 wShelfNo;
WORD16 wSlotNo;
WORD16 wPcmNo;
WORD16 wSubTs;
WORD16 wTs;
WORD16 wN7PCM;

CString str,strPos;
WORD32  iPos;
CFile *pfFile;
CHAR  pFileName[100];

EXEC SQL BEGIN DECLARE SECTION;

/* --------------add by lichunlan for tru-------------   */
     typedef struct R_ZTESITE{
       int     m_BSCID;                  
       int     m_SITEID;                                        
       char    m_LOCATIONNAME[50];           
       char    m_USERLABEL[50];              
       int     m_MODULE;
       char    m_RACKLIST[100];
       char    m_LAPDLINKID[100];
    }TR_ZTESITE;                 
    typedef struct R_TRXPOS{
	    int     m_BSCID;
		int     m_SITEID;
		int     m_BTSID;
		int     m_TRXID;
		int     m_TRXTYPE;
		int     m_MODULE;
		int     m_LAPDLINKID;
		int     m_PCMNO;
		int     m_PCMTS; 
        int     m_PCMSUBTS;
		int     m_LOCALTEI;
		int     m_RACKNO;
		int     m_SHELFNO;
		int     m_PANELNO;
		int     m_PANELTYPE;
		char    m_CARLIST[256];   
	 }TR_TRXPOS;
	 typedef struct R_ZTEBTS{
	    int     m_BSCID;
		int     m_SITEID;
		int     m_BTSID;
		char      m_LOCATIONNAME[50];                   
        char       m_USERLABEL[50];                      
        int     m_MODULE;                         
        int     m_CELLTYPE;                       
        int     m_LAC;                            
        int     m_CI;                             
        int     m_NCC;                            
        int     m_BCC;                            
        int     m_FREQBAND;                       
        int     m_BCCHARFCN;
		char       m_CAARFCNLIST[256];                          
 	    }TR_ZTEBTS;
     typedef struct R_PCMTS{
	    int     m_BSCID;   
		int     m_PSITEID;
		int     m_MODULENO;
		int     m_RACKNO;
		int     m_MUNIT;
		int     m_UNIT;
		int     m_PCM;
		int     m_BIETS;
        int     m_DESTPSITEID ;
        int     m_DESTRACKNO ;
        int     m_DESTSHELFNO;
        int     m_DESTPANELNO ;
	    }TR_PCMTS; 
	 typedef struct R_BTRUNKTS{
	    int     m_BSCID;
	    int     m_MUNIT;
	    int     m_UNIT;
	    int     m_PCM;
	    int     m_TS;
	    int     m_TNETHW;       
	    int     m_TNETTS;
	    int     m_SITEID;
	    int     m_BTSID;
	    int     m_TRXID;
		}TR_BTRUNKTS;
	typedef struct R_LAPDBCH{
	    int     m_BSCID;
		int     m_MODULE;
		int     m_CSLOTNO;
		int     m_BCH;
		}TR_LAPDBCH;
	typedef struct R_PCMINFO{
	    int     m_BSCID;
		int     m_PCMCIRCUITID;
		int     m_PHYSITENO;
		int     m_MUNIT;
		int     m_UNIT;
		int     m_PCM; 
        int     m_RACKNO;                          
        int     m_BIEPCM;                        
	   }TR_PCMINFO; 
	 typedef struct R_SITELAPD{
	    int    m_BSCID;
		int    m_BIPPMUNIT;
		int    m_BIPPUNIT;
		int    m_BIPPHW;
		int    m_BIPPTS;
		int    m_TICUNIT;
		int    m_TICPCM;
		int    m_TICTS;
		int    m_MODULE;
		int    m_CSLOTNO;
		int    m_BCH;
		int    m_TEI;
		int    m_SITEID;
		int    m_BTSID;
		int    m_TRXID;
	   }TR_SITELAPD;
/* --------------end by lichunlan for tru-------------   */

     typedef struct R_BSCEquipment{
	    int      m_BSCID;
	    char     m_cBSCVersion[11];
        float    m_Altitude;
	    float    m_Longtitude;
	    char     m_cUserLabel[101];
	    int      m_IsRRBSCExist;
	    int      m_MSCID;
	    int      m_NET;
	    int      m_BSCSPType;
	    int      m_OPC;
	    int      m_BSCSSF;
	    int      m_MSCSPType;
	    int      m_MSCSSF;
        int      m_DPC;
	    int      m_AM;
        int      m_STP18;
        int      m_OfficeID;
	    int      m_LinkSet;
	    int      m_LinkNum;
	    int      m_LECM;
	   }TR_BSCEquipment;
    typedef struct R_Rack{
       int  m_BSCID;
	   int  m_RackNo;
	   int  m_RackType;
	   }TR_Rack;
	typedef struct R_Shelf{
	   int  m_BSCID;
	   int  m_RackNo;
	   int  m_ShelfNo;
	   int  m_Module;
       int  m_ShelfType;
       int  m_ConRack;
	   int  m_ConShelf;
	   int  m_CRack;
	   int  m_CShelf;
	   }TR_Shelf;  
    typedef struct R_Board{
	   int  m_BSCID;
	   int  m_RackNo;
	   int  m_ShelfNo;
	   int  m_SlotNo;
	   int  m_BoardType;
	   int  m_Port;
	   int  m_MUnit;
	   int  m_Unit;
	   int  m_MOCID;
	   }TR_Board;
    typedef struct R_CBoard{
	   int  m_BSCID;
	   int  m_RackNo;
	   int  m_ShelfNo;
	   int  m_SlotNo;
	   int  m_Module;
	   int  m_BoardType;
	   int  m_CommType;
	   int  m_CoSlotNo;
	   int  m_MOCID;
	   }TR_CBoard;
    typedef struct R_HW{
	   int  m_BSCID;
	   int  m_MUnit;
	   int  m_Unit;
	   int  m_HW;
	   int  m_HWSet;
	   int  m_DELAY;
	   }TR_HW;
    typedef struct R_PCM{
       int  m_BSCID;
	   int  m_MUnit;
	   int  m_Unit;
	   int  m_PCM;
	   }TR_PCM;
    typedef struct R_DSP{
	   int  m_BSCID;
	   int  m_MUnit;
	   int  m_Unit;
	   int  m_DSP;
	   int  m_DSPType;
	   }TR_DSP;
    typedef struct R_Module{
	   int  m_BSCID;
	   int  m_ModuleNo;
	   int  m_ModuleType;
	   char    m_cFileID[14];
	   char    m_cFileVer[14];
       char    m_cModuleSibling[9];
	   }TR_Module;
    typedef struct R_MUnit{
	   int  m_BSCID;
	   int  m_MUnit;
	   int  m_MUnitType;
       int  m_R_Module;
	   }TR_MUnit;
    typedef struct R_Unit{
	   int  m_BSCID;
	   int  m_MUnit;
	   int  m_Unit;
	   int  m_UnitType;
	   int  m_LeftPort;
	   int  m_RightPort;
	   int  m_InterConType;
	   int  m_HWSet;
	   int  m_ConMUnit;
	   int  m_ConUnit;
	   int  m_CONSYCK;
	   }TR_Unit;
     typedef struct R_BCH{
	   int  m_BSCID;
	   int  m_MUnit;
	   int  m_CSlotNo;
	   int  m_BCH;
	   int  m_Width;
	   int  m_LinkPort;
	   }TR_BCH;
     typedef struct R_Lapd{
       int  m_BSCID;
	   int  m_CSlotNo;
	   int  m_BCH;
	   int  m_TEI;
	   int  m_Module;
	   int  m_SiteID;
	   int  m_BTSID;
	   int  m_TRXID;
	   }TR_Lapd;
     typedef struct R_485{
	   int  m_BSCID;
	   int  m_MUnit;
	   int  m_CSlotNo;
	   int  m_BusNo;
	   int  m_ADDR;
       int  m_LinkPort;
	   }TR_485;
     typedef struct R_TSCOM{
	   int  m_BSCID ;
	   int  m_CSLOTNO ;
	   int  m_BCH  ;
	   int  m_TNETHW ;
	   int  m_TNETTS  ;
	   int  m_COMMTNETHW ;
	   int  m_COMMTNETTS ;
	   }TR_TSCOM;
/*---------------  BTS  Equipment  ------------ */
	typedef struct T_Site{
	   int   m_BSCID;
	   int   m_PSiteID;
	   float m_Latitude;
	   float m_Longtitude;
	   char  m_cUserLabel[50]; 
	   int   m_ModuleNo;
	   int   m_TopLayer;
	   int   m_LapdFlow;
	   int   m_OAMID;
	   int   m_SiteType;
	   int   m_SynSource;
	   }TT_Site;
	typedef struct T_Rack{
	   int  m_BSCID;
	   int  m_PSiteID;
	   int  m_RackNo;
	   int  m_RackType;
	   int  m_CommNo;
	   }TT_Rack;
	typedef struct T_Shelf{
	   int  m_BSCID;
	   int  m_PSiteID;
	   int  m_RackNo;
	   int  m_ShelfNo;
	   int  m_ShelfType;
	   }TT_Shelf;
	typedef struct T_Panel{
	   int  m_BSCID;
	   int  m_PSiteID;
	   int  m_RackNo;
	   int  m_ShelfNo;
	   int  m_PanelNo;
	   int  m_PanelType;
       int  m_MOCID;
	   }TT_Panel;
	typedef struct T_Board{
	   int  m_BSCID;
	   int  m_PSiteID;
	   int  m_RackNo;
	   int  m_ShelfNo;
	   int  m_PanelNo;
	   int  m_BoardNo;
	   int  m_BoardType;
       int  m_MOCID;
	   }TT_Board;
	typedef struct T_BIEPCM{
	   int  m_BSCID;
	   int  m_PSiteID;
	   int  m_RackNo;
	   int  m_BIEPCM;
	   int  m_UseAs;
       }TT_BIEPCM;
	typedef struct T_DropCom{
	   int  m_BSCID;
	   int  m_PSiteID;
	   int  m_RackNo;
	   int  m_BIEPCMIn;
	   int  m_BIETSIn;
	   int  m_BIESUBTSIn;
	   int  m_BIEPCMOut;
	   int  m_BIETSOut;
	   int  m_BIESUBTSOut;
	   }TT_DropCom;	
	typedef struct T_BIEDropPCM{
	   int  m_BSCID  ;
	   int  m_PSITEID ;
	   int  m_RACKNO ;
	   int  m_BIEPCM ;
	   int  m_RELPSITEID ;
	   int  m_RELRACKNO ;
	   int  m_RELBIEPCM ;
	   }TT_BIEDropPCM;
	typedef struct T_TRXMUL{
	   int  m_BSCID ;
	   int  m_PSITEID;
	   int  m_RACKNO ;
	   int  m_SHELFNO;
	   int  m_PANELNO;
	   int  m_PORTTYPE;
	   int  m_LEVELNUM ;
	   int  m_L1RACKNO ;
	   int  m_L1SHELFNO;
	   int  m_L1PANELNO ;
	   int  m_L2RACKNO ;
	   int  m_L2SHELFNO;
	   int  m_L2PANELNO;
	   }TT_TRXMUL;
//-----------------------------------------------------------
	 typedef struct R_BTrunk{ 
	   int  m_BSCID;            
       int  m_MUNIT;    
       int  m_UNIT;          
       int  m_PCM;      
       int  m_TS;  
       int  m_SUBTS;
       int  m_BIPPUNIT; 
       int  m_BIPPHW;  
       int  m_BIPPTS;
       int  m_BIPPSUBTS ;
       int  m_TNETHW ;
       int  m_TNETTS ;
       int  m_TNETSUBTS;
       int  m_KIND ;
       int  m_SITEID;
       int  m_BTSID ;
       int  m_TRXID;
       int  m_TN  ; 
	} TR_BTrunk;
	typedef struct R_TCPool{  
	   int  m_BSCID ; 
	   int  m_TCPPMUNIT ; 
	   int  m_TCPPUNIT ; 
 	   int  m_TCPPHW ; 
 	   int  m_TCPPTS ; 
 	   int  m_UNIT; 
 	   int  m_DSP  ; 
 	   int  m_TNETHW ; 
 	   int  m_TNETTS ; 
 	   int  m_TNETSUBTS; 
	}TR_TCPool;
	typedef struct R_ATrunk{  
	   int  m_BSCID ; 
	   int  m_MUNIT ; 
	   int  m_UNIT ; 
	   int  m_PCM ; 
	   int  m_TS ;