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
}
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
}
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
}