public List <UserSimple> queryNotificationGroup(Group_Notification group_Notification) { return(Db.Queryable <EUserInfo>().Where(u => u.Group_Notification == group_Notification) .Select(u => new UserSimple { UserId = u.Id }).ToList()); }
public int UpdateGroupToUnRead(Group_Notification group, int num = 1) { if (num <= 0) { return(0); } var op = Db.Updateable <EMsgInfoOverview>() .SetColumns(m => new EMsgInfoOverview { nSystem = m.nSystem + num, notificationTotal = m.notificationTotal + num }) .Where(m => m.userId == SqlFunc.Subqueryable <EUserInfo>() .Where(u => u.Id == m.userId && u.Group_Notification == group) .Select(u => u.Id) ); var r = op.ExecuteCommand(); return(r); }
public List <UserSimple> queryNotificationGroup(Group_Notification group_Notification) { return(_userDb.queryNotificationGroup(group_Notification)); }