public static ENResultOperation Obtener_Registro(Int32 Clie_Ide, Int32 Clie_Cont_Ide) { SqlCommand CMD = new SqlCommand("SELECT * FROM CLIENTE_CONTACTO WHERE Clie_Ide = " + Clie_Ide.ToString() + " AND Clie_Cont_Ide = " + Clie_Cont_Ide.ToString()); return(Cliente_ContactoDA.Procesar_SQL(CMD)); }
public static ENResultOperation Listar_Filtro(Int32 Clie_Ide) { SqlCommand CMD = new SqlCommand("SELECT * FROM CLIENTE_CONTACTO WHERE Clie_Ide = " + Clie_Ide.ToString()); return(Cliente_ContactoDA.Procesar_SQL(CMD)); /* * SqlCommand CMD = new SqlCommand("PA_CLIENTE_LISTAR_FILTRO_CONTACTO"); * CMD.Parameters.Add(Parametros_SQL.nombre_error, SqlDbType.VarChar).Value = Texto_Buscar; * CMD.Parameters.Add(Parametros_SQL.ide, SqlDbType.Int).Value = Clie_Ide; * * CMD.Parameters.Add("@RETURN", SqlDbType.Int); * CMD.Parameters["@RETURN"].Value = DBNull.Value; * CMD.Parameters["@RETURN"].Direction = ParameterDirection.ReturnValue; * * return Cliente_ContactoDA.Acceder(CMD); */ }