📄 cmgetdb.pc

📁 李刚请赶快放开我的权限我上载的源码都是很精湛的,请查阅,qing请加我 li_xue_ming@msn.com必要的话可以和我在线沟通
💻 PC
📖 第 1 页 / 共 5 页
字号:
		
		//6
		v_LAPDphysiteid=tR_BPcm.m_PhySiteId;
		v_LAPDbierack=tR_BPcm.m_BieRack;
		v_LAPDbiepcm=tR_BPcm.m_BiePcm;
		v_LAPDticts=tRR_BsCom_Lapd.m_TicTs;
		v_LAPDbiesubts=(255-tRR_Lapd.m_Tei);



		////
		
		

	EXEC SQL WHENEVER NOT FOUND DO break;	
	do{
		if(tRBieCom[0].m_DestPSiteId!=v_LAPDphysiteid )
		{
		   if( m_BtsId == 0 && m_TrxId == 0 )
		   {
		    	EXEC SQL SELECT BIEPCMOUT,BIETSOUT,BIESUBTSOUT
				INTO :tRDropCom[0]
				FROM T_DROPCOM		 
				WHERE BSCID =:m_InPut[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCMIN =:v_LAPDbiepcm AND BIETSIN =:v_LAPDticts AND BIESUBTSIN =:v_LAPDbiesubts;
			
			PrintMsg((PCHAR)"BIEPCMOUT_%d=%d,BIETSOUT_%d=%d,BIESUBTSOUT_%d=%d\n",(++linktype4),tRDropCom[0].m_BiePcmOut,(++linktype4),tRDropCom[0].m_BieTsOut,(++linktype4),tRDropCom[0].m_BieSubTsOut);
			str.Format((PCHAR)"BIEPCMOUT_%d=%d,BIETSOUT_%d=%d,BIESUBTSOUT_%d=%d\n",(++linktype4),tRDropCom[0].m_BiePcmOut,(++linktype4),tRDropCom[0].m_BieTsOut,(++linktype4),tRDropCom[0].m_BieSubTsOut);
			pfFile->Write(str, str.GetLength());

			v_LAPDbiepcm = tRDropCom[0].m_BiePcmOut;			
			EXEC SQL SELECT RELPSITEID,RELRACKNO,RELBIEPCM
				INTO :tDropPcm[0]
				FROM T_BIEDROPPCM	  
				WHERE BSCID = :m_InPut[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCM =:tRDropCom[0].m_BiePcmOut;
			//7
		   PrintMsg((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype4),tDropPcm[0].m_RelPSiteid,(++linktype4),tDropPcm[0].m_RelRackNo,(++linktype4),tDropPcm[0].m_RelBiePcm);	
			str.Format((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype4),tDropPcm[0].m_RelPSiteid,(++linktype4),tDropPcm[0].m_RelRackNo,(++linktype4),tDropPcm[0].m_RelBiePcm);	
			pfFile->Write(str, str.GetLength());
 
     		}
	    	else
		   {
		    			
			EXEC SQL SELECT RELPSITEID,RELRACKNO,RELBIEPCM
				INTO :tDropPcm[0]
				FROM T_BIEDROPPCM	  
				WHERE BSCID = :m_InPut[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCM =:v_LAPDbiepcm;
			
			PrintMsg((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype4),tDropPcm[0].m_RelPSiteid,(++linktype4),tDropPcm[0].m_RelRackNo,(++linktype4),tDropPcm[0].m_RelBiePcm);	
			str.Format((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype4),tDropPcm[0].m_RelPSiteid,(++linktype4),tDropPcm[0].m_RelRackNo,(++linktype4),tDropPcm[0].m_RelBiePcm);	
		   	pfFile->Write(str, str.GetLength());
		   }

		   v_LAPDphysiteid=tDropPcm[0].m_RelPSiteid;
		   v_LAPDbierack=tDropPcm[0].m_RelRackNo;
		   v_LAPDbiepcm=tDropPcm[0].m_RelBiePcm;		
		   v_LAPDticts=tRDropCom[0].m_BieTsOut;
		   v_LAPDbiesubts=tRDropCom[0].m_BieSubTsOut;
        }
	}while(v_LAPDphysiteid!=tRBieCom[0].m_DestPSiteId);
  } 
    PrintMsg((PCHAR)"LINKTYPE=%d\n",linktype4);
	str.Format((PCHAR)"LINKTYPE=%d\n",linktype4);
	pfFile->Write(str, str.GetLength());
	linktype4=0;
	PrintMsg((PCHAR)"\n");
    EXEC SQL CLOSE cur;
 	return  sqlca.sqlcode;

notfoundLAPD4:
	PrintMsg((PCHAR)"LINKTYPE=%d\n",linktype4);
	str.Format((PCHAR)"LINKTYPE=%d\n",linktype4);
	pfFile->Write(str, str.GetLength());
	linktype4=0;
	PrintMsg((PCHAR)"\n");
	EXEC SQL CLOSE cur;
	return sqlca.sqlcode;
 
}

/********************************************************************
*函数名称:  ReadLapdFromDataBase2() 
*函数功能:  显示LAPD接续关系（包括带级链情况）
*输入参数:  BSCID、SITEID
*输出参数:  
*实现算法:  
*作者/日期:  /2001-02-20
*修改记录: 
********************************************************************/


CReadCircuit::ReadLapdFromDataBase2( WORD16 m_BscId,WORD16 m_SiteId)
{
       int count;

    	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",m_BscId);
        str.Format((PCHAR)"BSCID=%d\n",m_BscId);
        pfFile->Write(str, str.GetLength());



	EXEC SQL BEGIN DECLARE SECTION;
		char * RR_Lapd2 ="SELECT BTSID,TRXID,INSTANCEID,CSLOTNO,BCH,TEI FROM R_LAPD WHERE BSCID=:para0 AND SITEID = :para1 ";
		int linktype2;
		int m_Temp2;
	EXEC SQL END DECLARE SECTION;

	EXEC SQL WHENEVER SQLERROR DO SqlError();

	memset(m_InPut2,0,sizeof(m_InPut2));

	m_InPut2[0] = m_BscId;
	m_InPut2[1] = m_SiteId;
	linktype2=0;
	count=0;

	EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
	EXEC SQL PREPARE T FROM :RR_Lapd2;
	EXEC SQL DECLARE cur2 CURSOR FOR T; 
	EXEC SQL EXECUTE T USING :m_InPut2[0],:m_InPut2[1];
	EXEC SQL OPEN cur2;
	
	
	//第1重循环

	EXEC SQL WHENEVER NOT FOUND DO break;
	for(; ;)
	{
	   //1
		EXEC SQL FETCH cur2 INTO :tRR_Lapd2;	
		
 
		PrintMsg((PCHAR)"\n[LAPD_%d]\nsiteid = %d,btsid = %d, trxid= %d, \nLAPDBOARD:CSlotNo = %d,BCH=%d,TEI=%d,",(++count),m_SiteId,tRR_Lapd2.m_btsid,tRR_Lapd2.m_trxid,tRR_Lapd2.m_CSlot,tRR_Lapd2.m_Bch,tRR_Lapd2.m_Tei);
		str.Format((PCHAR)"\n[LAPD_%d]\nsiteid = %d,btsid = %d, trxid= %d, \nLAPDBOARD:CSlotNo = %d,BCH=%d,TEI=%d,",(count),m_SiteId,tRR_Lapd2.m_btsid,tRR_Lapd2.m_trxid,tRR_Lapd2.m_CSlot,tRR_Lapd2.m_Bch,tRR_Lapd2.m_Tei);
		pfFile->Write(str, str.GetLength());

		//2
		//EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT PARENTINSTANCEID 
			INTO :m_Temp2		   
			FROM MOINFO   
			WHERE INSTANCEID = :tRR_Lapd2.m_Instanceid;
		/*PrintMsg((PCHAR)"InstanceId = %d\n",m_Temp2);
		str.Format((PCHAR)"InstanceId = %d\n",m_Temp2);
		pfFile->Write(str, str.GetLength());*/

		//3
		//EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT RACKNO,SHELFNO 
			INTO :tRR_Board
			FROM R_CBOARD	 
			WHERE INSTANCEID = :m_Temp2;
		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 WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT BIPPMUNIT,BIPPUNIT,BIPPHW,BIPPTS,FARHW,FARTS,TICUNIT,TICPCM,TICTS
			INTO :tRR_BsCom_Lapd
			FROM R_BSCOM_LAPD	  
			WHERE BSCID=:m_InPut2[0] AND RACKNO =:tRR_Board.m_RackNo AND SHELFNO = :tRR_Board.m_ShelfNo AND CSLOTNO = :tRR_Lapd2.m_CSlot AND BCH = :tRR_Lapd2.m_Bch;
		PrintMsg((PCHAR)"BIPPBOARD which LAPD go through:BIPPMUNIT=%d,BIPPUNIT=%d,BIPPHW=%d,BIPPTS=%d,\nConnection between BIPP and TIC belong to ABIS:FARHW=%d,FARTS=%d,\nTIC: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 through:BIPPMUNIT=%d,BIPPUNIT=%d,BIPPHW=%d,BIPPTS=%d,\nConnection between BIPP and TIC belong to ABIS:FARHW=%d,FARTS=%d,\nTIC: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 WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT PHYSITENO,RACKNO,BIEPCM
			INTO :tR_BPcm
			FROM R_BPCM		   
			WHERE BSCID=:m_InPut2[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());


		v_LAPDphysiteid=tR_BPcm.m_PhySiteId;
		v_LAPDbierack=tR_BPcm.m_BieRack;
		v_LAPDbiepcm=tR_BPcm.m_BiePcm;
		v_LAPDticts=tRR_BsCom_Lapd.m_TicTs;
		v_LAPDbiesubts=(255-tRR_Lapd2.m_Tei);


	EXEC SQL WHENEVER NOT FOUND DO break;
	do{
	     //6
		if(tRBieCom[0].m_DestPSiteId!=v_LAPDphysiteid )
		{
		    //EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
			if(tRR_Lapd2.m_btsid == 0 && tRR_Lapd2.m_trxid == 0 )
		  {
			EXEC SQL SELECT BIEPCMOUT,BIETSOUT,BIESUBTSOUT
				INTO :tRDropCom[0]
				FROM T_DROPCOM		 
				WHERE BSCID =:m_InPut2[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCMIN =:v_LAPDbiepcm AND BIETSIN =:v_LAPDticts AND BIESUBTSIN =:v_LAPDbiesubts;
			PrintMsg((PCHAR)"BIEPCMOUT_%d=%d,BIETSOUT_%d=%d,BIESUBTSOUT_%d=%d\n",(++linktype2),tRDropCom[0].m_BiePcmOut,(++linktype2),tRDropCom[0].m_BieTsOut,(++linktype2),tRDropCom[0].m_BieSubTsOut);
			str.Format((PCHAR)"BIEPCMOUT_%d=%d,BIETSOUT_%d=%d,BIESUBTSOUT_%d=%d\n",(++linktype2),tRDropCom[0].m_BiePcmOut,(++linktype2),tRDropCom[0].m_BieTsOut,(++linktype2),tRDropCom[0].m_BieSubTsOut);
			pfFile->Write(str, str.GetLength());

			//7
			v_LAPDbiepcm = tRDropCom[0].m_BiePcmOut;
			//EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;			
			EXEC SQL SELECT RELPSITEID,RELRACKNO,RELBIEPCM
				INTO :tDropPcm[0]
				FROM T_BIEDROPPCM	  
				WHERE BSCID = :m_InPut2[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCM =:tRDropCom[0].m_BiePcmOut;
			PrintMsg((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype2),tDropPcm[0].m_RelPSiteid,(++linktype2),tDropPcm[0].m_RelRackNo,(++linktype2),tDropPcm[0].m_RelBiePcm);	
			str.Format((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype2),tDropPcm[0].m_RelPSiteid,(++linktype2),tDropPcm[0].m_RelRackNo,(++linktype2),tDropPcm[0].m_RelBiePcm);	
		   	pfFile->Write(str, str.GetLength());
		   
		   }

		   else
		   {
		   EXEC SQL SELECT RELPSITEID,RELRACKNO,RELBIEPCM
				INTO :tDropPcm[0]
				FROM T_BIEDROPPCM	  
				WHERE BSCID = :m_InPut2[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCM =:v_LAPDbiepcm;
			PrintMsg((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype2),tDropPcm[0].m_RelPSiteid,(++linktype2),tDropPcm[0].m_RelRackNo,(++linktype2),tDropPcm[0].m_RelBiePcm);
			str.Format((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype2),tDropPcm[0].m_RelPSiteid,(++linktype2),tDropPcm[0].m_RelRackNo,(++linktype2),tDropPcm[0].m_RelBiePcm);
		   	pfFile->Write(str, str.GetLength());
		   }

		v_LAPDphysiteid=tDropPcm[0].m_RelPSiteid;
		v_LAPDbierack=tDropPcm[0].m_RelRackNo;
		v_LAPDbiepcm=tDropPcm[0].m_RelBiePcm;		
		v_LAPDticts=tRDropCom[0].m_BieTsOut;
		v_LAPDbiesubts=tRDropCom[0].m_BieSubTsOut;
	  }
	}while(v_LAPDphysiteid!=tRBieCom[0].m_DestPSiteId);
   
    PrintMsg((PCHAR)"LINKTYPE=%d\n",linktype2);
	str.Format((PCHAR)"LINKTYPE=%d\n",linktype2);
	pfFile->Write(str, str.GetLength());
	linktype2 = 0;
   
   }
    EXEC SQL CLOSE cur2;
 	return  sqlca.sqlcode;

notfoundLAPD:
	PrintMsg((PCHAR)"LINKTYPE=%d\n",linktype2);
	str.Format((PCHAR)"LINKTYPE=%d\n",linktype2);
	pfFile->Write(str, str.GetLength());
        linktype2 = 0;
	EXEC SQL CLOSE cur2;
	return sqlca.sqlcode;
 
}

/********************************************************************
*函数名称:  ReadLapdFromDataBase3() 
*函数功能:  显示LAPD接续关系（包括带级链情况）
*输入参数:  BSCID、SITEID、BTSID
*输出参数:  
*实现算法:  
*作者/日期:  /2001-02-20
*修改记录: 
********************************************************************/


CReadCircuit::ReadLapdFromDataBase3(WORD16 m_BscId,WORD16 m_SiteId,WORD16 m_BtsId)
{
    int count;

    	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",m_BscId);
        str.Format((PCHAR)"BSCID=%d\n",m_BscId);
        pfFile->Write(str, str.GetLength());

    EXEC SQL BEGIN DECLARE SECTION;
		char * RR_Lapd3 ="SELECT TRXID,INSTANCEID,CSLOTNO,BCH,TEI FROM R_LAPD WHERE BSCID=:para0 AND SITEID = :para1 AND BTSID = :para2";
		int linktype3;
		int m_Temp3;
	EXEC SQL END DECLARE SECTION;

	EXEC SQL WHENEVER SQLERROR DO SqlError();

	memset(m_InPut3,0,sizeof(m_InPut3));

	m_InPut3[0] = m_BscId;
	m_InPut3[1] = m_SiteId;
	m_InPut3[2] = m_BtsId;
	linktype3=0;
	count=0;

	EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
	EXEC SQL PREPARE G FROM :RR_Lapd3;
	EXEC SQL DECLARE cur3 CURSOR FOR G; 
	EXEC SQL EXECUTE G USING :m_InPut3[0],:m_InPut3[1], :m_InPut3[2];
	EXEC SQL OPEN cur3;
	
	
	//第1重循环

	EXEC SQL WHENEVER NOT FOUND DO break;
	for(; ;)
	{
	   //1
		EXEC SQL FETCH cur3 INTO :tRR_Lapd3;	 
		PrintMsg((PCHAR)"\n[LAPD_%d]\nsiteid = %d,btsid = %d, trxid= %d, \nLAPDBOARD:CSlotNo = %d,BCH=%d,TEI=%d,",(++count),m_SiteId,m_BtsId,tRR_Lapd3.m_trxid,tRR_Lapd3.m_CSlot,tRR_Lapd3.m_Bch,tRR_Lapd3.m_Tei);
		str.Format((PCHAR)"\n[LAPD_%d]\nsiteid = %d,btsid = %d, trxid= %d, \nLAPDBOARD:CSlotNo = %d,BCH=%d,TEI=%d,",(count),m_SiteId,m_BtsId,tRR_Lapd3.m_trxid,tRR_Lapd3.m_CSlot,tRR_Lapd3.m_Bch,tRR_Lapd3.m_Tei);
		pfFile->Write(str, str.GetLength());

		//2
		//EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT PARENTINSTANCEID 
			INTO :m_Temp3		   
			FROM MOINFO   
			WHERE INSTANCEID = :tRR_Lapd3.m_Instanceid;
		/*PrintMsg((PCHAR)"InstanceId = %d\n",m_Temp3);
		str.Format((PCHAR)"InstanceId = %d\n",m_Temp3);
		pfFile->Write(str, str.GetLength());*/

		//3
		//EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT RACKNO,SHELFNO 
			INTO :tRR_Board
			FROM R_CBOARD	 
			WHERE INSTANCEID = :m_Temp3;
		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 WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT BIPPMUNIT,BIPPUNIT,BIPPHW,BIPPTS,FARHW,FARTS,TICUNIT,TICPCM,TICTS
			INTO :tRR_BsCom_Lapd
			FROM R_BSCOM_LAPD	  
			WHERE BSCID=:m_InPut3[0] AND RACKNO =:tRR_Board.m_RackNo AND SHELFNO = :tRR_Board.m_ShelfNo AND CSLOTNO = :tRR_Lapd3.m_CSlot AND BCH = :tRR_Lapd3.m_Bch;
		PrintMsg((PCHAR)"BIPPBOARD which LAPD go through:BIPPMUNIT=%d,BIPPUNIT=%d,BIPPHW=%d,BIPPTS=%d,\nConnection between BIPP and TIC: FARHW=%d,FARTS=%d,\nTIC: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 through:BIPPMUNIT=%d,BIPPUNIT=%d,BIPPHW=%d,BIPPTS=%d,\nConnection between BIPP and TIC:FARHW=%d,FARTS=%d,\nTIC: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 WHENEVER NOT FOUND GOTO notfoundLAPD;
		EXEC SQL SELECT PHYSITENO,RACKNO,BIEPCM
			INTO :tR_BPcm
			FROM R_BPCM		   
			WHERE BSCID=:m_InPut3[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());


		v_LAPDphysiteid=tR_BPcm.m_PhySiteId;
		v_LAPDbierack=tR_BPcm.m_BieRack;
		v_LAPDbiepcm=tR_BPcm.m_BiePcm;
		v_LAPDticts=tRR_BsCom_Lapd.m_TicTs;
		v_LAPDbiesubts=(255-tRR_Lapd3.m_Tei);

	EXEC SQL WHENEVER NOT FOUND DO break;
	do{
	     //6
		if(tRBieCom[0].m_DestPSiteId!=v_LAPDphysiteid )
		{
		    if(m_BtsId == 0 && tRR_Lapd3.m_trxid == 0 )
			{
		    //EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;
			EXEC SQL SELECT BIEPCMOUT,BIETSOUT,BIESUBTSOUT
				INTO :tRDropCom[0]
				FROM T_DropCom		 
				WHERE BSCID =:m_InPut3[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCMIN =:v_LAPDbiepcm AND BIETSIN =:v_LAPDticts AND BIESUBTSIN =:v_LAPDbiesubts;
			PrintMsg((PCHAR)"BIEPCMOUT_%d=%d,BIETSOUT_%d=%d,BIESUBTSOUT_%d=%d\n",(++linktype3),tRDropCom[0].m_BiePcmOut,(++linktype3),tRDropCom[0].m_BieTsOut,(++linktype3),tRDropCom[0].m_BieSubTsOut);	
			str.Format((PCHAR)"BIEPCMOUT_%d=%d,BIETSOUT_%d=%d,BIESUBTSOUT_%d=%d\n",(++linktype3),tRDropCom[0].m_BiePcmOut,(++linktype3),tRDropCom[0].m_BieTsOut,(++linktype3),tRDropCom[0].m_BieSubTsOut);	
			pfFile->Write(str, str.GetLength());
			
			//7
			v_LAPDbiepcm = tRDropCom[0].m_BiePcmOut;
			//EXEC SQL WHENEVER NOT FOUND GOTO notfoundLAPD;			
			EXEC SQL SELECT RELPSITEID,RELRACKNO,RELBIEPCM
				INTO :tDropPcm[0]
				FROM T_BIEDROPPCM	  
				WHERE BSCID = :m_InPut3[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCM =:v_LAPDbiepcm;
			PrintMsg((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype3),tDropPcm[0].m_RelPSiteid,(++linktype3),tDropPcm[0].m_RelRackNo,(++linktype3),tDropPcm[0].m_RelBiePcm);	
			str.Format((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype3),tDropPcm[0].m_RelPSiteid,(++linktype3),tDropPcm[0].m_RelRackNo,(++linktype3),tDropPcm[0].m_RelBiePcm);	
			pfFile->Write(str, str.GetLength());
			}
			else
			{
			EXEC SQL SELECT RELPSITEID,RELRACKNO,RELBIEPCM
				INTO :tDropPcm[0]
				FROM T_BIEDROPPCM	  
				WHERE BSCID = :m_InPut3[0] AND PSITEID =:v_LAPDphysiteid AND RACKNO =:v_LAPDbierack AND BIEPCM =:v_LAPDbiepcm;
			PrintMsg((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype3),tDropPcm[0].m_RelPSiteid,(++linktype3),tDropPcm[0].m_RelRackNo,(++linktype3),tDropPcm[0].m_RelBiePcm);	
			str.Format((PCHAR)"RELPSITEID_%d=%d,RELRACKNO_%d=%d,RELBIEPCM_%d=%d\n",(++linktype3),tDropPcm[0].m_RelPSiteid,(++linktype3),tDropPcm[0].m_RelRackNo,(++linktype3),tDropPcm[0].m_RelBiePcm);	
			 pfFile->Write(str, str.GetLength());
			}



		v_LAPDphysiteid=tDropPcm[0].m_RelPSiteid;
		v_LAPDbierack=tDropPcm[0].m_RelRackNo;
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -