考勤记录 [英] Time n attendance records

问题描述

我目前正在做时间&出勤项目.就像当我单击下载按钮时，代码和dll与出勤阅读器进行通信并以以下格式(sql)获取数据，

Hi ,

I''m currently doing a time & attendance project. its like when i click the download button, the code and dlls communicates with the attendance reader and fetches the datas in the following format(sql) ,

empCode in/outMode  date          time
5001        0       12/09/2011    09:05:34
5002        0       12/09/2011    09:33:13
5001        1       12/09/2011    18:05:09
5002        1       12/09/2011    17:44:34

其中，在输入/输出模式下，o是intime，1是outtime.

我想在每位员工的单个记录中显示这些数据.也就是说，我想显示以下内容(假设我创建了一个新表，如下所示)，

where , in the in/out mode , o is the intime and 1 is the outtime.

i want to show these datas in a single record for each employees. that is , i want to show somethng like the following , (assume that i created a new table as below) ,

empCode  date        intime      outtime
5001     12/09/2011  09:05:34    18:05:09
5002     12/09/2011  09:33:13    17:44:34

我该怎么办?..任何人都可以引导我吗?...

How do i do that?.. can anyone pls guide me?...

推荐答案

当您阅读每条记录时，将进出时间存储在由索引的结构中empCode.然后，当您拥有所有数据时，只需通读数据并以所需的格式打印即可.我知道听起来很明显，但也许您的问题需要澄清.

As you read each record store the in and out times in a structure indexed by empCode. Then when you have all the data just read through it and print in the format you want. I know that sounds obvious but maybe your question needs clarification.

这篇关于考勤记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！