C#考勤管理系统报告.docx

C#大作业报告-考勤管理系统一、 需求分析公司人员上下班考勤情况需要管理，为了简化管理，开发一个电子考勤系统，简化考勤的过程，以及主管人员查看员工的考勤情况。二、 系统模板设计针对不同的用户设计了不同的模板。主要用户有员工和管理人员。1. 员工员工上下班需要使用系统进行打卡登记。需要输入自己的员工号，选择上班或者下班。2. 管理人员需要对部门、员工等重要信息进行必要的维护。比如新增加某个部门，新增员工等操作。还可以查看各个员工的考情情况，搜索某一个特定员工指定的情况等功能。三、 系统主要流程1. 员工:输入员工号选择上班/下班相关信息进入数据库存储2. 管理人员:系统登录（用户，密码）. 用户密码验证成功管理主界面部门，员工信息维护考勤统计退出系统四、 系统界面和主要源代码1. 员工打卡界面： 主要代码：/根据用户是否存在执行不同的操作 if (empName = ) MessageBox.Show(对不起，该员工号不存在！请重新输入！, 系统提示); else /如果用户存在，查看今天有没有签退记录 commandText = string.Format(select count(*) from T_Record where EID=0 and type=2 and year(RecordTime)=year(getdate() and month(RecordTime)=month(getdate() and day(RecordTime)=day(getdate(), txtEID.Text); cmd = new SqlCommand(commandText, conn); conn.Open(); int ret = Convert.ToInt32(cmd.ExecuteScalar(); conn.Close(); if (ret 0) MessageBox.Show(对不起， + empName + ,您已经签退！, 系统提示); else /如果没有签退，在系统中记录用户的签退信息 commandText = string.Format(insert into T_Record(EID,Type,IsLate) values(0,1,2), txtEID.Text, 2, early); cmd = new SqlCommand(commandText, conn); conn.Open(); cmd.ExecuteNonQuery(); if (early = 0) MessageBox.Show(再见： + empName , 系统提示); else MessageBox.Show(对不起： + empName + ,您早退了！, 系统提示); 2.管理人员：（1）登录界面：主要代码：private void btnOk_Click(object sender, EventArgs e) string commandText = select count(*) from T_Operator where OperID=OperID And Pwd=Pwd; using (SqlConnection conn = new SqlConnection(SQLDBHelper.ConnectionString) using (SqlCommand cmd = new SqlCommand(commandText, conn) SqlParameter para = new SqlParameter new SqlParameter(OperID,txtOperID.Text), new SqlParameter(Pwd,txtPwd.Text) ; cmd.Parameters.AddRange(para); conn.Open(); int ret = Convert.ToInt32(cmd.ExecuteScalar(); if (ret = 1) MainForm form = new MainForm(); form.Show(); this.Hide(); else MessageBox.Show(用户名或密码错误！); （2）维护主界面：主要代码：public partial class MainForm : Form public MainForm() InitializeComponent(); private void tsbExit_Click(object sender, EventArgs e) Application.Exit(); private void tsbRecord_Click(object sender, EventArgs e) RecordListForm form = new RecordListForm(); form.ShowDialog(); private void tsbEmp_Click(object sender, EventArgs e) EmpListForm form = new EmpListForm(); form.ShowDialog(); private void tsbDepart_Click(object sender, EventArgs e) DepartListForm form = new DepartListForm(); form.ShowDialog(); private void MainForm_FormClosed(object sender, FormClosedEventArgs e) Application.Exit(); （3）统计查看界面： 主要代码：tring commandText = select d.DName as 部门,r.EID as 职员编号,e.EName as 姓名,r.RecordTime as 记录时间,case when Type=1 then 上班 else 下班 end as 类型, + casewhen (IsLate=0 and Type=1) or(IsLate=0 and Type=2) then 正常 when (IsLate=1 and Type=1) then 迟到else 早退 end as 状态 + from T_Record r,T_Employee e,T_Department d where r.EID=e.EID and d.DID=e.DID + sCon.ToString(); using (SqlConnection conn = new SqlConnection(SQLDBHelper.ConnectionString) using (SqlDataAdapter sda = new SqlDataAdapter(commandText, conn) DataSet ds = new DataSet(); sda.Fill(ds); dgvRecord.DataSource = ds.Tables0; （4）部门维护界面：主要代码：private void 修改职员信息ToolStripMenuItem_Click(object sender, EventArgs e) if (lvDepart.SelectedItems.Count = 0) return; string did = lvDepart.SelectedItems0.Text; DepartForm form = new DepartForm(OperType.Modify, did); form.ShowDialog(); /刷新数据 if (form.DialogResult = System.Windows.Forms.DialogResult.OK) btnQuery_Click(sender, e); private void 删除职员信息ToolStripMenuItem_Click(object sender, EventArgs e) if (lvDepart.SelectedItems.Count = 0) return; if (MessageBox.Show(您确实要删除部门编号为 + lvDepart.SelectedItems0.Text + 的部门信息吗?, 系统提示, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = System.Windows.Forms.DialogResult.Yes) string commandText = delete from T_Department where DID=DID; using (SqlConnection conn = new SqlConnection(SQLDBHelper.ConnectionString) using (SqlCommand cmd = new SqlCommand(commandText, conn) cmd.Parameters.Add(new SqlParameter(DID, lvDepart.SelectedItems0.Text); conn.Open(); try int ret = cmd.ExecuteNonQuery(); if (ret 0) MessageBox.Show( 数据删除成功！ , 系统提示); /刷新数据 btnQuery_Click(sender, e); else MessageBox.Show( 数据删除失败！ , 系统提示); catch (Exception ex) MessageBox.Show( 该部门还有职员，请先删除职员信息 , 系统提示); （5）员工维护界面：主要代码：private void 修改职员信息ToolStripMenuItem_Click(object sender, EventArgs e) if (lvEmp.SelectedItems.Count = 0) return; string eid = lvEmp.SelectedItems0.Text; EmpForm form = new EmpForm(OperType.Modify, eid); form.ShowDialog(); /刷新数据 if (form.DialogResult = System.Windows.Forms.DialogResult.OK) btnQuery_Click(sender, e); private void 删除职员信息ToolStripMenuItem_Click(object sender, EventArgs e) if (lvEmp.SelectedItems.Count = 0) return; SqlConnection conn = new SqlConnection(SQLDBHelper.ConnectionString); SqlTransaction tran = null; if (MessageBox.Show(您确实要删除员工号为 + lvEmp.SelectedItems0.Text + 的员工信息吗?, 系统提示, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = System.Windows.Forms.DialogResult.Yes) try conn.Open(); tran = conn.BeginTransaction(); string commandText = delete from T_Record where EID= + lvEmp.SelectedItems0.Text + ; SqlCommand cmd = new SqlCommand(commandText, conn); cmd.Transaction = tran; cmd.ExecuteNonQuery(); commandText = delete from T_Employee where EID= + lvEmp.SelectedItems0.Text + ; cmd = new SqlCommand(commandText, conn); cmd.Transaction = tran; cmd.ExecuteNonQuery(); tran.Commit(); MessageBox.Show(职员删除成功！, 系统提示); btnQ