public static OrdemServico Carregar(int ID)
{
System.Data.DataTable tabela = new DataTable("OrdemDeServico");
OrdemServico OSBase = new OrdemServico();
Spartacus.Database.Generic database;
Spartacus.Database.Command cmd = new Spartacus.Database.Command();
cmd.v_text = "Select * from OrdemDeServico Where ID = #id#";
cmd.AddParameter("id", Spartacus.Database.Type.INTEGER);
cmd.SetValue("id", ID.ToString());
try
{
database = new Spartacus.Database.Sqlite(DB.GetStrConection());
tabela = database.Query(cmd.GetUpdatedText(), "OrdemDeServico");
OSBase = PreencherOS(tabela);
}
catch (Spartacus.Database.Exception ex)
{
ControllerArquivoLog.GeraraLog(ex);
}
return OSBase;
}