string messageString = "";//记录未读消息的Id
string messageTime = "";//读取消息发送的时间
string messageText = "";//消息的内容
string MessageSend = "";//显示发送的信息
Messages message = new Messages();
message = mm.ShowMessage(hostId, users.Id);
txtSend.Clear();
foreach (Messages mess in message)
{
messageString += mess.Id + "_"; messageText = mess.Message; messageTime = mess.Messagetime; MessageSend = string.Format("\n{0}\t{1}\n", users.NickName, messageTime);
txtGet.AppendText(MessageSend);//追加文本
txtGet.AppendText(messageText + " \n");
} public Messages ShowMessage(int hostid,int friendid)
{
Messages message = new Messages();
message = ms.ShowMessage(hostid,friendid);
return message;
} public Messages ShowMessage(int hostid, int friendid)
{
Messages message = new Messages();
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand("usp_SelectMessagesIdAndMessageAndMessageTime", conn);
cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@fromUserId", SqlDbType.Int).Value = friendid;
cmd.Parameters.Add("@toUserId", SqlDbType.Int).Value = hostid;
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
message.Id = Convert.ToInt32(reader["id"]);
message.Message = reader["Message"].ToString();
message.Messagetime = Convert.ToDateTime(reader["MessageTime"]).ToString();
}
}
}
}
return message;
} 这是用三层开发是碰到的,运行时提示说“MyQQModels.Messages”不包含“GetEnumerator”的公共定义,因此 foreach 语句不能作用于“MyQQModels“ 求解决。。
string messageTime = "";//读取消息发送的时间
string messageText = "";//消息的内容
string MessageSend = "";//显示发送的信息
Messages message = new Messages();
message = mm.ShowMessage(hostId, users.Id);
txtSend.Clear();
foreach (Messages mess in message)
{
messageString += mess.Id + "_"; messageText = mess.Message; messageTime = mess.Messagetime; MessageSend = string.Format("\n{0}\t{1}\n", users.NickName, messageTime);
txtGet.AppendText(MessageSend);//追加文本
txtGet.AppendText(messageText + " \n");
} public Messages ShowMessage(int hostid,int friendid)
{
Messages message = new Messages();
message = ms.ShowMessage(hostid,friendid);
return message;
} public Messages ShowMessage(int hostid, int friendid)
{
Messages message = new Messages();
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand("usp_SelectMessagesIdAndMessageAndMessageTime", conn);
cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@fromUserId", SqlDbType.Int).Value = friendid;
cmd.Parameters.Add("@toUserId", SqlDbType.Int).Value = hostid;
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
message.Id = Convert.ToInt32(reader["id"]);
message.Message = reader["Message"].ToString();
message.Messagetime = Convert.ToDateTime(reader["MessageTime"]).ToString();
}
}
}
}
return message;
} 这是用三层开发是碰到的,运行时提示说“MyQQModels.Messages”不包含“GetEnumerator”的公共定义,因此 foreach 语句不能作用于“MyQQModels“ 求解决。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货