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

public partial class admin_addBus : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void gvBind()
    {
        this.GridView1.DataSource = Admin_Add.selectAll();
        this.GridView1.DataBind();
    }
    //protected void btAddBus_Click(object sender, EventArgs e)
    //{
    //    string zdz = this.tb_zdz.Text.Trim();
    //    if (Admin_Add.findBus(zdz))
    //        Response.Write("该点站已经存在！");
    //    else
    //    {
    //        StationMessage S = new StationMessage();
    //        S.zdz = this.tb_zdz.Text.Trim();
    //        S.fbsj = this.tb_fbsj.Text.Trim();
    //        S.tjzd = this.tb_tjzd.Text.Trim();
    //        S.zxdh = this.tb_zxdh.Text.Trim();
    //        S.cx = this.tb_cx.Text.Trim();
    //        S.pj = this.tb_pj.Text.Trim();
    //        S.lc = this.tb_lc.Text.Trim();
    //        S.cygs = this.tb_cygs.Text.Trim();
    //        S.bz = this.tb_bz.Text.Trim();
    //        if (Admin_Add.insertBus(S))
    //        {
    //            Response.Write("插入成功！");
    //            this.gvBind();
    //        }
    //        else
    //            Response.Write("插入失败！");
    //    }
    //}
    //protected void btnCheck_Click(object sender, EventArgs e)
    //{
    //    string zdz = this.tb_zdz.Text.Trim();
    //    if (Admin_Add.findBus(zdz))
    //        Response.Write("该点站已经存在！");
    //}
    //protected void Button1_Click(object sender, EventArgs e)
    //{
    //    string zdz = this.tb_zdz.Text.Trim();
    //    if (Admin_Add.findBus(zdz))
    //        Response.Write("<script language=javascript> alert('该点站已经存在！'); </script>");
    //    else
    //    {
    //        StationMessage S = new StationMessage();
    //        S.zdz = this.tb_zdz.Text.Trim();
    //        S.fbsj = this.tb_fbsj.Text.Trim();
    //        S.tjzd = this.tb_tjzd.Text.Trim();
    //        S.zxdh = this.tb_zxdh.Text.Trim();
    //        S.cx = this.tb_cx.Text.Trim();
    //        S.pj = this.tb_pj.Text.Trim();
    //        S.lc = this.tb_lc.Text.Trim();
    //        S.cygs = this.tb_cygs.Text.Trim();
    //        S.bz = this.tb_bz.Text.Trim();
    //        if (Admin_Add.insertBus(S))
    //        {
    //            Response.Write("插入成功！");
    //            this.gvBind();
    //        }
    //        else
    //            Response.Write("插入失败！");
    //    }
    //}
    //protected void btnCheck_click(object sender, EventArgs e)
    //{
    //    string zdz = this.tb_zdz.Text.Trim();
    //    if (Admin_Add.findBus(zdz))
    //        //Response.Write("该点站已经存在！");
    //        Response.Write("<script language=javascript> alert('该点站已经存在！'); </script>");
    //}


    protected void btnCheck_Click(object sender, EventArgs e)
    {
        string zdz = this.tb_zdz.Text.Trim();
        if (Admin_Add.findBus(zdz))
            //Response.Write("该点站已经存在！");
            Response.Write("<script language=javascript> alert('该点站已经存在！'); </script>");
    }
    protected void btAddBus_Click1(object sender, EventArgs e)
    {
        string zdz = this.tb_zdz.Text.Trim();
        if (Admin_Add.findBus(zdz))
            Response.Write("<script language=javascript> alert('该点站已经存在！'); </script>");
        else
        {
            StationMessage S = new StationMessage();
            S.zdz = this.tb_zdz.Text.Trim();
            S.fbsj = this.tb_fbsj.Text.Trim();
            S.tjzd = this.tb_tjzd.Text.Trim();
            S.zxdh = this.tb_zxdh.Text.Trim();
            S.cx = this.tb_cx.Text.Trim();
            S.pj = this.tb_pj.Text.Trim();
            S.lc = this.tb_lc.Text.Trim();
            S.cygs = this.tb_cygs.Text.Trim();
            S.bz = this.tb_bz.Text.Trim();
            if (Admin_Add.insertBus(S))
            {
                //Response.Write("插入成功！");
                Response.Write("<script language=javascript> alert('插入成功！'); </script>");
                this.gvBind();
            }
            else
                //Response.Write("插入失败！");
                Response.Write("<script language=javascript> alert('插入失败！'); </script>");
                
        }

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

    }
}