/// <summary> /// 添加日志 /// </summary> /// <param name="action">动作</param> /// <param name="link">链接</param> /// <param name="method">方式</param> /// <param name="data">数据</param> /// <param name="userId">用户编号</param> /// <param name="userName">用户名称</param> public void AddLog(string action, string link, string method, string data, int userId, string userName) { if (new BLL.S.Config().GetValuesByKeyAndGroupId("AdminLog", 2) == "1") { Models.S.Log model = new Models.S.Log(); model.Action = action; model.Link = link; model.Method = method; model.Data = data; model.UserId = userId; model.UserName = userName; model.IP = RequestHelper.GetIP(); model.Time = DateTime.Now; this.Add(model); } }
/// <summary> /// 添加 /// </summary> /// <param name="model">Model</param> /// <returns></returns> public int Add(Models.S.Log model) { try { SqlParameter[] param = { new SqlParameter("@action", SqlDbType.VarChar, 20), new SqlParameter("@link", SqlDbType.NVarChar, 255), new SqlParameter("@method", SqlDbType.VarChar, 20), new SqlParameter("@data", SqlDbType.NText), new SqlParameter("@userid", SqlDbType.Int), new SqlParameter("@username", SqlDbType.VarChar, 20), new SqlParameter("@ip", SqlDbType.VarChar, 20), new SqlParameter("@time", SqlDbType.DateTime) }; param[0].Value = model.Action; param[1].Value = model.Link; param[2].Value = model.Method; param[3].Value = model.Data; param[4].Value = model.UserId; param[5].Value = model.UserName; param[6].Value = model.IP; param[7].Value = model.Time; return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, "INSERT INTO S_LOG(L_ACTION,L_LINK,L_METHOD,L_DATA,U_ID,U_NAME,L_IP,L_TIME) VALUES(@action,@link,@method,@data,@userid,@username,@ip,@time)", param)); } catch (ArgumentNullException ex) { logger.Error("调用方法Add(Models.S.Log model)发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法Add(Models.S.Log model)发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法Add(Models.S.Log model)发生Exception", ex); } return(-1); }
/// <summary> /// 添加 /// </summary> /// <param name="model">Model</param> /// <returns></returns> public int Add(Models.S.Log model) { return(dal.Add(model)); }