Beispiel #1
0
        public override void ParseExcel(DataRow row)
        {
            if (Convert.ToInt32(row[3].ToString()) >= 5000000)
            {
                LineDay l = new LineDay(Convert.ToInt32(row[2].ToString()), row[0].ToString());
                if (!LD.Contains(l))
                {
                    LD.Add(l);
                }
            }


            if (row[6].ToString().ToUpper().Contains("FC"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    FCcount += 1;
                }
                FCtime += Convert.ToInt16(row[7].ToString());
            }

            else if (row[6].ToString().ToUpper().Contains("FB"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    FBcount += 1;
                }
                FBtime += Convert.ToInt16(row[7].ToString());
            }

            else if (row[6].ToString().ToUpper().Contains("RB"))
            {
                if (row[6].ToString().ToUpper().Contains("RB40"))
                {
                    if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                    {
                        RB40count += 1;
                    }
                    RB40time += Convert.ToInt16(row[7].ToString());
                }
                if (row[6].ToString().ToUpper().Contains("RB60"))
                {
                    if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                    {
                        RB60count += 1;
                    }
                    RB60time += Convert.ToInt16(row[7].ToString());
                }
            }

            else if (row[6].ToString().ToUpper().Contains("RC"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    RCcount += 1;
                }
                RCtime += Convert.ToInt16(row[7].ToString());
            }
        }
 public override void ParseExcel(DataRow row)
 {
     //Console.WriteLine("Not needed to Parse :D");
     if (Convert.ToInt32(row[3].ToString()) >= 5000000)
     {
         LineDay l = new LineDay(Convert.ToInt32(row[2].ToString()), row[0].ToString());
         if (!LD.Contains(l))
         {
             LD.Add(l);
         }
     }
 }
Beispiel #3
0
        public override void ParseExcel(DataRow row)
        {
            if (Convert.ToInt32(row[3].ToString()) >= 5000000)
            {
                LineDay l = new LineDay(Convert.ToInt32(row[2].ToString()), row[0].ToString());
                if (!LD.Contains(l))
                {
                    LD.Add(l);
                }
            }

            if (row[6].ToString().ToUpper().Contains("VST") || row[6].ToString().ToUpper().Contains("MITTE") || row[6].ToString().ToUpper().Contains("M-TEIL") || row[6].ToString().Contains("Motorschutzabdeckung") || row[6].ToString().Contains("Sichtschutz"))
            {
                SPtime += Convert.ToInt16(row[7].ToString());
                SPcount++;
            }
            //Console.WriteLine(row[6].ToString());
            if (row[6].ToString().ToUpper().Contains("FAKI"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    FCcount += 1;
                }
                FCtime += Convert.ToInt16(row[7].ToString());
            }

            else if (row[6].ToString().ToUpper().Contains("FALE"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    FBcount += 1;
                }
                FBtime += Convert.ToInt16(row[7].ToString());
            }

            else if (row[6].ToString().ToUpper().Contains("FOLE"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    if ((row[6].ToString().ToUpper().Contains("FSS")))
                    {
                        RB100count += 1;
                    }
                    else if ((row[6].ToString().ToUpper().Contains("FES")))
                    {
                        RB40count += 1;
                    }
                }
                if (row[6].ToString().ToUpper().Contains("FES") || (row[6].ToString().ToUpper().Contains("FSS")))
                {
                    RBtime += Convert.ToInt16(row[7].ToString());
                }
            }

            else if (row[6].ToString().ToUpper().Contains("FOKI"))
            {
                if (Convert.ToInt32(row[3].ToString()) >= 5000000)
                {
                    if (row[6].ToString().ToUpper().Contains("FOKI") && (row[6].ToString().ToUpper().Contains("FSS")))
                    {
                        RC100count += 1;
                    }
                    if (row[6].ToString().ToUpper().Contains("FOKI") && (row[6].ToString().ToUpper().Contains("FES")))
                    {
                        RC40count += 1;
                    }
                }
                if (row[6].ToString().ToUpper().Contains("FES") || (row[6].ToString().ToUpper().Contains("FSS")))
                {
                    RCtime += Convert.ToInt16(row[7].ToString());
                }
            }
        }