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);
}
}
}
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());
}
}
}