public void SupprimeRecodageFULLTABLE_referentiel()
{
ConnexionSQLITE con = new ConnexionSQLITE();
string txtSQLQuery = "delete from TB$S_PrevReferentiel where FlagPreventiel = 2";
con.ExecuteQuery(txtSQLQuery);
con.Dispose();
ReferentielDAL RefObject = new ReferentielDAL();
VariablePartage.TableReferentiel = RefObject.ObtenirListeReferentiel_SQLITE();
}
public void SupprimeRecodageModule_referentiel(List <ReferentielBLL> Referentiel)
{
ConnexionSQLITE con = new ConnexionSQLITE();
ReferentielDAL RefObject = new ReferentielDAL();
string txtSQLQuery = "delete from TB$S_PrevReferentiel where FlagPreventiel = 2 and Cpl = '" + Referentiel[0].Cpl + "' and Cpl1 = '" + Referentiel[0].Cpl1 + "' and Cpl2 = '" + Referentiel[0].Cpl2 + "' and Type = '" + Referentiel[0].Type + "'";
con.ExecuteQuery(txtSQLQuery);
con.Dispose();
if (Referentiel[0].Cpl == "135")
{
string txtSQLQuery2 = "delete from TB$S_PrevReferentiel where FlagPreventiel = 2 and Cpl = '50'";
con.ExecuteQuery(txtSQLQuery2);
con.Dispose();
}
if (Referentiel[0].Cpl == "141")
{
string txtSQLQuery2 = "delete from TB$S_PrevReferentiel where FlagPreventiel = 2 and Cpl = '60'";
con.ExecuteQuery(txtSQLQuery2);
con.Dispose();
}
VariablePartage.TableReferentiel = RefObject.ObtenirListeReferentiel_SQLITE();
}