2001-03-01 00:00:00.000 2005-03-03 00:00:00.000 work 2005-07-15 00:00:00.000 2008-11-04 00:00:00.000 work 2009-04-23 00:00:00.000 9999-12-31 00:00:00.000 work 2000-02-01 00:00:00.000 2004-06-08 00:00:00.000 study 2004-05-13 00:00:00.000 2008-10-28 00:00:00.000 study 2009-05-13 00:00:00.000 9999-12-31 00:00:00.000 study
数据已经是在dataset中处理的,与数据库无关.
表名:Table_WorkStudy 员工工号:badge 开始时间列名:starttime 结束时间列明:endtime 类型:type 思路:select badge,starttime,endtime,type from Table_WorkStudy order by badge,starttime存储在DataSet中的Tables[0]中然后分别判断每个员工的时间
2005-07-15 00:00:00.000 2008-11-04 00:00:00.000 work
2009-04-23 00:00:00.000 9999-12-31 00:00:00.000 work
2000-02-01 00:00:00.000 2004-06-08 00:00:00.000 study
2004-05-13 00:00:00.000 2008-10-28 00:00:00.000 study
2009-05-13 00:00:00.000 9999-12-31 00:00:00.000 study
员工工号:badge
开始时间列名:starttime
结束时间列明:endtime
类型:type
思路:select badge,starttime,endtime,type from Table_WorkStudy order by badge,starttime存储在DataSet中的Tables[0]中然后分别判断每个员工的时间