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