public IActionResult GetConnectedUsers()
{
return(this.ResultList(() =>
{
ICollection <V_AppUser> ret = new List <V_AppUser>();
var users = TokenTable.Instance.GetCurrentUserList();
if (!users.IsEmptyList())
{
foreach (User user in users)
{
V_AppUser entity = this.Db.AppUser.QueryViewBy(user.Name);
if (null != entity)
{
ret.Add(entity);
}
}
}
return ret;
}));
}
public V_AppUser QueryViewBy(string userName)
{
var q = V_AppUser.Query().ToInnerQuery("t").Sql(" where t.Username=@0", userName);
return(this.Cmd.QuerySingle <V_AppUser>(q));
}
public IEnumerable <V_AppUser> QueryView()
{
return(this.Cmd.Query <V_AppUser>(V_AppUser.Query()));
}
