devicesearch.aspx.cs

纯代码实现了从Oracle数据库中调用并添加、修改、删除设备信息表记录的功能。

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

public partial class DeviceSearch : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string conString = ConfigurationManager.AppSettings["ConnString"];
            OracleConnection conn = new OracleConnection(conString);
            OracleCommand cmd = new OracleCommand();
            cmd.CommandText = "select * from 设备信息表 order by 装置编号";
            cmd.Connection = conn;
            conn.Open();
            OracleDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
            conn.Close();
            string SQL = "select " + DropDownList1.Text + " from 匹配";
            cmd.Connection = conn;
            OracleDataAdapter myAdapter = new OracleDataAdapter(SQL, conn);
            conn.Open();
            DataSet dataSet = new DataSet();
            myAdapter.Fill(dataSet, "Table1");
            conn.Close();
            DropDownList2.DataSource = dataSet.Tables["Table1"].DefaultView;
            DropDownList2.DataTextField = "" + DropDownList1.Text + "";
            DropDownList2.DataValueField = "" + DropDownList1.Text + "";
            DropDownList2.DataBind();
        }


    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("DeviceADD.aspx");
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string conString = ConfigurationManager.AppSettings["ConnString"];
        OracleConnection conn = new OracleConnection(conString);
        OracleCommand cmd = new OracleCommand();
        string SQL = "select " + DropDownList1.Text + " from 匹配";
        cmd.Connection = conn;
        OracleDataAdapter myAdapter = new OracleDataAdapter(SQL,conn);
        conn.Open();
        DataSet dataSet = new DataSet();
        myAdapter.Fill(dataSet, "Table1");
        conn.Close();
        DropDownList2.DataSource = dataSet.Tables["Table1"].DefaultView;
        DropDownList2.DataTextField = "" + DropDownList1.Text + "";
        DropDownList2.DataValueField = "" + DropDownList1.Text + "";
        DropDownList2.DataBind();
        if (DropDownList1.Text == "装置状态")
        {
            TextBox1.Visible = false;
        }
        else
        {
            TextBox1.Visible = true;  
        }
       
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string conString=ConfigurationManager.AppSettings["ConnString"];
        OracleConnection conn = new OracleConnection(conString);
        OracleCommand cmd = new OracleCommand();
        if (DropDownList1.Text == "装置状态")
        {

            cmd.CommandText = "select * from 设备信息表 where 装置状态='" + DropDownList2.Text + "'";
            cmd.Connection = conn;
            conn.Open();
            OracleDataReader ds = cmd.ExecuteReader();
            GridView1.DataSource = ds;
            GridView1.DataBind();
            conn.Close();
        }
        else 
        {
            if (DropDownList1.Text == "装置名称")
            {
                cmd.CommandText = "select * from 设备信息表 where 装置名称='" + TextBox1.Text.Trim() + "'";
                cmd.Connection = conn;
                conn.Open();
                OracleDataReader ds = cmd.ExecuteReader();
                GridView1.DataSource = ds;
                GridView1.DataBind();
                conn.Close();
            }
            else
            {
                if (DropDownList1.Text == "装置编号")
                {
                    if (DropDownList2.Text == "大于")
                    {
                        cmd.CommandText = "select * from 设备信息表 where 装置编号 >'" + TextBox1.Text + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        OracleDataReader ds = cmd.ExecuteReader();
                        GridView1.DataSource = ds;
                        GridView1.DataBind();
                        conn.Close();
                    }
                    else
                    {
                        if (DropDownList2.Text == "等于")
                        {
                            cmd.CommandText = "select * from 设备信息表 where 装置编号='" + TextBox1.Text + "'";
                            cmd.Connection = conn;
                            conn.Open();
                            OracleDataReader ds = cmd.ExecuteReader();
                            GridView1.DataSource = ds;
                            GridView1.DataBind();
                            conn.Close();
                        }
                        else
                        {
                            cmd.CommandText = "select * from 设备信息表 where 装置编号 <'" + TextBox1.Text + "'";
                            cmd.Connection = conn;
                            conn.Open();
                            OracleDataReader ds = cmd.ExecuteReader();
                            GridView1.DataSource = ds;
                            GridView1.DataBind();
                            conn.Close();
                        }
                    }
                }
                else 
                {
                    if (DropDownList1.Text == "装置型号")
                    {
                        if (DropDownList2.Text == "大于")
                        {
                            cmd.CommandText = "select * from 设备信息表 where 装置型号>'" + TextBox1.Text + "'";
                            cmd.Connection = conn;
                            conn.Open();
                            OracleDataReader ds = cmd.ExecuteReader();
                            GridView1.DataSource = ds;
                            GridView1.DataBind();
                            conn.Close();
                        }
                        else
                        {
                            if (DropDownList2.Text == "等于")
                            {
                                cmd.CommandText = "select * from 设备信息表 where 装置型号='" + TextBox1.Text + "'";
                                cmd.Connection = conn;
                                conn.Open();
                                OracleDataReader ds = cmd.ExecuteReader();
                                GridView1.DataSource = ds;
                                GridView1.DataBind();
                                conn.Close();
                            }
                            else
                            {
                                cmd.CommandText = "select * from 设备信息表 where 装置型号<'" + TextBox1.Text + "'";
                                cmd.Connection = conn;
                                conn.Open();
                                OracleDataReader ds = cmd.ExecuteReader();
                                GridView1.DataSource = ds;
                                GridView1.DataBind();
                                conn.Close();
                            }
                        }
                    }
                }
            }
        }
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("change.aspx");
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        string conString = ConfigurationManager.AppSettings["ConnString"];
        OracleConnection conn = new OracleConnection(conString);
        OracleCommand cmd = new OracleCommand();
        cmd.CommandText = "select * from 设备信息表  order by 装置编号";
        cmd.Connection = conn;
        conn.Open();
        OracleDataReader dr = cmd.ExecuteReader();
        GridView1.DataSource = dr;
        GridView1.DataBind();
        conn.Close();
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
   
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string conString = ConfigurationManager.AppSettings["ConnString"];
        OracleConnection conn = new OracleConnection(conString);
        OracleCommand cmd = new OracleCommand();
        cmd.CommandText = "delete * from 设备信息表  where 装置编号 = '" +GridView1.DataKeys[e.RowIndex].Value.ToString() +"'" ;
        cmd.Connection = conn;
        conn.Open();
        OracleDataReader dr = cmd.ExecuteReader();
        GridView1.DataSource = dr;
        GridView1.DataBind();
        conn.Close();
    }
}