edithomereport.aspx.cs

来自「物业管理系统」· CS 代码 · 共 97 行

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["code"]) == "")
        {
            Response.Redirect("../login.aspx");
        }
        if (!IsPostBack)
        {
            this.bind();

        }
    }

    protected void bind()
    {


        string ID = Request.QueryString["ID"].ToString();
        string strsql = "select * from homereport where ID='" + ID + "'";
        SqlDataReader mydr = bc.ExecRead(strsql);
        if (mydr.Read())
        {


            //Response.Write(mydr["ownerID"].ToString());
            //Response.End();


            txttitle.Text = mydr["reportText"].ToString();
            selectdate.Text = mydr["reportDate"].ToString();//报修时间

            FreeTextBox1.Text = mydr["reportMemo"].ToString();
        }

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



        bc.Closeconn();
    }

    
    protected void Button1_Click(object sender, EventArgs e)
    {

        string ID = Request.QueryString["ID"].ToString();
        string reportTitle = txttitle.Text.Trim();//报修标题
        string reportDate = selectdate.Text;//日期
        string reportMemo = FreeTextBox1.Text;//详细内容


        string sqlstr = "update homereport set reportText='" + reportTitle + "',reportMemo='" + reportMemo + "',reportDate='" +reportDate + "' where ID='" + ID + "'";


        //Response.Write(sqlstr);
        //Response.End();


        if (bc.ExecSql(sqlstr))
        {
            Response.Write("<script>alert('报修信息修改成功！');</script>");
        }
        else
        {
            Response.Write("<script>alert('操作失败！');</script>");
        }

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