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