public SearchForm(RedDataSet dataset)
{
InitializeComponent();
tables = dataset.tables.Where(pair => !string.IsNullOrEmpty(pair.Value.SearchQuery)).Select(pair => pair.Key).ToList();
comboBox1.DataSource = tables;
comboBox1.Refresh();
}
private void InitForm()
{
dataSet = new RedDataSet();
lstTables.Items.Clear();
lstReqs.Items.Clear();
foreach (var t in config.Tables)
{
dataSet.AddTable(t.query, t.name, t.SearchQuery == null? null: t.SearchQuery.Query, context);
if (t.Comboboxes != null)
{
foreach (var c in t.Comboboxes)
{
dataSet.tables[t.name].AddComboBox(c.name, new RedComboBox(c.query, c.name));
}
}
if (t.Columns != null)
{
foreach (var c in t.Columns)
{
dataSet.tables[t.name].AddColumnAliasHere(c.Name, c.Alias);
}
}
lstTables.Items.Add(t.name);
}
foreach (var r in config.Requests)
{
dataSet.AddView(r.query, r.name, r.desc, context);
if (r.Comboboxes != null)
{
foreach (var c in r.Comboboxes)
{
dataSet.views[r.name].AddComboBox(c.name, new RedComboBox(c.query, c.name));
}
}
lstReqs.Items.Add(r.name);
}
if (currentUser.UserType == UserType.Admin)
{
адмініструванняToolStripMenuItem.Visible = true;
dataSet.AddTable("Select Id, Login, Pass, UserType From Users", "Користувачі", null, context);
dataSet.tables["Користувачі"].AddColumnAliasHere("Login", "Логін");
dataSet.tables["Користувачі"].AddColumnAliasHere("Pass", "Пароль");
dataSet.tables["Користувачі"].AddColumnAliasHere("UserType", "ТипКористувача");
dataSet.tables["Користувачі"].AddComboBox("UserType", new RedComboBox("Select Id, TypeName from UserTypes", "UserType"));
lstTables.Items.Add("Користувачі");
}
}
private Red.RedDataSet GetDataSet(DBConfig config, RedContext context)
{
var dataSet = new RedDataSet();
foreach (var t in config.Tables)
{
dataSet.AddTable(t.query, t.name, t.SearchQuery == null? null: t.SearchQuery.Query, context);
if (t.Comboboxes != null)
{
foreach (var c in t.Comboboxes)
{
dataSet.tables[t.name].AddComboBox(c.name, new RedComboBox(c.query, c.name));
}
}
if (t.Columns != null)
{
foreach (var c in t.Columns)
{
dataSet.tables[t.name].AddColumnAliasHere(c.Name, c.Alias);
}
}
}
foreach (var r in config.Requests)
{
dataSet.AddView(r.query, r.name, r.desc, context);
if (r.Comboboxes != null)
{
foreach (var c in r.Comboboxes)
{
dataSet.views[r.name].AddComboBox(c.name, new RedComboBox(c.query, c.name));
}
}
}
return(dataSet);
}
