public static void ToSql(NotExists expression, StringBuilder builder) { if (null == expression) { throw new ArgumentNullException("expression"); } if (null == builder) { throw new ArgumentNullException("builder"); } if (expression.Operands.Count > 0) { IToken operand = expression.Operands.First(); if (operand is ViewToken) { builder.Append(" not exists ("); ViewToken viewToken = operand as ViewToken; View view = viewToken.ViewsManager.Views[viewToken.ViewName]; view.ToSql(builder, true); builder.Append(")"); } else { operand.ToSql(builder); builder.Append(" IS NULL OR "); operand.ToSql(builder); builder.Append(" = ''''"); } } }
/// <summary>获取Token</summary> /// <param name="uid">用户id</param> /// <param name="requesttype">类型(web或app)</param> /// <returns></returns> public static ViewToken GetToken(Userinfo userinfomodel, string requesttype) { ViewToken viewToken = new ViewToken(); var requestTypedata = GetAppSettings(requesttype); if (!requestTypedata.success) { viewToken.success = false; viewToken.msg = "当前选择登录类型有误"; return(viewToken); } DateTime time = DateTime.Now; //验证过期时间 DateTime Expires = time.AddMinutes(int.Parse(requestTypedata.Tokenexp.ToString())); //刷新过期时间 DateTime frefreshExpires = time.AddMinutes(int.Parse(requestTypedata.refreshTokenexp.ToString())); viewToken.access_token = "Bearer " + Generate(Expires, userinfomodel); viewToken.expires_in = Expires; viewToken.refreshtoken = "Bearer " + Generate(frefreshExpires, new Userinfo() { roleid = 0, uid = 0, username = "" }); viewToken.success = true; return(viewToken); }
public ActionResult TokenDetails() { if (User.Identity.IsAuthenticated) { Alumno al = _repo.getAlumnoByEmail(User.Identity.Name); String status = _repo.createTokenWithValidation(al.NoControl); Token tk = _repo.getToken(al.NoControl); ViewToken vtk = new ViewToken(); //vtk.noControl = tk.NoControl; vtk.token = tk.token; vtk.TokenCreated = tk.TokenCreated; vtk.isTokenUsed = tk.IsTokenUsed; vtk.Status = status; return(View(vtk)); } else { return(RedirectToAction("Index", "Home")); } }