📄 form1.cs
字号:
//
// menuItem11
//
this.menuItem11.Index = 1;
this.menuItem11.Text = "各科目权值表";
this.menuItem11.Click += new System.EventHandler(this.menuItem11_Click);
//
// menuItem2
//
this.menuItem2.Index = 2;
this.menuItem2.Text = "专业成绩";
this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
//
// menuItem3
//
this.menuItem3.Index = 3;
this.menuItem3.Text = "行为积分数据";
this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
//
// menuItem4
//
this.menuItem4.Index = 1;
this.menuItem4.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem5});
this.menuItem4.Text = "行为积分";
//
// menuItem5
//
this.menuItem5.Index = 0;
this.menuItem5.Text = "加分规则";
this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
//
// menuItem6
//
this.menuItem6.Index = 2;
this.menuItem6.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem7});
this.menuItem6.Text = "评选";
//
// menuItem7
//
this.menuItem7.Index = 0;
this.menuItem7.Text = "开始评比";
this.menuItem7.Click += new System.EventHandler(this.menuItem7_Click);
//
// menuItem8
//
this.menuItem8.Index = 3;
this.menuItem8.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem9});
this.menuItem8.Text = "退出";
this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
//
// menuItem9
//
this.menuItem9.Index = 0;
this.menuItem9.Text = "退出程序";
this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
//
// dataGrid1
//
this.dataGrid1.AlternatingBackColor = System.Drawing.Color.LightCyan;
this.dataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, -8);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(552, 352);
this.dataGrid1.TabIndex = 0;
//
// button3
//
this.button3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.button3.Location = new System.Drawing.Point(120, 360);
this.button3.Name = "button3";
this.button3.TabIndex = 3;
this.button3.Text = "更新";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "student", 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.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
//
// oleDbConnection2
//
this.oleDbConnection2.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""recommendation.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString =@"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""recommendation.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
// oleDbDataAdapter2
//
this.oleDbDataAdapter2.DeleteCommand = this.oleDbDeleteCommand2;
this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand2;
this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "actionitem", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("行为项目编号", "行为项目编号"),
new System.Data.Common.DataColumnMapping("行为项目名称", "行为项目名称"),
new System.Data.Common.DataColumnMapping("所加分数", "所加分数")})});
this.oleDbDataAdapter2.UpdateCommand = this.oleDbUpdateCommand2;
//
// oleDbDataAdapter3
//
this.oleDbDataAdapter3.DeleteCommand = this.oleDbDeleteCommand3;
this.oleDbDataAdapter3.InsertCommand = this.oleDbInsertCommand3;
this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3;
this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "num", 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.oleDbDataAdapter3.UpdateCommand = this.oleDbUpdateCommand3;
//
// oleDbDataAdapter4
//
this.oleDbDataAdapter4.DeleteCommand = this.oleDbDeleteCommand4;
this.oleDbDataAdapter4.InsertCommand = this.oleDbInsertCommand4;
this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4;
this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "original", 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("c语言", "c语言"),
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.oleDbDataAdapter4.UpdateCommand = this.oleDbUpdateCommand4;
//
// oleDbDataAdapter5
//
this.oleDbDataAdapter5.InsertCommand = this.oleDbInsertCommand5;
this.oleDbDataAdapter5.SelectCommand = this.oleDbSelectCommand5;
this.oleDbDataAdapter5.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "power", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("bianyi", "bianyi"),
new System.Data.Common.DataColumnMapping("C", "C"),
new System.Data.Common.DataColumnMapping("database", "database"),
new System.Data.Common.DataColumnMapping("English", "English"),
new System.Data.Common.DataColumnMapping("gaoshu", "gaoshu"),
new System.Data.Common.DataColumnMapping("network", "network"),
new System.Data.Common.DataColumnMapping("os", "os"),
new System.Data.Common.DataColumnMapping("zhengzhi", "zhengzhi")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT id AS 学号, name AS 姓名, score AS 成绩, MajorPrize AS 重大发明奖, cet6 AS 六级 FROM st" +
"udent ORDER BY id";
this.oleDbSelectCommand1.Connection = this.oleDbConnection2;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -