private bool SaveFpDataToDB(byte[] FpData)
{
List <string> sql = new List <string>();
byte[] buff = new byte[1680];
byte[] FpDataConv = new byte[1680];
byte[] header = { 0x45, 0x4e, 0x52, 0x4f, 0x4c, 0x4c, 0x46, 0x50, 0x01, 0x28 };
Array.Copy(header, 0, FpDataConv, 0, header.Length); //Add Fixed Header
Array.Copy(FpData, 0, FpDataConv, 80, FpData.Length);
ObjFpReader.ConvEnrollData(FpDataConv, ref buff, 1680);
//Update RS_Emp、VRS_EmpFingerInfo Table
string EmpNo = txtEmpNo.Text;
string EnrollNumber = txtFingerNo.Text;
string BackupNumber = fpDataList.Count.ToString();
int EmpFingerCount = fpDataList.Count + 1;
try
{
sql.Add("UPDATE RS_Emp SET EmpFingerCount=" + EmpFingerCount.ToString() + " WHERE EmpNo='" + EmpNo + "'");
sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "204", SystemInfo.MacTypeID.ToString(),
EnrollNumber, fpDataList.Count.ToString(), "NULL" }));
if (SystemInfo.db.ExecSQL(sql) == 0)
{
SystemInfo.db.UpdateByteData(Pub.GetSQL(DBCode.DB_000300, new string[] { "202", SystemInfo.MacTypeID.ToString(),
EnrollNumber, BackupNumber }), "FingerData", buff);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
private bool GetDbFingerData(string EmpNo, string FingerNo)
{
fpDataList.Clear();
string sql = "SELECT * FROM VRS_EmpFingerInfo WHERE EmpNo='" + EmpNo + "' AND FingerBkNo BETWEEN 0 AND 9 ORDER BY FingerBkNo";
DataTable dt = new DataTable();
try
{
dt = SystemInfo.db.GetDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
byte[] buff = (byte[])dt.Rows[i]["FingerData"];
byte[] buffConv = new byte[1680];
byte[] fpdata = new byte[1600];
ObjFpReader.ConvEnrollData(buff, ref buffConv, 1680);
Array.Copy(buffConv, 80, fpdata, 0, 1600);
fpDataList.Add(fpdata);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
