private void BindData()
{
#region 组装查询条件
string whereStr = " group_id = " + (int)EnumCollection.examination_group.心理测试 + " and parent_id = " + this.chapter;
//string whereStr = " 1 = 1 ";
string _keywords = keywords.Replace("'", "");
if (!string.IsNullOrEmpty(_keywords))
{
if (Utils.IsSafeSqlString(_keywords))
{
whereStr += " and (name like '%" + _keywords + "%')";
}
else
{
JscriptMsg("搜索关键词中包含危险字符，检索终止！", Utils.CombUrlTxt("questionnaire_list.aspx", "keywords={0}", ""));
return;
}
}
//if (this.chapter > 0)
//{
// whereStr += " parent_id = " + this.chapter;
//}
#endregion
Model.course_chapter ccModel = new BLL.course_chapter().GetModel(chapter);
if (ccModel != null)
{
chapter_name = ccModel.name;
Model.course_info course = new BLL.course_info().GetModel(ccModel.course_id);
if (course != null)
{
course_name = course.name;
}
else
{
JscriptMsg("传递参数错误", "back");
return;
}
}
else
{
JscriptMsg("传递参数错误", "back");
return;
}
this.page = RequestHelper.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.common_examination bll = new BLL.common_examination();
this.rptList.DataSource = bll.GetListByPage(whereStr, "ID DESC", this.page, this.pageSize);
this.rptList.DataBind();
this.totalCount = bll.GetRecordCount(whereStr);
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("questionnaire_list.aspx", "keywords={0}&page={1}&chapter={2}", this.keywords, "__id__", this.chapter + "");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void BindData()
{
#region 组装查询条件
string whereStr = " 1 = 1 ";
string _keywords = keywords.Replace("'", "");
if (!string.IsNullOrEmpty(_keywords))
{
if (Utils.IsSafeSqlString(_keywords))
{
whereStr += " and (Title like '%" + _keywords + "%')";
}
else
{
JscriptMsg("搜索关键词中包含危险字符，检索终止！", Utils.CombUrlTxt("Manage.aspx", "keywords={0}", ""));
return;
}
}
#endregion
this.page = RequestHelper.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.common_examination bll = new BLL.common_examination();
this.rptList.DataSource = bll.GetListByPage(whereStr, "ID DESC", this.page, this.pageSize);
this.rptList.DataBind();
this.totalCount = bll.GetRecordCount(whereStr);
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("Manage.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}