/// <summary>
/// 评论数量
/// </summary>
protected int Comment_Count(int _kindId, int _parentId)
{
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
int _num = bll.GetCount("KindId=" + _kindId + " and ParentId=" + _parentId);
return(_num);
}
private void RptBind(string strWhere, string orderby)
{
if (!int.TryParse(Request.Params["page"] as string, out this.page))
{
this.page = 0;
}
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
//获得总条数
this.pcount = bll.GetCount(strWhere);
if (this.pcount > 0)
{
this.lbtnDel.Enabled = true;
this.lbtnAudit.Enabled = true;
}
else
{
this.lbtnDel.Enabled = false;
this.lbtnAudit.Enabled = false;
}
if (this.kindId >= 0)
{
this.ddlKindId.SelectedValue = this.kindId.ToString();
}
this.txtKeywords.Text = this.keywords;
this.ddlProperty.SelectedValue = this.property;
this.rptList.DataSource = bll.GetPageList(this.pagesize, this.page, strWhere, orderby);
this.rptList.DataBind();
}
//审核
protected void lbtnAudit_Click(object sender, EventArgs e)
{
chkLoginLevel("editReviews");
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("cb_id");
if (cb.Checked)
{
bll.UpdateField(id, "IsLock=0");
//保存日志
SaveLogs("[评论信息]审核评论信息，信息ID：" + id);
}
}
JscriptPrint("批量审核通过啦！", "List.aspx?" + CombUrlTxt(this.kindId, this.parentId, this.keywords, this.property) + "page=0", "Success");
}
/// <summary>
/// 绑定Repeater控件数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Comment_List_DataBind(object sender, EventArgs e)
{
Repeater _rpt = sender as Repeater;
if (_rpt == null)
{
return;
}
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
//绑定数据
if (_rpt.PageSize > 0)
{
_rpt.DataSource = bll.GetPageList(_rpt.PageSize, _rpt.PageIndex, _rpt.Where, "AddTime desc");
}
else
{
_rpt.DataSource = bll.GetList(_rpt.Top, _rpt.Where, "AddTime desc");
}
_rpt.DataBind();
}
public void ProcessRequest(HttpContext context)
{
string action = context.Request.Params["action"];
if (action == "add")
{
//取得站点配置信息
DtCms.Model.WebSet webset = new DtCms.BLL.WebSet().loadConfig(Utils.GetXmlMapPath("Configpath"));
int _kindId;
int _parentId;
string _code = context.Request.Form["txtCode"];
string _username = context.Request.Form["txtUserName"];
int _grade;
string _content = context.Request.Form["txtContent"];
//获得栏目ID
if (!int.TryParse(context.Request.Params["kindId"] as string, out _kindId))
{
context.Response.Write("{msg:0, msgbox:\"无法找到你所要评论的栏目！\"}");
return;
}
//获得信息ID
if (!int.TryParse(context.Request.Params["parentId"] as string, out _parentId))
{
context.Response.Write("{msg:0, msgbox:\"无法找到你所要评论的信息！\"}");
return;
}
//校检验证码
if (string.IsNullOrEmpty(_code))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入验证码！\"}");
return;
}
if (context.Session["DtCode"] == null)
{
context.Response.Write("{msg:0, msgbox:\"对不起，系统找不到生成的验证码！\"}");
return;
}
if (_code.ToLower() != (context.Session["DtCode"].ToString()).ToLower())
{
context.Response.Write("{msg:0, msgbox:\"您输入的验证码与系统的不一致！\"}");
return;
}
//获得评价星级
if (!int.TryParse(context.Request.Form["hidStar"] as string, out _grade))
{
context.Response.Write("{msg:0, msgbox:\"请对此商品作出评价再提交！\"}");
return;
}
//检查用户名
if (string.IsNullOrEmpty(_username))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您的昵称！\"}");
return;
}
//检查输入的内容
if (string.IsNullOrEmpty(_content))
{
context.Response.Write("{msg:0, msgbox:\"请输入您要评论的信息内容！\"}");
return;
}
//开始写入数据
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
DtCms.Model.AllReviews model = new DtCms.Model.AllReviews();
model.KindId = _kindId;
model.ParentId = _parentId;
model.UserName = _username.Trim();
model.Grade = _grade;
model.Content = Utils.ToHtml(_content);
model.IsLock = webset.IsCheckComment; //评论是否需要审核
model.AddTime = DateTime.Now;
bll.Add(model);
context.Response.Write("{msg:1, msgbox:\"您的评论已提交成功，感谢您的支持！\"}");
return;
}
else if (action == "list")
{
int kindId;
int parentId;
int pageIndex;
int pageSize;
//获得栏目ID
if (!int.TryParse(context.Request.Params["kindId"] as string, out kindId))
{
context.Response.Write("错误提示1，请勿提交非法字符！");
return;
}
//获得信息ID
if (!int.TryParse(context.Request.Params["parentId"] as string, out parentId))
{
context.Response.Write("错误提示2，请勿提交非法字符！");
return;
}
//获得当前页
if (!int.TryParse(context.Request.Params["pageIndex"] as string, out pageIndex))
{
context.Response.Write("错误提示3，请勿提交非法字符！");
return;
}
//获得每页大小
if (!int.TryParse(context.Request.Params["pageSize"] as string, out pageSize))
{
context.Response.Write("错误提示4，请勿提交非法字符！");
return;
}
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
DataSet ds = bll.GetPageList(pageSize, pageIndex, "IsLock=0 and KindId=" + kindId + " and ParentId=" + parentId, "AddTime desc");
//如果记录存在
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
context.Response.Write("<div class=\"item\">\n");
context.Response.Write("<div class=\"user\">\n");
context.Response.Write("<span class=\"u-name\">网友：" + dr["UserName"].ToString() + "</span>\n");
context.Response.Write("<span class=\"star star" + dr["Grade"].ToString() + "\"></span>\n");
context.Response.Write("<span class=\"date-ask\">" + dr["AddTime"] + "</span>\n");
context.Response.Write("</div>\n");
context.Response.Write("<dl class=\"answer\">\n");
context.Response.Write("<dt><b></b>评论内容：</dt>\n");
context.Response.Write("<dd><div class=\"content\">" + dr["Content"].ToString() + "</div></dd>\n");
context.Response.Write("</dl>\n");
context.Response.Write("</div>\n");
}
}
else
{
//context.Response.Write("<p>暂无评论信息！</p>");
}
}
}
