/// <summary>
/// 添加离线消息到数据库
/// </summary>
/// <param name="msg"></param>
public static void addMessageToDB(string userID, string from, string to, IMLibrary3.Enmu.MessageType messageType, string xml)
{
string sql = "insert into RecordMsg(userID,MessageType,froms,tos,datetime,MessageXML) values(@userID,@MessageType,@froms,@tos,@datetime,@MessageXML)";
System.Data.SqlClient.SqlParameter[] sqlpar = new System.Data.SqlClient.SqlParameter[]
{ new System.Data.SqlClient.SqlParameter("@userID", userID),
new System.Data.SqlClient.SqlParameter("@MessageType", messageType),
new System.Data.SqlClient.SqlParameter("@froms", from),
new System.Data.SqlClient.SqlParameter("@tos", to),
new System.Data.SqlClient.SqlParameter("@datetime", DateTime.Now.ToString()),
new System.Data.SqlClient.SqlParameter("@MessageXML", xml), };
IMLibrary.SqlData.DataAccess.ExecSql(sql, sqlpar);
}
/// <summary>
/// 树图节点选中后事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView_Organization_AfterSelect(object sender, TreeViewEventArgs e)
{
this.txtRecord.Clear();
this.ButLast.Enabled = false;
this.ButDown.Enabled = false;
this.ButFirst.Enabled = false;
this.ButUp.Enabled = false;
this.ButDelRecord.Enabled = false;
this.PageCount = 0;
this.CurrPage = 0;
if (e.Node.Tag is exUser)
{
exUser user = e.Node.Tag as exUser;
this.SelectUserID = user.UserID;
this.MessageType = IMLibrary3.Enmu.MessageType.User;
}
else if (e.Node.Tag is exRoom)
{
exRoom room = e.Node.Tag as exRoom;
this.SelectUserID = room.RoomID;
this.MessageType = IMLibrary3.Enmu.MessageType.Group;
}
else if (e.Node.ImageIndex == 17)
{
this.MessageType = IMLibrary3.Enmu.MessageType.Notice;
}
this.PageCount = GetPageCount(this.SelectUserID);
if (this.PageCount > 0)
{
DBRecordToRichTextBox(1);
}
this.TextBoxPage.Text = this.CurrPage.ToString() + "/" + this.PageCount.ToString();
}
/// <summary>
/// 获得消息集合
/// </summary>
/// <param name="MsgInfoClass">消息类型</param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static List <IMLibrary3.Protocol.Message> GetMsg(IMLibrary3.Enmu.MessageType MessageType, int pageIndex, int pageSize)
{
List <IMLibrary3.Protocol.Message> Msgs = null;
System.Data.SQLite.SQLiteParameter messageType = new System.Data.SQLite.SQLiteParameter("MessageType", MessageType);
string sql = "select * from MsgRecord where MessageType=@MessageType "
+ " order by ID limit " + pageSize.ToString() + " offset " + ((pageIndex - 1) * pageSize).ToString();
System.Data.SQLite.SQLiteDataReader dr = SQLiteDBHelper.ExecuteReader(sql, messageType);
if (dr != null)
{
Msgs = new List <IMLibrary3.Protocol.Message>();
while (dr.Read())
{
Msgs.Add(GetDrMsg(dr));
}
}
dr.Close(); dr.Dispose();
return(Msgs);
}
/// <summary>
/// 树图节点选中后事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView_Organization_AfterSelect(object sender, TreeViewEventArgs e)
{
this.txtRecord.Clear();
this.ButLast.Enabled = false;
this.ButDown.Enabled = false;
this.ButFirst.Enabled = false;
this.ButUp.Enabled = false;
this.ButDelRecord.Enabled = false;
this.PageCount = 0;
this.CurrPage = 0;
if (e.Node.Tag is exUser)
{
exUser user = e.Node.Tag as exUser;
this.SelectUserID=user.UserID;
this.MessageType = IMLibrary3.Enmu.MessageType.User;
}
else if (e.Node.Tag is exRoom)
{
exRoom room = e.Node.Tag as exRoom;
this.SelectUserID = room.RoomID ;
this.MessageType = IMLibrary3.Enmu.MessageType.Group;
}
else if (e.Node.ImageIndex == 17)
this.MessageType = IMLibrary3.Enmu.MessageType.Notice;
this.PageCount = GetPageCount(this.SelectUserID);
if (this.PageCount > 0)
DBRecordToRichTextBox(1);
this.TextBoxPage.Text = this.CurrPage.ToString() + "/" + this.PageCount.ToString();
}
