/// <summary>
/// 向数据表DawnAuthLogs中插入一条新记录
/// </summary>
/// <param name="dawnAuthLogs">DawnAuthLogs实体对象</param>
/// <returns></returns>
public int Insert(DawnAuthLogsMDL dawnAuthLogs)
{
try
{
string sqlCommand = "DawnAuthLogsInsert";
int res;
SqlParameter[] param =
{
new SqlParameter("@LogId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LogTime", SqlDbType.DateTime),
new SqlParameter("@LogRating", SqlDbType.TinyInt),
new SqlParameter("@LogTable", SqlDbType.VarChar, 200),
new SqlParameter("@LogAction", SqlDbType.NVarChar, -1),
new SqlParameter("@LogMemo", SqlDbType.NVarChar, -1),
new SqlParameter("@LogUid", SqlDbType.Int),
new SqlParameter("@LogUname", SqlDbType.NVarChar, 20)
};
param[0].Direction = ParameterDirection.Output;
param[1].Value = dawnAuthLogs.LogTime;
param[2].Value = dawnAuthLogs.LogRating;
param[3].Value = dawnAuthLogs.LogTable;
param[4].Value = dawnAuthLogs.LogAction;
param[5].Value = dawnAuthLogs.LogMemo;
param[6].Value = dawnAuthLogs.LogUid;
param[7].Value = dawnAuthLogs.LogUname;
res = SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
dawnAuthLogs.LogId = (Guid)param[0].Value;
return(res);
}
catch
{
return(-1);
}
}
/// <summary>
/// 向数据表DawnAuthLogs中插入一条新记录
/// </summary>
/// <param name="dawnAuthLogs">DawnAuthLogs实体对象</param>
/// <returns></returns>
public static int Insert(DawnAuthLogsMDL dawnAuthLogs)
{
if (dawnAuthLogs == null)
{
return(0);
}
return(DawnAuthLogsBLL._dal.Insert(dawnAuthLogs));
}
/// <summary>
/// 得到DawnAuthLogs实体对象
/// </summary>
/// <param name="row">row</param>
/// <returns>DawnAuthLogs实体对象</returns>
public DawnAuthLogsMDL Select(DataRow row)
{
DawnAuthLogsMDL obj = new DawnAuthLogsMDL();
if (row != null)
{
try
{
obj.LogId = (Guid)row["log_id"];
}
catch { }
try
{
obj.LogTime = ((row["log_time"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["log_time"]);
}
catch { }
try
{
obj.LogRating = ((row["log_rating"]) == DBNull.Value) ? Convert.ToByte(0) : Convert.ToByte(row["log_rating"]);
}
catch { }
try
{
obj.LogTable = row["log_table"].ToString();
}
catch { }
try
{
obj.LogAction = row["log_action"].ToString();
}
catch { }
try
{
obj.LogMemo = row["log_memo"].ToString();
}
catch { }
try
{
obj.LogUid = ((row["log_uid"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["log_uid"]);
}
catch { }
try
{
obj.LogUname = row["log_uname"].ToString();
}
catch { }
}
else
{
return(null);
}
return(obj);
}
/// <summary>
/// 得到DawnAuthLogs实体对象
/// </summary>
/// <param name="dr">dr</param>
/// <returns>DawnAuthLogs实体对象</returns>
public DawnAuthLogsMDL Select(IDataReader dr)
{
DawnAuthLogsMDL obj = new DawnAuthLogsMDL();
try
{
obj.LogId = (Guid)dr["log_id"];
}
catch { }
try
{
obj.LogTime = ((dr["log_time"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["log_time"]);
}
catch { }
try
{
obj.LogRating = ((dr["log_rating"]) == DBNull.Value) ? Convert.ToByte(0) : Convert.ToByte(dr["log_rating"]);
}
catch { }
try
{
obj.LogTable = dr["log_table"].ToString();
}
catch { }
try
{
obj.LogAction = dr["log_action"].ToString();
}
catch { }
try
{
obj.LogMemo = dr["log_memo"].ToString();
}
catch { }
try
{
obj.LogUid = ((dr["log_uid"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["log_uid"]);
}
catch { }
try
{
obj.LogUname = dr["log_uname"].ToString();
}
catch { }
return(obj);
}
/// <summary>
/// 动作执行时需要处理的信息
/// <para>记录执行动作</para>
/// <para>动作执行时</para>
/// </summary>
/// <param name="filterContext">动作执行上下文</param>
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
//写操作日志文件
if (null == this.FLogger)
{
var logPath = System.IO.Path.Combine(FileHelper.AppPath, "logs", "Action");
this.FLogger = new LogHelper(logPath, 2, LogType.Hour);
}
this.FLogger.Write(string.Format("控制器名称：{0}", filterContext.ActionDescriptor.ControllerDescriptor.ControllerName));
this.FLogger.Write(string.Format("动作名称：{0}", filterContext.ActionDescriptor.ActionName));
this.FLogger.Write(string.Format(" 客户端请求时间：{0}", filterContext.HttpContext.Timestamp.ToString("yyyy-MM-dd HH:mm:ss.fff")));
this.FLogger.Write(string.Format(" 客户端IP地址：{0}", RequestHelper.GetIPAddress()));
this.FLogger.Write(string.Format("客户端IP地址[强制]：{0}", RequestHelper.GetIPAddressAt()));
this.FLogger.Write(string.Format(" 客户端MAC地址：{0}", "Unknown"));
this.FLogger.Write(string.Format(" 客户端原始地址：{0}", RequestHelper.GetUrlOfRaw()));
this.FLogger.Write(string.Format(" 客户端来源地址：{0}", RequestHelper.GetUrlOfReferrer()));
this.FLogger.Write(string.Format(" 客户端访问方式：{0}", RequestHelper.IsBrowserGet() ? "来自于浏览器" : "非浏览器访问"));
this.FLogger.Write(string.Format(" 客户端浏览器类型：{0}", RequestHelper.GetClientOfType()));
this.FLogger.Write(string.Format(" 客户端浏览器名称：{0}", RequestHelper.GetClientOfBrowser()));
this.FLogger.Write(string.Format("客户端浏览器主版本：{0}", RequestHelper.GetClientOfMajorVersion()));
this.FLogger.Write(string.Format("客户端浏览器版本号：{0}", RequestHelper.GetClientOfVersion()));
this.FLogger.Write(string.Format(" 客户端远程IP地址：{0}", RequestHelper.GetClientOfUserHostAddress()));
this.FLogger.Write(string.Format(" 客户端远程DNS名称：{0}", RequestHelper.GetClientOfUserHostName()));
this.FLogger.Write(string.Format(" 客户端操作系统：{0}", RequestHelper.GetClientOfPlatform()));
this.FLogger.Write(string.Format("客户端是否16位环境：{0}", RequestHelper.GetClientOfWin16()));
this.FLogger.Write(string.Format("客户端是否32位环境：{0}", RequestHelper.GetClientOfWin32()));
this.FLogger.Write(string.Format(" 客户端用户编号：{0}", DawnauthHandler.UserId));
this.FLogger.Write(string.Format(" 客户端用户名称：{0}", DawnauthHandler.UserName));
this.FLogger.Write(string.Format(" 客户端用户姓名：{0}", DawnauthHandler.UserSurname));
this.FLogger.Write("\r\n\r\n");
//写入数据库
DawnAuthLogsMDL dataInfo = new DawnAuthLogsMDL();
dataInfo.LogTime = DateTime.Now;
dataInfo.LogRating = 1;
dataInfo.LogTable = string.Format("{0} - {1}", filterContext.ActionDescriptor.ControllerDescriptor.ControllerName, filterContext.ActionDescriptor.ActionName);
dataInfo.LogAction = string.Format("{0} - {1} - {2} - {3}", filterContext.Controller.ToString(), RequestHelper.GetIPAddressAt(), "Unknown", RequestHelper.GetIPAddress());
dataInfo.LogMemo = string.Format("{0} - {1} - {2}", filterContext.HttpContext.Timestamp.ToString("yyyy-MM-dd HH:mm:ss.fff"), RequestHelper.GetUrlOfRaw(), RequestHelper.GetUrlOfReferrer());
dataInfo.LogUid = DawnauthHandler.UserId < 1 ? -1 : DawnauthHandler.UserId;
dataInfo.LogUname = string.IsNullOrEmpty(DawnauthHandler.UserSurname) ? "匿名用户" : DawnauthHandler.UserSurname;
DawnAuthLogsBLL.Insert(dataInfo);
}
/// <summary>
/// 根据ID,返回一个DawnAuthLogs实体对象
/// </summary>
/// <param name="logId">系统编号</param>
/// <returns>DawnAuthLogs实体对象</returns>
public DawnAuthLogsMDL Select(Guid logId)
{
DawnAuthLogsMDL obj = null;
SqlParameter[] param =
{
new SqlParameter("@LogId", SqlDbType.UniqueIdentifier)
};
param[0].Value = logId;
string sqlCommand = "DawnAuthLogsSelect";
using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
{
while (dr.Read())
{
obj = this.Select(dr);
}
}
return(obj);
}
