/// <summary>
/// 操作日志数据填充
/// </summary>
/// <param name="log"></param>
public static void AddOpLog(OPLog log)
{
HttpContext corrent = HttpContext.Current;
log.IpAddress = corrent.Request.UserHostAddress;
log.CreateTime = DateTime.Now;
UserInfo user = (UserInfo)corrent.Session["userInfo"];
if (user != null)
{
log.UID = user.ID;
}
}
/// <summary>
/// 添加操作日志
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public int InsertLog(OPLog log)
{
string sql = "";
sql = "INSERT INTO OPLog(UID,Module,What,IpAddress,CreateTime) VALUES(@UID,@Module,@What,@IpAddress,GETDATE())";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@UID", log.UID),
new SqlParameter("@Module", log.Module),
new SqlParameter("@What", ChangeValue.Base64Str(1, log.What)),
new SqlParameter("@IpAddress", log.IpAddress)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
