public FilterForm()
{
InitializeComponent();
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Issue' table. You can move, or remove it, as needed.
this.issueTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Issue);
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Employees' table. You can move, or remove it, as needed.
this.employeesTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Employees);
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Delivery' table. You can move, or remove it, as needed.
this.deliveryTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Delivery);
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Supply' table. You can move, or remove it, as needed.
this.supplyTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Supply);
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Types_of_Products' table. You can move, or remove it, as needed.
this.types_of_ProductsTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Types_of_Products);
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Suppliers' table. You can move, or remove it, as needed.
this.suppliersTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Suppliers);
// TODO: This line of code loads data into the 'computer_Hardware_DepartmentDataSet.Models' table. You can move, or remove it, as needed.
this.modelsTableAdapter.Fill(this.computer_Hardware_DepartmentDataSet.Models);
labelSource.Text = "Таблиця: ";
CurrentBindingSource = modelsBindingSource;
TablesList.AddRange(new string[] { "Моделі", "Видача", "Поставки", "Компанії", "Види товарів", "Доставка", "Співробітники" });
comboBoxSource.DropDownStyle = ComboBoxStyle.DropDownList;
comboBoxFilter.DropDownStyle = ComboBoxStyle.DropDownList;
foreach (string s in TablesList)
{
comboBoxSource.Items.Add(s);
}
}
/// <summary>
/// Show items on page load
/// </summary>
private void ShowItems(bool show = false)
{
// Disable the connection string textbox
txtConnString.Enabled = false;
//Hide labels
lblTables.Show();
lblViews.Show();
lbloutDir.Show();
//Hide Textboxes and list
TablesList.Show();
ViewsList.Show();
txtoutDir.Show();
//Show buttons
btnGenerate.Show();
btnReset.Show();
}
/// <summary>
/// Hide items on page load
/// </summary>
private void HideItems(bool show = false)
{
// Enable the connection string textbox
txtConnString.Enabled = true;
//Hide labels
lblTables.Hide();
lblViews.Hide();
lbloutDir.Hide();
//Hide Textboxes and list
TablesList.Hide();
ViewsList.Hide();
txtoutDir.Hide();
//Hide buttons
btnGenerate.Hide();
btnReset.Hide();
}
public static SelectFromBuilder FromCombinedExpression <TCombinedModel, TNewModel>(TablesList tablesList, Expression <Func <TCombinedModel, TNewModel> > prBody)
{
var builder = new SelectFromBuilder();
builder.LeftJoinsExpressions = tablesList.JoinExpressions;
var options = new EvaluationOptions();
foreach (var tablePlaceholder in tablesList.Tables)
{
builder.AddTable(tablePlaceholder);
// options.ParameterToTableAlias.Add(tablePlaceholder.Name, tablePlaceholder);
}
var tableToPlaceholder = tablesList.Tables.ToDictionary(x => x.Name);
TypedExpression exp;
switch (prBody.Body)
{
/* For:
* .Select(x => new {
* M1 = x.M1,
* M2_name = x.M2.Name1,
* M3_calc = x.M2.Id * 2,
* })
*/
case NewExpression newExpression:
{
IEnumerable <Expression> args = newExpression.Arguments;
var resultProcessor = new AnonymousTypeSelectResultProcessor <TNewModel>();
builder.SelectResultProcessor = resultProcessor;
foreach (var argExpression in args)
{
// Member is Table (like M1 = x.M1)
if (argExpression is MemberExpression memberExpression && ModelsRegistry.IsTable(memberExpression.Type))
{
var tablePlaceholder = tableToPlaceholder[memberExpression.Member.Name];
var table = tablePlaceholder.Table;
var tableTestRawQuery = new RawQuery();
tableTestRawQuery.AppendTable(tablePlaceholder);
tableTestRawQuery.Append(" IS NULL");
builder.AddSelectPart(tableTestRawQuery, KDPgValueTypeInstances.Boolean);
foreach (var column in table.Columns)
{
var rq = new RawQuery();
rq.AppendColumn(column, tablePlaceholder);
builder.AddSelectPart(rq, column.Type);
}
resultProcessor.AddModelEntry(table);
}
public void CreateNewElemTablesList(string tblName)
{
BindData(tblName);
TablesList.SetSelected(TablesList.Items.Count - 1, true);
}
