系统维护.cs

管理学院机房计费系统,VISUAL STUDIO .NET 2003 c# 语言实现,SQL SERVER 2000数据库. 现运行正常.

			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_余额", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "余额", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 50, 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, 50, 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.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "锁定", System.Data.DataRowVersion.Original, null));
			// 
			// dataSet1
			// 
			this.dataSet1.DataSetName = "NewDataSet";
			this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.dataSet1.Tables.AddRange(new System.Data.DataTable[] {
																		  this.dataTable1});
			// 
			// dataTable1
			// 
			this.dataTable1.TableName = "Table1";
			// 
			// button2
			// 
			this.button2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.button2.Location = new System.Drawing.Point(520, 328);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(80, 24);
			this.button2.TabIndex = 3;
			this.button2.Text = "提交修改";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// tabControl1
			// 
			this.tabControl1.Controls.Add(this.tabPage1);
			this.tabControl1.Controls.Add(this.tabPage2);
			this.tabControl1.Controls.Add(this.tabPage3);
			this.tabControl1.Controls.Add(this.tabPage4);
			this.tabControl1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.tabControl1.Location = new System.Drawing.Point(24, 24);
			this.tabControl1.Name = "tabControl1";
			this.tabControl1.SelectedIndex = 0;
			this.tabControl1.Size = new System.Drawing.Size(656, 392);
			this.tabControl1.TabIndex = 4;
			// 
			// tabPage1
			// 
			this.tabPage1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.tabPage1.Controls.Add(this.dataGrid1);
			this.tabPage1.Controls.Add(this.groupBox1);
			this.tabPage1.Controls.Add(this.button2);
			this.tabPage1.Location = new System.Drawing.Point(4, 21);
			this.tabPage1.Name = "tabPage1";
			this.tabPage1.Size = new System.Drawing.Size(648, 367);
			this.tabPage1.TabIndex = 0;
			this.tabPage1.Text = "账户表";
			this.tabPage1.Click += new System.EventHandler(this.tabPage1_Click);
			// 
			// tabPage2
			// 
			this.tabPage2.Controls.Add(this.button11);
			this.tabPage2.Controls.Add(this.button4);
			this.tabPage2.Controls.Add(this.button3);
			this.tabPage2.Controls.Add(this.dataGrid2);
			this.tabPage2.Location = new System.Drawing.Point(4, 21);
			this.tabPage2.Name = "tabPage2";
			this.tabPage2.Size = new System.Drawing.Size(648, 367);
			this.tabPage2.TabIndex = 1;
			this.tabPage2.Text = "流水账表";
			this.tabPage2.Click += new System.EventHandler(this.tabPage2_Click);
			// 
			// button11
			// 
			this.button11.Location = new System.Drawing.Point(200, 336);
			this.button11.Name = "button11";
			this.button11.Size = new System.Drawing.Size(128, 23);
			this.button11.TabIndex = 3;
			this.button11.Text = "获取全部上机记录";
			this.button11.Click += new System.EventHandler(this.button11_Click);
			// 
			// button4
			// 
			this.button4.Location = new System.Drawing.Point(520, 336);
			this.button4.Name = "button4";
			this.button4.TabIndex = 2;
			this.button4.Text = "提交修改";
			this.button4.Click += new System.EventHandler(this.button4_Click);
			// 
			// button3
			// 
			this.button3.Location = new System.Drawing.Point(360, 336);
			this.button3.Name = "button3";
			this.button3.Size = new System.Drawing.Size(128, 23);
			this.button3.TabIndex = 1;
			this.button3.Text = "获取当前上机记录";
			this.button3.Click += new System.EventHandler(this.button3_Click);
			// 
			// dataGrid2
			// 
			this.dataGrid2.CaptionText = "上机记录";
			this.dataGrid2.DataMember = "";
			this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid2.Location = new System.Drawing.Point(24, 16);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.Size = new System.Drawing.Size(600, 304);
			this.dataGrid2.TabIndex = 0;
			this.dataGrid2.Tag = "";
			// 
			// tabPage3
			// 
			this.tabPage3.Controls.Add(this.label3);
			this.tabPage3.Controls.Add(this.textBox4);
			this.tabPage3.Controls.Add(this.button9);
			this.tabPage3.Controls.Add(this.button6);
			this.tabPage3.Controls.Add(this.dataGrid3);
			this.tabPage3.Location = new System.Drawing.Point(4, 21);
			this.tabPage3.Name = "tabPage3";
			this.tabPage3.Size = new System.Drawing.Size(648, 367);
			this.tabPage3.TabIndex = 2;
			this.tabPage3.Text = "收费流水表";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(312, 336);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(32, 23);
			this.label3.TabIndex = 7;
			this.label3.Text = "元";
			this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// textBox4
			// 
			this.textBox4.Location = new System.Drawing.Point(192, 336);
			this.textBox4.Name = "textBox4";
			this.textBox4.TabIndex = 6;
			this.textBox4.Text = "";
			// 
			// button9
			// 
			this.button9.Location = new System.Drawing.Point(88, 336);
			this.button9.Name = "button9";
			this.button9.TabIndex = 5;
			this.button9.Text = "今日收费额";
			this.button9.Click += new System.EventHandler(this.button9_Click);
			// 
			// button6
			// 
			this.button6.Location = new System.Drawing.Point(520, 336);
			this.button6.Name = "button6";
			this.button6.TabIndex = 4;
			this.button6.Text = "提交修改";
			this.button6.Click += new System.EventHandler(this.button6_Click);
			// 
			// dataGrid3
			// 
			this.dataGrid3.CaptionText = "收费表";
			this.dataGrid3.DataMember = "";
			this.dataGrid3.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid3.Location = new System.Drawing.Point(24, 16);
			this.dataGrid3.Name = "dataGrid3";
			this.dataGrid3.Size = new System.Drawing.Size(600, 304);
			this.dataGrid3.TabIndex = 0;
			// 
			// tabPage4
			// 
			this.tabPage4.Controls.Add(this.groupBox5);
			this.tabPage4.Controls.Add(this.groupBox4);
			this.tabPage4.Controls.Add(this.groupBox3);
			this.tabPage4.Controls.Add(this.groupBox2);
			this.tabPage4.Location = new System.Drawing.Point(4, 21);
			this.tabPage4.Name = "tabPage4";
			this.tabPage4.Size = new System.Drawing.Size(648, 367);
			this.tabPage4.TabIndex = 3;
			this.tabPage4.Text = "系统管理";
			// 
			// groupBox5
			// 
			this.groupBox5.Controls.Add(this.button10);
			this.groupBox5.Controls.Add(this.dataGrid6);
			this.groupBox5.Location = new System.Drawing.Point(24, 8);
			this.groupBox5.Name = "groupBox5";
			this.groupBox5.Size = new System.Drawing.Size(320, 184);
			this.groupBox5.TabIndex = 9;
			this.groupBox5.TabStop = false;
			this.groupBox5.Text = "值班教师信息";
			// 
			// button10
			// 
			this.button10.Location = new System.Drawing.Point(200, 152);
			this.button10.Name = "button10";
			this.button10.TabIndex = 1;
			this.button10.Text = "提交修改";
			this.button10.Click += new System.EventHandler(this.button10_Click);
			// 
			// dataGrid6
			// 
			this.dataGrid6.DataMember = "";
			this.dataGrid6.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid6.Location = new System.Drawing.Point(16, 24);