public List <AttendanceInAndOutRecord> GetEmployeeInAndOutRecordByCondition(int employeeID, string employeeName, int departmentID, string doorCardNo, DateTime iOTimeFrom, DateTime iOTimeTo, InOutStatusEnum iOStatus, OutInRecordOperateStatusEnum operateStatus, DateTime operateTimeFrom, DateTime operateTimeTo, Account loginUser) { return(new AttendanceOutInRecord(loginUser).GetEmployeeInAndOutRecordByCondition(employeeID, employeeName, departmentID, doorCardNo, iOTimeFrom, iOTimeTo, iOStatus, operateStatus, operateTimeFrom, operateTimeTo)); }
public static string GetOutInRecordOperateNameByOutInRecordOperateStatus(OutInRecordOperateStatusEnum outInRecordOperateStatusEnum) { switch (outInRecordOperateStatusEnum) { case OutInRecordOperateStatusEnum.AddByOperator: return("新增"); case OutInRecordOperateStatusEnum.ModifyByOperator: return("修改"); case OutInRecordOperateStatusEnum.ReadFromDataBase: return("从ACCESS导入"); case OutInRecordOperateStatusEnum.ImportByOperator: return("从XLS导入"); default: return(""); } }
/// <summary> /// 用于查询某个员工更多信息 /// </summary> public List <AttendanceInAndOutRecord> GetEmployeeInAndOutRecordByCondition(int employeeID, string employeeName, int departmentID, string doorCardNo, DateTime iOTimeFrom, DateTime iOTimeTo, InOutStatusEnum iOStatus, OutInRecordOperateStatusEnum operateStatus, DateTime operateTimeFrom, DateTime operateTimeTo) { List <Account> accountList = _IAccountBll.GetAccountByBaseCondition(employeeName, departmentID, -1, null, true, null); if (departmentID == -1) { accountList = Tools.RemoteUnAuthAccount(accountList, AuthType.HRMIS, _LoginUser, HrmisPowers.A504); } List <AttendanceInAndOutRecord> records = _dalAttendanceInAndOutRecord.GetAttendanceInAndOutRecordByCondition(employeeID, doorCardNo, iOTimeFrom, iOTimeTo, iOStatus, operateStatus, operateTimeFrom, operateTimeTo); for (int i = records.Count - 1; i >= 0; i--) { Account temp = Tools.FindAccountById(accountList, records[i].EmployeeId); if (temp == null) { records.RemoveAt(i); } else { records[i].EmployeeName = temp.Name; } } return(records); }
public List <AttendanceInAndOutRecord> GetAttendanceInAndOutRecordByCondition(int employeeID, string doorCardNo, DateTime iOTimeFrom, DateTime iOTimeTo, InOutStatusEnum iOStatus, OutInRecordOperateStatusEnum operateStatus, DateTime operateTimeFrom, DateTime operateTimeTo) { List <AttendanceInAndOutRecord> records = new List <AttendanceInAndOutRecord>(); SqlCommand sqlCommmand = new SqlCommand(); sqlCommmand.Parameters.Add(_EmployeeId, SqlDbType.Int).Value = employeeID; sqlCommmand.Parameters.Add(_IOTimeStart, SqlDbType.DateTime).Value = iOTimeFrom; sqlCommmand.Parameters.Add(_IOTimeEnd, SqlDbType.DateTime).Value = iOTimeTo; sqlCommmand.Parameters.Add(_IOStatus, SqlDbType.Int).Value = iOStatus; sqlCommmand.Parameters.Add(_OperateStatus, SqlDbType.Int).Value = operateStatus; sqlCommmand.Parameters.Add(_OperateTimeStart, SqlDbType.DateTime).Value = operateTimeFrom; sqlCommmand.Parameters.Add(_OperateTimeEnd, SqlDbType.DateTime).Value = operateTimeTo; sqlCommmand.Parameters.Add(_DoorCardNo, SqlDbType.NVarChar, 50).Value = doorCardNo; using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetEmployeeInAndOutByCondition", sqlCommmand)) { while (sdr.Read()) { AttendanceInAndOutRecord record = new AttendanceInAndOutRecord(); record.RecordID = (Int32)sdr[_DBRecordID]; record.EmployeeId = (Int32)sdr[_DBEmployeeId]; record.DoorCardNo = sdr[_DBDoorCardNo].ToString(); record.IOStatus = (InOutStatusEnum)sdr[_DBIOStatus]; record.IOTime = Convert.ToDateTime(sdr[_DBIOTime]); record.OperateStatus = (OutInRecordOperateStatusEnum)sdr[_DBOperateStatus]; record.OperateTime = Convert.ToDateTime(sdr[_DBOperateTime]); records.Add(record); } } return(records); }