Система бизнес-аналитики Stimulsoft | Форум

Код: Выделить всё

public void ReloadNodes(...)
{
	.....
        this.ExpandAll(); 
/// Выполнение диалога построителя запросов
/// 
public void Execute()
{
    using (Stimulsoft.Database.QueryBuilderForm form = new Stimulsoft.Database.QueryBuilderForm())
    {
        form.QueryBuilder.SyntaxProvider = createSyntaxProvider();
        form.QueryBuilder.MetadataProvider = createMetadataProvider();

        form.QueryBuilder.SQL = sql;

        setFieldValue(form, "PrevSql", sql);

        metadataTree = (Stimulsoft.Database.MetadataTree)getFieldValue(form.QueryBuilder, "fMetadataTree");
        sqlEditor = (Stimulsoft.Report.Design.Editors.StiCodeEditor)getFieldValue(form, "SqlEditor");

        form.QueryBuilder.RefreshMetadata();
        form.SaveQuery += new EventHandler(saveQueryHandler);
        form.Load += new EventHandler(loadHandler);

        DialogResult res = form.ShowDialog();
        if (res == DialogResult.OK || res == DialogResult.Yes)
        {
            this.sql = getQueryText();
        }
    }
}

private void saveQueryHandler(object sender, EventArgs e)
{
    this.sql = getQueryText(); // sender as string;

    EventHandler temp = SavingQueryText;
    if (temp != null)
    {
        temp(this, e);
    }
}

private FieldInfo getFieldInfo(object recipient, string fieldName)
{
    FieldInfo fi = recipient.GetType().GetField(fieldName, BindingFlags.NonPublic | BindingFlags.Instance);
    if (fi != null)
    {
        return fi;
    }
    else
    {
        throw new Exception("Field '{0}' not found in object {1}", fieldName, recipient.GetType().Name);
    }
}

private void setFieldValue(object recipient, string fieldName, object value) 
{
    getFieldInfo(recipient, fieldName).SetValue(recipient, value);
}

private object getFieldValue(object recipient, string fieldName)
{
    return getFieldInfo(recipient, fieldName).GetValue(recipient);
}

private Stimulsoft.Database.MetadataTree metadataTree;
private void loadHandler(object sender, EventArgs e)
{
	// 
	// Здесь пытаемся открыть дерево метаданных как нам надо...
	// 

    if (metadataTree != null)
    {
        metadataTree.CollapseAll();
        if (metadataTree.Nodes.Count > 0)
        {
            if (Connection is PDPStorageDbConnection)
            {
                metadataTree.Nodes[0].Text = Connection.ConnectionString;
            }
            metadataTree.Nodes[0].Expand();
        }
    }
}

private Stimulsoft.Report.Design.Editors.StiCodeEditor sqlEditor;
private string getQueryText()
{
    return sqlEditor.Text;
}