public override RequisicaoInfo getRequisicaoInfo(long idNivel, IDbConnection conn)
{
RequisicaoInfo result = null;
SqlDataReader reader;
using (SqlCommand command = new SqlCommand("", (SqlConnection)conn))
{
command.Parameters.AddWithValue("@idNivel", idNivel);
command.Parameters.AddWithValue("@isDeleted", 0);
command.Parameters.AddWithValue("@reqCatCode", "REQ");
command.CommandText = string.Format(@"
SELECT TOP 1 n.ID IDNivel, dm.IDMovimento, me.Entidade, req.Data, req.Notas
FROM Nivel n
INNER JOIN DocumentosMovimentados dm ON dm.IDNivel = n.ID AND dm.isDeleted = @isDeleted
INNER JOIN Movimento req ON req.ID = dm.IDMovimento and req.CatCode = @reqCatCode AND req.isDeleted = @isDeleted
INNER JOIN MovimentoEntidade me ON me.ID = req.IDEntidade AND me.isDeleted = @isDeleted
WHERE n.ID = @idNivel AND n.isDeleted = @isDeleted
ORDER BY req.Data DESC", idNivel);
try
{
reader = command.ExecuteReader();
if (reader.Read())
{
result = new RequisicaoInfo();
result.idNivel = reader.GetInt64(0);
result.idMovimento = reader.GetInt64(1);
result.entidade = reader.GetString(2);
result.data = reader.GetDateTime(3);
result.notas = reader.GetValue(4).ToString();
}
reader.Close();
}
catch (Exception e)
{
throw e;
}
}
return(result);
}
public override RequisicaoInfo getRequisicaoInfo(long idNivel, IDbConnection conn)
{
RequisicaoInfo result = null;
SqlDataReader reader;
using (SqlCommand command = new SqlCommand("", (SqlConnection)conn))
{
command.Parameters.AddWithValue("@idNivel", idNivel);
command.Parameters.AddWithValue("@isDeleted", 0);
command.Parameters.AddWithValue("@reqCatCode", "REQ");
command.CommandText = string.Format(@"
SELECT TOP 1 n.ID IDNivel, dm.IDMovimento, me.Entidade, req.Data, req.Notas
FROM Nivel n
INNER JOIN DocumentosMovimentados dm ON dm.IDNivel = n.ID AND dm.isDeleted = @isDeleted
INNER JOIN Movimento req ON req.ID = dm.IDMovimento and req.CatCode = @reqCatCode AND req.isDeleted = @isDeleted
INNER JOIN MovimentoEntidade me ON me.ID = req.IDEntidade AND me.isDeleted = @isDeleted
WHERE n.ID = @idNivel AND n.isDeleted = @isDeleted
ORDER BY req.Data DESC", idNivel);
try
{
reader = command.ExecuteReader();
if (reader.Read())
{
result = new RequisicaoInfo();
result.idNivel = reader.GetInt64(0);
result.idMovimento = reader.GetInt64(1);
result.entidade = reader.GetString(2);
result.data = reader.GetDateTime(3);
result.notas = reader.GetValue(4).ToString();
}
reader.Close();
}
catch (Exception e)
{
throw e;
}
}
return result;
}
