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