/// <summary>
/// 添加操作日志
/// </summary>
/// <param name="title">操作类型</param>
/// <param name="actionDetails">详细描述</param>
public bool AddSysLog(string title, string actionDetails)
{
Sys_Log SysLog = new Sys_Log();
Manager manager = this.GetAdminInfo(); //获得当前管理员信息
SysLog.UserId = manager.RoleId;
SysLog.UserName = manager.UserName;
SysLog.UserIp = DTRequest.GetIP();
SysLog.ActionType = title;
SysLog.ActionDetails = actionDetails;
if (BLL_SysLog.AddLog(SysLog) > 0) //添加操作日志
return true;
return false;
}
/// <summary>
/// 添加操作日志
/// </summary>
/// <param name="sysLog">
/// </param>
/// <returns>
/// 添加成功: >0
/// 失败 : =0
/// </returns>
public int AddLog(Sys_Log sysLog)
{
var result = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into T_Sys_Log (");
strSql.Append(" userId,userName,actionType,actionDetails,userIp)");
strSql.Append(" values(");
strSql.Append(" @userId,@userName,@actionType,@actionDetails,@userIp)");
strSql.Append(" ;select @@IDENTITY");
SqlParameter[] para =
{
new SqlParameter("@userId",SqlDbType.Int),
new SqlParameter("@userName",SqlDbType.NVarChar,100),
new SqlParameter("@actionType",SqlDbType.NVarChar,100),
new SqlParameter("@actionDetails",SqlDbType.NVarChar,200),
new SqlParameter("@userIp",SqlDbType.NVarChar,30)
};
para[0].Value = sysLog.UserId;
para[1].Value = sysLog.UserName;
para[2].Value = sysLog.ActionType;
para[3].Value = sysLog.ActionDetails;
para[4].Value = sysLog.UserIp;
object obj = SqlHelper.ExecuteScalar(SqlHelper.connString, CommandType.Text, strSql.ToString(), para);
if (obj != null)
{
result = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_SysLog//AddLog" + e.Message); //发生异常，记录
}
return result;
}
private static readonly DAL_SysLog dalSysLog = new DAL_SysLog(); //实例化
#endregion Fields
#region Methods
/// <summary>
/// 增加日志
/// </summary>
/// <param name="sysLog"></param>
/// <returns>刚刚插入记录的主键编号</returns>
public static int AddLog(Sys_Log sysLog)
{
return dalSysLog.AddLog(sysLog);
}
