private void BindList() { DataTable myTable = comBLL.GetData("UserName='******'"); myTable = pg.pagination(myTable, 10, ""); pageInfo = pg.pageNumList; StringBuilder sb = new StringBuilder(); List <ClassLibrary.Model.RouteClass> rcList = new List <ClassLibrary.Model.RouteClass>(); if (myTable.Rows.Count != 0) { ClassLibrary.BLL.RouteClass rcBLL = new ClassLibrary.BLL.RouteClass(); rcList = rcBLL.GetModelList(string.Empty); } int rowIndex = 0; foreach (DataRow dr in myTable.Rows) { sb.Append("<tr'>"); ClassLibrary.Model.Routes route = routeBLL.GetModel(Convert.ToInt32(dr["routeID"])); string tmpClassPy = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == route.LocationID); }).ClassNamePY; sb.AppendFormat("<td align='center'>{0}</td>", ++rowIndex); sb.AppendFormat("<td align='center'><a href='{3}/{2}/{0}.html' target='_blank'>{1}</a></td>", dr["routeID"].ToString(), route.Title, tmpClassPy, SysConfig.webSite); sb.AppendFormat("<td align='center'>{0}</td>", GetGradeImg(dr["Grade"].ToString())); sb.AppendFormat("<td align='center'>{0}</td>", dr["Content"].ToString()); sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["Checked"]) ? "<span class='red'>已审核</span>" : "审核中"); sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["CreatedTime"]).ToString("yyyy-MM-dd")); sb.Append("</tr>"); } if (sb.Length == 0) { sb.Append("<tr><td colspan='6'>暂无评价!</td></tr>"); } dataList = sb.ToString(); }
private void BindData() { DataTable myTable = routeCommentBLL.GetData(" id =" + routeCommentId); if (myTable.Rows.Count == 1) { userName = myTable.Rows[0]["UserName"].ToString(); nickname = myTable.Rows[0]["Nickname"].ToString(); anonymous = Convert.ToBoolean(myTable.Rows[0]["Anonymous"]) ? "是" : "否"; route = GetRoute(Convert.ToInt32(myTable.Rows[0]["routeID"].ToString())); grade = Convert.ToInt32(myTable.Rows[0]["Grade"]); email = myTable.Rows[0]["Email"].ToString(); content = myTable.Rows[0]["Content"].ToString(); checkeds = Convert.ToBoolean(myTable.Rows[0]["Checked"]) ? "是" : "否"; createdTime = Convert.ToDateTime(myTable.Rows[0]["CreatedTime"]); } else { Function.goMessagePage("显示路线评论", "操作失败,数据不存在!", "RouteComment/RouteCommentList.aspx"); } }
private void BindData(string sql) { DataTable myTable = routeCommentBLL.GetData(sql); myTable = pg.pagination(myTable, 20, ""); pageInfo = pg.pageNumList; StringBuilder sb = new StringBuilder(); foreach (DataRow dr in myTable.Rows) { sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString()); ClassLibrary.Model.Routes rmodel = routeBLL.GetModel(Convert.ToInt32(dr["routeId"])); string tmpClassPy = rcList.Find(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ID == rmodel.LocationID); }).ClassNamePY; sb.AppendFormat("<td><a href='/{2}/{1}.html' target='_blank'>{0}</a></td>", Function.Clip(GetRoute(Convert.ToInt32(dr["routeID"])), 10, true), Convert.ToInt32(dr["routeID"]), tmpClassPy); sb.AppendFormat("<td>{0}</td>", Convert.ToInt16(dr["Grade"].ToString())); sb.AppendFormat("<td>{0}</td>", dr["UserName"].ToString()); sb.AppendFormat("<td>{0}</td>", dr["Nickname"].ToString()); sb.AppendFormat("<td>{0}</td>", dr["Email"].ToString()); sb.AppendFormat("<td>{0}</td>", Convert.ToBoolean(dr["Checked"]) ? "<span class='green'>是</span>" : "<span class='red'>否</span>"); sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString()); sb.Append("<td>"); if (!Convert.ToBoolean(dr["Checked"])) { sb.AppendFormat("<a href='RouteCommentList.aspx?ID={0}'>审核</a> ", dr["ID"].ToString()); } else { sb.Append(" "); } sb.AppendFormat("<a href='RouteCommentDetail.aspx?id={0}'>查看</a> ", dr["ID"].ToString()); sb.AppendFormat("<a href='javascript:void(0)' onclick='routeCommentDelete({0})'>删除</a>", dr["ID"].ToString()); sb.Append("</td>"); sb.Append("</tr>"); } dataRouteCommentList = sb.ToString(); }
//添加评论 private void AddComment() { if (!isLogin) { Response.Write("<script>alert('仅登录会员可评论...');history.back(-1);</script>"); return; } ClassLibrary.Model.RouteComment model = new ClassLibrary.Model.RouteComment(); model.routeID = Convert.ToInt32(Function.GetFormString("routeID")); model.Nickname = Function.GetFormString("Nickname"); model.Email = HttpUtility.HtmlEncode(Function.GetFormString("Email")); model.Grade = Convert.ToByte(Function.GetFormString("xing")); model.Content = HttpUtility.HtmlEncode(Function.GetFormString("Content")); string pingyin = Function.GetFormString("pingyin"); model.UserName = userName; if (!string.IsNullOrEmpty(Function.GetFormString("Anonymous"))) { model.Anonymous = Convert.ToBoolean(Function.GetFormString("Anonymous")); } model.Checked = false; if (Session["ValidateCode"] == null) { Response.Write("<script>alert('验证码输入错误,请重新输入。');history.back(-1);</script>"); return; } else if (Request.Form["yanz"] != Session["ValidateCode"].ToString()) { Response.Write("<script>alert('验证码输入错误,请重新输入。');history.back(-1);</script>"); return; } DataTable myTable = cmtBLL.GetData("routeID=" + model.routeID); DateTime lastTime = DateTime.Now; bool existcomment = false; foreach (DataRow dr in myTable.Rows) { lastTime = DateTime.Parse(dr["CreatedTime"].ToString()); existcomment = true; break; } System.TimeSpan ts = DateTime.Now - lastTime; if (existcomment && ts.Days == 0 && ts.Hours == 0 && ts.Minutes <= 3) { Response.Write("<script>alert('请3分钟后重新输入!');history.back(-1);</script>"); return; } if (cmtBLL.Add(model) > 0) { Response.Write("<script>alert('评论成功!');location.href='/" + pingyin + "/" + model.routeID + ".html';</script>"); } else { Response.Write("<script>alert('评论失败,数据错误,请重试。。。');location.href='/" + pingyin + "/" + model.routeID + ".html';</script>"); } }