user_blog_edit.aspx.cs

本程序基于 asp.net 2.0 +sql server 2

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using lalablog;
public partial class user_user_blog_edit : System.Web.UI.Page
{
    int userid,blogid;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["userid"] == null)
            Response.Redirect("~/user/userLogin.aspx?url="+Server .HtmlEncode(Request .RawUrl ));
        else userid = Convert.ToInt32(Session["userid"]);

        blogid = Convert.ToInt32(Request.QueryString["blogid"]);

        if (!IsPostBack)           getBlog();
    }

    /*保存修改后的blog*/
    protected void btnSaveBlog_Click(object sender, EventArgs e)
    {
        saveBlog(0);
    }

    //保存为私人日志
    protected void btnSavePrivate_Click(object sender, EventArgs e)
    {
        saveBlog(2);
    }

//保存为草稿
    protected void btnSaveDraft_Click(object sender, EventArgs e)
    {
        saveBlog(1);
    }


    private void  saveBlog(int text_folder)
    {
        int subjectid;
        decode blogtitle = new decode(tb_title.Text.ToString());
        string title = Server.HtmlEncode(blogtitle.outstr());

        decode blogtext = new decode(hf_editor.Value);
        string text = blogtext.outstr();

        decode blogpuretext = new decode(hf_text.Value);
        string puretext = blogpuretext.outstr();

        string blogpassword;
        //因为读入的时候 把密码显示那里设置成了lalablogencrypt ，如果更改，则说明密码变更了。
        if (tbBlogPassWord.Text != ""&&tbBlogPassWord .Text !="lalablogencrypt")
            blogpassword = FormsAuthentication.HashPasswordForStoringInConfigFile(tbBlogPassWord.Text, "sha1");
        else 
            blogpassword = ViewState ["blogpassword"].ToString ();
        //表示保留原来的密码

        //选中则表示要删除密码
        if (chkPassword.Checked)
            blogpassword = "delete";
        
            DateTime add_date = System.DateTime.Now;
            string add_ip = Request.UserHostAddress;
            int classid = Convert.ToInt32(ddl_class.SelectedValue);
            if (ddl_subject.SelectedValue != null)
                subjectid = Convert.ToInt32(ddl_subject.SelectedValue);
            else subjectid = 0;

            myblog newblog = new myblog(userid, blogid, title, text, 
                puretext, add_date, add_ip, classid, subjectid, 
                text_folder,blogpassword );

            string msg = newblog.update();

            myfunc m1 = new myfunc(msg);
            Response.Write(m1.JavaMsg("user_manage_blog.aspx"));
    }

    /*加载要修改的blog*/
    private void getBlog()
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        string sql = "select title,classid,subjectid,text,blogpassword from blog where blogid=" + blogid;
        sql += " and userid=" + this.userid;

        cn.Open();
        SqlCommand cm = new SqlCommand(sql, cn);
        SqlDataReader dr = cm.ExecuteReader();

        if (dr.Read())
        {
            if (dr["blogpassword"].ToString() != "")
            {
                tbBlogPassWord.Text = "lalablogencrypt";
                chkPassword.Visible = true;
            }
            ViewState["blogpassword"] = dr["blogpassword"].ToString();

            editor.InnerHtml = dr["text"].ToString();
            tb_title.Text = dr["title"].ToString();
            changeIndex (ddl_class ,Convert .ToInt32(dr["classid"].ToString ()));
            changeIndex(ddl_subject, Convert.ToInt32(dr["subjectid"].ToString ()));
        }
        cn.Close();
    }

    //把用户的classid和subjectid反映到 下拉框中去
    private void changeIndex(DropDownList ddl, int x)
    {
        ddl.DataBind();
        bool ok=true;
        int i = 0;
        for (; i < ddl.Items.Count && ok ; i++)
        {
            ddl.SelectedIndex = i;
            if (Convert .ToInt32(ddl.SelectedValue) == x) ok = false;
        }
        ddl.SelectedIndex = i-1;
    }

}