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