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