public string UpdateWorkerAttandence(IList <CV_PM_EM_RECATTANDENCE> param)
{
try
{
foreach (var item in param)
{
string sql = " select * from PM_EM_TS_EMPLOYEE where TimesheetEmployeeGuid!='" + item.TimesheetEmployeeGuid.ToString() + "' and EmployeeGuid='" + item.EmployeeGuid.ToString() +
@"' and StartTime>'" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + " 00:00:00' and StartTime<'" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + " 23:59:59' ";
DataTable dt = co_BSC_BO.GetDataTableBySql(sql);
if (dt != null)
{
return("已经录入了" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + "的信息,不可重复录入！");
}
PM_EM_TS_EMPLOYEE tsEmployeeModel = new PM_EM_TS_EMPLOYEE();
tsEmployeeModel = saveEmpAttData(item);
tsEmployeeModel.TimesheetEmployeeGuid = item.TimesheetEmployeeGuid;
tsEmployeeModel.TimesheetTeamGuid = item.TeamGuid;
//更新数据或者修改数据
tsEmployeeBO.UpdateSome(tsEmployeeModel);
}
return("更新成功！");
}
catch (Exception ex)
{
return("系统异常：" + ex.Message);
}
}
public string RecordWorkerAttandence(IList <CV_PM_EM_RECATTANDENCE> param)
{
try
{
foreach (var item in param)
{
string sql = " select * from PM_EM_TS_EMPLOYEE where EmployeeGuid='" + item.EmployeeGuid.ToString() +
@"' and StartTime>'" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + " 00:00:00' and StartTime<'" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + " 23:59:59' ";
DataTable dt = co_BSC_BO.GetDataTableBySql(sql);
if (dt != null)
{
return("已经录入了" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + "的信息,不可重复录入！");
}
PM_EM_TS_EMPLOYEE tsEmployeeModel = new PM_EM_TS_EMPLOYEE();
tsEmployeeModel = saveEmpAttData(item);
tsEmployeeModel.TimesheetEmployeeGuid = Guid.NewGuid();
tsEmployeeModel.TimesheetTeamGuid = item.TeamGuid; //需要修改为真实的班组guid
tsEmployeeModel.EmployeeGuid = item.EmployeeGuid; //需要修改为真实的员工GUID
//tsEmployeeModel.EntryDate = item.EntryTime;//需要修改为真实的入厂时间
tsEmployeeModel.PositionGuid = item.PositionGuid;
//插入数据或者修改数据
tsEmployeeBO.Insert(tsEmployeeModel);
}
return("录入成功！");
}
catch (Exception ex)
{
return("系统异常：" + ex.Message);
}
}
/// <summary>
/// 保存需要更新的考勤数据
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
private PM_EM_TS_EMPLOYEE saveEmpAttData(CV_PM_EM_RECATTANDENCE item)
{
PM_EM_TS_EMPLOYEE tsEmployeeModel = new PM_EM_TS_EMPLOYEE();
//上班出勤-赋值
tsEmployeeModel.StartTime = item.StartTime;
tsEmployeeModel.EndTime = item.EndTime;
tsEmployeeModel.StartNote = item.StartNote;
tsEmployeeModel.AttendanceRestTime = item.AttendanceRestTime;
tsEmployeeModel.Shift = item.Shift;
//加班出勤-赋值
tsEmployeeModel.WorkoverStartTime = item.WorkoverStartTime;
tsEmployeeModel.WorkoverEndTime = item.WorkoverEndTime;
tsEmployeeModel.WorkoverType = item.WorkoverType;
tsEmployeeModel.WorkoverRestTime = item.WorkoverRestTime;
tsEmployeeModel.WorkoverNote = item.WorkoverNote;
//请假工时-赋值
tsEmployeeModel.LeaveTime = item.LeaveTime;
tsEmployeeModel.LeaveType = item.LeaveType;
tsEmployeeModel.LeaveNote = item.LeaveNote;
//调休工时-赋值
tsEmployeeModel.ShiftLeaveTime = item.ShiftLeaveTime;
tsEmployeeModel.ShiftLeaveType = item.ShiftLeaveType;
tsEmployeeModel.ShiftLeaveNote = item.ShiftLeaveNote;
//迟到工时-赋值
tsEmployeeModel.ToBeLateTime = item.ToBeLateTime;
tsEmployeeModel.ToBeLateType = item.ToBeLateType;
tsEmployeeModel.ToBeLateNote = item.ToBeLateNote;
//旷工工时-赋值
tsEmployeeModel.AbsenteeismTime = item.AbsenteeismTime;
tsEmployeeModel.AbsenteeismType = item.AbsenteeismType;
tsEmployeeModel.AbsenteeismNote = item.AbsenteeismNote;
tsEmployeeModel.CreatedOn = SSGlobalConfig.Now;
return(tsEmployeeModel);
}
