public void SetFilter(SQLiteSettings.FilterElementModel filter, List <UcTableObjects.FieldInfoFull> fList)
{
fieldInfo fi = classesOfMetods.getFieldInfo(Convert.ToInt32(filter.Column));
switch (fi.type)
{
case 1:
txtValue.Text = filter.Value.ToString();
break;
case 2:
txtValue.Text = filter.Value.ToString();
break;
case 3:
dateTimePicker1.Value = Convert.ToDateTime(filter.Value);
break;
case 4:
dateTimePicker1.Value = Convert.ToDateTime(filter.Value);
break;
case 6:
txtValue.Text = filter.Value.ToString();
break;
default:
txtValue.Text = filter.Value.ToString();
break;
}
_currentFilter = fList.Find(w => w.idField == fi.idField);
this.ListIS = fList;
SetFilterType(filter);
}
private void CbListColumnSelectedIndexChanged(object sender, EventArgs e)
{
_currentFilter = cbListColumn.SelectedItem as UcTableObjects.FieldInfoFull;
setValid();
var currentText = cbListFilter.Text;
cbListFilter.Items.Clear();
if (_currentFilter == null)
{
return;
}
//DateTime? date;
if (_currentFilter.is_reference)
{
SetObject(true, GetValue());
cbListFilter.Items.AddRange(_findListText);
}
else
{
switch (_currentFilter.TypeField)
{
case TypeField.Integer:
SetObject(true, GetValue());
cbListFilter.Items.AddRange(_findListNum);
break;
case TypeField.Numeric:
SetObject(true, GetValue());
cbListFilter.Items.AddRange(_findListNum);
break;
case TypeField.Date:
SetObject(false, GetValue());
cbListFilter.Items.AddRange(_findListNum);
break;
case TypeField.DateTime:
SetObject(false, GetValue());
cbListFilter.Items.AddRange(_findListNum);
break;
default:
SetObject(true, GetValue());
cbListFilter.Items.AddRange(_findListText);
break;
}
}
cbListFilter.Items.AddRange(_findList);
cbListFilter.Text = currentText;
if (cbListFilter.SelectedIndex == -1)
{
cbListFilter.SelectedIndex = 0;
}
}
public FindBox2(UcTableObjects.FieldInfoFull key, object value)
: this()
{
if (key == null)
{
return;
}
_currentFilter = key;
cbListFilter.Items.Clear();
cbListFilter.Items.AddRange(_findListNum);
cbListFilter.Items.AddRange(_findList);
cbListFilter.SelectedIndex = 0;
switch (key.TypeField)
{
case TypeField.Default:
txtValue.Text = value.ToString();
break;
case TypeField.Integer:
txtValue.Text = value.ToString();
break;
case TypeField.Text:
txtValue.Text = value.ToString();
break;
case TypeField.Date:
dateTimePicker1.Value = Convert.ToDateTime(value);
break;
case TypeField.DateTime:
dateTimePicker1.Value = Convert.ToDateTime(value);
break;
case TypeField.Numeric:
txtValue.Text = value.ToString();
break;
default:
txtValue.Text = value.ToString();
break;
}
}
public FindRequest2(UcTableObjects.FieldInfoFull coll, object findd, string type)
{
Col = coll;
FindValue = findd;
TypeFr = type;
}