/// <summary>
/// Dado um idArquivo consulto os dados para geração do arquivo
/// </summary>
/// <param name="idArquivo"></param>
/// <returns></returns>
public static ACSOPRGCR_RRodapeEN ConsultaPorIdArquivo(int idArquivo)
{
using (SqlConnection cnx = new SqlConnection(upSight.Consulta.Base.BD.Conexao.StringConexaoBDGlobal))
{
ACSOPRGCR_RRodapeEN acsPrgCrgRdpEN = null;
try
{
string query = " SELECT IdArquivo, NumCrg, NumCart, ValorCrg, NumCrgRej, ValCgrRej, NumLinha " +
" FROM crpACSOPRGCR_RRodape " +
" WHERE IdArquivo = @IdArquivo ";
using (SqlCommand cmd = new SqlCommand(query, cnx))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("IdArquivo", SqlDbType.Int).Value = idArquivo;
cnx.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow))
{
while (dr.Read())
{
acsPrgCrgRdpEN = new ACSOPRGCR_RRodapeEN();
Mapeia(dr, acsPrgCrgRdpEN);
}
}
}
}
catch (SqlException sqlExc)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
{
Trace.TraceError("{0}: {1}", new object[] { "u.Integ.Servicos.CrtCorp, IdtnfRBD", sqlExc });
}
throw;
}
catch (Exception ex)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
{
Trace.TraceError("{0}: {1}", new object[] { "u.Integ.Servicos.CrtCorp, IdtnfR", ex });
}
throw;
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
}
return(acsPrgCrgRdpEN);
}
}
private static void Mapeia(SqlDataReader dr, ACSOPRGCR_RRodapeEN acsPrgCrgRdpEN)
{
if (dr.HasRows)
{
acsPrgCrgRdpEN.IdArquivo = (int)dr["IdArquivo"];
acsPrgCrgRdpEN.NumCrg = (int)dr["NumCrg"];
acsPrgCrgRdpEN.NumCart = (int)dr["NumCart"];
acsPrgCrgRdpEN.ValorCrg = (decimal)dr["ValorCrg"];
acsPrgCrgRdpEN.NumCrgRej = (int)dr["NumCrgRej"];
acsPrgCrgRdpEN.ValCgrRej = (decimal)dr["ValCgrRej"];
acsPrgCrgRdpEN.NumLinha = (int)dr["NumLinha"];
}
}
/// <summary>
/// Monta o rodapé
/// </summary>
/// <param name="idArquivo"></param>
/// <param name="numCrg"></param>
/// <param name="numCart"></param>
/// <param name="valorCrg"></param>
/// <param name="numCrgRej"></param>
/// <param name="valCrgRej"></param>
/// <param name="numLinha"></param>
/// <returns></returns>
private ACSOPRGCR_RRodapeEN MontaRodape(int idArquivo, int numCrg, int numCart, decimal valorCrg, int numCrgRej, decimal valCrgRej, int numLinha)
{
var acsPrgCrgRdpEN = new ACSOPRGCR_RRodapeEN()
{
IdArquivo = idArquivo,
NumCrg = numCrg,
NumCart = numCart,
ValorCrg = valorCrg,
NumCrgRej = numCrgRej,
ValCgrRej = valCrgRej,
NumLinha = numLinha
};
return(acsPrgCrgRdpEN);
}
/// <summary>
/// Dado um idArquivo consulto os dados para geração do arquivo
/// </summary>
/// <param name="idArquivo"></param>
/// <returns></returns>
public static ACSOPRGCR_RRodapeEN ConsultaPorIdArquivo(int idArquivo)
{
using (SqlConnection cnx = new SqlConnection(upSight.Consulta.Base.BD.Conexao.StringConexaoBDGlobal))
{
ACSOPRGCR_RRodapeEN acsPrgCrgRdpEN = null;
try
{
string query = " SELECT IdArquivo, NumCrg, NumCart, ValorCrg, NumCrgRej, ValCgrRej, NumLinha " +
" FROM crpACSOPRGCR_RRodape " +
" WHERE IdArquivo = @IdArquivo ";
using (SqlCommand cmd = new SqlCommand(query, cnx))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("IdArquivo", SqlDbType.Int).Value = idArquivo;
cnx.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow))
{
while (dr.Read())
{
acsPrgCrgRdpEN = new ACSOPRGCR_RRodapeEN();
Mapeia(dr, acsPrgCrgRdpEN);
}
}
}
}
catch (SqlException sqlExc)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
Trace.TraceError("{0}: {1}", new object[] { "u.Integ.Servicos.CrtCorp, IdtnfRBD", sqlExc });
throw;
}
catch (Exception ex)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
Trace.TraceError("{0}: {1}", new object[] { "u.Integ.Servicos.CrtCorp, IdtnfR", ex });
throw;
}
finally
{
if (cnx.State == ConnectionState.Open)
cnx.Close();
}
return acsPrgCrgRdpEN;
}
}
public static void Insere(this ACSOPRGCR_RRodapeEN acsPrgCrgRdpEN)
{
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["Global"].ConnectionString))
{
try
{
string query = " INSERT crpACSOPRGCR_RRodape " +
" (IdArquivo, TpRegistro, NumCrg, NumCart, ValorCrg, NumCrgRej, ValCgrRej, NumLinha) " +
" SELECT @IdArquivo, @TpRegistro, @NumCrg, @NumCart, @ValorCrg, @NumCrgRej, @ValCgrRej, @NumLinha ";
using (SqlCommand cmd = new SqlCommand(query, cnx))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("IdArquivo", SqlDbType.Int).Value = acsPrgCrgRdpEN.IdArquivo;
cmd.Parameters.Add("TpRegistro", SqlDbType.Char, 1).Value = ACSOPRGCR_RRodapeEN.TpRegistro;
cmd.Parameters.Add("NumCrg", SqlDbType.Int).Value = acsPrgCrgRdpEN.NumCrg;
cmd.Parameters.Add("NumCart", SqlDbType.Int).Value = acsPrgCrgRdpEN.NumCart;
cmd.Parameters.Add("ValorCrg", SqlDbType.Money).Value = acsPrgCrgRdpEN.ValorCrg;
cmd.Parameters.Add("NumCrgRej", SqlDbType.Int).Value = acsPrgCrgRdpEN.NumCrgRej;
cmd.Parameters.Add("ValCgrRej", SqlDbType.Money).Value = acsPrgCrgRdpEN.ValCgrRej;
cmd.Parameters.Add("NumLinha", SqlDbType.Int).Value = acsPrgCrgRdpEN.NumLinha;
cnx.Open();
cmd.ExecuteNonQuery();
}
}
catch (SqlException sqlExc)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
{
Trace.TraceError("{0}: {1}", new object[] { "u.CrtCorp.ACSOIDTSC_R.RdpBD", sqlExc });
}
throw;
}
catch (Exception ex)
{
if (upSight.Consulta.Base.BD.Geral.TS.TraceError)
{
Trace.TraceError("{0}: {1}", new object[] { "u.CrtCorp.ACSOIDTSC_R.Rdp", ex });
}
throw;
}
}
}
private static void Mapeia(SqlDataReader dr, ACSOPRGCR_RRodapeEN acsPrgCrgRdpEN)
{
if(dr.HasRows)
{
acsPrgCrgRdpEN.IdArquivo = (int)dr["IdArquivo"];
acsPrgCrgRdpEN.NumCrg = (int)dr["NumCrg"];
acsPrgCrgRdpEN.NumCart = (int)dr["NumCart"];
acsPrgCrgRdpEN.ValorCrg = (decimal)dr["ValorCrg"];
acsPrgCrgRdpEN.NumCrgRej = (int)dr["NumCrgRej"];
acsPrgCrgRdpEN.ValCgrRej = (decimal)dr["ValCgrRej"];
acsPrgCrgRdpEN.NumLinha = (int)dr["NumLinha"];
}
}
/// <summary>
/// Monta o rodapé
/// </summary>
/// <param name="idArquivo"></param>
/// <param name="numCrg"></param>
/// <param name="numCart"></param>
/// <param name="valorCrg"></param>
/// <param name="numCrgRej"></param>
/// <param name="valCrgRej"></param>
/// <param name="numLinha"></param>
/// <returns></returns>
private ACSOPRGCR_RRodapeEN MontaRodape(int idArquivo, int numCrg, int numCart, decimal valorCrg, int numCrgRej, decimal valCrgRej, int numLinha)
{
var acsPrgCrgRdpEN = new ACSOPRGCR_RRodapeEN()
{
IdArquivo = idArquivo,
NumCrg = numCrg,
NumCart = numCart,
ValorCrg = valorCrg,
NumCrgRej = numCrgRej,
ValCgrRej = valCrgRej,
NumLinha = numLinha
};
return acsPrgCrgRdpEN;
}
