📄 form1.cs
字号:
this.MenuItem4.Text = "帮助(&H)";
//
// MenuItem8
//
this.MenuItem8.Index = 0;
this.MenuItem8.Text = "关于";
this.MenuItem8.Click += new System.EventHandler(this.MenuItem8_Click);
//
// MenuItem9
//
this.MenuItem9.Index = 1;
this.MenuItem9.Text = "帮助";
this.MenuItem9.Click += new System.EventHandler(this.MenuItem9_Click);
//
// menuItem5
//
this.menuItem5.Index = 3;
this.menuItem5.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuEdit,
this.menuAdd,
this.menuDel});
this.menuItem5.Text = "编辑(&E)";
//
// menuEdit
//
this.menuEdit.Index = 0;
this.menuEdit.Text = "更新";
this.menuEdit.Click += new System.EventHandler(this.menuEdit_Click);
//
// menuAdd
//
this.menuAdd.Index = 1;
this.menuAdd.Text = "添加";
this.menuAdd.Click += new System.EventHandler(this.menuAdd_Click);
//
// menuDel
//
this.menuDel.Index = 2;
this.menuDel.Text = "删除";
this.menuDel.Click += new System.EventHandler(this.menuDel_Click);
//
// menuItem6
//
this.menuItem6.Index = 4;
this.menuItem6.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.Mnotepad});
this.menuItem6.Text = "工具(&T)";
//
// Mnotepad
//
this.Mnotepad.Index = 0;
this.Mnotepad.Text = "记事本";
this.Mnotepad.Click += new System.EventHandler(this.Mnotepad_Click);
//
// BtLast
//
this.BtLast.BackColor = System.Drawing.Color.Plum;
this.BtLast.Location = new System.Drawing.Point(210, 70);
this.BtLast.Name = "BtLast";
this.BtLast.Size = new System.Drawing.Size(70, 21);
this.BtLast.TabIndex = 3;
this.BtLast.Text = "最后一条&L";
this.BtLast.TextAlign = System.Drawing.ContentAlignment.TopCenter;
this.BtLast.Click += new System.EventHandler(this.BtLast_Click);
//
// BtFirst
//
this.BtFirst.BackColor = System.Drawing.Color.Plum;
this.BtFirst.Location = new System.Drawing.Point(210, 30);
this.BtFirst.Name = "BtFirst";
this.BtFirst.Size = new System.Drawing.Size(70, 21);
this.BtFirst.TabIndex = 2;
this.BtFirst.Text = "第一条&F";
this.BtFirst.TextAlign = System.Drawing.ContentAlignment.TopCenter;
this.BtFirst.Click += new System.EventHandler(this.BtFirst_Click);
//
// BtNext
//
this.BtNext.BackColor = System.Drawing.Color.Plum;
this.BtNext.Location = new System.Drawing.Point(210, 150);
this.BtNext.Name = "BtNext";
this.BtNext.Size = new System.Drawing.Size(70, 21);
this.BtNext.TabIndex = 1;
this.BtNext.Text = "下一条&N";
this.BtNext.TextAlign = System.Drawing.ContentAlignment.TopCenter;
this.BtNext.Click += new System.EventHandler(this.BtNext_Click);
//
// BtPre
//
this.BtPre.BackColor = System.Drawing.Color.Plum;
this.BtPre.Location = new System.Drawing.Point(210, 110);
this.BtPre.Name = "BtPre";
this.BtPre.Size = new System.Drawing.Size(70, 21);
this.BtPre.TabIndex = 0;
this.BtPre.Text = "上一条&P";
this.BtPre.TextAlign = System.Drawing.ContentAlignment.TopCenter;
this.BtPre.Click += new System.EventHandler(this.BtPre_Click);
//
// NotifyIcon1
//
this.NotifyIcon1.ContextMenu = this.myIconMenu;
this.NotifyIcon1.Text = "公司员工查询系统";
this.NotifyIcon1.Visible = true;
this.NotifyIcon1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.NotifyIcon1_MouseDown);
//
// myIconMenu
//
this.myIconMenu.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.MenuItem2,
this.MenuItem12});
this.myIconMenu.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
//
// MenuItem2
//
this.MenuItem2.Index = 0;
this.MenuItem2.Text = "关于公司员工查询系统";
this.MenuItem2.Click += new System.EventHandler(this.MenuItem2_Click);
//
// MenuItem12
//
this.MenuItem12.Index = 1;
this.MenuItem12.Text = "退出";
this.MenuItem12.Click += new System.EventHandler(this.MenuItem12_Click);
//
// MonthCalendar1
//
this.MonthCalendar1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.MonthCalendar1.BackColor = System.Drawing.Color.Plum;
this.MonthCalendar1.Cursor = System.Windows.Forms.Cursors.Hand;
this.MonthCalendar1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.MonthCalendar1.ForeColor = System.Drawing.SystemColors.WindowText;
this.MonthCalendar1.Location = new System.Drawing.Point(320, 0);
this.MonthCalendar1.Name = "MonthCalendar1";
this.MonthCalendar1.TabIndex = 22;
this.MonthCalendar1.TitleForeColor = System.Drawing.SystemColors.Window;
//
// label7
//
this.label7.Location = new System.Drawing.Point(0, 150);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(70, 21);
this.label7.TabIndex = 23;
this.label7.Text = "员工年龄：";
this.label7.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// label8
//
this.label8.Location = new System.Drawing.Point(0, 190);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(70, 21);
this.label8.TabIndex = 24;
this.label8.Text = "员工职称：";
this.label8.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// label9
//
this.label9.Location = new System.Drawing.Point(0, 270);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(70, 21);
this.label9.TabIndex = 25;
this.label9.Text = "家庭住址：";
this.label9.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
//
// TxtAge
//
this.TxtAge.BackColor = System.Drawing.Color.SpringGreen;
this.TxtAge.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.TxtAge.ForeColor = System.Drawing.Color.Red;
this.TxtAge.Location = new System.Drawing.Point(75, 150);
this.TxtAge.Name = "TxtAge";
this.TxtAge.TabIndex = 26;
this.TxtAge.Text = "";
this.TxtAge.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//
// TxtJob
//
this.TxtJob.BackColor = System.Drawing.Color.SpringGreen;
this.TxtJob.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.TxtJob.ForeColor = System.Drawing.Color.Red;
this.TxtJob.Location = new System.Drawing.Point(75, 190);
this.TxtJob.Name = "TxtJob";
this.TxtJob.TabIndex = 27;
this.TxtJob.Text = "";
this.TxtJob.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//
// TxtAdd
//
this.TxtAdd.BackColor = System.Drawing.Color.SpringGreen;
this.TxtAdd.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.TxtAdd.ForeColor = System.Drawing.Color.Red;
this.TxtAdd.Location = new System.Drawing.Point(75, 270);
this.TxtAdd.Multiline = true;
this.TxtAdd.Name = "TxtAdd";
this.TxtAdd.Size = new System.Drawing.Size(205, 63);
this.TxtAdd.TabIndex = 28;
this.TxtAdd.Text = "";
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(300, 220);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(130, 100);
this.pictureBox1.TabIndex = 29;
this.pictureBox1.TabStop = false;
//
// label10
//
this.label10.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label10.ForeColor = System.Drawing.Color.Red;
this.label10.Location = new System.Drawing.Point(320, 330);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(216, 20);
this.label10.TabIndex = 30;
this.label10.Text = "该系统功能正在不断挖掘中．．．";
this.label10.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// menuItem7
//
this.menuItem7.Index = 5;
this.menuItem7.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem10});
this.menuItem7.Text = "娱乐中心(&G)";
//
// menuItem10
//
this.menuItem10.Index = 0;
this.menuItem10.Text = "俄罗斯方块";
this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackColor = System.Drawing.Color.Plum;
this.ClientSize = new System.Drawing.Size(592, 373);
this.Controls.Add(this.label10);
this.Controls.Add(this.pictureBox1);
this.Controls.Add(this.TxtAdd);
this.Controls.Add(this.TxtJob);
this.Controls.Add(this.TxtAge);
this.Controls.Add(this.txtSearch);
this.Controls.Add(this.TxtTel);
this.Controls.Add(this.TxtSex);
this.Controls.Add(this.TxtName);
this.Controls.Add(this.TxtNumber);
this.Controls.Add(this.label9);
this.Controls.Add(this.label8);
this.Controls.Add(this.label7);
this.Controls.Add(this.MonthCalendar1);
this.Controls.Add(this.Label6);
this.Controls.Add(this.CmbSearch);
this.Controls.Add(this.Label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.BtExit);
this.Controls.Add(this.BtFind);
this.Controls.Add(this.BtLast);
this.Controls.Add(this.BtFirst);
this.Controls.Add(this.BtNext);
this.Controls.Add(this.BtPre);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximumSize = new System.Drawing.Size(600, 400);
this.Menu = this.MainMenu1;
this.MinimumSize = new System.Drawing.Size(600, 400);
this.Name = "Form1";
this.Text = "公司员工查询系统";
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
//----------------------------------------------
//以下定义了一些DAO对象
//和一些SQL打开数据库字符串
//设计了一个OPenDB（）函数
//用DAO对象打开了数据库
//----------------------------------------------
DAO.Database Mydb;
//定义一个DAO.Database数据库对象
DAO.Workspace MyWs;
//定义一个工作空间DAO.Workspace
String MySql ;
//定义一个字符串用来存放SQL查询语言
DAO.Recordset Myrec;
//定义一个数据项DAO.Recordset
DAO.DBEngine de=new DAO.DBEngineClass();
//定义一个数据引擎DAO.DBEngine()
public bool OpenDb()
{
//定义一个数据打开函数
String dbstr;
//定义一个字符串来存放数据库所在目录
dbstr =Application.StartupPath +"\\Employee.MDB";
//取得数据库所在目录
MyWs = de.Workspaces[0];
//建立一个工作空间
Mydb = MyWs.OpenDatabase(dbstr,null,null,null);
//打开数据库存放于Mydb
MySql = "select * from 员工资料";
//设置SQL打开方式
Myrec = Mydb.OpenRecordset(MySql,
DAO.RecordsetTypeEnum.dbOpenDynaset,
DAO.RecordsetOptionEnum.dbDenyWrite,
DAO.LockTypeEnum.dbOptimistic);
//打开数据项
return true;
}
private void BtNext_Click(object sender, System.EventArgs e)
{
//当点击下一条按钮时产生的操作
Myrec.MoveNext();
//数据项先后移动一项
if(Myrec.EOF)
{
//判断是否移动到了末尾
MessageBox.Show("已经是最后一条","查询信息框");
//如果到了末尾则不向下移动数据项
Myrec.MovePrevious();
}
else
{
TxtNumber.Text = Myrec.Fields[0].Value.ToString();
//给 txtnumber.Text赋值为数据项的0单员中的内容
TxtName.Text = Myrec.Fields[1].Value.ToString();
//给 txtname.Text赋值为数据项的1单员中的内容
TxtSex.Text = Myrec.Fields[2].Value.ToString();
//给 txtdate.Text赋值为数据项的3单员中的内容
TxtAge.Text = Myrec.Fields[3].Value.ToString();
TxtJob.Text = Myrec.Fields[4].Value.ToString();
TxtTel.Text = Myrec.Fields[5].Value.ToString();
//给 txttel.Text赋值为数据项的2单员中的内容
TxtAdd.Text = Myrec.Fields[6].Value.ToString();
}
}
private void BtPre_Click(object sender, System.EventArgs e)
{
//点击上一条时产生的操作
//如果没到则向前移动数据项
Myrec.MovePrevious();
if(Myrec.BOF)
{
//判断是否移动到了末尾
MessageBox.Show("已经是第一条","查询信息框");
//如果到了末尾则不向上移动数据项
Myrec.MoveNext();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -