62,254
社区成员
发帖
与我相关
我的任务
分享
//根据用户Id获得个人消息
//IList<Message>是什么意思???
public static IList<Message> GetReceiveMessage(string userId, DateTime AvailTime)
{
string sql = "SELECT a.* FROM Message a,MessageToUser b where a.MessageId = b.Messageid and a.IfPublish='1' and b.ToUserId='" + userId + "' and a.fromuserid<>'" + userId + "' and Convert(DateTime,'" + AvailTime + "') between BeginTime and EndTime";
sql += " union SELECT a.* FROM Message a,MessageToUser b where a.MessageId = b.Messageid and a.IfPublish='1' and b.ToUserId='0' and a.fromuserid<>'" + userId + "' and Convert(DateTime,'" + AvailTime + "') between BeginTime and EndTime";
return GetMessagesBySql(sql);
}