我有一个数所表(Table1),该表是用于存储公司员工的上下班的刷卡记录.
该表的结构如下:
FiledName DataType
--------------------------
EmpNo char(8)
riqi int(4)
BC_IC smallint(2)
NBC smallint(2)
flag smallint(2)
CDATA binary(68)
Card binary(72)
Analysis binary(32)
我使用探查器跟踪到查询工号为010123的从2008-12-01至2008-12-05这五天的刷卡记录,跟踪到如下SQL语名:
select * from Attend where EmpNo='010123' and riqi<=39787 and riqi>=39783 order by riqi我在SQL查询分析器中执行的结果如下:(格式有点乱, 所以我只复制第一条记录出来^^)我现在想知道的时,如何从下在的数据中得到我想要的日期和刷卡时间?EmpNo: 010123
riqi:39783
BC_ID:3
NBC:32766
flag:388
CDATA:0x3E03CE040700070008000000780508070700070008000
0006C078A070700D0020D00000000000000000000000000
00000000000000000000000000000000000000000000
Card:0x420312CE04137805220F0723320E000F27000F27000F27
000F27000F27000F27000F27000F27000F27000F27000F27
000F27000F27000F27000F27000F27000F27000F27000F2700
Analysis:0xE00100000000000000000000000000004203CE0478050F070F270F27FF7FFF7F
该表的结构如下:
FiledName DataType
--------------------------
EmpNo char(8)
riqi int(4)
BC_IC smallint(2)
NBC smallint(2)
flag smallint(2)
CDATA binary(68)
Card binary(72)
Analysis binary(32)
我使用探查器跟踪到查询工号为010123的从2008-12-01至2008-12-05这五天的刷卡记录,跟踪到如下SQL语名:
select * from Attend where EmpNo='010123' and riqi<=39787 and riqi>=39783 order by riqi我在SQL查询分析器中执行的结果如下:(格式有点乱, 所以我只复制第一条记录出来^^)我现在想知道的时,如何从下在的数据中得到我想要的日期和刷卡时间?EmpNo: 010123
riqi:39783
BC_ID:3
NBC:32766
flag:388
CDATA:0x3E03CE040700070008000000780508070700070008000
0006C078A070700D0020D00000000000000000000000000
00000000000000000000000000000000000000000000
Card:0x420312CE04137805220F0723320E000F27000F27000F27
000F27000F27000F27000F27000F27000F27000F27000F27
000F27000F27000F27000F27000F27000F27000F27000F2700
Analysis:0xE00100000000000000000000000000004203CE0478050F070F270F27FF7FFF7F
DateTime baseDate = new DateTime(1900, 1, 1); //<---
DateTime date = baseDate.AddDays(39783); //<---
MessageBox.Show(date.ToString());
byte[]转换回int
int iCount = BitConverter.ToInt32(byInputData, 0);