📄 cmgetdb.pc
字号:
int m_TcppMUnit;
int m_TcppUnit;
int m_TcppHw;
int m_TcppTs;
}TATsCom;
typedef struct TagAFSOM{
int m_FARSMPPMUNIT;
int m_FARSMPPUNIT;
int m_FARSMPPPCM;
int m_FARSMPPTS;
int m_FARSMPPSUBTS;
int m_FSPPHW1;
int m_FSPPTS1;
int m_FSPPHW2;
int m_FSPPTS2;
}TFSOM;
typedef struct TagANSOM{
int m_NEARSMPPMUNIT;
int m_NEARSMPPUNIT;
int m_NSPPHW;
int m_NSPPTS;
}TNSOM;
typedef struct TagATCCOM{
int m_Unit;
int m_DSP;
}TATCCOM;
typedef struct TagTsCom{
int m_CSlotNo;
int m_Bch;
int m_CommTNetHw;
int m_CommTNetTs;
}TTsCom;
typedef struct TagBTrunk7{
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;
}TBTrunk7;
typedef struct TagBTrunk6{
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;
}TBTrunk6;
typedef struct TagBTrunk5{
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;
}TBTrunk5;
typedef struct TagBTrunk4{
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;
}TBTrunk4;
typedef struct TagBTrunk3{
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;
}TBTrunk3;
typedef struct TagBTrunk2{
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;
}TBTrunk2;
typedef struct TagBTrunk1{
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;
}TBTrunk1;
TBTrunk7 tBTrunk7;
TBTrunk6 tBTrunk6;
TBTrunk5 tBTrunk5;
TBTrunk4 tBTrunk4;
TBTrunk3 tBTrunk3;
TBTrunk2 tBTrunk2;
TBTrunk1 tBTrunk1;
TTsCom tTsCom;
TATsCom tATsCom;
TATrunk tATrunk;
TATrunk1 tATrunk1;
TATrunk5 tATrunk5;
TATCCOM tATCCOM;
TFSOM tFSOM;
TNSOM tNSOM;
TBscBoard tBscBoard;
TBscBoard3 tBscBoard3;
TBscBoard2 tBscBoard2;
TBscBoard1 tBscBoard1;
taKBscBoard1 tAKBscBoard1;
TSHELF1 tSHELF1;
TABscBoard1 tABscBoard1;
TRR_Lapd tRR_Lapd;
TRR_Lapd2 tRR_Lapd2;
TRR_Lapd3 tRR_Lapd3;
TRR_Lapd1 tRR_Lapd1;
TRR_Board tRR_Board;
TRR_BsCom_Lapd tRR_BsCom_Lapd;
TR_BPcm tR_BPcm;
TRBieCom tRBieCom[10];
TRDropCom tRDropCom[10];
TDropPcm tDropPcm[10];
TABISFSCOM tABISFSCOM;
TABISNSCOM tABISNSCOM;
TABISBPCM tABISBPCM;
TABISBIECOM tABISBIECOM;
TABISDROPCOM tABISDROPCOM;
TABISBIEDROPPCM tABISBIEDROPPCM;
TNN7PCM tNN7PCM;
TNATRUNK tNATRUNK;
TNN7LINK tNN7LINK;
THDLCPort tHDLCPort;
THDLCBCH tHDLCBCH;
THDLCTscom tHDLCTscom;
THDLCTcpool tHDLCTcpool;
THDLCNscom tHDLCNscom;
THDLCFscom tHDLCFscom;
/*--------------------------------------------------*/
TR_TRXPOS tR_TRXPOS;
TR_SITELAPD tR_SITELAPD;
TR_PCMINFO tR_PCMINFO;
TR_LAPDBCH tR_LAPDBCH;
TR_BTRUNKTS tR_BTRUNKTS;
TR_PCMTS tR_PCMTS;
TR_ZTEBTS tR_ZTEBTS;
TR_ZTESITE tR_ZTESITE;
TR_ZTELAPDLINK tR_ZTELAPDLINK;
TR_BSCOM_Lapd tR_BSCOM_Lapd;
TR_BSCOM_MPMP tR_BSCOM_MPMP;
TT_BIECOM tT_BIECOM;
TR_FSCom tR_FSCom;
TR_NSCom tR_NSCom;
TR_N7Link tR_N7Link;
TR_BSCEquipment tR_BSCEquipment;
TR_Rack tR_Rack;
TR_Shelf tR_Shelf;
TR_Board tR_Board;
TR_CBoard tR_CBoard;
TR_HW tR_HW;
TR_PCM tR_PCM;
TR_DSP tR_DSP;
TR_Module tR_Module;
TR_MUnit tR_MUnit;
TR_Unit tR_Unit;
TR_BCH tR_BCH;
TR_Lapd tR_Lapd;
TR_485 tR_485;
TR_BTrunk tR_BTrunk;
TR_TCPool tR_TCPool;
TR_ATrunk tR_ATrunk;
TR_ATSCom tR_ATSCom;
TT_Site tT_Site;
TT_Rack tT_Rack;
TT_Shelf tT_Shelf;
TT_Panel tT_Panel;
TT_Board tT_Board;
TT_BIEPCM tT_BIEPCM;
TT_DropCom tT_DropCom;
TR_TSCOM tR_TSCOM;
TT_BIEDropPCM tT_BIEDropPCM;
TT_TRXMUL tT_TRXMUL;
EXEC SQL END DECLARE SECTION;
/********************************************************************
*函数名称: CReadCircuit()
*函数功能: 构造函数
*输入参数: 从配置文件中读出用户名及口令
*输出参数:
*实现算法:
*作者/日期: /2001-02-20
*修改记录:
********************************************************************/
CReadCircuit::CReadCircuit(CHAR* pUid,CHAR* pPassWd)
{
EXEC SQL WHENEVER SQLERROR DO printf("error\n");
EXEC SQL BEGIN DECLARE SECTION;
char uid[40];
char pass[40];
EXEC SQL END DECLARE SECTION;
strcpy(uid,pUid);
strcpy(pass,pPassWd);
EXEC SQL CONNECT :uid
IDENTIFIED BY :pass;
}
/********************************************************************
*函数名称: ~CReadCircuit()
*函数功能: 析构函数
*输入参数:
*输出参数:
*实现算法:
*作者/日期: /2001-02-20
*修改记录:
********************************************************************/
CReadCircuit::~CReadCircuit()
{
EXEC SQL COMMIT WORK RELEASE;
}
/********************************************************************
*函数名称: SqlError()
*函数功能: SQL语句出错的处理
*输入参数:
*输出参数:
*实现算法:
*作者/日期: /2001-02-20
*修改记录:
********************************************************************/
void CReadCircuit::SqlError()
{
EXEC SQL WHENEVER SQLERROR CONTINUE ;
}
/********************************************************************
*函数名称: ReadLapdFromDataBase4()
*函数功能: 显示LAPD接续关系（包括带级链情况）
*输入参数: BSCID、SITEID、BTSID、TRXID
*输出参数:
*实现算法:
*作者/日期: /2001-02-20
*修改记录:
********************************************************************/
CReadCircuit::ReadLapdFromDataBase4( WORD16 m_BscId,WORD16 m_SiteId,WORD16 m_BtsId,WORD16 m_TrxId)
{
PrintMsg((PCHAR)"[COMM]\n");
str.Format((PCHAR)"[COMM]\n");
pfFile->Write(str, str.GetLength());
PrintMsg((PCHAR)"TYPE=LAPD,");
str.Format((PCHAR)"TYPE=LAPD,");
pfFile->Write(str, str.GetLength());
PrintMsg((PCHAR)"BSCID=%d\n\n",m_BscId);
str.Format((PCHAR)"BSCID=%d\n\n",m_BscId);
pfFile->Write(str, str.GetLength());
PrintMsg((PCHAR)"[LAPD]\n");
str.Format((PCHAR)"[LAPD]\n");
pfFile->Write(str, str.GetLength());
PrintMsg((PCHAR)" SITEID = %d,BTSID=%d,TRXID=%d\n",m_SiteId,m_BtsId,m_TrxId);
str.Format((PCHAR)"SITEID = %d,BTSID=%d,TRXID=%d\n",m_SiteId,m_BtsId,m_TrxId);
pfFile->Write(str, str.GetLength());
//int count;
EXEC SQL BEGIN DECLARE SECTION;
char* RR_Lapd ="SELECT INSTANCEID,CSLOTNO,BCH,TEI FROM R_LAPD WHERE BSCID=:para0 AND SITEID = :para1 AND BTSID = :para2 AND TRXID = :para3";
int linktype4;
int m_Temp;
EXEC SQL END DECLARE SECTION;
EXEC SQL WHENEVER SQLERROR DO SqlError();
memset(m_InPut,0,sizeof(m_InPut));
m_InPut[0] = m_BscId;
m_InPut[1] = m_SiteId;
m_InPut[2] = m_BtsId;
m_InPut[3] = m_TrxId;
linktype4=0;
EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD4;
EXEC SQL PREPARE S FROM :RR_Lapd;
EXEC SQL DECLARE cur CURSOR FOR S;
EXEC SQL EXECUTE S USING :m_InPut[0],:m_InPut[1],:m_InPut[2],:m_InPut[3];
EXEC SQL OPEN cur;
//new function
EXEC SQL WHENEVER NOT FOUND DO break;
for(; ;)
{
//1
EXEC SQL FETCH cur INTO :tRR_Lapd;
PrintMsg((PCHAR)"LAPDBOARD:CSlotNo = %d,BCH=%d,TEI=%d",tRR_Lapd.m_CSlot,tRR_Lapd.m_Bch,tRR_Lapd.m_Tei);
str.Format((PCHAR)"LAPDBOARD:CSlotNo = %d,BCH=%d,TEI=%d",tRR_Lapd.m_CSlot,tRR_Lapd.m_Bch,tRR_Lapd.m_Tei);
pfFile->Write(str, str.GetLength());
//2
EXEC SQL SELECT PARENTINSTANCEID
INTO :m_Temp
FROM MOINFO
WHERE INSTANCEID = :tRR_Lapd.m_Instanceid;
/*PrintMsg((PCHAR)"LAPDBOARD:parentInstanceId = %d\n",m_Temp);
str.Format((PCHAR)"LAPDBOARD:parentInstanceId = %d\n",m_Temp);
pfFile->Write(str, str.GetLength());*/
//3
EXEC SQL SELECT RACKNO,SHELFNO
INTO :tRR_Board
FROM R_CBOARD
WHERE INSTANCEID = :m_Temp;
PrintMsg((PCHAR)",RackNo = %d,ShelfNo=%d\n",tRR_Board.m_RackNo,tRR_Board.m_ShelfNo);
str.Format((PCHAR)",RackNo = %d,ShelfNo=%d\n",tRR_Board.m_RackNo,tRR_Board.m_ShelfNo);
pfFile->Write(str, str.GetLength());
//4
EXEC SQL SELECT BIPPMUNIT,BIPPUNIT,BIPPHW,BIPPTS,FARHW,FARTS,TICUNIT,TICPCM,TICTS
INTO :tRR_BsCom_Lapd
FROM R_BSCOM_LAPD
WHERE BSCID=:m_InPut[0] AND RACKNO =:tRR_Board.m_RackNo AND SHELFNO = :tRR_Board.m_ShelfNo AND CSLOTNO = :tRR_Lapd.m_CSlot AND BCH = :tRR_Lapd.m_Bch;
PrintMsg((PCHAR)"BIPPBOARD which lapd go though: BIPPMUNIT=%d,BIPPUNIT=%d,BIPPHW=%d,BIPPTS=%d,\nConnection between BIPP and TIC belong to ABIS: FARHW=%d,FARTS=%d,\nTIC belong to ABIS: TICUNIT=%d,TICPCM=%d,TICTS=%d\n",tRR_BsCom_Lapd.m_BippMUnit,tRR_BsCom_Lapd.m_BippUnit,tRR_BsCom_Lapd.m_BippHw,tRR_BsCom_Lapd.m_BippTs,tRR_BsCom_Lapd.m_FarHw,tRR_BsCom_Lapd.m_FarTs,tRR_BsCom_Lapd.m_TicUnit,tRR_BsCom_Lapd.m_TicPcm,tRR_BsCom_Lapd.m_TicTs);
str.Format((PCHAR)"BIPPBOARD which lapd go though:BIPPMUNIT=%d,BIPPUNIT=%d,BIPPHW=%d,BIPPTS=%d,\nConnection between BIPP and TIC belong to ABIS: FARHW=%d,FARTS=%d,\nTIC belong to ABIS: TICUNIT=%d,TICPCM=%d,TICTS=%d\n",tRR_BsCom_Lapd.m_BippMUnit,tRR_BsCom_Lapd.m_BippUnit,tRR_BsCom_Lapd.m_BippHw,tRR_BsCom_Lapd.m_BippTs,tRR_BsCom_Lapd.m_FarHw,tRR_BsCom_Lapd.m_FarTs,tRR_BsCom_Lapd.m_TicUnit,tRR_BsCom_Lapd.m_TicPcm,tRR_BsCom_Lapd.m_TicTs);
pfFile->Write(str, str.GetLength());
//5
EXEC SQL SELECT PHYSITENO,RACKNO,BIEPCM
INTO :tR_BPcm
FROM R_BPCM
WHERE BSCID=:m_InPut[0] AND MUNIT =: tRR_BsCom_Lapd.m_BippMUnit AND UNIT =: tRR_BsCom_Lapd.m_TicUnit AND PCM =: tRR_BsCom_Lapd.m_TicPcm;
PrintMsg((PCHAR)"BTS: PHYSITENO=%d,RACK=%d,BIEPCM=%d\n",tR_BPcm.m_PhySiteId,tR_BPcm.m_BieRack,tR_BPcm.m_BiePcm);
str.Format((PCHAR)"BTS: PHYSITENO=%d,RACK=%d,BIEPCM=%d\n",tR_BPcm.m_PhySiteId,tR_BPcm.m_BieRack,tR_BPcm.m_BiePcm);
pfFile->Write(str, str.GetLength());
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -