/// <summary> /// 请假申请 /// </summary> /// <param name="leave"></param> /// <returns></returns> public string ApplicationLeave(MODEL.Leave leave) { string sql = "insert into Leave(UserID,LeaveTime,LeaveStartTime,LeaveEndTime,LeaveHalfDay,LeaveDays,LeaveReason,LeaveState) values(@UserID,GETDATE(),@LeaveStartTime,@LeaveEndTime,@LeaveHalfDay,@LeaveDays,@LeaveReason,3);select @@identity;"; SqlParameter[] sqlpar = { new SqlParameter("UserID", leave.UserID), new SqlParameter("LeaveStartTime", leave.LeaveStartTime), new SqlParameter("LeaveEndTime", leave.LeaveEndTime), new SqlParameter("LeaveHalfDay", leave.LeaveHalfDay), new SqlParameter("LeaveDays", leave.LeaveDays), new SqlParameter("LeaveReason", leave.LeaveReason), }; DataTable dt = DBHelper.GetSelect(sql, sqlpar); return(dt.Rows[0][0].ToString()); }
/// <summary> /// 请假申请 /// </summary> /// <param name="leave"></param> /// <returns></returns> public bool ApplicationLeave(MODEL.Leave leave, MODEL.UserInfo user) { MODEL.OvertineCheck overtineCheck = new MODEL.OvertineCheck(); overtineCheck.LeaveID = Leave_dal.ApplicationLeave(leave); overtineCheck.userID = user.UserID; overtineCheck.ApproverType = "2"; if (user.RoleID == "1" && user.DepartmentID != "10") //普通员工 { if (Convert.ToInt32(leave.LeaveDays) < 3) { //只需要部门经理审核 overtineCheck.DepartmentalAudit = "3"; } else if (Convert.ToInt32(leave.LeaveDays) >= 3 && Convert.ToInt32(leave.LeaveDays) <= 5) { //需要部门经理和人事经理审核 overtineCheck.DepartmentalAudit = "3"; overtineCheck.GeneralManagerAudit = "3"; } else { //需要总经理,部门经理,人事经理审核 overtineCheck.DepartmentalAudit = "3"; overtineCheck.GeneralManagerAudit = "3"; overtineCheck.ManagerAudit = "3"; } } else if (user.DepartmentID == "10" && user.RoleID != "4") //人事部员工 { //需要人事经理审核 if (Convert.ToInt32(leave.LeaveDays) < 3) { overtineCheck.GeneralManagerAudit = "3"; } else { overtineCheck.GeneralManagerAudit = "3"; overtineCheck.ManagerAudit = "3"; } } else if (user.RoleID == "2") //部门经理 { if (Convert.ToInt32(leave.LeaveDays) < 3) { //只需要人事经理审核 overtineCheck.GeneralManagerAudit = "3"; } else { overtineCheck.GeneralManagerAudit = "3"; overtineCheck.ManagerAudit = "3"; } } else if (user.RoleID == "4") //人事经理 { overtineCheck.ManagerAudit = "3"; } return(OvertineCheck_dal.AddOvertineCheck(overtineCheck)); }