Hi There
We have a requirement to create a custom lookup window similar to the attached one, can you pls provide an example
var search = BusinessLogicHost.Manager.Search;
search.Clear();
search.Caption = "Document Type";
var searchOption = new JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.SearchOption();
searchOption.Title = "Document Type";
searchOption.SQLStr = @"SELECT SY_DocumentTypes.RecID, SY_DocumentTypes.DocumentDescription
FROM SY_DocumentTypes";
if (SystemSetting.IDKey != "InvCatFID" )
{
searchOption.SQLStr += " where DocumentType = 'JiwaFinancials.Jiwa.JiwaDebtors.Debtor'";
}
else
{
searchOption.SQLStr += " where DocumentType = 'JiwaFinancials.Jiwa.JiwaInventory.Inventory'";
}
searchOption.OrderBy = @"ORDER BY SY_DocumentTypes.DocumentDescription";
searchOption.AddColumn("RecID", Microsoft.VisualBasic.VariantType.String, "", 0, 1);
searchOption.AddColumn("Document Description", Microsoft.VisualBasic.VariantType.String, "", 100, 2);
search.AddSearchOption(ref searchOption);
if (search.Show(null) == DialogResult.OK)
{
if (search.Results.Count > 0)
{
var idField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(1);
SystemSetting.Contents = idField.FieldValue.ToString();
var DescriptionField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(2);
//var PrinterNameField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(3);
SystemSetting.DisplayContents = DescriptionField.FieldValue.ToString();
}
}
else
{
throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();
}
Return to Technical and or Programming
Users browsing this forum: No registered users and 16 guests