📄 navigationframe.cs
字号:
this.SystemManagerGroup.TabIndex = 3;
this.SystemManagerGroup.TabStop = false;
//
// SystemRevertLabel
//
this.SystemRevertLabel.Enabled = false;
this.SystemRevertLabel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.SystemRevertLabel.Font = new System.Drawing.Font("仿宋_GB2312", 11F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.SystemRevertLabel.ForeColor = System.Drawing.SystemColors.Desktop;
this.SystemRevertLabel.Location = new System.Drawing.Point(216, 152);
this.SystemRevertLabel.Name = "SystemRevertLabel";
this.SystemRevertLabel.Size = new System.Drawing.Size(88, 24);
this.SystemRevertLabel.TabIndex = 5;
this.SystemRevertLabel.Text = "系统还原";
this.SystemRevertLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.SystemRevertLabel.Click += new System.EventHandler(this.SystemRevertLabel_Click);
//
// SystemDesignLabel
//
this.SystemDesignLabel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.SystemDesignLabel.Font = new System.Drawing.Font("仿宋_GB2312", 11F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.SystemDesignLabel.ForeColor = System.Drawing.SystemColors.Desktop;
this.SystemDesignLabel.Location = new System.Drawing.Point(112, 152);
this.SystemDesignLabel.Name = "SystemDesignLabel";
this.SystemDesignLabel.Size = new System.Drawing.Size(88, 24);
this.SystemDesignLabel.TabIndex = 4;
this.SystemDesignLabel.Text = "系统设置";
this.SystemDesignLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.SystemDesignLabel.Click += new System.EventHandler(this.SystemDesignLabel_Click);
//
// SystemBackLabel
//
this.SystemBackLabel.Enabled = false;
this.SystemBackLabel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.SystemBackLabel.Font = new System.Drawing.Font("仿宋_GB2312", 11F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.SystemBackLabel.ForeColor = System.Drawing.SystemColors.Desktop;
this.SystemBackLabel.Location = new System.Drawing.Point(8, 152);
this.SystemBackLabel.Name = "SystemBackLabel";
this.SystemBackLabel.Size = new System.Drawing.Size(88, 24);
this.SystemBackLabel.TabIndex = 3;
this.SystemBackLabel.Text = "系统备份";
this.SystemBackLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.SystemBackLabel.Click += new System.EventHandler(this.SystemBackLabel_Click);
//
// pictureBox6
//
this.pictureBox6.BackColor = System.Drawing.SystemColors.ControlLightLight;
this.pictureBox6.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox6.Image")));
this.pictureBox6.Location = new System.Drawing.Point(8, 72);
this.pictureBox6.Name = "pictureBox6";
this.pictureBox6.Size = new System.Drawing.Size(560, 328);
this.pictureBox6.TabIndex = 6;
this.pictureBox6.TabStop = false;
this.pictureBox6.Click += new System.EventHandler(this.pictureBox6_Click);
//
// label15
//
this.label15.BackColor = System.Drawing.SystemColors.ControlLightLight;
this.label15.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.label15.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label15.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(0)), ((System.Byte)(192)), ((System.Byte)(192)));
this.label15.Location = new System.Drawing.Point(48, 24);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(88, 24);
this.label15.TabIndex = 2;
this.label15.Text = "系统管理";
this.label15.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// pictureBox5
//
this.pictureBox5.BackColor = System.Drawing.SystemColors.ControlLightLight;
this.pictureBox5.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox5.Image")));
this.pictureBox5.Location = new System.Drawing.Point(3, 16);
this.pictureBox5.Name = "pictureBox5";
this.pictureBox5.Size = new System.Drawing.Size(565, 56);
this.pictureBox5.TabIndex = 0;
this.pictureBox5.TabStop = false;
//
// userManagerGroup
//
this.userManagerGroup.BackColor = System.Drawing.SystemColors.ControlLightLight;
this.userManagerGroup.Controls.Add(this.label21);
this.userManagerGroup.Controls.Add(this.UserPopedomLabel);
this.userManagerGroup.Controls.Add(this.userManagerLabel);
this.userManagerGroup.Controls.Add(this.userPopedomImage);
this.userManagerGroup.Controls.Add(this.userManagerImage);
this.userManagerGroup.Controls.Add(this.pictureBox7);
this.userManagerGroup.Location = new System.Drawing.Point(136, 56);
this.userManagerGroup.Name = "userManagerGroup";
this.userManagerGroup.Size = new System.Drawing.Size(576, 408);
this.userManagerGroup.TabIndex = 2;
this.userManagerGroup.TabStop = false;
this.userManagerGroup.Enter += new System.EventHandler(this.userManagerGroup_Enter);
//
// label21
//
this.label21.BackColor = System.Drawing.SystemColors.ControlLightLight;
this.label21.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label21.ForeColor = System.Drawing.SystemColors.Desktop;
this.label21.Location = new System.Drawing.Point(48, 24);
this.label21.Name = "label21";
this.label21.TabIndex = 5;
this.label21.Text = "用户管理";
this.label21.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// UserPopedomLabel
//
this.UserPopedomLabel.Enabled = false;
this.UserPopedomLabel.ForeColor = System.Drawing.SystemColors.Desktop;
this.UserPopedomLabel.Location = new System.Drawing.Point(112, 160);
this.UserPopedomLabel.Name = "UserPopedomLabel";
this.UserPopedomLabel.TabIndex = 4;
this.UserPopedomLabel.Text = "权限管理";
this.UserPopedomLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.UserPopedomLabel.Click += new System.EventHandler(this.UserPopedomLabel_Click);
//
// userManagerLabel
//
this.userManagerLabel.Enabled = false;
this.userManagerLabel.ForeColor = System.Drawing.SystemColors.Desktop;
this.userManagerLabel.Location = new System.Drawing.Point(0, 160);
this.userManagerLabel.Name = "userManagerLabel";
this.userManagerLabel.TabIndex = 3;
this.userManagerLabel.Text = "用户管理";
this.userManagerLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.userManagerLabel.Click += new System.EventHandler(this.userManagerLabel_Click);
//
// userPopedomImage
//
this.userPopedomImage.Image = ((System.Drawing.Image)(resources.GetObject("userPopedomImage.Image")));
this.userPopedomImage.Location = new System.Drawing.Point(120, 72);
this.userPopedomImage.Name = "userPopedomImage";
this.userPopedomImage.Size = new System.Drawing.Size(456, 344);
this.userPopedomImage.TabIndex = 2;
this.userPopedomImage.TabStop = false;
this.userPopedomImage.Click += new System.EventHandler(this.userPopedomImage_Click);
//
// userManagerImage
//
this.userManagerImage.Image = ((System.Drawing.Image)(resources.GetObject("userManagerImage.Image")));
this.userManagerImage.Location = new System.Drawing.Point(8, 72);
this.userManagerImage.Name = "userManagerImage";
this.userManagerImage.Size = new System.Drawing.Size(112, 344);
this.userManagerImage.TabIndex = 1;
this.userManagerImage.TabStop = false;
this.userManagerImage.Click += new System.EventHandler(this.userManagerImage_Click);
//
// pictureBox7
//
this.pictureBox7.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox7.Image")));
this.pictureBox7.Location = new System.Drawing.Point(8, 16);
this.pictureBox7.Name = "pictureBox7";
this.pictureBox7.Size = new System.Drawing.Size(576, 56);
this.pictureBox7.TabIndex = 0;
this.pictureBox7.TabStop = false;
//
// SystemPictureImage
//
this.SystemPictureImage.Location = new System.Drawing.Point(0, 0);
this.SystemPictureImage.Name = "SystemPictureImage";
this.SystemPictureImage.TabIndex = 0;
this.SystemPictureImage.TabStop = false;
//
// lowImage
//
this.lowImage.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.lowImage.BackColor = System.Drawing.SystemColors.ControlLightLight;
this.lowImage.Image = ((System.Drawing.Image)(resources.GetObject("lowImage.Image")));
this.lowImage.Location = new System.Drawing.Point(0, 464);
this.lowImage.Name = "lowImage";
this.lowImage.Size = new System.Drawing.Size(712, 40);
this.lowImage.TabIndex = 2;
this.lowImage.TabStop = false;
//
// label11
//
this.label11.BackColor = System.Drawing.SystemColors.HighlightText;
this.label11.Font = new System.Drawing.Font("Microsoft Sans Serif", 11F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label11.ForeColor = System.Drawing.SystemColors.Desktop;
this.label11.Location = new System.Drawing.Point(168, 472);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(256, 16);
this.label11.TabIndex = 3;
this.label11.Text = "@版权所有(ALL Right Resevered)";
this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// startLoadQuanXian
//
this.startLoadQuanXian.Interval = 1000;
this.startLoadQuanXian.Tick += new System.EventHandler(this.startLoadQuanXian_Tick);
//
// modifyQuanXian
//
this.modifyQuanXian.Interval = 1000;
this.modifyQuanXian.Tick += new System.EventHandler(this.modifyQuanXian_Tick);
//
// contextMenu
//
this.contextMenu.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuClose});
//
// menuClose
//
this.menuClose.Index = 0;
this.menuClose.Shortcut = System.Windows.Forms.Shortcut.CtrlE;
this.menuClose.Text = "关闭窗体(&C)";
this.menuClose.Click += new System.EventHandler(this.menuClose_Click);
//
// sqlDataAdapter
//
this.sqlDataAdapter.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "UserOperatorTable_History", 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.sqlDataAdapter.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlConnection
//
this.sqlConnection.ConnectionString = "workstation id=localhost;integrated security=SSPI;database=SystemODBC;";
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 编号, 日期, 时间, 操作员, 状态 FROM UserOperatorTable_History";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO UserOperatorTable_History(日期, 时间, 操作员, 状态) VALUES (@日期, @时间, @操作员, @状" +
"态); SELECT 编号, 日期, 时间, 操作员, 状态 FROM UserOperatorTable_History WHERE (编号 = @@IDEN" +
"TITY)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.DateTime, 8, "日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@时间", System.Data.SqlDbType.VarChar, 50, "时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 50, "操作员"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 50, "状态"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE UserOperatorTable_History SET 日期 = @日期, 时间 = @时间, 操作员 = @操作员, 状态 = @状态 WHERE (编号 = @Original_编号) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS NULL) AND (日期 = @Original_日期) AND (时间 = @Original_时间 OR @Original_时间 IS NULL AND 时间 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL); SELECT 编号, 日期, 时间, 操作员, 状态 FROM UserOperatorTable_History WHERE (编号 = @编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.DateTime, 8, "日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@时间", System.Data.SqlDbType.VarChar, 50, "时间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 50, "操作员"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 50, "状态"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.Int, 4, 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, 50, 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.DateTime, 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, 50, 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, 50, 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("@编号", System.Data.SqlDbType.Int, 4, "编号"));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM UserOperatorTable_History WHERE (编号 = @Original_编号) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS NULL) AND (日期 = @Original_日期) AND (时间 = @Original_时间 OR @Original_时间 IS NULL AND 时间 IS NULL) 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.Int, 4, 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, 50, 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.DateTime, 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, 50, 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, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;integrated security=SSPI;database=SystemODBC;";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -