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); }
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"; }
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); }
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); }
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; }
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); }