public static TableLink LoadUnreadLink(IDataLayer forumConnection)
{
return(TableLink.Load(forumConnection,
new FieldBlank[] {
DialogReadType.UserId,
DialogReadType.Count
},
new IndexBlank[] {
DialogReadType.UnreadByUserId
}, "",
"Select user_id, count(*) From dialogue",
"unread = 1 group by user_id"
));
}
public static TableLink LoadCorrespondenceLink(IDataLayer forumConnection, string conditionWithoutWhere,
params DbParameter[] conditionParameters)
{
return(TableLink.Load(forumConnection,
new FieldBlank[] {
CorrespondenceType.Id,
CorrespondenceType.UserId,
CorrespondenceType.CollocutorId,
CorrespondenceType.Inbox,
CorrespondenceType.Content,
CorrespondenceType.CreateTime
},
new IndexBlank[] {
CorrespondenceType.MessageById
}, "",
"Select id, user_id, collocutor_id, inbox, content, create_time From correspondence",
conditionWithoutWhere, conditionParameters
));
}
public static TableLink LoadDialogueLink(IDataLayer forumConnection, string conditionWithoutWhere,
params DbParameter[] conditionParameters)
{
return(TableLink.Load(forumConnection,
new FieldBlank[] {
DialogueType.Id,
DialogueType.UserId,
DialogueType.CollocutorId,
DialogueType.Inbox,
DialogueType.Content,
DialogueType.ModifyTime,
DialogueType.Unread
},
new IndexBlank[] {
DialogueType.DialogueById
}, "",
"Select id, user_id, collocutor_id, inbox, content, modify_time, unread From dialogue",
conditionWithoutWhere, conditionParameters
));
}