?? 主界面.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 + -