addchargetype.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;

public partial class admin_Default2 : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();//定义一个公共类的实例
    protected void Page_Load(object sender, EventArgs e)
    {
        
            if (Convert.ToString(Session["UID"]) == "")
            {
                Response.Redirect("login.aspx");

            }
           
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {

        string sql = "select count(*) from chargeFeetype where Name='" + TextBox1.Text.Trim() + "'";
        int count = (int)bc.ExecCscalar(sql);
        if (count > 0)
        {
            Response.Write("<script language=javascript>alert('添加失败,存在相同的收费！')</script>");
            return;

        }
        string sqlstr = "insert into ChargeFeeType(Name,textmemo,format)values('" + TextBox1.Text + "','" + TextBox2.Text+"','"+TextBox3.Text+ "')";
      //  Response.Write(sqlstr);
      //  Response.End();

        if (bc.ExecSql(sqlstr))
        {
            Response.Write("<script language=javascript>alert('添加小区收费类型成功！');location='chargetype.aspx'</script>");
        }
        else
        {
            Response.Write("<script>alert('添加失败，请重试！');</script>");
        }

    }
}