예제 #1
0
        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                string excelPath = textBox2.Text;
                string sheet     = textBox4.Text.Trim();
                string center    = textBox3.Text.Trim();
                if (string.IsNullOrEmpty(excelPath) || string.IsNullOrEmpty(sheet))
                {
                    return;
                }

                DataTable dt = ExcelManager.ReadExcelToDataTable(excelPath, sheet);
                if (dt.Rows.Count <= 1 || dt.Columns.Count <= 1)
                {
                    Console.WriteLine("None Item Information.");
                    return;
                }
                int outOrin = 0;
                switch (comboBox1.Text)
                {
                case "In":
                    outOrin = 1;
                    break;
                }
                string        defaultPortName = "defaultPortName";
                string        defaultPortID   = "50000";
                List <string> columnNames     = new List <string>()
                {
                    "A653PortName", "DestUDP"
                };

                string[] centerArray = new string[] { "CENTER", "LIB", "LOB", "ROB", "RIB" };

                string[] portNameArray = new string[dt.Rows.Count - 1];
                string[] portIDArray   = new string[dt.Rows.Count - 1];


                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    string columnName = dt.Rows[0][i].ToString().Trim();

                    switch (columnName)
                    {
                    case "A653PortName":
                        for (int j = 1; j < dt.Rows.Count; j++)
                        {
                            string data = dt.Rows[j][i].ToString().Trim();
                            if (string.IsNullOrEmpty(data))
                            {
                                data = defaultPortName;
                            }
                            portNameArray[j - 1] = data;
                        }
                        break;

                    case "DestUDP":
                        for (int j = 1; j < dt.Rows.Count; j++)
                        {
                            string data = dt.Rows[j][i].ToString().Trim();
                            if (string.IsNullOrEmpty(data))
                            {
                                data = defaultPortID;
                            }
                            portIDArray[j - 1] = data;
                        }
                        break;
                    }
                }
                richTextBox1.AppendText(string.Format("name:{0} -> id:{1}\n", portNameArray.Length, portIDArray.Length));

                Dictionary <string, LineData> portInfo = new Dictionary <string, LineData>();
                StringBuilder sb = new StringBuilder();
                sb.Append(string.Format("[{0}]", sheet));
                sb.Append("\n");
                for (int i = 0; i < dt.Rows.Count - 1; i++)
                {
                    string name = portNameArray[i];
                    string id   = portIDArray[i];
                    if (portInfo.ContainsKey(name))
                    {
                        richTextBox1.AppendText(string.Format("sane port name:{0}\n", name));
                        continue;
                    }
                    string centerinfo = center;
                    if (outOrin == 0)
                    {
                        Random rd    = new Random(i);
                        int    index = rd.Next(0, 5);
                        centerinfo = centerArray[index];
                    }
                    LineData line = new LineData(true, id, name, centerinfo, outOrin.ToString(), i);
                    portInfo.Add(name, line);
                    sb.Append(line.ToString());
                    sb.Append("\n");
                }
                sb.Append(string.Format("[END_OF_{0}]", sheet));

                FileInfo info      = new FileInfo(excelPath);
                string   dic       = info.Directory.FullName;
                string   writepath = Path.Combine(dic, string.Format("{0}_config_file_Center.ini", sheet));
                if (File.Exists(writepath))
                {
                    File.Delete(writepath);
                }
                using (StreamWriter sw = new StreamWriter(File.Open(writepath, FileMode.OpenOrCreate, FileAccess.Write)))
                {
                    sw.Write(sb.ToString());
                }

                richTextBox1.AppendText("End.\n");
            }
            catch (Exception error)
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(string.Format("Error:{0}\n", error.Message));
            }
        }
예제 #2
0
        private void button5_Click(object sender, EventArgs e)
        {
            string path = this.textBox5.Text;

            if (string.IsNullOrEmpty(path))
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("文件路径不能为空!");
                return;
            }


            Dictionary <string, List <LineData> > allPortID = new Dictionary <string, List <LineData> >();

            Dictionary <string, List <string> > samePortID = new Dictionary <string, List <string> >();

            allPortID.Clear();
            samePortID.Clear();

            List <LineData> lins = new List <LineData>();

            int start = 0;

            int.TryParse(comboBox2.Text, out start);
            start = start * 1000;
            int lineIndex = 0;

            using (StreamReader sr = new StreamReader(File.Open(path, FileMode.Open, FileAccess.Read)))
            {
                string line = string.Empty;

                while ((line = sr.ReadLine()) != null)
                {
                    lineIndex++;
                    LineData dt = new LineData(false, "", "", "", "", lineIndex);
                    if (line.Contains("#") || !line.Contains("="))
                    {
                        dt = new LineData(false, "", line, "", "", lineIndex);
                    }
                    else
                    {
                        string[] data1 = line.Split('=');
                        if (data1.Length == 2)
                        {
                            string   data2 = data1[1];
                            string[] data3 = data2.Split('-');
                            if (data3.Length == 3)
                            {
                                string data4 = data3[1];
                                data4 = (start++).ToString();

                                dt = new LineData(true, data4, data1[0], data3[0], data3[2], lineIndex);
                            }
                        }
                    }
                    lins.Add(dt);
                }
            }
            StringBuilder OverwriteSB = new StringBuilder();

            for (int i = 0; i < lins.Count; i++)
            {
                LineData dt = lins[i];
                OverwriteSB.Append(dt.ToString());
                if (i < lins.Count - 1)
                {
                    OverwriteSB.Append("\n");
                }
            }

            FileInfo fileInfo = new FileInfo(path);
            string   newPath  = Path.Combine(fileInfo.Directory.FullName, "new" + Path.GetFileNameWithoutExtension(fileInfo.FullName) + fileInfo.Extension);

            if (File.Exists(newPath))
            {
                File.Delete(newPath);
            }
            using (StreamWriter sw = new StreamWriter(File.Open(newPath, FileMode.OpenOrCreate, FileAccess.Write)))
            {
                sw.Write(OverwriteSB.ToString());
            }
        }
