private void CFormEditProprieteListeColonnes_Load(object sender, System.EventArgs e)
        {
            // Lance la traduction du formulaire
            sc2i.win32.common.CWin32Traducteur.Translate(this);
            FillListeColonnes();

            m_cmbAgregate.DataSource    = CUtilSurEnum.GetCouplesFromEnum(typeof(OperationsAgregation));
            m_cmbAgregate.DisplayMember = "Libelle";
            m_cmbAgregate.ValueMember   = "Valeur";
        }
        private void CFormEditVariableFiltreCalculee_Load(object sender, System.EventArgs e)
        {
            // Lance la traduction du formulaire
            sc2i.win32.common.CWin32Traducteur.Translate(this);

            m_cmbOperation.ValueMember   = "Valeur";
            m_cmbOperation.DisplayMember = "Libelle";
            m_cmbOperation.DataSource    = CUtilSurEnum.GetCouplesFromEnum(typeof(OperationsAgregation));
            m_cmbOperation.SelectedValue = (int)m_champ.OperationAgregation;

            //Types finaux
            m_cmbTypeFinal.Items.Clear();
            List <CInfoClasseDynamique> lstTypes = new List <CInfoClasseDynamique>();

            lstTypes.Add(new CInfoClasseDynamique(typeof(DBNull), I.T("Default|20007")));
            lstTypes.Add(new CInfoClasseDynamique(typeof(int), C2iTypeDonnee.GetLibelleType(TypeDonnee.tEntier)));
            lstTypes.Add(new CInfoClasseDynamique(typeof(string), C2iTypeDonnee.GetLibelleType(TypeDonnee.tString)));
            lstTypes.Add(new CInfoClasseDynamique(typeof(bool), C2iTypeDonnee.GetLibelleType(TypeDonnee.tBool)));
            lstTypes.Add(new CInfoClasseDynamique(typeof(DateTime), C2iTypeDonnee.GetLibelleType(TypeDonnee.tDate)));
            lstTypes.Add(new CInfoClasseDynamique(typeof(double), C2iTypeDonnee.GetLibelleType(TypeDonnee.tDouble)));
            m_cmbTypeFinal.DataSource    = lstTypes;
            m_cmbTypeFinal.ValueMember   = "Classe";
            m_cmbTypeFinal.DisplayMember = "Nom";

            Type tp = m_champ.TypeDonneeFinalForce;

            if (tp == null)
            {
                tp = typeof(DBNull);
            }
            try
            {
                m_cmbTypeFinal.SelectedValue = tp;
            }
            catch
            { }

            m_chkGrouper.Checked = m_champ.GroupBy;
            //m_lblSource.Text = m_champ.Source;
            m_txtNomChamp.Text    = m_champ.NomChamp;
            m_txtFonctionSql.Text = m_champ.FonctionSql;

            int nIndex = 0;

            foreach (CSourceDeChampDeRequete source in m_champ.Sources)
            {
                CPanelSourceDeRequete panel = new CPanelSourceDeRequete();
                panel.Dock = DockStyle.Top;
                m_panelSources.Controls.Add(panel);
                panel.BringToFront();
                panel.Init(source, nIndex++, m_typeSource, m_defRacineDeChamps);
            }
        }
        private void CFormEditCumulCroise_Load(object sender, System.EventArgs e)
        {
            // Lance la traduction du formulaire
            sc2i.win32.common.CWin32Traducteur.Translate(this);

            m_lblChampSource.Text        = m_cumul.NomChamp;
            m_txtPrefix.Text             = m_cumul.PrefixFinal;
            m_cmbOperation.ValueMember   = "Valeur";
            m_cmbOperation.DisplayMember = "Libelle";
            m_cmbOperation.DataSource    = CUtilSurEnum.GetCouplesFromEnum(typeof(TypeCumulCroise));
            m_cmbOperation.SelectedValue = (int)m_cumul.TypeCumul;
            m_chkHorsPivot.Checked       = m_cumul.HorsPivot;
        }
		private void AffecteControlsWithExporteurValues()
		{
			if (m_exporteur==null)
				m_exporteur = new CExporteurDatasetAccess();

			CExporteurDatasetAccess exp = (CExporteurDatasetAccess) m_exporteur;

			m_cmbFormat.DataSource = CUtilSurEnum.GetCouplesFromEnum ( typeof ( VersionAccessExport ) );
			foreach ( CUtilSurEnum.CCoupleEnumLibelle couple in (IList)m_cmbFormat.DataSource )
				if ( couple.Valeur == (int)exp.VersionAccess )
					m_cmbFormat.SelectedItem = couple;
			if ( m_cmbFormat.SelectedItem == null )
				m_cmbFormat.SelectedIndex = 0;
		}
