- Code: Select all
public void Search(System.Windows.Forms.Form OwnerForm)
{
var search = this.Manager.Search;
search.Clear();
search.Caption = "Salesman Groups";
var searchOption = new JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.SearchOption();
searchOption.Title = "Salesman Groups";
searchOption.SQLStr = @" SELECT SalesmanGroupID as ID
,Description
FROM HR_SalesmanGroups where Description <> '' ";
searchOption.OrderBy = @" order by Description ";
searchOption.AddColumn("ID", Microsoft.VisualBasic.VariantType.String, "", 0, 1);
searchOption.AddColumn("Description", Microsoft.VisualBasic.VariantType.String, "", 100, 2);
// search.Options.Clear();
search.AddSearchOption(ref searchOption);
if (search.Show(OwnerForm) == DialogResult.OK)
{
if (search.Results.Count > 0)
{
var idField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(1);
Read(idField.FieldValue.ToString());
}
}
else
{
throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();
}
}