editnotice.aspx.cs

物业管理系统

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;


public partial class admin_notice : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["UID"]) == "")
        {
            Response.Redirect("login.aspx");

        }

        if (!IsPostBack)
        {
            
           
            this.bind();
           
        }       

        
        
    }

    protected void bind()
    {
        string noticeID = Request.QueryString["ID"].ToString();
        //Response.Write(noticeID);
        //Response.End();
      
        string sqlstr = "select * from notice where ID='" + noticeID + "'";
        
             SqlDataReader sdr = bc.ExecRead(sqlstr);
             if (sdr.Read())
             {
                 ID.Text = sdr["ID"].ToString();//公告编号
                 ID.ReadOnly=true;//报修编著号不允许修修改
                 title.Text = sdr["title"].ToString();//公告标题
                 selectdate.Text = sdr["noticeDate"].ToString();//公告日期
                 FreeTextBox1.Text = sdr["notiContent"].ToString();//公告内容
                 addname.Text = sdr["noticePerson"].ToString();//i添加人
                 addname.ReadOnly = true;//只读(添加人不允许修改

             }
             else
             {
                 Response.Write("<script language=javascript>alert('获取数据失败，请重试！');</script>");
                 return;
             }
      
        
      

    }  

   



    protected void Button1_Click(object sender, EventArgs e)
    {
        
        string noticeID = Request.QueryString["ID"].ToString();
        string noticetitle = title.Text;//公告标题
        string date = selectdate.Text;//发布日期
        string content =FreeTextBox1.Text;//内容

        string sql = "update notice set title='" + noticetitle + "',noticeDate='" +date + "',notiContent='" + content + "' where ID='" + noticeID + "'";
     //   Response.Write(sql);
       // Response.End();


        if (bc.ExecSql(sql))
        {

            Response.Write("<script language=javascript>alert('修改物业公告成功！');location='notice.aspx'</script>");
        }
        else
        {
            Response.Write("<script>alert('修改物业公告失败，请重试！');</script>");
        }

    } 
    
}