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