homeholdinfo.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
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["UID"]) == "")
        {
            Response.Redirect("login.aspx");

        }

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

    }
    protected void bind()
    {
        BaseClass bc = new BaseClass();
      //下拉列表枢的数据绑定
        bc.ExecDropDownList(pavname, "select * from pavilion", "Name", "paID");
        bc.ExecDropDownList(cellname, "select * from cell", "Name", "ID");
        bc.ExecDropDownList(sunnyname, "select * from sunny", "Name", "ID");
        bc.ExecDropDownList(indoorname, "select * from indoor", "Name", "ID");
        //收集传递过来的值
        string ownerID = Request.QueryString["ownerID"].ToString();
        
        string strsql = "SELECT dbo.homeHold.*, dbo.pavilion.Name AS pavname,  dbo.cell.Name AS cellname ";
        strsql = strsql + "FROM dbo.homeHold INNER JOIN dbo.pavilion ON dbo.homeHold.paID = dbo.pavilion.paID ";
        strsql = strsql + "INNER JOIN dbo.cell ON dbo.homeHold.cellID = dbo.cell.ID ";
        strsql = strsql + "where ownerID=" + ownerID + "";

        //Response.Write(strsql);
        //Response.End();
        BaseClass bccc = new BaseClass();
        SqlDataReader sda = bccc.ExecRead(strsql);
        if (sda.Read())
        {   //绑定数据
            pavname.Text = sda["paID"].ToString();
            cellname.Text = sda["cellID"].ToString();
            sunnyname.Text = sda["sunnyID"].ToString();
            indoorname.Text = sda["indoorID"].ToString();

            holdname.Text = sda["Name"].ToString();
            tel.Text = sda["tel"].ToString();
            caldID.Text = sda["cardID"].ToString();
            floorname.Text = sda["floorNum"].ToString();
            unitname.Text = sda["unit"].ToString();
            uid.Text = sda["uid"].ToString();
            pwd.Text = sda["password"].ToString();


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


        }



       
       

    }

   
       
    














}