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