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;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null)
                Response.Redirect("adminLogin.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();
            Response.Redirect("~/admin/adminBlog.aspx");


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