/// <summary> /// 插入评论 /// ok: 成功,err:失败 /// /// 创建标识:一木鱼 20080507 /// </summary> private void InsertComment() { String strMsg = ""; Result lastresult = Result.Null; string body = XYRequest.GetQueryString("CommentBody").Trim(); string newsId = XYRequest.GetQueryString("NewsID").Trim(); string isHiddenIP = XYRequest.GetQueryString("IsHiddenIP").Trim(); string vcode = XYRequest.GetQueryString("code").Trim(); long _newsId = XYECOM.Core.MyConvert.GetInt64(newsId); if (body.Equals("") || _newsId == 0) { strMsg = "评论失败"; lastresult = Result.Failed; } //如果启用验证码 if (XYECOM.Configuration.Security.Instance.IsEnabledValidateCode(XYECOM.Configuration.ValidateCodeItem.Comment)) { if (!CheckCode(vcode)) { ResponseXML(Result.Failed, "验证码不正确!"); } } XYECOM.Model.NewsDiscussInfo info = new XYECOM.Model.NewsDiscussInfo(); info.IpAddress = XYECOM.Core.XYRequest.GetIP(); info.IpIsShow = isHiddenIP.Equals("1") ? false : true; info.ND_Content = content.Server.HtmlEncode(body); info.NS_ID = _newsId; info.U_ID = 0; info.U_Name = "游客"; if (Business.CheckUser.CheckUserLogin()) { info.U_ID = Business.CheckUser.UserInfo.userid; info.U_Name = Business.CheckUser.UserInfo.LoginName; } info.ND_IsShow = true; int result = new XYECOM.Business.NewsDiscuss().Insert(info); if (result <= 0) { strMsg = "评论失败"; lastresult = Result.Failed; ResponseXML(lastresult, strMsg); } else { XYECOM.Core.Utils.ClearSession("VNum"); strMsg = "评论成功"; lastresult = Result.Success; ResponseXML(lastresult, strMsg); } }
private void GetNewsComment() { string strdata = ""; Result result = Result.Null; XYECOM.Business.NewsDiscuss newsDiscussBLL = new XYECOM.Business.NewsDiscuss(); string newsId = XYECOM.Core.XYRequest.GetQueryString("value"); if (newsId.Equals("")) { ResponseXML(Result.Null, "数据不完整!"); } string strColumuName = " ND_ID, U_Name,U_Flag, U_ID, ND_Content, ND_AddTime,IPIsShow,IPAddress "; int topNum = 4; int clikcNum = 0; clikcNum = XYECOM.Core.Function.Updateinfo(" where NS_ID=" + XYECOM.Core.XYRequest.GetQueryString("value"), "n_News", "NS_Count"); DataTable tableDiscuss = newsDiscussBLL.GetDataTable(newsId, "", strColumuName, topNum); if (tableDiscuss.Rows.Count <= 0) { ResponseXML(Result.Failed, "没有评论信息!"); } string userType = ""; string userName = ""; string shopUrl = ""; for (int i = 0; i < tableDiscuss.Rows.Count; i++) { userName = tableDiscuss.Rows[i]["U_Name"].ToString(); if (tableDiscuss.Rows[i]["U_ID"].ToString() == "0") { userType = "guest"; shopUrl = ""; } else { if (tableDiscuss.Rows[i]["U_Flag"].ToString().ToLower().Equals("true")) { userType = "user"; if (webInfo.IsDomain) shopUrl = "http://" + tableDiscuss.Rows[i]["U_Name"].ToString() + HttpContext.Current.Request.ServerVariables["HTTP_HOST"].Substring(HttpContext.Current.Request.ServerVariables["HTTP_HOST"].IndexOf(".")) + "/"; else shopUrl = webInfo.WebDomain + "shop/" + tableDiscuss.Rows[i]["U_Name"].ToString() + "/index." + webInfo.WebSuffix; } else { userType = "person"; shopUrl = ""; } } strdata += "<comment>" + "<user>" + " <name>" + userName + "</name>" + " <shopurl>" + shopUrl + "</shopurl>" + " <type>" + userType + "</type>" + "</user>" + "<sendtime>" + tableDiscuss.Rows[i]["ND_AddTime"].ToString() + "</sendtime>" + "<content>" + content.Server.HtmlEncode(XYECOM.Business.FiltrateKeyWord.LeachKeyWord(tableDiscuss.Rows[i]["ND_Content"].ToString())) + "</content>" + "</comment>"; } result = Result.Success; ResponseXML(result, "", strdata); }