Пример #1
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
        clients.GetClientsByType(elt_account_number, "All");

        ColumnsCollection tmpCols = e.Layout.Bands[0].Columns;

        tmpCols.FromKey("auto_uid").Hidden = true;

        tmpCols.FromKey("po_num").Header.Caption   = "Pickup Order No";
        tmpCols.FromKey("MAWB_NUM").Header.Caption = "Master AWB/BL";
        tmpCols.FromKey("HAWB_NUM").Header.Caption = "House AWB/BL";

        tmpCols.FromKey("Shipper_Name").Header.Caption     = "Shipper";
        tmpCols.FromKey("Pickup_Name").Header.Caption      = "Pickup From";
        tmpCols.FromKey("Carrier_Name").Header.Caption     = "Delivery To";
        tmpCols.FromKey("Origin_Port_Code").Header.Caption = "From";
        tmpCols.FromKey("Dest_Port_Code").Header.Caption   = "To";
        tmpCols.FromKey("ModifiedDate").Header.Caption     = "Last Modified";
        tmpCols.FromKey("file_type").Header.Caption        = "File Type";

        tmpCols.FromKey("ModifiedDate").Format = "MM/dd/yyyy";

        tmpCols.FromKey("file_type").Width        = Unit.Pixel(60);
        tmpCols.FromKey("Shipper_Name").Width     = Unit.Pixel(150);
        tmpCols.FromKey("Pickup_Name").Width      = Unit.Pixel(150);
        tmpCols.FromKey("Carrier_Name").Width     = Unit.Pixel(150);
        tmpCols.FromKey("Origin_Port_Code").Width = Unit.Pixel(50);
        tmpCols.FromKey("Dest_Port_Code").Width   = Unit.Pixel(50);
        tmpCols.FromKey("ModifiedDate").Width     = Unit.Pixel(80);
    }
Пример #2
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
        clients.GetClientsByType(elt_account_number, "All");

        UltraGridColumn ConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("consignee_acct");

        ConsigneeCol.Type = ColumnType.DropDownList;
        ConsigneeCol.ValueList.DataSource    = clients.Tables["All"];
        ConsigneeCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
        ConsigneeCol.ValueList.ValueMember   = clients.Tables["All"].Columns["org_account_number"].ToString();
        ConsigneeCol.ValueList.DataBind();
        ConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));

        UltraGridColumn ShipperCol = UltraWebGrid1.Bands[0].Columns.FromKey("customer_acct");

        ShipperCol.Type = ColumnType.DropDownList;
        ShipperCol.ValueList.DataSource    = clients.Tables["All"];
        ShipperCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
        ShipperCol.ValueList.ValueMember   = clients.Tables["All"].Columns["org_account_number"].ToString();
        ShipperCol.ValueList.DataBind();
        ShipperCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));

        ColumnsCollection tmpCols = e.Layout.Bands[0].Columns;

        tmpCols.FromKey("created_date").Format = "MM/dd/yyyy";
        tmpCols.FromKey("shipout_date").Format = "MM/dd/yyyy";

        tmpCols.FromKey("auto_uid").Hidden = true;

        tmpCols.FromKey("so_num").Header.Caption         = "Shipout No";
        tmpCols.FromKey("created_date").Header.Caption   = "Created Date";
        tmpCols.FromKey("shipout_date").Header.Caption   = "Shipout Date";
        tmpCols.FromKey("consignee_acct").Header.Caption = "Ship To";
        tmpCols.FromKey("customer_acct").Header.Caption  = "Customer";
        tmpCols.FromKey("file_type").Header.Caption      = "File Type";
        tmpCols.FromKey("house_num").Header.Caption      = "House AWB/BL";
        tmpCols.FromKey("master_num").Header.Caption     = "Master AWB/BL";
        tmpCols.FromKey("file_type").Header.Caption      = "File Type";
    }