Beispiel #5
0
        private void InitFromParametre(  )
        {
            CTypeDonneeCumulee typeDonnee = new CTypeDonneeCumulee(CSc2iWin32DataClient.ContexteCourant);

            if (m_parametre.IdTypeDonneeCumulee != null)
            {
                if (!typeDonnee.ReadIfExists(m_parametre.IdTypeDonneeCumulee.Value))
                {
                    typeDonnee = null;
                }
            }
            if (typeDonnee == null)
            {
                m_tabControl.Visible = false;
                if (m_cmbTypeDonnee.ElementSelectionne != null)
                {
                    m_cmbTypeDonnee.ElementSelectionne = null;
                }
                return;
            }
            m_tabControl.Visible = true;
            m_cmbTypeDonnee.ElementSelectionne = typeDonnee;
            DataTable table = m_parametre.GetDataTableModelePourParametrage(CSc2iWin32DataClient.ContexteCourant);

            if (table != null)
            {
                m_panelTableauCroise.InitChamps(table, m_parametre.TableauCroise);
                m_panelTableauCroise.Enabled = true;
            }
            else
            {
                m_panelTableauCroise.Enabled = false;
            }

            m_panelFormatHeader.Init(m_parametre.FormatHeader, null, true);
            m_panelFormatRows.Init(m_parametre.FormatRows, null, false);

            InitFormatsChamps();

            InitFiltres(m_panelFiltresDeBase, m_parametre.FiltresDeBase, false);
            InitFiltres(m_panelFiltresUser, m_parametre.FiltresUtilisateur, true);

            m_cmbOperation.ValueMember    = "Valeur";
            m_cmbOperation.DisplayMember  = "Libelle";
            m_cmbOperation.DataSource     = CUtilSurEnum.GetCouplesFromEnum(typeof(OperationsAgregation));
            m_cmbOperation.SelectedValue  = (int)m_parametre.OperationCumul;
            m_txtLibelleTotal.Text        = m_parametre.LibelleTotal;
            m_chkShowExportButton.Checked = m_parametre.ShowExportButton;
            m_chkShowHeader.Checked       = m_parametre.ShowHeader;
        }
