/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XCLCMS.Data.Model.SysLog model)
{
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("sp_SysLog_ADD");
db.AddOutParameter(dbCommand, "SysLogID", DbType.Int64, 8);
db.AddInParameter(dbCommand, "LogLevel", DbType.AnsiString, model.LogLevel);
db.AddInParameter(dbCommand, "LogType", DbType.AnsiString, model.LogType);
db.AddInParameter(dbCommand, "RefferUrl", DbType.AnsiString, model.RefferUrl);
db.AddInParameter(dbCommand, "Url", DbType.AnsiString, model.Url);
db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code);
db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
db.AddInParameter(dbCommand, "Contents", DbType.AnsiString, model.Contents);
db.AddInParameter(dbCommand, "ClientIP", DbType.AnsiString, model.ClientIP);
db.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
db.AddInParameter(dbCommand, "FK_MerchantID", DbType.Int64, model.FK_MerchantID);
db.AddInParameter(dbCommand, "FK_MerchantAppID", DbType.Int64, model.FK_MerchantAppID);
db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
db.AddOutParameter(dbCommand, "ResultCode", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "ResultMessage", DbType.String, 1000);
db.ExecuteNonQuery(dbCommand);
var result = XCLCMS.Data.DAL.Common.Common.GetProcedureResult(dbCommand.Parameters);
if (result.IsSuccess)
{
return(true);
}
else
{
throw new Exception(result.ResultMessage);
}
}
public void WriteLog(LogModel model)
{
XCLNetLogger.Log.WriteLog(new XCLNetLogger.Model.LogModel()
{
ClientIP = model.ClientIP,
Code = model.Code,
Contents = model.Contents,
CreateTime = model.CreateTime,
LogLevel = (XCLNetLogger.Config.LogConfig.LogLevel)((int)model.LogLevel),
LogType = model.LogType,
RefferUrl = model.RefferUrl,
Remark = model.Remark,
Title = model.Title,
Url = model.Url
});
var m = new XCLCMS.Data.Model.SysLog();
m.ClientIP = model.ClientIP;
m.Code = model.Code;
m.Contents = model.Contents;
m.CreateTime = model.CreateTime;
m.LogLevel = model.LogLevel.ToString();
m.
}
/// <summary>
/// 写日志
/// </summary>
public static void WriteLog(XCLCMS.Data.Model.SysLog model)
{
try
{
var context = Log.GetContext();
if (null == model.ClientIP)
{
model.ClientIP = context.ClientIP;
}
model.FK_MerchantID = context.MerchantID;
model.FK_MerchantAppID = context.MerchantAppID;
if (null == model.RefferUrl)
{
model.RefferUrl = HttpContext.Current?.Request?.UrlReferrer?.AbsoluteUri;
}
if (null == model.Url)
{
model.Url = HttpContext.Current?.Request?.Url?.AbsoluteUri;
}
var request = XCLCMS.Lib.WebAPI.Library.CreateRequest <XCLCMS.Data.Model.SysLog>();
request.Body = model;
XCLCMS.Lib.WebAPI.SysLogAPI.Add(request);
}
catch
{
//
}
}
/// <summary>
/// 异常
/// </summary>
public void OnException(ExceptionContext filterContext)
{
var ex = filterContext.Exception;
var request = filterContext.RequestContext.HttpContext.Request;
//获取异常信息
XCLNetTools.Message.MessageModel msgModel = new XCLNetTools.Message.MessageModel();
msgModel.IsSuccess = false;
msgModel.Date = DateTime.Now;
msgModel.ErrorCode = "";
msgModel.FromUrl = request.UrlReferrer?.AbsoluteUri;
msgModel.Message = ex.Message;
msgModel.MessageMore = ex.StackTrace;
msgModel.Title = "系统出错了";
msgModel.Url = request.Url?.AbsoluteUri;
var httpExp = ex as HttpException;
if (null != httpExp)
{
msgModel.ErrorCode = Convert.ToString(httpExp.GetHttpCode());
}
if (string.IsNullOrWhiteSpace(msgModel.ErrorCode))
{
msgModel.ErrorCode = "500";
}
//写入日志
var logModel = new XCLCMS.Data.Model.SysLog();
logModel.Contents = string.Format("{0}——{1}", msgModel.Message, msgModel.MessageMore);
logModel.LogLevel = XCLCMS.Data.CommonHelper.EnumType.LogLevelEnum.ERROR.ToString();
logModel.RefferUrl = msgModel.FromUrl ?? string.Empty;
logModel.Title = msgModel.Title;
logModel.Url = msgModel.Url ?? string.Empty;
logModel.Code = msgModel.ErrorCode;
XCLCMS.Lib.Common.Log.WriteLog(logModel);
//输出异常
//msgModel.MessageMore = null;
if (msgModel.IsAjax)
{
filterContext.Result = new JsonResult()
{
Data = msgModel,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
else
{
filterContext.Result = new ViewResult()
{
ViewName = "~/Views/Common/Error.cshtml",
ViewData = new ViewDataDictionary(msgModel)
};
}
filterContext.ExceptionHandled = true;
filterContext.HttpContext.Response.StatusCode = 500;
}
/// <summary>
/// 写异常日志
/// </summary>
public static void WriteLog(Exception ex, string remark = null)
{
var model = new XCLCMS.Data.Model.SysLog();
model.Code = "500";
model.Contents = ex.Message;
model.LogLevel = XCLCMS.Data.CommonHelper.EnumType.LogLevelEnum.ERROR.ToString();
model.LogType = XCLCMS.Data.CommonHelper.EnumType.LogTypeEnum.SYSTEM.ToString();
model.Remark = remark;
model.Title = "系统出错了";
Log.WriteLog(model);
}
/// <summary>
/// 写日志
/// </summary>
public static void WriteLog(XCLCMS.Data.CommonHelper.EnumType.LogLevelEnum logLevel, string title, string contents = null)
{
var model = new XCLCMS.Data.Model.SysLog();
model.Code = null;
model.Contents = contents;
model.LogLevel = logLevel.ToString();
model.LogType = XCLCMS.Data.CommonHelper.EnumType.LogTypeEnum.SYSTEM.ToString();
model.Remark = null;
model.Title = title;
Log.WriteLog(model);
}
/// <summary>
/// 写日志
/// </summary>
public static void WriteLog(XCLCMS.Data.Model.SysLog model)
{
var sysLogBLL = new Data.BLL.SysLog();
var merchantAppBLL = new Data.BLL.MerchantApp();
var app = merchantAppBLL.GetModel(XCLCMS.Lib.Common.Comm.AppKey);
model.FK_MerchantAppID = app.MerchantAppID;
model.FK_MerchantID = app.FK_MerchantID;
model.RefferUrl = HttpContext.Current?.Request?.UrlReferrer?.AbsoluteUri;
model.Url = HttpContext.Current?.Request?.Url?.AbsoluteUri;
model.CreateTime = DateTime.Now;
model.SysLogID = 0;
model.ClientIP = XCLNetTools.Common.IPHelper.GetClientIP();
sysLogBLL.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XCLCMS.Data.Model.SysLog model)
{
return(dal.Add(model));
}
