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