📄 机房管理.cs
字号:
this.groupBox4.Size = new System.Drawing.Size(200, 40);
this.groupBox4.TabIndex = 16;
this.groupBox4.TabStop = false;
this.groupBox4.Text = "groupBox4";
//
// groupBox1
//
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Controls.Add(this.label11);
this.groupBox1.Controls.Add(this.label10);
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.textBox6);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.textBox4);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.textBox2);
this.groupBox1.Controls.Add(this.textBox1);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.groupBox1.Location = new System.Drawing.Point(32, 24);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(632, 144);
this.groupBox1.TabIndex = 14;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "充值优惠政策";
//
// button1
//
this.button1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button1.Location = new System.Drawing.Point(536, 112);
this.button1.Name = "button1";
this.button1.TabIndex = 12;
this.button1.Text = "提交修改";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// label11
//
this.label11.Location = new System.Drawing.Point(528, 40);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(40, 23);
this.label11.TabIndex = 11;
this.label11.Text = "%";
//
// label10
//
this.label10.Location = new System.Drawing.Point(528, 88);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(40, 23);
this.label10.TabIndex = 10;
this.label10.Text = "%";
//
// label9
//
this.label9.Location = new System.Drawing.Point(248, 80);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(40, 23);
this.label9.TabIndex = 9;
this.label9.Text = "元";
//
// label8
//
this.label8.Location = new System.Drawing.Point(248, 40);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(40, 23);
this.label8.TabIndex = 8;
this.label8.Text = "元";
//
// textBox6
//
this.textBox6.Location = new System.Drawing.Point(416, 80);
this.textBox6.MaxLength = 4;
this.textBox6.Name = "textBox6";
this.textBox6.TabIndex = 7;
this.textBox6.Text = "textBox6";
//
// label7
//
this.label7.Location = new System.Drawing.Point(312, 80);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(80, 23);
this.label7.TabIndex = 6;
this.label7.Text = "优惠比例";
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(416, 32);
this.textBox4.MaxLength = 4;
this.textBox4.Name = "textBox4";
this.textBox4.TabIndex = 5;
this.textBox4.Text = "textBox4";
//
// label6
//
this.label6.Location = new System.Drawing.Point(312, 32);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(80, 23);
this.label6.TabIndex = 4;
this.label6.Text = "优惠比例";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(128, 80);
this.textBox2.MaxLength = 3;
this.textBox2.Name = "textBox2";
this.textBox2.TabIndex = 3;
this.textBox2.Text = "textBox2";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(128, 32);
this.textBox1.MaxLength = 3;
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 2;
this.textBox1.Text = "textBox1";
//
// label5
//
this.label5.Location = new System.Drawing.Point(32, 32);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 1;
this.label5.Text = "优惠限1";
//
// label3
//
this.label3.Location = new System.Drawing.Point(32, 80);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 23);
this.label3.TabIndex = 0;
this.label3.Text = "优惠限2";
//
// 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("定价", "定价")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 系统表 WHERE (机房 = @Original_机房) AND (定价 = @Original_定价 OR @Original_定价 " +
"IS NULL AND 定价 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
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));
//
// sqlConnection1
//
this.sqlConnection1.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.sqlConnection1;
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, "定价"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 机房, 定价 FROM 系统表";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 系统表 SET 机房 = @机房, 定价 = @定价 WHERE (机房 = @Original_机房) AND (定价 = @Original_定" +
"价 OR @Original_定价 IS NULL AND 定价 IS NULL); SELECT 机房, 定价 FROM 系统表 WHERE (机房 = @机" +
"房)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
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("@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));
//
// 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("机器数", "机器数")})});
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)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.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.sqlDeleteCommand2.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.sqlDeleteCommand2.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));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 系统表(机房, 定价, 机器数) VALUES (@机房, @定价, @机器数); SELECT 机房, 定价, 机器数 FROM 系统表" +
" WHERE (机房 = @机房)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机房", System.Data.SqlDbType.VarChar, 10, "机房"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@定价", System.Data.SqlDbType.Money, 8, "定价"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机器数", System.Data.SqlDbType.VarChar, 10, "机器数"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 机房, 定价, 机器数 FROM 系统表";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.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.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机房", System.Data.SqlDbType.VarChar, 10, "机房"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@定价", System.Data.SqlDbType.Money, 8, "定价"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机器数", System.Data.SqlDbType.VarChar, 10, "机器数"));
this.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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));
//
// button2
//
this.button2.Location = new System.Drawing.Point(184, 16);
this.button2.Name = "button2";
this.button2.TabIndex = 15;
this.button2.Text = "系统归零";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// groupBox5
//
this.groupBox5.Controls.Add(this.label12);
this.groupBox5.Controls.Add(this.button2);
this.groupBox5.Location = new System.Drawing.Point(384, 352);
this.groupBox5.Name = "groupBox5";
this.groupBox5.Size = new System.Drawing.Size(280, 48);
this.groupBox5.TabIndex = 16;
this.groupBox5.TabStop = false;
this.groupBox5.Text = "系统重设";
//
// label12
//
this.label12.ForeColor = System.Drawing.SystemColors.ControlText;
this.label12.Location = new System.Drawing.Point(16, 16);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(144, 23);
this.label12.TabIndex = 16;
this.label12.Text = "清除历史上机、收费记录";
this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// sqlConnection2
//
this.sqlConnection2.ConnectionString = "workstation id=XU;packet size=4096;integrated security=SSPI;data source=XU;persis" +
"t security info=False;initial catalog=jifei";
//
// 机房管理
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(692, 416);
this.Controls.Add(this.groupBox5);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox2);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;
this.MaximizeBox = false;
this.Name = "机房管理";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "机房管理";
this.Load += new System.EventHandler(this.机房管理_Load);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -