示例#1
0
    protected void Load_CategoryList()
    {
        DataTable dt = OPS_Admin.Get_CategoryList(txtfilter.Text);

        GridView_Category.DataSource = dt;
        GridView_Category.DataBind();
    }
示例#2
0
    protected void Load_CategoryList()
    {
        DataTable dt = BLL_Crew_Evaluation.Get_CategoryList(txtfilter.Text);

        GridView_Category.DataSource = dt;
        GridView_Category.DataBind();
    }
示例#3
0
    protected void Search_Worklist_Type()
    {
        DataTable dt = BLL_Tec_WorklistType.TEC_GET_WORKLISTYPE().Tables[0];

        GridView_Category.DataSource = dt;
        GridView_Category.DataBind();
    }
示例#4
0
    protected void Search_WorkCategory()
    {
        int rowcount   = ucCustomPagerItems.isCountRecord;
        int SearchRows = 0;
        int TotalRows  = 0;

        JRA_Lib JRALib_Data = new JRA_Lib();

        JRALib_Data.SearchText = txtfilter.Text.Trim();
        JRALib_Data.SearchCate = ddlFiter.SelectedValue == "0" ? null : ddlFiter.SelectedValue;
        JRALib_Data.PageNumber = ucCustomPagerItems.CurrentPageIndex;
        JRALib_Data.PageSize   = ucCustomPagerItems.PageSize;

        DataTable dt = BLL_JRA_Work_Category.JRA_SEARCH_WORK_CATEGORY(JRALib_Data);

        GridView_Category.DataSource = dt;
        GridView_Category.DataBind();

        if (dt.Rows.Count > 0)
        {
            SearchRows = Convert.ToInt32(dt.Rows[0]["SearchRows"]);
            TotalRows  = Convert.ToInt32(dt.Rows[0]["TotalRows"]);
        }

        if (ucCustomPagerItems.isCountRecord == 1)
        {
            rowcount = SearchRows;
            ucCustomPagerItems.CountTotalRec = Convert.ToString(TotalRows);
            ucCustomPagerItems.BuildPager();
        }
    }
示例#5
0
    protected void Load_CategoryList()
    {
        string    SearchText = txtCategory.Text;
        DataTable dt         = objBLL.Get_Survay_CategoryList(SearchText);

        GridView_Category.DataSource = dt;
        GridView_Category.DataBind();
    }
示例#6
0
    public void BindSurveyCategory()
    {
        try
        {
            int rowcount = ucCustomPagerItems.isCountRecord;

            string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
            int?   sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
            {
                sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
            }


            DataTable dt = objBLL.Get_Survey_Category_Search(txtfilter.Text != "" ? txtfilter.Text : null, sortbycoloumn, sortdirection
                                                             , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);

            if (ucCustomPagerItems.isCountRecord == 1)
            {
                ucCustomPagerItems.CountTotalRec = rowcount.ToString();
                ucCustomPagerItems.BuildPager();
            }

            GridView_Category.DataSource = dt;
            GridView_Category.DataBind();

            if (dt.Rows.Count > 0)
            {
                ImgExpExcel.Visible = true;
            }
            else
            {
                ImgExpExcel.Visible = false;
            }
        }
        catch (Exception ex)
        {
            UDFLib.WriteExceptionLog(ex);
        }
    }