private int ImportDate(DataTable dt)
{
List <Employee> employeeList = new List <Employee>();
DateTime dt_Now = DateTime.Now;
//Employee employee
for (int i = 0; i < dt.Rows.Count; i++)
{
_Name = GetItem(dt, i, _NameColumn);
if (string.IsNullOrEmpty(_Name))
{
continue;
}
Employee employee = employeeList.Find(FindEmployee);
if (employee == null)
{
Account account = _IAccountBll.GetAccountByName(_Name);
//如果系统里没有该员工或者该员工在系统中没有门禁卡卡号
if (account == null)
{
continue;
}
employee = getEmployee.GetEmployeeAttendenceInfoByAccountID(account.Id);
if (employee == null)
{
continue;
}
if (string.IsNullOrEmpty(employee.EmployeeAttendance.DoorCardNo))
{
continue;
}
employee.EmployeeAttendance.AttendanceInAndOutRecordList = new List <AttendanceInAndOutRecord>();
employeeList.Add(employee);
}
AttendanceInAndOutRecord attendanceInAndOutRecord = new AttendanceInAndOutRecord();
attendanceInAndOutRecord.IOStatus = GetInOutStatusByInOutName(GetItem(dt, i, _InOutColumn));
try
{
var date = Convert.ToDateTime(GetItem(dt, i, _DateColumn));
DateTime time;
if (DateTime.TryParse(GetItem(dt, i, _TimeColumn), out time))
{
attendanceInAndOutRecord.IOTime = new DateTime(date.Year, date.Month, date.Day, time.Hour, time.Minute, time.Second);
}
else
{
attendanceInAndOutRecord.IOTime = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + GetItem(dt, i, _TimeColumn));
}
}
catch
{
continue;
}
attendanceInAndOutRecord.OperateStatus = OutInRecordOperateStatusEnum.ImportByOperator;
attendanceInAndOutRecord.OperateTime = dt_Now;
//判断读取中是否有重复记录 add by liudan 2009-09-19
List <AttendanceInAndOutRecord> sqlRecords =
attendanceInAndOutRecordDal.GetAttendanceInAndOutRecordByCondition(employee.Account.Id,
employee.EmployeeAttendance.
DoorCardNo,
Convert.ToDateTime("1900-12-31"),
Convert.ToDateTime("2999-12-31"),
InOutStatusEnum.All,
OutInRecordOperateStatusEnum.All,
Convert.ToDateTime("1900-12-31"),
Convert.ToDateTime("2999-12-31"));
bool isFind = false;
foreach (AttendanceInAndOutRecord records in sqlRecords)
{
if (attendanceInAndOutRecord.IOStatus.Equals(records.IOStatus) &&
attendanceInAndOutRecord.IOTime.Equals(records.IOTime))
{
isFind = true;
}
}
if (!isFind)
{
employee.EmployeeAttendance.AttendanceInAndOutRecordList.Add(attendanceInAndOutRecord);
count = count + 1;
}
}
attendanceInAndOutRecordDal.InsertAttendanceInAndOutRecordList(employeeList);
return(employeeList.Count);
}