/// <summary>
/// 确定已读
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSure_Click(object sender, EventArgs e)
{
if (trvMessage.SelectedNode != null)
{
try
{
Class_Message temp = (Class_Message)trvMessage.SelectedNode.Tag;
string[] sqls = new string[2];
sqls[0] = "delete from T_MSG_USER where MSG_ID=" + temp.Id + " and USER_ID=" + App.UserAccount.UserInfo.User_id + "";
sqls[1] = "insert into T_MSG_USER(MSG_ID,USER_ID)values(" + temp.Id + "," + App.UserAccount.UserInfo.User_id + ")";
if (App.ExecuteBatch(sqls) > 0)
{
App.Msg("操作成功！");
GetUnReadMessages();
}
}
catch (Exception ex)
{
App.MsgErr("操作失败！原因:" + ex.Message);
}
}
else
{
App.MsgWaring("请选择先选择需要确认的消息！");
}
}
/// <summary>
/// 获取未读取的消息
/// </summary>
private void GetUnReadMessages()
{
try
{
trvMessage.Nodes.Clear();
RichTxtMessage.Text = "";
lblCreateTime.Text = "发布时间：";
lblCreator.Text = "发布人：";
string Sql = "select * from T_MSG_INFO t where t.receive_user_ID like '%" + App.UserAccount.UserInfo.User_id + "%' and (select count(*) from T_MSG_USER a where a.MSG_ID=t.id and USER_ID=" + App.UserAccount.UserInfo.User_id + ")=0";
DataSet ds = App.GetDataSet(Sql);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Class_Message msg = new Class_Message();
msg.Id = ds.Tables[0].Rows[i]["id"].ToString();
msg.Pid = ds.Tables[0].Rows[i]["pid"].ToString();;
msg.Patient_name = ds.Tables[0].Rows[i]["patient_name"].ToString();
msg.In_time = ds.Tables[0].Rows[i]["in_time"].ToString();
msg.Receive_user = ds.Tables[0].Rows[i]["receive_user_Id"].ToString();
msg.Title = ds.Tables[0].Rows[i]["title"].ToString();
msg.Content = ds.Tables[0].Rows[i]["content"].ToString();
msg.Add_time = ds.Tables[0].Rows[i]["add_time"].ToString();
msg.Operator_user = ds.Tables[0].Rows[i]["operator_user"].ToString();;
TreeNode tn = new TreeNode();
tn.Text = msg.Title;
tn.Name = msg.Id;
tn.Tag = msg;
trvMessage.Nodes.Add(tn);
}
}
else
{
App.Msg("当前没有任何消息！");
}
}
catch (Exception ex)
{
App.MsgErr("读取消息失败！原因:" + ex.Message);
}
}
private void trvMessage_AfterSelect(object sender, TreeViewEventArgs e)
{
if (trvMessage.SelectedNode != null)
{
if (trvMessage.SelectedNode.Tag != null)
{
try
{
Class_Message temp = (Class_Message)trvMessage.SelectedNode.Tag;
RichTxtMessage.Text = temp.Content;
lblCreateTime.Text = "发布时间：" + temp.Add_time;
lblCreator.Text = "发布人：" + temp.Operator_user;
}
catch
{ }
}
}
}
