如何在c#中将值连接到逗号分隔的值

我正在读取文本文件，我想根据条件获得值。首先，我将采取FREQ，其中CELLID=639和ISMAINBCCH=YES，我已经完成了现在的下一个任务是我必须以逗号分隔的方式连接FREQ值，其中CELLID=639和ISMAINBCCH=NO，所以我想要的输出是24,28,67。如何做到这一点?

行是

ADD GCELL:CELLID=639, CELLNAME="NR_0702_07021_G1_A", MCC="424", MNC="02", LAC=6112, CI=7021, NCC=6, BCC=0, EXTTP=Normal_cell, IUOTP=Concentric_cell, ENIUO=ON, DBFREQBCCHIUO=Extra, FLEXMAIO=OFF, CSVSP=3, CSDSP=5, PSHPSP=4, PSLPSVP=6, BSPBCCHBLKS=1, BSPAGBLKSRES=4, BSPRACHBLKS=1, TYPE=GSM900_DCS1800, 
......................
.............
ADD GTRX:TRXID=0, TRXNAME="M_RAK_JeerExch_G_1879_18791_A-0", FREQ=81, TRXNO=0, CELLID=639, IDTYPE=BYID, ISMAINBCCH=YES, ISTMPTRX=NO, GTRXGROUPID=2556;
ADD GTRX:TRXID=1, TRXNAME="M_RAK_JeerExch_G_1879_18791_A-1", FREQ=24, TRXNO=1, CELLID=639, IDTYPE=BYID, ISMAINBCCH=NO, ISTMPTRX=NO, GTRXGROUPID=2556;
ADD GTRX:TRXID=5, TRXNAME="M_RAK_JeerExch_G_1879_18791_A-2", FREQ=28, TRXNO=2, CELLID=639, IDTYPE=BYID, ISMAINBCCH=NO, ISTMPTRX=NO, GTRXGROUPID=2556;
ADD GTRX:TRXID=6, TRXNAME="M_RAK_JeerExch_G_1879_18791_A-3", FREQ=67, TRXNO=3, CELLID=639, IDTYPE=BYID, ISMAINBCCH=NO, ISTMPTRX=NO, GTRXGROUPID=2556;

我得到如下所示的值

using (StreamReader sr = File.OpenText(filename))
{
    while ((s = sr.ReadLine()) != null)
    {
        if (s.Contains("ADD GCELL:"))
        {
            var gtrx = new Gtrx
            {
                CellId = int.Parse(PullValue(s, "CELLID")),
                Freq = int.Parse(PullValue(s, "FREQ")),
                TrxNo = int.Parse(PullValue(s, "TRXNO")),
                IsMainBcch = PullValue(s, "ISMAINBCCH").ToUpper() == "YES",
                TrxName = PullValue(s, "TRXNAME"),
            };
        }
    }

我使用立面概念，但现在花费了很多时间。我不确定我是否使用了任何坏的逻辑两次我迭代文本文件一次获得常规值，另一次获得连接值

 private class Gtrx
    {
        public int Freq { get; set; }
        public int TrxNo { get; set; }
        public string TrxName { get; set; }
        public int CellId { get; set; }
        public bool IsMainBcch { get; set; }
    }
    private class Gcell
    {
        public int CellId { get; set; }
        public string CellName { get; set; }
        public string Mcc { get; set; }
        public int Lac { get; set; }
        public int Ci { get; set; }
    }
    private class GcellGtrx
    {
        public Gcell Gcell { get; set; }
        public Gtrx Gtrx { get; set; }
    }
using (var sr = new StringReader(data))
{
    string line = sr.ReadLine();
    while (line != null)
    {
        line = line.Trim();
        if (line.StartsWith("ADD GCELL:"))
        {
            var gcell = new Gcell
            {
                CellId = int.Parse(PullValue(line, "CELLID")),
                CellName = PullValue(line, "CELLNAME"),
                Ci = int.Parse(PullValue(line, "CI")),
                Lac = int.Parse(PullValue(line, "LAC")),
                Mcc = PullValue(line, "MCC")
            };
            var gcellGtrx = new GcellGtrx();
            gcellGtrx.Gcell = gcell;
            _dictionary.Add(gcell.CellId, gcellGtrx);
        }
        if (line.StartsWith("ADD GTRX:"))
        {
            var gtrx = new Gtrx
            {
                CellId = int.Parse(PullValue(line, "CELLID")),
                Freq = int.Parse(PullValue(line, "FREQ")),
                TrxNo = int.Parse(PullValue(line, "TRXNO")),
                IsMainBcch = PullValue(line, "ISMAINBCCH").ToUpper() == "YES",
DEFINED_TCH_FRQ = null,
                TrxName = PullValue(line, "TRXNAME")
            };
           if (!intarr.Contains(gtrx.CellId))
                            {
                                if (!_dictionary.ContainsKey(gtrx.CellId))
                                {
                                    // No GCell record for this id. Do something!
                                    continue;
                                }
                                intarr.Add(gtrx.CellId);
                                string results = string.Empty;
                                    var result = String.Join(",",
        from ss in File.ReadLines(filename)
        where ss.Contains("ADD GTRX:")
        where int.Parse(PullValue(ss, "CELLID")) == gtrx.CellId
        where PullValue(ss, "ISMAINBCCH").ToUpper() != "YES"
        select int.Parse(PullValue(ss, "FREQ")));
                                    results = result;

                                var gtrxnew = new Gtrx
                                {
                                    DEFINED_TCH_FRQ = results
                                };
                                _dictionary[gtrx.CellId].Gtrx = gtrx;
        }
        line = sr.ReadLine();
    }
}

最后，我像第一次一样使用File保存了以ADD GTRX开始的行到数组中。Readalllines，然后只使用该数组来获得连接字符串，而不是存储整个文本文件，并获得了一些性能改进。

如果我将包含数十万行的文本文件转换为xml，然后从xml文件而不是从文本文件检索数据，它会使任何性能改进吗?如果我在这里使用数据表和数据集而不是类，性能会有所提高吗?

var gtrxs = new List<Gtrx>();
using (StreamReader sr = File.OpenText(filename))
{
    while ((s = sr.ReadLine()) != null)
    {

        if (s.Contains("ADD GCELL:"))
        {
            var gtrx = new Gtrx
                                {
                                    CellId = int.Parse(PullValue(s, "CELLID")),
                                    Freq = int.Parse(PullValue(s, "FREQ")),
                                    TrxNo = int.Parse(PullValue(s, "TRXNO")),
                                    IsMainBcch = PullValue(s, "ISMAINBCCH").ToUpper() == "YES",
                                    TrxName = PullValue(s, "TRXNAME"),
                                };
            gtrxs.Add(gtrx);
        }
    }
}
IEnumerable<int> freqValues = gtrxs.Where(x => x.CellId == 639 && x.IsMainBcch == false).Select(x => x.Freq);
string result = String.Join(",", freqValues);

var result = String.Join(",", 
    from s in File.ReadAllLines(filename)
    where s.Contains("ADD GCELL:")
    where int.Parse(PullValue(s, "CELLID")) == 639
    where PullValue(s, "ISMAINBCCH").ToUpper() != "YES"
    select int.Parse(PullValue(s, "FREQ")));