Plan/List.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Plan_List : MojoCube.Api.UI.MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["q"] != null)
            {
                txtKeyword.Text = Request.QueryString["q"];
            }

            hlAdd.NavigateUrl = "Edit.aspx?active=" + Request.QueryString["active"];
            ViewState["OrderByKey"] = "pk_Plan";
            ViewState["OrderByType"] = true;
            GridBind();
            this.Title = "计划列表";
        }
    }

    protected void lnbSearch_Click(object sender, EventArgs e)
    {
        GridBind();
    }

    protected void ListPager_PageChanged(object sender, EventArgs e)
    {
        GridBind();
    }

    private void GridBind()
    {
        MojoCube.Api.UI.AdminPager pager = new MojoCube.Api.UI.AdminPager(ListPager);
        pager.PageSize = MojoCube.Office.String.PageSize();
        pager.ConnStr = MojoCube.Office.Connection.ConnString();
        pager.TableName = "View_Plan_List";
        pager.strGetFields = "*";

        string where = "fk_User=" + Session["UserID"].ToString();

        if (txtKeyword.Text.Trim() != "")
        {
            string keyword = MojoCube.Api.Text.CheckSql.Filter(txtKeyword.Text.Trim());
            where += " and Title like '%" + keyword + "%'";
        }

        pager.where = where;
        pager.fldName = ViewState["OrderByKey"].ToString();
        pager.OrderType = (bool)ViewState["OrderByType"];

        GridView1.DataSource = pager.GetTable();
        GridView1.DataBind();
    }