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); } }