Ejemplo n.º 1
0
        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();
        }
Ejemplo n.º 2
0
        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();
        }