base.aspx.cs

小E单班同学录系统

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.OleDb;

public partial class Admin_Base : MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        WebFunction.AdminLogin();
        binddata();
    }
    void binddata()
    {
        if (!IsPostBack)
        {
            dbh.Reset();
            dbh.sqlCommand = "select top 1 * from ClassInfo";
            dbh.GetDataReader();
            if (dbh.dr.Read())
            {
                this.fckClassEnouce.Value = dbh.dr["ClassEnounce"].ToString();
                this.txtClassName.Text = dbh.dr["ClassName"].ToString();
                this.fckBirMail.Value = dbh.dr["MailBirthdayContext"].ToString();
                this.txtMailBirthdayTitle.Text = dbh.dr["MailBirthdayTitle"].ToString();
                this.fckMail.Value = dbh.dr["MailContext"].ToString();
                this.txtMailServer.Text = dbh.dr["MailServer"].ToString();
                this.txtMailTitle.Text = dbh.dr["MailTitle"].ToString();
                this.txtMailUserName.Text = dbh.dr["MailUserName"].ToString();
                this.txtMailUserPwd.Text = dbh.dr["MailUserPwd"].ToString();
                this.txtSiteName.Text = dbh.dr["SiteName"].ToString();
                this.txtClassYear.Text = dbh.dr["ClassYear"].ToString();
                this.ddlClassMode.SelectedValue = dbh.dr["ClassMode"].ToString();
                this.ddlSendMail.SelectedValue = dbh.dr["SendMail"].ToString();
                this.txtSiteUrl.Text = dbh.dr["SiteUrl"].ToString();
            }
        }
    }
    protected void btnSub_Click(object sender, EventArgs e)
    {
        dbh.Reset();
        dbh.tableName = "ClassInfo";
        dbh.AddFieldParameters("ClassEnounce", this.fckClassEnouce.Value);
        dbh.AddFieldParameters("ClassName", this.txtClassName.Text);
        dbh.AddFieldParameters("MailBirthdayContext", this.fckBirMail.Value);
        dbh.AddFieldParameters("MailBirthdayTitle", this.txtMailBirthdayTitle.Text);
        dbh.AddFieldParameters("MailContext", this.fckMail.Value);
        dbh.AddFieldParameters("MailServer", this.txtMailServer.Text);
        dbh.AddFieldParameters("MailTitle", this.txtMailTitle.Text);
        dbh.AddFieldParameters("MailUserName", this.txtMailUserName.Text);
        dbh.AddFieldParameters("MailUserPwd", this.txtMailUserPwd.Text);
        dbh.AddFieldParameters("SiteName", this.txtSiteName.Text);
        dbh.AddFieldParameters("ClassMode", this.ddlClassMode.SelectedValue.Replace("True", "1").Replace("False", "0"));
        dbh.AddFieldParameters("SendMail", this.ddlSendMail.SelectedValue.Replace("True", "1").Replace("False", "0"));
        dbh.AddFieldParameters("ClassYear", this.txtClassYear.Text);
        dbh.AddFieldParameters("SiteUrl", this.txtSiteUrl.Text);
        AlertHandleSucess(dbh.DataUpdate()>-1, this.ltlMessage, "修改");
    }
}