public static object SQL_ConsulaAcciones(string SQLComando)
{
var model = new List <Tipo_Acciones>();
using (var connection = new SqlConnection(DB_SGDE))
{
var command = new SqlCommand(SQLComando, connection);
command.Connection.Open();
var consulta = command.ExecuteReader();
if (consulta.HasRows)
{
while (consulta.Read())
{
var Doc = new Tipo_Acciones {
Id = Convert.ToInt32(consulta["Id"]),
IdReg = consulta["IdReg"].ToString(),
NumDoc = consulta["NumDoc"].ToString(),
Xfec = DateTime.Parse(consulta["xfec"].ToString()),
Xusr = consulta["xusr"].ToString(),
NumEdicion = Convert.ToInt32(consulta["NumEdicion"]),
Obs = consulta["Obs"].ToString()
};
model.Add(Doc);
}
}
command.Connection.Close();
connection.Close();
}
return(model);
}
public IActionResult DOCLog(Tipo_Acciones model)
{
ViewBag.NumDoc = model.NumDoc;
ViewBag.IdReg = model.IdReg;
return(View());
}
