admin_config.aspx.cs

一个开源企业网站

using System;
using System.Data;
using System.Data.OleDb;
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;

public partial class Admin_Admin_Config : System.Web.UI.Page
{
    OleDbConnection MyConn;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserID"] == "" || Session["UserID"] == null)
        {
            Response.Write("<script language=javascript>window.alert('为了系统安全，请您重新登陆');window.location.href=('Admin_Login.aspx')</script>");
        }
        if (!IsPostBack)
        {
            this.DataToBind();
        }
    }
    public void DataToBind()
    {
        MyConn = DB.CreateDB();
        MyConn.Open();
        OleDbCommand cmd = new OleDbCommand("select * from title", MyConn);
        OleDbDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            this.TxtTitle.Text = dr["title"].ToString();
            this.TxtGj.Text = dr["Keywords"].ToString();
            this.TxtDes.Text = dr["Description"].ToString();
        }
        dr.Close();
        MyConn.Close();
    }
    protected void BtnSubmit_Click(object sender, EventArgs e)
    {
        MyConn = DB.CreateDB();
        MyConn.Open();
        string title=FunStr(this.TxtTitle.Text);
        string keywords =FunStr(this.TxtGj.Text);
        string description =FunStr(this.TxtDes.Text);
        OleDbCommand cmd1 = new OleDbCommand("update title set Title='" + title + "',Keywords='" + keywords + "',Description='" + description + "'", MyConn);
        cmd1.ExecuteNonQuery();
        MyConn.Close();
    }
    public static string FunStr(string str)
    {
        str = str.Replace("'", "‘");
        str = str.Replace("   ", "&nbsp;");

        str = str.Trim();
        if (str.Trim().ToString() == "")
            str = "无";
        return str;
    } 
    
}