addnotice.aspx.cs

基于asp.net的网上选课系统

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 addnotice : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //设置分页控件的数据源
        Pg1.datalist1 = DataList1;
        Pg1.CmdStr = "SELECT * FROM Notice";
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = e.Item.ItemIndex;
        Pg1.BindData();
    }

    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = -1;
        Pg1.BindData();
    }

    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string NoticeID;
        bool aff;
        AdminSQL admin = new AdminSQL();
        admin.Open();

        NoticeID = DataList1.DataKeys[e.Item.ItemIndex].ToString().Trim();
        aff = admin.DeleteNotice(NoticeID);
        if (aff)
        {
            Response.Write("<script>javascript:alert('删除通知成功！');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('删除通知失败！');</script>");
        }
        Pg1.recordchanged();
        admin.Close();
    }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        string NoticeID, NoticeTitle, NoticeContent,NoticeObject;
        DateTime NoticeDate;
        int aff;
        AdminSQL admin = new AdminSQL();
        admin.Open();
        if (e.CommandName == "insert")
        {
            NoticeID = ((TextBox)e.Item.FindControl("id")).Text.ToString();
            NoticeTitle = ((TextBox)e.Item.FindControl("title")).Text.ToString();
            NoticeContent = ((TextBox)e.Item.FindControl("content")).Text.ToString();
            NoticeDate =DateTime.Now;
            NoticeObject = ((TextBox)e.Item.FindControl("object")).Text.ToString();
            if (NoticeID != "" && NoticeTitle != "" && NoticeContent !="" && NoticeObject !="")
            {
                aff = admin.AddNotice(NoticeID, NoticeTitle,NoticeContent,NoticeDate,NoticeObject);
                if (aff>0)
                {

                    Response.Write("<script>javascript:alert('添加通知成功！');</script>");
                }
                else
                {
                    Response.Write("<script>javascript:alert('添加通知失败，ID号已存在或其它错误！');</script>");
                }
            }
            else
            {
                Response.Write("<script>javascript:alert('添加通知失败，请输入完整的通知信息！');</script>");
            }
            ((TextBox)e.Item.FindControl("id")).Text = "";
            ((TextBox)e.Item.FindControl("title")).Text = "";
            ((TextBox)e.Item.FindControl("content")).Text = "";
            ((TextBox)e.Item.FindControl("object")).Text = "";
        }
        Pg1.recordchanged();
        admin.Close();
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        string NoticeID, NoticeTitle, NoticeContent, NoticeObject;
        DateTime NoticeDate;
        bool aff;
        AdminSQL admin = new AdminSQL();
        admin.Open();

        NoticeID = ((Label)e.Item.FindControl("NoticeIDLabel")).Text.ToString();
        NoticeTitle = ((TextBox)e.Item.FindControl("txtNoticeTitle")).Text.ToString();
        NoticeContent = ((TextBox)e.Item.FindControl("txtNoticeContent")).Text.ToString();
        NoticeDate = DateTime.Now;
        NoticeObject = ((TextBox)e.Item.FindControl("txtNoticeObject")).Text.ToString();
        aff = admin.ModifyNotice(NoticeID, NoticeTitle, NoticeContent, NoticeDate, NoticeObject);
        if (aff)
        {
            Response.Write("<script>javascript:alert('修改通知成功！');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('修改通知失败！');</script>");
        }
        Pg1.recordchanged();
        admin.Close();
    }
    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            LinkButton btnDel = (LinkButton)e.Item.FindControl("btdelete");
            btnDel.Attributes.Add("onclick", "return confirm('确定要删除这条记录吗？')");

            e.Item.Attributes.Add("onmouseover", "this.style.backgroundColor='#cccc00'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='white'");
        }
    }
}