/// <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));
}
