//---------------------------------------------------------------
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);
}
}
}
