/// <summary> /// 新消息 /// </summary> /// <param name="me">用户</param> /// <param name="messageNote"></param> public void New(User me, MessageNote messageNote) { foreach (string msg in messageNote.MessageContent) { //label1.Paint += new PaintEventHandler(DrawBorder(label1,)); } }
/// <summary> /// 后台异步获取消息 /// </summary> private void getMessageBackgroundWorker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { //string sql; //if (lastGetTime != null) sql = @"SELECT * FROM MessageNotes WHERE ReceiveUser='******' OR ReceiveDepartment='" + user.Dept + " WHERE SendTime>" + lastGetTime + "'"; //else sql = @"SELECT * FROM MessageNotes WHERE ReceiveUser='******' OR ReceiveDepartment='" + user.Dept + "'"; DataTable messageTable1 = SqlFunction.Select(@"SELECT * FROM MessageNotes WHERE ReceiveUser='******' OR ReceiveDepartment='" + user.Dept + "'"); /// if (messageTable1.Rows.Count == 0) { getMessageBackgroundWorker.ReportProgress(100, "无任何消息:" + DateTime.Now.ToString());// 进度传出 return; } for (int i = 0; i < messageTable1.Rows.Count; i++)// 拆解消息 { MessageNote messageNote = new MessageNote(); messageNote.SendUser = messageTable1.Rows[i]["SendUser"].ToString(); messageNote.SendTime = messageTable1.Rows[i]["SendTime"].ToString(); messageNote.SendComputer = messageTable1.Rows[i]["SendComputer"].ToString(); messageNote.ReceiveUser = messageTable1.Rows[i]["ReceiveUser"].ToString(); messageNote.ReceiveDepartment = messageTable1.Rows[i]["ReceiveDepartment"].ToString(); messageNote.OrderTape = messageTable1.Rows[i]["OrderTape"].ToString(); string[] content = messageTable1.Rows[i]["MessageContent"].ToString().Split(';'); foreach (string str in content) { messageNote.MessageContent.Add(str); } messageNote.Reading = Convert.ToBoolean(messageTable1.Rows[i]["Reading"]); messageNote.ReadTime = messageTable1.Rows[i]["ReadTime"].ToString(); messageNote.Complete = Convert.ToBoolean(messageTable1.Rows[i]["Complete"]); messageNote.CompleteTime = messageTable1.Rows[i]["CompleteTime"].ToString(); messagesNotes.Add(messageNote); } getMessageBackgroundWorker.ReportProgress(100, "消息刷新时间:" + DateTime.Now.ToString());// 进度传出 }