homerepairinfo.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 addhomerepair : 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 strsql = "select * from homeRepair where ID='" + ID + "'";
        SqlDataReader mydr = bc.ExecRead(strsql);
        if (mydr.Read())
        {


            //Response.Write(mydr["ownerID"].ToString());
            //Response.End();
            Label1.Text = mydr["repairText"].ToString();//报修标题
            Label2.Text = mydr["repairDate"].ToString();//报修时间
            Label3.Text = mydr["repairMemo"].ToString();//报修内容

            Label9.Text = mydr["ownertext"].ToString();//业主验证意见

            labname.Text = mydr["varperson"].ToString();//审核人
           
            txtunit.Text = mydr["repairunit"].ToString();//维修单位
            txtmainhead.Text = mydr["mainhead"].ToString();//主要负责人
            txttel.Text = mydr["tel"].ToString();//电话
            txtmemo.Text = mydr["vartext"].ToString();//审核说明
            ddlyesno.Text = mydr["sign"].ToString();

            if (mydr["ownertext"].ToString() != "")
            {
                Button1.Visible = false;//用户反馈之后的报修信息怀允许在外理
            }

           
        }

        else
        {
            Response.Write("<script>alert('数据加载失败！请重试');</script>");
            return;
        }



        bc.Closeconn();
    }




    protected void Button1_Click(object sender, EventArgs e)
    {
        string id = Request.QueryString["ID"].ToString();
        string name = Session["adminName"].ToString();
        string sql = "update homerepair set varperson='" + name + "',repairunit='" + txtunit.Text + "',mainhead='" + txtmainhead.Text + "',tel='" + txttel.Text + "',vartext='" + txtmemo.Text + "',sign="+ddlyesno.SelectedItem.Value+" where id=" + id;

      //  Response.Write(sql);
        //Response.End();
        if (bc.ExecSql(sql))
        {
            Response.Write("<script>alert('审核信息成功！');opener.location='homerepair.aspx';</script>");
        }
        else
        {
            Response.Write("<script>alert(信息失败，请重试！');</script>");
        }
    }
}