public static MethodReturn RepairDepoRaf(SERVISDEPOLAR depo, string strRaf, decimal servisId) { MethodReturn ret = new MethodReturn(); if (depo == null) { return(ret); } if (strRaf.isNullOrWhiteSpace()) { strRaf = "1.Raf"; } SERVISDEPORAFLAR foundRaf = R.Query <SERVISDEPORAFLAR>(ret).First(t => t.SERVISDEPOID == depo.ID && t.AD == strRaf).createIsNull(); if (ret.ok() && foundRaf.IsNew()) { decimal seqId = Convert.ToDecimal(SasonBase.SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPORAFLAR_SEQ.NEXTVAL from dual", ret)); if (ret.ok()) { foundRaf.ID = seqId; foundRaf.KOD = strRaf; foundRaf.AD = strRaf; foundRaf.SERVISDEPOID = depo.ID; foundRaf.DURUMID = 1; ret = foundRaf.Update(); } } return(ret); }
public override object ExecuteReport(MethodReturn refMr = null) { List <SERVISTEKNISYEN_REPORT_DATA> servisTeknisyenler = R.Query <SERVISTEKNISYEN_REPORT_DATA>(refMr).Where(t => t.SERVISID == ServisId).ToList(); //Tarih Aralığında Personelin Hareketlerini Bul List <TEKNISYENHAREKET> hareketler = R.Query <TEKNISYENHAREKET>(refMr).Where(t => t.GIRISTARIHI.Between(StartDate.startOfDay(), FinishDate.endOfDay()) && t.SERVISTEKNISYENID.In(servisTeknisyenler.select(tks => tks.ID)) && t.DURUM == YeniTeknisyenHareketDurum.Cikis).ToList(); //Bu Hareketlerde Kullanılan İşEmirİşlemleri Çek List <Teknisyen_ViewServisIsEmirIslemIscilikler> iscilikler = Teknisyen_ViewServisIsEmirIslemIscilikler.SelectOverloadFromISLEMID(hareketler.select(t => t.ISEMIRISLEMID).Distinct().toList()); PuantajGunlugu pg = new PuantajGunlugu(); List <ServisGunMola> servisGunMolalari = ServisGunMola.SelectServisGunMolalar(ServisId, refMr); List <HareketNeden> hareketNedenler = HareketNeden.Select_Nedenler(); foreach (SERVISTEKNISYEN_REPORT_DATA servisTeknisyen in servisTeknisyenler) { var teknisyenHareketler = hareketler.where (t => t.SERVISTEKNISYENID == servisTeknisyen.ID).orderBy(t => t.GIRISTARIHI).toList(); List <decimal> teknisyenIslemIds = teknisyenHareketler.select(t => t.ISEMIRISLEMID).Distinct().toList(); var teknisyenIscilikler = iscilikler.where (t => teknisyenIslemIds.contains(t.SERVISISEMIRISLEMID)).toList(); servisTeknisyen.Faturalanan_Dakika = (int)teknisyenIscilikler.Sum(t => t.Iscilik_Dakika_Suresi); List <DateTime> tarihler = teknisyenHareketler.select(t => t.GIRISTARIHI.Date).Distinct().toList(); foreach (var tarih in tarihler) { var firstIn = teknisyenHareketler.where (t => t.GIRISTARIHI.Date == tarih).first().GIRISTARIHI; var lastOut = teknisyenHareketler.where (t => t.GIRISTARIHI.Date == tarih).last().CIKISTARIHI; servisTeknisyen.NetMevcudiyet_Dakika += (int)(lastOut - firstIn).TotalMinutes; } TEKNISYENHAREKET.DAGILIM_SONUCLARI hamPntjData = Puantaj.GetPuantajSonuclari(teknisyenHareketler, pg, servisGunMolalari, hareketNedenler); servisTeknisyen.FiiliCalisma_Dakika = hamPntjData.GetSonucSure(NedenFormati.NormalCalisma); } return(servisTeknisyenler); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = $" = {ServisId}"; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT distinct a.SERVISID, (SELECT vtsx.partnercode FROM vt_servisler vtsx where vtsx.servisid = a.SERVISID and vtsx.dilkod = 'Turkish') as partnercode, (SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = a.SERVISID) as servisad, count(b.servisisemirid) as servisisemiridadedi, to_number ( to_char(KAYITTARIH,'mm')) as ay, to_char(KAYITTARIH, 'Month') as ayadi, to_char(sysdate,'yyyy') as yil FROM servisisemirler a INNER JOIN servisisemirislemler b on a.id=b.servisisemirid WHERE b.isemirtipid=2 AND a.servisid {servisIdQuery} AND to_char(sysdate,'yyyy') = to_char(KAYITTARIH,'yyyy') GROUP BY a.servisid, to_number ( to_char(KAYITTARIH,'mm')), to_char(KAYITTARIH, 'Month') order by 5 desc ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { List <object> reportDataSource = new List <object>(); DataTable dtb = AppPool.EbaTestConnector.CreateQuery(@" SELECT distinct s.id,o.ad,s.isemirno, to_char(s.kayittarih,'dd.mm.yyyy') tarih, S.MUSTERIAD, S.MUSTERITELEFON, T.ISORTAKAD, case when S.KULLANICIID is null then s.okullaniciid else s.kullaniciid end kullanici, t.partnercode, S.ARACTIPAD, s.saseno,R.PLAKA, CASE when O.FILOBUYUKLUKID is null then 1 else 0 end filo,h.servisisortakkontaktipad,no,h.ad kontakad from sason.vt_servisler t,sason.servisisemirler s,sason.vt_servisisortaklar o ,sason.servisvarlikruhsatlar r ,sason.vw_isortakkontakbilgiler h where O.SERVISISORTAKID =S.SERVISISORTAKID and s.servisid=t.servisid and t.dilkod='Turkish' and S.SASENO=R.SASENO and s.kayittarih between {StartDate} and {FinishDate} and t.dilkod=o.dilkod and (s.servisid = {ServisId} or {ServisId} = 1) and O.SERVISISORTAKID=h.servisisortakid(+) and (h.servisisortakkontaktipid=6 or h.servisisortakkontaktipid is null) ") .Parameter("StartDate", StartDate.Date) .Parameter("FinishDate", FinishDate.endOfDay()) .Parameter("ServisId", ServisId) .GetDataTable(refMr); reportDataSource = dtb.ToModels(refMr); CloseCustomAppPool(); return(reportDataSource); }
public override object ExecuteReport(MethodReturn refMr = null) { decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>(); string servisIdQuery = $" = {selectedServisId}"; #if DEBUG selectedServisId = ServisId; servisIdQuery = $" = {selectedServisId}"; #endif MethodReturn mr = new MethodReturn(); List <ReportData> reportDataSource = new List <ReportData>(); List <QueryResult> queryResults = AppPool.EbaTestConnector.CreateQuery($@" select * from (select * from sason.rptable_yedekparcadetay where servisid {servisIdQuery} and tarih between {{startDate}} AND {{finishDate}}) rpt ") .Parameter("startDate", StartDate.startOfDay()) .Parameter("finishDate", FinishDate.endOfDay()) .GetDataTable(mr) .ToModels <QueryResult>(); CloseCustomAppPool(); return(reportDataSource); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = ""; if (ServisIds.isNotEmpty()) { servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) "; } else { servisIdQuery = $" > 1 "; } List <object> reportDataSource = AppPool.EbaTestConnector.CreateQuery($@" SELECT tarihler.tarih, tarihler.yil, tarihler.ay, servis.servisid, servis.isortakad SERVISISORTAKAD, servis.VARLIKAD SERVISVARLIKAD, ags.arac_giris, ags.isemir_acilan, ags.isemir_kapanan FROM (SELECT TARIH, YIL, AY FROM TARIHLER WHERE TARIH BETWEEN {{startDate}} AND {{finishDate}}) tarihler left join vt_servisler servis on servis.servisid {servisIdQuery} and servis.dilkod = 'Turkish' left join mobilags ags on AGS.SERVIS = servis.servisid and AGS.TARIH = tarihler.tarih order by tarihler.tarih, servis.servisid ") .Parameter("startDate", StartDate.startOfDay()) .Parameter("finishDate", FinishDate.endOfDay()) .GetDataTable() .ToModels(); CloseCustomAppPool(); return(reportDataSource); }
public override object ExecuteReport(MethodReturn refMr = null) { decimal selectedServisId = ServisId; string servisIdQuery = $" = {selectedServisId}"; // string dateQuery = ""; decimal selectedReceteId = ReceteIds.first().toString("0").cto <decimal>(); string receteIDQuery = $" = {selectedReceteId}"; if (ReceteIds.isNotEmpty()) { receteIDQuery = $" in ({ReceteIds.joinNumeric(",")}) "; } else { selectedReceteId = 756; receteIDQuery = $" in( {selectedReceteId} )"; } MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT (SELECT vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = b.SERVISID and vtsx.dilkod = 'Turkish') as partnercode, (SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = b.SERVISID ) as servisad, b.*, stok-miktar fark, case when stok-miktar > -1 then 0 when stok-miktar < 0 then (stok-miktar)*kurlar_pkg.malzemefiyatindgetir(malzemeid,1,2) end TUTAR from (SELECT a.*,sason.servisstok(sason.getservisstokid(a.malzemeid,servisid)) stok from ( SELECT l.gkod, l.ad, S.SERVISID, l.malzemeid, MAX (miktar) miktar, b.ad birimad, R.KOD FROM (SELECT * from receteler where id {receteIDQuery} ) r, servisreceteler s, recetemalzemeler m, mt_malzemeler l, vw_birimler b WHERE r.id = m.receteid AND S.RECETEID = r.id AND m.birimid = b.id and b.dilkod='Turkish' and l.malzemeid=m.malzemeid GROUP BY l.gkod, l.ad, l.malzemeid, s.servisid, b.ad ,R.KOD) a where servisid {servisIdQuery} ) b order by kod , ad ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>(); string servisIdQuery = $" = {selectedServisId}"; string dateQuery = ""; #if DEBUG selectedServisId = ServisId; servisIdQuery = $" in( {selectedServisId} )"; #endif if (ServisIds.isNotEmpty()) { servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) "; } else { // servisIdQuery = $" > 1 "; selectedServisId = ServisId; servisIdQuery = $" in( {selectedServisId} )"; } StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" select (select vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = a.servisid and vtsx.dilkod = 'Turkish') as partnercode, (Select vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = a.servisid) as servisad, a.faturaturid, a.faturano, a.islemtarihi, a.cariunvan, a.bruttoplam, a.indirimtoplam, a.netkdvtoplam, a.nettutar, a.toplam, a.carikod, a.vno, a.servisid FROM faturalar a WHERE a.servisid {servisIdQuery} and a.islemtarihi between '{dateQuery}' and a.faturaturid=4 ORDER BY servisad ,a.islemtarihi desc ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = $" = {ServisId}"; string dateQuery = ""; //#if DEBUG // selectedServisId = ServisId; // servisIdQuery = $" in( {selectedServisId} )"; //#endif StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT ssip.SERVISID, (select vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = ssip.SERVISID and vtsx.dilkod = 'Turkish') as partnercode, (Select vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = ssip.SERVISID ) as servisad, isortak.ad, ssip.belgeno SIPARIS_NO, ssip.tarih SIPARIS_TARIHI, srvstok.kod PARCA_NO, srvstok.ad PARCA_AD, ssm.miktar, tdrkneden.kod TEDARIK_NEDEN, srvstok.kod , CASE WHEN orj.orjinalgkod IS NULL THEN srvstok.kod ELSE orj.orjinalgkod END orjinalkod FROM servissiparismlzler ssm INNER JOIN servissiparisler ssip ON ssip.id=SSM.SERVISSIPARISID AND SSIP.siparisSERVISID is null INNER JOIN servisstoklar srvstok ON SSM.SERVISSTOKID=srvstok.id INNER JOIN muadiltedariknedenler tdrkneden ON SSM.MUADILTEDARIKNEDENID = tdrkneden.id INNER JOIN servisisortaklar isortak ON ssip.siparisisortakid=isortak.id LEFT JOIN (SELECT m1.id malzemeid, m1.kod, m1.gkod, m2.kod orjinalkod, m2.gkod orjinalgkod, m1.orjinalmalzemeid FROM malzemeler m1, malzemeler m2 WHERE m1.orjinalmalzemeid = M2.ID) orj ON orj.malzemeid=SRVSTOK.MALZEMEID WHERE SSM.MUADILTEDARIKNEDENID is not null AND ssip.SERVISID {servisIdQuery} AND ssip.tarih between '{dateQuery}' ORDER BY ssip.SERVISID ,ssip.tarih desc ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = ""; decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>(); if (ServisIds.isNotEmpty()) { servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) "; } else { // servisIdQuery = $" > 1 "; selectedServisId = ServisId; servisIdQuery = $" in( {selectedServisId} )"; } List <object> reportDataSource = AppPool.EbaTestConnector.CreateQuery($@" select --ie.id ISEMIR_ID, srv.ISORTAKAD SERVIS_AD, srv.partnercode SERVIS_PARTNER_KOD, ie.isemirno ISEMIR_NO, ie.KAYITTARIH ISEMIR_KAYITTARIHI, ie.TAMAMLANMATARIH ISEMIR_TAMAMLANMA_TARIHI, ie.saseno ISEMIR_SASENO --,iei.ID ISEMIR_ISLEM_ID ,atip.kod GARANTI_KODU, atip.ad GARANTI_TIPI ,ay.ARIZAKODU AYR_ARIZAKODU, ay.CLAIMNO AYR_CLAIMNO, AY.ESAGARANTINO AYR_ESA_GARANTINO, AY.SERVISGARANTINO AYR_SERVIS_GARANTI_NO, AY.PDFGARANTINO AYR_PDF_GARANTI_NO ,mlz.KOD MALZEME_KODU, mlz.AD MALZEME_ADI, MLZ.MIKTAR MALZEME_MIKTAR, MLZ.BIRIM_AD MALZEME_BIRIM_AD from (select * from servisisemirler where TAMAMLANMATARIH BETWEEN {{startDate}} AND {{finishDate}} and TEKNIKOLARAKTAMAMLA = 1 AND SERVISID {servisIdQuery}) ie left join vt_servisler srv on srv.dilkod = 'Turkish' and srv.servisid = ie.servisid -- AYRISTIRMA TIPLER left join vw_ayristirmatipler atip on atip.id not in (1,2) and atip.dilkod = 'Turkish' -- SERVIS ISEMIR ISLEMLER left join servisisemirislemler iei on iei.servisisemirid = ie.id -- AYRISTIRMALAR inner join ayristirmalar ay on ay.ayristirmatipid = atip.id and AY.SERVISISEMIRISLEMID = iei.id -- MALZEMELER inner join ( select a.id AYRISTIRMAID, 1 GROUPID, 'MALZEME' GROUPNAME, st.kod KOD, st.ad AD, ad.miktar MIKTAR, brm.ad BIRIM_AD, ad.gtutar TUTAR, AD.PDFMIKTAR, AD.PDFNETFIYAT, AD.PDFISLETIMUCRETI, AD.PDFONAYLANANYUZDE, AD.PDFTOPLAM, AD.PDFPARABIRIMID from ayristirmalar a, ayristirmadetaylar ad, servisismislemmalzemeler im, servisstoklar st, vw_birimler brm where AD.AYRISTIRMAID(+) = a.id and ad.turid = 1 --malzeme and im.id(+) = ad.referansid and st.id(+)= im.servisstokid and brm.id(+) = st.birimid and BRM.DILKOD(+) = 'Turkish' ) mlz on mlz.ayristirmaid = ay.ID ") .Parameter("startDate", StartDate.startOfDay()) .Parameter("finishDate", FinishDate.endOfDay()) .GetDataTable() .ToModels(); CloseCustomAppPool(); return(reportDataSource); }
public override object ExecuteReport(MethodReturn refMr = null) { string dateQuery = ""; StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT V.Ad, A.Saseno, Bgrup.Kod AS Bakim_Grubu, Bst.Kod AS Sozlesme_Tipi, Bksoz.Bastarih AS Baslangic_Tarihi, Bksoz.Bittarih AS Bitis_Tarihi, Bksoz.Bakimadedi, Bksoz.Oncekibakimadedi, Bksoz.Kullanilan, Bksoz.Tutar, Pb.Kod , (CASE WHEN Bksoz.Durumid=1 THEN 'AKTIF' ELSE 'PASIF' END) AS Sozlesme_Durum, Bksoz.Km, Bksoz.Saat, Bksoz.Litre FROM Bakimsozlesmeler Bksoz, Bakimgruplar Bgrup, Araclar A, Bakimsozlesmetipler Bst, Varliklar V, Parabirimler Pb WHERE Bksoz.Bakimgrupid=Bgrup.Id AND A.Id=Bksoz.Aracid AND Bksoz.Bakimsozlesmetipid=Bst.Id AND Bksoz.Varlikid=V.Id AND Pb.Id=Bksoz.Parabirimid AND (A.Saseno = NVL('{SaseNo}', A.Saseno)) AND Bksoz.Bastarih BETWEEN '{dateQuery}' ORDER BY Bksoz.Id DESC ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public static void ModifyDepolar(MethodReturn refMr, decimal servisId, List <string> depolar) { foreach (string depo in depolar) { CheckAndGetDefaultDepo(refMr, servisId, depo); if (refMr.error()) { break; } } }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = ""; if (ServisIds.isNotEmpty()) { servisIdQuery = $"in ({ServisIds.joinNumeric(",")})"; } else { servisIdQuery = $">1"; } List <ReportData> reportDataSource = new List <ReportData>(); List <RowData> rowDataSource = AppPool.EbaTestConnector.CreateQuery($@" SELECT tarihler.tarih, servis.PARTNERCODE, servis.servisid, servis.isortakad SERVISISORTAKAD, servis.VARLIKAD SERVISVARLIKAD, ags.arac_giris, ags.isemir_acilan, ags.isemir_kapanan FROM (SELECT TARIH, YIL, AY FROM TARIHLER WHERE TARIH BETWEEN {{startDate}} AND {{finishDate}}) tarihler left join vt_servisler servis on servis.servisid {servisIdQuery} and servis.dilkod = 'Turkish' left join mobilags ags on AGS.SERVIS = servis.servisid and AGS.TARIH = tarihler.tarih order by tarihler.tarih, servis.servisid ") .Parameter("startDate", StartDate.startOfDay()) .Parameter("finishDate", FinishDate.endOfDay()) .GetDataTable() .ToModels <RowData>(); foreach (RowData data in rowDataSource) { int ay = data.TARIH.Month; int yil = data.TARIH.Year; ReportData reportData = reportDataSource.first(t => t.ServisId == data.SERVISID && t.Yil == yil); if (reportData.isNull()) { reportData = new ReportData() { PartnerCode = data.PARTNERCODE, ServisId = data.SERVISID, ServisAdi = data.SERVISISORTAKAD, ServisVarlikAdi = data.SERVISVARLIKAD, Yil = data.TARIH.Year, }; reportDataSource.add(reportData); } reportData.SetPropertyValue($"AIS{ay}", reportData.GetPropertyValue <decimal>($"AIS{ay}") + data.ISEMIR_ACILAN); reportData.SetPropertyValue($"KIS{ay}", reportData.GetPropertyValue <decimal>($"KIS{ay}") + data.ISEMIR_KAPANAN); reportData.SetPropertyValue($"AGS{ay}", reportData.GetPropertyValue <decimal>($"AGS{ay}") + data.ARAC_GIRIS); } CloseCustomAppPool(); return(reportDataSource); }
public override object ExecuteReport(MethodReturn refMr = null) { decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>(); string servisIdQuery = $" = {selectedServisId}"; #if DEBUG selectedServisId = ServisId; servisIdQuery = $" = {selectedServisId}"; #endif if (ServisIds.isNotEmpty()) { servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) "; } else { // servisIdQuery = $" > 1 "; selectedServisId = ServisId; servisIdQuery = $" in( {selectedServisId} )"; } List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT vt.isortakad servis_adi, vt.partnercode servis_kodu, a.isemirno, a.tamamlanmatarih, sv.ad musteri_adi, a.tutar FROM servisisemirler a, servisvarliklar sv, vt_servisler vt WHERE a.servisid {servisIdQuery} AND a.teknikolaraktamamla=1 AND vt.servisid=a.servisid AND vt.dilkod='Turkish' AND a.tutar>0 AND a.servisvarlikid=sv.id AND a.isemirno not in (SELECT DISTINCT isemirno FROM ayristirmalar) ORDER BY vt.servisid ASC, a.tamamlanmatarih DESC ") .GetDataTable() .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { string dateQuery = ""; StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT EXTRECALLNUM AS HARICI_NO, INTRECALLNUM AS DAHLI_NO, WARRANTYCLAIMTYPE AS GARANTI_TIPI, REFDATE AS BASLANGIC_TARIHI, RECALLVALIDTO AS BITIS_TARIHI, WARRANTYCLAIMNUM AS GARANTI_NUMARASI, --TXTTABLECOUNTER, DocAppendix AS DOKUMAN_LINKI, DamageCode AS ARIZA_KODU, SIShortText AS KISA_ACIKLAMA, --WarrantyClaimType, Priority AS ONCELIK FROM MX_VIS_SERVICEINFODETAILS a WHERE refdate IS NOT NULL and extrecallnum not in (SELECT refaksiyonid FROM aksiyonlar WHERE refaksiyonid is not null) GROUP BY EXTRECALLNUM, INTRECALLNUM, WARRANTYCLAIMTYPE, REFDATE, RECALLVALIDTO, WARRANTYCLAIMNUM, TXTTABLECOUNTER, DocAppendix, DamageCode, SIShortText, WarrantyClaimType, Priority ORDER BY 1 DESC ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = $" = {ServisId}"; string dateQuery = ""; #if DEBUG servisIdQuery = $" = {ServisId}"; #endif StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT SUM(AIES) AS AIES , sum(KIES) AS KIES , servisid, partnercode , servisad , KAYITTARIH FROM ( SELECT max(acikadet) as AIES, max(kapanan_adet) as KIES, servisid, (SELECT vtsx.partnercode from vt_servisler vtsx WHERE vtsx.servisid = dsf.servisid and vtsx.dilkod = 'Turkish') as partnercode, (SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy WHERE vtsxy.dilkod = 'Turkish' and vtsxy.servisid = dsf.servisid) as servisad, to_char(KAYITTARIH,'dd/mm/yyyy') as KAYITTARIH FROM (SELECT count(id) acikadet,null kapanan_adet ,servisid,KAYITTARIH FROM servisisemirler WHERE KAYITTARIH BETWEEN '{dateQuery}' AND servisid {servisIdQuery} group by servisid,KAYITTARIH union all SELECT null acikadet ,count(id)kapanan_adet,servisid,TAMAMLANMATARIH FROM servisisemirler WHERE TAMAMLANMATARIH BETWEEN '{dateQuery}' AND servisid {servisIdQuery} group by servisid,TAMAMLANMATARIH) dsf group by servisid,KAYITTARIH ) GROUP BY servisid, partnercode , servisad , KAYITTARIH order by servisid,to_date(KAYITTARIH) desc ") .GetDataTable() .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = $" = {ServisId}"; string dateQuery = ""; StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT (SELECT vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = d.servisid and vtsx.dilkod = 'Turkish') as partnercode, (SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = d.servisid) as servisad, f.netkdvtoplam, f.nettutar, f.netkdvtoplam+f.nettutar toplam, D.FATURANO, D.SERVISID, D.SERVISISEMIRID, D.SERVISISORTAKID, F.ACIKLAMA, F.ADRES, F.BRUTTOPLAM, F.CARIUNVAN, F.IL, F.ILCE, F.VERGIDAIRESI, F.VNO, F.ILGILIKISI, F.ILGILIKISITELNO, F.IRSALIYENO, to_char(F.IRSALIYETARIHI,'dd/mm/yyyy') as IRSALIYETARIHI, F.ISLEMTARIHI, (SELECT zx.ISEMIRNO FROM servisisemirler zx where zx.id = d.SERVISISEMIRID) as ISEMIRNO FROM sason.servisdishizmetalimlar d, sason.faturalar f WHERE d.faturaid = f.id AND F.ISLEMTARIHI BETWEEN '{dateQuery}' AND d.servisid {servisIdQuery} ORDER BY F.islemtarihi desc ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public MethodReturn DeserializeMethodReturn(byte[] input, Type returnType) { JToken t; JObject obj = this.ToJsonObject(input); MethodReturn methodReturn = new MethodReturn(); if (obj.TryGetValue("ReturnValue", out t)) methodReturn.ReturnValue = t.ToObject(returnType, jsonSerializer); var ex = obj.TryGetValue("Exception", out t) ? t.ToObject<string>() : null; if (!string.IsNullOrEmpty(ex)) methodReturn.Exception = new Exception(ex); return methodReturn; }
public override object ExecuteReport(MethodReturn refMr = null) { MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT a.SERVISID, MAX(a.id) maxid, b.teknisyenid, a.giristarihi, a.CIKISTARIHI, a.ISEMIRISLEMID, a.ISEMIRID, concat(concat(c.ad,' ') ,c.soyad) as adsoyad, sse.ISEMIRNO, sse.SASENO, sse.plaka, SSE.KAYITTARIH, SSE.MUSTERIAD, CASE WHEN a.CIKISTARIHI > '01.01.2000' THEN cast(EXTRACT(MINUTE FROM (a.CIKISTARIHI - a.giristarihi) DAY TO SECOND)|| ' dk ' as NVARCHAR2(50)) ELSE cast('Devam Ediyor...'as NVARCHAR2(50)) END as Durum, (SELECT isem.aciklama FROM servisisemirler isem WHERE isem.id = a.ISEMIRID) as emir, (SELECT isemis.aciklama FROM servisisemirislemler isemis WHERE isemis.id = (SELECT isemx.id FROM servisisemirler isemx WHERE isemx.id = a.ISEMIRID )) as islem FROM teknisyenhareket a INNER JOIN servisteknisyenler b ON b.servisid = a.servisid and b.id = a.servisteknisyenid INNER JOIN teknisyenler c ON c.id = b.teknisyenid INNER JOIN THRKNEDEN d ON d.id = a.girisnedenid INNER JOIN THRKNEDEN dx ON dx.id = a.cikisnedenid INNER JOIN servisisemirler sse ON sse.id = a.ISEMIRID WHERE a.SERVISID = {{ServisId}} and a.id = (SELECT MAX(xx.id) FROM teknisyenhareket xx WHERE xx.servisteknisyenid = a.servisteknisyenid) GROUP BY a.SERVISID, a.id, b.teknisyenid, a.giristarihi, a.CIKISTARIHI, A.ISEMIRISLEMID, a.ISEMIRID, c.ad, c.soyad, sse.ISEMIRNO, sse.SASENO, sse.plaka, SSE.KAYITTARIH, SSE.MUSTERIAD ORDER BY a.SERVISID, c.ad, c.soyad, a.id DESC ") .Parameter("ServisId", ServisId) .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public static List <Teknisyen_ViewServisIsEmirIslemler> Select_IsEmir_Islemler_View(decimal ownerIsEmirId, decimal servisTeknisyenId) { MethodReturn mr = new MethodReturn(); List <Teknisyen_ViewServisIsEmirIslemler> servisIsEmirIslemler = R.Query <Teknisyen_ViewServisIsEmirIslemler>(mr).Where(t => t.SERVISISEMIRID == ownerIsEmirId).ToList(); List <HareketUstBilgi> isEmir_UstHareketBilgileri = HareketUstBilgi.Select_IsEmir_UstHareketBilgileri(ownerIsEmirId, mr); List <TeknisyenHareket> isEmir_TeknisyenHareketleri = TeknisyenHareket.Select_IsEmir_TeknisyenHareketleri(ownerIsEmirId, mr); List <Teknisyen_ViewServisIsEmirIslemIscilikler> isEmir_Iscilikleri = Teknisyen_ViewServisIsEmirIslemIscilikler.Select_IsEmir_Iscilikleri(ownerIsEmirId); decimal servisId = isEmir_UstHareketBilgileri.first().SERVISID; List <ServisGunMola> servis_gun_molalar = ServisGunMola.SelectServisGunMolalar(servisId); List <HareketNeden> nedenler = HareketNeden.Select_Nedenler(); PuantajGunlugu pg = new PuantajGunlugu(); pg.InitNedenler(nedenler); servisIsEmirIslemler.forEach(islem => { List <HareketUstBilgi> islem_UstBilgileri = isEmir_UstHareketBilgileri.where (t => t.ISEMIRISLEMID == islem.ID).toList(); List <TeknisyenHareket> islem_TeknisyenHareketleri = null; List <TeknisyenHareket> servisTeknisyenHareketleri = null; islem.TeknisyenIsDurumu = LocalHelpers.GetTeknisyenDurum(servisTeknisyenId, isEmir_TeknisyenHareketleri, islem_UstBilgileri, out islem_TeknisyenHareketleri, out servisTeknisyenHareketleri);; var iscilikler = isEmir_Iscilikleri.where (t => t.SERVISISEMIRISLEMID == islem.ID).toList(); islem.ToplamIscilikSayisi = iscilikler.count(); if (islem_TeknisyenHareketleri.isNotEmpty()) { islem.CalisilanSure = servisTeknisyenHareketleri.Sum(t => t.CalismaDakika); } if (islem_UstBilgileri.isNotEmpty()) { islem.PlanlananSure = islem_UstBilgileri.Sum(t => t.PLANLANANSURE); } TeknisyenHareketDagilimSonuclari puantajSonuclari = Puantaj.GetPuantajSonuclari(islem_TeknisyenHareketleri, pg, servis_gun_molalar, nedenler); islem.CalisilanSure = puantajSonuclari.GetSonucSure(NedenFormati.NormalCalisma); islem.TeknisyenSure = puantajSonuclari.GetSonucSure(servisTeknisyenId, NedenFormati.NormalCalisma); }); return(servisIsEmirIslemler); }
public override void HandleMethodCall(MethodCall method_call) { //object retVal = obj.GetType ().InvokeMember (method_call.Member, BindingFlags.InvokeMethod, null, obj, new object[0]); //IDynamicMetaObjectProvider idyn = obj as IDynamicMetaObjectProvider; object retVal = null; Exception raisedException = null; try { object[] args = MessageHelper.GetDynamicValues (method_call.message); retVal = ops.InvokeMember (obj, method_call.Member, args); //retVal = ops.Call (ops.GetMember (obj, method_call.Member), args); } catch (Exception e) { raisedException = e; } if (!method_call.message.ReplyExpected) return; Message msg = method_call.message; Message replyMsg = null; if (raisedException == null) { MethodReturn method_return = new MethodReturn (msg.Header.Serial); replyMsg = method_return.message; if (retVal != null) { if (retVal.GetType ().FullName == "IronRuby.Builtins.MutableString") retVal = retVal.ToString (); // TODO: Invalid sig handling Signature outSig = Signature.GetSig (retVal.GetType ()); MessageWriter retWriter = new MessageWriter (); retWriter.Write (retVal.GetType (), retVal); //retWriter.WriteValueType (retVal, retVal.GetType ()); replyMsg.Body = retWriter.ToArray (); replyMsg.Signature = outSig; } } else { Error error = method_call.CreateError (Mapper.GetInterfaceName (raisedException.GetType ()), raisedException.Message); replyMsg = error.message; } if (method_call.Sender != null) replyMsg.Header[FieldCode.Destination] = method_call.Sender; conn.Send (replyMsg); }
public static SERVISDEPOLAR CheckAndGetDefaultDepo(MethodReturn refMr, decimal servisId, string depoAdi = "") { refMr = refMr.createIsNull(); string writeDepoKodu = "001"; string writeDepoAdi = "Ana Depo"; SERVISDEPOLAR defaultDepo = null; if (depoAdi.isNullOrWhiteSpace()) { defaultDepo = Select.OrderBy(t => t.KOD).First(t => t.SERVISID == servisId); } else { writeDepoKodu = depoAdi; writeDepoAdi = depoAdi; defaultDepo = Select.First(t => t.AD == writeDepoAdi && t.SERVISID == servisId); } if (defaultDepo.isNull()) { decimal seqId = Convert.ToDecimal(SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPOLAR_SEQ.NEXTVAL from dual", refMr)); if (refMr.ok()) { defaultDepo = new SERVISDEPOLAR() { ID = seqId, KOD = writeDepoKodu, // "001", AD = writeDepoAdi, // "Ana Depo", SERVISDEPOGRUPID = null, DEPOTIPID = 0, RAFSIZ = 0, DURUMID = 1, SERVISID = servisId, }; refMr = defaultDepo.Update(); } if (refMr.error()) { defaultDepo = null; } } return(defaultDepo); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = $" = {ServisId}"; string dateQuery = ""; StartDate = StartDate.startOfDay(); FinishDate = FinishDate.endOfDay(); dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + ""; MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT DISTINCT b.servisid, (select vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = b.servisid and vtsx.dilkod = 'Turkish') as partnercode, (Select vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = b.servisid) as servisad, d.kod, d.ad, a.miktar, br.ad BIRIM, A.BIRIMFIYAT ALIS_FIYATI, b.TARIH, f.faturano, KURLAR_PKG.CAPRAZKURTARIH (2, 1, b.TARIH) kur, kurlar_pkg.servisstokfiyatgetir (d.id, 2, TRUNC (SYSDATE)) as EUROLISTEFIYAT, KURLAR_PKG.STOKFIYATINDGETIR (d.id, 2, 2, 1,0) as EUROINDFIYAT FROM servisstokhareketdetaylar a INNER JOIN servisstokhareketler b on B.ID = A.SERVISSTOKHAREKETID and b.parabirimid=1 INNER JOIN servissiparisler c on c.id=b.servissiparisid and c.siparisservisid=1 INNER JOIN servisstoklar d on d.id = A.SERVISSTOKID INNER JOIN faturalar f on f.id=b.faturaid INNER JOIN vw_birimler br on br.id=a.birimid and br.dilkod='Turkish' INNER JOIN servisdeporaflar dr ON d.servisdeporafid = dr.id INNER JOIN servisstokturler sst ON sst.id = d.servisstokturid WHERE a.stokislemtipdeger=1 and b.servisid {servisIdQuery} AND b.TARIH between '{dateQuery}' ORDER BY b.servisid , b.TARIH desc ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { decimal selectedBakimTuruId = BakimTuruIds.first().toString("0").cto <decimal>(); string bakimTuruIdQuery = $" = {selectedBakimTuruId}"; if (BakimTuruIds.isNotEmpty()) { bakimTuruIdQuery = $" in ({BakimTuruIds.joinNumeric(",")}) "; } else { selectedBakimTuruId = 21; bakimTuruIdQuery = $" in( {selectedBakimTuruId} )"; } MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT bgrup.ID, bgrup.kod, klm.ad KONTROL_TALIMATI, klm.durumad DURUM, knt.sure, knt.periyot KONTROL_PERIYODU, bgrup.endeks, bgrup.kilometre, bgrup.saat, BGRUP.GUN FROM bakimgrupkontroller knt, bakimgruplar bgrup, vw_BAKIMKONTROLKALEMLER klm WHERE KNT.BAKIMGRUPID=bgrup.id and KNT.BAKIMKONTROLKALEMID = klm.id and KNT.DURUMID = 1 AND klm.dilkod='Turkish' AND bgrup.ID {bakimTuruIdQuery} ORDER BY bgrup.kod, klm.ad ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public static List <Teknisyen_ViewServisIsEmirler> Select_Servis_IsEmirler_View(decimal servisId, decimal servisTeknisyenId) { MethodReturn mr = new MethodReturn(); List <Teknisyen_ViewServisIsEmirler> servis_IsEmirleri = R.Query <Teknisyen_ViewServisIsEmirler>().Where(t => t.SERVISID == servisId && t.TEKNIKOLARAKTAMAMLA == 0).ToList(); List <decimal> isEmirIds = servis_IsEmirleri.select(t => t.ID).ToList(); List <HareketUstBilgi> servis_UstHareketBilgileri = HareketUstBilgi.Select_IsEmirler_UstHareketBilgileri(isEmirIds); List <TeknisyenHareket> servis_TeknisyenHareketleri = TeknisyenHareket.Select_IsEmirler_TeknisyenHareketleri(isEmirIds); List <Teknisyen_ViewServisIsEmirIslemler> servis_IsEmirIslemleri = Teknisyen_ViewServisIsEmirIslemler.Select_IsEmirler_Islemler(isEmirIds); List <Teknisyen_ViewServisIsEmirIslemIscilikler> servis_IsEmirIslem_Iscilikleri = Teknisyen_ViewServisIsEmirIslemIscilikler.Select_IsEmirler_Iscilikleri(isEmirIds); List <ServisGunMola> servis_Gun_Molalar = ServisGunMola.SelectServisGunMolalar(servisId); List <HareketNeden> nedenler = HareketNeden.Select_Nedenler(); PuantajGunlugu pg = new PuantajGunlugu(); pg.InitNedenler(nedenler); servis_IsEmirleri.forEach(isemir => { List <HareketUstBilgi> isEmir_ustBilgileri = servis_UstHareketBilgileri.Where(t => t.ISEMIRID == isemir.ID).toList(); List <TeknisyenHareket> isEmir_TeknisyenHareketleri = null; List <TeknisyenHareket> servisTeknisyenHareketleri = null; isemir.TeknisyenIsDurumu = LocalHelpers.GetTeknisyenDurum(servisTeknisyenId, servis_TeknisyenHareketleri, isEmir_ustBilgileri, out isEmir_TeknisyenHareketleri, out servisTeknisyenHareketleri); if (isEmir_TeknisyenHareketleri.isNotEmpty()) { isemir.IlkHareketTarihi = isEmir_TeknisyenHareketleri.Min(t => t.GIRISTARIHI); isemir.SonHareketTarihi = isEmir_TeknisyenHareketleri.OrderByDescending(t => t.GIRISTARIHI).first().AktifCikisTarih; } if (isEmir_ustBilgileri.isNotEmpty()) { isemir.PlanlananSure = isEmir_ustBilgileri.Sum(t => t.PLANLANANSURE); } TeknisyenHareketDagilimSonuclari puantajSonuclari = Puantaj.GetPuantajSonuclari(isEmir_TeknisyenHareketleri, pg, servis_Gun_Molalar, nedenler); isemir.CalisilanSure = puantajSonuclari.GetSonucSure(NedenFormati.NormalCalisma);// isEmir_TeknisyenHareketleri.Sum(t => t.CalismaDakika); isemir.TeknisyenSure = puantajSonuclari.GetSonucSure(servisTeknisyenId, NedenFormati.NormalCalisma); }); return(servis_IsEmirleri.orderByDesc(t => t.TeknisyenDurumResim).toList()); }
public async Task <IMethodInvocationResult> InterceptAsync(IAsyncMethodInvocation methodInvocation) { // BEFORE the target method execution var methodInput = CreateMethodInput(methodInvocation); var(msgInputLog, correlationState) = _methodLogMessageFactory.CreateInputMethodLogMessage(methodInput); _logger.Info(msgInputLog); try { // Yield to the next module in the pipeline var result = await methodInvocation.InvokeNextAsync().ConfigureAwait(false); // AFTER the target method execution var methodReturn = new MethodReturn { ReturnValue = result.ReturnValue }; if (methodInvocation.ActualReturnType.Name == "Void") { methodReturn.ReturnValue = "Void"; } var msgOutputLog = _methodLogMessageFactory.CreateOutputMethodLogMessage(methodReturn, correlationState); _logger.Info(msgOutputLog); return(result); } catch (Exception e) { var methodReturn = new MethodReturn { Exception = e }; var msgOutputLog = _methodLogMessageFactory.CreateOutputMethodLogMessage(methodReturn, correlationState); _logger.Error(msgOutputLog); throw; } }
public override object ExecuteReport(MethodReturn refMr = null) { // string dateQuery = ""; decimal selectedAgretaId = AgretaIds.first().toString("0").cto <decimal>(); string agretaIdQuery = $" = {selectedAgretaId}"; if (AgretaIds.isNotEmpty()) { agretaIdQuery = $" in ({AgretaIds.joinNumeric(",")}) "; } else { selectedAgretaId = 4; agretaIdQuery = $" in( {selectedAgretaId} )"; } MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT AGR.AD AGREGA_ADI, Q.AD AGREGA_OZELLIK, T.AD AGREGA_TIPI, TIP.DEGER KULLANILACAK_DEGER FROM VW_AGREGATIPLER T LEFT JOIN vw_agregalar agr ON T.AGREGAID = AGR.ID LEFT JOIN AGREGATIPOZELLIKLER tip ON TIP.AGREGATIPID= t.id LEFT JOIN vw_AGREGAOZELLIKLER q ON Q.ID= TIP.AGREGAOZELLIKID WHERE agr.dilkod='Turkish' and Q.DILKOD = 'Turkish' and t.dilkod = 'Turkish' AND AGR.ID {agretaIdQuery} ORDER BY AGR.AD ,Q.AD , T.AD ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT DISTINCT vm.vin as SASE_NO, vm.vehiclenum as KISA_SASE, SVR.PLAKA as PLAKA, vm.modelnum ARAC_MODEL, vm.variant VARYANT, vm.exworksdate FABRIKA_CIKIS_TARIHI, vm.firstregdate TRAFIGE_CIKIS_TARIHI, vm.vehicleregdate RUHSAT_TARIHI, vm.lastvisitdate SON_SERVIS_ZIYARET_TARIHI, vm.wheelstrack, vm.overhang, vm.doorkeynum KAPI_KILIT_NUMARASI, vm.vehicledes ARAC_TIP_VARYANT, vm.vehicledescavis ARAC_TIPI, vm.vehicletype ARAC_TIPI, vm.motbr MOTOR_TIPI, vm.schadstkl MOTOR_NORMU, vm.vehiclekm ARAC_KM, vm.assetmanuf URETICI FROM VX_VIS_VEHICLEMASTER vm, servisvarlikruhsatlar svr, esaaraclar ea WHERE vm.vin is not null and vm.vin=svr.saseno and EA.ID=VM.ESAARACID and (ea.vin = NVL ('{SaseNo}', ea.vin)) ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { List <object> reportDataSource = new List <object>(); DataTable dtb = AppPool.EbaTestConnector.CreateQuery(@" select a.*,b.kod from sason.faturalar a,sason.faturaturler b where a.servisid = {ServisId} and a.islemtarihi between {StartDate} and {FinishDate} and a.faturaturid=4 and a.faturaturid=b.id ") .Parameter("StartDate", StartDate.Date) .Parameter("FinishDate", FinishDate.endOfDay()) .Parameter("ServisId", ServisId) .GetDataTable(refMr); reportDataSource = dtb.ToModels(refMr); CloseCustomAppPool(); return(reportDataSource); }
public override object ExecuteReport(MethodReturn refMr = null) { string servisIdQuery = $" = {ServisId}"; //#if DEBUG // selectedServisId = ServisId; // servisIdQuery = $" in( {selectedServisId} )"; //#endif MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT vt.isortakad servis_adi, vt.partnercode servis_kodu, a.isemirno, a.tamamlanmatarih, sv.ad musteri_adi, a.tutar FROM servisisemirler a, servisvarliklar sv, vt_servisler vt WHERE a.servisid {servisIdQuery} AND a.teknikolaraktamamla=1 AND vt.servisid=a.servisid AND vt.dilkod='Turkish' AND a.tutar>0 AND a.servisvarlikid=sv.id AND a.isemirno not in (SELECT DISTINCT isemirno FROM ayristirmalar) ORDER BY vt.servisid ASC, a.tamamlanmatarih DESC ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { decimal selectedBakimTuruId = BakimTuruIds.first().toString("0").cto <decimal>(); string bakimTuruIdQuery = $" = {selectedBakimTuruId}"; if (BakimTuruIds.isNotEmpty()) { bakimTuruIdQuery = $" in ({BakimTuruIds.joinNumeric(",")}) "; } else { selectedBakimTuruId = 40; bakimTuruIdQuery = $" in( {selectedBakimTuruId} )"; } MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT DISTINCT a.saseno, a.bakimgrupkod BAKIM_GRUBU , a.bakimgrupad BAKIM_GRUBU_ADI, a.bakimturkod BAKIM_KONTROL_TURU, a.endeks, a.kilometre, a.endeks LITRE, a.saat, a.gun FROM mt_aracbakimgruplar a INNER JOIN bakimgruplar b on b.kod = a.bakimgrupkod WHERE saseno = NVL ('{SaseNo}', a.saseno) AND b.id {bakimTuruIdQuery} ORDER BY a.bakimgrupkod, a.bakimgrupad ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public override object ExecuteReport(MethodReturn refMr = null) { // string dateQuery = ""; decimal selectedAgretaId = AgretaIds.first().toString("0").cto <decimal>(); string agretaIdQuery = $" = {selectedAgretaId}"; if (AgretaIds.isNotEmpty()) { agretaIdQuery = $" in ({AgretaIds.joinNumeric(",")}) "; } else { selectedAgretaId = 4; agretaIdQuery = $" in( {selectedAgretaId} )"; } MethodReturn mr = new MethodReturn(); List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@" SELECT AGR.ID, AGR.AD AGREGA_ADI, t.kod AGREGA_KODU, T.AD AGREGA_TIPI, t.durumad DURUM FROM vw_agregalar agr, VW_AGREGATIPLER t WHERE T.AGREGAID = AGR.ID AND AGR.ID {agretaIdQuery} AND agr.dilkod='Turkish' AND t.dilkod = 'Turkish' ORDER BY 1 DESC ") .GetDataTable(mr) .ToModels(); CloseCustomAppPool(); return(queryResults); }
public byte[] SerializeMethodReturn(MethodReturn methodReturn) { var wrapper = new MethodReturnWrapper(); wrapper.ReturnValue = methodReturn.ReturnValue; wrapper.Exception = methodReturn.Exception != null ? methodReturn.Exception.Message : null; return this.ToJsonBytes(wrapper); }
public static Message ConstructReply(MethodCall method_call, params object[] vals) { MethodReturn method_return = new MethodReturn (method_call.message.Header.Serial); Message replyMsg = method_return.message; Signature inSig = Signature.GetSig (vals); if (vals != null && vals.Length != 0) { MessageWriter writer = new MessageWriter (Connection.NativeEndianness); foreach (object arg in vals) writer.Write (arg.GetType (), arg); replyMsg.Body = writer.ToArray (); } //TODO: we should be more strict here, but this fallback was added as a quick fix for p2p if (method_call.Sender != null) replyMsg.Header[FieldCode.Destination] = method_call.Sender; replyMsg.Signature = inSig; //replyMsg.WriteHeader (); return replyMsg; }
public static Message ConstructDynamicReply(MethodCall method_call, MethodInfo mi, object retVal, object[] vals) { Type retType = mi.ReturnType; MethodReturn method_return = new MethodReturn (method_call.message.Header.Serial); Message replyMsg = method_return.message; Signature outSig = Signature.GetSig (retType); outSig += Signature.GetSig (Mapper.GetTypes (ArgDirection.Out, mi.GetParameters ())); if (outSig != Signature.Empty) { MessageWriter writer = new MessageWriter (Connection.NativeEndianness); //first write the return value, if any if (retType != null && retType != typeof (void)) writer.Write (retType, retVal); //then write the out args WriteDynamicValues (writer, mi.GetParameters (), vals); replyMsg.Body = writer.ToArray (); } //TODO: we should be more strict here, but this fallback was added as a quick fix for p2p if (method_call.Sender != null) replyMsg.Header[FieldCode.Destination] = method_call.Sender; replyMsg.Signature = outSig; return replyMsg; }