////---------------------给标记数组赋值------------  

            format[0] = title;

            format[1] = datetime;

            format[2] = desc;

            format[3] = content;

            format[4] = nowPosition;

            ////----------替换htm里的标记为你想加的内容

            for (int i = 0; i < 5; i++)

            {

                htmltext.Replace("$htmlformat[" + i + "]", format[i]);

            }

            //----------生成htm文件------------------――   

            try

            {

                using (StreamWriter sw = new StreamWriter(Server.MapPath("html/article" + article_id + ".html"), false, System.Text.Encoding.GetEncoding("GB2312")))

                {

                    sw.WriteLine(htmltext);

                    sw.Flush();

                    sw.Close();

                }

            }

            catch

            {

                Response.Write("The file could not be wirte:");

            }

        }

    }

    #region 得到现在的位置(无限级栏目)

    public string GetPosition(string articlesgroup_id, string positionlist)

    {

        string articlesgroup_parent_id = "";

        string groupname = "";

 

        string NowPosition = "";

        if (articlesgroup_id == "")

            articlesgroup_id = "0";

        string sql = "select articlesgroup_parent_id, groupname from articlesgroup where articlesgroup_id = " + articlesgroup_id + "";

        SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=city;database=test;");

        SqlCommand cmd = new SqlCommand(sql, conn);

        cmd.CommandType = CommandType.Text;

        try

        {

            conn.Open();

            SqlDataReader sdr;

            sdr = cmd.ExecuteReader();

            if (!sdr.Read())

            {

                NowPosition = "Current Location:<a href=categorylist.aspx>Base</a>";

            }

            else

            {

                articlesgroup_parent_id = sdr["articlesgroup_parent_id"].ToString();

                groupname = sdr["groupname"].ToString();

                if (groupname != "")

                    NowPosition = GetPosition(articlesgroup_parent_id, groupname);

            }

            sdr.Close();

            conn.Close();

            if (articlesgroup_id != "0")

                NowPosition = NowPosition + " -> <a href=categorylist.aspx?viewcatagorie_id=" + articlesgroup_id + ">" + groupname + "</a>";

        }

        catch { }

        return NowPosition;

    }

    #endregion

posted on 2007-06-03 19:56  E商.NET  阅读(314)  评论(0编辑  收藏  举报