static string strWhere = ""; //Sql语句 为什么要放外面因为AspNetPager1_PageChanged事件也要用到
//应该完成了 搜索操作
protected void btSearch_Click(object sender, EventArgs e)
{
BLL.CMS_Column bcol = new BLL.CMS_Column();
AspNetPager1.CurrentPageIndex = 1;
string strEndTime = ""; //结束时间，要拿来加1
if (ddlKeyType.Value == "PostDate") //选的是时间
{
if (BLL.Validator.IsStringDate(EntTime1.Value) && BLL.Validator.IsStringDate(EntTime2.Value))
{
strEndTime = DateTime.Parse(EntTime2.Value).AddDays(1).ToString();
strWhere = " PostDate between '" + EntTime1.Value + "' and '" + strEndTime + "'";
}
else
{
JavaScript("alert(\"请输入合法格式的日期\");");
}
}
else //选的是标题||作者||栏目||
{
if (txtKeyWord.Text != String.Empty || txtKeyWord.Text != "")
{
strWhere = ddlKeyType.Value == "Column" ? "c.title" : ("a." + ddlKeyType.Value);
strWhere += " like '%" + txtKeyWord.Text.Trim() + "%'";
}
}
btShowAll.Visible = true;
Flush(strWhere);
}
// 更新DDL里面Column的可选项
public void FlushColumn()
{
//只能列出满足下列条件的栏目：不能是跳转网址的栏目，也不能是有子栏目的栏目
BLL.CMS_Column bcol = new BLL.CMS_Column();
DataTable dt2 = bcol.GetList("(Len(GotoUrl)=0 or GotoUrl is NULL) and id not in (select distinct ParentId from CMS_Column)").Tables[0];
foreach (DataRow dr in dt2.Rows)
{
ListItem li = new ListItem();
li.Text = GetColumnName(dr["Title"].ToString(), dr["Code"].ToString());
li.Value = dr["Id"].ToString();
ddlColumnId.Items.Add(li);
}
}