Beispiel #6
0
 /// ////////////////////////////////////////////////////
 protected override void InitChamps()
 {
     base.InitChamps();
     m_txtLibelle.Text = ActionCreerHandler.LibelleEvenement;
     m_panelParametreDeclenchement.Init(ActionCreerHandler.ParametreDeclencheur);
     FillListeVariablesElement();
     m_comboVariableElement.SelectedValue = ActionCreerHandler.VariableElement;
     m_cmbGestionCode.DataSource          = CUtilSurEnum.GetCouplesFromEnum(typeof(CActionCreerHandlerEvenement.TypeGestionCode));
     foreach (CUtilSurEnum.CCoupleEnumLibelle couple in (IEnumerable)m_cmbGestionCode.DataSource)
     {
         if (couple.Valeur == (int)ActionCreerHandler.TypeDeGestionDuCodeEvenement)
         {
             m_cmbGestionCode.SelectedItem = couple;
         }
     }
     //m_chkCodeUnique.Checked = ActionCreerHandler.HandlerACodeUnique;
 }
        public override void InitChamps(CPlanificationTache planification)
        {
            CUtilSurEnum.CCoupleEnumLibelle[] couples = CUtilSurEnum.GetCouplesFromEnum(typeof(CPlanificationTacheFrequente.EUniteTemps));
            m_cmbUnite.DataSource    = couples;
            m_cmbUnite.DisplayMember = "Libelle";
            m_cmbUnite.ValueMember   = "Valeur";
            base.InitChamps(planification);
            CPlanificationTacheFrequente plFreq = (CPlanificationTacheFrequente)planification;

            for (int n = 0; n < 7; n++)
            {
                if ((plFreq.JoursExecution & CUtilDate.GetJourBinaireForBaseLundi(n)) != 0)
                {
                    m_wndListeJours.Items[n].Checked = true;
                }
                else
                {
                    m_wndListeJours.Items[n].Checked = false;
                }
            }
            int nIndex = 0;

            foreach (CUtilSurEnum.CCoupleEnumLibelle couple in couples)
            {
                if (couple.Valeur == (int)plFreq.Unite)
                {
                    m_cmbUnite.SelectedIndex = nIndex;
                }
                nIndex++;
            }
            m_wndHeureFin.ValeurHeure = plFreq.HeureFin;
            m_wndEcart.DoubleValue    = plFreq.Ecart;

            foreach (ListViewItem item in m_wndListeJours.Items)
            {
                item.Text = I.TT(GetType(), item.Text);
            }
        }
        /// //////////////////////////////////////////
        protected override void InitChamps()
        {
            base.InitChamps();
            m_wndAideFormule.FournisseurProprietes = ObjetEdite.Process;
            m_wndAideFormule.ObjetInterroge        = typeof(CProcess);

            m_txtFormuleCle.Init(m_wndAideFormule.FournisseurProprietes, m_wndAideFormule.ObjetInterroge);
            m_txtFormuleDescriptif.Init(m_wndAideFormule.FournisseurProprietes, m_wndAideFormule.ObjetInterroge);
            m_txtFormuleLibelle.Init(m_wndAideFormule.FournisseurProprietes, m_wndAideFormule.ObjetInterroge);
            m_txtFormuleVariable.Init(m_wndAideFormule.FournisseurProprietes, m_wndAideFormule.ObjetInterroge);

            CListeObjetsDonnees liste = new CListeObjetsDonnees(CSc2iWin32DataClient.ContexteCourant, typeof(CCategorieGED));

            m_wndListeCategories.Remplir(liste, false);
            foreach (ListViewItem item in m_wndListeCategories.Items)
            {
                CCategorieGED cat = (CCategorieGED)item.Tag;
                if (ActionGenererEtat.ListeIdsCategoriesStockage.Contains(cat.Id))
                {
                    item.Checked = true;
                }
                else
                {
                    item.Checked = false;
                }
            }

            liste = new CListeObjetsDonnees(CSc2iWin32DataClient.ContexteCourant, typeof(sc2i.documents.C2iRapportCrystal));
            m_comboModeleEtat.ListDonnees = liste;
            C2iRapportCrystal rapport = new C2iRapportCrystal(CSc2iWin32DataClient.ContexteCourant);

            m_tableIdVariableToFormule.Clear();
            if (rapport.ReadIfExists(ActionGenererEtat.IdEtatCrystal))
            {
                m_comboModeleEtat.SelectedValue = rapport;
                CMultiStructureExport multiStructure = rapport.MultiStructure;
                if (multiStructure != null)
                {
                    foreach (IVariableDynamique variable in multiStructure.ListeVariables)
                    {
                        m_tableIdVariableToFormule[variable.IdVariable] = ActionGenererEtat.GetExpressionForVariableFiltre(variable.IdVariable);
                    }
                }
            }
            else
            {
                m_comboModeleEtat.SelectedValue = null;
            }

            UpdateListeVariables();

            m_txtFormuleCle.Text        = ActionGenererEtat.ExpressionCle.GetString();
            m_txtFormuleDescriptif.Text = ActionGenererEtat.ExpressionDescriptif.GetString();
            m_txtFormuleLibelle.Text    = ActionGenererEtat.ExpressionLibelle.GetString();

            m_cmbFormat.DisplayMember = "Libelle";
            m_cmbFormat.ValueMember   = "Valeur";
            m_cmbFormat.DataSource    = CUtilSurEnum.GetCouplesFromEnum(typeof(TypeFormatExportCrystal));

            m_cmbFormat.SelectedValue = (int)ActionGenererEtat.FormatExport;

            m_chkStocker.Checked  = ActionGenererEtat.StockerDansLaGed;
            m_chkImprimer.Checked = ActionGenererEtat.ImprimerSurClient;
        }