public string GetWareHouse(string pStrUserID) { SAPbobsCOM.Recordset lObjRecordset = null; string lStrWareHouse = ""; try { TicketDAO mObjTicketDAO = new TicketDAO(); Dictionary <string, string> lLstStrParameters = new Dictionary <string, string>(); lLstStrParameters.Add("UserID", pStrUserID); string lStrQuery = this.GetSQL("GetWarehouse").Inject(lLstStrParameters); //this.UIAPIRawForm.DataSources.DataTables.Item("RESULT").ExecuteQuery(lStrQuery); lObjRecordset = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { lStrWareHouse = lObjRecordset.Fields.Item(0).Value.ToString(); } } catch (Exception ex) { LogService.WriteError(string.Format("[GetWareHouse]: {0} ", ex.Message)); LogService.WriteError(ex); UIApplication.ShowError(string.Format("[GetWareHouse]: {0}", ex.Message)); // UIApplication.ShowMessageBox(string.Format("InitDataSourcesException: {0}", ex.Message)); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lStrWareHouse); }
public IList <string> GetProjects() { SAPbobsCOM.Recordset lObjRecordset = null; IList <string> lLstProjects = new List <string>(); try { TicketDAO mObjTicketDAO = new TicketDAO(); string lStrQuery = this.GetSQL("GetProjects"); //this.UIAPIRawForm.DataSources.DataTables.Item("RESULT").ExecuteQuery(lStrQuery); lObjRecordset = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { lLstProjects.Add(lObjRecordset.Fields.Item("PrjCode").Value.ToString()); lObjRecordset.MoveNext(); } } } catch (Exception ex) { LogService.WriteError(string.Format("[GetProjects]: {0} ", ex.Message)); LogService.WriteError(ex); UIApplication.ShowError(string.Format("[GetProjects]: {0}", ex.Message)); // UIApplication.ShowMessageBox(string.Format("InitDataSourcesException: {0}", ex.Message)); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lLstProjects); }