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

public partial class Admin_Message : MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        WebFunction.AdminLogin();
        if (!IsPostBack)
        {
            dbh.Reset();
            dbh.sqlCommand = "select Count(ID) from Message";
            dbh.GetDataReader();
            int count = 0;
            if (dbh.dr.Read())
            {
                count = (int)dbh.dr[0];
            }
            this.ltlCount.Text = count.ToString();
        }
    }
    protected void btnDelUser_Click(object sender, EventArgs e)
    {
        dbh.Reset();
        dbh.tableName = "Message";
        dbh.conditionExpress = "Receiver=@Receiver";
        dbh.AddConditionParameters("Receiver", this.txtUserName.Text);
        AlertHandleSucess(dbh.DataDelete() > -1, this.ltlMessage, "删除", "请查看系统出错日志");
    }
    protected void btnDelCon_Click(object sender, EventArgs e)
    {
        dbh.Reset();
        dbh.tableName = "Message";
        dbh.conditionExpress = " Contents like '%" + this.txtContent.Text + "%'";
        AlertHandleSucess(dbh.DataDelete() > -1, this.ltlMessage, "删除", "请查看系统出错日志");
    }
    protected void btnDay_Click(object sender, EventArgs e)
    {
        dbh.Reset();
        dbh.tableName = "Message";
        dbh.conditionExpress = "SendTime<@SendTime";
        dbh.AddConditionParameters("SendTime", DateTime.Today.AddDays(-Convert.ToInt16(this.ddlDay.SelectedValue)).ToString("yyyy-MM-dd"));
        AlertHandleSucess(dbh.DataDelete() > -1, this.ltlMessage, "删除", "请查看系统出错日志");
    }
}