【導讀】計算機科學與技術專業(yè)畢業(yè)論文--企業(yè)人事管理系統(tǒng)。在當今社會互聯網空前的發(fā)展給人們的工作和生活帶來了極大的便利和高。效信息化電子化已經成為節(jié)約運營成本提高工作效率的首選考慮到當前大量企。業(yè)的人事管理尚處于手工作業(yè)階段不但效率低下還常常因為管理的不慎而出現。紕漏因此根據部分企業(yè)提供的需求設計此企業(yè)人事管理系統(tǒng)以幫助企業(yè)達到人。事管理辦公自動化節(jié)約管理成本提高企業(yè)工作效率的目的。本企業(yè)人事管理系統(tǒng)采用CS結構主要對企業(yè)員工的信息以及跟人事相關的。工作流程進行集中的管理方便企業(yè)建立一個完善的強大的員工信息數據庫。2021Express數據庫作為開發(fā)平臺使用C設計操作控件和編寫操作程序完成數。據輸入修改存儲調用查詢等功能并使用SQL2021數據庫形成數據表進行數據存。本文詳細介紹了企業(yè)人事管理系統(tǒng)的功能需求系統(tǒng)設計和具體實現并簡要。安全性與錯誤處理9. 人力資源管理系統(tǒng)主導21世紀無論是發(fā)達國家還是發(fā)展中國家對人力資源

　　

【正文】 bxUserPwdFocus break case UserLoginResultSuccess FormMain objMain new FormMain thisHide objMainShow break default break F12 登陸實體類 StringBuilder strSql new StringBuilder strSqlAppend select EmpID LoginName LoginCode Password RoleID IsUsed CreateNameCreateDatetimeRemark FROM Login strSqlAppend where LoginrCode LoginrCode Login model new Login DataTable dt DbHelpeataTable strSqlToString if t 0 modelEmpNO dtRows[0][EmpNO]ToString modelLoginName dtRows[0][LoginName]ToString modelLoginrCode dtRows[0][LoginCode]ToString modelPassword dtRows[0][Password]ToString if dtRows[0][RoleID]ToString modelRoleID intParse dtRows[0][RoleID]ToString modelIsUsed dtRows[0][IsUsed]ToString modelCreateName dtRows[0][CreateName]ToString if dtRows[0][CreateDatetime]ToString modelCreateDatetime DateTimeParse dtRows[0][CreateDatetime]ToString modelRemark dtRows[0][Remark]ToString return model else return null 檢查該員工是否應該是系統(tǒng)用戶 return DbHelpeuteScalar SELECT LoginID FROM Login WHERE LoginCode LoginrCode 檢查用戶編碼是否可以使用 return DbHelpeuteScalar SELECT LoginrCode FROM Login WHERE LoginCode LoginrCode 通過 LoginID 查找相應的密碼 return DbHelpeuteScalar Select Password from Login Where LoginID LoginID F13 員工管理模塊的設計與實現的主要代碼 理實現的主要代碼 public class BllAttendance 增加一條數據 public static int Add Attendance model DbTransaction trans StringBuilder sb new StringBuilder sbAppend INSERT INTO Attendance AttenDate EmpNo Adsum Fact Late Leave Absent Overtime NotIn NotOut Outgo sbAppend WorkOut WorkTime NumCount [In] Out Artificial [Work] Illness Thing Family sbAppend VALUES AttenDate EmpNoAdsum Fact Late Leave Absent Overtime NotIn NotOut Outgo sbAppend WorkOut WorkTime NumCount InOutArtificial Work Illness Thing Family return DbHelpeteTransNonQuery sbToString DbHelpeteParamters sbToString model trans 更新一條數據 public static int Update Attendance model StringBuilder sb new StringBuilder sbAppend UPDATE Attendance SET Adsum Adsum Fact Fact Late Late Leave Leave Absent Absent Overtime Overtime sbAppend NotIn NotIn NotOut NotOut Outgo Outgo WorkOut WorkOut WorkTime WorkTime NumCount NumCount sbAppend [In] In Artificial Artificial Out Out [Work] WorkIllness Illness Thing Thing Family Family WHERE EmpNo EmpNo return DbHelpeteNonQuery sbToString DbHelpeteParamters sbToString model 刪除一條數據 public static int Delete string EmpNo StringBuilder sb new StringBuilder sbAppend StringFormat DELETE FROM Attendance WHERE EmpNo 0 EmpNo return DbHelpeteNonQuery sbToString public static DataTable GetAttenddanceDataTable StringBuilder sb new StringBuilder sbAppend SELECT AttenDate EmpNo Adsum Fact Late Leave Absent Overtime NotIn NotOut sbAppend Outgo WorkOut WorkTime NumCount [In] Out Artificial [Work] Illness ThingFamily FROM Attendance return DbHelpeataTable sbToString 部門管理實現主要代碼 public class BLLDepartment 增加一條數據 public static int Add Department model StringBuilder strSql new StringBuilder strSqlAppend insert into Department strSqlAppend DepartNoDepartNameDepartDesnParentIDRemark strSqlAppend strSqlAppend values strSqlAppend modelDepartNo strSqlAppend modelDepartName strSqlAppend modelDepartDesn strSqlAppend modelParentID strSqlAppend modelRemark strSqlAppend return DbHelpeteNonQuery strSqlToString 更新一條數據 public static int Update Department model StringBuilder strSql new StringBuilder strSqlAppend update Department set strSqlAppend DepartName modelDepartName strSqlAppend DepartDesn modelDepartDesn strSqlAppend ParentID modelParentID strSqlAppend Remark modelRemark strSqlAppend where DepartNo modelDepartNo return DbHelpeteNonQuery strSqlToString 刪除一條數據 pu