/// <summary> /// 添加留言信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddContactMessage(WebContactMessageModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WebContactMessage("); strSql.Append("MemberID,MemberName,MemberPhone,MessageTitle,MessageContent,AddTime,MStatus"); strSql.Append(") values ("); strSql.Append("@MemberID,@MemberName,@MemberPhone,@MessageTitle,@MessageContent,GETDATE(),1"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.Int), new SqlParameter("@MemberName", SqlDbType.NVarChar), new SqlParameter("@MemberPhone", SqlDbType.NVarChar), new SqlParameter("@MessageTitle", SqlDbType.NVarChar), new SqlParameter("@MessageContent", SqlDbType.NVarChar) }; parameters[0].Value = model.MemberID; parameters[1].Value = model.MemberName; parameters[2].Value = model.MemberPhone; parameters[3].Value = model.MessageTitle; parameters[4].Value = model.MessageContent; object obj = helper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 回复会员留言 /// </summary> public bool UpdateMsg(WebContactMessageModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WebContactMessage set "); strSql.Append(" ReplyTime = GETDATE() , "); strSql.Append(" MStatus = 2 , "); strSql.Append(" ReplyContent = @ReplyContent "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@ReplyContent", SqlDbType.NVarChar) }; parameters[0].Value = model.ID; parameters[1].Value = model.ReplyContent; int rows = helper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public ActionResult UpdateMsg(WebContactMessageModel updatemodel) { if (updatemodel != null) { bool row = bll.UpdateMsg(updatemodel); } return(RedirectToAction("MemberMsg", "SiteMsg", new { area = "AdminArea" })); }
/// <summary> /// 查询会员的留言信息 /// </summary> /// <param name="userid"></param> /// <returns></returns> public List <WebContactMessageModel> GetContractMessage(int userid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, ReplyTime, MemberID, MemberName, MemberPhone, MessageTitle, MessageContent, AddTime, MStatus, ReplyContent,CASE MStatus WHEN 1 THEN '新留言' WHEN 2 THEN '已回复' WHEN 3 THEN '删除' END AS MStatusName "); strSql.Append(" from WebContactMessage "); strSql.Append(" where MemberID=@MemberID"); strSql.Append(" Order By ID Desc "); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.Int) }; parameters[0].Value = userid; List <WebContactMessageModel> list = new List <WebContactMessageModel>(); DataSet ds = helper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { WebContactMessageModel model = new WebContactMessageModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["ReplyTime"].ToString() != "") { model.ReplyTime = DateTime.Parse(item["ReplyTime"].ToString()); } if (item["MemberID"].ToString() != "") { model.MemberID = int.Parse(item["MemberID"].ToString()); } model.MemberName = item["MemberName"].ToString(); model.MemberPhone = item["MemberPhone"].ToString(); model.MessageTitle = item["MessageTitle"].ToString(); model.MessageContent = item["MessageContent"].ToString(); if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["MStatus"].ToString() != "") { model.MStatus = int.Parse(item["MStatus"].ToString()); } model.ReplyContent = item["ReplyContent"].ToString(); model.MStatusName = item["MStatusName"].ToString(); list.Add(model); } return(list); } else { return(null); } }
/// <summary> /// 查询所有的会员留言信息 /// </summary> /// <param name="userid"></param> /// <returns></returns> public List <WebContactMessageModel> GetAllContractMessage() { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, ReplyTime, MemberID, MemberName, MemberPhone, MessageTitle, MessageContent, AddTime, MStatus, case MStatus when 1 then '刚提问' when 2 then '已回复' when 3 then '删除' end as MStatusName,ReplyContent "); strSql.Append(" from WebContactMessage "); strSql.Append(" Order By ID Desc "); List <WebContactMessageModel> list = new List <WebContactMessageModel>(); DataSet ds = helper.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { WebContactMessageModel model = new WebContactMessageModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["ReplyTime"].ToString() != "") { model.ReplyTime = DateTime.Parse(item["ReplyTime"].ToString()); } if (item["MemberID"].ToString() != "") { model.MemberID = int.Parse(item["MemberID"].ToString()); } model.MemberName = item["MemberName"].ToString(); model.MemberPhone = item["MemberPhone"].ToString(); model.MessageTitle = item["MessageTitle"].ToString(); model.MessageContent = item["MessageContent"].ToString(); if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["MStatus"].ToString() != "") { model.MStatus = int.Parse(item["MStatus"].ToString()); } model.ReplyContent = item["ReplyContent"].ToString(); model.MStatusName = item["MStatusName"].ToString(); list.Add(model); } return(list); } else { return(null); } }
public ActionResult contentus(WebContactMessageModel message) { MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel; if (logmember == null) { return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" })); } if (message != null) { message.MemberID = logmember.ID; message.MemberName = logmember.TruethName; message.MemberPhone = logmember.MobileNum; int row = newsbll.AddContactMessage(message); } return(RedirectToAction("contentus", "WebHome", new { area = "NewTemplateArea" })); }
/// <summary> /// 添加留言信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddContactMessage(WebContactMessageModel model) { return(dal.AddContactMessage(model)); }
/// <summary> /// 回复会员留言 /// </summary> public bool UpdateMsg(WebContactMessageModel model) { return(dal.UpdateMsg(model)); }