//------------------------------------------------------- protected override CResultAErreur MySerialize(C2iSerializer serializer) { int nVersion = GetNumVersion(); CResultAErreur result = serializer.TraiteVersion(ref nVersion); if (result) { result = base.MySerialize(serializer); } if (!result) { return(result); } result = serializer.TraiteObject <ITableDefinition>(ref m_definitionTable); if (!result) { return(result); } serializer.TraiteListe <IColumnDeEasyQuery>(m_listeColonnes); if (nVersion >= 1) { serializer.TraiteObject <CCAMLQuery>(ref m_CAMLQuery); } else { m_CAMLQuery = new CCAMLQuery(); } return(result); }
//----------------------------------------------------------------------------------- public void Init( CEasyQuery easyQuery, CCAMLQuery query, IEnumerable <CCAMLItemField> fields) { m_easyQuery = easyQuery; m_fields = fields; if (query != null) { m_query = CCloner2iSerializable.Clone(query) as CCAMLQuery; } else { m_query = new CCAMLQuery(); } InitArbre(); }
//----------------------------------------------------------------------------------- public void Init(CODEQFiltreCAML filtre) { m_objetFiltre = filtre; m_txtNomTable.Text = filtre.NomFinal; m_chkUseCache.Checked = filtre.UseCache; m_ctrlFormulesNommees.TypeFormuleNomme = typeof(CColonneEQCalculee); m_ctrlFormulesNommees.Init(m_objetFiltre.ColonnesCalculees.ToArray(), typeof(CDataRowForChampCalculeODEQ), m_objetFiltre); if (filtre.CAMLQuery != null) { m_query = CCloner2iSerializable.Clone(filtre.CAMLQuery) as CCAMLQuery; } else { m_query = new CCAMLQuery(); } m_panelCAML.Init(m_objetFiltre.Query, m_query, filtre.TableSource.CAMLFields); m_panelPostFilter.Init(filtre); }
//---------------------------------------------- public CResultAErreur GetDatasWithCAML( CEasyQuerySource source, CEasyQuery easyQuery, CCAMLQuery camlquery, params string[] strIdsColonnesSource) { CResultAErreur result = CResultAErreur.True; CSharepointConnexion filler = source.Connexion as CSharepointConnexion; if (filler != null) { List <string> strColsShp = new List <string>(); foreach (IColumnDefinition col in Columns) { if (strIdsColonnesSource.Contains(col.Id)) { CColonneDefinitionSharepoint colShp = col as CColonneDefinitionSharepoint; if (colShp != null) { strColsShp.Add(colShp.SharepointId); } } } string strCAMLQuery = ""; if (camlquery != null && easyQuery != null) { strCAMLQuery = camlquery.GetXmlText(easyQuery); } System.Data.DataTable table = filler.GetDataWithCAML( this, strCAMLQuery, strColsShp.ToArray()); result.Data = table; } return(result); }
public void Init(CODEQTableFromBase obj) { m_tableFromBase = obj; if (m_tableFromBase.TableDefinition != null) { m_lblSource.Text = m_tableFromBase.TableDefinition.TableName; } else { m_lblSource.Text = "?"; } m_txtNomTable.Text = m_tableFromBase.NomFinal; m_chkUseCache.Checked = m_tableFromBase.UseCache; FillListeColonnes(); FillListeFormulesNommees(); if (m_controleOptions != null) { m_pageOptions.Control = null; m_controleOptions.Dispose(); } m_controleOptions = null; m_controleOptions = CAllocateurControleOptionTableDefinition.GetControleOptions(obj.TableDefinition); if (m_controleOptions == null) { if (m_tabControl.TabPages.Contains(m_pageOptions)) { m_tabControl.TabPages.Remove(m_pageOptions); } } else { if (!m_tabControl.TabPages.Contains(m_pageOptions)) { m_tabControl.TabPages.Add(m_pageOptions); } m_pageOptions.Control = (Control)m_controleOptions; m_controleOptions.FillFromTable(m_tableFromBase.TableDefinition); } CCAMLQuery query = obj.CAMLQuery; if (query == null) { query = new CCAMLQuery(); } IEnumerable <CCAMLItemField> fields = null; ITableDefinitionRequetableCAML tableCAML = obj.TableDefinition as ITableDefinitionRequetableCAML; if (tableCAML != null) { fields = tableCAML.CAMLFields; } else { if (obj.TableDefinition != null) { fields = obj.CAMLFields; } else { fields = new List <CCAMLItemField>(); } } m_panelCAML.Init(m_tableFromBase.Query, query, fields); m_panelPostFilter.Init(obj); }