adminblogedit.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 admin_adminBlogEdit : System.Web.UI.Page
{
    int userid, blogid,pagex=1;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToInt32(Session["user_level"].ToString()) != 3)
        {
            myfunc m1 = new myfunc("您不是前台管理员!");
            Response.Write(m1.JavaMsg("user_manage_blog.aspx"));
        }

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

        if (!IsPostBack) getBlog();
    }
    protected void btnSaveBlog_Click(object sender, EventArgs e)
    {
        int subjectid,text_folder=0;

        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();

            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,"");

            Label1.Text = newblog.update();

            int pagex=1;
            if(Request .QueryString ["pagex"]!=null)
                pagex=Convert .ToInt32 (Request .QueryString ["pagex"].ToString ());
            Response.Redirect("~/user/adminBlog.aspx?pagex="+pagex );

    }
    private void getBlog()
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        string sql = "select title,classid,subjectid,text from blog where blogid=" + blogid;
       

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

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

    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;
    }
}