ldlist.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_LdList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       if (!Page.IsPostBack)
        {
           //显示楼栋列表
            this.GridView1.DataSource = DataControl.GetData("select * from 楼栋");
            this.GridView1.DataBind();
            this.TextBox1.Text = "";
        }
    }

    private void initGrid()
    {
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        //判断信息是否正确
        if (this.TextBox1.Text.Trim() == "")
        {
            Response.Write("<script>alert('楼栋名称不能为空');</script>");
            return;
        }
        if (DataControl.GetData("select * from 楼栋 where 楼栋名称='" + this.TextBox1.Text.Trim() + "'").Rows.Count > 0)
        {
            Response.Write("<script>alert('名称重复');</script>");
            return;
        }
        //添加楼栋
        DataControl.Execute("insert into 楼栋(楼栋名称) values('" + this.TextBox1.Text.Trim() + "')");
        this.GridView1.DataSource = DataControl.GetData("select * from 楼栋");
        this.GridView1.DataBind();
        this.TextBox1.Text = "";
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string idkey = this.GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)]["楼栋代码"].ToString();
        if (e.CommandName == "Del")
        {
            //判断记录是否允许删除
            if (DataControl.GetData("select * from 住户 where 楼栋代码=" + idkey + "").Rows.Count > 0)
            {
                Response.Write("<script>alert('当前楼栋使用中');</script>");
                return;
            }
            //删除记录  刷新列表
            DataControl.Execute("delete from 楼栋 where 楼栋代码=" + idkey);
            this.GridView1.DataSource = DataControl.GetData("select * from 楼栋");
            this.GridView1.DataBind();
            this.TextBox1.Text = "";
        }
    }

    }