public void filterapply(GridEX grid, string filtername, CreateFilterForm hiddeninstanceinitialized)
{
foreach (string item in hiddeninstanceinitialized.comboBox7.Items)
{
if (item == filtername)
{
hiddeninstanceinitialized.comboBox7.SelectedItem = filtername;
hiddeninstanceinitialized.comboBox7_SelectedIndexChanged(this, new EventArgs());
List <string> stacknames = new List <string>();
hiddeninstanceinitialized.processList(ref grid, false, 1, stacknames);
}
}
foreach (string item in hiddeninstanceinitialized.comboBox1.Items)
{
if (item == filtername)
{
hiddeninstanceinitialized.comboBox1.SelectedItem = filtername;
//hiddeninstanceinitialized.comboBox1_SelectedIndexChanged(this, new EventArgs());
GridEXColumn column = grid.RootTable.Columns[hiddeninstanceinitialized.comboBox5.SelectedValue.ToString()];
GridEXFilterCondition singlefiltercondtion = hiddenInstance.CreateSinglefilter(hiddenInstance.textBox6.Text, hiddenInstance.textBox7.Text, hiddenInstance.comboBox6.SelectedValue.ToString(), column);
grid.RootTable.FilterCondition = singlefiltercondtion;
grid.RootTable.ApplyFilter(singlefiltercondtion);
break;
}
}
grid.Refetch();
grid.Select();
}
public void managefilters(string direction = "???")
{
string singleFiltersSQL = "";
string CompositeListPartsSQL = "";
string appntmentsSQL = "";
string CompositeListSQL = "";
string direcction = ""; string wherefilter = "";
singleFiltersSQL = "select * from FilterSingle";
appntmentsSQL = "select * from Entries order by DateTime1 asc";
CompositeListSQL = "select * from FilterList";
CompositeListPartsSQL = "select * from FilterListParts where FilterListParent='[parameter1]' order by FilterListPartID";
direcction = "Έσοδα";
if (connection == null || connection.State == ConnectionState.Closed)
{
connection.Open();
}
OleDbCommand allitems = new OleDbCommand(appntmentsSQL, connection);
//List<Entries2Fiilter> appntmntlist = localUpload2Form(allitems, direcction);
CreateFilterForm createfilters = new CreateFilterForm(direction, this.data, this.metadatainFilterForm, "");
createfilters.Path_readwrite = this.Path_readwrite;
createfilters.AppointmentswherelessSQL = appntmentsSQL;
createfilters.CompositeListPartsSQL = CompositeListPartsSQL;
createfilters.simplewherelessSQL = singleFiltersSQL;
createfilters.ListMasterSQL = CompositeListSQL;
createfilters.onedatabaseConn = connection;
createfilters.prefix = "";
createfilters.ShowDialog();
}
private void appointments_advanced_filter_Load(object sender, EventArgs e)
{
Path_readwrite = Application.ExecutablePath;
int formmax = this.Height - 100;
int Padding = 3;
prefix = "";
this.filterEditor2.ApplyFilter();
selectfiltered(this.gridEX2);
this.gridEX2.Refetch();
this.gridEX2.Select();
this.ComboBox8storageDesc = new List <string>();
string wherefilter = "(true)";
string appntmntfilter = "(true)";
if (true)
{
autochoose = "Διαχείρηση Φίλτρων Εσόδων";
}
string CompositeListSQL = ("select * from [prefix]FilterList where " + wherefilter + " ").Replace("[prefix]", prefix);
if (connection == null || connection.State == ConnectionState.Closed)
{
connection.Open();
}
string simplewherelessSQL = "select * from [prefix]FilterSingle".Replace("[prefix]", prefix);
ListSingle = new OleDbCommand(simplewherelessSQL, connection);
using (OleDbDataReader calitm = ListSingle.ExecuteReader())
{
int i = 0;
/// this.comboBox7.Items.Add(this.combo7Text4AutomaticProcess);
/// you, out!!! den thimamai giati xrisimopoiithike
/// na diagrafei sto epomeno checkpoint
while (calitm.Read())
{
this.listBox1.Items.Add(calitm["[prefix]FilterDescription".Replace("[prefix]", prefix)].ToString());
lastsimpleidx++;
}
}
ListMaster = new OleDbCommand(CompositeListSQL, connection);
using (OleDbDataReader calitm = ListMaster.ExecuteReader())
{
int i = 0;
/// this.comboBox7.Items.Add(this.combo7Text4AutomaticProcess);
/// you, out!!! den thimamai giati xrisimopoiithike
/// na diagrafei sto epomeno checkpoint
while (calitm.Read())
{
this.listBox1.Items.Add(calitm["[prefix]FilterListDescription".Replace("[prefix]", prefix)].ToString());
}
if (this.listBox1.Items.Count > 0)
{
this.listBox1.SelectedIndex = 0;
}
}
Dictionary <string, string> allfields = new Dictionary <string, string>();
for (int i = 0; i < arrayofcolumns.Length; i++)
{
allfields.Add(arrayofcolumns[i], arrayofcolumnnames[i]);
}
hiddenInstance = new CreateFilterForm(autochoose, this.data, metadatainFilterForm, "");
hiddenInstance.CompositeListPartsSQL = ("select* from [prefix]FilterListParts where [prefix]FilterListParent = '[parameter1]' order by [prefix]FilterListPartID").Replace("[prefix]", prefix);
hiddenInstance.simplewherelessSQL = "select * from [prefix]FilterSingle".Replace("[prefix]", prefix);
hiddenInstance.ListMasterSQL = "select * from [prefix]FilterList".Replace("[prefix]", prefix);
hiddenInstance.onedatabaseConn = connection;
hiddenInstance.debuglevel = 4;
hiddenInstance.comboBox5.DataSource = new BindingSource(allfields, null);
hiddenInstance.comboBox5.DisplayMember = "Value";
hiddenInstance.comboBox5.ValueMember = "Key";
hiddenInstance.loadingvaluesdontrunchangeindexevents = false;
hiddenInstance.updatecombos();
}
