📄 fteainfo.cs
字号:
//
this.textBox3.Location = new System.Drawing.Point(536, 32);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(80, 21);
this.textBox3.TabIndex = 6;
this.textBox3.Text = "";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(344, 32);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(88, 21);
this.textBox2.TabIndex = 5;
this.textBox2.Text = "";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(192, 32);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(80, 21);
this.textBox1.TabIndex = 4;
this.textBox1.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(120, 32);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(56, 23);
this.label3.TabIndex = 3;
this.label3.Text = "教师号";
//
// label2
//
this.label2.Location = new System.Drawing.Point(456, 32);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(56, 23);
this.label2.TabIndex = 2;
this.label2.Text = "职务";
//
// label1
//
this.label1.Location = new System.Drawing.Point(288, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(48, 23);
this.label1.TabIndex = 1;
this.label1.Text = "性别";
//
// button1
//
this.button1.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("button1.BackgroundImage")));
this.button1.Location = new System.Drawing.Point(24, 32);
this.button1.Name = "button1";
this.button1.TabIndex = 0;
this.button1.Text = "搜索";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// label4
//
this.label4.Location = new System.Drawing.Point(16, 336);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(40, 23);
this.label4.TabIndex = 3;
this.label4.Text = "姓名";
//
// label5
//
this.label5.Location = new System.Drawing.Point(16, 376);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(48, 24);
this.label5.TabIndex = 4;
this.label5.Text = "教师号";
//
// label6
//
this.label6.Location = new System.Drawing.Point(192, 336);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(32, 23);
this.label6.TabIndex = 5;
this.label6.Text = "性别";
//
// label7
//
this.label7.Location = new System.Drawing.Point(192, 376);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(40, 23);
this.label7.TabIndex = 6;
this.label7.Text = "年龄";
//
// label8
//
this.label8.Location = new System.Drawing.Point(384, 328);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(56, 23);
this.label8.TabIndex = 7;
this.label8.Text = "出生年月";
//
// label9
//
this.label9.Location = new System.Drawing.Point(392, 376);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(40, 16);
this.label9.TabIndex = 8;
this.label9.Text = "院系";
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "教师基本信息", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("教师号", "教师号"),
new System.Data.Common.DataColumnMapping("性别", "性别"),
new System.Data.Common.DataColumnMapping("年龄", "年龄"),
new System.Data.Common.DataColumnMapping("出生年月", "出生年月"),
new System.Data.Common.DataColumnMapping("院系", "院系"),
new System.Data.Common.DataColumnMapping("职务", "职务")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 教师基本信息 WHERE (教师号 = @Original_教师号) AND (出生年月 = @Original_出生年月) AND (姓" +
"名 = @Original_姓名) AND (年龄 = @Original_年龄) AND (性别 = @Original_性别) AND (职务 = @Ori" +
"ginal_职务) AND (院系 = @Original_院系)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_教师号", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "教师号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出生年月", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出生年月", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_年龄", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_性别", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性别", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职务", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职务", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_院系", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "院系", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=3366359E777E4EE;packet size=4096;integrated security=SSPI;data sou" +
"rce=3366359E777E4EE;persist security info=False;initial catalog=jiaoshi";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 教师基本信息(姓名, 教师号, 性别, 年龄, 出生年月, 院系, 职务) VALUES (@姓名, @教师号, @性别, @年龄, @出" +
"生年月, @院系, @职务); SELECT 姓名, 教师号, 性别, 年龄, 出生年月, 院系, 职务 FROM 教师基本信息 WHERE (教师号 = @教" +
"师号)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@教师号", System.Data.SqlDbType.VarChar, 16, "教师号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 4, "性别"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@年龄", System.Data.SqlDbType.Int, 4, "年龄"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生年月", System.Data.SqlDbType.DateTime, 8, "出生年月"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@院系", System.Data.SqlDbType.VarChar, 10, "院系"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职务", System.Data.SqlDbType.VarChar, 10, "职务"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 姓名, 教师号, 性别, 年龄, 出生年月, 院系, 职务 FROM 教师基本信息 WHERE (教师号 LIKE @a) AND (性别 LIKE" +
" @b) AND (职务 LIKE @c)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@a", System.Data.SqlDbType.VarChar, 16, "教师号"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@b", System.Data.SqlDbType.VarChar, 4, "性别"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@c", System.Data.SqlDbType.VarChar, 10, "职务"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 教师基本信息 SET 姓名 = @姓名, 教师号 = @教师号, 性别 = @性别, 年龄 = @年龄, 出生年月 = @出生年月, 院系 = @院系, 职务 = @职务 WHERE (教师号 = @Original_教师号) AND (出生年月 = @Original_出生年月) AND (姓名 = @Original_姓名) AND (年龄 = @Original_年龄) AND (性别 = @Original_性别) AND (职务 = @Original_职务) AND (院系 = @Original_院系); SELECT 姓名, 教师号, 性别, 年龄, 出生年月, 院系, 职务 FROM 教师基本信息 WHERE (教师号 = @教师号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@教师号", System.Data.SqlDbType.VarChar, 16, "教师号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 4, "性别"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@年龄", System.Data.SqlDbType.Int, 4, "年龄"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生年月", System.Data.SqlDbType.DateTime, 8, "出生年月"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@院系", System.Data.SqlDbType.VarChar, 10, "院系"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职务", System.Data.SqlDbType.VarChar, 10, "职务"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_教师号", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "教师号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出生年月", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出生年月", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_年龄", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_性别", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性别", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职务", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职务", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_院系", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "院系", System.Data.DataRowVersion.Original, null));
//
// label10
//
this.label10.Location = new System.Drawing.Point(560, 336);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(32, 16);
this.label10.TabIndex = 9;
this.label10.Text = "职务";
//
// textBox4
//
this.textBox4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.姓名"));
this.textBox4.Location = new System.Drawing.Point(72, 336);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(88, 21);
this.textBox4.TabIndex = 10;
this.textBox4.Text = "";
//
// textBox5
//
this.textBox5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.教师号"));
this.textBox5.Location = new System.Drawing.Point(72, 376);
this.textBox5.Name = "textBox5";
this.textBox5.TabIndex = 11;
this.textBox5.Text = "";
//
// textBox6
//
this.textBox6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.性别"));
this.textBox6.Location = new System.Drawing.Point(256, 336);
this.textBox6.Name = "textBox6";
this.textBox6.TabIndex = 12;
this.textBox6.Text = "";
//
// textBox7
//
this.textBox7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.年龄"));
this.textBox7.Location = new System.Drawing.Point(256, 376);
this.textBox7.Name = "textBox7";
this.textBox7.TabIndex = 13;
this.textBox7.Text = "";
//
// textBox8
//
this.textBox8.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.出生年月"));
this.textBox8.Location = new System.Drawing.Point(448, 328);
this.textBox8.Name = "textBox8";
this.textBox8.TabIndex = 14;
this.textBox8.Text = "";
//
// textBox9
//
this.textBox9.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.院系"));
this.textBox9.Location = new System.Drawing.Point(448, 376);
this.textBox9.Name = "textBox9";
this.textBox9.TabIndex = 15;
this.textBox9.Text = "";
//
// textBox10
//
this.textBox10.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet31, "教师基本信息.职务"));
this.textBox10.Location = new System.Drawing.Point(600, 328);
this.textBox10.Name = "textBox10";
this.textBox10.TabIndex = 16;
this.textBox10.Text = "";
//
// label11
//
this.label11.Location = new System.Drawing.Point(208, 432);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(48, 24);
this.label11.TabIndex = 17;
this.label11.Text = "共有：";
//
// textBox11
//
this.textBox11.Location = new System.Drawing.Point(264, 432);
this.textBox11.Name = "textBox11";
this.textBox11.Size = new System.Drawing.Size(96, 21);
this.textBox11.TabIndex = 18;
this.textBox11.Text = "";
//
// Form3
//
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -