Exemplo n.º 1
0
    private void BindGrid()
    {
        DateTime dtBegin = DateTime.Parse(tbx_begin.Text);
        DateTime dtEnd   = DateTime.Parse(tbx_end.Text).AddDays(1);

        DataTable dt = EWF_Task_JobBLL.GetJobHasDecision(int.Parse(Session["UserID"].ToString()), dtBegin, dtEnd);

        string condition = " 1 = 1 ";

        if (ddl_App.SelectedValue != "0")
        {
            condition += " AND App = '" + ddl_App.SelectedValue + "'";
        }
        if (tbx_MessageSubject.Text != "")
        {
            condition += " AND (Title like '%" + tbx_MessageSubject.Text + "%' OR MessageSubject like '%" + tbx_MessageSubject.Text + "%')";
        }
        if (ddl_DecisionResult.SelectedValue != "0")
        {
            condition += " AND (DecisionResultName='" + ddl_DecisionResult.SelectedItem.Text + "')";
        }

        dt.DefaultView.RowFilter = condition;
        dt.DefaultView.Sort      = " TaskID desc ";
        gv_List.DataSource       = dt.DefaultView;
        gv_List.TotalRecordCount = dt.DefaultView.Count;
        gv_List.PageIndex        = (int)ViewState["PageIndex"];
        gv_List.DataBind();
    }