/// <summary>
/// 获取员工年度年假及调休假统计情况
/// </summary>
/// <param name="strEmployeeID">员工ID</param>
/// <param name="dtBalance">结算日期</param>
/// <param name="dLastAnnualLevelUnusedDays">上年度未休年假</param>
/// <param name="dAnnualLeaveUsedDays">本年度已休年假</param>
/// <param name="dAnnualLeaveSumDays">本年度总年假</param>
/// <param name="dAnnualLeaveValidDays">本年度剩余年假</param>
/// <param name="dLastLeaveValidDays">上年度未休调休假</param>
/// <param name="dLeaveUsedDays">本年度已休调休假</param>
/// <param name="dLeaveValidDays">本年度剩余调休假</param>
/// <param name="dLeaveSumDays">本年度总调休假</param>
private void CalculateEmployeeLeaveDays(string strEmployeeID, DateTime dtBalance, ref decimal?dLastAnnualLevelUnusedDays, ref decimal?dAnnualLeaveUsedDays,
ref decimal?dAnnualLeaveSumDays, ref decimal?dAnnualLeaveValidDays, ref decimal?dLastLeaveValidDays, ref decimal?dLeaveUsedDays,
ref decimal?dLeaveValidDays, ref decimal?dLeaveSumDays)
{
EmployeeLevelDayCountBLL bllEmployeeLevelDayCount = new EmployeeLevelDayCountBLL();
V_AttendSummaryRecord entCounts = bllEmployeeLevelDayCount.GetAttendSummaryRecordByEmployeeIDAndDate(strEmployeeID, dtBalance);
if (entCounts == null)
{
return;
}
dLastAnnualLevelUnusedDays = ParseDecimalValue(entCounts.LastUseYearDays);
dAnnualLeaveUsedDays = ParseDecimalValue(entCounts.UsedYearDays);
dAnnualLeaveSumDays = ParseDecimalValue(entCounts.YearDays);
dAnnualLeaveValidDays = ParseDecimalValue(entCounts.UseYearDays);
dLastLeaveValidDays = ParseDecimalValue(entCounts.LastUseLevelDayCount);
dLeaveUsedDays = ParseDecimalValue(entCounts.UsedLeavelDays);
dLeaveValidDays = ParseDecimalValue(entCounts.UseLeavelDay);
dLeaveSumDays = ParseDecimalValue(entCounts.LeavelDayCount);
}
public List<T_HR_EMPLOYEELEAVERECORD> GetEmployeeleaverecordByMultSearchId(string employeeid, string leavetypesetid, string OWNERCOMPANYID,
string strEfficDateFrom, string strEfficDateTo, int pageIndex, int pageSize, ref int pageCount)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
var ents = bllEmployeeleveldaycount.GetEmployeeleaverecordByMultSearchId(employeeid, leavetypesetid, OWNERCOMPANYID, strEfficDateFrom, strEfficDateTo,pageIndex, pageSize, ref pageCount);
if (ents == null)
{
return null;
}
return ents.ToList();
}
}
public byte[] ExportEmployeeLeaveDayCount(string sOrgType, string sValue, string strLeaveType, string strOwnerID, string strEmployeeID, string strEfficDateFrom,
string strEfficDateTo, string strSortKey)
{
using (EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL())
{
return bll.ExportEmployeeLeaveDayCount(sOrgType, sValue, strLeaveType, strOwnerID, strEmployeeID, strEfficDateFrom, strEfficDateTo, strSortKey);
}
}
public List<T_HR_EMPLOYEELEVELDAYCOUNT> GetEmployeeLevelDayCountRdListByMultSearch(string sOrgType, string sValue, string strLeaveType, string strOwnerID, string strEmployeeID, string strEfficDateFrom,
string strEfficDateTo, string strSortKey, int pageIndex, int pageSize, ref int pageCount)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
var ents = bllEmployeeleveldaycount.GetEmployeeLevelDayCountRdListByMultSearch(sOrgType, sValue, strLeaveType, strOwnerID, strEmployeeID, strEfficDateFrom, strEfficDateTo, strSortKey, pageIndex, pageSize, ref pageCount).ToList();
if (ents == null)
{
return null;
}
return ents.ToList();
}
}
public static void SendMailForExpiredOvertimeRecord(string LeaveDayCountRecordID)
{
EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL();
bll.SendMailForExpiredOvertimeRecord(LeaveDayCountRecordID);
}
public string CreateLevelDayCountWithAllForSingle(string companyID)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
return bllEmployeeleveldaycount.CreateLevelDayCountWithAllCompanyForSingle(companyID);
}
}
public void CreateLevelDayCountByAsignAttSol(string strAttendanceSolutionAsignId)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
bllEmployeeleveldaycount.CreateLevelDayCountByAsignAttSol(strAttendanceSolutionAsignId);
}
}
public List<T_HR_EMPLOYEELEVELDAYDETAILS> EmployeeLeaveDetailPaging(int pageIndex, int pageSize, string sort, string filterString, string[] paras, ref int pageCount)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
return bllEmployeeleveldaycount.EmployeeLeaveDetailPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount).ToList();
}
}
public List<T_HR_EMPLOYEELEVELDAYCOUNT> QueryEmployeeLeaveDayCount(EmployeeVacationDayCountRequest request)
{
using (EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL())
{
return bll.QueryEmployeeLeaveDayCount(request);
}
}
public List<T_HR_EMPLOYEELEVELDAYCOUNT> GetLevelDayCountByEmployeeIDAndVacType(string EmployeeID, string VacationType)
{
using (EmployeeLevelDayCountBLL leaveDayCountBll = new EmployeeLevelDayCountBLL())
{
List<T_HR_EMPLOYEELEVELDAYCOUNT> daycount = new List<T_HR_EMPLOYEELEVELDAYCOUNT>();
var daycountQueryable = leaveDayCountBll.GetLevelDayCountByEmployeeIDAndVacType(EmployeeID, VacationType);
if (daycountQueryable != null)
{
daycount = daycountQueryable.ToList();
}
return daycount;
}
}
public List<T_HR_EMPLOYEELEVELDAYCOUNT> GetAllLeaveDayCountByEmployeeID(string employeeID)
{
using (EmployeeLevelDayCountBLL logic = new EmployeeLevelDayCountBLL())
{
return logic.GetAllLeaveDayCountByEmployeeID(employeeID);
}
}
/// <summary>
/// 对指定公司，指定的员工，按照指定的考勤方案应用生成指定时段内的考勤初始化记录
/// </summary>
/// <param name="entTemp"></param>
/// <param name="entCompany"></param>
/// <param name="entEmployees"></param>
/// <param name="dtAsignDate"></param>
/// <returns></returns>
private string AsignAttendSolForEmployees(T_HR_ATTENDANCESOLUTIONASIGN entTemp, T_HR_COMPANY entCompany, List <T_HR_EMPLOYEE> entEmployees, DateTime dtAsignDate)
{
string strRes = string.Empty;
try
{
decimal dWorkMode = entTemp.T_HR_ATTENDANCESOLUTION.WORKMODE.Value;
string strAttendanceSolutionID = entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID;
int iWorkMode = 0;
int.TryParse(dWorkMode.ToString(), out iWorkMode);
List <int> iWorkDays = new List <int>();
Utility.GetWorkDays(iWorkMode, ref iWorkDays);
SchedulingTemplateDetailBLL bllTemplateDetail = new SchedulingTemplateDetailBLL();
List <T_HR_SCHEDULINGTEMPLATEDETAIL> entTemplateDetails = new List <T_HR_SCHEDULINGTEMPLATEDETAIL>();
var q = bllTemplateDetail.GetTemplateDetailRdListByAttendanceSolutionId(strAttendanceSolutionID);
if (q == null)
{
Tracer.Debug("考勤初始化考勤班次不存在");
return("{NOTFOUND}");
}
entTemplateDetails = q.ToList();
if (entTemplateDetails == null)
{
Tracer.Debug("考勤初始化考勤班次不存在");
return("{NOTFOUND}");
}
if (entTemplateDetails.Count == 0)
{
Tracer.Debug("考勤初始化考勤班次不存在");
return("{NOTFOUND}");
}
int iTotalDay = 0;
//DateTime dtCheck = new DateTime();
DateTime dtStart = DateTime.Parse(dtAsignDate.ToString("yyyy-MM") + "-1");
//DateTime dtStart = DateTime.Parse("2012-10-1");
if (entTemp.STARTDATE > dtStart)
{
dtStart = entTemp.STARTDATE.Value;
}
DateTime dtInitAttandRecordEndDate = dtStart.AddMonths(1).AddDays(-1);
AttendanceRecordBLL bllAttRd = new AttendanceRecordBLL();
EmployeeLevelDayCountBLL bllLevelDayCount = new EmployeeLevelDayCountBLL();
EmployeeEntryBLL bllEntry = new EmployeeEntryBLL();
LeftOfficeConfirmBLL bllConfirm = new LeftOfficeConfirmBLL();
//操作表T_HR_EMPLOYEELEVELDAYCOUNT数据的方式：0：直接逐条新增或修改；
//1：先把要新增或修改的记录存到内存，然后一次性提交到数据库修改
Tracer.Debug("开始生成员工考勤初始化记录,总员工数：" + entEmployees.Count());
for (int n = 0; n < entEmployees.Count(); n++)
{
bool AttendNoCheck = false;
try
{
T_HR_EMPLOYEE item_emp = entEmployees[n];
DateTime dtInitAttandRecordStartDate = new DateTime();
#region 判断是否免打卡
//如果是免打卡的用户，在这里还是需要初始化，因为结算的时候需要计算出勤天数
if (!entTemp.T_HR_ATTENDANCESOLUTIONReference.IsLoaded)
{
entTemp.T_HR_ATTENDANCESOLUTIONReference.Load();
}
if (entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCETYPE == (Convert.ToInt32(Common.AttendanceType.NoCheck) + 1).ToString())//考勤方案设置为不考勤
{
AttendNoCheck = true;
Tracer.Debug("初始化员工,考勤方案设置为免打卡，员工姓名："
+ entEmployees.FirstOrDefault().EMPLOYEECNAME
+ " 考勤方案名：" + entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONNAME);
}
#endregion
#region 初始化开始日期大于结束日期
dtInitAttandRecordStartDate = dtStart;
if (dtInitAttandRecordStartDate >= dtInitAttandRecordEndDate)
{
Tracer.Debug("初始化员工考勤记录被跳过，dtInitAttandRecordStartDate >= dtEnd" + "，员工姓名" + item_emp.EMPLOYEECNAME);
continue;
}
#endregion
#region 判断员工状态，是否有入职记录，是否已离职,入职，离职日期
string usedAttendSolutionName = ",使用的考勤方案：" + entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONNAME
+ "，当前线程id：" + Thread.CurrentThread.ManagedThreadId;
Tracer.Debug("初始化员工考勤记录：员工状态：" + item_emp.EMPLOYEESTATE + "，员工姓名" + item_emp.EMPLOYEECNAME
+ usedAttendSolutionName);
if (item_emp.EMPLOYEESTATE == "0")
{
T_HR_EMPLOYEEENTRY entEntry = bllEntry.GetEmployeeEntryByEmployeeID(item_emp.EMPLOYEEID);
if (entEntry == null)
{
Tracer.Debug("初始化员工考勤记录被跳过,该员工入职为空" + "，员工姓名" + item_emp.EMPLOYEECNAME);
continue;
}
TimeSpan tsStart = entEntry.ONPOSTDATE.Value - dtInitAttandRecordStartDate;
TimeSpan tsEnd = dtInitAttandRecordEndDate - entEntry.ONPOSTDATE.Value;
if (tsStart.Days >= 0 && tsEnd.Days >= 0)
{
Tracer.Debug("初始化员工考勤记录开始日期被修改：entEntry.ONPOSTDATE.Value > dtInitAttandRecordStartDate" + "，员工姓名" + item_emp.EMPLOYEECNAME
+ " 入职日期：" + entEntry.ENTRYDATE.Value.ToString("yyyy-MM-dd")
+ " 到岗日期：" + entEntry.ONPOSTDATE.Value.ToString("yyyy-MM-dd"));
dtInitAttandRecordStartDate = new DateTime(entEntry.ONPOSTDATE.Value.Year, entEntry.ONPOSTDATE.Value.Month, entEntry.ONPOSTDATE.Value.Day);
}
if (tsEnd.Days < 0)
{
Tracer.Debug("初始化员工考勤记录被跳过：员工到岗日期大于考勤初始化结束日期entEntry.ONPOSTDATE.Value > dtEnd" + "，员工姓名" + item_emp.EMPLOYEECNAME
+ " 入职日期：" + entEntry.ENTRYDATE.Value.ToString("yyyy-MM-dd")
+ " 到岗日期：" + entEntry.ONPOSTDATE.Value.ToString("yyyy-MM-dd")
+ " 考勤初始化结束日期：" + dtInitAttandRecordEndDate);
continue;
}
}
if (item_emp.EMPLOYEESTATE == "1")
{
T_HR_EMPLOYEEENTRY entEntry = bllEntry.GetEmployeeEntryByEmployeeID(item_emp.EMPLOYEEID);
if (entEntry == null)
{
Tracer.Debug("该员工入职为空" + "，员工姓名" + item_emp.EMPLOYEECNAME);
continue;
}
if (entEntry.ONPOSTDATE.Value > dtInitAttandRecordStartDate && entEntry.ONPOSTDATE.Value < dtInitAttandRecordEndDate)
{
Tracer.Debug("初始化员工考勤记录开始日期被修改：entEntry.ONPOSTDATE.Value > dtInitAttandRecordStartDate" + "，员工姓名" + item_emp.EMPLOYEECNAME
+ " 入职日期：" + entEntry.ENTRYDATE.Value.ToString("yyyy-MM-dd")
+ " 到岗日期：" + entEntry.ONPOSTDATE.Value.ToString("yyyy-MM-dd"));
dtInitAttandRecordStartDate = new DateTime(entEntry.ONPOSTDATE.Value.Year, entEntry.ONPOSTDATE.Value.Month, entEntry.ONPOSTDATE.Value.Day);
}
TimeSpan ts3 = entEntry.ONPOSTDATE.Value - dtInitAttandRecordEndDate;
if (ts3.Days > 0)
{
Tracer.Debug("初始化员工考勤记录被跳过,员工入职日期大于本月最后一天" + "，员工姓名" + item_emp.EMPLOYEECNAME);
continue;
}
}
else if (item_emp.EMPLOYEESTATE == "2")
{
T_HR_LEFTOFFICECONFIRM entConfirm = bllConfirm.GetLeftOfficeConfirmByEmployeeId(item_emp.EMPLOYEEID);
if (entConfirm.STOPPAYMENTDATE != null && entConfirm.STOPPAYMENTDATE.Value < dtStart)
{
Tracer.Debug("初始化员工考勤记录被跳过,entConfirm.STOPPAYMENTDATE !=null && entConfirm.STOPPAYMENTDATE.Value < dtStart" + "，员工姓名" + item_emp.EMPLOYEECNAME);
continue;
}
if (entConfirm.STOPPAYMENTDATE != null && entConfirm.STOPPAYMENTDATE.Value > dtStart && entConfirm.STOPPAYMENTDATE.Value < dtInitAttandRecordEndDate)
{
dtInitAttandRecordEndDate = new DateTime(entConfirm.STOPPAYMENTDATE.Value.Year, entConfirm.STOPPAYMENTDATE.Value.Month, entConfirm.STOPPAYMENTDATE.Value.Day);
}
if (entConfirm.STOPPAYMENTDATE != null && entConfirm.STOPPAYMENTDATE.Value < dtStart)
{
Tracer.Debug("初始化员工考勤记录被跳过,entConfirm.STOPPAYMENTDATE != null && entConfirm.STOPPAYMENTDATE.Value < dtStart" + "，员工姓名" + item_emp.EMPLOYEECNAME);
continue;
}
}
#endregion
TimeSpan ts = dtInitAttandRecordEndDate.Subtract(dtInitAttandRecordStartDate);
iTotalDay = ts.Days;
T_HR_SCHEDULINGTEMPLATEMASTER entTemplateMaster = entTemplateDetails[0].T_HR_SCHEDULINGTEMPLATEMASTER;
int iCircleDay = 0;
if (entTemplateMaster.SCHEDULINGCIRCLETYPE == (Convert.ToInt32(Common.SchedulingCircleType.Month) + 1).ToString())
{
iCircleDay = 31;
}
else if (entTemplateMaster.SCHEDULINGCIRCLETYPE == (Convert.ToInt32(Common.SchedulingCircleType.Week) + 1).ToString())
{
iCircleDay = 7;
}
int iPeriod = iTotalDay / iCircleDay;
if (iTotalDay % iCircleDay >= 0)
{
iPeriod += 1;
}
OutPlanDaysBLL bllOutPlanDays = new OutPlanDaysBLL();
IQueryable <T_HR_OUTPLANDAYS> entOutPlanDays = bllOutPlanDays.GetOutPlanDaysRdListByEmployeeID(item_emp.EMPLOYEEID);
string strVacDayType = (Convert.ToInt32(Common.OutPlanDaysType.Vacation) + 1).ToString();
string strWorkDayType = (Convert.ToInt32(Common.OutPlanDaysType.WorkDay) + 1).ToString();
IQueryable <T_HR_OUTPLANDAYS> entVacDays = entOutPlanDays.Where(s => s.DAYTYPE == strVacDayType);
IQueryable <T_HR_OUTPLANDAYS> entWorkDays = entOutPlanDays.Where(s => s.DAYTYPE == strWorkDayType && s.STARTDATE >= dtInitAttandRecordStartDate && s.ENDDATE <= dtInitAttandRecordEndDate);
//IQueryable<T_HR_OUTPLANDAYS> entVacWorkDays = entOutPlanDays.Where(s => s.STARTDATE >= dtInitAttandRecordStartDate && s.ENDDATE <= dtInitAttandRecordEndDate);
//例外工作日考勤初始化记录公共假期
CreateOutPlanWorkDay(entCompany, item_emp, entTemp, entTemplateDetails, entWorkDays, AttendNoCheck);
//IQueryable<T_HR_OUTPLANDAYS> entVacWorkHalfDays
// = entVacDays.Where(s => s.STARTDATE >= dtInitAttandRecordStartDate
// && s.ENDDATE <= dtInitAttandRecordEndDate && s.ISHALFDAY=="1");
int addCount = 0;
int updateCount = 0;
for (int i = 0; i < iPeriod; i++)
{
for (int j = 0; j < iCircleDay; j++)
{
#region 开始生成员工考勤初始化记录
try
{
int m = (i * iCircleDay) + j;
DateTime dtCurDate = dtInitAttandRecordStartDate.AddDays(m);
if (dtCurDate > entTemp.ENDDATE.Value)
{
break;
}
bool isVacDay = false;
if (iWorkDays.Contains(Convert.ToInt32(dtCurDate.DayOfWeek)) == false)
{
continue;
}
if (entVacDays.Count() > 0)
{
foreach (T_HR_OUTPLANDAYS item_Vac in entVacDays)
{
if (item_Vac.STARTDATE.Value <= dtCurDate && item_Vac.ENDDATE >= dtCurDate)
{
//如果是公共假期并未设置半天，设为公共假期不考勤
if (string.IsNullOrEmpty(item_Vac.ISHALFDAY))
{
isVacDay = true;
break;
}
if (!string.IsNullOrEmpty(item_Vac.ISHALFDAY) &&
item_Vac.ISHALFDAY == "0")
{
isVacDay = true;
break;
}
else
{ //例外工作日考勤初始化记录（公共假期半天休息，还有半天上班也需要初始化考勤记录）
}
}
}
}
if (isVacDay)
{
continue;
}
T_HR_SCHEDULINGTEMPLATEDETAIL item = entTemplateDetails.Where(c => c.SCHEDULINGDATE == (j + 1).ToString()).FirstOrDefault();
var qc = from ar in dal.GetObjects <T_HR_ATTENDANCERECORD>()
where //ar.OWNERCOMPANYID == entCompany.COMPANYID &&
ar.EMPLOYEEID == item_emp.EMPLOYEEID && ar.ATTENDANCEDATE == dtCurDate
select ar;
T_HR_ATTENDANCERECORD entUpdate = qc.FirstOrDefault();
if (entUpdate == null)
{
T_HR_ATTENDANCERECORD entAttRd = new T_HR_ATTENDANCERECORD();
entAttRd.ATTENDANCERECORDID = System.Guid.NewGuid().ToString().ToUpper();
entAttRd.ATTENDANCESOLUTIONID = entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID;
entAttRd.EMPLOYEEID = item_emp.EMPLOYEEID;
entAttRd.EMPLOYEECODE = item_emp.EMPLOYEECODE;
entAttRd.EMPLOYEENAME = item_emp.EMPLOYEECNAME;
entAttRd.ATTENDANCEDATE = dtCurDate;
//外键实体
//entAttRd.T_HR_SHIFTDEFINE = item.T_HR_SHIFTDEFINE;
entAttRd.T_HR_SHIFTDEFINEReference.EntityKey = new EntityKey("TM_SaaS_OA_EFModelContext.T_HR_SHIFTDEFINE", "SHIFTDEFINEID", item.T_HR_SHIFTDEFINE.SHIFTDEFINEID);
//第一段工作时间
entAttRd.FIRSTSTARTTIME = item.T_HR_SHIFTDEFINE.FIRSTSTARTTIME;
entAttRd.FIRSTENDTIME = item.T_HR_SHIFTDEFINE.FIRSTENDTIME;
//第二段工作时间
entAttRd.SECONDSTARTTIME = item.T_HR_SHIFTDEFINE.SECONDSTARTTIME;
entAttRd.SECONDENDTIME = item.T_HR_SHIFTDEFINE.SECONDENDTIME;
//第三段工作时间
entAttRd.THIRDSTARTTIME = item.T_HR_SHIFTDEFINE.THIRDSTARTTIME;
entAttRd.THIRDENDTIME = item.T_HR_SHIFTDEFINE.THIRDENDTIME;
//第四段工作时间
entAttRd.FOURTHENDTIME = item.T_HR_SHIFTDEFINE.FOURTHENDTIME;
entAttRd.FOURTHSTARTTIME = item.T_HR_SHIFTDEFINE.FOURTHSTARTTIME;
//查询公共假期设置判断是否只上半天班公共假期
var qVacDay = from ent in entVacDays
where ent.STARTDATE == entAttRd.ATTENDANCEDATE
select ent;
if (qVacDay.Count() > 0)
{
var set = qVacDay.FirstOrDefault();
if (!string.IsNullOrEmpty(set.ISHALFDAY))
{
if (set.ISHALFDAY == "1")
{
if (set.PEROID == "0")//上午
{
string msg = "考勤初始化（新增）-检测到假期设置了休假（半天）："
+ " 员工：" + entAttRd.EMPLOYEENAME
+ " 日期：" + entAttRd.ATTENDANCEDATE
+ " 休假分段（0上午）：" + set.PEROID;
Tracer.Debug(msg);
entAttRd.REMARK = msg;
entAttRd.NEEDFRISTATTEND = "0"; //上午不上班
entAttRd.NEEDSECONDATTEND = "1"; //下午上班
}
else if (set.PEROID == "1")
{
string msg = "考勤初始化（新增）-检测到假期设置了休假（半天）："
+ " 员工：" + entAttRd.EMPLOYEENAME
+ " 日期：" + entAttRd.ATTENDANCEDATE
+ " 休假分段（1下午）：" + set.PEROID;
Tracer.Debug(msg);
entAttRd.REMARK = msg;
entAttRd.NEEDFRISTATTEND = "1"; //上午上班
entAttRd.NEEDSECONDATTEND = "0"; //下午不上班
}
}
}
}
//权限
entAttRd.OWNERCOMPANYID = item_emp.OWNERCOMPANYID;
entAttRd.OWNERDEPARTMENTID = item_emp.OWNERDEPARTMENTID;
entAttRd.OWNERPOSTID = item_emp.OWNERPOSTID;
entAttRd.OWNERID = item_emp.OWNERID;
entAttRd.CREATEUSERID = entTemp.CREATEUSERID;
entAttRd.CREATEDATE = DateTime.Now;
entAttRd.REMARK += entTemp.REMARK;
entAttRd.UPDATEUSERID = entTemp.UPDATEUSERID;
entAttRd.UPDATEDATE = DateTime.Now;
entAttRd.CREATECOMPANYID = entTemp.CREATECOMPANYID;
entAttRd.CREATEDEPARTMENTID = entTemp.CREATEDEPARTMENTID;
entAttRd.CREATEPOSTID = entTemp.CREATEPOSTID;
if (AttendNoCheck)
{
entAttRd.ATTENDANCESTATE = "1";//免打卡员工
Tracer.Debug("设置为免打孔员工，考勤默认为已出勤，" + " 员工姓名" + item_emp.EMPLOYEECNAME + " 考勤初始化日期：" + entAttRd.ATTENDANCEDATE.Value.ToString("yyyy-MM-dd")
+ usedAttendSolutionName);
}
else
{
entAttRd.ATTENDANCESTATE = string.Empty; //新生成的考勤记录，出勤状态为空
}
Tracer.Debug("开始新增员工T_HR_ATTENDANCERECORD记录,日期：" + dtCurDate.ToString("yyyy-MM-dd") + "，员工姓名:" + item_emp.EMPLOYEECNAME
+ "，初始化考勤状态：" + entAttRd.ATTENDANCESTATE + usedAttendSolutionName);
addCount += dal.Add(entAttRd);
}
else
{
if (AttendNoCheck) //免打孔
{
entUpdate.ATTENDANCESTATE = "1"; //免打卡员工 //非免打卡员工，跳过
Tracer.Debug("设置为免打孔员工，考勤默认为已出勤，" + " 员工姓名" + item_emp.EMPLOYEECNAME + " 考勤初始化日期：" + entUpdate.ATTENDANCEDATE.Value.ToString("yyyy-MM-dd")
+ usedAttendSolutionName);
}
else
{
if (!string.IsNullOrEmpty(entUpdate.ATTENDANCESTATE))
{
Tracer.Debug("更新考勤初始化记录，已存在的考勤初始化记录状态为： " + entUpdate.ATTENDANCESTATE + " ,跳过不再生成" + "，员工姓名:" + item_emp.EMPLOYEECNAME
+ "，考勤状态：" + entUpdate.ATTENDANCESTATE + usedAttendSolutionName);
continue; //如果存在直接跳过
}
entUpdate.ATTENDANCESTATE = string.Empty; //新生成的考勤记录，出勤状态为空
}
Tracer.Debug("更新考勤初始化记录，ATTENDANCESTATE考勤状态为空,日期：" + dtCurDate.ToString("yyyy-MM-dd") + "，员工姓名:" + item_emp.EMPLOYEECNAME
+ "，初始化考勤状态：" + entUpdate.ATTENDANCESTATE + usedAttendSolutionName);
entUpdate.ATTENDANCESOLUTIONID = entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID;
entUpdate.EMPLOYEEID = item_emp.EMPLOYEEID;
entUpdate.EMPLOYEECODE = item_emp.EMPLOYEECODE;
entUpdate.EMPLOYEENAME = item_emp.EMPLOYEECNAME;
entUpdate.ATTENDANCEDATE = dtCurDate;
entUpdate.T_HR_SHIFTDEFINE = item.T_HR_SHIFTDEFINE;
//第一段工作时间
entUpdate.FIRSTSTARTTIME = item.T_HR_SHIFTDEFINE.FIRSTSTARTTIME;
entUpdate.FIRSTENDTIME = item.T_HR_SHIFTDEFINE.FIRSTENDTIME;
//第二段工作时间
entUpdate.SECONDSTARTTIME = item.T_HR_SHIFTDEFINE.SECONDSTARTTIME;
entUpdate.SECONDENDTIME = item.T_HR_SHIFTDEFINE.SECONDENDTIME;
//第三段工作时间
entUpdate.THIRDSTARTTIME = item.T_HR_SHIFTDEFINE.THIRDSTARTTIME;
entUpdate.THIRDENDTIME = item.T_HR_SHIFTDEFINE.THIRDENDTIME;
//第四段工作时间
entUpdate.FOURTHENDTIME = item.T_HR_SHIFTDEFINE.FOURTHENDTIME;
entUpdate.FOURTHSTARTTIME = item.T_HR_SHIFTDEFINE.FOURTHSTARTTIME;
//查询公共假期设置判断是否只上半天班
var qVacDay = from ent in entVacDays
where ent.STARTDATE == entUpdate.ATTENDANCEDATE
select ent;
if (qVacDay.Count() > 0)
{
var set = qVacDay.FirstOrDefault();
if (!string.IsNullOrEmpty(set.ISHALFDAY))
{
if (set.ISHALFDAY == "1")
{
if (set.PEROID == "0")//上午
{
string msg = "考勤初始化（修改）-检测到假期设置了休假（半天）："
+ " 员工：" + entUpdate.EMPLOYEENAME
+ " 日期：" + entUpdate.ATTENDANCEDATE
+ " 上班分段（0上午）：" + set.PEROID;
Tracer.Debug(msg);
entUpdate.REMARK = msg;
entUpdate.NEEDFRISTATTEND = "0"; //上午不上班休息
entUpdate.NEEDSECONDATTEND = "1"; //下午上班
}
else if (set.PEROID == "1")
{
string msg = "考勤初始化（修改）-检测到假期设置了休假（半天）："
+ " 员工：" + entUpdate.EMPLOYEENAME
+ " 日期：" + entUpdate.ATTENDANCEDATE
+ " 上班分段（1下午）：" + set.PEROID;
Tracer.Debug(msg);
entUpdate.REMARK = msg;
entUpdate.NEEDFRISTATTEND = "1"; //上午上班
entUpdate.NEEDSECONDATTEND = "0"; //下午不上班休息
}
}
}
}
//权限
entUpdate.OWNERCOMPANYID = item_emp.OWNERCOMPANYID;
entUpdate.OWNERDEPARTMENTID = item_emp.OWNERDEPARTMENTID;
entUpdate.OWNERPOSTID = item_emp.OWNERPOSTID;
entUpdate.OWNERID = item_emp.OWNERID;
entUpdate.REMARK += entTemp.REMARK;
entUpdate.UPDATEUSERID = entTemp.UPDATEUSERID;
entUpdate.UPDATEDATE = DateTime.Now;
updateCount += dal.Update(entUpdate);
}
}
catch (Exception ex)
{
Tracer.Debug("生成考勤初始化记录出错：" + item_emp.EMPLOYEECNAME + ex.ToString() + usedAttendSolutionName);
continue;
}
#endregion
}
}
//bllLevelDayCount.CalculateEmployeeLevelDayCount(entTemp, item_emp, strOperationType);
//int saveCount=dal.SaveContextChanges();
Tracer.Debug(n + "生成员工：" + item_emp.EMPLOYEECNAME + " 考勤记录成功,开始日期" + dtStart.ToString("yyyy-MM-dd") + "结束日期："
+ dtInitAttandRecordEndDate.ToString("yyyy-MM-dd") + "共新增考勤记录" + addCount.ToString() + " 更新记录条数：" + updateCount
+ usedAttendSolutionName);
}
catch (Exception ex)
{
Tracer.Debug("生成考勤初始化记录出错：" + entEmployees[n].EMPLOYEECNAME + ex.ToString());
continue;
}
}
Tracer.Debug("生成所有员工考勤记录成功,开始日期" + dtStart.ToString("yyyy-MM-dd") + "结束日期：" + dtInitAttandRecordEndDate.ToString("yyyy-MM-dd"));
strRes = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
Tracer.Debug("生成考勤初始化记录出错：" + ex.ToString());
strRes = ex.Message.ToString();
}
return(strRes);
}
/// <summary>
/// 根据员工ID获取员工的带薪假期的天数，调休假天数，及已休假天数。
/// </summary>
/// <param name="employeeID">员工ID</param>
/// <param name="date">日期</param>
/// <returns></returns>
public List <V_EMPLOYEELEAVE> GetEmployeeLeaveByEmployeeID(string employeeID, DateTime date)
{
List <V_EMPLOYEELEAVE> leaveList = new List <V_EMPLOYEELEAVE>();
try
{
//获取员工组织架构
EmployeeBLL employeeBll = new EmployeeBLL();
V_EMPLOYEEPOST employeePost = employeeBll.GetEmployeeDetailByID(employeeID);
//获取员工的入职信息
EmployeeEntryBLL entryBll = new EmployeeEntryBLL();
T_HR_EMPLOYEEENTRY entry = entryBll.GetEmployeeEntryByEmployeeID(employeeID);
DateTime entryDate = entry.ENTRYDATE.Value;
int m = Utility.DateDiff(entryDate, date, "M");
string departmentID = employeePost.EMPLOYEEPOSTS[0].T_HR_POST.T_HR_DEPARTMENT.DEPARTMENTID;
string comparyID = employeePost.EMPLOYEEPOSTS[0].T_HR_POST.T_HR_DEPARTMENT.T_HR_COMPANY.COMPANYID;
var ent = from a in dal.GetObjects().Include("T_HR_LEAVETYPESET")
join al in dal.GetObjects <T_HR_ATTENDFREELEAVE>().Include("T_HR_ATTENDANCESOLUTION").Include("T_HR_LEAVETYPESET") on a.T_HR_LEAVETYPESET.LEAVETYPESETID equals al.T_HR_LEAVETYPESET.LEAVETYPESETID
join ad in dal.GetObjects <T_HR_ATTENDANCESOLUTION>() on al.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID equals ad.ATTENDANCESOLUTIONID
join at in dal.GetObjects <T_HR_ATTENDANCESOLUTIONASIGN>() on ad.ATTENDANCESOLUTIONID equals at.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID
where (at.ASSIGNEDOBJECTID == departmentID || at.ASSIGNEDOBJECTID == comparyID) &&
a.MINIMONTH <= m &&
a.MAXMONTH >= m
select new V_EMPLOYEELEAVE()
{
EmployeeID = employeeID,
EmployeeCode = employeePost.T_HR_EMPLOYEE.EMPLOYEECODE,
EmployeeName = employeePost.T_HR_EMPLOYEE.EMPLOYEECNAME,
LeaveTypeName = a.T_HR_LEAVETYPESET.LEAVETYPENAME,
LeaveTypeSetID = a.T_HR_LEAVETYPESET.LEAVETYPESETID,
MaxDays = a.T_HR_LEAVETYPESET.MAXDAYS.Value,
FineType = a.T_HR_LEAVETYPESET.FINETYPE,
IsPerfectAttendanceFactor = a.ISPERFECTATTENDANCEFACTOR,
LeaveDays = a.LEAVEDAYS.Value
};
leaveList = ent.Count() > 0 ? ent.ToList() : null;
//获取年度考勤结算日
AttendanceSolutionAsignBLL bll = new AttendanceSolutionAsignBLL();
var tempEnt = bll.GetAttendanceSolutionAsignByEmployeeID(employeeID);
string strDate = tempEnt.T_HR_ATTENDANCESOLUTION.YEARLYBALANCEDATE;
string strType = tempEnt.T_HR_ATTENDANCESOLUTION.YEARLYBALANCETYPE; //结算方式
//获取加班调休假的天数
EmployeeLevelDayCountBLL leaveDaybll = new EmployeeLevelDayCountBLL();
AdjustLeaveBLL adjustbll = new AdjustLeaveBLL();
decimal leaveDays = leaveDaybll.GetLevelDayCountByEmployeeID(employeeID, date, strDate);
V_EMPLOYEELEAVE leave = new V_EMPLOYEELEAVE();
ent = from a in dal.GetObjects <T_HR_LEAVETYPESET>()
where !string.IsNullOrEmpty(a.LEAVETYPEVALUE)
select new V_EMPLOYEELEAVE
{
EmployeeID = employeeID,
EmployeeCode = employeePost.T_HR_EMPLOYEE.EMPLOYEECODE,
EmployeeName = employeePost.T_HR_EMPLOYEE.EMPLOYEECNAME,
LeaveTypeName = a.LEAVETYPENAME,
LeaveTypeSetID = a.LEAVETYPESETID,
MaxDays = a.MAXDAYS.Value,
FineType = a.FINETYPE,
LeaveDays = leaveDays
};
leave = ent.Count() > 0 ? ent.FirstOrDefault() : null;
if (leave != null)
{
leaveList.Add(leave);
}
//获取已休天数,并算出可休假天数
foreach (var obj in leaveList)
{
//剩余可休假为累计的情况
if (strType == "1")
{
//往年可休假的总数
decimal leaveHistoryDays = leaveDaybll.GetLevelDayCountHistoryByEmployeeID(employeeID, date, strDate);
//往年已休假的总数
decimal UsedUpDays = adjustbll.GetUseUpHistory(obj.LeaveTypeSetID, obj.EmployeeID, date, strDate);
obj.LeaveDays += leaveHistoryDays - UsedUpDays;
}
obj.UsedLeaveDays = adjustbll.GetUseUp(obj.LeaveTypeSetID, obj.EmployeeID, date, strDate);
obj.UseableLeaveDays = obj.LeaveDays - obj.UsedLeaveDays;
}
}
catch (Exception ex)
{
Tracer.Debug(ex.ToString());
}
return(leaveList);
}
public List<T_HR_EMPLOYEELEVELDAYCOUNT> GetEmployeeLevelDayCountRdListByMultSearchByTime(string strOwnerID, string strEmployeeID,
string strSortKey, int pageIndex, int pageSize, ref int pageCount, DateTime startTime, DateTime endTime)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
var ents = bllEmployeeleveldaycount.GetEmployeeLevelDayCountRdListByMultSearch(strOwnerID, strEmployeeID, strSortKey, pageIndex, pageSize, ref pageCount, startTime, endTime).ToList();
if (ents == null)
{
return null;
}
return ents.ToList();
}
}
public List<EmployeeAlreadyLeave> QueryEmployeeLeaveDayCount(int PageIndex, int PageSize, string Sort, string FilterString, List<object> parameters, string strOwenerID, out int PageCount, string Type)
{
using (EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL())
{
return bll.QueryEmployeeLeaveDayCount(PageIndex, PageSize, Sort, FilterString, parameters, strOwenerID, out PageCount, Type);
}
}
public string AddEmployeeLevelDayCount(T_HR_EMPLOYEELEVELDAYCOUNT entTemp)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
return bllEmployeeleveldaycount.AddEmployeeLevelDayCount(entTemp);
}
}
/// <summary>
/// 加班申请审核通过后添加定时任务，用于加班过期执行
/// 在T_HR_EmployeeLevelDayCount表中，RecordID等于审核通过后的加班记录的ID
/// </summary>
public static void AuditOverTimeRecordPass(string LeaveDayCountRecordID)
{
EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL();
bll.ExpireOvertimeVacation(LeaveDayCountRecordID);
}
public T_HR_EMPLOYEELEVELDAYCOUNT GetCurLevelDayCountByEmployeeID(string employeeID, string strVacType, DateTime currDate)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
return bllEmployeeleveldaycount.GetCurLevelDayCountByEmployeeID(employeeID, strVacType, currDate);
}
}
public static void SendMailForExpiredOvertimeRecord(string LeaveDayCountRecordID)
{
EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL();
bll.SendMailForExpiredOvertimeRecord(LeaveDayCountRecordID);
}
public void CreateLevelDayCountWithAll()
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
bllEmployeeleveldaycount.CreateLevelDayCountWithAllCompany();
}
}
public void GetCurLevelDaysByEmployeeIDAndLeaveFineType(string strEmployeeID, string strLeaveRecordId, string strLeaveSetId,
DateTime dtStartDate, DateTime dtEndDate, ref decimal dCurLevelDays)
{
using (EmployeeLevelDayCountBLL bllEmployeeleveldaycount = new EmployeeLevelDayCountBLL())
{
dCurLevelDays = bllEmployeeleveldaycount.GetCurLevelDaysByEmployeeIDAndLeaveFineType(strEmployeeID, strLeaveRecordId, strLeaveSetId, dtStartDate, dtEndDate);
}
}
public void CalculateEmployeeLevelDayCountByOrgID(string strOrgType, string strOrgId)
{
using (EmployeeLevelDayCountBLL bllLevelDayCount = new EmployeeLevelDayCountBLL())
{
bllLevelDayCount.CalculateEmployeeLevelDayCountByOrgID(strOrgType, strOrgId);
}
}
/// <summary>
/// 加班申请审核通过后添加定时任务，用于加班过期执行
/// 在T_HR_EmployeeLevelDayCount表中，RecordID等于审核通过后的加班记录的ID
/// </summary>
public static void AuditOverTimeRecordPass(string LeaveDayCountRecordID)
{
EmployeeLevelDayCountBLL bll = new EmployeeLevelDayCountBLL();
bll.ExpireOvertimeVacation(LeaveDayCountRecordID);
}
