homehold.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
{
    public static string sql = "";
    BaseClass bc = new BaseClass();
    stringoperator stroper = new stringoperator();
    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()
    {
        BaseClass bc = new BaseClass();

       // string strsql = "SELECT dbo.homeHold.*, dbo.room.ownerID AS ownerID ";
         //strsql=strsql+"FROM dbo.homeHold INNER JOIN  dbo.room ON dbo.homeHold.Code = dbo.room.Code "+sql+" ORDER BY dbo.homeHold.ID DESC";
        string strsql = "select * from v_homehold " + sql + " order by ID desc";
     

    　bc.ExecGridView(GridView1, strsql);//绑定数据
     

      
    }

    //GRID行绑定时发生
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {


            ((LinkButton)(e.Row.Cells[10].Controls[0])).Attributes.Add("onclick", "return confirm('确定删除吗？')");
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#22dd22';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 updateroom = "update room set state=0 where code='"+id+"'";
         sql.Add(updateroom);
         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);
        
         //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('edithomehold.aspx?ownerID=" + id + "','','width=450,height=450')</script>");//弹出窗口
        Response.Redirect("edithomehold.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 ddlPavilion_SelectedIndexChanged(object sender, EventArgs e)
    {
        string pavID = ddlPavilion.SelectedItem.Value;

        sql = " where left(code," + pavID.Length + ")='" + pavID + "'";
        this.bind();

    }
    //选择单元后执行
    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(TextBox1.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 Button3_Click(object sender, EventArgs e)
    {
        sql = "";
        Panel1.Visible = true;
        Panel2.Visible = false;
        this.bind();
    }
    //根据选择进行多条件查找
    protected void Button4_Click(object sender, EventArgs e)
    {

        Hashtable htabel = new Hashtable();
        if (CheckBox1.Checked)
        {
            htabel.Add("Name", name.Text);
            // Response.Write(htabel["unitName"].GetType().ToString());
            //  Response.End();

        }
        if (CheckBox2.Checked)
        {
            htabel.Add("cardID", cardID.Text);

        }
        if (CheckBox3.Checked)
        {
            htabel.Add("unit", unit.Text);
        }
        if (CheckBox4.Checked)
        {
            htabel.Add("tel", mobile.Text);
        }
        if (CheckBox5.Checked)
        {
            htabel.Add("roomID", roomID.Text);
        }
        if(CheckBox7.Checked)
        {
            htabel.Add("uid",user.Text);
        }
        if (CheckBox8.Checked)
        {
            htabel.Add("ownerID", TextBox2.Text);
        }
        if (CheckBox6.Checked)
        {
            sql = stroper.GetConditionClause(htabel, true);
        }
        else
        {
            sql = stroper.GetConditionClause(htabel, false);
        }

      //  Response.Write(sql);
     //   Response.End();
        this.bind();
    }
    protected void Button6_Click(object sender, EventArgs e)
    {
        Panel1.Visible = false;
        Panel2.Visible = true;
    }
}