//--------------------------------------------------------------- private void RefreshComboChamps() { List <string> lstChamps = new List <string>(); if (m_cmbTable.Text != "" && m_panelQuery.Query != null) { IObjetDeEasyQuery table = null; foreach (I2iObjetGraphique obj in m_panelQuery.Query.Childs) { table = obj as IObjetDeEasyQuery; if (table != null && table.NomFinal == m_cmbTable.Text) { break; } else { table = null; } } if (table != null) { foreach (IColumnDeEasyQuery col in table.Columns) { lstChamps.Add(col.ColumnName); } } } UpdateCombo(m_cmbLatitude, lstChamps); UpdateCombo(m_cmbLongitude, lstChamps); UpdateCombo(m_cmbGroupBy, lstChamps); UpdateCombo(m_cmbLabel, lstChamps); }
//--------------------------------------------------- public override IEnumerable <IColumnDeEasyQuery> GetColonnesFinales() { List <IColumnDeEasyQuery> lst = new List <IColumnDeEasyQuery>(); if (m_bInclureToutesLesColonnesSource) { IObjetDeEasyQuery source = TableSource; if (source != null) { lst.AddRange(source.Columns); } } else { foreach (IColumnDeEasyQuery col in ColonnesFromSource) { lst.Add(col); } } foreach (IColumnDeEasyQuery col in ColonnesCalculeesFromSource) { lst.Add(col); } return(lst.AsReadOnly()); }
//------------------------------------------------------- public override void Draw(CContextDessinObjetGraphique ctx) { base.Draw(ctx); if (SourceEntites is CSourceEntitesPourTableDataChampDeTable) { string strIdTable = ((CSourceEntitesPourTableDataChampDeTable)SourceEntites).IdTable; IObjetDeEasyQuery tableSource = null; foreach (IObjetDeEasyQuery objet in Query.Childs) { CODEQBase o = objet as CODEQBase; if (o != null && o.Id == strIdTable) { tableSource = o; break; } } if (tableSource != null) { Pen pen = new Pen(Brushes.Black, 2); CLienTracable lien = CTraceurLienDroit.GetLienPourLier(tableSource.RectangleAbsolu, RectangleAbsolu, EModeSortieLien.Automatic); lien.RendVisibleAvecLesAutres(ctx.Liens); ctx.AddLien(lien); pen.DashStyle = DashStyle.Dot; AdjustableArrowCap cap = new AdjustableArrowCap(4, 4, true); pen.CustomEndCap = cap; lien.Draw(ctx.Graphic, pen); pen.Dispose(); cap.Dispose(); } } }
//-------------------------------------------------------------------------------- private void InitListeTables(bool bKeepChecked) { //Stocke les items cochés HashSet <string> strCoches = new HashSet <string>(); if (bKeepChecked) { foreach (ListViewItem item in m_wndListeTablesAExporter.CheckedItems) { IObjetDeEasyQuery objet = item.Tag as IObjetDeEasyQuery; if (objet != null) { strCoches.Add(objet.Id); } } } else { strCoches = m_setTablesARetourner; } m_wndListeTablesAExporter.BeginUpdate(); m_wndListeTablesAExporter.Items.Clear(); foreach (I2iObjetGraphique objet in m_query.Childs) { IObjetDeEasyQuery objE = objet as IObjetDeEasyQuery; if (objE != null) { ListViewItem item = new ListViewItem(objE.NomFinal); item.Tag = objE; item.Checked = strCoches.Contains(objE.Id); m_wndListeTablesAExporter.Items.Add(item); } } m_wndListeTablesAExporter.EndUpdate(); }
//----------------------------------------------------------------- void itemNewSource_Click(object sender, EventArgs e) { ToolStripMenuItem item = sender as ToolStripMenuItem; CODEQFromObjetsSource tableFromSource = Selection.Count == 1 ? Selection[0] as CODEQFromObjetsSource : null; ToolStripMenuItem itemParent = item != null ? item.OwnerItem as ToolStripMenuItem : null; IObjetDeEasyQuery newSource = item != null?item.Tag as IObjetDeEasyQuery:null; int nIndexSource = itemParent != null && itemParent.Tag is int?(int)itemParent.Tag : -1; if (newSource != null && nIndexSource >= 0 && tableFromSource != null) { if (MessageBox.Show(I.T("Replace Table @1 by table @2 ?", itemParent.Text, item.Text), "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { CResultAErreur result = tableFromSource.SetSource(nIndexSource, newSource); if (!result) { CFormAlerte.Afficher(result.Erreur); } else { Refresh(); } } } }
private void FillTables() { m_bIsFillingTables = true; m_comboTable.BeginUpdate(); m_comboTable.Items.Clear(); CParametreSourceChart p = m_chartSetup.ParametresDonnees.GetSourceFV(m_fournisseur.SourceId); if (p != null) { CEasyQuery query = p.GetSource(m_chartSetup) as CEasyQuery; if (query != null) { foreach (C2iObjetGraphique obj in query.Childs) { IObjetDeEasyQuery oe = obj as IObjetDeEasyQuery; if (oe != null) { m_comboTable.Items.Add(oe.NomFinal); } } } } m_comboTable.EndUpdate(); m_comboTable.SelectedItem = m_fournisseur.TableName; m_bIsFillingTables = false; }
public void Init(CODEQTableauCroise objetTableauCroise) { m_txtNomTable.Text = objetTableauCroise.NomFinal; m_chkUseCache.Checked = objetTableauCroise.UseCache; m_objetTableauCroise = objetTableauCroise; m_tableSource = new DataTable(); IObjetDeEasyQuery tableDef = m_objetTableauCroise.TableSource; if (tableDef != null) { foreach (IColumnDeEasyQuery col in tableDef.Columns) { Type tp = col.DataType; if (tp.IsGenericType && tp.GetGenericTypeDefinition() == typeof(Nullable <>)) { tp = tp.GetGenericArguments()[0]; } m_tableSource.Columns.Add(new DataColumn(col.ColumnName, tp)); } } CTableauCroise tableauCroise = CCloner2iSerializable.Clone(m_objetTableauCroise.TableauCroise) as CTableauCroise; if (tableauCroise == null) { tableauCroise = new CTableauCroise(); } m_panelTableauCroise.InitChamps(m_tableSource, tableauCroise); }
//-------------------------------------------------- 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() : "?")); }
//------------------------------------------------- public void Init(IObjetDeEasyQuery table1, IObjetDeEasyQuery table2, CParametreJointure parametre) { if (table1 == null || table2 == null) { Visible = false; return; } Visible = true; m_parametre = CCloner2iSerializable.Clone(parametre) as CParametreJointure; m_cmbOperateur.Items.Clear(); if (table1 != null) { m_txtFormule1.Init(table1, table1.GetType()); } if (table2 != null) { m_txtFormule2.Init(table2, table2.GetType()); } foreach (EOperateurJointure operateur in Enum.GetValues(typeof(EOperateurJointure))) { switch (operateur) { case EOperateurJointure.Egal: m_cmbOperateur.Items.Add("="); break; case EOperateurJointure.Superieur: m_cmbOperateur.Items.Add(">"); break; case EOperateurJointure.SuperieurEgal: m_cmbOperateur.Items.Add(">="); break; case EOperateurJointure.Inferieur: m_cmbOperateur.Items.Add("<"); break; case EOperateurJointure.InferieurEgal: m_cmbOperateur.Items.Add("<="); break; case EOperateurJointure.Different: m_cmbOperateur.Items.Add("<>"); break; default: break; } m_txtFormule1.Formule = m_parametre.FormuleTable1; m_txtFormule2.Formule = m_parametre.FormuleTable2; m_cmbOperateur.SelectedIndex = (int)m_parametre.Operateur; } }
//--------------------------------------------------- public override IEnumerable <IColumnDeEasyQuery> GetColonnesFinales() { IObjetDeEasyQuery source = TableSource; if (source != null) { return(source.Columns); } return(new List <IColumnDeEasyQuery>()); }
//----------------------------------------------------------------------------------- public void Init( CEasyQuery easyQuery, IDHFiltre filtre, CODEQTableFromDataHotel table) { m_easyQuery = easyQuery; m_table = table; m_filtreOriginal = filtre; InitArbre(); }
//----------------------------------------------------------------------------------- public void InitForChampFixe( CEasyQuery easyQuery, IDHFiltre filtre, CODEQTableFromDataHotel table, string strIdChamp) { m_easyQuery = easyQuery; m_table = table; m_filtreOriginal = filtre; InitArbre(); }
public void ClearCache() { foreach (I2iObjetGraphique objetGraphique in Childs) { IObjetDeEasyQuery obj = objetGraphique as IObjetDeEasyQuery; if (obj != null) { obj.ClearCache(); } } }
//-------------------------------------------------------------- public static bool EditeComparaison(CEasyQuery query, IObjetDeEasyQuery table, CDHFiltreValeur itemComparaison) { CFormEditeComposantDHComparaison frm = new CFormEditeComposantDHComparaison(); frm.Init(query, table, itemComparaison); DialogResult res = frm.ShowDialog(); frm.Dispose(); return(res == DialogResult.OK); }
//-------------------------------------------------------------- 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; }
//--------------------------------------------------- public virtual IObjetDeEasyQuery GetObjet(string strId) { foreach (I2iObjetGraphique objet in Childs) { IObjetDeEasyQuery ob = objet as IObjetDeEasyQuery; if (ob != null && ob.Id == strId) { return(ob); } } return(null); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQJointure jointure = objet as CODEQJointure; if (jointure == null) { return(false); } CFormEditeProprietesJointure form = new CFormEditeProprietesJointure(); form.Init(jointure); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQTableManuelle tableManuelle = objet as CODEQTableManuelle; if (tableManuelle == null) { return(false); } CFormEditeProprietesTableManuelle form = new CFormEditeProprietesTableManuelle(); form.Init(tableManuelle); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQSort sort = objet as CODEQSort; if (sort == null) { return(false); } CFormEditeProprietesSort form = new CFormEditeProprietesSort(); form.Init(sort); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQFiltreCAML filtre = objet as CODEQFiltreCAML; if (filtre == null) { return(false); } CFormEditeProprietesFiltreCAML form = new CFormEditeProprietesFiltreCAML(); form.Init(filtre); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQTableEntitiesFromDataHotel tableFromDataHotel = objet as CODEQTableEntitiesFromDataHotel; if (tableFromDataHotel == null) { return(false); } CFormEditeProprietesTableEntitiesFromDataHotel form = new CFormEditeProprietesTableEntitiesFromDataHotel(); form.Init(tableFromDataHotel); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
//--------------------------------------------------- public virtual DataTable GetTable(string strNomTable, CListeQuerySource sources) { foreach (I2iObjetGraphique objet in Childs) { IObjetDeEasyQuery ob = objet as IObjetDeEasyQuery; if (ob != null && ob.NomFinal == strNomTable) { CResultAErreur result = ob.GetDatas(sources); if (result) { return(result.Data as DataTable); } } } return(null); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQTableFromTableFramework TableFromFramework = objet as CODEQTableFromTableFramework; if (TableFromFramework == null) { return(false); } CFormEditeProprietesTableFromFramework form = new CFormEditeProprietesTableFromFramework(); form.Init(TableFromFramework); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
public bool EditeProprietes(IObjetDeEasyQuery objet) { CODEQTableauCroise objetDeTableau = objet as CODEQTableauCroise; if (objetDeTableau == null) { return(false); } CFormEditeProprietesTableauCroise form = new CFormEditeProprietesTableauCroise(); form.Init(objetDeTableau); bool bResult = form.ShowDialog() == DialogResult.OK; form.Dispose(); return(bResult); }
//-------------------------------------------------------------------------------- public CResultAErreur MajChamps() { m_elementDeMultiStructure.Libelle = m_txtLibelleElement.Text; m_elementDeMultiStructure.Prefixe = m_txtPrefix.Text; JeuQuery.EasyQueryAvecSource = m_panelQuery.Query; List <string> lstIdChecked = new List <string>(); foreach (ListViewItem item in m_wndListeTablesAExporter.CheckedItems) { IObjetDeEasyQuery obj = item.Tag as IObjetDeEasyQuery; if (obj != null) { lstIdChecked.Add(obj.Id); } } JeuQuery.IdTablesARetourner = lstIdChecked; return(CResultAErreur.True); }
//--------------------------------------------------- protected override void MyDraw(CContextDessinObjetGraphique ctx) { base.MyDraw(ctx); IObjetDeEasyQuery source = TableSource; if (source != null) { Pen pen = new Pen(Brushes.Black, 2); CLienTracable lien = CTraceurLienDroit.GetLienPourLier(source.RectangleAbsolu, RectangleAbsolu, EModeSortieLien.Automatic); lien.RendVisibleAvecLesAutres(ctx.Liens); ctx.AddLien(lien); AdjustableArrowCap cap = new AdjustableArrowCap(4, 4, true); pen.CustomEndCap = cap; lien.Draw(ctx.Graphic, pen); pen.Dispose(); cap.Dispose(); } }
//----------------------------------------------------------------- public bool EditeProprietes(I2iObjetGraphique objet) { IObjetDeEasyQuery objetDeQuery = objet as IObjetDeEasyQuery; if (objetDeQuery == null) { return(false); } Type tpEditeur = GetTypeEditeurForObjet(objetDeQuery); if (tpEditeur == null) { return(false); } IEditeurProprietesObjetDeEasyQuery editeur = Activator.CreateInstance(tpEditeur) as IEditeurProprietesObjetDeEasyQuery; bool bResult = false; if (editeur != null) { bResult = editeur.EditeProprietes(objetDeQuery); } if (editeur is IDisposable) { ((IDisposable)editeur).Dispose(); } if (bResult) { CEasyQuery query = ObjetEdite as CEasyQuery; if (query != null && query.ListeSources != null) { CODEQTableFromBase odeqFromBase = objetDeQuery as CODEQTableFromBase; if (odeqFromBase != null && odeqFromBase.TableDefinition != null) { query.ListeSources.ClearCache(odeqFromBase.TableDefinition); } } Refresh(); if (ElementPropertiesChanged != null) { ElementPropertiesChanged(objetDeQuery, null); } } return(bResult); }
//------------------------------------------------------------------------------- private CColumnDefinitionSNMP GetSourceColumn( IObjetDeEasyQuery objetDeQuery, CChampEntiteFromQueryToChampCustom champ) { if (objetDeQuery == null || objetDeQuery.Query == null) { return(null); } ITableDefinition table = null; IColumnDefinition col = null; if (objetDeQuery.Query.FindSource(champ.Champ.ColonneSource, objetDeQuery, out table, out col)) { return(col as CColumnDefinitionSNMP); } return(null); }
//---------------------------------------------------------------------------------------- public void Draw(IObjetDeEasyQuery objetPossedant, CContextDessinObjetGraphique ctxDessin) { if (objetPossedant != null && objetPossedant.Query != null) { IObjetDeEasyQuery objet = objetPossedant.Query.GetObjet(SourceTableId); if (objet != null) { Color c = Color.FromArgb(128, 0, 0, 255); Pen pen = new Pen(c, 1); AdjustableArrowCap cap = new AdjustableArrowCap(4, 4, true); pen.CustomEndCap = cap; CLienTracable lien = CTraceurLienDroit.GetLienPourLier(objet.RectangleAbsolu, objetPossedant.RectangleAbsolu, EModeSortieLien.Automatic); lien.RendVisibleAvecLesAutres(ctxDessin.Liens); ctxDessin.AddLien(lien); lien.Draw(ctxDessin.Graphic, pen); pen.Dispose(); cap.Dispose(); } } }
//----------------------------------------------------------------- private void m_menuBrowse_Click(object sender, EventArgs e) { if (Selection.Count == 1) { IObjetDeEasyQuery obj = Selection[0] as IObjetDeEasyQuery; CResultAErreur result = CResultAErreur.True; ((CEasyQuery)ObjetEdite).ClearCache(); if (obj != null) { result = obj.GetDatas(((CEasyQuery)ObjetEdite).ListeSources); } if (!result || !(result.Data is DataTable)) { CFormAfficheErreur.Show(result.Erreur); } else { CFormVisuTable.ShowTable(result.Data as DataTable); } } }