消费机SDK接口

目录1概述 (2)2 函数简述 (2)2.1 Connect (2)2.2 Disconnect (3)2.3 DataQuery (3)2.4 DataCount (4)2.5 DataAppend (5)2.6 DataUpdate (6)2.7 DataDelete (6)2.8 InfoQuery (7)2.9 InfoUpdate (8)2.10 GetRTLog (8)3 表名附件 (9)4 表结构附件 (10)5 设备信息定义 (10)Dataapi接口使用指南（简要）1概述dataapi接口是一组功能函数，使用类似于SQL语句方式访问考勤机中的数据表及设备信息。

相对原有通信接口，dataapi接口提供仅10个函数，使用简单、直观。

提供dataapi接口的commro.dll动态库，依然兼容原有的通信接口。

2 函数简述以下为dataapi接口包含的函数，仅列出了函数名及功能叙述。

参数描述和详细的调用方法，参考提供的demo例程。

2.1 Connect[函数]DLLIMPORT void * __stdcall Connect(const char *Parameters);[功能]连接到设备，连接成功后返回连接的句柄。

[示例]VC：CString szPara ="protocol=HTTP,ipaddress=192.168.1.201,port=80,name=12345,passwd=12345 ";HANDLE h = Connect(szPara);VB：Private Declare Function Connect Lib "commpro.dll" (ByVal Parameters As String) As Long Dim h As Long '连接设备句柄Dim ret As Long '函数返回h =Connect("protocol=HTTP,ipaddress=192.168.1.213,port=80,name=12345,passwd=12345")MsgBox "Connect return =0x" + Hex(h)Java：commpro2java co = new commpro2java();long h =co.Connect("protocol=HTTP,ipaddress=192.168.1.213,port=80,name=12345,passwd=12345 ");System.out.printf("Return Handle = 0x%x\n", h);2.2 Disconnect[函数]DLLIMPORT void__stdcall Disconnect(void* Handle);[功能]断开与设备的连接。

[示例]VC：Disconnect(h);VB：Disconnect (h)Java：co.Disconnect(h);2.3 DataQuery[函数]DLLIMPORT int__stdcall DataQuery(void *Handle, char *Buffer, int BufferSize, const char *TableName, const char *FieldNames, const char *Filter, const char *Options);[功能]根据输入的表名、过滤条件、选项来查询设备中的数据，返回符合条件的记录数。

表名见附件[示例]VC：char *bufOut =(char *)malloc(2 * 1024 *1024); //至少分配K以上，这里分配的是M字节CString strTable = "UserInfo";CString strFields = "*";CString strFilter = "pin<100";CString strOptions = "";ret = DataQuery(h, (char *)bufOut, 2 * 1024 *1024, strTable, strFields, strFilter, strOptions);VB：BufferSize = 204800Buffer = Space(BufferSize)TableName = "UserInfo" '//可选择的表有：UserInfo/ FPTemplate/ Transaction/ OpLog/ Sms/WorkcodeFieldNames = "*" '//“*”为显示全部字段fil = "" '//过滤条件，不填写为没有指定过滤条件Options = ""ret = DataQuery(h, Buffer, BufferSize, TableName, FieldNames, fil, Options)MsgBox "DataQuery return=" + Str$(ret)Print BufferJava：int i = 0;byte[] Buffer = new byte[5 * 1024 * 1024]; //分配M内存for(i = 0; i<5 * 1024 * 1024;i++)Buffer[i] = 0x00; //清空这片内存int BufferSize = Buffer.length;String TableName = "FPTemplate"; '//可选择的表有：UserInfo/ FPTemplate/ Transaction/OpLog/ Sms/ WorkcodeString FieldNames = "*"; //“*”为显示全部字段String Filter = ""; //出现中文时，使用 Filter.getBytes(“gb2312”) 传递参数String Options = "";int len = co.DataQuery(h, Buffer, BufferSize, TableName.getBytes(), FieldNames.getBytes(), Filter.getBytes(), Options.getBytes());String szBuffer = new String(Buffer);int nNull = szBuffer.indexOf(0)+1; //找到第一个'\0'的位置，重新构造一个串String szRet = new String(Buffer, 0, nNull);System.out.println(szRet);2.4 DataCount[函数]DLLIMPORT int__stdcall DataCount(void*Handle, const char*TableName, const char *Filter, const char *Options);[功能]根据输入的表名、过滤条件来查询设备中的数据记录数。

[示例]VC：CString strTable = "UserInfo";CString strFilter = "pin<100";CString strOptions = "";ret = dataCount(h, strTable, strFilter, strOptions);VB：TableName = "UserInfo"fil = ""Options = ""ret = DataCount(h, TableName, fil, Options)MsgBox "DataCount return=" + Str$(ret)Java：TableName = "UserInfo";Filter = ""; //出现中文时，使用 Filter.getBytes(“gb2312”) 传递参数Options = "";len = co.DataCount(h, TableName.getBytes(), Filter.getBytes(), Options.getBytes());System.out.printf("DataCount Return = %d\n", len);2.5 DataAppend[函数]DLLIMPORT int__stdcall DataAppend(void *Handle, const char *TableName, const char*Datas, const char *Options);[功能]增加数据到设备中,返回设备成功新增的数据记录数[示例]VC：CString strTable = "UserInfo";CString strPost = "PIN=2111\r\nPIN=2112\tname=www\r\nPIN=2113";//在代码中要明确的使用”\r\n”及”\r”CString strOptions = "";ret = dataAppend(h, strTable, strPost, strOptions);VB：TableName = "UserInfo"Options = ""Datas = "PIN=2111" + vbTab + "name=ixie" + vbCrLf + "PIN=2113" + vbCrLf + "PIN=2112"ret = DataAppend(h, TableName, Datas, Options)MsgBox "DataAppend return=" + Str$(ret)Java：TableName = "UserInfo";Options = "";String Datas = "PIN=2111\r\nPIN=2112\r\nPIN=2113"; //出现中文时，使用// Datas.getBytes(“gb2312”) 传递参数len = co.DataAppend(h, TableName .getBytes(), Datas .getBytes(), Options .getBytes());System.out.printf("DataAppend Return = %d\n", len);2.6 DataUpdate[函数]DLLIMPORT int__stdcall DataUpdate(void *Handle, const char *TableName, const char*DataValues, const char *Filter, const char *Options);[功能]更新设备中的表的数据[示例]VC：CString strTable = "UserInfo";CString strPost = "name=xyz";CString strFilter = "pin<100";//将用户表中pin<100的用户的姓名，更改为xyzCString strOptions = "";ret = dataUpdate(h, strTable, strPost, strFilter, strOptions); //VB：TableName = "UserInfo"fil = "pin<100" '//过滤条件Options = ""DataValues = "name=xyz"ret = DataUpdate(h, TableName, DataValues, fil, Options)MsgBox "DataUpdate return=" + Str$(ret)Java：TableName = "UserInfo";Filter = "pin<2111";Options = "";String DataValues = "name=xyz"; //出现中文时，使用 DataValues.getBytes(“gb2312”) 传递参数len = co.DataUpdate(h, TableName.getBytes(), DataValues.getBytes(), Filter.getBytes(), Options.getBytes());System.out.printf("DataUpdate Return = %d\n", len);2.7 DataDelete[函数]DLLIMPORT int__stdcall DataDelete(void*Handle, const char*TableName,const char*Filter, const char *Options );[功能]根据表名、过滤条件及选项，删除设备中的表的数据。