public static void WriteTextLog(string log) { string filename = string.Format(LogFilePath, LogMessageDAL.GetLogTableSuffix()); try { lock (m_lockLogFileObj1) { if (!File.Exists(filename)) { string dirPath = filename.Remove(filename.LastIndexOf("\\") + 1); if (!Directory.Exists(dirPath)) { Directory.CreateDirectory(dirPath); } } File.AppendAllText(filename, string.Format(@"-----------------------------------------{1}-----------------------------------------{0}{2}{0}", Environment.NewLine, DateTime.Now.ToString(), log)); } } catch { } }
private int Insert(LogMessage log) { int ret = 0; string tableName = ""; try { tableName = "dbo.tbl_Interface_ProcessLog"; if (log.IsHandle) { tableName = "dbo.tbl_Interface_HandleLog"; } tableName = string.Format("{0}{1}", tableName, LogMessageDAL.GetLogTableSuffix()); string sql = string.Format(@"insert into {0}(IKey, Username, LogTime, ClientIP, ServerIP, Module, Keyword, OrderNo, LogType, Content) values (@IKey, @Username, @LogTime, @ClientIP, @ServerIP, @Module, @Keyword, @OrderNo, @LogType, @Content)", tableName); List <DbParameter> paraList = new List <DbParameter>(); AddParameter(paraList, "@IKey", log.Ikey); AddParameter(paraList, "@Username", log.Username); AddParameter(paraList, "@LogTime", log.LogTime); AddParameter(paraList, "@ClientIP", log.ClientIP); AddParameter(paraList, "@ServerIP", log.ServerIP); AddParameter(paraList, "@Module", log.Module); AddParameter(paraList, "@Keyword", log.Keyword); AddParameter(paraList, "@OrderNo", log.OrderNo); AddParameter(paraList, "@LogType", log.LogType); AddParameter(paraList, "@Content", log.Content); ret = DbHelper.ExecuteNonQuery(DatabaseEnum.Log4Net_CMD, CommandType.Text, sql, paraList.ToArray()); } catch (Exception ex) { //丢弃日志 Logger.Fatal(string.Format("往{0}表插入数据出现严重错误,{1}", tableName, log.ToString()), ex); } return(ret); }