private void btnRech_Click(object sender, EventArgs e)
{
Fcts_DB.AffichNRech(
"select i.id_intervention, m.id_mat, i.dateInter, i.com, m.nom, t.nom as nomType, c.nom as nomClient, s.nom as nomSite,if(i.finie = 'True', 'oui', 'non') as intervenu from materiel m left join intervention i on m.id_mat = i.id_mat left join client c on c.id_client = m.id_client left join site s on m.id_site = s.id_site left join typemateriel t on m.id_type = t.id_type where m.id_client like '%" +
cbClient.SelectedValue + "' and m.id_mat like '%" + cbMateriel.SelectedValue +
"' and m.id_type like '%" + cbTypeMat.SelectedValue + "' and m.id_site like '%" +
cbSite.SelectedValue + "'", dgvInter);
}
private void btnRech_Click(object sender, EventArgs e)
{
Fcts_DB.AffichNRech(
"select m.id_mat,m.nom,m.referenece,m.descr,m.date_instal,m.mtbf,if(isnull((SELECT intervention.dateInter FROM materiel as t1 LEFT JOIN intervention ON intervention.id_mat = t1.id_mat WHERE t1.id_mat = m.id_mat order by intervention.dateInter desc limit 1)), m.date_instal, (SELECT intervention.dateInter FROM materiel as m LEFT JOIN intervention ON intervention.id_mat = m.id_mat WHERE m.id_mat = m.id_mat order by intervention.dateInter desc limit 1)) as dateDernInter, ADDDATE(if(isnull((SELECT intervention.dateInter FROM materiel as t1 LEFT JOIN intervention ON intervention.id_mat = t1.id_mat WHERE t1.id_mat = m.id_mat order by intervention.dateInter desc limit 1)), m.date_instal, (SELECT intervention.dateInter FROM materiel as t1 LEFT JOIN intervention ON intervention.id_mat = t1.id_mat WHERE t1.id_mat = m.id_mat order by intervention.dateInter desc limit 1)),m.mtbf) as Datelimite, if(perime = 'True', 'oui', 'non') as perimeON, t.nom as nomType,s.nom as nomSite, c.nom as nomClient from materiel m left join typemateriel t on t.id_type = m.id_type left join site s on s.id_site = m.id_site left join client c on c.id_client = m.id_client WHERE m.id_mat LIKE '%" +
cbMateriel.SelectedValue + "' and c.id_client like '%" + cbClient.SelectedValue +
"' and t.id_type like '%" + cbTypeMat.SelectedValue + "' and s.id_site like '%" +
cbSite.SelectedValue + "' order by perimeON, nom", dgvMat);
}
public void MultipleCb()
{
Fcts_DB.ComboData(
"select '' as id_type, '-- Choisir un Type --' as nom union select id_type, nom from typemateriel",
"nom", "id_type", cbType);
Fcts_DB.ComboData(
"select '' as id_site, '-- Choisir un Site --' as nom union select id_site, nom from site", "nom",
"id_site", cbSite);
Fcts_DB.ComboData(
"select '' as id_client, '-- Choisir un Client --' as nom union select id_client, nom from client",
"nom", "id_client", cbClient);
}
public void Display()
{
Fcts_DB.AffichNRech("call getMat()", dgvMat);
Fcts_DB.ComboData(
"SELECT '' as id_client, '-- Choisir un client --' AS nom UNION SELECT id_client, nom FROM client ORDER BY nom",
"nom", "id_client", cbClient);
Fcts_DB.ComboData(
"SELECT '' as id_type, '-- Choisir un type --' AS nom UNION SELECT id_type, nom FROM typemateriel ORDER BY nom",
"nom", "id_type", cbTypeMat);
Fcts_DB.ComboData(
"SELECT '' as id_mat, '-- Choisir un materiel --' AS nom UNION SELECT id_mat, nom FROM materiel ORDER BY nom",
"nom", "id_mat", cbMateriel);
Fcts_DB.ComboData(
"SELECT '' as id_site, '-- Choisir un site --' AS nom UNION SELECT id_site, nom FROM site ORDER BY nom",
"nom", "id_site", cbSite);
}
public void Display()
{
Fcts_DB.AffichNRech("select * from site", dgvSites);
}
public void Display()
{
Fcts_DB.AffichNRech("select * from client", dgvClients);
}
public void FillCb()
{
Fcts_DB.ComboData(
"select '' as id_mat, '-- Choisir un materiel --' as nom union select id_mat, nom from materiel", "nom",
"id_mat", cbMateriel);
}
