private void LoadSalaryTableList()
{
this.lbNoSalaryTableList.Items.Clear();
this.lbSalaryTableList.Items.Clear();
DataTable listByYear = this.l_SalaryTableList.GetListByYear(int.Parse(this.dtYear.Text));
foreach (DataRow row in listByYear.Rows)
{
ImageListBoxItemCollection items = this.lbSalaryTableList.Items;
object[] str = new object[] { "Tháng ", row["Month"].ToString(), '-', row["Year"].ToString() };
items.Add(string.Concat(str), 2);
}
for (int i = 1; i <= 12; i++)
{
if (!this.l_SalaryTableList.Exist(i, int.Parse(this.dtYear.Text)))
{
this.lbNoSalaryTableList.Items.Add(string.Concat("Tháng ", i.ToString(), "-", this.dtYear.Text), 2);
}
}
}
public ImageListBox()
{
// Set owner draw mode
base.DrawMode = DrawMode.OwnerDrawFixed;
listItems = new ImageListBoxItemCollection(this);
}
/// <summary>
/// Olay dağılımı raporu
/// </summary>
/// <param name="lstRaporElemanlari">Seçili rapor elemanları</param>
/// <returns></returns>
public string OlayDagilimi(ImageListBoxItemCollection lstRaporElemanlari)
{
var htmlTable = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>Yıllık Döküm</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]-->" +
"<title>Yıllık Döküm</title>" +
"<style>" +
"th {text-align:center; font-weight:bold;}" +
"</style>" +
"</head>" +
"<body>" +
"<table>";
using (var db = new ETSEntities())
{
// : Başlıklar
htmlTable += "<tr>";
for (var i = -1; i < lstRaporElemanlari.Count; i++)
{
if (i >= 0)
{
htmlTable += "<td colspan='6' style='background-color: " + RaporRengi(i) + ";' valign='center' align='center'>" + lstRaporElemanlari[i] + "</td>";
}
else
{
htmlTable += "<td></td>";
}
}
// : Genel Toplam
htmlTable += "<td colspan='6' style='background-color: " + RaporRengi(99) + ";' valign='center' align='center'>GENEL TOPLAM</td>";
htmlTable += "</tr>";
// : Yıllar
htmlTable += "<tr>";
for (var i = -1; i < lstRaporElemanlari.Count + 1; i++)
{
if (i >= 0)
{
for (var yil = DateTime.Now.Year - 4; yil <= DateTime.Now.Year; yil++)
{
htmlTable += "<td style='background-color: " + RaporRengi(i) + ";' valign='center' align='center'>" + yil + "</td>";
if (yil == DateTime.Now.Year)
{
htmlTable += "<td style='background-color: " + RaporRengi(i) + ";' valign='center' align='center'>TOPLAM</td>";
}
}
}
else
{
htmlTable += "<td></td>";
}
}
htmlTable += "</tr>";
// : Köyler ve rakamları
var olayYerleri = db.OlayYerleri.Distinct().ToArray();
foreach (var t in olayYerleri)
{
htmlTable += "<tr>";
var aralik = 0;
var yil = DateTime.Now.Year - 4;
var toplam = 6 * lstRaporElemanlari.Count;
var digerKolon = false;
for (var j = 0; j < toplam; j++)
{
if (j == 0)
{
htmlTable += "<td>" + t.OlayYeri + "</td>";
}
else
{
if (j > 1 && yil == DateTime.Now.Year - 4)
{
aralik++;
digerKolon = aralik >= lstRaporElemanlari.Count;
}
if (!digerKolon)
{
var grup = lstRaporElemanlari[aralik].ToString();
var ids = db.Tasnifler.Where(s => s.Grup == grup).Select(s => s.Id).ToList();
htmlTable += "<td style='background-color: " + RaporRengi(aralik) + ";'>" + db.OlaylarBilgisi.Count(w => ids.Contains((int)w.TansifId) && w.OlayTarihi.Year == yil && w.OlayYeriId == t.Id) + "</td>";
if (j % 5 == 0)
{
yil = DateTime.Now.Year - 4;
htmlTable += "<td style='background-color: " + RaporRengi(aralik) + ";'>" + db.OlaylarBilgisi.Count(w => ids.Contains((int)w.TansifId) && yil <= w.OlayTarihi.Year && yil + 5 >= w.OlayTarihi.Year && w.OlayYeriId == t.Id) + "</td>";
}
else
{
yil++;
}
}
}
}// : Genel Toplamlar
for (var genelToplamYili = DateTime.Now.Year - 4; genelToplamYili <= DateTime.Now.Year + 1; genelToplamYili++)
{
if (genelToplamYili > DateTime.Now.Year)
{
htmlTable += "<td style='background-color: " + RaporRengi(aralik) + ";'>" + db.OlaylarBilgisi.Count(w => DateTime.Now.Year - 4 <= w.OlayTarihi.Year && DateTime.Now.Year >= w.OlayTarihi.Year && w.OlayYeriId == t.Id) + "</td>";
}
else
{
htmlTable += "<td style='background-color: " + RaporRengi(aralik) + ";'>" + db.OlaylarBilgisi.Count(w => w.OlayTarihi.Year == genelToplamYili && w.OlayYeriId == t.Id) + "</td>";
}
}
htmlTable += "</tr>";
}
}
htmlTable += "</table>";
htmlTable += "</body>";
htmlTable += "</html>";
return(htmlTable);
}
