/// <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));
}
