zhlist.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_ZhList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //显示住户信息列表
            this.GridView1.DataSource = DataControl.GetData("select * from 住户,楼栋 where 住户.楼栋代码=楼栋.楼栋代码");
            this.GridView1.DataBind();
        }
    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string idKey = this.GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)]["住户代码"].ToString();
        if (e.CommandName == "Mod")
        {
            //传递修改的标志 跳转页面
            Response.Redirect("ZhEdit.aspx?ID=" + idKey);
        }
        else 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 住户,楼栋 where 住户.楼栋代码=楼栋.楼栋代码");
            this.GridView1.DataBind();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //跳转页面
        Response.Redirect("ZhEdit.aspx");
    }
}