?? staffquery.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using HrSalary.util;
using HrSalary.salary;
namespace HrSalary.employee
{
/// <summary>
/// EmployeeQuery 的摘要說明。
/// </summary>
public class StaffQuery : System.Windows.Forms.Form
{
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox totalNumber;
private System.Windows.Forms.TextBox empid;
private System.Windows.Forms.TextBox empname;
/// <summary>
/// 必需的設計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn3;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn4;
private OleDbConnection dbCon = null;
private OleDbDataAdapter dbAdapter = null;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.CheckBox idCheck;
private System.Windows.Forms.CheckBox nameCheck;
private System.Windows.Forms.ContextMenu contextMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem menuItem2;
private System.Windows.Forms.MenuItem menuItem3;
private System.Windows.Forms.MenuItem menuItem4;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.TextBox bankcard;
private System.Windows.Forms.CheckBox bankcardcheck;
private System.Windows.Forms.TextBox email;
private System.Windows.Forms.CheckBox emailcheck;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.Button Excel_button8;
private DataSet ds = null;
public StaffQuery()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調用后添加任何構造函數代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設計器生成的代碼
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.bankcard = new System.Windows.Forms.TextBox();
this.bankcardcheck = new System.Windows.Forms.CheckBox();
this.email = new System.Windows.Forms.TextBox();
this.emailcheck = new System.Windows.Forms.CheckBox();
this.button3 = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
this.empname = new System.Windows.Forms.TextBox();
this.nameCheck = new System.Windows.Forms.CheckBox();
this.empid = new System.Windows.Forms.TextBox();
this.idCheck = new System.Windows.Forms.CheckBox();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.contextMenu1 = new System.Windows.Forms.ContextMenu();
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.menuItem2 = new System.Windows.Forms.MenuItem();
this.menuItem4 = new System.Windows.Forms.MenuItem();
this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
this.menuItem3 = new System.Windows.Forms.MenuItem();
this.label1 = new System.Windows.Forms.Label();
this.totalNumber = new System.Windows.Forms.TextBox();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.Excel_button8 = new System.Windows.Forms.Button();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.BackColor = System.Drawing.Color.AliceBlue;
this.groupBox1.Controls.Add(this.bankcard);
this.groupBox1.Controls.Add(this.bankcardcheck);
this.groupBox1.Controls.Add(this.email);
this.groupBox1.Controls.Add(this.emailcheck);
this.groupBox1.Controls.Add(this.button3);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Controls.Add(this.empname);
this.groupBox1.Controls.Add(this.nameCheck);
this.groupBox1.Controls.Add(this.empid);
this.groupBox1.Controls.Add(this.idCheck);
this.groupBox1.Location = new System.Drawing.Point(8, 0);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(688, 80);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "員工信息查詢";
//
// bankcard
//
this.bankcard.Location = new System.Drawing.Point(368, 48);
this.bankcard.Name = "bankcard";
this.bankcard.Size = new System.Drawing.Size(136, 21);
this.bankcard.TabIndex = 12;
this.bankcard.Text = "";
//
// bankcardcheck
//
this.bankcardcheck.Location = new System.Drawing.Point(296, 48);
this.bankcardcheck.Name = "bankcardcheck";
this.bankcardcheck.Size = new System.Drawing.Size(80, 24);
this.bankcardcheck.TabIndex = 11;
this.bankcardcheck.Text = "銀行卡號";
//
// email
//
this.email.Location = new System.Drawing.Point(112, 48);
this.email.Name = "email";
this.email.Size = new System.Drawing.Size(136, 21);
this.email.TabIndex = 10;
this.email.Text = "";
//
// emailcheck
//
this.emailcheck.Location = new System.Drawing.Point(48, 48);
this.emailcheck.Name = "emailcheck";
this.emailcheck.Size = new System.Drawing.Size(80, 24);
this.emailcheck.TabIndex = 9;
this.emailcheck.Text = "email";
//
// button3
//
this.button3.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.button3.Location = new System.Drawing.Point(544, 16);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(104, 24);
this.button3.TabIndex = 8;
this.button3.Text = "查詢已刪除信息";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// button1
//
this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.button1.Location = new System.Drawing.Point(544, 48);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(104, 24);
this.button1.TabIndex = 7;
this.button1.Text = "查詢員工信息";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// empname
//
this.empname.Location = new System.Drawing.Point(368, 16);
this.empname.Name = "empname";
this.empname.Size = new System.Drawing.Size(136, 21);
this.empname.TabIndex = 4;
this.empname.Text = "";
//
// nameCheck
//
this.nameCheck.Location = new System.Drawing.Point(296, 16);
this.nameCheck.Name = "nameCheck";
this.nameCheck.Size = new System.Drawing.Size(80, 24);
this.nameCheck.TabIndex = 3;
this.nameCheck.Text = "姓名";
//
// empid
//
this.empid.Location = new System.Drawing.Point(112, 16);
this.empid.Name = "empid";
this.empid.Size = new System.Drawing.Size(136, 21);
this.empid.TabIndex = 2;
this.empid.Text = "";
//
// idCheck
//
this.idCheck.Location = new System.Drawing.Point(48, 16);
this.idCheck.Name = "idCheck";
this.idCheck.Size = new System.Drawing.Size(80, 24);
this.idCheck.TabIndex = 1;
this.idCheck.Text = "編號";
//
// dataGrid1
//
this.dataGrid1.BackgroundColor = System.Drawing.SystemColors.ActiveCaptionText;
this.dataGrid1.CaptionVisible = false;
this.dataGrid1.ContextMenu = this.contextMenu1;
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(48, 88);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(608, 280);
this.dataGrid1.TabIndex = 1;
this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
this.dataGridTableStyle1});
this.dataGrid1.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dataGrid1_MouseUp);
//
// contextMenu1
//
this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1,
this.menuItem2,
this.menuItem4});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.Text = "修改選擇員工信息";
this.menuItem1.Click += new System.EventHandler(this.menuItem1_Click);
//
// menuItem2
//
this.menuItem2.Index = 1;
this.menuItem2.Text = "刪除該條信息";
this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
//
// menuItem4
//
this.menuItem4.Index = 2;
this.menuItem4.Text = "恢復該條信息";
this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
//
// dataGridTableStyle1
//
this.dataGridTableStyle1.DataGrid = this.dataGrid1;
this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
this.dataGridTextBoxColumn1,
this.dataGridTextBoxColumn2,
this.dataGridTextBoxColumn3,
this.dataGridTextBoxColumn4});
this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGridTableStyle1.MappingName = "employee";
//
// dataGridTextBoxColumn1
//
this.dataGridTextBoxColumn1.Format = "";
this.dataGridTextBoxColumn1.FormatInfo = null;
this.dataGridTextBoxColumn1.HeaderText = "編號";
this.dataGridTextBoxColumn1.MappingName = "編號";
this.dataGridTextBoxColumn1.Width = 45;
//
// dataGridTextBoxColumn2
//
this.dataGridTextBoxColumn2.Format = "";
this.dataGridTextBoxColumn2.FormatInfo = null;
this.dataGridTextBoxColumn2.HeaderText = "姓名";
this.dataGridTextBoxColumn2.MappingName = "姓名";
this.dataGridTextBoxColumn2.Width = 105;
//
// dataGridTextBoxColumn3
//
this.dataGridTextBoxColumn3.Format = "";
this.dataGridTextBoxColumn3.FormatInfo = null;
this.dataGridTextBoxColumn3.HeaderText = "Email";
this.dataGridTextBoxColumn3.MappingName = "Email";
this.dataGridTextBoxColumn3.Width = 205;
//
// dataGridTextBoxColumn4
//
this.dataGridTextBoxColumn4.Format = "";
this.dataGridTextBoxColumn4.FormatInfo = null;
this.dataGridTextBoxColumn4.HeaderText = "銀行卡號";
this.dataGridTextBoxColumn4.MappingName = "銀行卡號";
this.dataGridTextBoxColumn4.Width = 175;
//
// menuItem3
//
this.menuItem3.Index = -1;
this.menuItem3.Text = "";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(264, 312);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(66, 17);
this.label1.TabIndex = 2;
this.label1.Text = "共有人數：";
//
// totalNumber
//
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -