Exemple #1
0
 /// <summary>
 /// 更新用户登录信息
 /// </summary>
 /// <param name="sysUser"></param>
 /// <returns></returns>
 public bool UpdateUserLoginInfo(SysUser sysUser)
 {
     try
     {
         _sysUserRepository.BeginTran();//开始事务
         string           sql       = "UPDATE sys_user SET LoginCount=@LoginCount,FirstVisit=@FirstVisit,LastVisit=@LastVisit WHERE Id=@Id";
         SugarParameter[] Parameter = new SugarParameter[]
         {
             new SugarParameter("@Id", sysUser.Id),
             new SugarParameter("@LoginCount", sysUser.LoginCount),
             new SugarParameter("@FirstVisit", sysUser.FirstVisit),
             new SugarParameter("@LastVisit", sysUser.LastVisit)
         };
         bool result = _sysUserRepository.ExecuteSql(sql, Parameter);
         _sysUserRepository.CommitTran();//提交事务
         return(result);
     }
     catch (Exception ex)
     {
         _sysUserRepository.RollbackTran();//回滚事务
         throw ex;
     }
 }