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