示例#1
0
        string IntfDalUSAxe.insertUSAxe(crlUSAxe axe, string sigleAgence)
        {
            #region declaration
            string       numAxe       = "";
            IntfDalUSAxe serviceUSAxe = new ImplDalUSAxe();
            int          nbInsert     = 0;
            #endregion

            #region implemenation
            if (axe != null && sigleAgence != "")
            {
                axe.NumAxe        = serviceUSAxe.getNumUSAxe(sigleAgence);
                this.strCommande  = "INSERT INTO `usaxe` (`numAxe`,`nomAxe`,`descriptionAxe`)";
                this.strCommande += " VALUES ('" + axe.NumAxe + "','" + axe.NomAxe + "',";
                this.strCommande += " '" + axe.DescriptionAxe + "')";

                this.serviceConnectBase.openConnection();
                nbInsert = this.serviceConnectBase.requete(this.strCommande);
                if (nbInsert == 1)
                {
                    numAxe = axe.NumAxe;
                }
                this.serviceConnectBase.closeConnection();
            }
            #endregion

            return(numAxe);
        }
示例#2
0
        void IntfDalUSAxe.insertToGridAxe(GridView gridView, string param, string paramLike, string valueLike)
        {
            #region declaration
            IntfDalUSAxe serviceUSAxe = new ImplDalUSAxe();
            #endregion

            #region implementation

            this.strCommande  = "SELECT usaxe.numAxe, usaxe.nomAxe, usaxe.descriptionAxe FROM usaxe";
            this.strCommande += " WHERE " + paramLike + " LIKE  '%" + valueLike + "%'";
            this.strCommande += " ORDER BY " + param;


            gridView.DataSource = serviceUSAxe.getDataTableAxe(this.strCommande);
            gridView.DataBind();
            #endregion
        }