void IntfDalUSLigne.insertToGridLigne(GridView gridView, string param, string paramLike, string valueLike)
{
#region declaration
IntfDalUSLigne serviceUSLigne = new ImplDalUSLigne();
#endregion
#region implementation
this.strCommande = "SELECT usligne.numLigne, usligne.numCooperative, usligne.nomLigne,";
this.strCommande += " usligne.descriptionLigne, usligne.numArretD, usligne.numArretF,";
this.strCommande += " usligne.zone, cooperative.nomCooperative FROM usligne";
this.strCommande += " Left Join usarret ON usarret.numArret = usligne.numArretF OR usarret.numArret = usligne.numArretD";
this.strCommande += " Left Join uslieu ON uslieu.numLieu = usarret.numLieu";
this.strCommande += " Inner Join cooperative ON cooperative.numCooperative = usligne.numCooperative";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " GROUP BY usligne.numLigne";
this.strCommande += " ORDER BY " + param;
gridView.DataSource = serviceUSLigne.getDataTableLigne(this.strCommande);
gridView.DataBind();
#endregion
}
