Example #1
0
        void IntfDalRouteNationale.insertToGridRouteNationaleNotItineraire(GridView gridView, string param, string paramLike, string valueLike, List <crlRouteNationale> routeNationales)
        {
            #region declaration
            IntfDalRouteNationale serviceRouteNationale = new ImplDalRouteNationale();
            string strWhere = "";
            #endregion

            #region implementation

            if (routeNationales != null)
            {
                for (int i = 0; i < routeNationales.Count; i++)
                {
                    strWhere += " routenationale.routeNationale <> '" + routeNationales[i].RouteNationale + "' AND";
                }
            }
            this.strCommande  = "SELECT routenationale.routeNationale, routenationale.distanceRN FROM `routenationale`";
            this.strCommande += " WHERE " + strWhere;
            this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'";
            this.strCommande += " ORDER BY " + param + " ASC";

            gridView.DataSource = serviceRouteNationale.getDataTableRouteNationaleNotItineraire(this.strCommande);
            gridView.DataBind();
            #endregion
        }
Example #2
0
        void IntfDalRouteNationale.insertToGridRouteNationale(GridView gridView, string param, string paramLike, string valueLike)
        {
            #region declaration
            IntfDalRouteNationale serviceRouteNationale = new ImplDalRouteNationale();
            #endregion

            #region implementation
            this.strCommande  = "SELECT * FROM `routenationale`";
            this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'";
            this.strCommande += " ORDER BY " + param + " ASC";

            gridView.DataSource = serviceRouteNationale.getDataTableRouteNationale(this.strCommande);
            gridView.DataBind();
            #endregion
        }
Example #3
0
        void IntfDalRouteNationale.insertToGridRouteNationaleItineraire(GridView gridView, string param, string paramLike, string valueLike, string idItineraire)
        {
            #region declaration
            IntfDalRouteNationale serviceRouteNationale = new ImplDalRouteNationale();
            #endregion

            #region implementation
            this.strCommande  = "SELECT routenationale.routeNationale, routenationale.distanceRN FROM `routenationale`";
            this.strCommande += " Inner Join assoitineraireroutenationale ON assoitineraireroutenationale.routeNationale = routenationale.routeNationale";
            this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%' AND";
            this.strCommande += " assoitineraireroutenationale.idItineraire =  '" + idItineraire + "'";
            this.strCommande += " ORDER BY " + param + " ASC";

            gridView.DataSource = serviceRouteNationale.getDataTableRouteNationaleItineraire(this.strCommande);
            gridView.DataBind();
            #endregion
        }