/// <summary> /// 添加图书评论的回复2 /// </summary> /// <returns></returns> public string AddBookCommentReplyAgain() { int BookRemarkReplyId = int.Parse(context.Request.Form["iBookRemarkReplyId"].ToString()); //对哪条回复的回复 BookRemarkReply ReplyTo = BookDetailsDAL.m_BookRemarkReplyDal.GetModel(BookRemarkReplyId); int UserId = ReplyTo.UserId; string UserName = "******" + ReplyTo.UserName; string sBookRemarksReplyAgain = context.Request.Form["sBookRemarksReplyAgain"].ToString(); rm.Success = true; try { BookRemarkReply bookRemarkReply = new BookRemarkReply(); bookRemarkReply.BookRemarkId = ReplyTo.BookRemarkId; bookRemarkReply.BookId = ReplyTo.BookId; bookRemarkReply.UserId = UserId; bookRemarkReply.BookRemarksReply = sBookRemarksReplyAgain; bookRemarkReply.UserName = UserName; bookRemarkReply.ClientIP = WebHelp.GetIP(); bookRemarkReply.CreatedTime = DateTime.Now; if (CRegex.FilterHTML(bookRemarkReply.BookRemarksReply) == "") { rm.Info = "内容不能为空"; return(jss.Serialize(rm)); } int iBookRemarkReplyId = BookDetailsDAL.m_BookRemarkReplyDal.Add(bookRemarkReply); } catch (Exception) { rm.Success = false; rm.Info = "未知错误"; } return(jss.Serialize(rm)); }
/// <summary> /// 添加图书评论 /// </summary> /// <returns></returns> public string AddBookComment() { int BookId = int.Parse(context.Request.Form["iBookId"].ToString()); User u = UserDal.CurrentUser(); int UserId = u.UserId; string UserName = u.UserName; string BookRemarks = context.Request.Form["sBookRemarks"].ToString(); rm.Success = true; try { BookRemark bookRemark = new BookRemark(); bookRemark.BookId = BookId; bookRemark.UserId = UserId; bookRemark.BookRemarks = BookRemarks; bookRemark.UserName = UserName; bookRemark.ClientIP = WebHelp.GetIP(); bookRemark.CreatedTime = DateTime.Now; if (CRegex.FilterHTML(bookRemark.BookRemarks) == "") { rm.Info = "内容不能为空"; return(jss.Serialize(rm)); } int iBookRemarkId = BookDetailsDAL.m_BookRemarkDal.Add(bookRemark); } catch (Exception) { rm.Success = false; rm.Info = "未知错误"; } return(jss.Serialize(rm)); }
public string GetShopList() { StringBuilder sb = new StringBuilder(); List <travel_shopper> list = travel_shopperDAL.m_travel_shopperDal.GetList("1=1", 10, page, true, "*"); foreach (var r in list) { string txt = CRegex.FilterHTML(r.shopper_content).Length > 120 ? CRegex.FilterHTML(r.shopper_content).Substring(0, 120) + "..." : CRegex.FilterHTML(r.shopper_content); sb.Append(string.Format(@"<a href=""TripList.aspx?id={0}""><div class=""shopname"" style=""font-size: 20px;font-weight:800;"">{1}</div> <div class=""shopdp""><img src=""{2}""></div> <div class=""shopcontent"" style=""text-indent:28px;"">{3}</div></a>", r.shopper_shopId, r.shopper_shopname, r.shopper_dp, r.shopper_content)); } return(sb.ToString()); }
public string GetGuideList() { StringBuilder sb = new StringBuilder(); List <travel_guide> list = travel_guideDAL.m_travel_guideDal.GetList("1=1", 10, page, true, "*"); foreach (var r in list) { string txt = CRegex.FilterHTML(r.guide_introduce).Length > 120 ? CRegex.FilterHTML(r.guide_introduce).Substring(0, 120) + "..." : CRegex.FilterHTML(r.guide_introduce); sb.Append(string.Format(@"<div class=""guidedp""><img src=""{0}""></div> <div class=""guidecardId"">导游证编号:{1}</div> <div class=""guidename"">姓名:{2}</div> <div class=""guideintroduce"">导游简介:{3}</div>", r.guide_dp, r.guide_guidecardId, r.guide_name, r.guide_introduce)); } return(sb.ToString()); }
public string GetBuycarList() { string listTitle = Session["listTitle"].ToString(); string listPrice = Session["listPrice"].ToString(); string listPicture = Session["listPicture"].ToString(); string listTxt = Session["listTxt"].ToString(); StringBuilder sb = new StringBuilder(); string txt = CRegex.FilterHTML(listTxt).Length > 120 ? CRegex.FilterHTML(listTxt).Substring(0, 120) + "..." : CRegex.FilterHTML(listTxt); string tit = CRegex.FilterHTML(listTitle).Length > 25 ? CRegex.FilterHTML(listTitle).Substring(0, 25) + "..." : CRegex.FilterHTML(listTitle); sb.Append(string.Format(@"<div class=""tripcard""><div class=""trippicture""><img src=""{0}""></div> <div class=""triptitle""><span style=""font-size: 20px;font-weight:800;"">{1}</span></div> <div class=""tripcontent"" style=""text-indent:28px;"">{2}</div> <div class=""tripprice"">¥{3}<span style=""font-size: 16px;margin-left: 3px;"">起</span></div><a class=""tripcount"" href=""UserPay.aspx"">立即支付</a></div>", listPicture, tit, txt, listPrice)); return(sb.ToString()); }
public string GetTripList() { StringBuilder sb = new StringBuilder(); List <travel_trip> list = travel_tripDAL.m_travel_tripDal.GetList("1=1", 10, page, true, "*"); foreach (var r in list) { string txt = CRegex.FilterHTML(r.trip_content).Length > 120 ? CRegex.FilterHTML(r.trip_content).Substring(0, 120) + "..." : CRegex.FilterHTML(r.trip_content); string tit = CRegex.FilterHTML(r.trip_name).Length > 25 ? CRegex.FilterHTML(r.trip_name).Substring(0, 25) + "..." : CRegex.FilterHTML(r.trip_name); sb.Append(string.Format(@"<a href=""TripLiskItem.aspx?id={0}""><div class=""trippicture""><img src=""{1}""></div> <div class=""triptitle""><span style=""font-size: 20px;font-weight:800;"">{2}</span></div> <div class=""tripcontent"" style=""text-indent:28px;"">{3}</div> <div class=""tripprice"">¥{4}<span style=""font-size: 16px;margin-left: 3px;"">起</span></div> <div class=""tripcount"">参与人数:{5}</div></a>", r.trip_tripId, r.trip_picutur, tit, txt, r.trip_price, r.trip_count)); } return(sb.ToString()); }
public string BindRews()//查询函数 返回拼凑好的列表 { StringBuilder sb1 = new StringBuilder(); try { //List<RNews> list = RNewsDAL.m_RNewsDal.GetList("NewsClass='线报活动'", pagesize, page, true, "*", "Id", para); DataTable dt = RNewsDAL.GetUserScoreTop(isclass, page); for (int i = 0; i < dt.Rows.Count; i++) { //sb1.Append(string.Format(@"1={0},2={1},3={2},4={3},5={4},6={5},7={6},8={7}", dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString(), dt.Rows[i][3].ToString(), dt.Rows[i][4].ToString(), dt.Rows[i][5].ToString(), dt.Rows[i][6].ToString(), dt.Rows[i][7].ToString())); sb1.Append(string.Format(@"<li><div class='thumbnail col-lg-3 col-md-3 col-sm-3 col-xs-3'><img src='{0}' alt=''></div>", dt.Rows[i][3].ToString())); sb1.Append(string.Format(@"<div class='detailed col-lg-9 col-md-9 col-sm-9 col-xs-9'><h3><a target='_blank' href='articleContent.aspx?id={0}'>{1}</a></h3>", dt.Rows[i][8].ToString(), dt.Rows[i][1].ToString())); sb1.Append(string.Format(@"<div class='wztime'><span >时间:{0}</span><span class='hidden-xs'>作者:{1}</span><span class='hidden-xs'>星级:<img src='img/s{2}.gif' alt=''></span>", dt.Rows[i][4].ToString(), dt.Rows[i][7].ToString(), dt.Rows[i][5].ToString())); sb1.Append(string.Format(@"<p class='wzxiangxi col-lg-12 col-md-12 col-sm-12 hidden-xs'>{0}</p></div></li>", CRegex.FilterHTML(dt.Rows[i][2].ToString()))); } //sb1.Append(string.Format(@"<li><a target='_blank' href=""/RNewsM.aspx?id={0}"" title=""{3}"">{1}</a><span>{2}</span></li>", i.ID, STitle, i.CreatedTime.ToShortDateString().ToString(), i.Title)); //GridView1.DataSource = list; // GridView1.DataBind(); } catch (Exception ex) { Response.Write("网站正在维修中..."); } return(sb1.ToString()); }
public string AddComment() { string title = context.Request.Form["title"].ToString(); string text = context.Request.Form["text"].ToString(); //过滤html标签再判断是否为空 if (CRegex.FilterHTML(text) == "") { rm.Info = "内容不能为空"; return(jss.Serialize(rm)); } else if (CRegex.FilterHTML(text).Length > 500 || CRegex.FilterHTML(text).Length < 6) { rm.Info = "问题内容长度在6~500之间"; return(jss.Serialize(rm)); } else { string strIP = WebHelp.GetIP(); User user = UserDal.CurrentUser();//获取当前登陆用户 List <dbParam> list = new List <dbParam>() { new dbParam() { ParamName = "@ClientIP", ParamValue = strIP }, new dbParam() { ParamName = "@UserId", ParamValue = user.UserId } }; #region 一IP,同一当前日期(年月日),可以确定当天评论次数。 List <WebComment> wList = WebCommentDAL.m_WebCommentDal.GetList(" ClientIP=@ClientIP and UserId=@UserId", list); int count = 0; if (wList.Count == 0) { count = 0; } else { string DateCurrent = string.Format("{0:D}", DateTime.Now);//设置当前日期(年-月-日) foreach (var w in wList) { if (DateCurrent == string.Format("{0:D}", w.CreatedTime)) { count++; } } } #endregion //同一用户不能一天超过三次留言 if (count >= 3) { rm.Info = "一天最多只能发帖三次"; jss.Serialize(rm); } else { if (user.Type < 0) { rm.Info = "只有已登录用户才能发帖"; jss.Serialize(rm); } else { WebComment webCom = new WebComment(); webCom.CommentTitle = title; webCom.CommentText = text; webCom.CreatedTime = DateTime.Now; webCom.ClientIP = WebHelp.GetIP(); webCom.UserId = user.UserId; WebCommentDAL.m_WebCommentDal.Add(webCom); rm.Success = true; rm.Info = "提交成功"; } } } return(jss.Serialize(rm)); }
/// <summary> /// 回复当前用户的评论 /// </summary> /// <returns></returns> public string AddReplyComment() { int webCommentId = Convert.ToInt32(context.Request.Form["webCommentId"].ToString()); string text = context.Request.Form["text"].ToString(); if (CRegex.FilterHTML(text) == "") { rm.Info = "内容不能为空"; return(jss.Serialize(rm)); } else if (CRegex.FilterHTML(text).Length > 500 || CRegex.FilterHTML(text).Length < 6) { rm.Info = "回复内容长度在6~500之间"; return(jss.Serialize(rm)); } else { string strIP = WebHelp.GetIP(); User user = UserDal.CurrentUser();//获取当前登陆用户 List <dbParam> list = new List <dbParam>() { new dbParam() { ParamName = "@ClientIP", ParamValue = strIP }, new dbParam() { ParamName = "@UserId", ParamValue = user.UserId } }; #region 一IP,同一当前日期(年月日),可以确定当天回复次数。 List <WebCommentReply> wcrList = CommentReplyDAL.m_WebCommentReplyDAL.GetList(" ClientIP=@ClientIP and UserId=@UserId", list); int count = 0; if (wcrList.Count == 0) { count = 0; } else { string DateCurrent = string.Format("{0:D}", DateTime.Now);//设置当前日期(年-月-日) foreach (var wcr in wcrList) { if (DateCurrent == string.Format("{0:D}", wcr.CreatedTime)) { count++; } } } #endregion //同一用户不能一天超过三次留言 if (count >= 3) { rm.Info = "一天最多只能回复三次"; jss.Serialize(rm); } else { if (user.Type < 0) { rm.Info = "只有已登录用户用户才能评论"; jss.Serialize(rm); } else { WebCommentReply webComReply = new WebCommentReply(); webComReply.WebCommentId = webCommentId; webComReply.UserId = user.UserId; webComReply.CommentReplyText = text; webComReply.CreatedTime = DateTime.Now; webComReply.ClientIP = WebHelp.GetIP(); CommentReplyDAL.m_WebCommentReplyDAL.Add(webComReply); rm.Success = true; rm.Info = "评论成功"; } } } return(jss.Serialize(rm)); }