searchuserpeodomframe.cs
来自「独立完成考勤管理软件加打卡系统(C#) 是打卡加管理系统软件 」· CS 代码 · 共 689 行 · 第 1/3 页
CS
689 行
this.btnCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnCancel.Font = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.btnCancel.ForeColor = System.Drawing.Color.White;
this.btnCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.btnCancel.ImageIndex = 1;
this.btnCancel.ImageList = this.image;
this.btnCancel.Location = new System.Drawing.Point(304, 48);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(80, 24);
this.btnCancel.TabIndex = 5;
this.btnCancel.Text = "存储(&S)";
this.btnCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
this.btnCancel.MouseEnter += new System.EventHandler(this.btnCancel_MouseEnter);
this.btnCancel.MouseLeave += new System.EventHandler(this.btnCancel_MouseLeave);
//
// label1
//
this.label1.BackColor = System.Drawing.Color.Teal;
this.label1.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.label1.Location = new System.Drawing.Point(0, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(416, 64);
this.label1.TabIndex = 6;
//
// label2
//
this.label2.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.label2.Location = new System.Drawing.Point(0, 376);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(416, 40);
this.label2.TabIndex = 7;
this.label2.Text = "label2";
//
// currentUser
//
this.currentUser.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.currentUser.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.currentUser.Font = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.currentUser.ForeColor = System.Drawing.Color.White;
this.currentUser.Location = new System.Drawing.Point(40, 384);
this.currentUser.Name = "currentUser";
this.currentUser.Size = new System.Drawing.Size(152, 23);
this.currentUser.TabIndex = 8;
this.currentUser.Text = "当前用户:";
this.currentUser.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// currentPeodom
//
this.currentPeodom.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.currentPeodom.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.currentPeodom.Font = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.currentPeodom.ForeColor = System.Drawing.Color.White;
this.currentPeodom.Location = new System.Drawing.Point(216, 384);
this.currentPeodom.Name = "currentPeodom";
this.currentPeodom.Size = new System.Drawing.Size(160, 23);
this.currentPeodom.TabIndex = 9;
this.currentPeodom.Text = "操作权限:";
this.currentPeodom.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label3
//
this.label3.ForeColor = System.Drawing.Color.Blue;
this.label3.Location = new System.Drawing.Point(152, 136);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(80, 23);
this.label3.TabIndex = 10;
this.label3.Text = "权限编号:";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// textPeodomID
//
this.textPeodomID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.textPeodomID.Cursor = System.Windows.Forms.Cursors.Hand;
this.textPeodomID.Enabled = false;
this.textPeodomID.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.textPeodomID.Location = new System.Drawing.Point(248, 136);
this.textPeodomID.Name = "textPeodomID";
this.textPeodomID.Size = new System.Drawing.Size(128, 21);
this.textPeodomID.TabIndex = 11;
this.textPeodomID.Text = "";
this.textPeodomID.MouseEnter += new System.EventHandler(this.textPeodomID_MouseEnter);
this.textPeodomID.MouseLeave += new System.EventHandler(this.textPeodomID_MouseLeave);
//
// textPeodomName
//
this.textPeodomName.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.textPeodomName.Cursor = System.Windows.Forms.Cursors.Hand;
this.textPeodomName.Enabled = false;
this.textPeodomName.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.textPeodomName.Location = new System.Drawing.Point(248, 184);
this.textPeodomName.Name = "textPeodomName";
this.textPeodomName.Size = new System.Drawing.Size(128, 21);
this.textPeodomName.TabIndex = 13;
this.textPeodomName.Text = "";
this.textPeodomName.MouseEnter += new System.EventHandler(this.textPeodomID_MouseEnter);
this.textPeodomName.MouseLeave += new System.EventHandler(this.textPeodomID_MouseLeave);
//
// label4
//
this.label4.ForeColor = System.Drawing.Color.Blue;
this.label4.Location = new System.Drawing.Point(152, 184);
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.MiddleCenter;
//
// textPeodomStatus
//
this.textPeodomStatus.BackColor = System.Drawing.SystemColors.HighlightText;
this.textPeodomStatus.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.textPeodomStatus.Cursor = System.Windows.Forms.Cursors.Hand;
this.textPeodomStatus.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
this.textPeodomStatus.Location = new System.Drawing.Point(248, 232);
this.textPeodomStatus.Name = "textPeodomStatus";
this.textPeodomStatus.ReadOnly = true;
this.textPeodomStatus.Size = new System.Drawing.Size(128, 21);
this.textPeodomStatus.TabIndex = 15;
this.textPeodomStatus.Text = "";
this.textPeodomStatus.MouseEnter += new System.EventHandler(this.textPeodomID_MouseEnter);
this.textPeodomStatus.MouseLeave += new System.EventHandler(this.textPeodomID_MouseLeave);
//
// label5
//
this.label5.ForeColor = System.Drawing.Color.Blue;
this.label5.Location = new System.Drawing.Point(152, 232);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(80, 23);
this.label5.TabIndex = 14;
this.label5.Text = "权限状态:";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// TimeLabel
//
this.TimeLabel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.TimeLabel.Font = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.TimeLabel.ForeColor = System.Drawing.Color.Blue;
this.TimeLabel.Location = new System.Drawing.Point(160, 288);
this.TimeLabel.Name = "TimeLabel";
this.TimeLabel.Size = new System.Drawing.Size(192, 24);
this.TimeLabel.TabIndex = 16;
this.TimeLabel.Text = "当前时间:";
this.TimeLabel.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// dateLabel
//
this.dateLabel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.dateLabel.Font = new System.Drawing.Font("宋体", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.dateLabel.ForeColor = System.Drawing.Color.Blue;
this.dateLabel.Location = new System.Drawing.Point(160, 336);
this.dateLabel.Name = "dateLabel";
this.dateLabel.Size = new System.Drawing.Size(192, 24);
this.dateLabel.TabIndex = 17;
this.dateLabel.Text = "当前日期:";
this.dateLabel.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// 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", "System_PopedomTable", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("编号", "编号"),
new System.Data.Common.DataColumnMapping("权限名称", "权限名称")})});
this.sqlDataAdapter.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM System_PopedomTable WHERE (编号 = @Original_编号) AND (权限名称 = @Original_权" +
"限名称 OR @Original_权限名称 IS NULL AND 权限名称 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection;
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));
//
// sqlConnection
//
this.sqlConnection.ConnectionString = "workstation id=localhost;integrated security=SSPI;database=SystemODBC";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO System_PopedomTable(权限名称) VALUES (@权限名称); SELECT 编号, 权限名称 FROM System" +
"_PopedomTable WHERE (编号 = @@IDENTITY)";
this.sqlInsertCommand1.Connection = this.sqlConnection;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限名称", System.Data.SqlDbType.VarChar, 50, "权限名称"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 编号, 权限名称 FROM System_PopedomTable";
this.sqlSelectCommand1.Connection = this.sqlConnection;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE System_PopedomTable SET 权限名称 = @权限名称 WHERE (编号 = @Original_编号) AND (权限名称 =" +
" @Original_权限名称 OR @Original_权限名称 IS NULL AND 权限名称 IS NULL); SELECT 编号, 权限名称 FRO" +
"M System_PopedomTable WHERE (编号 = @编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection;
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("@编号", System.Data.SqlDbType.Int, 4, "编号"));
//
// system_PopedomSet
//
this.system_PopedomSet.DataSetName = "System_PopedomSet";
this.system_PopedomSet.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// currentTime
//
this.currentTime.Enabled = true;
this.currentTime.Interval = 1000;
this.currentTime.Tick += new System.EventHandler(this.currentTime_Tick);
//
// searchUserPeodomFrame
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.ClientSize = new System.Drawing.Size(410, 415);
this.Controls.Add(this.dateLabel);
this.Controls.Add(this.TimeLabel);
this.Controls.Add(this.textPeodomStatus);
this.Controls.Add(this.textPeodomName);
this.Controls.Add(this.textPeodomID);
this.Controls.Add(this.label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.currentPeodom);
this.Controls.Add(this.currentUser);
this.Controls.Add(this.label2);
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?