//-------------------------------------------------
        public void Init(
            IDataHotelCalcul calcul,
            CEasyQuery query,
            CODEQTableFromDataHotel table)
        {
            m_calcul = calcul as CDataHotelCalculDuration;
            if (m_calcul == null)
            {
                m_calcul = new CDataHotelCalculDuration();
            }
            List <CColumnEQFromSource> cols   = new List <CColumnEQFromSource>();
            CColumnEQFromSource        colSel = null;

            foreach (IColumnDeEasyQuery colTest in table.Columns)
            {
                CColumnEQFromSource cs = colTest as CColumnEQFromSource;
                if (cs != null && colTest != null && colTest.DataType == typeof(double))
                {
                    cols.Add(cs);
                    if (cs.IdColumnSource == m_calcul.IdChampSource)
                    {
                        colSel = cs;
                    }
                }
            }
            m_cmbChampSource.SelectedValue = colSel;
            if (table != null)
            {
                m_cmbChampSource.ListDonnees       = cols;
                m_cmbChampSource.ProprieteAffichee = "ColumnName";
                m_cmbChampSource.AssureRemplissage();
                m_cmbChampSource.SelectedItem = colSel;
            }
            m_panelFiltre.Init(query, m_calcul.Filtre, table);
        }
        //---------------------------------------------------------------
        private void m_btnOk_Click(object sender, EventArgs e)
        {
            if (m_txtNomTable.Text.Length == 0)
            {
                MessageBox.Show(I.T("Please enter a table name|20004"));
                return;
            }



            m_tableFromDataHotel.NomFinal = m_txtNomTable.Text;
            m_tableFromDataHotel.UseCache = m_chkUseCache.Checked;
            List <IColumnDeEasyQuery> lst = new List <IColumnDeEasyQuery>();

            foreach (ListViewItem item in m_wndListeColonnes.Items)
            {
                if (item.Checked)
                {
                    IColumnDefinition colFromSource = item.Tag as IColumnDefinition;
                    if (colFromSource != null)
                    {
                        IColumnDeEasyQuery newCol = m_tableFromDataHotel.GetColonneFor(colFromSource);
                        if (newCol == null)
                        {
                            newCol = new CColumnEQFromSource(colFromSource);
                        }
                        newCol.ColumnName = item.Text;
                        lst.Add(newCol);
                    }
                    CColonneCalculeeDataHotel colCalc = item.Tag as CColonneCalculeeDataHotel;
                    if (colCalc != null)
                    {
                        colCalc.ColumnName = item.Text;
                        lst.Add(colCalc);
                    }
                }
            }
            m_tableFromDataHotel.SetColonnesOrCalculees(lst);

            List <CColonneEQCalculee> colsCalc = new List <CColonneEQCalculee>();

            foreach (CColonneEQCalculee col in m_ctrlFormulesNommees.GetFormules())
            {
                colsCalc.Add(col);
            }

            m_tableFromDataHotel.ColonnesCalculees = colsCalc;

            CResultAErreur result = m_panelOptions.MajChamps(m_tableFromDataHotel);

            if (!result)
            {
                CFormAlerte.Afficher(result.Erreur);
                return;
            }

            DialogResult = DialogResult.OK;
            Close();
        }
예제 #3
0
        //--------------------------------------------------
        public string GetLibelle(IObjetDeEasyQuery table)
        {
            CColumnEQFromSource col = table.Columns.FirstOrDefault(c => c is CColumnEQFromSource && ((CColumnEQFromSource)c).IdColumnSource == m_strHotelColonneId) as CColumnEQFromSource;

            return((col != null ? col.ColumnName : "?") +
                   new COperateurComparaisonMassStorage(m_operateur).Libelle +
                   (m_formuleValeur != null ? m_formuleValeur.GetString() : "?"));
        }
예제 #4
0
        //-------------------------------------------------------
        public IColumnDefinition GetColumnDefinitionFor(IColumnDeEasyQuery colonne)
        {
            CColumnEQFromSource colFromSource = colonne as CColumnEQFromSource;

            if (m_definitionTable != null && colFromSource != null)
            {
                return(m_definitionTable.Columns.FirstOrDefault(c => c.Id == colFromSource.IdColumnSource));
            }
            return(null);
        }
예제 #5
0
        //--------------------------------------------------------------
        public void Init(
            CEasyQuery query,
            IObjetDeEasyQuery table,
            CDHFiltreValeur comparaison)
        {
            m_query = query;
            m_table = table;
            if (comparaison == null)
            {
                comparaison = new CDHFiltreValeur();
            }
            m_comparaison = comparaison;
            List <COperateurComparaisonMassStorage> ops = new List <COperateurComparaisonMassStorage>();

            foreach (EOperateurComparaisonMassStorage op in COperateurComparaisonMassStorage.ValeursEnumPossibles)
            {
                ops.Add(new COperateurComparaisonMassStorage(op));
            }
            m_comboOperateur.ListDonnees       = ops;
            m_comboOperateur.ProprieteAffichee = "Libelle";

            m_comboOperateur.SelectedValue = new COperateurComparaisonMassStorage(comparaison.Operateur);

            IColumnDeEasyQuery         colSel = null;
            List <CColumnEQFromSource> cols   = new List <CColumnEQFromSource>();

            foreach (IColumnDeEasyQuery col in m_table.Columns)
            {
                CColumnEQFromSource cs = col as CColumnEQFromSource;
                if (cs != null && col.DataType == typeof(double))
                {
                    cols.Add(cs);
                    if (cs.IdColumnSource == m_comparaison.ColumnHotelId)
                    {
                        colSel = col;
                    }
                }
            }

            m_comboChamp.ListDonnees       = cols;
            m_comboChamp.ProprieteAffichee = "ColumnName";
            m_comboChamp.SelectedValue     = colSel;

            m_txtFormuleValeur.Init(
                new CFournisseurGeneriqueProprietesDynamiques(),
                new CObjetPourSousProprietes(m_query));
            m_txtFormuleValeur.Formule = comparaison.FormuleValeur;

            m_txtFormuleCondition.Init(
                new CFournisseurGeneriqueProprietesDynamiques(),
                new CObjetPourSousProprietes(m_query));
            m_txtFormuleCondition.Formule = comparaison.FormuleApplication;
        }
예제 #6
0
 //-------------------------------------------------------
 public CODEQTableFromDataHotel(ITableDefinition definition)
     : base()
 {
     NomFinal          = definition.TableName;
     Size              = new Size(80, 150);
     m_definitionTable = definition;
     if (m_definitionTable != null)
     {
         foreach (IColumnDefinition def in m_definitionTable.Columns)
         {
             CColumnEQFromSource col = new CColumnEQFromSource(def);
             m_listeColonnes.Add(col);
         }
     }
 }
        //-------------------------------------------------
        public CResultAErreurType <IDataHotelCalcul> GetCalcul()
        {
            CResultAErreurType <IDataHotelCalcul> res = new CResultAErreurType <IDataHotelCalcul>();
            CColumnEQFromSource col = m_cmbChampSource.SelectedValue as CColumnEQFromSource;

            if (col == null)
            {
                res.EmpileErreur(I.T("Select a source field|20033"));
                return(res);
            }
            IDHFiltre filtre = m_panelFiltre.MajAndGetFiltre();

            m_calcul.IdChampSource = col.IdColumnSource;
            m_calcul.Filtre        = filtre;
            res.DataType           = m_calcul;
            return(res);
        }
 //--------------------------------------------------------
 private void FillListeColonnes()
 {
     if (m_tableFromFramework != null)
     {
         Dictionary <string, CColumnEQFromSource> dicIdSourceToCol = new Dictionary <string, CColumnEQFromSource>();
         foreach (IColumnDeEasyQuery col in m_tableFromFramework.ColonnesOrCalculees)
         {
             CColumnEQFromSource colFromSource = col as CColumnEQFromSource;
             if (colFromSource == null)
             {
                 ListViewItem item = new ListViewItem(col.ColumnName);
                 item.Tag = col;
                 m_wndListeColonnes.Items.Add(item);
             }
             else
             {
                 dicIdSourceToCol[colFromSource.IdColumnSource] = colFromSource;
             }
         }
         IObjetDeEasyQuery tableParent = m_tableFromFramework.ElementsSource.Length > 0 ? m_tableFromFramework.ElementsSource[0] : null;
         if (tableParent != null)
         {
             foreach (IColumnDeEasyQuery col in tableParent.Columns)
             {
                 ListViewItem item = new ListViewItem(col.ColumnName);
                 item.SubItems.Add(col.ColumnName);
                 CColumnEQFromSource colFromSource = null;
                 if (dicIdSourceToCol.TryGetValue(col.Id, out colFromSource))
                 {
                     item.Text              = colFromSource.ColumnName;
                     item.Checked           = true;
                     colFromSource.DataType = col.DataType;
                 }
                 item.Tag = col;
                 m_wndListeColonnesFromParent.Items.Add(item);
             }
         }
     }
 }
