public List <C_Extra> listarMotivos() { List <C_Extra> list = new List <C_Extra>(); if (con == null) { con = new conexion(); } con.conectar(); SqlCommand cmd = new SqlCommand("_sp_listarMotivoExtra", con.cnxn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { C_Extra nodo = new C_Extra(); nodo.observacion = dr.GetString(1).Trim(new char[] { ' ' }); list.Add(nodo); } } con.desconectar(); return(list); }
public C_Extra BuscarSumExtra() { if (con == null) { con = new conexion(); } con.conectar(); C_Extra ext = null; SqlCommand cmd = new SqlCommand("_sp_BuscarSumExtra", con.cnxn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idh", idHabitacion); cmd.Parameters.AddWithValue("@fecha", fecha); cmd.Parameters.AddWithValue("@ids", idSuministro); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ext = new C_Extra(); ext.idSuministro = dr.GetInt32(0); ext.idHabitacion = dr.GetInt32(3); ext.cantidad = dr.GetInt32(4); ext.fecha = dr.GetDateTime(5); ext.descripcion = dr.GetString(2).Trim(new char[] { ' ' }); ext.observacion = dr.GetString(8).Trim(new char[] { ' ' }); } } con.desconectar(); return(ext); }