public override object ExecuteReport(MethodReturn refMr = null)
{
string dateQuery = "";
string dateGunQuery1 = "";
string dateGunQuery2 = "";
int MinGun1 = Int32.Parse(MinGun.ToString());
int MaxGun1 = Int32.Parse(MaxGun.ToString());
if (MinGun1 > 0)
{
dateGunQuery1 = " AND acikkalmagunu >= " + MinGun;
}
if (MaxGun1 > 0)
{
dateGunQuery2 = " AND acikkalmagunu <= " + MaxGun;
}
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
select * from (
select
ie1.servisid,
SRV.PARTNERCODE,
SRV.ISORTAKAD SERVISADI,
ie1.isemirno,
ie1.kayittarih KAYITTARIHI,
SYSDATE RAPORGUNU,
round( sysdate - ie1.kayittarih) ACIKKALMAGUNU,
case
when ie1.arackazali = 1 then 'EVET'
else 'HAYIR'
end ARAC_KAZALI,
ie1.araccikiszamani,
case
when ie1.aracserviste = 0 then 'HAYIR'
else 'EVET'
end arac_servis_disinda,
case
when SERVAR.VARLIKTIPID=3 then 'EVET'
else 'HAYIR'
end KAMU,
ie1.aciklama
from (
select * from servisisemirler where teknikolaraktamamla = 0 and tamamlanmatarih is null) ie1
left join vt_servisler srv on srv.dilkod = 'Turkish' and srv.servisid = ie1.servisid
inner join servisvarliklar servar on SERVAR.id=ie1.servisvarlikid
WHERE srv.servisid = {ServisId}
)
where
1=1
{dateGunQuery1}
{dateGunQuery2}
order by ACIKKALMAGUNU desc ,kayittarihi asc
")
// .Parameter("StartDate", StartDate.Date)
// .Parameter("FinishDate", FinishDate.endOfDay())
// .Parameter("ServisId", ServisId)
// .Parameter("SaseNo", SaseNo.isNotNullOrWhiteSpace() ? null : SaseNo)
.GetDataTable(refMr)
.ToModels();
// reportDataSource = dtb.ToModels(refMr);
CloseCustomAppPool();
return(queryResults);
}
