public int AddLog(string busingessName, string opContent) { LogModel log = new LogModel(); log.BusinessName = busingessName; log.OperationIp = PublicMethod.GetClientIP(); log.OperationTime = DateTime.Now; log.OperationType = (int)OperationType.Other; log.UserId = SysVisitor.Instance.UserId; log.SqlText = ""; int logId = LogDal.Instance.Insert(log); if (logId > 0) { //添加日志详细信息 StringBuilder sb = new StringBuilder(); var sqlTemp = "insert into Sys_LogDetails (logid,fieldName,fieldtext,oldvalue,newvalue,remark) values('{0}','{1}','{2}','{3}','{4}','{5}')"; sb.AppendFormat(sqlTemp, logId, "", "", "", "", opContent); if (sb.Length > 0) { return(DbUtils.ExecuteNonQuery(sb.ToString(), null)); } } return(0); }
/// <summary> /// 用户登录 /// </summary> /// <param name="username">用户名</param> /// <param name="password">密码</param> /// <param name="saveCookieDays">保存cookie天数</param> /// <returns></returns> public bool UserLogin(string username, string password, int saveCookieDays = 1) { if (UserLogin(username, password)) { //写入cookie CookieHelper.WriteCookie(SysVisitor.CookieNameKey, SysVisitor.CookieUserNameKey, username, "", saveCookieDays); var desPass = StringHelper.EncryptDES(password, Key.DESkey); CookieHelper.WriteCookie(SysVisitor.CookieNameKey, SysVisitor.CookiePasswordKey, desPass, "", saveCookieDays); //写入登录日志 LogModel log = new LogModel(); log.BusinessName = "用户登录"; log.OperationIp = PublicMethod.GetClientIP(); log.OperationTime = DateTime.Now; log.PrimaryKey = ""; log.UserId = SysVisitor.Instance.UserId; log.TableName = ""; log.OperationType = (int)OperationType.Login; LogDal.Instance.Insert(log); return(true); } return(false); }
/// <summary> /// 添加更新操作日志 /// </summary> /// <param name="oldObj">旧实体对象</param> /// <param name="newObj">新实体对象</param> /// <returns></returns> public int UpdateLog(T oldObj, T newObj) { return(1); Type objTye = typeof(T); PropertyInfo property = objTye.GetProperty("FID"); LogModel log = new LogModel(); log.BusinessName = GetBusingessName(); log.OperationIp = PublicMethod.GetClientIP(); log.OperationTime = DateTime.Now; log.OperationType = (int)OperationType.Update; log.PrimaryKey = property.GetValue(newObj, null).ToString(); log.TableName = TableConvention.Resolve(newObj); log.UserId = SysVisitor.Instance.UserId; log.SqlText = ""; //添加日志详细信息 StringBuilder sb = new StringBuilder(); var sqlTemp = "insert into Sys_LogDetails (FID, logid,fieldName,fieldtext,oldvalue,newvalue,remark) values('{0}','{1}','{2}','{3}','{4}','{5}','')"; string logId = LogDal.Instance.Insert(log); if (logId != "") { var propertyList = objTye.GetInfos(); foreach (PropertyInfo p in propertyList) { object oldVal = p.GetValue(oldObj, null); object newVal = p.GetValue(newObj, null); if (!string.Equals(p.Name, "FID", StringComparison.CurrentCultureIgnoreCase) && p.GetCustomAttributes(true).OfType <DbFieldAttribute>().Count(dbFieldAttribute => !dbFieldAttribute.IsDbField) == 0 && !ignoredFields.Contains(p.Name, StringComparer.InvariantCultureIgnoreCase)) { if (!IsEqual(p.PropertyType, oldVal, newVal)) { sb.AppendFormat(sqlTemp, Guid.NewGuid().ToString(), logId, p.Name, GetFieldText(p), oldVal, newVal, ""); sb.AppendLine(); } } } if (sb.Length > 0) { return(DbUtils.ExecuteNonQuery(sb.ToString(), null)); } return(LogDal.Instance.Delete(logId)); } return(0); }
/// <summary> /// 添加操作日志 /// </summary> /// <param name="t">实体类</param> /// <returns></returns> public int AddLog(T t, string busingessName = "") { return(0); Type objTye = typeof(T); PropertyInfo property = objTye.GetProperty("FID"); LogModel log = new LogModel(); log.BusinessName = busingessName ?? GetBusingessName(); log.OperationIp = PublicMethod.GetClientIP(); log.OperationTime = DateTime.Now; log.OperationType = (int)OperationType.Add; if (property != null) { log.PrimaryKey = property.GetValue(t, null).ToString(); } log.TableName = TableConvention.Resolve(t); log.UserId = SysVisitor.Instance.UserId; log.SqlText = ""; string logId = LogDal.Instance.Insert(log); if (logId != "") { //添加日志详细信息 StringBuilder sb = new StringBuilder(); var sqlTemp = "insert into Sys_LogDetails (fid, logid,fieldName,fieldtext,oldvalue,newvalue,remark) values('{0}','{1}','{2}','{3}','{4}','{5}','');"; foreach (PropertyInfo pi in objTye.GetProperties()) { if (!string.Equals(pi.Name, "FID", StringComparison.CurrentCultureIgnoreCase) && pi.GetCustomAttributes(true).OfType <DbFieldAttribute>().Count(dbFieldAttribute => !dbFieldAttribute.IsDbField) == 0 && !ignoredFields.Contains(pi.Name, StringComparer.InvariantCultureIgnoreCase)) { sb.AppendFormat(sqlTemp, Guid.NewGuid().ToString(), logId, pi.Name, GetFieldText(pi), "", pi.GetValue(t, null)); sb.AppendLine(); } } if (sb.Length > 0) { return(DbUtils.ExecuteNonQuery(sb.ToString(), null)); } } return(0); }
public void LoginOut() { //写入退出日志 LogModel log = new LogModel(); log.BusinessName = "用户退出"; log.OperationIp = PublicMethod.GetClientIP(); log.OperationTime = DateTime.Now; log.PrimaryKey = ""; log.UserId = UserId; log.TableName = ""; log.OperationType = (int)OperationType.LoginOut; LogDal.Instance.Insert(log); CookieHelper.ClearUserCookie("", SysVisitor.CookieNameKey); UserName = null; UserId = 0; }