cwgledit.aspx.cs

来自「是个小区车辆管理系统」· CS 代码 · 共 57 行

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_CwglEdit : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //显示车位信息
            DataTable dt = new DataTable();
            if (Request.QueryString["ID"] != null)
            {
                this.TextBox1.ReadOnly = false;
                dt = DataControl.GetData("select * from 车位管理 where 车位代码=" + Request.QueryString["ID"] + "");
                if (dt.Rows.Count > 0)
                {
                    this.TextBox1.Text = dt.Rows[0]["车位名称"].ToString();
                    this.Textbox4.Text = dt.Rows[0]["车位备注"].ToString();
                    this.Textbox2.Text = dt.Rows[0]["车位编号"].ToString();
                    this.DropDownList1.SelectedIndex = DataControl.GetIndex(DropDownList1, dt.Rows[0]["车位类别"].ToString());
                }
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //跳转页面
        Response.Redirect("CwglList.aspx");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //根据标志 添加或修改 车位信息
        if (Request.QueryString["ID"] != null)
        {
            DataControl.Execute("update 车位管理 set 车位名称='" + TextBox1.Text + "',车位备注='" + Textbox4.Text + "'," +
                "车位类别='" + DropDownList1.SelectedItem.Text + "',车位编号='"+ this.Textbox2.Text +"'  where 车位代码='" + Request.QueryString["ID"] + "'");
        }
        else
        {
            DataControl.Execute("insert into 车位管理(车位名称,车位备注,车位类别,车位编号) values " +
                 " ('" + this.TextBox1.Text + "','" + Textbox4.Text + "','" + DropDownList1.SelectedItem.Text + "','" + this.Textbox2.Text + "')");

        }
        Response.Redirect("CwglList.aspx");
    }

}