Beispiel #1
0
    protected void Load_Crew_Queries()
    {
        int    FleetCode         = UDFLib.ConvertToInteger(ddlFleet.SelectedValue);
        int    Vessel_ID         = UDFLib.ConvertToInteger(ddlVessel.SelectedValue);
        int    Query_Type        = UDFLib.ConvertToInteger(ddlQueryType.SelectedValue);
        int    Status            = UDFLib.ConvertToInteger(rdoStatus.SelectedValue);
        int    PAGE_SIZE         = ucCustomPager_CrewQueries.PageSize;
        int    PAGE_INDEX        = ucCustomPager_CrewQueries.CurrentPageIndex;
        int    SelectRecordCount = ucCustomPager_CrewQueries.isCountRecord;
        string SortBy            = (ViewState["SORTBY"] == null) ? null : (ViewState["SORTBY"].ToString());
        int?   SortDirection     = null;

        if (ViewState["SORTDIRECTION"] != null)
        {
            SortDirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
        }

        DataTable dt = BLL_Crew_Queries.Get_CrewQueries(FleetCode, Vessel_ID, 0, Query_Type, Status, txtFilterText.Text, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, SortBy, SortDirection);

        ddlQueryType.DataSource = dt;

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

        if (ucCustomPager_CrewQueries.isCountRecord == 1)
        {
            ucCustomPager_CrewQueries.CountTotalRec = SelectRecordCount.ToString();
            ucCustomPager_CrewQueries.BuildPager();
        }
    }
Beispiel #2
0
    protected void Load_Crew_Queries()
    {
        int    FleetCode         = 0;
        int    Vessel_ID         = 0;
        int    CrewID            = UDFLib.ConvertToInteger(Request.QueryString["CrewID"]);
        int    Query_Type        = 0;
        int    Status            = 0;
        int    PAGE_SIZE         = 1000;
        int    PAGE_INDEX        = 1;
        int    SelectRecordCount = 0;
        string SortBy            = (ViewState["SORTBY"] == null) ? null : (ViewState["SORTBY"].ToString());
        int?   SortDirection     = null;

        if (ViewState["SORTDIRECTION"] != null)
        {
            SortDirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
        }

        DataTable dt = BLL_Crew_Queries.Get_CrewQueries(FleetCode, Vessel_ID, CrewID, Query_Type, Status, null, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, SortBy, SortDirection);

        GridView_CrewQueries.DataSource = dt;
        GridView_CrewQueries.DataBind();
    }