public bool Delete(TEntity entity) { try { dal.Delete(entity); DeleteMyRecord(entity); return(true); } catch (Exception ex) { return(false); throw (ex); } }
/// <summary> /// 根据设置的日历重新初始化考勤 /// </summary> /// <param name="entVacRd"></param> private void reInitAttandeceRecordWithOutWorkDaySet(string VACATIONID) { try { using (dal = new CommDal <T_HR_VACATIONSET>()) { var q = from ent in dal.GetObjects <T_HR_VACATIONSET>().Include("T_HR_OUTPLANDAYS") where ent.VACATIONID == VACATIONID select ent; var entVacRd = q.FirstOrDefault(); if (entVacRd == null) { Tracer.Debug("根据设置的日历重新初始化考勤跳过,获取的T_HR_VACATIONSET为空,id:" + VACATIONID); } List <T_HR_OUTPLANDAYS> entOutPlanDays = entVacRd.T_HR_OUTPLANDAYS.ToList(); bool needInitCompanyAttanceDayAgain = false; string strCurYearMonth = string.Empty; if (entOutPlanDays.Count == 0) { Tracer.Debug("根据设置的日历重新初始化考勤跳过,明细为空"); } foreach (T_HR_OUTPLANDAYS item in entOutPlanDays) { #region 处理考勤初始化 if (item.DAYTYPE == (Convert.ToInt32(Common.OutPlanDaysType.Vacation) + 1).ToString()) { try { string sql = @"delete smthrm.t_hr_attendancerecord a where a.ownercompanyid = '" + entVacRd.ASSIGNEDOBJECTID + @"' and a.attendancedate >= To_Date('" + item.STARTDATE.Value.ToString("yyyy-MM-dd") + @"', 'yyyy-MM-dd') and a.attendancedate <= To_Date('" + item.ENDDATE.Value.ToString("yyyy-MM-dd") + @"', 'yyyy-MM-dd')"; var attdel = from ent in dal.GetObjects <T_HR_ATTENDANCERECORD>() where ent.OWNERCOMPANYID == entVacRd.ASSIGNEDOBJECTID && ent.ATTENDANCEDATE >= item.STARTDATE && ent.ATTENDANCEDATE <= item.ENDDATE select ent; int i = 0; foreach (var att in attdel) { i = i + dal.Delete(att); } //int i = dal.ExecuteNonQuery(sql); Tracer.Debug("新增假期设置删除设定日期整个公司考勤初始化记录,共删除:" + i.ToString() + " 条数据:转换出的sql" + sql); } catch (Exception ex) { Tracer.Debug("新增假期设置删除设定日期整个公司考勤初始化记录异常:" + ex.ToString()); } } //if (item.DAYTYPE == (Convert.ToInt32(Common.OutPlanDaysType.WorkDay) + 1).ToString()) //{ //如果设置的日期是当月,需要重新初始化公司考勤 if (item.STARTDATE.Value <= DateTime.Now.AddMonths(1).AddDays(-1)) { needInitCompanyAttanceDayAgain = true; strCurYearMonth = item.STARTDATE.Value.Year + "-" + item.STARTDATE.Value.Month; } if (item.ENDDATE.Value <= DateTime.Now.AddMonths(1).AddDays(-1)) { needInitCompanyAttanceDayAgain = true; strCurYearMonth = item.ENDDATE.Value.Year + "-" + item.ENDDATE.Value.Month; } //} #endregion } if (needInitCompanyAttanceDayAgain) { Tracer.Debug("====================================新增假期设置工作日开始初始化整个公司考勤记录"); using (AttendanceSolutionAsignBLL bllAttendanceSolutionAsign = new AttendanceSolutionAsignBLL()) { bllAttendanceSolutionAsign.AsignAttendanceSolutionByOrgID("1", entVacRd.ASSIGNEDOBJECTID, strCurYearMonth); } Tracer.Debug("====================================新增假期设置工作日初始化整个公司考勤记录完毕"); } } } catch (Exception ex) { Tracer.Debug(ex.ToString()); } }