public List <CheckinRecord> GetNewCheckinRecord()
{
List <CheckinRecord> records = new List <CheckinRecord>();
int length = GetLength();
int record_count = length / SINGE_CHECKIN_RECORD_LENGTH;
string file_content = ReadFile();
for (int position = 0; position < record_count * SINGE_CHECKIN_RECORD_LENGTH;)
{
CheckinRecord record = new CheckinRecord();
Staff staff = new Staff();
staff.CardID = file_content.Substring(position, CARDID_LENGTH);
position += CARDID_LENGTH;
record.CheckinTime = file_content.Substring(position, CHECKIN_TIME_LENGTH);
position += CHECKIN_TIME_LENGTH;
staff.SetInfoByCardID();
record.staff = staff;
records.Add(record);
}
return(records);
}
/// <summary>
/// 获得全部考勤信息
/// </summary>
/// <returns></returns>
public List <CheckinRecord> GetAllRecords()
{
List <CheckinRecord> records = new List <CheckinRecord>();
string cmd_str = "SELECT checkin_time, " +
"checkin_record.card_id as card_id, " +
"department.name as department_name," +
"staff.`name` as staff_name " +
"FROM checkin_record, staff, department " +
"where staff.card_id = checkin_record.card_id and staff.department_id = department.id"; //sql语句
DataTable dataTable = SelectSql(cmd_str); //执行sql语句，获得返回结果
foreach (DataRow row in dataTable.Rows)
{
CheckinRecord record = new CheckinRecord();
record.CheckinTime = row["checkin_time"].ToString();
record.staff.CardID = row["card_id"].ToString();
record.staff.DepartmentName = row["department_name"].ToString();
record.staff.Name = row["staff_name"].ToString();
records.Add(record);
}
return(records);
}
