editfix.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
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Convert.ToString(Session["UID"]) == "")
            {
                Response.Redirect("login.aspx");

            }
            else
            {
                this.bind();

            }
        }
       
    }
    protected void bind()
    {
        string ID = Request.QueryString["fixID"].ToString();
        string str = "select * from fixManager where fixID='" + ID + "'";

        BaseClass bc = new BaseClass();

        SqlDataReader sda = bc.ExecRead(str);
        if (sda.Read())
        {   //绑定数据
            name.Text = sda["name"].ToString();
            amount.Text = sda["amount"].ToString();
            factory.Text = sda["factory"].ToString();
            logoutdate.Text = sda["factoryDate"].ToString();




        }
       
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {
        BaseClass bcc = new BaseClass();
        string ID = Request.QueryString["fixID"].ToString();

        string sqlstr = "update fixManager set name='" + name.Text + "',amount='" + amount.Text + "',factory='" + factory.Text + "',factoryDate='" + logoutdate.Text + "' where fixID='"+ID+"'" ;
        //Response.Write(sqlstr);
        //Response.End();

        if (bcc.ExecSql(sqlstr))
        {
            Response.Write("<script language=javascript>alert('修改设备信息成功！');opener.location='fix.aspx';window.close()</script>");

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

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Write("<script>window.close();</script>");
    }
   
}