public static int UpdateTbl_Message(Tbl_Message tbl_message)
{
WebCommon.Public.WriteLog("修改内部消息：" + tbl_message.MessageInfo);
tbl_message.DealUser = WebCommon.Public.GetUserName();
tbl_message.DealTime = DateTime.Now;
return(new Tbl_MessageService().UpdateTbl_MessageById(tbl_message));
}
public ActionResult MessageDelete(int id)
{
var session = HttpContext.Session;
if (session != null)
{
HttpContext.Session.TryGetValue("token", out var result);
if (result != null)
{
TempData["memberID"] = HttpContext.Session.GetString("memberID");
int memberID = Convert.ToInt32(TempData["memberID"].ToString());
Tbl_Message message = _tbl_MessageService.Get(id);
_tbl_MessageService.Delete(message);
int count = _tbl_MessageService.GetAll().Where(x => x.MessageRequestID == message.MessageRequestID && x.SenderMemberID == message.SenderMemberID).Count();
if (count > 0)
{
return(RedirectToAction("Message", "GeneralPage", new { id = message.MessageRequestID }));
}
return(RedirectToAction("Message", "GeneralPage"));
}
}
return(RedirectToAction("Index", "GeneralPage"));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_Message> getTbl_MessagesBySql(string sql)
{
IList <Tbl_Message> list = new List <Tbl_Message>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_Message tbl_message = new Tbl_Message();
tbl_message.ID = Convert.ToInt32(dr["ID"]);
tbl_message.UserNameFrom = Convert.ToString(dr["UserNameFrom"]);
tbl_message.UserNameTo = Convert.ToString(dr["UserNameTo"]);
tbl_message.MessageInfo = Convert.ToString(dr["MessageInfo"]);
tbl_message.MessageFile = Convert.ToString(dr["MessageFile"]);
tbl_message.Status = Convert.ToString(dr["Status"]);
tbl_message.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_message.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_message.DealUser = Convert.ToString(dr["DealUser"]);
tbl_message.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_message);
}
}
return(list);
}
public int AddTbl_Message(Tbl_Message tbl_message)
{
string sql = "insert into [Tbl_Message] ([UserNameFrom],[UserNameTo],[MessageInfo],[MessageFile],[Status],[DealUser]) values (@UserNameFrom,@UserNameTo,@MessageInfo,@MessageFile,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserNameFrom", tbl_message.UserNameFrom),
new SqlParameter("@UserNameTo", tbl_message.UserNameTo),
new SqlParameter("@MessageInfo", tbl_message.MessageInfo),
new SqlParameter("@MessageFile", tbl_message.MessageFile),
new SqlParameter("@Status", tbl_message.Status),
new SqlParameter("@DealUser", tbl_message.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public JsonResult MemberRequestMessage(int id)
{
var session = HttpContext.Session;
if (session != null)
{
HttpContext.Session.TryGetValue("token", out var result);
if (result != null)
{
TempData["isLoggedIn"] = HttpContext.Session.GetString("token");
TempData["memberID"] = HttpContext.Session.GetString("memberID");
int memberID = Convert.ToInt32(TempData["memberID"].ToString());
Tbl_Ad ad = _AdService.Get(id);
Tbl_Request Request = _RequestService.GetAll().Where(x => x.AdID == id && x.RequestMemberID == memberID).LastOrDefault();
Tbl_Message messagednm = _tbl_MessageService.GetAll().Where(x => x.MessageRequestID == Request.RequestID).LastOrDefault();
Tbl_Message lastMessage = new Tbl_Message();
if (messagednm == null)
{
Tbl_Request newRequest = new Tbl_Request()
{
AdID = id,
RequestMemberID = memberID,
RequestStateID = 1
};
_RequestService.Add(newRequest);
Tbl_Request lastRequest = _RequestService.GetAll().LastOrDefault();
Tbl_Message message = new Tbl_Message
{
SenderMemberID = memberID,
Message = "Konu Başlığı: " + ad.AdTitle,
MessageDate = DateTime.Now,
MessageRequestID = lastRequest.RequestID,
};
_tbl_MessageService.Add(message);
lastMessage = _tbl_MessageService.GetAll().LastOrDefault();
}
else
{
lastMessage = _tbl_MessageService.GetAll().Where(x => x.MessageRequestID == Request.RequestID).LastOrDefault();
}
// return RedirectToAction("Message", "GeneralPage", new { id = lastMessage.MessageRequestID });
return(Json(new { id = lastMessage.MessageID }));
}
}
return(Json("Giriş Yapınız"));
}
public static int AddTbl_Message(Tbl_Message tbl_message)
{
WebCommon.Public.WriteLog("添加内部消息：" + tbl_message.MessageInfo);
//foreach (var obj in tbl_message.UserNameTo.Split(','))
//{
// WebCommon.Public.WriteAlert(obj, "消息", tbl_message.MessageInfo, "views/Message_Detail.aspx?ID=" + tbl_message.ID.ToString());
//}
//return new Tbl_MessageService().AddTbl_Message(tbl_message);
int InfoID = new Tbl_MessageService().AddTbl_Message(tbl_message);
foreach (var obj in tbl_message.UserNameTo.Split(','))
{
WebCommon.Public.WriteAlert(obj, "消息", tbl_message.MessageInfo, "views/Message_Detail.aspx?ID=" + InfoID.ToString());
}
return(InfoID);
}
public int UpdateTbl_MessageById(Tbl_Message tbl_message)
{
string sql = "update [Tbl_Message] set [UserNameFrom]=@UserNameFrom,[UserNameTo]=@UserNameTo,[MessageInfo]=@MessageInfo,[MessageFile]=@MessageFile,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_message.ID),
new SqlParameter("@UserNameFrom", tbl_message.UserNameFrom),
new SqlParameter("@UserNameTo", tbl_message.UserNameTo),
new SqlParameter("@MessageInfo", tbl_message.MessageInfo),
new SqlParameter("@MessageFile", tbl_message.MessageFile),
new SqlParameter("@Status", tbl_message.Status),
new SqlParameter("@DealUser", tbl_message.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public JsonResult MessageDelete(int id)
{
var session = HttpContext.Session;
if (session != null)
{
HttpContext.Session.TryGetValue("token", out var result);
if (result != null)
{
TempData["memberID"] = HttpContext.Session.GetString("memberID");
int memberID = Convert.ToInt32(TempData["memberID"].ToString());
Tbl_Message message = _tbl_MessageService.Get(id);
_tbl_MessageService.Delete(message);
return(Json(new { id = message.MessageRequestID }));
// return RedirectToAction("Message", "GeneralPage", new { id = message.MessageRequestID });
}
}
return(Json("Giriş Yapın"));
}
public ActionResult MessageSend(MessageDetailViewModel model)
{
var session = HttpContext.Session;
if (session != null)
{
HttpContext.Session.TryGetValue("token", out var result);
if (result != null)
{
TempData["memberID"] = HttpContext.Session.GetString("memberID");
int memberID = Convert.ToInt32(TempData["memberID"].ToString());
Tbl_Message message = model.messageSend;
message.SenderMemberID = memberID;
message.MessageDate = DateTime.Now;
_tbl_MessageService.Add(message);
return(RedirectToAction("Message", "GeneralPage", new { id = message.MessageRequestID }));
}
}
return(RedirectToAction("Index", "GeneralPage"));
}
public void Update(Tbl_Message Parameter)
{
_Tbl_MessageDal.Update(Parameter);
}
public void Delete(Tbl_Message Parameter)
{
_Tbl_MessageDal.Delete(Parameter);
}
public void Add(Tbl_Message Parameter)
{
_Tbl_MessageDal.Add(Parameter);
}
