private static int InsertDataTo(AttendFingerPrintDataInTimeModel entity)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO Attendance_FingerPrintDataInTimeBackup (WorkerId,WorkerName,CardID,CardType,SlodCardTime,SlodCardDate)");
sb.AppendFormat(" values ('{0}',", entity.WorkerId);
sb.AppendFormat("'{0}',", entity.WorkerName);
sb.AppendFormat("'{0}',", entity.CardID);
sb.AppendFormat("'{0}',", entity.CardType);
sb.AppendFormat("'{0}',", entity.SlodCardTime);
sb.AppendFormat("'{0}')", entity.SlodCardDate);
return(DbHelper.Hrm.ExecuteNonQuery(sb.ToString()));
}
private AttendSlodFingerDataCurrentMonthModel CreateAttendDataModel(AttendFingerPrintDataInTimeModel attendTimeMdl, ArWorkerInfo worker, DateTime slodCardTime)
{
var mdl = new AttendSlodFingerDataCurrentMonthModel()
{
AttendanceDate = attendTimeMdl.SlodCardDate,
WorkerId = worker.WorkerId,
CardID = attendTimeMdl.CardID,
CardType = attendTimeMdl.CardType,
ClassType = worker.ClassType,
Department = worker.Department,
WorkerName = worker.Name,
WeekDay = attendTimeMdl.SlodCardDate.DayOfWeek.ToString().ToChineseWeekDay(),
LeaveHours = 0,
LeaveMark = 0,
YearMonth = slodCardTime.ToString("yyyyMM"),
SlotCardTime = slodCardTime.ToString("HH:mm"),
HandleSlotExceptionStatus = 0,
SlotExceptionMark = 0,
OpSign = "init",
OpPerson = "system",
};
return(mdl);
}
/// <summary>
/// 初次插入数据
/// </summary>
/// <param name="attendTimeMdl"></param>
/// <param name="worker"></param>
/// <param name="slodCardTime"></param>
/// <returns></returns>
private int InitAttendData(AttendFingerPrintDataInTimeModel attendTimeMdl, ArWorkerInfo worker, DateTime slodCardTime, out AttendSlodFingerDataCurrentMonthModel initMdl, DateTime middleTime)
{
initMdl = null;
int record = 0;
var mdl = CreateAttendDataModel(attendTimeMdl, worker, slodCardTime);
//首次赋值需要加中间判定时间
if (slodCardTime > middleTime)
{
mdl.SlotCardTime2 = slodCardTime.ToString("yyyy-MM-dd HH:mm");
}
else
{
mdl.SlotCardTime1 = slodCardTime.ToString("yyyy-MM-dd HH:mm");
}
record = irep.Insert(mdl);
if (record == 1)
{
initMdl = CreateAttendDataModel(attendTimeMdl, worker, slodCardTime);
initMdl.Id_Key = mdl.Id_Key;
initMdl.SlotCardTime1 = mdl.SlotCardTime1;
}
return(record);
}
public int StoreNoIdentityWorkerInfo(AttendFingerPrintDataInTimeModel entity)
{
return(this.irep.StoreNoIdentityWorkerInfo(entity));
}
){kind=link}