homereportinfo.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 (Convert.ToString(Session["UID"]) == "")
        {
            Response.Redirect("login.aspx");

        }

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

    }

    protected void bind()
    {
        string ID = Request.QueryString["ID"].ToString();
      
        string sql = "select * from v_homereport where ID=" + ID + "";
        //Response.Write(sql);
        //Response.End();
     
        try
        {
            SqlDataReader sda = bc.ExecRead(sql);
            if (sda.Read())
            {
                labid.Text = sda["ID"].ToString();
                labownerID.Text = sda["ownerID"].ToString();
                labtext.Text = sda["reportText"].ToString();
                labdate.Text = sda["reportDate"].ToString();
                memo.Text = sda["reportMemo"].ToString();

                ddlyesno.Text = sda["sign"].ToString();
                TextBox1.Text=sda["finshtext"].ToString();

            }
            else 
            {
                Response.Write("<script language=javascript>alert('没有检索到数据请重试！');</script>");
                return;
            }
        }
        catch(Exception ex)
        { Response.Write("获取数据出错！出错原因："+ex.Message);
            return;
        }
    }









    protected void Button2_Click(object sender, EventArgs e)
    {
        string id = Request.QueryString["ID"].ToString();
        string yesno = ddlyesno.SelectedItem.Value;
        string finsh = TextBox1.Text;
        string sql = "update homereport set sign=" + yesno + ",finshtext='" + finsh + "' where ID="+id+"";
        //Response.Write(sql);
       if(bc.ExecSql(sql))
       {
           Response.Write("<script language=javascript>alert('投诉审核处理成功！');location='homereport.aspx';</script>");
          

       }
       else
       {
            Response.Write("<script language=javascript>alert('数据处理失败，请重试！');</script>");
             return;
       }


    }
}