private void HandleTitleMessage(NetIncomingMessage im)
{
var message = new TitleMessage(im);
if (!this.IsHost)
{
ShowMessage = message.Show;
SetTitle(message.Title);
TileGrid.Expansions = message.Title;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TitleMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into titleMessage(");
strSql.Append("code,title,context,memo,userCode,messageDate,msgType,upfile)");
strSql.Append(" values (");
strSql.Append("@code,@title,@context,@memo,@userCode,@messageDate,@msgType,@upfile)");
SqlParameter[] parameters =
{
new SqlParameter("@code", SqlDbType.VarChar, 30),
new SqlParameter("@title", SqlDbType.VarChar, 50),
new SqlParameter("@context", SqlDbType.VarChar, 300),
new SqlParameter("@memo", SqlDbType.VarChar, 50),
new SqlParameter("@userCode", SqlDbType.VarChar, 30),
new SqlParameter("@messageDate", SqlDbType.DateTime),
new SqlParameter("@msgType", SqlDbType.VarChar, 2),
new SqlParameter("@upfile", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Title;
parameters[2].Value = model.Context;
parameters[3].Value = model.Memo;
parameters[4].Value = model.UserCode;
parameters[5].Value = model.MessageDate;
parameters[6].Value = model.MsgType;
parameters[7].Value = model.Upfile;
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
Delete(model.Code, trans);
DataHelper.ExcuteNonQuery(strSql.ToString(), trans, parameters, false);
if (model.Userlist.Count > 0)
{
AddUser(model.Userlist, trans);
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
/// <summary>
/// Показать уведомляющее сообщение
/// </summary>
/// <param name="title"></param>
public void ShowMessageNotification(TitleMessage title)
{
if (CheckMessages)
{
string fullMessage = null;
foreach (string message in messages)
{
fullMessage += message + "\n";
}
MessageBox.Show(fullMessage, titleMessage[(int)title], MessageBoxButton.OK, MessageBoxImage.Asterisk);
messages.Clear();
}
}
public TitleMessage GetNewsByCode(string code)
{
string sql = selsql + " where code=@code ";
SqlParameter[] sps =
{
new SqlParameter("@code", code)
};
using (SqlDataReader dr = DataHelper.GetDataReader(sql, sps))
{
if (dr.Read())
{
TitleMessage model = new TitleMessage();
model.Code = dr["code"].ToString();
model.Title = dr["title"].ToString();
model.Context = dr["context"].ToString();
model.Memo = dr["memo"].ToString();
model.UserCode = dr["userCode"].ToString();
if (dr["messageDate"].ToString() != "")
{
model.MessageDate = Convert.ToDateTime(dr["messageDate"]);
}
model.MsgType = dr["msgType"].ToString();
model.Upfile = dr["upfile"].ToString();
string tempsql = "select * from MessageReader where code=@code";
SqlParameter[] tempsps = { new SqlParameter("@code", model.Code) };
DataTable dt = DataHelper.GetDataTable(tempsql, tempsps, false);
foreach (DataRow tempdr in dt.Rows)
{
MessageReader reader = new MessageReader();
reader.Code = model.Code;
reader.IsRead = Convert.ToInt32(tempdr["IsRead"]);
reader.Usercode = Convert.ToString(tempdr["Usercode"]);
model.Userlist.Add(reader);
}
return(model);
}
else
{
return(null);
}
}
}
private IList <TitleMessage> ListMaker(string sql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <TitleMessage> list = new List <TitleMessage>();
foreach (DataRow dr in dt.Rows)
{
TitleMessage model = new TitleMessage();
model.Code = dr["code"].ToString();
model.Title = dr["title"].ToString();
model.Context = dr["context"].ToString();
model.Memo = dr["memo"].ToString();
model.UserCode = dr["userCode"].ToString();
if (dr["messageDate"].ToString() != "")
{
model.MessageDate = Convert.ToDateTime(dr["messageDate"]);
}
model.MsgType = dr["msgType"].ToString();
model.Upfile = dr["upfile"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 增加一条新闻或通知
/// </summary>
public void Add(TitleMessage model)
{
msgDal.Add(model);
}
public override void ViewAppeared()
{
var message = new TitleMessage(this, "Contact Dispatch");
_messenger.Publish(message);
}
