예제 #1
0
    //AJOUTER

    protected void Enregistrer(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        string libelle     = Cl_Fonction.GetStringTxt("lib", GridView);
        string observation = Cl_Fonction.GetStringMemo("com", GridView);


        if (Cl_Fonction.Verification_Code("Daf.TYPE_RESSOURCES", "LIBELLE", libelle.ToLower()))
        {
            GridView.JSProperties["cpShowPopup"] = "Caution";
            e.Cancel = true;
        }
        else
        {
            try
            {
                ArrayList cle = new ArrayList();
                ArrayList val = new ArrayList();

                cle.Add("@INDEX");
                val.Add("1");

                cle.Add("@ID");
                val.Add("0");

                cle.Add("@COMMENTAIRE");
                val.Add(observation);

                cle.Add("@LIBELLE");
                val.Add(libelle);

                cle.Add("@DATE");
                val.Add(DateTime.Now);

                cle.Add("@USER");
                val.Add(AuthHelper.GetLoggedInUserInfo().UserName.ToString());

                Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMETRE_UPLOAD", cle, val);
                GridView.JSProperties["cpShowPopup"] = "Success";
                e.Cancel = true;
                GridView.CancelEdit();
                chargerGrid();
            }
            catch (Exception ex)
            {
                e.Cancel = true;

                GridView.JSProperties["cpShowPopup"] = "Error";
            }
        }
    }
예제 #2
0
    //MODIFIER
    protected void Modifier(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
    {
        // int index = Convert.ToInt32(GridView.FocusedRowIndex.ToString());
        var    selectedIds = GridView.GetSelectedFieldValues("ID");
        string index       = selectedIds[0].ToString();
        string libelle     = Cl_Fonction.GetStringTxt("lib", GridView);
        string observation = Cl_Fonction.GetStringMemo("com", GridView);


        try
        {
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();


            cle.Add("@INDEX");
            val.Add("1");

            cle.Add("@ID");
            val.Add(index);

            cle.Add("@COMMENTAIRE");
            val.Add(observation);

            cle.Add("@LIBELLE");
            val.Add(libelle);

            cle.Add("@DATE");
            val.Add(DateTime.Now);

            cle.Add("@USER");
            val.Add(AuthHelper.GetLoggedInUserInfo().UserName.ToString());

            Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMETRE_UPLOAD", cle, val);
            GridView.JSProperties["cpShowPopup"] = "Success";
            e.Cancel = true;
            GridView.CancelEdit();
            chargerGrid();
        }
        catch (Exception ex)
        {
            e.Cancel = true;

            GridView.JSProperties["cpShowPopup"] = "Error";
        }
    }
예제 #3
0
    protected void Enregistrer(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        try
        {
            ArrayList cle = new ArrayList();
            ArrayList val = new ArrayList();

            cle.Add("@INDEX");
            val.Add("1");

            cle.Add("@ID");
            val.Add(0);

            cle.Add("@SITE_ID");
            val.Add(AuthHelper.GetLoggedInUserInfo().SiteID.ToString());

            cle.Add("@JACH");
            val.Add(Cl_Fonction.GetIntCmb("jach", GridView, "pgControl"));

            cle.Add("@JVEN");
            val.Add(Cl_Fonction.GetIntCmb("jven", GridView, "pgControl"));

            cle.Add("@JNOU");
            val.Add(Cl_Fonction.GetIntCmb("jnou", GridView, "pgControl"));

            cle.Add("@RACH");
            val.Add(Cl_Fonction.GetIntCmb("rach", GridView, "pgControl"));

            cle.Add("@RVEN");
            val.Add(Cl_Fonction.GetIntCmb("rven", GridView, "pgControl"));

            cle.Add("@ACH1");
            val.Add(Cl_Fonction.GetStringMemo("ach1", GridView, "pgControl"));

            cle.Add("@VEN1");
            val.Add(Cl_Fonction.GetStringMemo("ven1", GridView, "pgControl"));

            cle.Add("@ACH2");
            val.Add(Cl_Fonction.GetStringMemo("ach2", GridView, "pgControl"));

            cle.Add("@VEN2");
            val.Add(Cl_Fonction.GetStringMemo("ven2", GridView, "pgControl"));

            cle.Add("@STO1");
            val.Add(Cl_Fonction.GetStringMemo("sto1", GridView, "pgControl"));

            cle.Add("@PRO1");
            val.Add(Cl_Fonction.GetStringMemo("pro1", GridView, "pgControl"));

            cle.Add("@STO2");
            val.Add(Cl_Fonction.GetStringMemo("sto2", GridView, "pgControl"));

            cle.Add("@PRO2");
            val.Add(Cl_Fonction.GetStringMemo("pro2", GridView, "pgControl"));

            cle.Add("@PRE");
            val.Add(Cl_Fonction.GetStringMemo("pre", GridView, "pgControl"));

            Cl_Fonction.Execute_Commande_StoreProc("PS_PARAMCOMPTABLE", cle, val);
            //e.Cancel = true;
            GridView.CancelEdit();
            chargerGrid();
        }
        catch (Exception ex)
        {
        }
    }