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 SetFilterType(SQLiteSettings.FilterElementModel filter)
{
switch (filter.Type)
{
case Rekod.SQLiteSettings.TypeOperation.More:
cbListFilter.SelectedIndex = FindIndex(">");
break;
case Rekod.SQLiteSettings.TypeOperation.Less:
cbListFilter.SelectedIndex = FindIndex("<");
break;
case Rekod.SQLiteSettings.TypeOperation.Equal:
cbListFilter.SelectedIndex = FindIndex("=");
break;
case Rekod.SQLiteSettings.TypeOperation.NotEqual:
cbListFilter.SelectedIndex = FindIndex("<>");
break;
case Rekod.SQLiteSettings.TypeOperation.MoreOrEqual:
cbListFilter.SelectedIndex = FindIndex(">=");
break;
case Rekod.SQLiteSettings.TypeOperation.LessOrEqual:
cbListFilter.SelectedIndex = FindIndex("<=");
break;
case Rekod.SQLiteSettings.TypeOperation.Empty:
cbListFilter.SelectedIndex = FindIndex(Rekod.Properties.Resources.FindBox2_Empty);
break;
case Rekod.SQLiteSettings.TypeOperation.NotEmpty:
cbListFilter.SelectedIndex = FindIndex(Rekod.Properties.Resources.FindBox2_IsNotEmpty);
break;
case Rekod.SQLiteSettings.TypeOperation.Included:
cbListFilter.SelectedIndex = FindIndex(Rekod.Properties.Resources.FindBox2_Contains);
break;
case Rekod.SQLiteSettings.TypeOperation.IncludesFirst:
cbListFilter.SelectedIndex = FindIndex(Rekod.Properties.Resources.FindBox2_StartsWith);
break;
case Rekod.SQLiteSettings.TypeOperation.NotIncluded:
cbListFilter.SelectedIndex = FindIndex(Rekod.Properties.Resources.FindBox2_DoesNotContain);
break;
case Rekod.SQLiteSettings.TypeOperation.Init:
cbListFilter.SelectedIndex = -1;
break;
default:
break;
}
}
public SQLiteSettings.FilterElementModel GetFilterElementModel()
{
if (_currentFilter.TypeField != TypeField.Default)
{
SQLiteSettings.FilterElementModel temp = new SQLiteSettings.FilterElementModel(-1, _currentFilter.idField.ToString(),
GetTypeOperation(cbListFilter.Text), GetValue().ToString(), false);
return(temp);
}
else
{
SQLiteSettings.FilterElementModel temp = new SQLiteSettings.FilterElementModel(-1, _currentFilter.idField.ToString(),
GetTypeOperation(cbListFilter.Text), GetValue().ToString(), false);
return(temp);
}
}