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 admin_Default2 : 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           
24    }
25    
26    protected void Button1_Click(object sender, EventArgs e)
27    ...{
28
29        string sql = "select count(*) from chargeFeetype where Name='" + TextBox1.Text.Trim() + "'";
30        int count = (int)bc.ExecCscalar(sql);
31        if (count > 0)
32        ...{
33            Response.Write("<script language=javascript>alert('添加失败,存在相同的收费！')</script>");
34            return;
35
36        }
37        string sqlstr = "insert into ChargeFeeType(Name,textmemo,format)values('" + TextBox1.Text + "','" + TextBox2.Text+"','"+TextBox3.Text+ "')";
38      //  Response.Write(sqlstr);
39      //  Response.End();
40
41        if (bc.ExecSql(sqlstr))
42        ...{
43            Response.Write("<script language=javascript>alert('添加小区收费类型成功！');location='chargetype.aspx'</script>");
44        }
45        else
46        ...{
47            Response.Write("<script>alert('添加失败，请重试！');</script>");
48        }
49
50    }
51}
52