コード例 #1
0
    protected void Load_CrewProcessingFee()
    {
        int    FleetCode       = UDFLib.ConvertToInteger(ddlFleet.SelectedValue);
        int    VesselID        = UDFLib.ConvertToInteger(ddlVessel.SelectedValue);
        int    ManningOfficeID = UDFLib.ConvertToInteger(ddlManningOffice.SelectedValue);
        int    Rank_Category   = UDFLib.ConvertToInteger(ddlRankCategory.SelectedValue);
        int    Crew_Status     = UDFLib.ConvertToInteger(ddlStatus.SelectedValue);
        int    Fee_Type        = UDFLib.ConvertToInteger(ddlFeeType.SelectedValue);
        int    Approved_Status = UDFLib.ConvertToInteger(rdoApprovedStatus.SelectedValue);
        string Sign_On_From    = txtSignOnFrom.Text;
        string Sign_On_To      = txtSignOnTo.Text;
        string Approved_From   = txtApprovedFrom.Text;
        string Approved_To     = txtApprovedTo.Text;
        string SearchText      = txtSearchText.Text;

        int     PAGE_SIZE         = ucCustomPager_CrewList.PageSize;
        int     PAGE_INDEX        = ucCustomPager_CrewList.CurrentPageIndex;
        int     SelectRecordCount = ucCustomPager_CrewList.isCountRecord;
        decimal GrandTotal        = 0;

        DataTable dt = BLL_Crew_Disbursement.Get_AllCrewFeeStatus(FleetCode, VesselID, ManningOfficeID, Rank_Category, GetSessionUserID(), Crew_Status, Fee_Type, Approved_Status, UDFLib.ConvertToDefaultDt(Sign_On_From), UDFLib.ConvertToDefaultDt(Sign_On_To), UDFLib.ConvertToDefaultDt(Approved_From), UDFLib.ConvertToDefaultDt(Approved_To), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref GrandTotal, int.Parse(ddlMonth.SelectedValue), int.Parse(ddlYear.SelectedValue), SearchText);

        lblGrandTotal.Text = GrandTotal.ToString();

        if (ucCustomPager_CrewList.isCountRecord == 1)
        {
            ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString();
            ucCustomPager_CrewList.BuildPager();
        }

        GridView_Crew.DataSource = dt;
        GridView_Crew.DataBind();
    }
コード例 #2
0
    protected void Load_Report()
    {
        int FleetCode = UDFLib.ConvertToInteger(ddlFleet.SelectedValue);
        int VesselID  = UDFLib.ConvertToInteger(ddlVessel.SelectedValue);

        string Sign_On_From = "";
        string Sign_On_To   = "";

        if (txtSignOnFrom.Text != "")
        {
            Sign_On_From = UDFLib.ConvertToDate(Convert.ToString(txtSignOnFrom.Text), UDFLib.GetDateFormat()).ToString();
        }

        if (txtSignOnTo.Text != "")
        {
            Sign_On_To = UDFLib.ConvertToDate(Convert.ToString(txtSignOnTo.Text), UDFLib.GetDateFormat()).ToString();
        }

        string SearchString = txtSearch.Text;

        int PAGE_SIZE         = ucCustomPager_CrewList.PageSize;
        int PAGE_INDEX        = ucCustomPager_CrewList.CurrentPageIndex;
        int SelectRecordCount = ucCustomPager_CrewList.isCountRecord;
        int TotalDays         = 0;

        DataTable dt = BLL_Crew_CrewList.Get_Super_Att_Vessel_Report(FleetCode, VesselID, Sign_On_From, Sign_On_To, SearchString, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref TotalDays);

        if (ucCustomPager_CrewList.isCountRecord == 1)
        {
            ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString();
            ucCustomPager_CrewList.BuildPager();
        }
        GridView_Crew.DataSource = dt;
        GridView_Crew.DataBind();
        lblGrandTotal.Text = TotalDays.ToString();
    }