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