private void ucSearchCriteriaInput1_RequestedAddCriteria(ucSearchCriteriaItem uCriteriaItem)
{
this.ucSearchCriteriaSet1.AddCriteria(uCriteriaItem);
}
public void AddCriteria(ucSearchCriteriaItem uCriteriaItem)
{
this.flpCritieraSet.Controls.Add(uCriteriaItem);
uCriteriaItem.RequestedRemoveCriteria +=new ucSearchCriteriaItem.RemoveClicked(uCriteriaItem_RequestedRemoveCriteria);
}
private void btnAddCriteria_Click(object sender, EventArgs e)
{
ucSearchCriteriaItem uItem = new ucSearchCriteriaItem();
String SearchCrit = "";
String SearchCrit2 = "";
String ActualSQL = "";
if (this.CurrentInputObject == null)
return;
if (this.CurrentInputObject.GetType() == typeof(TextBox))
{
TextBox tBox = (TextBox)this.CurrentInputObject;
SearchCrit = tBox.Text;
if (this.cboLogic.Text == "BETWEEN")
{
TextBox tBox2 = (TextBox)this.CurrentInputObject2;
SearchCrit2 = tBox2.Text;
ActualSQL = this.cboCriteriaID.Text + " " + this.cboLogic.Text + " '" + SearchCrit + "' AND '" + SearchCrit2 + "'";
}
else
{
ActualSQL = this.cboCriteriaID.Text + " " + this.cboLogic.Text + " '" + SearchCrit + "'";
}
}
else if (this.CurrentInputObject.GetType() == typeof(ComboBox))
{
ComboBox cBox = (ComboBox)this.CurrentInputObject;
SearchCrit = cBox.Text;
if (this.cboLogic.Text == "BETWEEN")
{
ComboBox cBox2 = (ComboBox)this.CurrentInputObject2;
SearchCrit2 = cBox2.Text;
string[] id = SearchCrit.Split(':');
string[] id2 = SearchCrit2.Split(':');
ActualSQL = this.cboCriteriaID.Text + " " + this.cboLogic.Text + " '" + id[0] + "' AND '" + id2[0] + "'";
}
else
{
string[] id = SearchCrit.Split(':');
ActualSQL = this.cboCriteriaID.Text + " " + this.cboLogic.Text + " '" + id[0] + "'";
}
}
if (this.cboLogic.Text == "BETWEEN")
{
uItem.SetCriteriaText(this.cboCriteriaID.Text + " " + this.cboLogic.Text + " " + SearchCrit + " AND " + SearchCrit2);
}
else
{
uItem.SetCriteriaText(this.cboCriteriaID.Text + " " + this.cboLogic.Text + " " + SearchCrit);
}
uItem.ActualCriteriaSQL = ActualSQL;
if (this.RequestedAddCriteria != null)
this.RequestedAddCriteria(uItem);
}
