change.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
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;
using System.Drawing;
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
        //string conString = ConfigurationManager.AppSettings["ConnString"];
        //OracleConnection conn = new OracleConnection(conString);
        //OracleCommand cmd = new OracleCommand();
        //cmd.CommandText = "select * from 设备信息表 ";
        //cmd.Connection = conn;
        //conn.Open();
        //OracleDataReader dr = cmd.ExecuteReader();
        //while (dr.Read())
        //{

        //    this.ListBox1.Items.Add(dr.GetString(0));
        //}
        //conn.Close();
        
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("DeviceSearch.aspx");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
        TextBox7.Text = "";
        TextBox9.Text = "";
        TextBox10.Text = "";
        TextBox11.Text = "";
        TextBox12.Text = "";
        TextBox13.Text = "";
    }
    protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
       
        string conString = ConfigurationManager.AppSettings["ConnString"];
        OracleConnection conn = new OracleConnection(conString);
        OracleCommand cmd = new OracleCommand();
        cmd.CommandText = "select * from 设备信息表 where 装置编号='"+ListBox1.SelectedItem.Value.ToString()+"'";
        cmd.Connection = conn;
        conn.Open();
        OracleDataReader ds = cmd.ExecuteReader();
        if(ds.Read())
        {
            TextBox1.Text = ds.GetString(0);
            TextBox3.Text = ds.GetString(2);
            TextBox4.Text = ds.GetString(3);
        }
        conn.Close();
        cmd.CommandText = "select * from 设备信息表 where 装置编号='" + ListBox1.SelectedItem.Value.ToString() + "'";
        cmd.Connection = conn;
        conn.Open();
        OracleDataReader dr = cmd.ExecuteReader();
        GridView1.DataSource = dr;
        GridView1.DataBind();
        conn.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string conString = ConfigurationManager.AppSettings["ConnString"];
        OracleConnection conn = new OracleConnection(conString);
        OracleCommand cmd = new OracleCommand();
        if (TextBox3.Text == "")
        {
            Label1.ForeColor = Color.FromName("red");
            Label1.Text = "请输入装置名称";
        }
        else
        {
            if (TextBox4.Text == "")
            {
                Label1.ForeColor = Color.FromName("red");
                Label1.Text = "请输入装置型号";
            }
            else
            {
                if (TextBox5.Text == "")
                {
                    if (TextBox6.Text == "")
                    {
                        cmd.CommandText = "update 设备信息表 set 出厂编号='" + TextBox2.Text + "',装置名称='" + TextBox3.Text + "',装置型号='" + TextBox4.Text + "',出厂日期='" + TextBox5.Text + "',购置日期='" + TextBox6.Text + "',购入单价='" + TextBox7.Text + "',备注='" + TextBox13.Text + "',装置状态='" + DropDownList1.Text + "',装置制造商='" + TextBox9.Text + "',装置类别='" + TextBox10.Text + "',装置精度='" + TextBox11.Text + "',装置量程='" + TextBox12.Text + "' where 装置编号='"+TextBox1.Text+"'";
                        cmd.Connection = conn;
                        conn.Open();
                        cmd.ExecuteNonQuery();
                        conn.Close();
                        cmd.CommandText = "select * from 设备信息表 where 装置编号='" + ListBox1.SelectedItem.Value.ToString() + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        OracleDataReader dr = cmd.ExecuteReader();
                        GridView1.DataSource = dr;
                        GridView1.DataBind();
                        conn.Close();
                        Label1.ForeColor = Color.FromName("blue");
                        Label1.Text = "修改成功！";
                    }
                    else
                    {
                        cmd.CommandText = "update 设备信息表 set 出厂编号='" + TextBox2.Text + "',装置名称='" + TextBox3.Text + "',装置型号='" + TextBox4.Text + "',出厂日期='" + TextBox5.Text + "',购置日期=date'" + TextBox6.Text + "',购入单价='" + TextBox7.Text + "',备注='" + TextBox13.Text + "',装置状态='" + DropDownList1.Text + "',装置制造商='" + TextBox9.Text + "',装置类别='" + TextBox10.Text + "',装置精度='" + TextBox11.Text + "',装置量程='" + TextBox12.Text + "' where 装置编号='" + TextBox1.Text + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        cmd.ExecuteNonQuery();
                        conn.Close();
                        cmd.CommandText = "select * from 设备信息表 where 装置编号='" + ListBox1.SelectedItem.Value.ToString() + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        OracleDataReader dr = cmd.ExecuteReader();
                        GridView1.DataSource = dr;
                        GridView1.DataBind();
                        conn.Close();
                        Label1.ForeColor = Color.FromName("blue");
                        Label1.Text = "修改成功！";
                    }
                }
                else 
                {
                    if (TextBox6.Text == "")
                    {
                        cmd.CommandText = "update 设备信息表 set 出厂编号='" + TextBox2.Text + "',装置名称='" + TextBox3.Text + "',装置型号='" + TextBox4.Text + "',出厂日期=date'" + TextBox5.Text + "',购置日期='" + TextBox6.Text + "',购入单价='" + TextBox7.Text + "',备注='" + TextBox13.Text + "',装置状态='" + DropDownList1.Text + "',装置制造商='" + TextBox9.Text + "',装置类别='" + TextBox10.Text + "',装置精度='" + TextBox11.Text + "',装置量程='" + TextBox12.Text + "' where 装置编号='" + TextBox1.Text + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        cmd.ExecuteNonQuery();
                        conn.Close();
                        cmd.CommandText = "select * from 设备信息表 where 装置编号='" + ListBox1.SelectedItem.Value.ToString() + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        OracleDataReader dr = cmd.ExecuteReader();
                        GridView1.DataSource = dr;
                        GridView1.DataBind();
                        conn.Close();
                        Label1.ForeColor = Color.FromName("blue");
                        Label1.Text = "修改成功！";
                    }
                    else 
                    {
                        cmd.CommandText = "update 设备信息表 set 出厂编号='" + TextBox2.Text + "',装置名称='" + TextBox3.Text + "',装置型号='" + TextBox4.Text + "',出厂日期=date'" + TextBox5.Text + "',购置日期=date'" + TextBox6.Text + "',购入单价='" + TextBox7.Text + "',备注='" + TextBox13.Text + "',装置状态='" + DropDownList1.Text + "',装置制造商='" + TextBox9.Text + "',装置类别='" + TextBox10.Text + "',装置精度='" + TextBox11.Text + "',装置量程='" + TextBox12.Text + "' where 装置编号='" + TextBox1.Text + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        cmd.ExecuteNonQuery();
                        conn.Close();
                        cmd.CommandText = "select * from 设备信息表 where 装置编号='" + ListBox1.SelectedItem.Value.ToString() + "'";
                        cmd.Connection = conn;
                        conn.Open();
                        OracleDataReader dr = cmd.ExecuteReader();
                        GridView1.DataSource = dr;
                        GridView1.DataBind();
                        conn.Close();
                        Label1.ForeColor = Color.FromName("blue");
                        Label1.Text = "修改成功！";
                    }
                }
            }
        }
        

    }
}