Пример #3
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        UltraWebGrid      uwg      = (UltraWebGrid)e.Layout.Grid;
        ColumnsCollection mawbCols = uwg.Bands[0].Columns;
        ColumnsCollection hawbCols = uwg.Bands[1].Columns;
        ColumnsCollection itemCols = uwg.Bands[2].Columns;

        //hiding uneccessary columns
        mawbCols.FromKey("elt_account_number").Hidden     = true;
        mawbCols.FromKey("shipper_account_number").Hidden = true;
        mawbCols.FromKey("createddate").Hidden            = true;
        mawbCols.FromKey("createdby").Hidden = true;

        hawbCols.FromKey("elt_account_number").Hidden     = true;
        hawbCols.FromKey("mawb_num").Hidden               = true;
        hawbCols.FromKey("shipper_account_number").Hidden = true;
        hawbCols.FromKey("agent_no").Hidden               = true;
        hawbCols.FromKey("createddate").Hidden            = true;
        hawbCols.FromKey("modifiedby").Hidden             = true;

        itemCols.FromKey("elt_account_number").Hidden = true;
        itemCols.FromKey("hawb_num").Hidden           = true;
        itemCols.FromKey("mawb_num").Hidden           = true;

        // renaming headers
        mawbCols.FromKey("mawb_num").Header.Caption                = "Master AWB";
        mawbCols.FromKey("shipper_name").Header.Caption            = "Shipper";
        mawbCols.FromKey("dep_airport_code").Header.Caption        = "From";
        mawbCols.FromKey("to_1").Header.Caption                    = "To 1";
        mawbCols.FromKey("to_2").Header.Caption                    = "To 2";
        mawbCols.FromKey("total_gross_weight").Header.Caption      = "Gross Wt.";
        mawbCols.FromKey("total_chargeable_weight").Header.Caption = "Charge Wt.";
        mawbCols.FromKey("weight_scale").Header.Caption            = "Scale";
        mawbCols.FromKey("createddate").Header.Caption             = "Created";
        mawbCols.FromKey("createdby").Header.Caption               = "By";

        hawbCols.FromKey("hawb_num").Header.Caption                = "House AWB";
        hawbCols.FromKey("shipper_name").Header.Caption            = "Shipper";
        hawbCols.FromKey("agent_name").Header.Caption              = "Agent";
        hawbCols.FromKey("total_chargeable_weight").Header.Caption = "Charge Wt.";
        hawbCols.FromKey("weight_scale").Header.Caption            = "Scale";
        hawbCols.FromKey("createddate").Header.Caption             = "Created";
        hawbCols.FromKey("modifiedby").Header.Caption              = "By";

        itemCols.FromKey("item_type").Header.Caption   = "Item Type";
        itemCols.FromKey("item_desc").Header.Caption   = "Item Name";
        itemCols.FromKey("item_amount").Header.Caption = "Item Amount";
        itemCols.FromKey("vendor_no").Header.Caption   = "Vendor";

        // format data
        mawbCols.FromKey("createddate").Format = "MM/dd/yyyy";
        hawbCols.FromKey("createddate").Format = "MM/dd/yyyy";

        FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
        clients.GetClientsByType(elt_account_number, "All");
        UltraGridColumn vendorCol = itemCols.FromKey("vendor_no");

        vendorCol.Type = ColumnType.DropDownList;
        vendorCol.ValueList.DataSource    = clients.Tables["All"];
        vendorCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
        vendorCol.ValueList.ValueMember   = clients.Tables["All"].Columns["org_account_number"].ToString();
        vendorCol.ValueList.DataBind();
        vendorCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", 0));

        mawbCols.FromKey("mawb_num").Width                = Unit.Pixel(120);
        mawbCols.FromKey("shipper_name").Width            = Unit.Pixel(200);
        mawbCols.FromKey("dep_airport_code").Width        = Unit.Pixel(50);
        mawbCols.FromKey("to_1").Width                    = Unit.Pixel(50);
        mawbCols.FromKey("to_2").Width                    = Unit.Pixel(50);
        mawbCols.FromKey("total_gross_weight").Width      = Unit.Pixel(80);
        mawbCols.FromKey("total_chargeable_weight").Width = Unit.Pixel(80);
        mawbCols.FromKey("weight_scale").Width            = Unit.Pixel(40);
        mawbCols.FromKey("Revenue").Width                 = Unit.Pixel(80);
        mawbCols.FromKey("Expense").Width                 = Unit.Pixel(80);
        mawbCols.FromKey("createddate").Width             = Unit.Pixel(80);
        mawbCols.FromKey("createdby").Width               = Unit.Pixel(80);
        mawbCols.FromKey("Profit").Width                  = Unit.Pixel(80);

        hawbCols.FromKey("hawb_num").Width                = Unit.Pixel(138);
        hawbCols.FromKey("shipper_name").Width            = Unit.Pixel(200);
        hawbCols.FromKey("agent_name").Width              = Unit.Pixel(200);
        hawbCols.FromKey("total_chargeable_weight").Width = Unit.Pixel(80);
        hawbCols.FromKey("weight_scale").Width            = Unit.Pixel(40);
        hawbCols.FromKey("Revenue").Width     = Unit.Pixel(80);
        hawbCols.FromKey("Expense").Width     = Unit.Pixel(80);
        hawbCols.FromKey("createddate").Width = Unit.Pixel(80);
        hawbCols.FromKey("modifiedby").Width  = Unit.Pixel(80);
        hawbCols.FromKey("Profit").Width      = Unit.Pixel(80);

        itemCols.FromKey("item_type").Width   = Unit.Pixel(80);
        itemCols.FromKey("item_desc").Width   = Unit.Pixel(160);
        itemCols.FromKey("item_amount").Width = Unit.Pixel(80);
        itemCols.FromKey("vendor_no").Width   = Unit.Pixel(150);
    }
