//增添房间的留言
public void AddChatMessgae(string id, string message)
{
IHandleMysql handleMysql = new HandleMysql();
string nowtime = DateTime.Now.Year + "." + DateTime.Now.Month + "." + DateTime.Now.Day + "-" + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
handleMysql.insertMySQL("insert into roomchat(ChatId,RoomName,PlayerId,ChatMessage,ChatTime) values(NULL,'" + Name + "', '" + id + "', '" + message + "', '" + nowtime + "')"); //插入数据到表);
}
//删除展厅
public bool DeleteRoom(Player player, string RoomName)
{
//根据展厅名称判断是否存在该展厅
if (list.Keys.Contains(RoomName))
{
lock (list)
{
list.Remove(RoomName); //从展厅字典中移除展厅
IHandleMysql handleMysql = new HandleMysql(); //调用接口，操纵数据库删除该展厅所有信息
handleMysql.deleteMySQL("delete from roomchat where RoomName = " + RoomName);
return(true);
}
}
else
{
return(false);
}
}
//获取房间的留言
public Dictionary <List <string>, List <string> > GetChatMessgae()
{
IHandleMysql handleMysql = new HandleMysql();
return(handleMysql.selectMySQL("select * from roomchat where RoomName=" + Name)); //查询数据表);
}
