//-------------------------------------------------------------- public void Init( CEasyQuery query, IEnumerable <CCAMLItemField> fields, CCAMLItemComparaison comparaison) { m_query = query; m_comparaison = comparaison; List <CCAMLItemComparaison> itemsComparaison = new List <CCAMLItemComparaison>(); List <CCAMLOperateurComparaison> ops = new List <CCAMLOperateurComparaison>(); foreach (ECAMLComparaison op in CCAMLOperateurComparaison.ValeursEnumPossibles) { ops.Add(new CCAMLOperateurComparaison(op)); } m_comboOperateur.ListDonnees = ops; m_comboOperateur.ProprieteAffichee = "Libelle"; m_comboOperateur.SelectedValue = new CCAMLOperateurComparaison(comparaison.Operateur); m_comboChamp.ListDonnees = fields; m_comboChamp.ProprieteAffichee = "Libelle"; m_comboChamp.SelectedValue = comparaison.Field; m_txtFormuleValeur.Init( new CFournisseurGeneriqueProprietesDynamiques(), new CObjetPourSousProprietes(m_query)); m_txtFormuleValeur.Formule = comparaison.Valeur; m_txtFormuleCondition.Init( new CFournisseurGeneriqueProprietesDynamiques(), new CObjetPourSousProprietes(m_query)); m_txtFormuleCondition.Formule = comparaison.Condition; }
//--------------------------------------------------------------- private void m_btnLoad_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = "Easy query|*.esq|All files|*.*"; if (dlg.ShowDialog() == DialogResult.OK) { CEasyQuery query = m_editeur.ObjetEdite as CEasyQuery; CResultAErreur res = CSerializerObjetInFile.ReadFromFile(query, "QUERY", dlg.FileName); if (!res) { CEasyQueryAvecSource qas = new CEasyQueryAvecSource(); CResultAErreur res2 = CSerializerObjetInFile.ReadFromFile(qas, "QUERYWITHSOURCE", dlg.FileName); if (res2) { m_bSaveWithSource = true; query = qas.GetEasyQuerySansSource(); res = CResultAErreur.True; } } else { m_bSaveWithSource = false; } if (!res) { CFormAlerte.Afficher(res.Erreur); } Init(query); /*m_editeur.ObjetEdite = query;*/ m_editeur.Refresh(); } }
//------------------------------------------------- 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); }
//------------------------------------------ protected override void MyGetXmlText(CEasyQuery query, StringBuilder bl, int nIndent) { if (BaliseOperateur.Length > 0 && m_champ != null) { AddIndent(bl, nIndent); bl.Append("<"); bl.Append(BaliseOperateur); bl.Append(">"); bl.Append(Environment.NewLine); m_champ.GetXmlText(query, bl, nIndent + 1); bl.Append(Environment.NewLine); bl.Append("<Value Type='Text'>"); if (m_valeur != null) { CContexteEvaluationExpression ctx = new CContexteEvaluationExpression(query); CResultAErreur result = m_valeur.Eval(ctx); if (result && result.Data != null) { bl.Append(result.Data.ToString()); } } bl.Append("</Value>"); bl.Append(Environment.NewLine); bl.Append("</"); bl.Append(BaliseOperateur); bl.Append(">"); bl.Append(Environment.NewLine); } }
//-------------------------------------------- public void GetRowFilter(CEasyQuery query, StringBuilder bl) { if (ShouldApply(query)) { MyGetRowFilter(query, bl); } }
void itemSource_DropDownOpening(object sender, EventArgs e) { ToolStripMenuItem item = sender as ToolStripMenuItem; CEasyQuery query = ObjetEdite as CEasyQuery; CODEQFromObjetsSource tableFromSource = Selection.Count == 1?Selection[0] as CODEQFromObjetsSource:null; if (item != null && query != null && tableFromSource != null) { item.DropDownItems.Clear(); List <IObjetDeEasyQuery> lst = new List <IObjetDeEasyQuery>(); foreach (IObjetDeEasyQuery obj in query.Childs) { lst.Add(obj); } lst.Sort((x, y) => x.NomFinal.CompareTo(y.NomFinal)); foreach (IObjetDeEasyQuery objet in lst) { if (objet.Id != tableFromSource.Id) { ToolStripMenuItem itemNewSource = new ToolStripMenuItem(objet.NomFinal); itemNewSource.Tag = objet; itemNewSource.Click += itemNewSource_Click; item.DropDownItems.Add(itemNewSource); } } } }
public void InitFromColonneSource(IColumnDeEasyQuery colonne, CODEQBase objetDeQuery) { m_colonneSource = colonne; CEasyQuery query = objetDeQuery.Query; if (query != null) { //cherche la source ITableDefinition tableDef = null; IColumnDefinition colDef = null; IsReadOnly = true; Description = ""; if (query.FindSource(colonne, objetDeQuery, out tableDef, out colDef)) { CColumnDefinitionSNMP colSnmp = colDef as CColumnDefinitionSNMP; if (colSnmp != null) { if (tableDef is CTableDefinitionSNMP || tableDef is CTableDefinitionSnmpOfScalar) { Description = colSnmp.Description; IsReadOnly = colSnmp.IsReadOnly; } } } } }
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 GetXmlText(CEasyQuery query, StringBuilder bl, int nIndent) { if (ShouldApply(query)) { MyGetXmlText(query, bl, nIndent); } }
//------------------------------------------ public void FillFromTable(CODEQBase objetDeRequete) { CEasyQuery query = objetDeRequete.Query; if (query == null) { return; } IdObjetDeQuerySource = objetDeRequete.Id; HashSet <string> champsASupprimer = new HashSet <string>(); foreach (IChampEntiteSNMP champ in Champs.ToArray()) { if (champ is CChampEntiteSnmpStandard) { champsASupprimer.Add(champ.Id); } } foreach (IColumnDeEasyQuery col in objetDeRequete.Columns) { CChampEntiteFromQuery champ = Champs.FirstOrDefault(c => c is CChampEntiteFromQuery && ((CChampEntiteFromQuery)c).ColonneSource.Id == col.Id) as CChampEntiteFromQuery; if (champ == null) { champ = new CChampEntiteFromQuery(); ChampsListe.Add(champ); } champ.InitFromColonneSource(col, objetDeRequete); } }
public static void EditeOptions(CEasyQuery query) { using (CFormOptionsDeQuery frm = new CFormOptionsDeQuery()) { frm.m_query = query; frm.ShowDialog(); } }
//------------------------------------ protected override void MyGetXmlText(CEasyQuery query, StringBuilder bl, int nIndent) { AddIndent(bl, nIndent); bl.Append("<FieldRef "); bl.Append(m_strXmlAttrib); bl.Append("='"); bl.Append(m_strXmlAttribValue); bl.Append("'/>"); }
//-------------------------------------------- public string GetRowFilter(CEasyQuery query) { StringBuilder bl = new StringBuilder(); if (m_root != null) { m_root.GetRowFilter(query, bl); } return(bl.ToString()); }
//------------------------------------------------------------------------------ private CODEQBase GetObjetDeQuerySource() { CEasyQuery query = m_typeAgent.Queries.FirstOrDefault(c => c.GetObjet(m_typeEntite.IdObjetDeQuerySource) != null); if (query != null) { return(query.Childs.FirstOrDefault(o => o is IObjetDeEasyQuery && ((IObjetDeEasyQuery)o).Id == m_typeEntite.IdObjetDeQuerySource) as CODEQBase); } return(null); }
//----------------------------------------------------------------------------------- public void Init( CEasyQuery easyQuery, IDHFiltre filtre, CODEQTableFromDataHotel table) { m_easyQuery = easyQuery; m_table = table; m_filtreOriginal = filtre; InitArbre(); }
//--------------------------------------------------------------- public void Init(CEasyQuery query) { m_query = query; Size sz = new Size(Math.Max(m_query.Size.Width, 3000), Math.Max(m_query.Size.Height, 3000)); m_query.Size = sz; m_arbre.Init(query.ListeSources); m_editeur.ObjetEdite = query; m_panelVariables.Init(query); }
//--------------------------------------------------------------- private void m_lnkAddQuery_LinkClicked(object sender, EventArgs e) { CEasyQuery query = new CEasyQuery(); if (EditeQuery(query)) { m_baseHandlers.AddQuery(query); FillListeQueries(); } }
public string GetXmlText(CEasyQuery query) { StringBuilder bl = new StringBuilder(); if (m_root != null) { m_root.GetXmlText(query, bl, 0); } return(bl.ToString()); }
//----------------------------------------------------------------------------------- public void InitForChampFixe( CEasyQuery easyQuery, IDHFiltre filtre, CODEQTableFromDataHotel table, string strIdChamp) { m_easyQuery = easyQuery; m_table = table; m_filtreOriginal = filtre; InitArbre(); }
//--------------------------------------------------------------- private bool EditeQuery(CEasyQuery query) { CEasyQuerySource source = new CEasyQuerySource(); CDynamicSnmpAgent agent = new CDynamicSnmpAgent(); agent.Connexion = m_connexion; source.AddTableFiller(new CSnmpTableFiller(agent)); CTableDefinitionSNMP.FromMib(source, m_browser.RootDefinition, source.RootFolder); query.Source = source; return(CFormEditEasyQuery.EditeQuery(query)); }
//--------------------------------------------------------------- private void m_lnkRemoveQuery_LinkClicked(object sender, EventArgs e) { if (m_wndListeQueries.SelectedItems.Count == 1) { CEasyQuery query = m_wndListeQueries.SelectedItems[0] as CEasyQuery; if (query != null) { m_baseHandlers.RemoveQuery(query); } } }
//----------------------------------------------- public CResultAErreur InitChamps(CEasyQueryInDb queryInDb) { CResultAErreur result = CResultAErreur.True; m_queryInDb = queryInDb; CEasyQuery query = queryInDb.EasyQueryAvecSources; m_panelQuery.Init(query); result = m_extLinkField.FillDialogFromObjet(queryInDb); return(result); }
//-------------------------------------------------------------- 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 static bool EditeComparaison(CEasyQuery query, IEnumerable <CCAMLItemField> fields, CCAMLItemComparaison itemComparaison) { CFormEditeComposantCAMLComparaison frm = new CFormEditeComposantCAMLComparaison(); frm.Init(query, fields, itemComparaison); DialogResult res = frm.ShowDialog(); frm.Dispose(); return(res == DialogResult.OK); }
//------------------------------------------ public CODEQBase GetObjetDeQuery(CTypeAgentPourSupervision typeAgent) { if (IdObjetDeQuerySource != null) { CEasyQuery query = typeAgent.Queries.FirstOrDefault(q => q.GetObjet(IdObjetDeQuerySource) != null); if (query != null) { return(query.Childs.FirstOrDefault(c => c is CODEQBase && ((CODEQBase)c).Id == IdObjetDeQuerySource) as CODEQBase); } } return(null); }
//-------------------------------------------------------------- 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); }
//------------------------------------------------------------ private void SaveWithoutSources() { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Easy query|*.esq|All files|*.*"; if (dlg.ShowDialog() == DialogResult.OK) { CEasyQuery query = m_editeur.ObjetEdite as CEasyQuery; CSerializerObjetInFile.SaveToFile(query, "QUERY", dlg.FileName); m_bSaveWithSource = false; } }
//------------------------------------------------------------------- public object[] GetValues(CChartSetup chart) { List <object> lstValeurs = new List <object>(); CParametreSourceChart p = chart.ParametresDonnees.GetSourceFV(SourceId); if (p != null) { CEasyQuery query = p.GetSource(chart) as CEasyQuery; if (query != null) { //trouve la table DataTable table = query.GetTable(TableName); if (table != null) { DataColumn col = table.Columns[ColumnName]; if (col != null) { foreach (DataRow row in table.Rows) { object val = row[col]; if (val == DBNull.Value) { lstValeurs.Add(null); } else { lstValeurs.Add(val); } } } else if (Formule != null) { foreach (DataRow row in table.Rows) { CDynamicDataTableRow dr = new CDynamicDataTableRow(row); CContexteEvaluationExpression ctx = new CContexteEvaluationExpression(dr); CResultAErreur result = Formule.Eval(ctx); if (result) { lstValeurs.Add(result.Data); } else { lstValeurs.Add(null); } } } } } } return(lstValeurs.ToArray()); }
//------------------------------------------------------------ private void SaveWithSources() { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Easy query|*.esq|All files|*.*"; if (dlg.ShowDialog() == DialogResult.OK) { CEasyQuery query = m_editeur.ObjetEdite as CEasyQuery; CEasyQueryAvecSource qas = CEasyQueryAvecSource.FromQuery(query); CSerializerObjetInFile.SaveToFile(qas, "QUERYWITHSOURCE", dlg.FileName); m_bSaveWithSource = true; } }
//------------------------------------------------------- protected override CResultAErreur GetDatasHorsCalculees(CListeQuerySource sources) { CEasyQuery query = Query; CResultAErreur result = CResultAErreur.True; if (result && TypeSource == null) { result.EmpileErreur(I.T("###Table object must be specified |")); } if (query == null || sources == null) { result.EmpileErreur(I.T("###Query needs a source to provide datas|")); } C2iRequeteAvancee requete = new C2iRequeteAvancee(); requete.TableInterrogee = CContexteDonnee.GetNomTableForType(TypeSource); result = FiltreDynamique.GetFiltreData(); if (!result) { return(result); } if (result.Data is CFiltreData) { requete.FiltreAAppliquer = result.Data as CFiltreData; } foreach (IColumnDeEasyQuery col in Columns) { CColumnDeEasyQueryChampDeRequete colR = col as CColumnDeEasyQueryChampDeRequete; requete.ListeChamps.Add(colR); } DataTable table = null; if (requete.ListeChamps.Count > 0) { result = requete.ExecuteRequete(CContexteDonneeSysteme.GetInstance().IdSession); if (!result) { result.EmpileErreur(I.T("###Error on table @1|")); return(result); } table = result.Data as DataTable; } else { table = new DataTable(); } table.TableName = NomFinal; return(result); }