Пример #4
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        ColumnsCollection routeCols   = e.Layout.Bands[0].Columns;
        ColumnsCollection airlineCols = e.Layout.Bands[1].Columns;
        ColumnsCollection weightCols  = e.Layout.Bands[2].Columns;

        //hiding uneccessary columns
        routeCols.FromKey("elt_account_number").Hidden   = true;
        routeCols.FromKey("rate_type").Hidden            = true;
        airlineCols.FromKey("origin_port").Hidden        = true;
        airlineCols.FromKey("dest_port").Hidden          = true;
        airlineCols.FromKey("kg_lb").Hidden              = true;
        airlineCols.FromKey("elt_account_number").Hidden = true;
        airlineCols.FromKey("rate_type").Hidden          = true;
        weightCols.FromKey("airline").Hidden             = true;
        weightCols.FromKey("origin_port").Hidden         = true;
        weightCols.FromKey("dest_port").Hidden           = true;
        weightCols.FromKey("kg_lb").Hidden              = true;
        weightCols.FromKey("airline").Hidden            = true;
        weightCols.FromKey("item_no").Hidden            = true;
        weightCols.FromKey("elt_account_number").Hidden = true;
        weightCols.FromKey("rate_type").Hidden          = true;
        weightCols.FromKey("share").Hidden              = true;
        weightCols.FromKey("fl_rate").Hidden            = true;
        weightCols.FromKey("sec_rate").Hidden           = true;
        weightCols.FromKey("include_fl_rate").Hidden    = true;
        weightCols.FromKey("include_sec_rate").Hidden   = true;

        // renaming headers
        routeCols.FromKey("origin_port").Header.Caption        = "Origin Port";
        routeCols.FromKey("dest_port").Header.Caption          = "Destination Port";
        routeCols.FromKey("kg_lb").Header.Caption              = "Unit";
        airlineCols.FromKey("share").Header.Caption            = "Share (%)";
        airlineCols.FromKey("airline").Header.Caption          = "Airline (Code)";
        airlineCols.FromKey("fl_rate").Header.Caption          = "Fuel Sur (%)";
        airlineCols.FromKey("sec_rate").Header.Caption         = "Security Sur (%)";
        airlineCols.FromKey("include_fl_rate").Header.Caption  = "Fuel Profit Sharing";
        airlineCols.FromKey("include_sec_rate").Header.Caption = "Security Profit Sharing";
        weightCols.FromKey("weight_break").Header.Caption      = "Weight Break";
        weightCols.FromKey("rate").Header.Caption              = "Rate (%)";

        ////////////////////////////////////////////////////////////////////

        FreightEasy.Ports.ALLPorts ports = new FreightEasy.Ports.ALLPorts();
        ports.GetAllPorts(elt_account_number, "All");
        FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
        clients.GetClientsByType(elt_account_number, "Airlines");

        //////////////////////////////////////////////////////////////////////

        UltraGridColumn KgLbCol = UltraWebGrid1.Bands[0].Columns.FromKey("kg_lb");

        KgLbCol.Type = ColumnType.DropDownList;
        KgLbCol.ValueList.ValueListItems.Add(new ValueListItem("LB", "L"));
        KgLbCol.ValueList.ValueListItems.Add(new ValueListItem("KG", "K"));
        KgLbCol.ValueList.Style.Font.Size = FontUnit.Point(8);
        KgLbCol.Width = Unit.Pixel(80);

        UltraGridColumn OriginPortCol = UltraWebGrid1.Bands[0].Columns.FromKey("origin_port");

        OriginPortCol.Type = ColumnType.DropDownList;
        OriginPortCol.ValueList.DataSource    = ports.Tables["All"];;
        OriginPortCol.ValueList.DisplayMember = ports.Tables["All"].Columns["port_display"].ToString();
        OriginPortCol.ValueList.ValueMember   = ports.Tables["All"].Columns["port_code"].ToString();
        OriginPortCol.ValueList.DataBind();
        OriginPortCol.ValueList.Style.Font.Size = FontUnit.Point(8);
        OriginPortCol.Width = Unit.Pixel(200);

        UltraGridColumn DestPortCol = UltraWebGrid1.Bands[0].Columns.FromKey("dest_port");

        DestPortCol.Type = ColumnType.DropDownList;
        DestPortCol.ValueList.DataSource    = ports.Tables["All"];
        DestPortCol.ValueList.DisplayMember = ports.Tables["All"].Columns["port_display"].ToString();
        DestPortCol.ValueList.ValueMember   = ports.Tables["All"].Columns["port_code"].ToString();
        DestPortCol.ValueList.DataBind();
        DestPortCol.ValueList.Style.Font.Size = FontUnit.Point(8);
        DestPortCol.Width = Unit.Pixel(200);

        UltraGridColumn AirlineCol = UltraWebGrid1.Bands[1].Columns.FromKey("airline");

        AirlineCol.Type = ColumnType.DropDownList;
        AirlineCol.ValueList.DataSource    = clients.Tables["Airlines"];
        AirlineCol.ValueList.DisplayMember = clients.Tables["Airlines"].Columns["airline_display"].ToString();
        AirlineCol.ValueList.ValueMember   = clients.Tables["Airlines"].Columns["carrier_code"].ToString();
        AirlineCol.ValueList.DataBind();
        AirlineCol.ValueList.Style.Font.Size = FontUnit.Point(8);
        AirlineCol.Width = Unit.Pixel(250);

        UltraGridColumn IncFlRateCol = UltraWebGrid1.Bands[1].Columns.FromKey("include_fl_rate");

        IncFlRateCol.Type = ColumnType.DropDownList;
        IncFlRateCol.ValueList.ValueListItems.Add(new ValueListItem("Yes", "Y"));
        IncFlRateCol.ValueList.ValueListItems.Add(new ValueListItem("No", "N"));
        IncFlRateCol.ValueList.Style.Font.Size = FontUnit.Point(8);
        IncFlRateCol.Width = Unit.Pixel(100);

        UltraGridColumn IncSecRateCol = UltraWebGrid1.Bands[1].Columns.FromKey("include_sec_rate");

        IncSecRateCol.Type = ColumnType.DropDownList;
        IncSecRateCol.ValueList.ValueListItems.Add(new ValueListItem("Yes", "Y"));
        IncSecRateCol.ValueList.ValueListItems.Add(new ValueListItem("No", "N"));
        IncSecRateCol.ValueList.Style.Font.Size = FontUnit.Point(8);
        IncSecRateCol.Width = Unit.Pixel(120);

        UltraWebGrid1.Bands[1].Columns.FromKey("share").Width    = Unit.Pixel(80);
        UltraWebGrid1.Bands[1].Columns.FromKey("fl_rate").Width  = Unit.Pixel(80);
        UltraWebGrid1.Bands[1].Columns.FromKey("sec_rate").Width = Unit.Pixel(90);
    }
Пример #5
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        ColumnsCollection aesCols = e.Layout.Bands[0].Columns;

        FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
        clients.GetClientsByType(elt_account_number, "Consignees");
        clients.GetClientsByType(elt_account_number, "Shippers");

        UltraGridColumn ConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("consignee_acct");

        ConsigneeCol.Type = ColumnType.DropDownList;
        ConsigneeCol.ValueList.DataSource    = clients.Tables["Consignees"];
        ConsigneeCol.ValueList.DisplayMember = clients.Tables["Consignees"].Columns["dba_name"].ToString();
        ConsigneeCol.ValueList.ValueMember   = clients.Tables["Consignees"].Columns["org_account_number"].ToString();
        ConsigneeCol.ValueList.DataBind();
        ConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));

        UltraGridColumn InterConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("inter_consignee_acct");

        InterConsigneeCol.Type = ColumnType.DropDownList;
        InterConsigneeCol.ValueList.DataSource    = clients.Tables["Consignees"];
        InterConsigneeCol.ValueList.DisplayMember = clients.Tables["Consignees"].Columns["dba_name"].ToString();
        InterConsigneeCol.ValueList.ValueMember   = clients.Tables["Consignees"].Columns["org_account_number"].ToString();
        InterConsigneeCol.ValueList.DataBind();
        InterConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));

        UltraGridColumn ShipperCol = UltraWebGrid1.Bands[0].Columns.FromKey("shipper_acct");

        ShipperCol.Type = ColumnType.DropDownList;
        ShipperCol.ValueList.DataSource    = clients.Tables["Shippers"];
        ShipperCol.ValueList.DisplayMember = clients.Tables["Shippers"].Columns["dba_name"].ToString();
        ShipperCol.ValueList.ValueMember   = clients.Tables["Shippers"].Columns["org_account_number"].ToString();
        ShipperCol.ValueList.DataBind();
        ShipperCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));

        aesCols.FromKey("shipment_ref_no").Header.Caption      = "Ship Ref No";
        aesCols.FromKey("aes_status").Header.Caption           = "AES Status";
        aesCols.FromKey("aes_itn").Header.Caption              = "ITN No.";
        aesCols.FromKey("shipper_acct").Header.Caption         = "USPPI";
        aesCols.FromKey("house_num").Header.Caption            = "House AWB";
        aesCols.FromKey("master_num").Header.Caption           = "Master AWB";
        aesCols.FromKey("consignee_acct").Header.Caption       = "Consignee";
        aesCols.FromKey("inter_consignee_acct").Header.Caption = "Inter Consignee";
        aesCols.FromKey("export_date").Header.Caption          = "Export Date";
        aesCols.FromKey("origin_state").Header.Caption         = "Origin";
        aesCols.FromKey("dest_country").Header.Caption         = "Destination";
        aesCols.FromKey("export_carrier").Header.Caption       = "Carrier";
        aesCols.FromKey("export_port").Header.Caption          = "From";
        aesCols.FromKey("unloading_port").Header.Caption       = "To";
        aesCols.FromKey("tran_date").Header.Caption            = "Submit Date";

        aesCols.FromKey("export_date").Format = "MM/dd/yyyy";
        aesCols.FromKey("tran_date").Format   = "MM/dd/yyyy";

        aesCols.FromKey("auto_uid").Hidden            = true;
        aesCols.FromKey("aes_status").Width           = new Unit("80px");
        aesCols.FromKey("shipment_ref_no").Width      = new Unit("90px");
        aesCols.FromKey("shipper_acct").Width         = new Unit("160px");
        aesCols.FromKey("consignee_acct").Width       = new Unit("160px");
        aesCols.FromKey("inter_consignee_acct").Width = new Unit("160px");
        aesCols.FromKey("export_date").Width          = new Unit("70px");
        aesCols.FromKey("origin_state").Width         = new Unit("40px");
        aesCols.FromKey("dest_country").Width         = new Unit("65px");
        aesCols.FromKey("export_carrier").Width       = new Unit("110px");
        aesCols.FromKey("export_port").Width          = new Unit("40px");
        aesCols.FromKey("unloading_port").Width       = new Unit("40px");
        aesCols.FromKey("tran_date").Width            = new Unit("70px");

        aesCols.FromKey("shipment_ref_no").Hidden      = true;
        aesCols.FromKey("consignee_acct").Hidden       = true;
        aesCols.FromKey("inter_consignee_acct").Hidden = true;
        aesCols.FromKey("origin_state").Hidden         = true;
        aesCols.FromKey("dest_country").Hidden         = true;
        aesCols.FromKey("export_carrier").Hidden       = true;
    }
Пример #6
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        UltraWebGrid      uwg      = (UltraWebGrid)e.Layout.Grid;
        ColumnsCollection mawbCols = uwg.Bands[0].Columns;
        ColumnsCollection hawbCols = uwg.Bands[1].Columns;
        ColumnsCollection itemCols = uwg.Bands[2].Columns;

        //hiding uneccessary columns
        mawbCols.FromKey("elt_account_number").Hidden = true;
        mawbCols.FromKey("shipper_acct_num").Hidden   = true;

        hawbCols.FromKey("elt_account_number").Hidden = true;
        hawbCols.FromKey("booking_num").Hidden        = true;
        hawbCols.FromKey("shipper_acct_num").Hidden   = true;
        hawbCols.FromKey("agent_no").Hidden           = true;

        itemCols.FromKey("elt_account_number").Hidden = true;
        itemCols.FromKey("booking_num").Hidden        = true;
        itemCols.FromKey("hbol_num").Hidden           = true;

        // renaming headers
        mawbCols.FromKey("booking_num").Header.Caption    = "Booking No";
        mawbCols.FromKey("loading_port").Header.Caption   = "FROM";
        mawbCols.FromKey("unloading_port").Header.Caption = "To";
        mawbCols.FromKey("gross_weight").Header.Caption   = "Gross Wt.";

        hawbCols.FromKey("hbol_num").Header.Caption     = "House B/L";
        hawbCols.FromKey("shipper_name").Header.Caption = "Shipper";
        hawbCols.FromKey("agent_name").Header.Caption   = "Agent";
        hawbCols.FromKey("gross_weight").Header.Caption = "Gross Wt.";

        itemCols.FromKey("item_type").Header.Caption   = "Item Type";
        itemCols.FromKey("item_desc").Header.Caption   = "Item Name";
        itemCols.FromKey("item_amount").Header.Caption = "Item Amount";
        itemCols.FromKey("vendor").Header.Caption      = "Vendor";

        FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
        clients.GetClientsByType(elt_account_number, "All");
        UltraGridColumn vendorCol = itemCols.FromKey("vendor");

        vendorCol.Type = ColumnType.DropDownList;
        vendorCol.ValueList.DataSource    = clients.Tables["All"];
        vendorCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
        vendorCol.ValueList.ValueMember   = clients.Tables["All"].Columns["org_account_number"].ToString();
        vendorCol.ValueList.DataBind();
        vendorCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", 0));

        mawbCols.FromKey("booking_num").Width    = Unit.Pixel(120);
        mawbCols.FromKey("shipper_name").Width   = Unit.Pixel(200);
        mawbCols.FromKey("loading_port").Width   = Unit.Pixel(50);
        mawbCols.FromKey("unloading_port").Width = Unit.Pixel(50);
        mawbCols.FromKey("gross_weight").Width   = Unit.Pixel(80);
        mawbCols.FromKey("Revenue").Width        = Unit.Pixel(80);
        mawbCols.FromKey("Expense").Width        = Unit.Pixel(80);
        mawbCols.FromKey("Profit").Width         = Unit.Pixel(80);

        hawbCols.FromKey("hbol_num").Width     = Unit.Pixel(138);
        hawbCols.FromKey("shipper_name").Width = Unit.Pixel(200);
        hawbCols.FromKey("agent_name").Width   = Unit.Pixel(200);
        hawbCols.FromKey("gross_weight").Width = Unit.Pixel(80);
        hawbCols.FromKey("Revenue").Width      = Unit.Pixel(80);
        hawbCols.FromKey("Expense").Width      = Unit.Pixel(80);
        hawbCols.FromKey("Profit").Width       = Unit.Pixel(80);

        itemCols.FromKey("item_type").Width   = Unit.Pixel(80);
        itemCols.FromKey("item_desc").Width   = Unit.Pixel(160);
        itemCols.FromKey("item_amount").Width = Unit.Pixel(80);
        itemCols.FromKey("vendor").Width      = Unit.Pixel(150);
    }