//存入离线消息
public int InsertOffLineMessage(OffLineMessages msg)
{
DBConnection dbc = new DBConnection();
dbc.GetConnection();
string cmdText = "insert younger_message_info(message_user1,message_user2,message_content,message_senddate) values(" +
"'" + msg.MessageUser1 + "'," + "'" + msg.MessageUser2 + "'," + "'" + msg.MessageContent + "'," + "'" + msg.MessageSendTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
return(dbc.ExecuteNonQueryForInc(cmdText));
}
//这里解析遇到问题：输入的信息不应该包含'#'否则发生解析错误，可以在客户端防止用户输入该符号
private List <OffLineMessages> GetOffLineMessagesList(string formatString)
{
AnalysisStr analy = new AnalysisStr(formatString);
List <OffLineMessages> list = new List <OffLineMessages>();
int paraIndex = 0;
while (analy.GetParaIndexOf(paraIndex) != null)
{
OffLineMessages msgTemp = new OffLineMessages();
msgTemp.MessageID = int.Parse(analy.GetParaIndexOf(paraIndex++));
msgTemp.MessageUser1 = analy.GetParaIndexOf(paraIndex++);
msgTemp.MessageUser2 = analy.GetParaIndexOf(paraIndex++);
msgTemp.MessageContent = analy.GetParaIndexOf(paraIndex++);
msgTemp.MessageSendTime = DateTime.Parse(analy.GetParaIndexOf(paraIndex++));
list.Add(msgTemp);
}
return(list);
}
//根据消息ID获得消息的详细信息
public OffLineMessages GetOffLineMessage(int msgID)
{
DBConnection dbc = new DBConnection();
OffLineMessages msg = new OffLineMessages();
dbc.GetConnection();
string cmdText = "select * from younger_message_info where message_id=" + msgID;
dbc.GetDataReader(cmdText);
while (dbc.dataReader.Read())
{
msg.MessageID = msgID;
msg.MessageUser1 = dbc.dataReader.GetString(1);
msg.MessageUser2 = dbc.dataReader.GetString(2);
msg.MessageContent = dbc.dataReader.GetString(3);
msg.MessageSendTime = dbc.dataReader.GetDateTime(4);
}
return(msg);
}
//获得用户2的所有发出的离线消息
public List <OffLineMessages> SentOffLineMessages(string userID)
{
List <OffLineMessages> list = new List <OffLineMessages>();
DBConnection dbc = new DBConnection();
dbc.GetConnection();
string cmdText = "select * from younger_message_info where message_user2='" + userID + "' order by message_senddate desc";
dbc.GetDataReader(cmdText);
while (dbc.dataReader.Read())
{
OffLineMessages msgTemp = new OffLineMessages();
msgTemp.MessageID = dbc.dataReader.GetInt16(0);
msgTemp.MessageUser1 = dbc.dataReader.GetString(1);
msgTemp.MessageUser2 = dbc.dataReader.GetString(2);
msgTemp.MessageContent = dbc.dataReader.GetString(3);
msgTemp.MessageSendTime = dbc.dataReader.GetDateTime(4);
list.Add(msgTemp);
}
return(list);
}
