账户管理.cs

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

			this.textBox2.Location = new System.Drawing.Point(136, 72);
			this.textBox2.Name = "textBox2";
			this.textBox2.Size = new System.Drawing.Size(112, 26);
			this.textBox2.TabIndex = 3;
			this.textBox2.Text = "";
			// 
			// textBox1
			// 
			this.textBox1.Enabled = false;
			this.textBox1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.textBox1.Location = new System.Drawing.Point(136, 24);
			this.textBox1.Name = "textBox1";
			this.textBox1.Size = new System.Drawing.Size(296, 26);
			this.textBox1.TabIndex = 1;
			this.textBox1.Text = "";
			this.textBox1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox1_KeyPress);
			// 
			// 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, 336);
			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);
			// 
			// tabPage2
			// 
			this.tabPage2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.tabPage2.Controls.Add(this.button5);
			this.tabPage2.Controls.Add(this.textBox3);
			this.tabPage2.Controls.Add(this.label1);
			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.Visible = false;
			// 
			// button5
			// 
			this.button5.Location = new System.Drawing.Point(416, 24);
			this.button5.Name = "button5";
			this.button5.TabIndex = 6;
			this.button5.Text = "查询";
			this.button5.Click += new System.EventHandler(this.button5_Click);
			// 
			// 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(112, 24);
			this.textBox3.Name = "textBox3";
			this.textBox3.Size = new System.Drawing.Size(272, 26);
			this.textBox3.TabIndex = 5;
			this.textBox3.Text = "";
			this.textBox3.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox3_KeyPress);
			// 
			// 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(32, 24);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(56, 23);
			this.label1.TabIndex = 4;
			this.label1.Text = "条形码";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// 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, 64);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.Size = new System.Drawing.Size(600, 256);
			this.dataGrid2.TabIndex = 0;
			this.dataGrid2.Tag = "";
			this.dataGrid2.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dataGrid2_Navigate);
			// 
			// tabPage3
			// 
			this.tabPage3.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.tabPage3.Controls.Add(this.dateTimePicker1);
			this.tabPage3.Controls.Add(this.label2);
			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 = "收费明细";
			// 
			// dateTimePicker1
			// 
			this.dateTimePicker1.Location = new System.Drawing.Point(152, 24);
			this.dateTimePicker1.Name = "dateTimePicker1";
			this.dateTimePicker1.TabIndex = 2;
			this.dateTimePicker1.ValueChanged += new System.EventHandler(this.dateTimePicker1_ValueChanged);
			// 
			// 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.MiddleRight;
			this.label2.Location = new System.Drawing.Point(32, 24);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(96, 23);
			this.label2.TabIndex = 1;
			this.label2.Text = "请选择日期:";
			// 
			// dataGrid3
			// 
			this.dataGrid3.CaptionText = "收费明细";
			this.dataGrid3.DataMember = "";
			this.dataGrid3.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid3.Location = new System.Drawing.Point(24, 64);
			this.dataGrid3.Name = "dataGrid3";
			this.dataGrid3.Size = new System.Drawing.Size(600, 280);
			this.dataGrid3.TabIndex = 0;
			// 
			// tabPage4
			// 
			this.tabPage4.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.tabPage4.Controls.Add(this.richTextBox1);
			this.tabPage4.Controls.Add(this.label6);
			this.tabPage4.Controls.Add(this.label5);
			this.tabPage4.Controls.Add(this.button6);
			this.tabPage4.Controls.Add(this.textBox5);
			this.tabPage4.Controls.Add(this.label4);
			this.tabPage4.Controls.Add(this.textBox4);
			this.tabPage4.Controls.Add(this.label3);
			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 = "账户转移";
			// 
			// richTextBox1
			// 
			this.richTextBox1.Enabled = false;
			this.richTextBox1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.richTextBox1.Location = new System.Drawing.Point(160, 120);
			this.richTextBox1.Name = "richTextBox1";
			this.richTextBox1.Size = new System.Drawing.Size(280, 112);
			this.richTextBox1.TabIndex = 9;
			this.richTextBox1.Text = "";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(464, 72);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(152, 23);
			this.label6.TabIndex = 8;
			this.label6.Text = "(输入结束后敲回车确认)";
			// 
			// label5
			// 
			this.label5.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label5.Location = new System.Drawing.Point(48, 112);
			this.label5.Name = "label5";
			this.label5.TabIndex = 7;
			this.label5.Text = "账户信息";
			this.label5.TextAlign = System.Drawing.ContentAlignment.BottomRight;
			// 
			// button6
			// 
			this.button6.Enabled = false;
			this.button6.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.button6.Location = new System.Drawing.Point(472, 264);
			this.button6.Name = "button6";
			this.button6.TabIndex = 5;
			this.button6.Text = "确认修改";
			this.button6.Click += new System.EventHandler(this.button6_Click);
			// 
			// 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(160, 256);
			this.textBox5.Name = "textBox5";
			this.textBox5.Size = new System.Drawing.Size(280, 26);
			this.textBox5.TabIndex = 4;
			this.textBox5.Text = "";
			this.textBox5.Enter += new System.EventHandler(this.textBox5_Enter);
			// 
			// 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(32, 256);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(120, 23);
			this.label4.TabIndex = 2;
			this.label4.Text = "新账户标识";
			this.label4.TextAlign = System.Drawing.ContentAlignment.BottomRight;
			// 
			// textBox4
			// 
			this.textBox4.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.textBox4.Location = new System.Drawing.Point(160, 64);
			this.textBox4.Name = "textBox4";
			this.textBox4.Size = new System.Drawing.Size(280, 26);
			this.textBox4.TabIndex = 0;
			this.textBox4.Text = "";
			this.textBox4.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox4_KeyPress);
			// 
			// label3
			// 
			this.label3.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label3.Location = new System.Drawing.Point(32, 64);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(120, 23);
			this.label3.TabIndex = 1;
			this.label3.Text = "原始账户标识";
			this.label3.TextAlign = System.Drawing.ContentAlignment.BottomRight;
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=XU;packet size=4096;integrated security=SSPI;data source=XU;persis" +
				"t security info=False;initial catalog=jifei";