Exemplo n.º 1
0
        /// <summary>
        /// 初始化ATU
        /// </summary>
        private void init_atu()
        {
            atu.Clear();

            int i = 0;
            foreach(var item in m_cellInfo.cellInfo)
            { // 按主小区 逐批取
                double r = ++i / (double)m_cellInfo.cellInfo.Count;
                LogHelper.instance().write("# init atu process:" + r.ToString());
                string sql = @"SELECT [PROJECT_ID] ,[SECTOR_ID] ,[S_RSRP] ,[RS_SINR] ,[NCELL_ID] ,[N_PCI] ,[N_RSRP]
                              FROM [tbATUData2]
                              WHERE SECTOR_ID = '193544-2'";

                sql = sql.Replace("193544-2", item.Key);
                DataTable dt = new DataTable();
                DBHelper.instatnce().get_dataTable(ref dt, sql);

                foreach(DataRow dr in dt.Rows){
                    string PROJECT_ID = dr["PROJECT_ID"].ToString();
                    string SECTOR_ID = dr["SECTOR_ID"].ToString();
                    string S_RSRP = dr["S_RSRP"].ToString();
                    string RS_SINR = dr["RS_SINR"].ToString();
                    string NCELL_ID = dr["NCELL_ID"].ToString();
                    string N_PCI = dr["N_PCI"].ToString();
                    string N_RSRP = dr["N_RSRP"].ToString();

                    if(!atu.ContainsKey(SECTOR_ID))
                    {
                        atu[SECTOR_ID] = new ATU();
                    }
                    if(!atu[SECTOR_ID].nInfo.ContainsKey(NCELL_ID))
                    {
                        atu[SECTOR_ID].nInfo[NCELL_ID] = new ATUMatrix();
                    }

                    atu[SECTOR_ID].PROJECT_ID = int.Parse(PROJECT_ID);
                    atu[SECTOR_ID].S_Sample_CT++;

                    atu[SECTOR_ID].nInfo[NCELL_ID].N_Sample_CT++;

                    double deltRSRP = double.Parse(S_RSRP) - double.Parse(N_RSRP);
                    if(deltRSRP <= 0) { // <= 0
                        atu[SECTOR_ID].nInfo[NCELL_ID].DB_LE_0_CT++;
                    }
                    if(0 < deltRSRP && deltRSRP <= 6) { // <= 0
                        atu[SECTOR_ID].nInfo[NCELL_ID].DB_LE_6_CT++;
                    }
                    if(6 < deltRSRP && deltRSRP <= 10) { // <= 0
                        atu[SECTOR_ID].nInfo[NCELL_ID].DB_LE_10_CT++;
                    }
                }

            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 读取ATU统计信息
        /// </summary>
        private void readATUStatistic()
        {
            atu.Clear();

            int i = 0;
            foreach(var item in m_cellInfo.cellInfo)
            { // 按主小区 逐批取
                double r = ++i / (double)m_cellInfo.cellInfo.Count;
                LogHelper.instance().write("# read atu process:" + r.ToString());
                string sql = @"SELECT [seq],[PROJECT_ID]
                                  ,[SECTOR_ID],[S_EARFCN],[PCI]
                                  ,[NCELL_ID],[N_EARFCN],[N_PCI]
                                  ,[S_SampleCount],[N_SampleCount]
                                  ,[SampleCountBelowZero],[SampleRatioBelowZero]
                                  ,[SampleCountZeroAndSix],[SampleRatioZeroAndSix]
                                  ,[SampleCountSixAndTen],[SampleRatioSixAndTen]
                              FROM [tbATUStatistics]
                              WHERE SECTOR_ID = '193544-2'";

                sql = sql.Replace("193544-2", item.Key);
                DataTable dt = new DataTable();
                DBHelper.instatnce().get_dataTable(ref dt, sql);

                foreach(DataRow dr in dt.Rows){
                    string seq = dr["seq"].ToString();
                    string PROJECT_ID = dr["PROJECT_ID"].ToString();
                    string SECTOR_ID = dr["SECTOR_ID"].ToString();
                    string NCELL_ID = dr["NCELL_ID"].ToString();

                    string S_SampleCount = dr["S_SampleCount"].ToString();
                    string N_SampleCount = dr["N_SampleCount"].ToString();
                    string SampleCountBelowZero = dr["SampleCountBelowZero"].ToString();
                    string SampleRatioBelowZero = dr["SampleRatioBelowZero"].ToString();
                    string SampleCountZeroAndSix = dr["SampleCountZeroAndSix"].ToString();
                    string SampleRatioZeroAndSix = dr["SampleRatioZeroAndSix"].ToString();
                    string SampleCountSixAndTen = dr["SampleCountSixAndTen"].ToString();
                    string SampleRatioSixAndTen = dr["SampleRatioSixAndTen"].ToString();

                    if(!atu.ContainsKey(SECTOR_ID)) {
                        atu[SECTOR_ID] = new ATU();
                    }
                    if(!atu[SECTOR_ID].nInfo.ContainsKey(NCELL_ID)) {
                        atu[SECTOR_ID].nInfo[NCELL_ID] = new ATUMatrix();
                    }

                    atu[SECTOR_ID].PROJECT_ID = int.Parse(PROJECT_ID);
                    atu[SECTOR_ID].S_Sample_CT = int.Parse(S_SampleCount);

                    atu[SECTOR_ID].nInfo[NCELL_ID].N_Sample_CT = int.Parse(N_SampleCount);
                    atu[SECTOR_ID].nInfo[NCELL_ID].DB_LE_0_CT = int.Parse(SampleCountBelowZero);
                    atu[SECTOR_ID].nInfo[NCELL_ID].DB_LE_6_CT = int.Parse(SampleCountZeroAndSix);
                    atu[SECTOR_ID].nInfo[NCELL_ID].DB_LE_10_CT = int.Parse(SampleCountSixAndTen);
                }

            }
        }