- Code: Select all
public void Search(System.Windows.Forms.Form OwnerForm)
{
var search = this.Manager.Search;
search.Clear();
search.Caption = "Salesman Rates";
var searchOption = new JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.SearchOption();
searchOption.Title = "Salesman Rates";
searchOption.SQLStr = @" SELECT StaffID
,FName
,SName
,DisplayName
FROM Attk_HR_SalesmanCommissionRatesHeader ";
searchOption.OrderBy = @"ORDER BY DisplayName ";
searchOption.AddColumn("StaffID", Microsoft.VisualBasic.VariantType.String, "", 0, 1);
searchOption.AddColumn("First Name", Microsoft.VisualBasic.VariantType.String, "", 25, 2);
searchOption.AddColumn("Surname", Microsoft.VisualBasic.VariantType.String, "", 25, 3);
searchOption.AddColumn("Display Name", Microsoft.VisualBasic.VariantType.String, "", 25, 4);
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();
}
}
But the following does not even though its legal SQL syntax
- Code: Select all
public void Search(System.Windows.Forms.Form OwnerForm)
{
var search = this.Manager.Search;
search.Clear();
search.Caption = "Salesman Rates";
var searchOption = new JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.SearchOption();
searchOption.Title = "Salesman Rates";
searchOption.SQLStr = @" SELECT [StaffID]
,[FName]
,[SName]
,[DisplayName]
FROM [Attk_HR_SalesmanCommissionRatesHeader] ";
searchOption.OrderBy = @"ORDER BY DisplayName ";
searchOption.AddColumn("StaffID", Microsoft.VisualBasic.VariantType.String, "", 0, 1);
searchOption.AddColumn("First Name", Microsoft.VisualBasic.VariantType.String, "", 25, 2);
searchOption.AddColumn("Surname", Microsoft.VisualBasic.VariantType.String, "", 25, 3);
searchOption.AddColumn("Display Name", Microsoft.VisualBasic.VariantType.String, "", 25, 4);
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();
}
}