adminblogsettings.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_adminBlogSettings : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null)
            Response.Redirect("adminLogin.aspx");
        if (!IsPostBack)
            readSetting();

    }

    private void readSetting()
    {
        firstpage f1 = new firstpage();
        f1.getSetting();
        tbNewBlog.Text = f1.newBlogCount.ToString ();
        tbNewReply.Text = f1.newReplyCount.ToString ();
        tbHotBlog.Text = f1.hotBlogCount.ToString ();
        tbGoodBlogCount.Text = f1.goodBlogCount.ToString();
        tbMaxBlogUser.Text = f1.userByBlogCount.ToString ();
        tbActiveUser.Text = f1.userByActiveCount.ToString ();
        tbNewUser.Text = f1.newUserCount.ToString ();
        ddlCanReg.SelectedIndex = f1.canreg;
        ddlNeedCheck.SelectedIndex = f1.needcheck;
        tbFileExt.Text = f1.fileExt;
        tbPerFileSize.Text = f1.perFileSize.ToString ();
        tbTotalFileSize.Text = f1.totalFileSize.ToString ();
        tbBlogTitle.Text = f1.blogTitle.ToString();
        tbSubject.Text = f1.BlogSubjectCount.ToString();
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
        int newBlogCount, newReplyCount, hotBlogCount,BlogSubjectCount,goodblogCount;
        int userByBlogCount, userByActiveCount, newUserCount;

        newBlogCount = Convert.ToInt32(tbNewBlog.Text);
        newReplyCount = Convert.ToInt32(tbNewReply.Text);
        hotBlogCount = Convert.ToInt32(tbHotBlog.Text);
        userByBlogCount = Convert.ToInt32(tbMaxBlogUser.Text);
        userByActiveCount = Convert.ToInt32(tbActiveUser.Text);
        newUserCount = Convert.ToInt32(tbNewUser.Text);
        BlogSubjectCount = Convert.ToInt32(tbSubject.Text);
        goodblogCount = Convert.ToInt32(tbGoodBlogCount.Text);

        string sql = "update setting set newblog=" + newBlogCount;
        sql += ",newreply=" + newReplyCount;
        sql += ",hotblog=" + hotBlogCount;
        sql += ",userbyblog=" + userByBlogCount;
        sql += ",userbyactive=" + userByActiveCount;
        sql += ",newuser=" + newUserCount;
        sql += ",goodblog=" + goodblogCount;
        sql += ",blogsubjectcount=" + BlogSubjectCount;

        openDb db1 = new openDb(sql);
        string msg = db1.update();

        myfunc m1 = new myfunc(msg);
        Response.Write(m1.JavaMsg());

    }
    protected void btnok2_Click(object sender, EventArgs e)
    {
        string blogTitle;
        int CanReg, NeedCheck;
        CanReg = Convert.ToInt32(ddlCanReg.SelectedValue);
        NeedCheck = Convert.ToInt32(ddlNeedCheck.SelectedValue);
        blogTitle = Server.HtmlEncode(tbBlogTitle.Text);

        string sql  = "update setting set canreg=" + CanReg;
        sql += ",needcheck=" + NeedCheck;
        sql +=",blogTitle='"+blogTitle +"'";

        openDb db1 = new openDb(sql);
        string msg=db1.update();

        myfunc m1 = new myfunc(msg);
        Response.Write(m1.JavaMsg());
    }
    protected void btnFile_Click(object sender, EventArgs e)
    {
        int perFileSize = Convert.ToInt32(tbPerFileSize.Text);
        int totalFileSize = Convert.ToInt32(tbTotalFileSize.Text);
        string fileExt = Server.HtmlEncode(tbFileExt.Text);

        string sql = "update setting set perFileSize=" + perFileSize;
        sql += ",totalfilesize=" + totalFileSize;
        sql += ",fileExt='" + fileExt+"'";

        openDb db1 = new openDb(sql);
        string msg = db1.update();

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

    
}