/// <summary>
/// 增加到报警纪录
/// </summary>
/// <param name="objAuditRecord"></param>
private static void AddAlertDB(AuditRecord objAuditRecord)
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=..\\..\\mdb\\AlertRecord.mdb";
string strDBInfo = String.Format("insert into t_AlertRecord ([UserNmer],[OperationNumer],[UserName],[StartTime],[OperationType],[OperationReason]) values ('{0}','{1}','{2}','{3}','{4}','{5}')", objAuditRecord.m_strUserNum, objAuditRecord.m_strOperationNum, objAuditRecord.m_strUserName, objAuditRecord.m_strStartTime, objAuditRecord.m_strOperationType, objAuditRecord.m_strOperationReason);
TOCTest.db.dbMrg.AlterDB(strConnection, strDBInfo);
}
private static void dealAuditRecord(byte[] readBuffer)
{
AuditRecord objAuditRecord = new AuditRecord();
int mK = 0;
objAuditRecord.m_strUserNum = readBuffer[mK + 6].ToString();
objAuditRecord.m_strOperationNum = readBuffer[mK + 7].ToString();
for (int i = 0; i < 16; i++)
{
string temp = ((char)readBuffer[mK + 9 + i]).ToString();
if (temp != "\0")
{
objAuditRecord.m_strUserName = objAuditRecord.m_strUserName + temp;
}
}
objAuditRecord.m_strStartTime = "20" + readBuffer[24].ToString("D2") + "-" + readBuffer[25].ToString("D2") + "-" + readBuffer[26].ToString("D2") + " " + readBuffer[27].ToString("D2") + ":" + readBuffer[28].ToString("D2");
for (int i = 0; i < 32; i++)
{
string temp = ((char)readBuffer[mK + 29 + i]).ToString();
if (temp != "\0")
{
objAuditRecord.m_strOperationType = objAuditRecord.m_strOperationType + temp;
}
}
for (int i = 0; i < 32; i++)
{
string temp = ((char)readBuffer[mK + 61 + i]).ToString();
if (temp != "\0")
{
objAuditRecord.m_strOperationReason = objAuditRecord.m_strOperationReason + temp;
}
}
AddAlertDB(objAuditRecord);
}