📄 主界面.cs
字号:
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, 192);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(80, 23);
this.label4.TabIndex = 12;
this.label4.Text = "余额";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// 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(32, 240);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(80, 23);
this.label5.TabIndex = 13;
this.label5.Text = "上机区域";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// textBox6
//
this.textBox6.Enabled = false;
this.textBox6.Location = new System.Drawing.Point(144, 280);
this.textBox6.Name = "textBox6";
this.textBox6.TabIndex = 14;
this.textBox6.Text = "";
//
// label6
//
this.label6.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label6.Location = new System.Drawing.Point(32, 288);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(80, 23);
this.label6.TabIndex = 15;
this.label6.Text = "本次花费";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label7
//
this.label7.Location = new System.Drawing.Point(264, 192);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(32, 23);
this.label7.TabIndex = 16;
this.label7.Text = "元";
//
// label8
//
this.label8.Location = new System.Drawing.Point(264, 240);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(40, 23);
this.label8.TabIndex = 17;
this.label8.Text = "机房 ";
//
// label9
//
this.label9.Location = new System.Drawing.Point(264, 288);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(24, 23);
this.label9.TabIndex = 18;
this.label9.Text = "元";
//
// button5
//
this.button5.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
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(48, -64);
this.button5.Name = "button5";
this.button5.Size = new System.Drawing.Size(75, 46);
this.button5.TabIndex = 19;
this.button5.Text = "统计信息";
this.button5.Click += new System.EventHandler(this.button5_Click);
//
// groupBox1
//
this.groupBox1.Controls.Add(this.button6);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Controls.Add(this.button2);
this.groupBox1.Controls.Add(this.button3);
this.groupBox1.Controls.Add(this.button5);
this.groupBox1.Controls.Add(this.button4);
this.groupBox1.Location = new System.Drawing.Point(568, 456);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(168, 24);
this.groupBox1.TabIndex = 21;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "功能区";
this.groupBox1.Visible = false;
//
// button6
//
this.button6.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
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(48, -16);
this.button6.Name = "button6";
this.button6.Size = new System.Drawing.Size(75, 31);
this.button6.TabIndex = 20;
this.button6.Text = "集体下机";
this.button6.Click += new System.EventHandler(this.button6_Click);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.comboBox1);
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.textBox3);
this.groupBox2.Controls.Add(this.textBox4);
this.groupBox2.Controls.Add(this.label1);
this.groupBox2.Controls.Add(this.label2);
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.textBox6);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.groupBox2.ForeColor = System.Drawing.SystemColors.ControlText;
this.groupBox2.Location = new System.Drawing.Point(24, 96);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(472, 352);
this.groupBox2.TabIndex = 20;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "扫码区";
this.groupBox2.Enter += new System.EventHandler(this.groupBox2_Enter);
//
// comboBox1
//
this.comboBox1.Location = new System.Drawing.Point(144, 240);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(104, 24);
this.comboBox1.TabIndex = 19;
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
//
// label10
//
this.label10.Font = new System.Drawing.Font("宋体", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label10.ForeColor = System.Drawing.Color.Red;
this.label10.Location = new System.Drawing.Point(16, 56);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(744, 24);
this.label10.TabIndex = 22;
this.label10.Text = "管理学院机房计费系统";
this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=XU;packet size=4096;integrated security=SSPI;data source=XU;persis" +
"t security info=False;initial catalog=jifei";
//
// label11
//
this.label11.Font = new System.Drawing.Font("Comic Sans MS", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.label11.Location = new System.Drawing.Point(24, 456);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(744, 24);
this.label11.TabIndex = 23;
this.label11.Text = "Powered by SE Lab Tjpu ";
this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// 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("机器数", "机器数")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 系统表 WHERE (机房 = @Original_机房) AND (定价 = @Original_定价 OR @Original_定价 " +
"IS NULL AND 定价 IS NULL) AND (机器数 = @Original_机器数 OR @Original_机器数 IS NULL AND 机器" +
"数 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection2;
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.Money, 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, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "机器数", System.Data.DataRowVersion.Original, null));
//
// sqlConnection2
//
this.sqlConnection2.ConnectionString = "workstation id=XU;packet size=4096;integrated security=SSPI;data source=XU;persis" +
"t security info=False;initial catalog=jifei";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 系统表(机房, 定价, 机器数) VALUES (@机房, @定价, @机器数); SELECT 机房, 定价, 机器数 FROM 系统表" +
" WHERE (机房 = @机房)";
this.sqlInsertCommand1.Connection = this.sqlConnection2;
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.Money, 8, "定价"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机器数", System.Data.SqlDbType.VarChar, 10, "机器数"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 机房, 定价, 机器数 FROM 系统表 order by 机房 desc";
this.sqlSelectCommand1.Connection = this.sqlConnection2;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 系统表 SET 机房 = @机房, 定价 = @定价, 机器数 = @机器数 WHERE (机房 = @Original_机房) AND (定价 =" +
" @Original_定价 OR @Original_定价 IS NULL AND 定价 IS NULL) AND (机器数 = @Original_机器数 O" +
"R @Original_机器数 IS NULL AND 机器数 IS NULL); SELECT 机房, 定价, 机器数 FROM 系统表 WHERE (机房 " +
"= @机房)";
this.sqlUpdateCommand1.Connection = this.sqlConnection2;
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.Money, 8, "定价"));
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, 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.Money, 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, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "机器数", System.Data.DataRowVersion.Original, null));
//
// statusBarPanel2
//
this.statusBarPanel2.Text = "statusBarPanel2";
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1,
this.menuItem2,
this.menuItem3,
this.menuItem4,
this.menuItem5});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem6,
this.menuItem17,
this.menuItem21,
this.menuItem22,
this.menuItem18,
this.menuItem8});
this.menuItem1.Text = "工具箱";
//
// menuItem6
//
this.menuItem6.Index = 0;
this.menuItem6.Text = "用户切换";
this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
//
// menuItem17
//
this.menuItem17.Index = 1;
this.menuItem17.Text = "集体下机";
this.menuItem17.Click += new System.EventHandler(this.menuItem17_Click);
//
// menuItem21
//
this.menuItem21.Index = 2;
this.menuItem21.Text = "停止轮询";
this.menuItem21.Click += new System.EventHandler(this.menuItem21_Click);
//
// menuItem22
//
this.menuItem22.Index = 3;
this.menuItem22.Text = "启动轮询";
this.menuItem22.Click += new System.EventHandler(this.menuItem22_Click);
//
// menuItem18
//
this.menuItem18.Index = 4;
this.menuItem18.Text = "开/关实时信息";
this.menuItem18.Click += new System.EventHandler(this.menuItem18_Click);
//
// menuItem8
//
this.menuItem8.Index = 5;
this.menuItem8.Text = "退出";
this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
//
// menuItem2
//
this.menuItem2.Index = 1;
this.menuItem2.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem9,
this.menuItem10,
this.menuItem11});
this.menuItem2.Text = "账户管理";
//
// menuItem9
//
this.menuItem9.Index = 0;
this.menuItem9.Text = "新建账户";
this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
//
// menuItem10
//
this.menuItem10.Index = 1;
this.menuItem10.Text = "账户充值";
this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
//
// menuItem11
//
this.menuItem11.Index = 2;
this.menuItem11.Text = "高级功能";
this.menuItem11.Click += new System.EventHandler(this.menuItem11_Click);
//
// menuItem3
//
this.menuItem3.Index = 2;
this.menuItem3.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem12,
this.menuItem13,
this.menuItem16,
this.menuItem25,
this.menuItem24,
this.menuItem7});
this.menuItem3.Text = "系统管理";
//
// menuItem12
//
this.menuItem12.Index = 0;
this.menuItem12.Text = "机房管理";
this.menuItem12.Click += new System.EventHandler(this.menuItem12_Click);
//
// menuItem13
//
this.menuItem13.Index = 1;
this.menuItem13.Text = "收费管理";
this.menuItem13.Click += new System.EventHandler(this.menuItem13_Click);
//
// menuItem16
//
this.menuItem16.Index = 2;
this.menuItem16.Text = "用户管理";
this.menuItem16.Click += new System.EventHandler(this.menuItem16_Click);
//
// menuItem25
//
this.menuItem25.Index = 3;
this.menuItem25.Text = "-";
//
// menuItem24
//
this.menuItem24.Index = 4;
this.menuItem24.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem27,
this.menuItem26});
this.menuItem24.Text = "数据库备份/还原";
//
// menuItem27
//
this.menuItem27.Index = 0;
this.menuItem27.Text = "数据库备份";
this.menuItem27.Click += new System.EventHandler(this.menuItem27_Click);
//
// menuItem26
//
this.menuItem26.Index = 1;
this.menuItem26.Text = "数据库还原";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -