Пример #1
0
    protected void BindRequestList()
    {
        BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest();
        int rowcount = ucCustomPagerItems.isCountRecord;

        string status = ViewState["Status"].ToString();



        try
        {
            if ((status == "RFQ SENT" || status == "QUOTE RECEIVED") && !chkShowAllPendingApproval.Checked)
            {
                Approver_ID = UDFLib.ConvertToInteger(Session["userid"]);
            }

            DataSet ds = new DataSet();
            ds = treq.GetRequestList(UDFLib.ConvertIntegerToNull(cmbFleet.SelectedValue), UDFLib.ConvertIntegerToNull(cmbVessel.SelectedValue), UDFLib.ConvertIntegerToNull(cmbSupplier.SelectedValue),
                                     UDFLib.ConvertStringToNull(txtSectorFrom.Text), UDFLib.ConvertStringToNull(txtSectorTo.Text), UDFLib.ConvertStringToNull(txtTrvDateFrom.Text)
                                     , UDFLib.ConvertStringToNull(txtTrvDateTo.Text), UDFLib.ConvertStringToNull(txtPaxName.Text), UDFLib.ConvertStringToNull(status), UDFLib.ConvertIntegerToNull(Approver_ID), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);


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

            rptParent.DataSource = ds;
            rptParent.DataBind();
        }
        catch { }
        finally { treq = null; }
    }
Пример #2
0
 public DataSet GetRequestList(int vessel_id, string stage, string request_id, string pax_name, string airport, int agent_id)
 {
     try
     {
         BLL_TRV_TravelRequest objTrv = new BLL_TRV_TravelRequest();
         DataSet ds       = new DataSet();
         int     rowcount = 1;
         ds = objTrv.GetRequestList(vessel_id, stage, request_id, pax_name, airport, agent_id, ref rowcount);
         return(ds);
     }
     catch (Exception ex)
     {
         CustomSoapException(ex.GetType().Name, ex.Message);
         return(null);
     }
 }