예제 #9
0
        //-------------------------------------------------------
        protected override CResultAErreur GetDatasHorsCalculees(CListeQuerySource sources)
        {
            CEasyQuery     query  = Query;
            CResultAErreur result = CResultAErreur.True;



            if (query == null || sources == null)
            {
                result.EmpileErreur(I.T("Table @1 needs a source to provide datas|20001", NomFinal));
                return(result);
            }

            CEasyQuerySource    source         = sources.GetSourceFromId(TableDefinition.SourceId);
            CDataHotelConnexion hotelConnexion = source != null ? source.Connexion as CDataHotelConnexion : null;

            if (hotelConnexion == null)
            {
                result.EmpileErreur(I.T("No connection for table @1|20006", NomFinal));
                return(result);
            }

            CTableDefinitionDataHotel tableHotel = m_definitionTable as CTableDefinitionDataHotel;

            if (tableHotel == null)
            {
                result.EmpileErreur(I.T("Table @1 can not be calculated. A DataHotel table should be used as source|20002", NomFinal));
                return(result);
            }

            DateTime?dateDebut = null;
            DateTime?dateFin   = null;
            CContexteEvaluationExpression ctxEval = new CContexteEvaluationExpression(Query);

            if (m_formuleDateDebut != null)
            {
                result = m_formuleDateDebut.Eval(ctxEval);
                if (!result)
                {
                    result.EmpileErreur(I.T("Error on start date formula in table @1|20003", NomFinal));
                }
                else
                {
                    dateDebut = result.Data as DateTime?;
                }
            }
            if (m_formuleDateFin != null)
            {
                result = m_formuleDateFin.Eval(ctxEval);
                if (!result)
                {
                    result.EmpileErreur(I.T("Error on end date formula in table @1|20004", NomFinal));
                }
                else
                {
                    dateFin = result.Data as DateTime?;
                }
            }
            if (dateDebut == null || dateFin == null)
            {
                result.EmpileErreur(I.T("Both start date and end date must be set for table  @1|20005", NomFinal));
            }
            if (!result)
            {
                return(result);
            }

            List <string> lstIdsEntites = new List <string>();

            if (SourceEntites != null)
            {
                lstIdsEntites.AddRange(SourceEntites.GetListeIdsEntites(Query));
            }

            ITestDataHotel test = null;

            //Calcule le filtre
            if (m_filtre != null)
            {
                test = m_filtre.GetTestFinal(Query);
            }

            CDataHotelQuery hotelQuery = new CDataHotelQuery();

            hotelQuery.TableId   = tableHotel.Id;
            hotelQuery.DateDebut = dateDebut.Value;
            hotelQuery.DateFin   = dateFin.Value;
            hotelQuery.EntitiesId.AddRange(lstIdsEntites);
            hotelQuery.Filtre = test;
            List <string>             lstIdsColonnes = new List <string>();
            List <IChampHotelCalcule> lstCalcs       = new List <IChampHotelCalcule>();

            foreach (IColumnDeEasyQuery col in m_listeColonnes)
            {
                CColumnEQFromSource colFromSource = col as CColumnEQFromSource;
                if (colFromSource != null)
                {
                    lstIdsColonnes.Add(colFromSource.IdColumnSource);
                }
                CColonneCalculeeDataHotel colCalc = col as CColonneCalculeeDataHotel;
                if (colCalc != null)
                {
                    if (colCalc.Calcul != null)
                    {
                        IChampHotelCalcule champHotelCalc = colCalc.Calcul.GetChampHotel(Query);
                        if (champHotelCalc != null)
                        {
                            champHotelCalc.NomChampFinal = colCalc.ColumnName;
                            lstCalcs.Add(champHotelCalc);
                        }
                    }
                }
            }
            hotelQuery.ChampsId       = lstIdsColonnes;
            hotelQuery.ChampsCalcules = lstCalcs;


            DataTable tableResult = hotelConnexion.GetData(tableHotel, hotelQuery);

            if (tableResult != null)
            {
                Dictionary <string, IColumnDeEasyQuery> colNameSourceToDestCol = new Dictionary <string, IColumnDeEasyQuery>();
                foreach (IColumnDeEasyQuery col in m_listeColonnes)
                {
                    CColumnEQFromSource cs = col as CColumnEQFromSource;
                    if (cs != null)
                    {
                        IColumnDefinition def = tableHotel.GetColumn(cs.IdColumnSource);
                        if (def != null)
                        {
                            colNameSourceToDestCol[def.ColumnName] = col;
                        }
                    }
                }

                foreach (DataColumn col in tableResult.Columns)
                {
                    IColumnDeEasyQuery colThis = null;
                    if (colNameSourceToDestCol.TryGetValue(col.ColumnName, out colThis))
                    {
                        col.ColumnName = colThis.ColumnName;
                    }
                }
            }

            result.Data = tableResult;



            return(result);
        }
        //-----------------------------------
        private void m_btnOk_Click(object sender, EventArgs e)
        {
            if (m_txtNomTable.Text.Length == 0)
            {
                MessageBox.Show(I.T("Please enter a table name|20004"));
                return;
            }
            List <CParametreJointure> lstParametres = new List <CParametreJointure>();
            ArrayList lst = new ArrayList(m_panelJointure.Controls);

            lst.Reverse();
            foreach (Control ctrl in lst)
            {
                CEditeurParametreJointure editeur = ctrl as CEditeurParametreJointure;
                if (editeur != null)
                {
                    CResultAErreur result = editeur.MajChamps();
                    if (!result)
                    {
                        editeur.BackColor = Color.Red;
                        CFormAfficheErreur.Show(result.Erreur);
                        return;
                    }
                    editeur.BackColor = BackColor;
                    lstParametres.Add(editeur.Parametre);
                }
            }

            List <IColumnDeEasyQuery> lstColonnes = new List <IColumnDeEasyQuery>();

            foreach (ListViewItem item in m_wndListeColonnes1.Items)
            {
                if (item.Checked)
                {
                    IColumnDeEasyQuery col = item.Tag as IColumnDeEasyQuery;
                    if (col != null)
                    {
                        bool bColExiste = false;
                        foreach (IColumnDeEasyQuery colEx in m_objetJointure.ColonnesSource)
                        {
                            CColumnEQFromSource colExSrc = colEx as CColumnEQFromSource;
                            if (colExSrc != null && colExSrc.IdColumnSource == col.Id)
                            {
                                colEx.ColumnName = item.Text;
                                lstColonnes.Add(colEx);
                                bColExiste = true;
                                break;
                            }
                        }
                        if (!bColExiste)
                        {
                            IColumnDeEasyQuery newCol = new CColumnEQFromSource(col);
                            newCol.ColumnName = item.Text;
                            lstColonnes.Add(newCol);
                        }
                    }
                }
            }

            foreach (ListViewItem item in m_wndListeColonnes2.Items)
            {
                if (item.Checked)
                {
                    IColumnDeEasyQuery col = item.Tag as IColumnDeEasyQuery;
                    if (col != null)
                    {
                        bool bColExiste = false;
                        foreach (IColumnDeEasyQuery colEx in m_objetJointure.ColonnesSource)
                        {
                            CColumnEQFromSource colExSrc = colEx as CColumnEQFromSource;
                            if (colExSrc != null && colExSrc.IdColumnSource == col.Id)
                            {
                                colEx.ColumnName = item.Text;
                                lstColonnes.Add(colEx);
                                bColExiste = true;
                                break;
                            }
                        }
                        if (!bColExiste)
                        {
                            IColumnDeEasyQuery newCol = new CColumnEQFromSource(col);
                            newCol.ColumnName = item.Text;
                            lstColonnes.Add(newCol);
                        }
                    }
                }
            }
            m_objetJointure.UseCache           = m_chkUseCache.Checked;
            m_objetJointure.ModeJointure       = (CODEQJointure.EModeJointure)m_cmbTypeJointure.SelectedIndex;
            m_objetJointure.ColonnesSource     = lstColonnes;
            m_objetJointure.ParametresJointure = lstParametres;
            m_objetJointure.NomFinal           = m_txtNomTable.Text;

            DialogResult = DialogResult.OK;
            Close();
        }
