Manage/addtype.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;
using LYF.SqlHelper;

public partial class Manage_addtype : System.Web.UI.Page
{
    private SqlHelper shp = new SqlHelper("XS");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack) 
        {

        }
    }
    /// <summary>
    /// 添加类型事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void addBT_Click(object sender, EventArgs e)
    {
        int count=0;
        string selsql = "select count(*) from XS_Type where typename='" + this.typeTB.Value + "'";
        using (SqlDataReader dr = shp.ExecuteReader(selsql)) 
        {
            if (dr.Read())
            {
                count = Int32.Parse(dr[0].ToString());
            }
        }
        shp.CloseDB();
        if (count > 0)
        {
            ShowJsMsg("此类型已存在！");
            this.typeTB.Value = "";
            this.typeTB.Focus();
        }
        else 
        {
            string insertsql = "insert into XS_Type(typename) values('" + this.typeTB.Value + "')";
            shp.ExecuteNonQuery(insertsql);
            Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>parent.closeLayer('addtype');</script>");
        }
    }
    public void ShowJsMsg(string msg)
    {
        this.ClientScript.RegisterStartupScript(this.GetType(), "message",
            "<script type='text/javascript' defer='defer'>alert('" + msg + "');</script>");
    }
}