protected void BindGridData()
{
FreightEasy.Accounting.APDispute myDs = new FreightEasy.Accounting.APDispute();
myDs.GetAllRecords(elt_account_number, Session["VENDOR"].ToString(),
Session["SDATE"].ToString(), Session["EDATE"].ToString());
DataSet ds = myDs;
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
UltraWebGrid1.ExpandAll();
}
protected void BindGridData()
{
FreightEasy.PNL.AirExportPNL myDs = new FreightEasy.PNL.AirExportPNL();
myDs.GetAllRecords(elt_account_number, Session["MAWB"].ToString(),
"", "");
DataSet ds = myDs;
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
UltraWebGrid1.ExpandAll();
}
protected void BindGridData()
{
FreightEasy.AirExport.ChargeItems myDs = new FreightEasy.AirExport.ChargeItems();
myDs.GetAllRecords(elt_account_number, Session["MAWB"].ToString());
DataSet ds = myDs;
UltraWebGrid1.DataSource = ds;
UltraWebGrid1.DataBind();
if (Request.Params["SearchType"] == "master" || Request.Params["SearchType"] == "file")
{
UltraWebGrid1.ExpandAll(true);
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
Session.LCID = 1033;
elt_account_number = Request.Cookies["CurrentUserInfo"]["elt_account_number"];
user_id = Request.Cookies["CurrentUserInfo"]["user_id"];
user_right = Request.Cookies["CurrentUserInfo"]["user_right"];
login_name = Request.Cookies["CurrentUserInfo"]["login_name"];
if (Session["Accounting_sPeriod"] == null)
{
Response.Redirect("./GLSelection.aspx?parm=bal");
}
if (login_name == "imoon")
{
this.TextBox1.Width = new Unit("100px");
this.TextBox2.Width = new Unit("100px");
}
if (!IsPostBack)
{
ViewState["Count"] = 1;
if (Request.UrlReferrer == null)
{
Response.Redirect(ParentPage);
}
else
{
ViewState["Parent"] = Request.UrlReferrer.ToString();
}
PerformSearch();
PerformDataBind();
}
else
{
ViewState["Count"] = (int)ViewState["Count"] + 1;
}
UltraWebGrid1.ExpandAll(true);
UltraWebGrid2.ExpandAll(true);
UltraWebGrid3.ExpandAll(true);
}
protected void GetRateList()
{
FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
string rateSQL, rateDetailSQL;
if (lstRateType.SelectedValue == "1")
{
rateSQL = @"SELECT distinct b.dba_name,b.carrier_code,a.airline,a.share FROM all_rate_table a
LEFT OUTER JOIN (select distinct dba_name,carrier_code,elt_account_number from organization) b
on (a.elt_account_number=b.elt_account_number
and a.airline=b.carrier_code) WHERE a.elt_account_number="
+ elt_account_number + " AND a.rate_type=" + lstRateType.SelectedValue
+ " AND a.origin_port=N'" + txtFrom.Text + "' AND a.dest_port=N'" + txtTo.Text
+ "' AND a.agent_no=" + lstCustomer.SelectedValue + " AND (b.carrier_code=" + txtCarrierCode.Text + " OR a.airline=-1)";
rateDetailSQL = @"SELECT airline,weight_break=case item_no when 0 then 'Min($)' when 1 then '+Min'
else cast(weight_break as NVARCHAR) end,kg_lb,rate,fl_rate,sec_rate FROM all_rate_table WHERE elt_account_number="
+ elt_account_number + " AND rate_type=" + lstRateType.SelectedValue
+ " AND origin_port=N'" + txtFrom.Text + "' AND dest_port=N'" + txtTo.Text
+ "' AND agent_no=" + lstCustomer.SelectedValue + " ORDER BY item_no";
}
else if (lstRateType.SelectedValue == "5" || lstRateType.SelectedValue == "3")
{
rateSQL = @"SELECT distinct b.dba_name,b.carrier_code,a.airline,a.share FROM all_rate_table a
LEFT OUTER JOIN (select distinct dba_name,carrier_code,elt_account_number from organization) b
on (a.elt_account_number=b.elt_account_number
and a.airline=b.carrier_code) WHERE a.elt_account_number="
+ elt_account_number + " AND a.rate_type=" + lstRateType.SelectedValue
+ " AND a.origin_port=N'" + txtFrom.Text + "' AND a.dest_port=N'" + txtTo.Text
+ "' AND (b.carrier_code=" + txtCarrierCode.Text + " OR a.airline=-1)";
rateDetailSQL = @"SELECT airline,weight_break=case item_no when 0 then 'Min($)' when 1 then '+Min'
else cast(weight_break as NVARCHAR) end,kg_lb,rate,fl_rate,sec_rate FROM all_rate_table WHERE elt_account_number="
+ elt_account_number + " AND rate_type=" + lstRateType.SelectedValue
+ " AND origin_port=N'" + txtFrom.Text + "' AND dest_port=N'" + txtTo.Text
+ "' ORDER BY item_no";
}
else if (lstRateType.SelectedValue == "4")
{
rateSQL = @"SELECT distinct b.dba_name,b.carrier_code,a.airline,a.share FROM all_rate_table a
LEFT OUTER JOIN (select distinct dba_name,carrier_code,elt_account_number from organization) b
on (a.elt_account_number=b.elt_account_number
and a.airline=b.carrier_code) WHERE a.elt_account_number="
+ elt_account_number + " AND a.rate_type=" + lstRateType.SelectedValue
+ " AND a.origin_port=N'" + txtFrom.Text + "' AND a.dest_port=N'" + txtTo.Text
+ "' AND a.customer_no=" + lstCustomer.SelectedValue + " AND (b.carrier_code=" + txtCarrierCode.Text + " OR a.airline=-1)";
rateDetailSQL = @"SELECT airline,weight_break=case item_no when 0 then 'Min($)' when 1 then '+Min'
else cast(weight_break as NVARCHAR) end,kg_lb,rate,fl_rate,sec_rate FROM all_rate_table WHERE elt_account_number="
+ elt_account_number + " AND rate_type=" + lstRateType.SelectedValue
+ " AND origin_port=N'" + txtFrom.Text + "' AND dest_port=N'" + txtTo.Text
+ "' AND customer_no=" + lstCustomer.SelectedValue + " ORDER BY item_no";
}
else
{
return;
}
feData.AddToDataSet("Rate", rateSQL);
feData.AddToDataSet("RateDetail", rateDetailSQL);
feData.AddRelation("RateRelation", "Rate", "airline", "RateDetail", "airline");
UltraWebGrid1.DataSource = feData;
UltraWebGrid1.DataBind();
UltraWebGrid1.ExpandAll(true);
}