public List<clsRubricStructureBO> GetListRubricsStructureByIdSoc(int IdSoc) { // Get Rubrique ordred by order parameter clsRubricStructureDAL Dal = new clsRubricStructureDAL(); return Dal.GetListRubricsByIdSoc(IdSoc); }
/// <summary> /// Retourne les ordres des colonnes select Col1,Col2,.....,Coln /// </summary> /// <returns></returns> public string PrepareSqlQuery(int IdSoc) { // Get Rubrique ordred by order parameter // clsRubricStructureDAL Dal = new clsRubricStructureDAL(); string SqlQuery=""; int index = 0; List<clsRubricStructureBO> ListRubrics = Dal.GetListRubricsByIdSoc(IdSoc); foreach (clsRubricStructureBO r in ListRubrics) { SqlQuery = SqlQuery + r.NomColonne ; if (index != ListRubrics.Count() - 1) SqlQuery = SqlQuery + ","; } string GrossToNetTableName = ""; GrossToNetTableName = ManagerDAO.GetInstance().GetDetailsSociete(IdSoc).GrossToNetTableName; return " Select " + SqlQuery + " From " + GrossToNetTableName; }