editroom.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_Default2 : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["uid"] == "")
        {
            Response.Redirect("login.aspx");
        }

        if (!IsPostBack)
        {
            bc.ExecDropDownList(CX, "select * from type where type='CX' order by code", "name", "code");//朝向

            bc.ExecDropDownList(GG, "select * from type where type='GG' order by code", "name", "code");//规格
            bc.ExecDropDownList(GN, "select * from type where type='GN' order by code", "name", "code");//功能用途

            bc.ExecDropDownList(ZX, "select * from type where type='ZX' order by code", "name", "code");//装修标准
            this.bind();
        }
       

    }


    protected void bind()
    {

        string code = Request.QueryString["Code"].ToString();

        string sql = "select * from v_room where Code='" + code + "'";
        SqlDataReader sdr = bc.ExecRead(sql);
        if (sdr.Read())
        {
            Label1.Text = sdr["Code"].ToString();
            Label2.Text = sdr["ownerID"].ToString();
            Label3.Text = sdr["pavilion"].ToString();

            CX.SelectedItem.Text = sdr["sunny"].ToString();
            GG.SelectedItem.Text = sdr["indoor"].ToString();
            GN.SelectedItem.Text = sdr["roomUse"].ToString();
            ZX.SelectedItem.Text = sdr["roomFormat"].ToString();
            txtbuildarea.Text = sdr["buildarea"].ToString();
            txtusearea.Text = sdr["usearea"].ToString();
        }
       

    }












    protected void Button2_Click(object sender, EventArgs e)
    {
        string sunny = CX.SelectedItem.Value;//朝向
        string indoor = GG.SelectedItem.Value;//规格
        string roomuse = GN.SelectedItem.Value;//用途
        string roomformat = ZX.SelectedItem.Value;//标准

        string buildarea = txtbuildarea.Text.Trim();
        string usearea = txtusearea.Text.Trim();
       // Response.Write(buildarea + "   " + usearea);
       // Response.End();


        string strsql = "update  room set sunnyID='" + sunny + "',indoorID='" + indoor + "',roomUse='" + roomuse;
        strsql = strsql + "',roomFormat='" + roomformat + "',buildarea=" + buildarea + ",usearea=" + usearea;
        strsql = strsql + "where Code='" + Request.QueryString["Code"].ToString() + "'";
        //Response.Write(strsql);
        //Response.End();

        if (bc.ExecSql(strsql))
        {
            Response.Write("<script language=javascript>alert('修改房产信息成功！');location='room.aspx'</script>");
            return;
        }
        else
        {
            Response.Write("<script language=javascript>alert('修改房产信息失败，请重试！')</script>");
            return;
        }





    }
}