private bool NewMessages()
{
try
{
string Title = Request["Title"];
string Content = Request["Details"];
string Level = Request["level"];
string Rec = Request["Rec"];
//如果是全部用户 则记录下来的ToUser字段就为全部用户
Model.UserMessage mess = new Model.UserMessage();
mess.Title = Title;
mess.Content = Content;
mess.level = int.Parse(Level);
mess.IsRead = 0;
mess.Remark = "";
mess.FromUser = Session["UserName"].ToString();
mess.ToUser = Rec;
mess.SentTime = DateTime.Now;
if (!DAL.UserMessage.Add(mess))
{
return(false);
}
return(true);
}
catch (Exception e)
{
Response.Write("发送失败");
return(false);
}
}
public static bool Add(Model.UserMessage model)
{
string strSql = "insert into UserMessage(level,Title, Content, FromUser, ToUser,SentTime, IsRead, Remark) values(@level,@Title, @Content, @FromUser, @ToUser,@SentTime, @IsRead, @Remark)";
SqlParameter level = new SqlParameter("level", SqlDbType.Int); level.Value = model.level;
SqlParameter Title = new SqlParameter("Title", SqlDbType.VarChar); Title.Value = model.Title;
SqlParameter Content = new SqlParameter("Content", SqlDbType.NVarChar); Content.Value = model.Content;
SqlParameter FromUser = new SqlParameter("FromUser", SqlDbType.VarChar); FromUser.Value = model.FromUser;
SqlParameter ToUser = new SqlParameter("ToUser", SqlDbType.VarChar); ToUser.Value = model.ToUser;
SqlParameter SentTime = new SqlParameter("SentTime", SqlDbType.DateTime); SentTime.Value = model.SentTime;
// SqlParameter ReadTime = new SqlParameter("ReadTime", SqlDbType.DateTime); ReadTime.Value = model.ReadTime;
SqlParameter IsRead = new SqlParameter("IsRead", SqlDbType.Int); IsRead.Value = model.IsRead;
SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { level, Title, Content, FromUser, ToUser, SentTime, IsRead, Remark }) == 1 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(Model.UserMessage model)
{
string strSql = "update UserMessage set level=@level,Title=@Title, Content=@Content, FromUser=@FromUser,ToUser=@ToUser, SentTime=@SentTime,ReadTime=@ReadTime, IsRead=@IsRead, Remark=@Remark where ID = " + model.ID.ToString();
SqlParameter level = new SqlParameter("level", SqlDbType.Int); level.Value = model.level;
SqlParameter Title = new SqlParameter("Title", SqlDbType.VarChar); Title.Value = model.Title;
SqlParameter Content = new SqlParameter("Content", SqlDbType.NVarChar); Content.Value = model.Content;
SqlParameter FromUser = new SqlParameter("FromUser", SqlDbType.VarChar); FromUser.Value = model.FromUser;
SqlParameter ToUser = new SqlParameter("ToUser", SqlDbType.VarChar); ToUser.Value = model.ToUser;
SqlParameter SentTime = new SqlParameter("SentTime", SqlDbType.DateTime); SentTime.Value = model.SentTime;
SqlParameter ReadTime = new SqlParameter("ReadTime", SqlDbType.DateTime); ReadTime.Value = model.ReadTime;
SqlParameter IsRead = new SqlParameter("IsRead", SqlDbType.Int); IsRead.Value = model.IsRead;
SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { level, Title, Content, FromUser, ToUser, SentTime, IsRead, ReadTime, Remark }) == 1 ? true : false);
}
private void identifyHaveRead(string sysLogId, string status)
{
if (Convert.ToInt32(Session["UserType"]) == 1)
{
Model.UserMessage sysLog = DAL.UserMessage.GetModel(Convert.ToInt32(sysLogId));
if (status == "identifyHaveRead")
{
//消息已读则IsRead=1
sysLog.IsRead = 1;
sysLog.ReadTime = DateTime.Now;
}
DAL.UserMessage.Update(sysLog);
string strwhere = "ToUser = '******' or ToUser ='******' and IsRead=0 ";
//查询该用户收件箱里里面未读信个数
unreadMailNum = DAL.UserMessage.GetRecordCountNew("", strwhere).ToString();
if (unreadMailNum == "0")
{
unreadMailNum = "";
}
}
else
{
Model.SysLog sysLog = DAL.SysLog.GetModel(Convert.ToInt32(sysLogId));
if (status == "identifyHaveRead")
{
//消息已读则LogType=6
sysLog.LogType = 6;
}
DAL.SysLog.Update(sysLog);
string search = ""; string strwhere = "";
strwhere = " LogType= 5 ";
unreadMailNum = DAL.SysLog.GetRecordCount(search, strwhere).ToString();
if (unreadMailNum == "0")
{
unreadMailNum = "";
}
}
}
/// <summary>
/// 得到一个实体对象
/// </summary>
/// <param name="ToUser"></param>
/// <returns></returns>
public Model.UserMessage GetModel(string ToUser)
{
string strSql = "select * from UserMessage where ToUser = '******'";
Model.UserMessage model = new Model.UserMessage();
DataSet ds = DBHelperSQL.GetDataSet(strSql);
model.ToUser = ToUser;
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
model.level = Convert.ToInt32(ds.Tables[0].Rows[0]["level"]);
model.Title = Convert.ToString(ds.Tables[0].Rows[0]["Title"]);
model.Content = Convert.ToString(ds.Tables[0].Rows[0]["Content"]);
model.FromUser = Convert.ToString(ds.Tables[0].Rows[0]["FromUser"]);
model.ToUser = Convert.ToString(ds.Tables[0].Rows[0]["ToUser"]);
model.IsRead = Convert.ToInt32(ds.Tables[0].Rows[0]["IsRead"]);
model.SentTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["SentTime"]);
if (ds.Tables[0].Rows[0]["ReadTime"] == null || ds.Tables[0].Rows[0]["ReadTime"].ToString().Trim() == "")
{
model.ReadTime = DateTime.Now;
}
else
{
model.ReadTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ReadTime"]);
}
if (ds.Tables[0].Rows[0]["Remark"] == null || ds.Tables[0].Rows[0]["Remark"].ToString().Trim() == "")
{
model.Remark = "";
}
else
{
model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]);
}
return(model);
}
else
{
return(null);
}
}
