private void button3_Click_1(object sender, EventArgs e)
{
//Ribbon1 a = new Ribbon1();
prefix = "";
//FilterLog.WriteToLog("Debug Level 1:launch filter management");
managefilters(this.autochoose);
this.listBox1.Items.Clear();
lastsimpleidx = 0;
// ListSingle = new OleDbCommand(simplewherelessSQL, connection);
using (OleDbDataReader calitm = ListSingle.ExecuteReader())
{
int i = 0;
while (calitm.Read())
{
this.listBox1.Items.Add(calitm["[prefix]FilterDescription".Replace("[prefix]", prefix)].ToString());
lastsimpleidx++;
}
}
using (OleDbDataReader calitm = ListMaster.ExecuteReader())
{
int i = 0;
while (calitm.Read())
{
this.listBox1.Items.Add(calitm["[prefix]FilterListDescription".Replace("[prefix]", prefix)].ToString());
}
if (this.listBox1.Items.Count > 0)
{
this.listBox1.SelectedIndex = 0;
}
}
hiddenInstance.updatecombos();
}
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();
}
