private void ceToplamHali_CheckedChanged(object sender, EventArgs e)
{
try
{
switch (leYillar.EditValue != null)
{
case true:
TYillar yillar = new TYillar
{
Yil = int.Parse(leYillar.Text)
};
FastReport.Report rep = new FastReport.Report();
switch (ceToplamHali.Checked)
{
case true:
using (SqlKutuphane lib = new SqlKutuphane())
{
DataSet ds2 = lib.SqlBinding_Rapor(string.Format(@"SELECT TM.MusteriUnvani
,(SUM(X.Gidis) + SUM(Y.Gelis1) + SUM(Z.Gelis2)) Sonuc
FROM TMusteriTanimlari TM
CROSS APPLY (
SELECT count(SI.GidisTarihi) AS Gidis
FROM TServisIslem SI
WHERE SI.DelDate IS NULL
AND DATEPART(YEAR, SI.AddDate) = {0}
AND TM.Id = SI.Musteri
) X
CROSS APPLY (
SELECT count(SGC.GelisTarihi) AS Gelis1
FROM TServiseGelenCihaz SGC
WHERE SGC.DelDate IS NULL
AND DATEPART(YEAR, SGC.AddDate) = {0}
AND TM.Id = SGC.MusteriId
) Y
CROSS APPLY (
SELECT count(SGCM.GelisTarihi) AS Gelis2
FROM TServiseGelenCihaz_M SGCM
WHERE SGCM.DelDate IS NULL
AND DATEPART(YEAR, SGCM.AddDate) = {0}
AND TM.Id = SGCM.MusteriId
) Z
WHERE TM.DelDate IS NULL
GROUP BY TM.MusteriUnvani
,X.Gidis
,Y.Gelis1
,Z.Gelis2
ORDER BY Sonuc DESC", yillar.Yil));
rep.RegisterData(ds2, "YillikServisToplami");
rep.Load(dosya2);
rep.Show(true);
}
break;
}
break;
case false: MessageBoxes.Error("Yıl seçiniz"); break;
}
}
catch (Exception ex)
{
MessageBoxes.Error(ex.Message);
}
}
private void btnGetir_Click(object sender, EventArgs e)
{
switch (ceToplamHali.Checked)
{
case true: ceToplamHali.CheckState = CheckState.Unchecked; break;
}
if (leYillar.EditValue != null || int.Parse(leYillar.EditValue.ToString()) != 0)
{
FastReport.Report rep = new FastReport.Report();
TYillar yillar = new TYillar
{
Yil = int.Parse(leYillar.Text)
};
using (SqlKutuphane lib = new SqlKutuphane())
{
DataSet ds1 = lib.SqlBinding_Rapor(string.Format(@"SELECT TM.MusteriUnvani
,X.Servis
,Y.Personel
,Z.Musteri
FROM TMusteriTanimlari TM
CROSS APPLY (
SELECT count(SI.GidisTarihi) AS Servis
FROM TServisIslem SI
WHERE SI.DelDate IS NULL
AND DATEPART(YEAR, SI.AddDate) = {0}
AND TM.Id = SI.Musteri
) X
CROSS APPLY (
SELECT count(SGC.GelisTarihi) AS Personel
FROM TServiseGelenCihaz SGC
WHERE SGC.DelDate IS NULL
AND DATEPART(YEAR, SGC.AddDate) = {0}
AND TM.Id = SGC.MusteriId
) Y
CROSS APPLY (
SELECT count(SGCM.GelisTarihi) AS Musteri
FROM TServiseGelenCihaz_M SGCM
WHERE SGCM.DelDate IS NULL
AND DATEPART(YEAR, SGCM.AddDate) = {0}
AND TM.Id = SGCM.MusteriId
) Z
WHERE TM.DelDate IS NULL
GROUP BY TM.MusteriUnvani
,X.Servis
,Y.Personel
,Z.Musteri
ORDER BY Servis DESC", yillar.Yil));
rep.RegisterData(ds1, "YillikServisAdeti");
rep.Load(dosya1);
rep.Show(true);
}
}
else
{
MessageBoxes.Error("Yanlış Seçim yaptınız");
}
}
private void btnGetir_Click(object sender, EventArgs e)
{
Tutar tutar = new Tutar()
{
BaslangicTarihi = (deBaslangic.EditValue == null) ? (DateTime?)null : DateTime.Parse(deBaslangic.EditValue.ToString()),
BitisTarihi = (deBitis.EditValue == null) ? (DateTime?)null : DateTime.Parse(deBitis.EditValue.ToString()),
};
try
{
if (tutar.BaslangicTarihi == null || tutar.BitisTarihi == null)
{
MessageBoxes.Error("Boş alan");
}
else
{
FastReport.Report rep = new FastReport.Report();
using (SqlKutuphane lib = new SqlKutuphane())
{
DataSet ds1 = lib.SqlBinding_Rapor(string.Format(@"SELECT SUM(Ucret)
FROM TServisIslem
WHERE DelDate IS NULL
AND Ucret != 0
AND GidisTarihi BETWEEN '{0}'
AND '{1}'" , tutar.BaslangicTarihi.Value.ToString("yyyy-MM-dd"), tutar.BitisTarihi.Value.ToString("yyyy-MM-dd")));
rep.RegisterData(ds1, "ServisIslem");
DataSet ds2 = lib.SqlBinding_Rapor(string.Format(@"SELECT SUM(Toplam)
FROM TServiseGelenCihaz
WHERE DelDate IS NULL
AND Toplam != 0
AND GidisTarihi BETWEEN '{0}'
AND '{1}'" , tutar.BaslangicTarihi.Value.ToString("yyyy-MM-dd"), tutar.BitisTarihi.Value.ToString("yyyy-MM-dd")));
rep.RegisterData(ds2, "ServiseGelen");
DataSet ds3 = lib.SqlBinding_Rapor(string.Format(@"SELECT SUM(Toplam)
FROM TServiseGelenCihaz_M
WHERE DelDate IS NULL
AND Toplam != 0
AND GidisTarihi BETWEEN '{0}'
AND '{1}'" , tutar.BaslangicTarihi.Value.ToString("yyyy-MM-dd"), tutar.BitisTarihi.Value.ToString("yyyy-MM-dd")));
rep.RegisterData(ds3, "ServiseGelen_M");
rep.Load(dosya);
rep.SetParameterValue("Baslangic", tutar.BaslangicTarihi);
rep.SetParameterValue("Bitis", tutar.BitisTarihi);
rep.Show(true);
}
}
}
catch (Exception ex)
{
MessageBoxes.Error(ex.Message);
}
}
