系统维护.cs

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

			this.dataGrid6.Name = "dataGrid6";
			this.dataGrid6.Size = new System.Drawing.Size(288, 120);
			this.dataGrid6.TabIndex = 0;
			// 
			// groupBox4
			// 
			this.groupBox4.Controls.Add(this.label6);
			this.groupBox4.Controls.Add(this.label5);
			this.groupBox4.Controls.Add(this.dataGrid5);
			this.groupBox4.Controls.Add(this.button8);
			this.groupBox4.Location = new System.Drawing.Point(360, 8);
			this.groupBox4.Name = "groupBox4";
			this.groupBox4.Size = new System.Drawing.Size(264, 184);
			this.groupBox4.TabIndex = 10;
			this.groupBox4.TabStop = false;
			this.groupBox4.Text = "优惠信息";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(200, 88);
			this.label6.Name = "label6";
			this.label6.TabIndex = 5;
			this.label6.Text = "%";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(200, 64);
			this.label5.Name = "label5";
			this.label5.TabIndex = 4;
			this.label5.Text = "%";
			// 
			// dataGrid5
			// 
			this.dataGrid5.DataMember = "";
			this.dataGrid5.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid5.Location = new System.Drawing.Point(16, 24);
			this.dataGrid5.Name = "dataGrid5";
			this.dataGrid5.Size = new System.Drawing.Size(184, 120);
			this.dataGrid5.TabIndex = 1;
			// 
			// button8
			// 
			this.button8.Location = new System.Drawing.Point(160, 152);
			this.button8.Name = "button8";
			this.button8.TabIndex = 3;
			this.button8.Text = "提交修改";
			this.button8.Click += new System.EventHandler(this.button8_Click);
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.dataGrid4);
			this.groupBox3.Controls.Add(this.button7);
			this.groupBox3.Location = new System.Drawing.Point(24, 200);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(320, 152);
			this.groupBox3.TabIndex = 11;
			this.groupBox3.TabStop = false;
			this.groupBox3.Text = "机房信息";
			// 
			// dataGrid4
			// 
			this.dataGrid4.DataMember = "";
			this.dataGrid4.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid4.Location = new System.Drawing.Point(16, 24);
			this.dataGrid4.Name = "dataGrid4";
			this.dataGrid4.Size = new System.Drawing.Size(288, 88);
			this.dataGrid4.TabIndex = 0;
			// 
			// button7
			// 
			this.button7.Location = new System.Drawing.Point(200, 120);
			this.button7.Name = "button7";
			this.button7.TabIndex = 2;
			this.button7.Text = "提交修改";
			this.button7.Click += new System.EventHandler(this.button7_Click);
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.label4);
			this.groupBox2.Controls.Add(this.comboBox1);
			this.groupBox2.Controls.Add(this.label2);
			this.groupBox2.Controls.Add(this.textBox5);
			this.groupBox2.Controls.Add(this.button5);
			this.groupBox2.Controls.Add(this.label1);
			this.groupBox2.Controls.Add(this.textBox3);
			this.groupBox2.Controls.Add(this.dateTimePicker1);
			this.groupBox2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.groupBox2.Location = new System.Drawing.Point(360, 200);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(264, 152);
			this.groupBox2.TabIndex = 5;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "意外情况集体下机";
			// 
			// label4
			// 
			this.label4.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label4.Location = new System.Drawing.Point(120, 120);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(40, 23);
			this.label4.TabIndex = 11;
			this.label4.Text = "机房";
			this.label4.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
			// 
			// comboBox1
			// 
			this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.comboBox1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.comboBox1.Location = new System.Drawing.Point(24, 120);
			this.comboBox1.Name = "comboBox1";
			this.comboBox1.Size = new System.Drawing.Size(80, 24);
			this.comboBox1.TabIndex = 7;
			this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
			// 
			// label2
			// 
			this.label2.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label2.ImageAlign = System.Drawing.ContentAlignment.BottomLeft;
			this.label2.Location = new System.Drawing.Point(216, 80);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(40, 24);
			this.label2.TabIndex = 9;
			this.label2.Text = "分";
			this.label2.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
			// 
			// textBox5
			// 
			this.textBox5.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.textBox5.Location = new System.Drawing.Point(144, 80);
			this.textBox5.MaxLength = 2;
			this.textBox5.Name = "textBox5";
			this.textBox5.Size = new System.Drawing.Size(56, 26);
			this.textBox5.TabIndex = 6;
			this.textBox5.Text = "";
			// 
			// button5
			// 
			this.button5.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.button5.Location = new System.Drawing.Point(168, 120);
			this.button5.Name = "button5";
			this.button5.TabIndex = 8;
			this.button5.Text = "下机";
			this.button5.Click += new System.EventHandler(this.button5_Click_2);
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(96, 80);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(32, 24);
			this.label1.TabIndex = 6;
			this.label1.Text = "点";
			this.label1.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
			// 
			// textBox3
			// 
			this.textBox3.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.textBox3.Location = new System.Drawing.Point(24, 80);
			this.textBox3.MaxLength = 2;
			this.textBox3.Name = "textBox3";
			this.textBox3.Size = new System.Drawing.Size(64, 26);
			this.textBox3.TabIndex = 5;
			this.textBox3.Text = "";
			// 
			// dateTimePicker1
			// 
			this.dateTimePicker1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.dateTimePicker1.Location = new System.Drawing.Point(24, 32);
			this.dateTimePicker1.Name = "dateTimePicker1";
			this.dateTimePicker1.Size = new System.Drawing.Size(224, 26);
			this.dateTimePicker1.TabIndex = 4;
			// 
			// sqlDataAdapter2
			// 
			this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand2;
			this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
			this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
			this.sqlDataAdapter2.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("上机区域", "上机区域"),
																																																			  new System.Data.Common.DataColumnMapping("值班教师", "值班教师")})});
			this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2;
			// 
			// sqlDeleteCommand2
			// 
			this.sqlDeleteCommand2.CommandText = @"DELETE FROM 流水帐表 WHERE (流水号 = @Original_流水号) AND (上机区域 = @Original_上机区域 OR @Original_上机区域 IS NULL AND 上机区域 IS NULL) AND (上机时间 = @Original_上机时间 OR @Original_上机时间 IS NULL AND 上机时间 IS NULL) AND (上机状态 = @Original_上机状态 OR @Original_上机状态 IS NULL AND 上机状态 IS NULL) AND (下机时间 = @Original_下机时间 OR @Original_下机时间 IS NULL AND 下机时间 IS NULL) AND (值班教师 = @Original_值班教师 OR @Original_值班教师 IS NULL AND 值班教师 IS NULL) AND (条形码 = @Original_条形码 OR @Original_条形码 IS NULL AND 条形码 IS NULL) AND (花费 = @Original_花费 OR @Original_花费 IS NULL AND 花费 IS NULL)";
			this.sqlDeleteCommand2.Connection = this.sqlConnection1;