예제 #3
0
        private void button3_Click(object sender, EventArgs e)
        {
            Dictionary <string, List <LineData> > allPortID  = new Dictionary <string, List <LineData> >();
            Dictionary <string, List <string> >   samePortID = new Dictionary <string, List <string> >();

            ReadConfig(allPortID, samePortID);

            #region Overwrite
            StringBuilder OverwriteSB = new StringBuilder();
            List <int>    hasChange   = new List <int>();

            Dictionary <int, LineData> lineDataDir = new Dictionary <int, LineData>();

            List <LineData> fileData = new List <LineData>();

            int firstPortID = 0;

            foreach (KeyValuePair <string, List <LineData> > item in allPortID)
            {
                if (item.Value != null)
                {
                    if (item.Value.Count == 1)
                    {
                        int id = 0;
                        if (int.TryParse(item.Value[0].portID, out id))
                        {
                            fileData.Add(item.Value[0]);
                            if (lineDataDir.ContainsKey(id))
                            {
                                while (true)
                                {
                                    if (lineDataDir.ContainsKey(id) || allPortID.ContainsKey(id.ToString()))
                                    {
                                        id++;
                                        continue;
                                    }
                                    break;
                                }
                                lineDataDir.Add(id, item.Value[0]);
                            }
                            else
                            {
                                lineDataDir.Add(id, item.Value[0]);
                            }
                        }
                        else
                        {
                            fileData.Add(item.Value[0]);
                        }
                        continue;
                    }
                    bool isFirst = true;
                    foreach (var data in item.Value)
                    {
                        hasChange.Add(data.lineIndex);

                        if (!data.isPortID)
                        {
                            fileData.Add(data);
                        }
                        else
                        {
                            if (firstPortID <= 0)
                            {
                                bool result = int.TryParse(data.portID, out firstPortID);
                                if (!result)
                                {
                                    this.richTextBox1.AppendText("TryParse Error: " + string.Format("First:  行数:{0} -> {1}\r\n", data.lineIndex, data.ToString()));
                                }
                            }
                            int portID = firstPortID;
                            if (isFirst)
                            {
                                isFirst = false;
                                while (true)
                                {
                                    if (lineDataDir.ContainsKey(portID) || allPortID.ContainsKey(portID.ToString()))
                                    {
                                        portID = ++firstPortID;
                                        continue;
                                    }
                                    break;
                                }

                                fileData.Add(data);
                                lineDataDir.Add(portID, data);

                                continue;
                            }
                            do
                            {
                                if (lineDataDir.ContainsKey(portID) || allPortID.ContainsKey(portID.ToString()))
                                {
                                    portID = ++firstPortID;
                                    continue;
                                }
                                data.portID = portID.ToString();
                                fileData.Add(data);

                                lineDataDir.Add(portID, data);
                                firstPortID++;
                                break;
                            }while (true);
                        }
                    }
                }
            }

            fileData.Sort((x, y) => { return(x.lineIndex - y.lineIndex); });

            for (int i = 0; i < fileData.Count; i++)
            {
                LineData item = fileData[i];
                OverwriteSB.Append(item.ToString());
                if (i < fileData.Count - 1)
                {
                    OverwriteSB.Append("\n");
                }
            }
            string   path     = this.textBox1.Text;
            FileInfo fileInfo = new FileInfo(path);
            string   newPath  = Path.Combine(fileInfo.Directory.FullName, "new" + Path.GetFileNameWithoutExtension(fileInfo.FullName) + fileInfo.Extension);
            if (File.Exists(newPath))
            {
                File.Delete(newPath);
            }
            using (StreamWriter sw = new StreamWriter(File.Open(newPath, FileMode.OpenOrCreate, FileAccess.Write)))
            {
                sw.Write(OverwriteSB.ToString());
            }
            #endregion
        }