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