editbaseinfo.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_editbaseinfo : System.Web.UI.Page
{

    BaseClass bc = new BaseClass();//定义公共类的实例,参见App_Code/baseClass.cs
    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 strsql = "select * from baseInfo";
        SqlDataReader mydr = bc.ExecRead(strsql);
        if (mydr.Read())
        {


            //Response.Write(mydr["ownerID"].ToString());
            //Response.End();


            TextBox1.Text =mydr["homeName"].ToString();
            TextBox2.Text = mydr["mainHead"].ToString();
            
            selectdate.Text = mydr["buildDate"].ToString();

            TextBox4.Text = mydr["buildArea"].ToString();
            TextBox5.Text = mydr["amount"].ToString();
            TextBox6.Text = mydr["address"].ToString();
            TextBox7.Text = mydr["greenArea"].ToString();
            TextBox8.Text = mydr["roadArea"].ToString();
            TextBox9.Text = mydr["tel"].ToString();
            TextBox10.Text = mydr["parkingArea"].ToString();
            txtmemo.Text = mydr["memo"].ToString();

           
        }

        else
        {
            Response.Write("<script>alert('数据加载失败！请重试');</script>");
            return;
        }



        bc.Closeconn();//关闭数据库的连接






    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        

        string sqlstr = "update baseInfo set homeName='" + TextBox1.Text + "',mainHead='" + TextBox2.Text + "',buildDate='" +selectdate.Text + "',";
        sqlstr=sqlstr+"buildArea='"+TextBox4.Text+"',amount='"+TextBox5.Text+"',address='"+TextBox6.Text+"',greenArea='"+TextBox7.Text+"',";
        sqlstr=sqlstr+"roadArea='"+TextBox8.Text+"',tel='"+TextBox9.Text+"',parkingArea='"+TextBox10.Text+"',memo='"+txtmemo.Text+"'";
        //Response.Write(sqlstr);
        //Response.End();

        if (bc.ExecSql(sqlstr))
        {
          
            Response.Write("<script language=javascript>alert('小区信息修改成功！');location='baseinfo.aspx'</script>");

        }
        else
        {
            Response.Write("<script>alert('修改失败，请重试！');</script>");
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("default.aspx");
    }
}