예제 #11
0
        //-----------------------------------
        private void m_btnOk_Click(object sender, EventArgs e)
        {
            if (m_txtNomTable.Text.Length == 0)
            {
                MessageBox.Show(I.T("Please enter a table name|20004"));
                return;
            }
            CResultAErreur result = CResultAErreur.True;

            if (m_txtEditeFormule.Formule == null)
            {
                result = m_txtEditeFormule.ResultAnalyse;
                if (result == null)
                {
                    result = CResultAErreur.True;
                }
                result.EmpileErreur(I.T("Error in the formula|20011"));
                CFormAfficheErreur.Show(result.Erreur);
                return;
            }
            m_tableFiltre.NomFinal = m_txtNomTable.Text;
            m_tableFiltre.UseCache = m_chkUseCache.Checked;
            m_tableFiltre.Formule  = m_txtEditeFormule.Formule;
            m_tableFiltre.InclureToutesLesColonnesSource = m_chkInclureTout.Checked;

            if (!m_tableFiltre.InclureToutesLesColonnesSource)
            {
                List <CColumnEQFromSource> lstColonnes = new List <CColumnEQFromSource>();
                foreach (ListViewItem item in m_wndListeColonnesFromSource.Items)
                {
                    if (item.Checked)
                    {
                        IColumnDeEasyQuery col = item.Tag as IColumnDeEasyQuery;
                        if (col != null)
                        {
                            bool bColExiste = false;
                            foreach (IColumnDeEasyQuery colEx in m_tableFiltre.ColonnesFromSource)
                            {
                                CColumnEQFromSource colExSrc = colEx as CColumnEQFromSource;
                                if (colExSrc != null && colExSrc.IdColumnSource == col.Id)
                                {
                                    colEx.ColumnName = item.Text;
                                    lstColonnes.Add(colExSrc);
                                    bColExiste = true;
                                    break;
                                }
                            }
                            if (!bColExiste)
                            {
                                CColumnEQFromSource newCol = new CColumnEQFromSource(col);
                                newCol.ColumnName = item.Text;
                                lstColonnes.Add(newCol);
                            }
                        }
                    }
                }
                m_tableFiltre.ColonnesFromSource = lstColonnes.AsReadOnly();
            }
            else
            {
                m_tableFiltre.ColonnesFromSource = null;
            }

            result = m_panelPostFilter.MajChamps();
            if (!result)
            {
                CFormAlerte.Afficher(result.Erreur);
                return;
            }


            List <CColonneEQCalculee> lst = new List <CColonneEQCalculee>();

            foreach (CColonneEQCalculee col in m_ctrlFormulesNommees.GetFormules())
            {
                lst.Add(col);
            }
            m_tableFiltre.ColonnesCalculeesFromSource = lst;
            DialogResult = DialogResult.OK;
            Close();
        }
        private void m_btnOk_Click(object sender, EventArgs e)
        {
            if (m_txtNomTable.Text.Length == 0)
            {
                MessageBox.Show(I.T("Please enter a table name|20004"));
                return;
            }


            m_tableFromBase.NomFinal = m_txtNomTable.Text;
            m_tableFromBase.UseCache = m_chkUseCache.Checked;
            List <IColumnDeEasyQuery> lst = new List <IColumnDeEasyQuery>();

            foreach (ListViewItem item in m_wndListeColonnes.Items)
            {
                if (item.Checked)
                {
                    IColumnDefinition  colFromSource = item.Tag as IColumnDefinition;
                    IColumnDeEasyQuery newCol        = m_tableFromBase.GetColonneFor(colFromSource);
                    if (newCol == null)
                    {
                        newCol = new CColumnEQFromSource(colFromSource);
                    }
                    newCol.ColumnName = item.Text;
                    lst.Add(newCol);
                }
            }
            m_tableFromBase.SetColonnesOrCalculees(lst);

            List <CColonneEQCalculee> colsCalc = new List <CColonneEQCalculee>();

            foreach (CColonneEQCalculee col in m_ctrlFormulesNommees.GetFormules())
            {
                colsCalc.Add(col);
            }

            m_tableFromBase.ColonnesCalculees = colsCalc;

            CResultAErreur result = CResultAErreur.True;

            if (m_controleOptions != null)
            {
                result = m_controleOptions.MajChamps();
            }

            CResultAErreurType <CCAMLQuery> resCAML = m_panelCAML.MajChamps();

            if (!resCAML)
            {
                result.EmpileErreur(resCAML.Erreur);
            }
            else
            {
                m_tableFromBase.CAMLQuery = resCAML.DataType;
            }

            if (result)
            {
                result = m_panelPostFilter.MajChamps();
            }

            if (!result)
            {
                CFormAlerte.Afficher(result.Erreur);
                return;
            }


            DialogResult = DialogResult.OK;
            Close();
        }
