public static string aylik_tonaj_verileri_getir()
{
Holding_raporu_db dbh = new Holding_raporu_db();
List <Tonajlar> tonajlar = new List <Tonajlar>();
DateTime dt = new DateTime();
dt = DateTime.Now;
int yil = dt.Year;
string firma = "DILER";
string unite = "CH";
dbh.Connect();
/** Diler CH */
tonajlar = dbh.tonajlar_data_read(firma, unite, yil);
dbh.Disconnect();
for (int i = tonajlar.Count; i < 12; i++)
{
/** Veri girilmemis aylara sıfır degeri ataycagiz. */
Tonajlar t = new Tonajlar();
t.Tonaj_id = 1;
t.Ay = i.ToString();
t.Tonaj = "0";
tonajlar.Add(t);
}
/** Diler HH */
List <Tonajlar> tonajlar3 = new List <Tonajlar>();
firma = "DILER";
unite = "HH";
dbh.Connect();
tonajlar3 = dbh.tonajlar_data_read(firma, unite, yil);
dbh.Disconnect();
for (int i = tonajlar3.Count; i < 12; i++)
{
/** Veri girilmemis aylara sıfır degeri ataycagiz. */
Tonajlar t = new Tonajlar();
t.Tonaj_id = 1;
t.Ay = i.ToString();
t.Tonaj = "0";
tonajlar3.Add(t);
}
/** Filmasin HH */
List <Tonajlar> tonajlar5 = new List <Tonajlar>();
firma = "FILMASIN";
unite = "HH";
dbh.Connect();
tonajlar5 = dbh.tonajlar_data_read(firma, unite, yil);
dbh.Disconnect();
for (int i = tonajlar5.Count; i < 12; i++)
{
/** Veri girilmemis aylara sıfır degeri ataycagiz. */
Tonajlar t = new Tonajlar();
t.Tonaj_id = 1;
t.Ay = i.ToString();
t.Tonaj = "0";
tonajlar5.Add(t);
}
string tonaj = "[";
foreach (var t in tonajlar)
{
tonaj += "{\"ay\":\"" + t.Ay + "\",\"tonaj\":\"" + t.Tonaj + "\",\"firma\":\"DILER\"},";
}
foreach (var t in tonajlar3)
{
tonaj += "{\"ay\":\"" + t.Ay + "\",\"tonaj\":\"" + t.Tonaj + "\",\"firma\":\"DILER\"},";
}
foreach (var t in tonajlar5)
{
tonaj += "{\"ay\":\"" + t.Ay + "\",\"tonaj\":\"" + t.Tonaj + "\",\"firma\":\"FILMASIN\"},";
}
tonaj = tonaj.Trim(',');
tonaj += "]";
return(tonaj);
}
private StringBuilder tonajlari_getir(string firma, string unite)
{
StringBuilder htmlTable = new StringBuilder();
htmlTable.Clear();
List <Tonajlar> tonajlar = new List <Tonajlar>();
tonajlar = db.tonajlar_data_read(firma, unite);
htmlTable.Append("<thead><tr><th></th>");
DateTime dt2 = new DateTime();
dt2 = DateTime.Now;
double[] toplam_tonaj = new double[5] {
0, 0, 0, 0, 0
};
int yil = dt2.Year - 5;
for (int i = dt2.Year; i > dt2.Year - 5; i--)
{
htmlTable.Append("<th>" + i.ToString() + "</th>");
}
htmlTable.Append("</tr></thead><tbody>");
if (tonajlar[0].Tonaj_id == 0)
{
//kayit bulunamadi
htmlTable.Append("<tr>");
htmlTable.Append("<td colspan='6'>" + tonajlar[0].Yil + "</td>");
htmlTable.Append("</tr>");
}
else
{
for (int i = 1; i <= 12; i++)
{
htmlTable.Append("<tr>");
htmlTable.Append("<td>" + ay_getir(i) + "</td>");
for (int j = dt2.Year; j > dt2.Year - 5; j--)
{
htmlTable.Append("<td>");
foreach (var t in tonajlar)
{
if (Convert.ToInt32(t.Yil) == j && Convert.ToInt32(t.Ay) == i)
{
htmlTable.Append(t.Tonaj);
toplam_tonaj[dt2.Year - Convert.ToInt32(t.Yil)] += Convert.ToDouble(t.Tonaj);
}
}
htmlTable.Append("</td>");
}
htmlTable.Append("</tr>");
}
}
htmlTable.Append("<tr><td style='background-color:#FF0;font-weight:bold;'>TOPLAM</td>");
for (int i = 0; i < toplam_tonaj.Length; i++)
{
htmlTable.Append("<td style='background-color:#FF0;font-weight:bold;'>" + toplam_tonaj[i] + "</td>");
}
htmlTable.Append("</tr>");
htmlTable.Append("</tbody>");
return(htmlTable);
}
