/// <summary>
/// 직급,직군 보이기 여부
/// </summary>
/// <param name="columnCollection"></param>
public static void VisiblePosColumn(ColumnsCollection columnCollection)
{
Biz_PositionInfos positionInfo = new Biz_PositionInfos();
DataTable dtPosNotUse = positionInfo.GetPositionInfoByUseYN("N").Tables[0];
foreach (DataRow dataRowPosNotUse in dtPosNotUse.Rows)
{
string col_key_id = string.Format("TGT_POS_{0}_ID", dataRowPosNotUse["POS_ID"]);
string col_key_name = string.Format("TGT_POS_{0}_NAME", dataRowPosNotUse["POS_ID"]);
string col_key_id_1 = string.Format("POS_{0}_ID", dataRowPosNotUse["POS_ID"]);
string col_key_name_1 = string.Format("POS_{0}_NAME", dataRowPosNotUse["POS_ID"]);
if (columnCollection.Exists(col_key_id))
{
columnCollection.FromKey(col_key_id).Hidden = true;
}
if (columnCollection.Exists(col_key_name))
{
columnCollection.FromKey(col_key_name).Hidden = true;
}
if (columnCollection.Exists(col_key_id_1))
{
columnCollection.FromKey(col_key_id_1).Hidden = true;
}
if (columnCollection.Exists(col_key_name_1))
{
columnCollection.FromKey(col_key_name_1).Hidden = true;
}
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection AirlineCols = uwg.Bands[0].Columns;
ColumnsCollection WeightBreakCols = uwg.Bands[1].Columns;
AirlineCols.FromKey("airline").Hidden = true;
WeightBreakCols.FromKey("airline").Hidden = true;
AirlineCols.FromKey("dba_name").Header.Caption = "Airline";
AirlineCols.FromKey("carrier_code").Header.Caption = "Carrier Code";
AirlineCols.FromKey("share").Header.Caption = "Profit Share (%)";
WeightBreakCols.FromKey("weight_break").Header.Caption = "Weight Break";
WeightBreakCols.FromKey("kg_lb").Header.Caption = "Kg/Lb";
WeightBreakCols.FromKey("rate").Header.Caption = "Freight Charge Rate";
WeightBreakCols.FromKey("fl_rate").Header.Caption = "Fuel Surcharge Rate";
WeightBreakCols.FromKey("sec_rate").Header.Caption = "Securoty Surcharge Rate";
WeightBreakCols.FromKey("weight_break").Width = Unit.Pixel(100);
WeightBreakCols.FromKey("kg_lb").Width = Unit.Pixel(35);
WeightBreakCols.FromKey("rate").Width = Unit.Pixel(60);
WeightBreakCols.FromKey("fl_rate").Width = Unit.Pixel(60);
WeightBreakCols.FromKey("sec_rate").Width = Unit.Pixel(60);
}
protected void FormatColumns(UltraWebGrid uwg)
{
ColumnsCollection routeCols = uwg.Bands[0].Columns;
ColumnsCollection airlineCols = uwg.Bands[1].Columns;
ColumnsCollection weightCols = uwg.Bands[2].Columns;
routeCols.FromKey("agent_no").Hidden = true;
airlineCols.FromKey("agent_no").Hidden = true;
weightCols.FromKey("agent_no").Hidden = true;
routeCols.FromKey("dba_name").Header.Caption = "Agent";
UltraGridColumn AgentCol = uwg.Bands[0].Columns.FromKey("dba_name");
AgentCol.EditorControlID = "TextAgent";
AgentCol.Type = ColumnType.Custom;
AgentCol.DataType = "System.String";
AgentCol.Width = Unit.Pixel(300);
}
protected void FormatColumns(UltraWebGrid uwg)
{
ColumnsCollection routeCols = uwg.Bands[0].Columns;
ColumnsCollection airlineCols = uwg.Bands[1].Columns;
ColumnsCollection weightCols = uwg.Bands[2].Columns;
// hiding uneccessary columns
routeCols.FromKey("customer_no").Hidden = true;
airlineCols.FromKey("customer_no").Hidden = true;
weightCols.FromKey("customer_no").Hidden = true;
// renaming headers
routeCols.FromKey("dba_name").Header.Caption = "Customer";
UltraGridColumn CustomerCol = uwg.Bands[0].Columns.FromKey("dba_name");
CustomerCol.EditorControlID = "TextCustomer";
CustomerCol.Type = ColumnType.Custom;
CustomerCol.DataType = "System.String";
CustomerCol.Width = Unit.Pixel(300);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection disputeTotal = uwg.Bands[0].Columns;
ColumnsCollection disputeItem = uwg.Bands[1].Columns;
disputeTotal.FromKey("elt_account_number").Hidden = true;
disputeTotal.FromKey("org_account_number").Hidden = true;
disputeItem.FromKey("elt_account_number").Hidden = true;
disputeItem.FromKey("vendor_number").Hidden = true;
disputeItem.FromKey("memo").Hidden = true;
disputeTotal.FromKey("dba_name").Header.Caption = "Vendor";
disputeTotal.FromKey("class_code").Header.Caption = "Class";
disputeTotal.FromKey("business_phone").Header.Caption = "Phone";
disputeItem.FromKey("print_id").Header.Caption = "Tran No";
disputeItem.FromKey("bill_number").Header.Caption = "Bill No";
disputeItem.FromKey("bill_date").Header.Caption = "Tran Date";
disputeItem.FromKey("pmt_method").Header.Caption = "Payment";
disputeItem.FromKey("memo").Header.Caption = "Memo";
disputeItem.FromKey("file_no").Header.Caption = "File No";
disputeItem.FromKey("amt_due").Header.Caption = "Due Amount";
disputeItem.FromKey("amt_paid").Header.Caption = "Paid Amount";
disputeItem.FromKey("amt_dispute").Header.Caption = "Disputed Amount";
disputeTotal.FromKey("dba_name").Width = Unit.Pixel(267);
disputeTotal.FromKey("class_code").Width = Unit.Pixel(80);
disputeTotal.FromKey("business_phone").Width = Unit.Pixel(100);
disputeTotal.FromKey("Bill Amount").Width = Unit.Pixel(100);
disputeTotal.FromKey("Paid Amount").Width = Unit.Pixel(100);
disputeTotal.FromKey("Balance").Width = Unit.Pixel(100);
disputeTotal.FromKey("Dispute Amount").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_number").Width = Unit.Pixel(100);
disputeItem.FromKey("print_id").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_date").Width = Unit.Pixel(80);
disputeItem.FromKey("file_no").Width = Unit.Pixel(165);
disputeItem.FromKey("pmt_method").Width = Unit.Pixel(70);
disputeItem.FromKey("amt_due").Width = Unit.Pixel(100);
disputeItem.FromKey("amt_paid").Width = Unit.Pixel(100);
disputeItem.FromKey("amt_dispute").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_date").Format = "MM/dd/yyyy";
}
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)
{
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)
{
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)
{
ColumnsCollection InvoiceCols = e.Layout.Bands[0].Columns;
InvoiceCols.FromKey("invoice_no").Header.Caption = "I/V No.";
InvoiceCols.FromKey("customer_name").Header.Caption = "Customer";
InvoiceCols.FromKey("mawb_num").Header.Caption = "Master BL";
InvoiceCols.FromKey("hawb_num").Header.Caption = "House BL";
InvoiceCols.FromKey("entry_date").Header.Caption = "I/V Date";
InvoiceCols.FromKey("invoice_type").Header.Caption = "T";
InvoiceCols.FromKey("import_export").Header.Caption = "I/E";
InvoiceCols.FromKey("air_ocean").Header.Caption = "A/O";
InvoiceCols.FromKey("ref_no").Header.Caption = "Ref. No.";
InvoiceCols.FromKey("ref_no_our").Header.Caption = "File No.";
InvoiceCols.FromKey("total_pieces").Header.Caption = "PCS";
InvoiceCols.FromKey("total_gross_weight").Header.Caption = "G. Weight";
InvoiceCols.FromKey("total_charge_weight").Header.Caption = "Charge";
InvoiceCols.FromKey("agent_profit").Header.Caption = "Agent P/F";
InvoiceCols.FromKey("sale_tax").Header.Caption = "Tax";
InvoiceCols.FromKey("total_cost").Header.Caption = "Cost";
InvoiceCols.FromKey("subtotal").Header.Caption = "Sub Total";
InvoiceCols.FromKey("lock_ap").Header.Caption = "A/P";
InvoiceCols.FromKey("balance").Header.Caption = "Balance";
InvoiceCols.FromKey("pay_status").Header.Caption = "P";
InvoiceCols.FromKey("arrival_dept").Header.Caption = "Arrival/Departure";
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection MasterCols = uwg.Bands[0].Columns;
ColumnsCollection AgentCols = uwg.Bands[1].Columns;
ColumnsCollection HouseCols = uwg.Bands[2].Columns;
ColumnsCollection ItemCols = uwg.Bands[3].Columns;
MasterCols.FromKey("elt_account_number").Hidden = true;
MasterCols.FromKey("shipper_account_number").Hidden = true;
MasterCols.FromKey("consignee_acct_num").Hidden = true;
AgentCols.FromKey("elt_account_number").Hidden = true;
AgentCols.FromKey("mawb_num").Hidden = true;
AgentCols.FromKey("agent_no").Hidden = true;
HouseCols.FromKey("elt_account_number").Hidden = true;
HouseCols.FromKey("mawb_num").Hidden = true;
HouseCols.FromKey("agent_no").Hidden = true;
AgentCols.FromKey("mawb_num").Hidden = true;
ItemCols.FromKey("elt_account_number").Hidden = true;
ItemCols.FromKey("mawb_num").Hidden = true;
ItemCols.FromKey("hawb_num").Hidden = true;
ItemCols.FromKey("item_code").Hidden = true;
ItemCols.FromKey("tran_no").Hidden = true;
MasterCols.FromKey("chargeable_weight").Format = "#0.00";
AgentCols.FromKey("chargeable_weight").Format = "#0.00";
HouseCols.FromKey("chargeable_weight").Format = "#0.00";
MasterCols.FromKey("mawb_num").Width = Unit.Pixel(120);
MasterCols.FromKey("file#").Width = Unit.Pixel(100);
MasterCols.FromKey("shipper_name").Width = Unit.Pixel(200);
MasterCols.FromKey("consignee_name").Width = Unit.Pixel(200);
MasterCols.FromKey("origin_port_id").Width = Unit.Pixel(50);
MasterCols.FromKey("dest_port_id").Width = Unit.Pixel(50);
MasterCols.FromKey("total_pieces").Width = Unit.Pixel(80);
MasterCols.FromKey("chargeable_weight").Width = Unit.Pixel(80);
AgentCols.FromKey("agent_name").Width = Unit.Pixel(200);
AgentCols.FromKey("chargeable_weight").Width = Unit.Pixel(80);
HouseCols.FromKey("hawb_num").Width = Unit.Pixel(120);
HouseCols.FromKey("agent_name").Width = Unit.Pixel(200);
HouseCols.FromKey("chargeable_weight").Width = Unit.Pixel(80);
ItemCols.FromKey("Charge").Width = Unit.Pixel(180);
ItemCols.FromKey("Cost").Width = Unit.Pixel(180);
ItemCols.FromKey("Charge Amt").Width = Unit.Pixel(80);
ItemCols.FromKey("Cost Amt").Width = Unit.Pixel(80);
MasterCols.FromKey("mawb_num").Header.Caption = "Master AWB";
MasterCols.FromKey("file#").Header.Caption = "File No";
MasterCols.FromKey("shipper_name").Header.Caption = "Shipper";
MasterCols.FromKey("consignee_name").Header.Caption = "Consignee";
MasterCols.FromKey("origin_port_id").Header.Caption = "From";
MasterCols.FromKey("dest_port_id").Header.Caption = "To";
MasterCols.FromKey("chargeable_weight").Header.Caption = "Chg Wt. (Lb)";
AgentCols.FromKey("agent_name").Header.Caption = "Agent";
AgentCols.FromKey("chargeable_weight").Header.Caption = "Chg Wt. (Lb)";
HouseCols.FromKey("hawb_num").Header.Caption = "House AWB";
HouseCols.FromKey("agent_name").Header.Caption = "Agent";
HouseCols.FromKey("chargeable_weight").Header.Caption = "Chg Wt. (Lb)";
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection SBCols = e.Layout.Bands[0].Columns;
SBCols.FromKey("auto_uid").Hidden = true;
SBCols.FromKey("sb").Header.Caption = "Schedule B Code";
SBCols.FromKey("description").Header.Caption = "Item Description";
SBCols.FromKey("sb_unit1").Header.Caption = "Unit 1";
SBCols.FromKey("sb_unit2").Header.Caption = "Unit 2";
SBCols.FromKey("export_code").Header.Caption = "Export Code";
SBCols.FromKey("license_type").Header.Caption = "License Type";
SBCols.FromKey("eccn").Header.Caption = "ECCN";
SBCols.FromKey("sb").Width = Unit.Pixel(100);
SBCols.FromKey("description").Width = Unit.Pixel(250);
SBCols.FromKey("sb_unit1").Width = Unit.Pixel(60);
SBCols.FromKey("sb_unit2").Width = Unit.Pixel(60);
SBCols.FromKey("export_code").Width = Unit.Pixel(70);
SBCols.FromKey("license_type").Width = Unit.Pixel(70);
SBCols.FromKey("eccn").Width = Unit.Pixel(70);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection columns = e.Layout.Bands[0].Columns;
if (lstSearchType.SelectedValue == "house")
{
columns.FromKey("houseNo").Header.Caption = "House B/L";
columns.FromKey("booking_num").Header.Caption = "Booking No.";
columns.FromKey("MasterNo").Header.Caption = "Master B/L";
columns.FromKey("file#").Header.Caption = "File No.";
columns.FromKey("p1").Header.Caption = "Departure Port";
columns.FromKey("p2").Header.Caption = "Destination Port";
columns.FromKey("shipper_name").Header.Caption = "Shipper";
columns.FromKey("consignee_name").Header.Caption = "Consingee";
columns.FromKey("agent").Header.Caption = "Agent";
columns.FromKey("CreatedDate").Header.Caption = "Date";
columns.FromKey("houseNo").Width = Unit.Percentage(10);
columns.FromKey("booking_num").Width = Unit.Percentage(10);
columns.FromKey("MasterNo").Width = Unit.Percentage(10);
columns.FromKey("file#").Width = Unit.Percentage(8);
columns.FromKey("p1").Width = Unit.Percentage(10);
columns.FromKey("p2").Width = Unit.Percentage(10);
columns.FromKey("shipper_name").Width = Unit.Percentage(10);
columns.FromKey("consignee_name").Width = Unit.Percentage(10);
columns.FromKey("agent").Width = Unit.Percentage(10);
columns.FromKey("CreatedDate").Width = Unit.Percentage(7);
columns.FromKey("Type").Width = Unit.Percentage(5);
columns.FromKey("CreatedDate").Format = "MM/dd/yyyy";
columns.FromKey("is_sub").Hidden = true;
columns.FromKey("is_master").Hidden = true;
columns.FromKey("shipper_no").Hidden = true;
columns.FromKey("consignee_no").Hidden = true;
columns.FromKey("agent_no").Hidden = true;
columns.FromKey("lastF#").Hidden = true;
columns.FromKey("measurement").Hidden = true;
}
if (lstSearchType.SelectedValue == "master")
{
columns.FromKey("booking_num").Header.Caption = "Booking No.";
columns.FromKey("MasterNo").Header.Caption = "Master B/L";
columns.FromKey("file#").Header.Caption = "File No.";
columns.FromKey("p1").Header.Caption = "Departure Port";
columns.FromKey("p2").Header.Caption = "Destination Port";
columns.FromKey("shipper_name").Header.Caption = "Shipper";
columns.FromKey("consignee_name").Header.Caption = "Consingee";
columns.FromKey("agent").Header.Caption = "Agent";
columns.FromKey("CreatedDate").Header.Caption = "Date";
columns.FromKey("booking_num").Width = Unit.Percentage(10);
columns.FromKey("MasterNo").Width = Unit.Percentage(10);
columns.FromKey("file#").Width = Unit.Percentage(8);
columns.FromKey("p1").Width = Unit.Percentage(10);
columns.FromKey("p2").Width = Unit.Percentage(10);
columns.FromKey("shipper_name").Width = Unit.Percentage(10);
columns.FromKey("consignee_name").Width = Unit.Percentage(10);
columns.FromKey("agent").Width = Unit.Percentage(10);
columns.FromKey("CreatedDate").Width = Unit.Percentage(7);
columns.FromKey("Status").Width = Unit.Percentage(5);
columns.FromKey("Type").Width = Unit.Percentage(5);
columns.FromKey("CreatedDate").Format = "MM/dd/yyyy";
columns.FromKey("shipper_no").Hidden = true;
columns.FromKey("consignee_no").Hidden = true;
columns.FromKey("lastF#").Hidden = true;
columns.FromKey("measurement").Hidden = true;
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
feData.AddToDataSet("ScheduleB", "SELECT * FROM scheduleB WHERE elt_account_number=" + elt_account_number + " ORDER BY description");
feData.AddToDataSet("ExportCode", "SELECT code_id,LEFT(code_id+'-'+CAST(code_desc AS NVARCHAR),32) AS code_desc FROM aes_codes WHERE code_type='Export Code' ORDER BY code_id");
feData.AddToDataSet("LicenseCode", "SELECT code_id,LEFT(code_id+'-'+CAST(code_desc AS NVARCHAR),32) AS code_desc FROM aes_codes WHERE code_type='License Code' ORDER BY code_id");
feData.AddToDataSet("UOMCode", "SELECT code_id,LEFT(CAST(code_desc AS NVARCHAR),32) AS code_desc FROM aes_codes WHERE code_type='UOM' ORDER BY code_desc");
ColumnsCollection cols = e.Layout.Bands[0].Columns;
cols.FromKey("dfm").Header.Caption = "Origin";
cols.FromKey("b_number").Header.Caption = "Item";
cols.FromKey("b_number_copy").Header.Caption = "Schedule B";
cols.FromKey("b_qty1").Header.Caption = "Qty 1";
cols.FromKey("unit1").Header.Caption = "Unit 1";
cols.FromKey("b_qty2").Header.Caption = "Qty 2";
cols.FromKey("unit2").Header.Caption = "Unit 2";
cols.FromKey("gross_weight").Header.Caption = "Gross Weight<br/>(KG)";
cols.FromKey("vin_type").Header.Caption = "Vehicle ID<br/>Type";
cols.FromKey("vin").Header.Caption = "Vehicle ID";
cols.FromKey("vc_title").Header.Caption = "Vehicle Title";
cols.FromKey("vc_state").Header.Caption = "Vehicle <br/>Title State";
cols.FromKey("item_value").Header.Caption = "Item Value<br/>(USD)";
cols.FromKey("export_code").Header.Caption = "<a href='http://www.aesdirect.gov/support/tables/eic.txt' target='_blank'>Export<br/>Code</a>";
cols.FromKey("license_type").Header.Caption = "<a href='http://www.aesdirect.gov/support/tables/lic.txt' target='_blank'>License<br/>Type</a>";
cols.FromKey("license_number").Header.Caption = "License<br/>Number";
cols.FromKey("eccn").Header.Caption = "ECCN<img src='/ASP/images/button_info.gif' alt='' border='0' id='imgInfoECCN' />";
cols.FromKey("dfm").Type = ColumnType.DropDownList;
cols.FromKey("dfm").ValueList.ValueListItems.Add(new ValueListItem("", ""));
cols.FromKey("dfm").ValueList.ValueListItems.Add(new ValueListItem("Domestic", "D"));
cols.FromKey("dfm").ValueList.ValueListItems.Add(new ValueListItem("Foreign", "F"));
cols.FromKey("dfm").ValueList.ValueListItems.Add(new ValueListItem("FMS", "M"));
cols.FromKey("dfm").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("b_number").Type = ColumnType.DropDownList;
cols.FromKey("b_number").ValueList.DataSource = feData.Tables["ScheduleB"];
cols.FromKey("b_number").ValueList.DisplayMember = feData.Tables["ScheduleB"].Columns["description"].ToString();
cols.FromKey("b_number").ValueList.ValueMember = feData.Tables["ScheduleB"].Columns["sb"].ToString();
cols.FromKey("b_number").ValueList.DataBind();
cols.FromKey("b_number").ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
cols.FromKey("b_number").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("unit1").Type = ColumnType.DropDownList;
cols.FromKey("unit1").ValueList.DataSource = feData.Tables["UOMCode"];
cols.FromKey("unit1").ValueList.DisplayMember = feData.Tables["UOMCode"].Columns["code_desc"].ToString();
cols.FromKey("unit1").ValueList.ValueMember = feData.Tables["UOMCode"].Columns["code_id"].ToString();
cols.FromKey("unit1").ValueList.DataBind();
cols.FromKey("unit1").ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
cols.FromKey("unit1").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("unit2").Type = ColumnType.DropDownList;
cols.FromKey("unit2").ValueList.DataSource = feData.Tables["UOMCode"];
cols.FromKey("unit2").ValueList.DisplayMember = feData.Tables["UOMCode"].Columns["code_desc"].ToString();
cols.FromKey("unit2").ValueList.ValueMember = feData.Tables["UOMCode"].Columns["code_id"].ToString();
cols.FromKey("unit2").ValueList.DataBind();
cols.FromKey("unit2").ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
cols.FromKey("unit2").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("vin_type").Type = ColumnType.DropDownList;
cols.FromKey("vin_type").ValueList.ValueListItems.Add(new ValueListItem("", ""));
cols.FromKey("vin_type").ValueList.ValueListItems.Add(new ValueListItem("VIN", "V"));
cols.FromKey("vin_type").ValueList.ValueListItems.Add(new ValueListItem("Product ID", "P"));
cols.FromKey("vin_type").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("export_code").Type = ColumnType.DropDownList;
cols.FromKey("export_code").ValueList.DataSource = feData.Tables["ExportCode"];
cols.FromKey("export_code").ValueList.DisplayMember = feData.Tables["ExportCode"].Columns["code_id"].ToString();
cols.FromKey("export_code").ValueList.ValueMember = feData.Tables["ExportCode"].Columns["code_id"].ToString();
cols.FromKey("export_code").ValueList.DataBind();
cols.FromKey("export_code").ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
cols.FromKey("export_code").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("license_type").Type = ColumnType.DropDownList;
cols.FromKey("license_type").ValueList.DataSource = feData.Tables["LicenseCode"];
cols.FromKey("license_type").ValueList.DisplayMember = feData.Tables["LicenseCode"].Columns["code_id"].ToString();
cols.FromKey("license_type").ValueList.ValueMember = feData.Tables["LicenseCode"].Columns["code_id"].ToString();
cols.FromKey("license_type").ValueList.DataBind();
cols.FromKey("license_type").ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
cols.FromKey("license_type").ValueList.Style.CssClass = "bodycopy";
cols.FromKey("dfm").Width = Unit.Pixel(60);
cols.FromKey("b_number").Width = Unit.Pixel(200);
cols.FromKey("unit1").Width = Unit.Pixel(150);
cols.FromKey("unit2").Width = Unit.Pixel(150);
cols.FromKey("vin_type").Width = Unit.Pixel(60);
cols.FromKey("export_code").Width = Unit.Pixel(45);
cols.FromKey("license_type").Width = Unit.Pixel(45);
cols.FromKey("eccn").Width = Unit.Pixel(70);
cols.FromKey("b_qty1").Width = Unit.Pixel(40);
cols.FromKey("b_qty2").Width = Unit.Pixel(40);
cols.FromKey("license_number").Width = Unit.Pixel(80);
cols.FromKey("gross_weight").Width = Unit.Pixel(80);
cols.FromKey("item_value").Width = Unit.Pixel(80);
cols.FromKey("b_number_copy").Width = Unit.Pixel(80);
cols.FromKey("vin_type").Width = Unit.Pixel(65);
cols.FromKey("vin").Width = Unit.Pixel(80);
cols.FromKey("vc_title").Width = Unit.Pixel(70);
cols.FromKey("vc_state").Width = Unit.Pixel(60);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection columns = e.Layout.Bands[0].Columns;
if (lstSearchType.SelectedValue == "house")
{
columns.FromKey("hawb_num").Header.Caption = "House AWB";
columns.FromKey("masterNo").Header.Caption = "Master AWB";
columns.FromKey("file#").Header.Caption = "File No.";
columns.FromKey("sec").Header.Caption = "SEC";
columns.FromKey("p1").Header.Caption = "Departure Port";
columns.FromKey("p2").Header.Caption = "Destination Port";
columns.FromKey("Shipper_name").Header.Caption = "Shipper";
columns.FromKey("consignee_name").Header.Caption = "Consingee";
columns.FromKey("CreatedDate").Header.Caption = "Date";
columns.FromKey("hawb_num").Width = Unit.Percentage(10);
columns.FromKey("masterNo").Width = Unit.Percentage(10);
columns.FromKey("file#").Width = Unit.Percentage(10);
columns.FromKey("sec").Width = Unit.Percentage(4);
columns.FromKey("p1").Width = Unit.Percentage(10);
columns.FromKey("p2").Width = Unit.Percentage(10);
columns.FromKey("Shipper_name").Width = Unit.Percentage(15);
columns.FromKey("consignee_name").Width = Unit.Percentage(15);
columns.FromKey("CreatedDate").Width = Unit.Percentage(7);
columns.FromKey("CreatedDate").Format = "MM/dd/yyyy";
columns.FromKey("Shipper_acct").Hidden = true;
columns.FromKey("consignee_acct").Hidden = true;
columns.FromKey("agent_org_acct").Hidden = true;
columns.FromKey("iType").Hidden = true;
columns.FromKey("lastF#").Hidden = true;
}
if (lstSearchType.SelectedValue == "master")
{
columns.FromKey("masterNo").Header.Caption = "Master AWB";
columns.FromKey("file#").Header.Caption = "File No.";
columns.FromKey("sec").Header.Caption = "SEC";
columns.FromKey("p1").Header.Caption = "Departure Port";
columns.FromKey("p2").Header.Caption = "Destination Port";
columns.FromKey("carrier").Header.Caption = "Carrier";
columns.FromKey("export_agent_name").Header.Caption = "Export Agent";
columns.FromKey("CreatedDate").Header.Caption = "Date";
columns.FromKey("masterNo").Width = Unit.Percentage(10);
columns.FromKey("file#").Width = Unit.Percentage(10);
columns.FromKey("sec").Width = Unit.Percentage(4);
columns.FromKey("p1").Width = Unit.Percentage(10);
columns.FromKey("p2").Width = Unit.Percentage(10);
columns.FromKey("carrier").Width = Unit.Percentage(15);
columns.FromKey("export_agent_name").Width = Unit.Percentage(15);
columns.FromKey("CreatedDate").Width = Unit.Percentage(7);
columns.FromKey("CreatedDate").Format = "MM/dd/yyyy";
columns.FromKey("agent_org_acct").Hidden = true;
columns.FromKey("carrier_code").Hidden = true;
columns.FromKey("agent_org_acct").Hidden = true;
columns.FromKey("iType").Hidden = true;
}
}
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)
{
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);
}