daily pastebin goal
63%
SHARE
TWEET

Untitled

gkpoll Feb 19th, 2019 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. using System;
  2. using System.Collections.Generic;
  3. using Sat.Dtec.Dto;
  4. using Sat.Dtec.Mdl;
  5. using Sat.Framework.Data;
  6. using Sat.Framework.Storage;
  7. using Sat.Framework.Types;
  8.  
  9. namespace Sat.Dtec.Svc
  10. {
  11.     public class SvcComAutomaticas
  12.     {
  13.         public static List<DtoJobsOmissosBlocoX> BuscarOmissosBlocoX()
  14.         {
  15.             DateTime? dataParaTestes = null;
  16.             //DateTime dataParaTestes = DateTime.Now;
  17.  
  18.             var p = new DbProcedureSettings
  19.             {
  20.                 ObjectName = "usr_sat_dtec.PKG_DTEC_COM_AUTOMATICAS.CEI_ConsultaDestBlocoX"
  21.             };
  22.  
  23.             p.Parameters.AddInput("p_dataOpcional", dataParaTestes, DbDataType.Date);
  24.             p.Parameters.AddOutput("p_cursor", typeof(MdlJobsOmissosBlocoX));
  25.  
  26.             DbManager.InvokeStoredProcedure(p);
  27.  
  28.             List<MdlJobsOmissosBlocoX> destinatariosRetornados = p.Parameters.GetValue<List<MdlJobsOmissosBlocoX>>("p_cursor");
  29.  
  30.             List<DtoJobsOmissosBlocoX> listaResultado = new List<DtoJobsOmissosBlocoX>();
  31.  
  32.             foreach(MdlJobsOmissosBlocoX dest in destinatariosRetornados)
  33.             {
  34.                 DtoJobsOmissosBlocoX omisso = new DtoJobsOmissosBlocoX();
  35.                 omisso.IE = dest.IE;
  36.                 omisso.nomeContribuinte = dest.NomeContribuinte;
  37.                 listaResultado.Add(omisso);
  38.             }
  39.  
  40.             return listaResultado;
  41.         }
  42.     }
  43. } // fim namespace
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top