Search.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Search : BasicPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Anthem.Manager.Register(this);
        Title = "站内搜索--" + Title;
        DataTable dt = WebFunction.dataTable("select code,name from [xk_Column] where isOut=0 order by code");
        ltColumn.Text = "<select id='column'><option value=''>请选择</option>";
        for (int i = 0; i < dt.Rows.Count; i++)
            ltColumn.Text += "<option value='" + dt.Rows[i][0].ToString() + "'>" + WebFunction.getColumnListName(dt.Rows[i][1].ToString(), dt.Rows[i][0].ToString()) + "</option>";
        ltColumn.Text += "</select>";
    }

    [Anthem.Method]
    public void getSearch(string keyType,string keyWord,string stime,string etime,string column,int page)
    {
        int pageSize = 20;
        int countNum = 0;
        int pageCount = 1;
        int currentPage = page == 0 ? 1 : page;
        string sqlStr = " from [xk_Content] where id>0";
        string whereStr = "";
        string orderStr = " order by id desc";
        if (column.Length > 0)
            whereStr += " and columnCode like '" + column + "%' ";
        if (keyType.Length > 0)
            whereStr += " and " + keyType + " like '%" + keyWord + "%' ";
        if (stime.Length < 8) stime = "1900-1-1";
        if (etime.Length < 8) etime = DateTime.Now.AddDays(1).ToShortDateString();
        whereStr += " and addDate between #" + stime + "# and #" + etime + "# ";

        sqlStr += whereStr;
        countNum = Convert.ToInt32(WebFunction.getValueByKey("count(id)", "xk_Content", "id>0" + whereStr));

        pageCount = countNum % pageSize == 0 ? countNum / pageSize : countNum / pageSize + 1;
        page = page > pageCount ? pageCount : page;

        if (page > 1)
            sqlStr = sqlStr + " and id not in (select top " + pageSize * (page - 1) + " id " + sqlStr + orderStr + ")";
        sqlStr += orderStr;
        sqlStr = "select top " + pageSize.ToString() + " id,title,columnId,columnName,viewNum,commentNum " + sqlStr;
        DataTable dt = WebFunction.dataTable(sqlStr);
        gvResult.DataSource = dt;
        gvResult.DataBind();
        ltPager.Text = WebFunction.PageList(pageSize, "getSearch(0",pageCount, page);
        plSearch.AutoUpdateAfterCallBack = true;
    }
}