private void OnBatchSearch(object sender, EventArgs e)
{
List <LeafItem> items = LoadDefaultQueryItems();
StartWatchIt("Search, " + _targetTbl);
{
//_search = new DtSearchProvider();
SearchFactory sf = new SearchFactory();
sf.GetSearchProvider(out _search);
_search.SetOption("connectionString", _connString);
_search.SetOption("IndexPath", _textBoxSearchIndexPath.Text);
_search.SetOption("MaxResultCount", _numericUpDownMaxResult.Value.ToString());
foreach (LeafItem qi in items)
{
_search.SetOption("skipLoadResult", "true");
_search.AddQueryItem(qi);
_search.RunSearch();
_search.SetOption("skipLoadResult", "false");
_search.AddQueryItem(qi);
_search.RunSearch();
}
}
StopWatchIt("Search, " + _targetTbl);
}
private void OnSearch(object sender, System.EventArgs e)
{
string resultTable = null;
StartWatchIt("Search, " + _targetTbl);
{
//try
{
SearchFactory sf = new SearchFactory();
if (_search == null)
{
sf.GetSearchProvider(out _search);
}
_search.SetOption("connectionString", _connString);
_search.SetOption("skipLoadResult", _checkBoxSkipLoad.Checked ? "true" : "false");
_search.SetOption("IndexPath", _textBoxSearchIndexPath.Text);
if (_numericUpDownMaxResult.Value > 0)
{
_search.SetOption("MaxResultCount", _numericUpDownMaxResult.Value.ToString());
}
ILeafItem qi = null;
sf.GetLeafItem(out qi);
qi.TableName = _textBoxSearchTableName.Text;
qi.Fieldname = _textBoxTargetField.Text;
qi.QueryValue = _comboBoxSearchValue.Text;
qi.CompareType = (CompareType)Enum.Parse(typeof(CompareType), _comboBoxCompareType.SelectedItem.ToString());
resultTable = _search.AddQueryItem(qi);
_search.RunSearch();
}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
StopWatchIt("Search, " + _targetTbl);
_textBoxOnFoundDoc.Text = _search.GetQueryResult(resultTable).HitCount.ToString();
_search.Reset();
}