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;
11
12public partial class addpavilion : System.Web.UI.Page
13...{
14    BaseClass bc = new BaseClass();//定义一个公共类的实例
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17      
18            if (Convert.ToString(Session["UID"]) == "")
19            ...{
20                Response.Redirect("login.aspx");
21
22            }
23           if (!IsPostBack)
24            ...{  
25        
26                this.bind();
27
28            }
29        
30    }
31    protected void bind()
32    ...{
33       
34        bc.ExecDropDownList(ddl1, "select * from type where type='LY'", "Name", "code");
35      
36
37
38    }
39    protected void Button1_Click(object sender, EventArgs e)
40    ...{
41        string valsql = "select count(*) from pavilion where name='" + name.Text + "'";
42        int count = (int)bc.ExecCscalar(valsql);
43        if (count > 0)
44        ...{
45            Response.Write("<script language=javascript>alert('小区楼宇重复！');location='pavilion.aspx'</script>");
46        }
47       
48        string sqlstr="insert into pavilion (Name,layer,high,area,buildDate,typeID,memo)values('" + name.Text + "'," + layer.Text + "," +high.Text + "," + area.Text + ",'" +selectdate.Text + "','" + ddl1.SelectedValue + "','"+memo.Text+"')";
49        //Response.Write(sqlstr);
50        //Response.End();
51        if (bc.ExecSql(sqlstr))
52        ...{
53            Response.Write("<script language=javascript>alert('添加小区楼宇成功！');location='pavilion.aspx'</script>");
54        }
55        else
56        ...{
57            Response.Write("<script>alert('添加失败，请重试！');</script>");
58        }
59    }
60}
61