📄 form1.cs
字号:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace odt
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private Oracle.DataAccess.Client.OracleDataAdapter oracleDataAdapter1;
private Oracle.DataAccess.Client.OracleCommand selectOracleCommand1;
private Oracle.DataAccess.Client.OracleConnection oracleConnection1;
private Oracle.DataAccess.Client.OracleCommand insertOracleCommand1;
private Oracle.DataAccess.Client.OracleCommand updateOracleCommand1;
private Oracle.DataAccess.Client.OracleCommand deleteOracleCommand1;
private odt.Emp1 emp11;
private System.Windows.Forms.DataGrid dataGrid1;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter3 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter4 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter5 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter6 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter7 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter8 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter9 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter10 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter11 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter12 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter13 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter14 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter15 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter16 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter17 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter18 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter19 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter20 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter21 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter22 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter23 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter24 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter25 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter26 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter27 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter28 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter29 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter30 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter31 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter32 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter33 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter34 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter35 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter36 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter37 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter38 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter39 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter40 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter41 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter42 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter43 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter44 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter45 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter46 = new Oracle.DataAccess.Client.OracleParameter();
this.oracleDataAdapter1 = new Oracle.DataAccess.Client.OracleDataAdapter();
this.selectOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.insertOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.updateOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.deleteOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.emp11 = new odt.Emp1();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
((System.ComponentModel.ISupportInitialize)(this.emp11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// oracleDataAdapter1
//
this.oracleDataAdapter1.DeleteCommand = this.deleteOracleCommand1;
this.oracleDataAdapter1.InsertCommand = this.insertOracleCommand1;
this.oracleDataAdapter1.SelectCommand = this.selectOracleCommand1;
this.oracleDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Emp", new System.Data.Common.DataColumnMapping[0])});
this.oracleDataAdapter1.UpdateCommand = this.updateOracleCommand1;
//
// selectOracleCommand1
//
this.selectOracleCommand1.CommandText = "select * from emp";
this.selectOracleCommand1.Connection = this.oracleConnection1;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "User Id=scott;Data Source=OEMREP;Password=tiger;Persist Security Info=true;";
//
// insertOracleCommand1
//
this.insertOracleCommand1.CommandText = @"INSERT INTO ""EMP""( ""EMPNO"", ""ENAME"", ""JOB"", ""MGR"", ""HIREDATE"", ""SAL"", ""COMM"", ""DEPTNO"") VALUES ( :current_EMPNO_param0, :current_ENAME_param1, :current_JOB_param2, :current_MGR_param3, :current_HIREDATE_param4, :current_SAL_param5, :current_COMM_param6, :current_DEPTNO_param7)";
this.insertOracleCommand1.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter1.ParameterName = ":current_EMPNO_param0";
oracleParameter1.SourceColumn = "EMPNO";
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter2.ParameterName = ":current_ENAME_param1";
oracleParameter2.SourceColumn = "ENAME";
oracleParameter3.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter3.ParameterName = ":current_JOB_param2";
oracleParameter3.SourceColumn = "JOB";
oracleParameter4.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter4.ParameterName = ":current_MGR_param3";
oracleParameter4.SourceColumn = "MGR";
oracleParameter5.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Date;
oracleParameter5.ParameterName = ":current_HIREDATE_param4";
oracleParameter5.SourceColumn = "HIREDATE";
oracleParameter6.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter6.ParameterName = ":current_SAL_param5";
oracleParameter6.SourceColumn = "SAL";
oracleParameter7.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter7.ParameterName = ":current_COMM_param6";
oracleParameter7.SourceColumn = "COMM";
oracleParameter8.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter8.ParameterName = ":current_DEPTNO_param7";
oracleParameter8.SourceColumn = "DEPTNO";
this.insertOracleCommand1.Parameters.Add(oracleParameter1);
this.insertOracleCommand1.Parameters.Add(oracleParameter2);
this.insertOracleCommand1.Parameters.Add(oracleParameter3);
this.insertOracleCommand1.Parameters.Add(oracleParameter4);
this.insertOracleCommand1.Parameters.Add(oracleParameter5);
this.insertOracleCommand1.Parameters.Add(oracleParameter6);
this.insertOracleCommand1.Parameters.Add(oracleParameter7);
this.insertOracleCommand1.Parameters.Add(oracleParameter8);
//
// updateOracleCommand1
//
this.updateOracleCommand1.CommandText = @"UPDATE ""EMP"" SET ""EMPNO""=:current_EMPNO_param0, ""ENAME""=:current_ENAME_param1, ""JOB""=:current_JOB_param2, ""MGR""=:current_MGR_param3, ""HIREDATE""=:current_HIREDATE_param4, ""SAL""=:current_SAL_param5, ""COMM""=:current_COMM_param6, ""DEPTNO""=:current_DEPTNO_param7 WHERE ""EMPNO""=:original_EMPNO_param8 AND ((:original_ENAME_param9 IS NULL AND ""ENAME"" IS NULL) OR ""ENAME""=:original_ENAME_param10) AND ((:original_JOB_param11 IS NULL AND ""JOB"" IS NULL) OR ""JOB""=:original_JOB_param12) AND ((:original_MGR_param13 IS NULL AND ""MGR"" IS NULL) OR ""MGR""=:original_MGR_param14) AND ((:original_HIREDATE_param15 IS NULL AND ""HIREDATE"" IS NULL) OR ""HIREDATE""=:original_HIREDATE_param16) AND ((:original_SAL_param17 IS NULL AND ""SAL"" IS NULL) OR ""SAL""=:original_SAL_param18) AND ((:original_COMM_param19 IS NULL AND ""COMM"" IS NULL) OR ""COMM""=:original_COMM_param20) AND ((:original_DEPTNO_param21 IS NULL AND ""DEPTNO"" IS NULL) OR ""DEPTNO""=:original_DEPTNO_param22)";
this.updateOracleCommand1.Connection = this.oracleConnection1;
oracleParameter9.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter9.ParameterName = ":current_EMPNO_param0";
oracleParameter9.SourceColumn = "EMPNO";
oracleParameter10.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter10.ParameterName = ":current_ENAME_param1";
oracleParameter10.SourceColumn = "ENAME";
oracleParameter11.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter11.ParameterName = ":current_JOB_param2";
oracleParameter11.SourceColumn = "JOB";
oracleParameter12.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter12.ParameterName = ":current_MGR_param3";
oracleParameter12.SourceColumn = "MGR";
oracleParameter13.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Date;
oracleParameter13.ParameterName = ":current_HIREDATE_param4";
oracleParameter13.SourceColumn = "HIREDATE";
oracleParameter14.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter14.ParameterName = ":current_SAL_param5";
oracleParameter14.SourceColumn = "SAL";
oracleParameter15.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Single;
oracleParameter15.ParameterName = ":current_COMM_param6";
oracleParameter15.SourceColumn = "COMM";
oracleParameter16.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter16.ParameterName = ":current_DEPTNO_param7";
oracleParameter16.SourceColumn = "DEPTNO";
oracleParameter17.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int16;
oracleParameter17.ParameterName = ":original_EMPNO_param8";
oracleParameter17.SourceColumn = "EMPNO";
oracleParameter17.SourceVersion = System.Data.DataRowVersion.Original;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -