private static void Write(LogLevel.LogLevelInfo logLevel, String tag, String message)
{
try
{
if (tag == "KHOIVV")
{
//Insert database
SanitaDataLogModel log = new SanitaDataLogModel();
log.App = LogName;
log.User = LogUser;
log.LogTime = SystemInfo.NOW;
log.LogValue = GetLogFormatString(logLevel, tag, message);
log.SoftVersion = LogVersion;
log.ComputerName = Sanita.Utility.SystemInfo.ComputerName;
log.IPAddress = Sanita.Utility.SystemInfo.IPAddress;
QueueLogRecord.Enqueue(log);
}
else
{
if (!String.IsNullOrEmpty(LogName))
{
//Filter
String data = message.Trim();
data = data.ToUpper();
data = data.Replace("INSERT INTO", "");
data = data.Replace("UPDATE", "");
data = data.Replace("DELETE FROM", "");
data = data.Trim();
String table_name = data.Split(' ')[0];
if (!TableLogFilter.Contains(table_name.ToLower()))
{
return;
}
#if false
if ((table_name.ToLower() == "sothutuphongkham" || table_name.ToLower() == "sothutubenhpham") && SystemInfo.NOW > new DateTime(2015, 02, 01))
{
return;
}
#endif
//Insert database
SanitaDataLogModel log = new SanitaDataLogModel();
log.App = LogName;
log.User = LogUser;
log.LogTime = Sanita.Utility.SystemInfo.NOW;
log.ComputerName = Sanita.Utility.SystemInfo.ComputerName;
log.IPAddress = Sanita.Utility.SystemInfo.IPAddress;
log.LogValue = GetLogFormatString(logLevel, tag, message);
log.SoftVersion = LogVersion;
QueueLogRecord.Enqueue(log);
}
}
}
catch (Exception ex)
{
}
}
private static void bwAsync_Worker(object sender, DoWorkEventArgs e)
{
while (true)
{
System.Threading.Thread.Sleep(300);
try
{
if (QueueLogRecord.Count > 0)
{
SanitaDataLogModel result = QueueLogRecord.Dequeue();
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO tblLogData (");
sql.Append(" LogApp,");
sql.Append(" LogUser,");
sql.Append(" SoftVersion,");
sql.Append(" LogTime,");
sql.Append(" IPAddress,");
sql.Append(" ComputerName,");
sql.Append(" LogValue) ");
sql.Append(" VALUES( " + DatabaseUtility.Escape(result.App) + ", ");
sql.Append(" " + DatabaseUtility.Escape(result.User) + ", ");
sql.Append(" " + DatabaseUtility.Escape(result.SoftVersion) + ", ");
sql.Append(" " + DatabaseUtility.Escape(result.LogTime) + ", ");
sql.Append(" " + DatabaseUtility.Escape(result.IPAddress) + ", ");
sql.Append(" " + DatabaseUtility.Escape(result.ComputerName) + ", ");
sql.Append(" " + DatabaseUtility.Escape(result.LogValue) + ") ");
// Assign new customer Id back to business object
baseDAO.DoInsert(sql.ToString());
}
}
catch (Exception ex)
{
}
}
}
