/// <summary>
/// Provides the description of the model settings for summary (GetFullSummary)
/// </summary>
/// <param name="formatForParentControl">Use full verbose description</param>
/// <returns></returns>
public override string ModelSummary(bool formatForParentControl)
{
string html = "";
html += "\n<div class=\"filter\">";
html += "Perform between ";
if (StartMonth == 0)
{
html += "<span class=\"errorlink\">NOT SET</span>";
}
else
{
html += "<span class=\"setvalueextra\">";
html += StartMonth.ToString() + "</span>";
}
html += " and <span class=\"setvalueextra\">";
if (EndMonth == 0)
{
html += "<span class=\"errorlink\">NOT SET</span>";
}
else
{
html += "<span class=\"setvalueextra\">";
html += EndMonth.ToString() + "</span>";
}
html += "</div>";
if (!this.Enabled)
{
html += " - DISABLED!";
}
return(html);
}
/// <summary>
/// Provides the description of the model settings for summary (GetFullSummary)
/// </summary>
/// <param name="formatForParentControl">Use full verbose description</param>
/// <returns></returns>
public override string ModelSummary(bool formatForParentControl)
{
using (StringWriter htmlWriter = new StringWriter())
{
htmlWriter.Write("\r\n<div class=\"filter\">");
htmlWriter.Write("Perform between ");
if (StartMonth == 0)
{
htmlWriter.Write("<span class=\"errorlink\">NOT SET</span>");
}
else
{
htmlWriter.Write("<span class=\"setvalueextra\">");
htmlWriter.Write(StartMonth.ToString() + "</span>");
}
htmlWriter.Write(" and <span class=\"setvalueextra\">");
if (EndMonth == 0)
{
htmlWriter.Write("<span class=\"errorlink\">NOT SET</span>");
}
else
{
htmlWriter.Write("<span class=\"setvalueextra\">");
htmlWriter.Write(EndMonth.ToString() + "</span>");
}
htmlWriter.Write("</div>");
if (!this.Enabled)
{
htmlWriter.Write(" - DISABLED!");
}
return(htmlWriter.ToString());
}
}
public void GrupingPNC_Revision()
{
int StartMonth;
decimal All = 0;
decimal DMD = 0;
decimal D45 = 0;
decimal DMD_FS = 0;
decimal D45_FS = 0;
decimal DMD_FI = 0;
decimal D45_FI = 0;
decimal DMD_BI = 0;
decimal D45_BI = 0;
decimal DMD_FSBU = 0;
decimal D45_FSBU = 0;
Data_Import.Singleton().Load_TxtToDataTable2(ref PNC, "PNC");
Data_Import.Singleton().Load_TxtToDataTable2(ref SumPNC, "SumPNCBU");
switch (_Rev)
{
case "BU":
StartMonth = 1;
break;
case "EA1":
StartMonth = 3;
break;
case "EA2":
StartMonth = 6;
break;
case "EA3":
StartMonth = 9;
break;
default:
StartMonth = 0;
break;
}
if (StartMonth == 0)
{
return;
}
for (; StartMonth <= 12; StartMonth++)
{
if (!PNC.Columns.Contains(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()))
{
MessageBox.Show("Missing Data for: " + _Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString(), "Attention!");
return;
}
if (SumPNC.Columns.Contains(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()))
{
SumPNC.Columns.Remove(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString());
}
SumPNC.Columns.Add(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString());
foreach (DataRow PNCRow in PNC.Rows)
{
if (PNCRow[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] != null && PNCRow[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()].ToString() != "")
{
decimal Value = decimal.Parse(PNCRow[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()].ToString());
string PNC = PNCRow["BUPNC"].ToString();
//Dodanie do sumy wszystkich PNC
All += Value;
//Rozbiecie na DMD i D45
if (PNC.Remove(0, 3).Remove(1, 5) == "5")
{
//Dodanie do Sumy DMD
DMD += Value;
//Sprawdzenie czy FS, FI, BI/BU lub FSBU
switch (PNC.Remove(0, 4).Remove(1, 4))
{
case "1":
DMD_FS += Value;
break;
case "2":
DMD_BI += Value;
break;
case "3":
DMD_FI += Value;
break;
case "4":
DMD_FSBU += Value;
break;
default:
break;
}
}
else
{
//Dodanie do Sumy D45
D45 += Value;
switch (PNC.Remove(0, 4).Remove(1, 4))
{
case "5":
D45_FS += Value;
break;
case "6":
D45_BI += Value;
break;
case "7":
D45_FI += Value;
break;
case "8":
D45_FSBU += Value;
break;
default:
break;
}
}
}
}
foreach (DataRow Row in SumPNC.Rows)
{
switch (Row["PNC"].ToString())
{
case "All":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = All;
break;
case "DMD":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD;
break;
case "D45":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45;
break;
case "DMD_FS":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_FS;
break;
case "D45_FS":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_FS;
break;
case "DMD_FI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_FI;
break;
case "D45_FI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_FI;
break;
case "DMD_BI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_BI;
break;
case "D45_BI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_BI;
break;
case "DMD_FSBU":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_FSBU;
break;
case "D45_FSBU":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_FSBU;
break;
default:
break;
}
}
All = 0;
DMD = 0;
D45 = 0;
DMD_BI = 0;
DMD_FI = 0;
DMD_FS = 0;
DMD_FSBU = 0;
D45_BI = 0;
D45_FI = 0;
D45_FS = 0;
D45_FSBU = 0;
}
Data_Import.Singleton().Save_DataTableToTXT2(ref SumPNC, "SumPNCBU");
}