예제 #13
0
        //-------------------------------------------------------
        protected override CResultAErreur GetDatasHorsCalculees(CListeQuerySource sources)
        {
            CResultAErreur result = CResultAErreur.True;



            if (sources == null)
            {
                result.EmpileErreur(I.T("Table @1 needs a source to provide datas|20001", NomFinal));
                return(result);
            }

            CEasyQuerySource    source         = sources.GetSourceFromId(TableDefinition.SourceId);
            CDataHotelConnexion hotelConnexion = source != null ? source.Connexion as CDataHotelConnexion : null;

            if (hotelConnexion == null)
            {
                result.EmpileErreur(I.T("No connection for table @1|20006", NomFinal));
                return(result);
            }


            CTableDefinitionEntitiesDataHotel tableHotel = m_definitionTable as CTableDefinitionEntitiesDataHotel;

            if (tableHotel == null)
            {
                result.EmpileErreur(I.T("Table @1 can not be calculated. A DataHotel table should be used as source|20002", NomFinal));
                return(result);
            }

            DateTime?dateDebut = null;
            DateTime?dateFin   = null;
            CContexteEvaluationExpression ctxEval = new CContexteEvaluationExpression(Query);

            if (m_formuleDateDebut != null)
            {
                result = m_formuleDateDebut.Eval(ctxEval);
                if (!result)
                {
                    result.EmpileErreur(I.T("Error on start date formula in table @1|20003", NomFinal));
                }
                else
                {
                    dateDebut = result.Data as DateTime?;
                }
            }
            if (m_formuleDateFin != null)
            {
                result = m_formuleDateFin.Eval(ctxEval);
                if (!result)
                {
                    result.EmpileErreur(I.T("Error on end date formula in table @1|20004", NomFinal));
                }
                else
                {
                    dateFin = result.Data as DateTime?;
                }
            }
            if (dateDebut == null || dateFin == null)
            {
                result.EmpileErreur(I.T("Both start date and end date must be set for table  @1|20005", NomFinal));
            }
            if (!result)
            {
                return(result);
            }



            DataTable tableResult = hotelConnexion.GetData(tableHotel, dateDebut.Value, dateFin.Value);

            if (tableResult != null)
            {
                Dictionary <string, IColumnDeEasyQuery> colNameSourceToDestCol = new Dictionary <string, IColumnDeEasyQuery>();
                foreach (IColumnDeEasyQuery col in m_listeColonnes)
                {
                    CColumnEQFromSource cs = col as CColumnEQFromSource;
                    if (cs != null)
                    {
                        IColumnDefinition def = tableHotel.GetColumn(cs.IdColumnSource);
                        if (def != null)
                        {
                            colNameSourceToDestCol[def.ColumnName] = col;
                        }
                    }
                }

                foreach (DataColumn col in tableResult.Columns)
                {
                    IColumnDeEasyQuery colThis = null;
                    if (colNameSourceToDestCol.TryGetValue(col.ColumnName, out colThis))
                    {
                        col.ColumnName = colThis.ColumnName;
                    }
                }
            }

            result.Data = tableResult;



            return(result);
        }
        //--------------------------------------------------------
        private void m_btnOk_Click(object sender, EventArgs e)
        {
            if (m_txtNomTable.Text.Length == 0)
            {
                MessageBox.Show(I.T("Please enter a table name|20101"));
                return;
            }

            m_tableFromFramework.FiltreDynamique = m_panelFiltre.FiltreDynamique;
            m_tableFromFramework.ChampSource     = m_champ;

            m_tableFromFramework.NomFinal = m_txtNomTable.Text;
            m_tableFromFramework.UseCache = m_chkUseCache.Checked;
            List <IColumnDeEasyQuery> lst = new List <IColumnDeEasyQuery>();

            foreach (ListViewItem item in m_wndListeColonnes.Items)
            {
                CColumnDeEasyQueryChampDeRequete col = item.Tag as CColumnDeEasyQueryChampDeRequete;
                if (col != null)
                {
                    lst.Add(col);
                }
            }


            foreach (ListViewItem item in m_wndListeColonnesFromParent.Items)
            {
                if (item.Checked)
                {
                    IColumnDeEasyQuery col = item.Tag as IColumnDeEasyQuery;
                    if (col != null)
                    {
                        bool bColExiste = false;
                        foreach (IColumnDeEasyQuery colEx in m_tableFromFramework.Columns)
                        {
                            CColumnEQFromSource colExSrc = colEx as CColumnEQFromSource;
                            if (colExSrc != null && colExSrc.IdColumnSource == col.Id)
                            {
                                colEx.ColumnName = item.Text;
                                lst.Add(colEx);
                                bColExiste = true;
                                break;
                            }
                        }
                        if (!bColExiste)
                        {
                            IColumnDeEasyQuery newCol = new CColumnEQFromSource(col);
                            newCol.ColumnName = item.Text;
                            lst.Add(newCol);
                        }
                    }
                }
            }


            m_tableFromFramework.SetColonnesOrCalculees(lst);

            List <CColonneEQCalculee> colsCalc = new List <CColonneEQCalculee>();

            foreach (CColonneEQCalculee col in m_ctrlFormulesNommees.GetFormules())
            {
                colsCalc.Add(col);
            }

            m_tableFromFramework.ColonnesCalculees = colsCalc;

            CResultAErreur result = CResultAErreur.True;

            if (m_controleOptions != null)
            {
                result = m_controleOptions.MajChamps();
            }

            if (result)
            {
                result = m_panelPostFilter.MajChamps();
            }

            if (!result)
            {
                CFormAlerte.Afficher(result.Erreur);
                return;
            }


            DialogResult = DialogResult.OK;
            Close();
        }