Exemplo n.º 1
0
        public int parseS1ModeInterMMECombinedTauSucRate4GFile()
        {
            int line_count = 0;

            FilesToParse.Add(file_to_parse_gz);
            FilesToParse.Add(file_to_parse_kt);

            foreach (string file_to_parse in FilesToParse)
            {
                string nodeName = "", st_time = "";

                if (file_to_parse.Contains("_GZ_"))
                {
                    nodeName = "GZ";
                }
                else if (file_to_parse.Contains("_KT_"))
                {
                    nodeName = "KT";
                }


                char[] delimiterChars = new char[5];

                try
                {
                    if (!File.Exists(file_to_parse))
                    {
                        throw new Exception();
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.ToString());
                    Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e);
                    return(0);
                }

                using (StreamReader sr = File.OpenText(@file_to_parse))
                {
                    String   input;
                    string[] tokens;
                    sr.ReadLine();

                    while ((input = sr.ReadLine()) != null)
                    {
                        delimiterChars[0] = ',';
                        tokens            = input.Split(delimiterChars[0]);
                        st_time           = tokens[1];
                        DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null);

                        S1ModeInterMMECombinedTauSucRate_Model data = new S1ModeInterMMECombinedTauSucRate_Model();
                        data.timesOfInterMmeTauWithSgwChangeAttempt              = Convert.ToInt32(tokens[34]);
                        data.timesOfInterMmeTauWithoutSgwChangeAttempt           = Convert.ToInt32(tokens[35]);
                        data.SuccessfulTimesOfInterMmeTauWithSgwChangeAttempt    = Convert.ToInt32(tokens[36]);
                        data.SuccessfulTimesOfInterMmeTauWithoutSgwChangeAttempt = Convert.ToInt32(tokens[37]);
                        data.resultTime = oDate;
                        data.nodeName   = nodeName;
                        dataList.Add(data);
                        line_count++;
                    }
                    sr.Close();
                }
            }

            string queryString = "";

            foreach (var data in dataList)
            {
                queryString += "INSERT into ps_sgsn_4g_s1_inter_mme_com_tau_suc_rate ( tau_request_times_sgw_change,tau_request_times_sgw_not_change,tau_suc_times_for_eps_non_eps_sgw_change,tau_suc_times_for_eps_non_eps_sgw_not_change,tau_suc_times_for_eps_sms_sgw_change,tau_suc_times_for_eps_sms_sgw_not_change,node_name,vendor,result_time) values ('" + data.timesOfInterMmeTauWithSgwChangeAttempt + "','" + data.timesOfInterMmeTauWithoutSgwChangeAttempt + "',0,0,'" + data.SuccessfulTimesOfInterMmeTauWithSgwChangeAttempt + "','" + data.SuccessfulTimesOfInterMmeTauWithoutSgwChangeAttempt + "','" + data.nodeName + "','" + data.vendor + "','" + data.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');";
            }


            try
            {
                MySqlConnection cn            = DatabaseConnection.CreateConnection();
                MySqlCommand    cmd           = new MySqlCommand(queryString, cn);
                int             inserted_rows = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                DatabaseConnection.CloseConnection();
                Console.WriteLine(ex.ToString());
                Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex);
                return(0);
            }
            DatabaseConnection.CloseConnection();

            return(line_count);
        }
Exemplo n.º 2
0
        public int parseGgsnGiTrafficFile()
        {
            int line_count = 0;

            FilesToParse.Add(file_to_parse_gz);
            FilesToParse.Add(file_to_parse_kt);

            foreach (string file_to_parse in FilesToParse)
            {
                string nodeName = "", st_time = "";

                if (file_to_parse.Contains("_GZ_"))
                {
                    nodeName = "GZ";
                }
                else if (file_to_parse.Contains("_KT_"))
                {
                    nodeName = "KT";
                }


                char[] delimiterChars = new char[5];

                try
                {
                    if (!File.Exists(file_to_parse))
                    {
                        throw new Exception();
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.ToString());
                    Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e);
                    return(0);
                }

                using (StreamReader sr = File.OpenText(@file_to_parse))
                {
                    String   input;
                    string[] tokens;
                    sr.ReadLine();

                    while ((input = sr.ReadLine()) != null)
                    {
                        delimiterChars[0] = ',';
                        tokens            = input.Split(delimiterChars[0]);
                        st_time           = tokens[1];
                        DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null);

                        GGSNGiTraffic_Model data = new GGSNGiTraffic_Model();
                        data.giDataInGB = Convert.ToInt32(tokens[5]);
                        data.resultTime = oDate;
                        data.nodeName   = nodeName;
                        dataList.Add(data);
                        line_count++;
                    }
                    sr.Close();
                }
            }

            string queryString = "";

            foreach (var data in dataList)
            {
                queryString += "INSERT into ps_ggsn_2g_3g_gi_traffic ( zte_gi_data_in_GB,node_name,vendor,result_time) values ('" + data.giDataInGB + "','" + data.nodeName + "','" + data.vendor + "','" + data.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');";
            }


            try
            {
                MySqlConnection cn            = DatabaseConnection.CreateConnection();
                MySqlCommand    cmd           = new MySqlCommand(queryString, cn);
                int             inserted_rows = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                DatabaseConnection.CloseConnection();
                Console.WriteLine(ex.ToString());
                Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex);
                return(0);
            }
            DatabaseConnection.CloseConnection();

            return(line_count);
        }