private void LoadComboQueryRecordset(string _query, dynamic oComboBox, string fieldValue, string fieldDesc, SAPbobsCOM.Company oCompany) { //oApp = (SAPbouiCOM.Application)Application.SBO_Application; //oCompany = (SAPbobsCOM.Company)oApp.Company.GetDICompany(); SAPbobsCOM.Recordset businessObject = (SAPbobsCOM.Recordset)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); businessObject.DoQuery(_query); SAPbouiCOM.ValidValues validValues = oComboBox.ValidValues; CleanComboBox(oComboBox); if (!string.Equals(fieldDesc, string.Empty)) { while (!businessObject.EoF) { validValues.Add((dynamic)businessObject.Fields.Item(fieldValue).Value, (dynamic)businessObject.Fields.Item(fieldDesc).Value); businessObject.MoveNext(); } } else { while (!businessObject.EoF) { validValues.Add((dynamic)businessObject.Fields.Item(fieldValue).Value, ""); businessObject.MoveNext(); } } }
public static void LoadComboQuery(string _query, ref SAPbouiCOM.ComboBox oComboBox, string fieldValue, string fieldDesc, SAPbobsCOM.Company oCompany) { SAPbobsCOM.Recordset businessObject = (SAPbobsCOM.Recordset)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); businessObject.DoQuery(_query); SAPbouiCOM.ValidValues validValues = oComboBox.ValidValues; while (oComboBox.ValidValues.Count > 0) { oComboBox.ValidValues.Remove(0, SAPbouiCOM.BoSearchKey.psk_Index); } if (!string.Equals(fieldDesc, string.Empty)) { while (!businessObject.EoF) { validValues.Add((dynamic)businessObject.Fields.Item(fieldValue).Value, (dynamic)businessObject.Fields.Item(fieldDesc).Value); businessObject.MoveNext(); } } else { while (!businessObject.EoF) { validValues.Add((dynamic)businessObject.Fields.Item(fieldValue).Value, ""); businessObject.MoveNext(); } } }