Controller.ControllerOrdemServico.Carregar C# (CSharp) Method

        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;
        }