取分类路径

        #region 取得当前ClassId所在树的路径
        public string GetClassPath(int id)
        {
            string ReturnText = "";
            DataSet rs = dal.GetClassPath(id);
            if (rs.Tables.Count > 0)
            {
                foreach (DataRow dr in rs.Tables[0].Rows)
                {
                    ReturnText += " > <a href=\"P_" + dr["id"].ToString() + "_0.html\">" + dr["title"].ToString() + "</a>";
                }
            }
            return ReturnText;
        }
        #endregion
      

  #region 取得当前ClassId所在树的路径
        public DataSet GetClassPath(int id)
        {
            string sql = "select id,title from tb_class_product where charindex('|'+parentid+'|',(select '|'+parentid+'|' from tb_class_product where id=@id))>0 order by id";
            SqlParameter[] para = { DbHelperSQL.MakeInParam("@id", SqlDbType.Int, 4, id) };
            return DbHelperSQL.Query(sql, para);
        }
        #endregion