1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class admin_editareafac : System.Web.UI.Page
14...{
15    BaseClass bc = new BaseClass();
16   
17 protected void Page_Load(object sender, EventArgs e)
18    ...{
19
20
21      
22            if (Convert.ToString(Session["UID"]) == "")
23            ...{
24                Response.Redirect("login.aspx");
25
26            }
27              if (!IsPostBack)
28             ...{
29                 string str2 = "select * from type where type = 'Area'";
30                 bc.ExecDropDownList(ddl, str2, "Name", "code");//绑定设备类型到下拉列表框
31                this.bind();
32
33            }
34        
35     
36    }
37    protected void bind()
38    ...{   string ID=Request.QueryString["ID"].ToString();
39        string str="select * from areaFacility where ID='"+ID+"'";
40
41      
42        
43          SqlDataReader sda=bc.ExecRead(str);
44       if(sda.Read())
45        ...{   //绑定数据
46            TextBox1.Text=sda["unitName"].ToString();
47            TextBox2.Text=sda["mainHead"].ToString();
48            TextBox4.Text = sda["contactPerson"].ToString();
49            TextBox5.Text=sda["tel"].ToString();
50            FreeTextBox1.Text =sda["memo"].ToString();
51           
52            string typeID = sda["typeID"].ToString();
53            sda.Close();
54           
55
56           ddl.Text = typeID;//默认选择
57           
58
59      
60
61        }
62       
63
64    }
65    protected void Button1_Click(object sender, EventArgs e)
66    ...{
67        BaseClass bcc = new BaseClass();
68        string ID=Request.QueryString["ID"].ToString();
69
70
71        try
72        ...{
73                 string sqlstr = "update areaFacility set unitName='" + TextBox1.Text + "',mainHead='" + TextBox2.Text + "',contactPerson='" + TextBox4.Text + "',typeID='" + ddl.SelectedValue.ToString() + "',tel='" + TextBox5.Text + "',memo='" + FreeTextBox1.Text + "' where ID='" + ID + "'";
74                //Response.Write(sqlstr);
75                //Response.End();
76
77                if(bcc.ExecSql(sqlstr))
78                 ...{
79                    Response.Write("<script language=javascript>alert('修改公共设施成功！');location='areafacility.aspx'</script>");
80                 }
81                else
82                ...{
83                    Response.Write("<script>alert(修改失败，请重试！');</script>");
84                }
85        }
86        catch(Exception ex)
87        ...{
88            Response.Write("<script language=javascript>alert('系统出错，出错原因"+ex.Message+"');location='areafacility.aspx'</script>");
89        }
90        
91
92    }
93    
94}
95