room.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;

public partial class admin_areafacility : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    public static string sql="";
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Convert.ToString(Session["UID"]) == "")
        {
            Response.Redirect("login.aspx");

        }


        if (!IsPostBack)
        {
           
            bc.ExecDropDownList(ddlPavilion, "select * from pavilion", "Name", "paID");//楼宇
            bc.ExecDropDownList(ddlCell, "select * from type where type='DY'", "name", "code");//单元
            this.bind();
        }
    }
    //数据绑定
    public void bind()
    {
        

        string strsql = "select * from v_room"+sql+" order by Code asc" ;
      // Response.Write(strsql);
        this.GridView1.DataSource = bc.ExecDS(strsql);
        this.GridView1.DataBind();
        


      
    }
    
   

    //GRID行绑定时发生
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            
            string id = e.Row.Cells[8].Text.ToString();
        //   Response.Write(id);
          //  Response.End();

            int not = Convert.ToInt32(id);
            if (not == 0)
            {
                e.Row.Cells[8].Text = "<font color=blue>空</font>";
                
            }
            else
            {
                e.Row.Cells[8].Text = "<font color=red>已有住户</font>";
               // ((LinkButton)(e.Row.Cells[9].Controls[0])).Enabled = false;//不能修改
                ((LinkButton)(e.Row.Cells[10].Controls[0])).Enabled = false;//不能删除
            }


            ((LinkButton)(e.Row.Cells[10].Controls[0])).Attributes.Add("onclick", "return confirm('将删除该房间的所有信息,确定删除吗？')");
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#99ccff';this.Style.color='buttontext';this.Style.cursor='default';");
          e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='';this.style.color='';");
        }
    }

    //分页
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        this.bind();
    }



//删除
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
         string id = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
        
         ArrayList sql = new ArrayList();
         
         string delHomeChargeFee = "delete from homechargefee where code='" + id+"'";//删除住户物业费记录
         sql.Add(delHomeChargeFee);
         string delHomePark = "delete from homePark where code='" + id+"'";//删除住户停车位记录
         sql.Add(delHomePark);
         string delHomeRepair = "delete from homeRepair where code='" + id+"'";//删除住户报修记录
         sql.Add(delHomeRepair);
         string delHomeReport = "delete from homeReport where code='" + id+"'";//删除住户投诉记录
         sql.Add(delHomeReport);
         string delHomeHold = "delete from homehold where code='" + id+"'";//删除住户表的相关记录
         sql.Add(delHomeHold);
         string delroom = "delete from room where code='" + id + "'";
         sql.Add(delroom);
         //foreach (string item in sql)
         //{
         //   Response.Write(item + "</br>");

         //}
         //Response.End();

         try
         {
             bc.ExecSQLTrans(sql);
             if (bc.ExecSQLTrans(sql))
             {
                 Response.Write("<script>alert('删除信息成功！');</script>");
                 this.bind();
             }
             else
             {
                 Response.Write("<script>alert('删除失败！');</script>");
                 return;
             }


             }
         catch(Exception ex)
         {
             Response.Write("操作失败，失败原因：" + ex.Message + "");
         }

         



      
    }
//编辑
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string id = this.GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        //Response.Write("<script>window.open('editroom.aspx?Code=" + id + "','','width=450,height=450')</script>");//弹出窗口
        Response.Redirect("editroom.aspx?Code=" + id + "");
        Response.Write("<script>location='javascript:history.go(-1)'</script>");
    }

    /// <summary>
    /// 实现将数据导出至Excel,
    /// 在上面的代码中，我们首先将gridview绑定到指定的数据源中，然后在button1的按钮（用来做导出到EXCEL的）的事件中，写入相关的代码。
    /// 这里使用Response.AddHeader("content-disposition","attachment;filename= exporttoexcel.xls");中的filename来指定将要导出的excel的文件名，
    /// 这里是exporttoexcel.xls。要注意的是，由于gridview的内容可能是分页显示的，因此，这里在每次导出excel时，先将gridview的allowpaging属性设置为 false,
    /// 然后通过页面流的方式导出当前页的gridview到excel中，最后再重新设置其allowpaging属性。另外要注意的是，要写一个空的VerifyRenderingInServerForm方法（必须写），
    /// 以确认在运行时为指定的ASP.NET 服务器控件呈现HtmlForm 控件
    /// ****************************************************************
    /// 以下代码部份来自互联网
    /// *****************
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
        Response.Charset = "gb2312";
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
      
        GridView1.AllowPaging = false;
        this.bind();
        GridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());
        Response.End();
        GridView1.AllowPaging = true;
        this.bind();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }
 
    
    //选择单元

    protected void ddlCell_SelectedIndexChanged(object sender, EventArgs e)
    {
        string pavID = ddlPavilion.SelectedItem.Value;
        string cellID = ddlCell.SelectedItem.Value;
        string left = pavID + cellID;
        int leftlenth = left.Length;
       sql=" where left(code," + leftlenth + ")='" + left + "'";
       this.bind();
       
       
       
    
       
    }

    //根据楼宇＋单元＋层数=查找
    protected void Button2_Click(object sender, EventArgs e)
    {
        string pavID = ddlPavilion.SelectedItem.Value;
        string cellID = ddlCell.SelectedItem.Value;
        string left = pavID + cellID;
        int leftlenth = left.Length;
        string floor;
       
        int num = Convert.ToInt32(txtnum.Text);
        if(num<10)
        {
          floor="0"+num.ToString();
        }
        else
        {
            floor=num.ToString();
        }



      sql = " where left(code," + leftlenth + ")='" + left + "' and substring(code,"+(leftlenth+1)+","+floor.Length+")='"+floor+"'";

       this.bind();
        
    }

   //选择楼宇
    protected void ddlPavilion_SelectedIndexChanged(object sender, EventArgs e)
    {
        string pavID = ddlPavilion.SelectedItem.Value;
       
        sql = " where left(code," + pavID.Length + ")='" + pavID + "'";
        this.bind();
    }

    //显示所有
    protected void Button3_Click(object sender, EventArgs e)
    {
       sql = "";
        this.bind();
    }
}