private void TestGlob(object source, ElapsedEventArgs e) { Common.PageBase p = new Common.PageBase(); p.Insert("insert into test(note) values('bn tst')"); // p.Alarme_Entrer_zone_interdite(); // p.Alarme_Sortie_zone_interdite(); }
public void histo_arret() { try { List <string> tab = new List <string>(); string re = " drop table temp_runk select * into temp_runk from tts_runk2 " + " select case when aff.contact = 0 then 'Arret' else 'depart' end as Etat, aff.imei,p.personnelid,vp.vehiculeid , " + " aff.date as date1 ,aff2.date as date2, aff2.adress as depart , " + " aff.adress as arrive, DATEDIFF(minute, aff2.date,aff.date) " + " from (select *, ROW_NUMBER() over(order by runk) as n from temp_runk rn) aff " + " left outer join (select *, ROW_NUMBER() over(order by runk) as n from temp_runk rn )aff2 " + " on aff2.imei = aff.imei and aff.n = aff2.n+1 " + " inner join boitier b on b.imei=aff.imei " + " inner join affectation_vehicule_boitier avb on avb.boitierid=b.boitierid " + " inner join vehicule_personnel vp on vp.vehiculeid=avb.vehiculeid " + " inner join personnel p on p.personnelid=vp.personnelid " + " where aff.date > DATEADD (HOUR,-24,CURRENT_TIMESTAMP) "; SqlDataReader dr = pp.Select(re); while (dr.Read()) { if (dr[0].ToString() == "Arret" && dr[8] != null && dr[8].ToString() != "" && dr[5] != null && dr[5].ToString() != "") { tab.Add("('" + dr[6].ToString() + "','" + dr[5].ToString() + "'," + dr[8].ToString() + "," + dr[3].ToString() + "," + dr[2].ToString() + ")"); } } dr.Close(); if (tab.Count > 0) { string req = "insert into Historique_Arret(localiisation ,date,duree,vehiculeid,personnelid ) values "; for (int i = 0; i < tab.Count; i++) { req = req + tab[i]; if (i + 1 != tab.Count) { req = req + " , "; } } pp.Insert(req); } } catch (Exception ee) { } }