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