editpavilion.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 addpavilion : 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)
            {
                bc.ExecDropDownList(ddl1, "select * from type where type='LY'", "Name", "code");
                this.bind();
              
            }
        
    }
    protected void bind()
    {
       
       
        

       

        string paID = Request.QueryString["paID"].ToString();
        string sqlstr = "select * from pavilion where paID='" + paID + "'";
        bc.openconn();
        SqlDataReader sda = bc.ExecRead(sqlstr);
        if (sda.Read())
        {   //绑定数据
            name.Text = sda["name"].ToString();
            layer.Text = sda["layer"].ToString();
            high.Text = sda["high"].ToString();
            area.Text = sda["area"].ToString();
            selectdate.Text = sda["buildDate"].ToString();
            ddl1.SelectedValue = sda["typeID"].ToString();
            
            memo.Text=sda["memo"].ToString();
            //sda.Close();//关闭读取




        }
       


    }
    protected void Button1_Click(object sender, EventArgs e)
    {
       
        string paID = Request["paID"].ToString();
        string sqlstr = "update pavilion set name='"+name.Text+"',layer='"+layer.Text+"',high='"+high.Text+"',area='"+area.Text+"',buildDate='"+selectdate.Text+"',typeID='"+ddl1.SelectedValue+"',memo='"+memo.Text+"' where paID='"+paID+"'";
        //Response.Write(sqlstr);
        //Response.End();

        if (bc.ExecSql(sqlstr))
        {
            Response.Write("<script language=javascript>alert('修改小区楼宇成功！');location='pavilion.aspx'</script>");
        }
        else
        {
            Response.Write("<script>alert('修改失败，请重试！');</script>");
        }
    }
}