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) { }
}
