public IList <DBDTO> GetDBServer()
{
Recordset lObjRecordset = null;
DBDTO lObjDBDTO = null;
IList <DBDTO> lListObjResult = null;
try
{
lObjDBDTO = new DBDTO();
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
//(Recordset)((SAPbobsCOM.Company)Application.SBO_Application.Company.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset);
string lStrQuery = this.GetSQL("SetupDB");
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
lListObjResult = new List <DBDTO>();
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
lListObjResult.Add(GetItemDB(lObjRecordset));
lObjRecordset.MoveNext();
}
}
}
catch (Exception ex)
{
Application.SBO_Application.StatusBar.SetText(ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
//throw;
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lListObjResult);
}
private DBDTO GetItemDB(Recordset pObjRecordset)
{
DBDTO lObjDBDTO = new DBDTO();
lObjDBDTO.Code = pObjRecordset.Fields.Item("Code").Value.ToString();
lObjDBDTO.Name = pObjRecordset.Fields.Item("Name").Value.ToString();
lObjDBDTO.Code_UG_AA_LOGIN = pObjRecordset.Fields.Item("U_Code_UG_AA_LOGIN").Value.ToString();
lObjDBDTO.NameDB = pObjRecordset.Fields.Item("U_NameDB").Value.ToString();
lObjDBDTO.Descripcion = pObjRecordset.Fields.Item("U_Descripcion").Value.ToString();
lObjDBDTO.Status = pObjRecordset.Fields.Item("U_Status").Value.ToString();
return(lObjDBDTO);
}
public DBDTO GetSingle(int ID)
{
conn = new SQLiteConnection("Data Source=semanticdatabase.sqlite;Version=3;");
cmd = new SQLiteCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = $"SELECT Value, ID FROM Example WHERE ID={ID}";
reader = cmd.ExecuteReader();
var dto = new DBDTO();
while (reader.Read())
{
dto.Value = reader.GetString(0);
dto.ID = reader.GetInt32(1);
}
conn.Close();
return(dto);
}
