예제 #1
0
    protected void Page_Init(object sender, EventArgs e)
    {
        // Naviagtor assigned
        //WebNavBar1.GridID = UltraWebGrid1.UniqueID;

        // FreightEasyData Initialized
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("Ports", "SELECT port_code + ' - ' + port_desc as port_name,port_code FROM port WHERE elt_account_number=" + elt_account_number + " AND ISNULL(port_id,'')<>'' ORDER BY port_desc");
        feData.AddToDataSet("Countries", "SELECT * FROM country_code WHERE elt_account_number=" + elt_account_number + " order by country_name");
        feData.AddToDataSet("MOT", "SELECT code_id,code_desc FROM aes_codes WHERE code_type='Transport Code' ORDER BY code_id");
        feData.AddToDataSet("Carriers", "SELECT ISNULL(carrier_id,'') AS carrier_code,LEFT(dba_name,22) AS carrier_name FROM organization WHERE is_carrier='Y' AND ISNULL(carrier_id,'') <> '' AND ISNULL(carrier_code,'')<>'' AND elt_account_number=" + elt_account_number + " ORDER BY dba_name");

        // Form initialize
        POE.DataSource     = feData.Tables["Ports"];
        POE.DataTextField  = "port_name";
        POE.DataValueField = "port_code";
        POE.DataBind();
        POE.Items.Insert(0, new ListItem("", ""));

        POU.DataSource     = feData.Tables["Ports"];
        POU.DataTextField  = "port_name";
        POU.DataValueField = "port_code";
        POU.DataBind();
        POU.Items.Insert(0, new ListItem("", ""));

        COD.DataSource     = feData.Tables["Countries"];
        COD.DataTextField  = "country_name";
        COD.DataValueField = "country_code";
        COD.DataBind();
        COD.Items.Insert(0, new ListItem("", ""));

        MOT.DataSource     = feData.Tables["MOT"];
        MOT.DataTextField  = "code_desc";
        MOT.DataValueField = "code_id";
        MOT.DataBind();
        MOT.Items.Insert(0, new ListItem("", ""));

        lstCarrier.DataSource     = feData.Tables["Carriers"];
        lstCarrier.DataTextField  = "carrier_name";
        lstCarrier.DataValueField = "carrier_code";
        lstCarrier.DataBind();
        lstCarrier.Items.Insert(0, new ListItem("", ""));

        hFileType.Value = move_type;

        // New AES
        if (aes_id == "" || aes_id == "0")
        {
            labelPageTitle.Text = "New AES Form";
            trInfo1.Visible     = false;
            trInfo2.Visible     = false;
        }
        // Saved AES
        else
        {
            labelPageTitle.Text = "Edit AES Form";
        }
    }
예제 #2
0
 private FreightEasy.DataManager.FreightEasyData SetDataList()
 {
     FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
     feData.AddToDataSet("Ports", "SELECT port_code + ' - ' + port_desc as port_name,port_code FROM port WHERE elt_account_number=" + elt_account_number + " AND ISNULL(port_id,'')<>'' ORDER BY port_desc");
     feData.AddToDataSet("Countries", "SELECT * FROM country_code WHERE elt_account_number=" + elt_account_number + " order by country_name");
     feData.AddToDataSet("MOT", "SELECT code_id,code_desc FROM aes_codes WHERE code_type='Transport Code' ORDER BY code_id");
     feData.AddToDataSet("Carriers", "SELECT ISNULL(carrier_id,'') AS carrier_code,LEFT(dba_name,22) AS carrier_name FROM organization WHERE is_carrier='Y' AND ISNULL(carrier_id,'') <> '' AND ISNULL(carrier_code,'')<>'' AND elt_account_number=" + elt_account_number + " ORDER BY dba_name");
     feData.AddToDataSet("ScheduleB", "SELECT * FROM scheduleB WHERE elt_account_number=" + elt_account_number + " ORDER BY description");
     // Session["AES_DATA"] = feData;
     return(feData);
 }
예제 #3
0
 protected void LoadPorts()
 {
     FEData.AddToDataSet("Ports", "SELECT port_code + ' - ' + port_desc as port_name,port_code FROM port WHERE elt_account_number=" + elt_account_number + " ORDER BY port_desc");
     OriginPortSelect.DataSource     = FEData.Tables["Ports"].DefaultView;
     OriginPortSelect.DataTextField  = "port_name";
     OriginPortSelect.DataValueField = "port_code";
     OriginPortSelect.DataBind();
     OriginPortSelect.Items.Insert(0, new ListItem("", ""));
     DestPortSelect.DataSource     = FEData.Tables["Ports"].DefaultView;
     DestPortSelect.DataTextField  = "port_name";
     DestPortSelect.DataValueField = "port_code";
     DestPortSelect.DataBind();
     DestPortSelect.Items.Insert(0, new ListItem("", ""));
 }
예제 #4
0
    protected void Page_Init(object sender, EventArgs e)
    {
        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"];
        string sb_id = Request.Params["SBID"];

        hOrgID.Value = Request.Params["OrgID"];

        if (sb_id == null || sb_id == "")
        {
            labelTitle.Text = "ADD NEW SCHEDULE B ITEM";
        }
        else
        {
            labelTitle.Text = "EDIT SCHEDULE B ITEM";
            hSBID.Value     = sb_id;
        }

        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        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("LicenseType", "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");

        lstSBUnit1.DataSource     = feData.Tables["UOMCode"];
        lstSBUnit1.DataTextField  = "code_desc";
        lstSBUnit1.DataValueField = "code_id";
        lstSBUnit1.DataBind();
        lstSBUnit1.Items.Insert(0, new ListItem("", ""));

        lstSBUnit2.DataSource     = feData.Tables["UOMCode"];
        lstSBUnit2.DataTextField  = "code_desc";
        lstSBUnit2.DataValueField = "code_id";
        lstSBUnit2.DataBind();
        lstSBUnit2.Items.Insert(0, new ListItem("", ""));

        lstExportCode.DataSource     = feData.Tables["ExportCode"];
        lstExportCode.DataTextField  = "code_desc";
        lstExportCode.DataValueField = "code_id";
        lstExportCode.DataBind();
        lstExportCode.Items.Insert(0, new ListItem("", ""));

        lstLicenseType.DataSource     = feData.Tables["LicenseType"];
        lstLicenseType.DataTextField  = "code_desc";
        lstLicenseType.DataValueField = "code_id";
        lstLicenseType.DataBind();
        lstLicenseType.Items.Insert(0, new ListItem("", ""));
    }
예제 #5
0
    protected void AddNewAES()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        ArrayList tranStrAL = new ArrayList();
        string    tranStr   = "";

        tranStr = "SET ANSI_WARNINGS OFF";
        tranStrAL.Add(tranStr);

        tranStr = @"INSERT INTO aes_master(elt_account_number,party_to_transaction,export_date,tran_ref_no,consignee_acct,inter_consignee_acct,origin_state,dest_country,tran_method,export_port,unloading_port,carrier_id_code,export_carrier,shipment_ref_no,entry_no,hazardous_materials,route_export_tran,in_bond_type,in_bond_no,ftz,last_modified,shipper_acct,file_type,house_num,master_num)
            VALUES(" + elt_account_number + ",N'" + RCC.SelectedValue + "',N'" + EDA.Text + "',N'" + BN.Text + "'," + MakeNullCase(hConsigneeAcct.Value) + "," + MakeNullCase(hInterConsigneeAcct.Value) + ",N'" + ST.SelectedValue + "',N'" + COD.SelectedValue + "',N'" + MOT.SelectedValue + "',N'" + POE.SelectedValue + "',N'" + POU.SelectedValue
                  + "',N'" + lstCarrier.SelectedValue + "',N'" + lstCarrier.Items[lstCarrier.SelectedIndex].Text + "',N'" + SRN.Text + "','',N'" + HAZ.SelectedValue + "',N'" + RT.SelectedValue + "',N'" + IBT.SelectedValue + "',N'" + IBN.Text + "',N'" + FTZ.Text + "',GETDATE()," + MakeNullCase(hShipperAcct.Value) + ",N'" + hFileType.Value + "',N'" + txtHouse.Text + "',N'" + txtMaster.Text + "')";
        tranStrAL.Add(tranStr);

        // AES item insert loop using grid entries
        for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
        {
            if (UltraWebGrid1.Rows[i].Cells[3].Value == null)
            {
                UltraWebGrid1.Rows[i].Cells[3].Value = "0";
            }
            if (UltraWebGrid1.Rows[i].Cells[5].Value == null)
            {
                UltraWebGrid1.Rows[i].Cells[5].Value = "0";
            }
            if (UltraWebGrid1.Rows[i].Cells[7].Value == null)
            {
                UltraWebGrid1.Rows[i].Cells[7].Value = "0";
            }
            if (UltraWebGrid1.Rows[i].Cells[8].Value == null)
            {
                UltraWebGrid1.Rows[i].Cells[8].Value = "0";
            }

            tranStr = @"INSERT INTO aes_detail(elt_account_number,item_no,dfm,b_number,item_desc,b_qty1,unit1,b_qty2,unit2,gross_weight,item_value,export_code,license_type,license_number,eccn,vin_type,vin,vc_title,vc_state,aes_id)
                VALUES(" + elt_account_number + "," + i + ",N'" + UltraWebGrid1.Rows[i].Cells[0].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[1].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[1].Text
                      + "'," + UltraWebGrid1.Rows[i].Cells[3].Value + ",N'" + UltraWebGrid1.Rows[i].Cells[4].Value + "'," + UltraWebGrid1.Rows[i].Cells[5].Value + ",N'" + UltraWebGrid1.Rows[i].Cells[6].Value
                      + "'," + UltraWebGrid1.Rows[i].Cells[7].Value + "," + UltraWebGrid1.Rows[i].Cells[8].Value + ",N'" + UltraWebGrid1.Rows[i].Cells[9].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[10].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[11].Value
                      + "',N'" + UltraWebGrid1.Rows[i].Cells[12].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[13].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[14].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[15].Value + "',N'" + UltraWebGrid1.Rows[i].Cells[16].Value + "',IDENT_CURRENT('aes_master'))";
            tranStrAL.Add(tranStr);

            tranStr = "SET ANSI_WARNINGS ON";
            tranStrAL.Add(tranStr);
        }

        if (!feData.DataTransactions((string[])tranStrAL.ToArray(typeof(string))))
        {
            txtResultBox.Text    = feData.GetLastTransactionError();
            txtResultBox.Visible = true;
        }
        else
        {
            feData.AddToDataSet("AESInfo", "SELECT * FROM aes_master WHERE elt_account_number=" + elt_account_number + " AND shipment_ref_no=N'" + SRN.Text + "'AND file_type='AE'");

            if (feData.Tables["AESInfo"].Rows.Count > 0)
            {
                Response.Redirect("EditAES.aspx?AESID=" + feData.Tables["AESInfo"].Rows[0]["auto_uid"].ToString());
            }
        }
    }
예제 #6
0
    protected void LoadAllData(string OrgID)
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("OrgInfo", "SELECT * FROM organization WHERE elt_account_number=" + elt_account_number + " AND org_account_number=" + OrgID);

        if (feData.Tables["OrgInfo"].Rows.Count > 0)
        {
            DataRow drOrg = feData.Tables["OrgInfo"].Rows[0];
            txtDBA.Text              = drOrg["dba_name"].ToString();
            txtLegalName.Text        = drOrg["business_legal_name"].ToString();
            txtAddress1.Text         = drOrg["business_address"].ToString();
            txtAddress2.Text         = drOrg["business_address2"].ToString();
            txtCity.Text             = drOrg["business_city"].ToString();
            txtState.Text            = drOrg["business_state"].ToString();
            txtZip.Text              = drOrg["business_zip"].ToString();
            lstCountry.SelectedValue = drOrg["b_country_code"].ToString();
            txtFirstName.Text        = drOrg["owner_fname"].ToString();
            txtMidName.Text          = drOrg["owner_mname"].ToString();
            txtLastName.Text         = drOrg["owner_lname"].ToString();
            txtPhone.Text            = FormatStringNumberOnly(drOrg["business_phone"].ToString());
            txtFax.Text              = FormatStringNumberOnly(drOrg["business_fax"].ToString());
            txtCell.Text             = FormatStringNumberOnly(drOrg["owner_phone"].ToString());
            txtEmail.Text            = drOrg["owner_email"].ToString();
            txtTaxID.Text            = drOrg["business_fed_taxid"].ToString();
        }
    }
예제 #7
0
    protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        string sqlTxt = "";

        if (hOrgID.Value == "" || hOrgID.Value == "0")
        {
            sqlTxt = "SELECT * FROM ig_schedule_b WHERE elt_account_number=" + elt_account_number + " AND sb_id=" + ListBox1.SelectedValue;
        }
        else
        {
            sqlTxt = "SELECT * FROM scheduleB WHERE elt_account_number=" + elt_account_number + " AND auto_uid=" + ListBox1.SelectedValue;
        }

        feData.AddToDataSet("scheduleBInfo", sqlTxt);

        if (feData.Tables["scheduleBInfo"].Rows.Count > 0)
        {
            DataRow dtTmp = feData.Tables["scheduleBInfo"].Rows[0];
            hSBCode.Value      = dtTmp["sb"].ToString();
            hUnit1.Value       = dtTmp["sb_unit1"].ToString();
            hUnit2.Value       = dtTmp["sb_unit2"].ToString();
            hDesc.Value        = dtTmp["description"].ToString();
            hExportCode.Value  = dtTmp["export_code"].ToString();
            hLicenseType.Value = dtTmp["license_type"].ToString();
            hECCN.Value        = dtTmp["eccn"].ToString();
        }
    }
예제 #8
0
    protected void Page_Init(object sender, EventArgs e)
    {
        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"];
        org_id             = Request.Params["orgID"].ToString();

        if (org_id == "" || org_id == "0")
        {
            labelTitle.Text = "ADD NEW COMPANY";
            org_id          = "";
        }
        else
        {
            labelTitle.Text = "EDIT COMPANY";
        }

        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("Countries", "SELECT * FROM country_code WHERE elt_account_number=" + elt_account_number + " ORDER BY country_name");

        lstCountry.DataSource     = feData.Tables["Countries"];
        lstCountry.DataTextField  = "country_name";
        lstCountry.DataValueField = "country_code";
        lstCountry.DataBind();
        lstCountry.Items.Insert(0, new ListItem("", ""));
    }
예제 #9
0
    protected void Load_Booking_Confirm(string bc_uid)
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("BookingConfirm", "select * from booking_confirm where elt_account_number="
                            + elt_account_number + " and auto_uid=" + bc_uid + "");
        DataTable dt = feData.Tables["BookingConfirm"];

        this.hSearchNum.Value          = dt.Rows[0]["auto_uid"].ToString();
        this.spn_prefix_select.Visible = false;
        this.td_bill_select.Visible    = false;
        if (dt.Rows[0]["document_date"] != DBNull.Value)
        {
            this.txt_document_date.Text = Convert.ToDateTime(dt.Rows[0]["document_date"]).ToShortDateString();
        }
        this.txt_booking_no.Text           = dt.Rows[0]["booking_no"].ToString();
        this.lstSearchNum.Text             = dt.Rows[0]["bc_no"].ToString();
        this.hf_booking_no.Value           = dt.Rows[0]["booking_no"].ToString();
        this.hf_master_no.Value            = dt.Rows[0]["master_no"].ToString();
        this.hf_house_no.Value             = dt.Rows[0]["house_no"].ToString();
        this.hf_sub_house_no.Value         = dt.Rows[0]["sub_house_no"].ToString();
        this.hShipperAcct.Value            = dt.Rows[0]["shipper_acct"].ToString();
        this.lstShipperName.Text           = dt.Rows[0]["shipper_name"].ToString();
        this.txtShipperInfo.Text           = dt.Rows[0]["shipper_info"].ToString();
        this.hConsigneeAcct.Value          = dt.Rows[0]["deliver_to_acct"].ToString();
        this.lstConsigneeName.Text         = dt.Rows[0]["deliver_to_name"].ToString();
        this.txtConsigneeInfo.Text         = dt.Rows[0]["deliver_to_info"].ToString();
        this.txt_cut_off_date.Text         = dt.Rows[0]["cut_off_date"].ToString();
        this.txt_export_reference.Text     = dt.Rows[0]["export_reference"].ToString();
        this.hCarrierAcct.Value            = dt.Rows[0]["carrier_acct"].ToString();
        this.lstCarrierName.Text           = dt.Rows[0]["carrier_name"].ToString();
        this.txt_carrier_no.Text           = dt.Rows[0]["carrier_no"].ToString();
        this.txt_place_of_receipt.Text     = dt.Rows[0]["place_of_receipt"].ToString();
        this.txt_place_of_delivery.Text    = dt.Rows[0]["place_of_delivery"].ToString();
        this.ddl_origin_port.SelectedValue = dt.Rows[0]["dep_port"].ToString();
        this.ddl_dest_port.SelectedValue   = dt.Rows[0]["arr_port"].ToString();
        if (dt.Rows[0]["eta"] != DBNull.Value)
        {
            this.txt_eta_date.Text = Convert.ToDateTime(dt.Rows[0]["eta"]).ToShortDateString();
        }
        if (dt.Rows[0]["etd"] != DBNull.Value)
        {
            this.txt_etd_date.Text = Convert.ToDateTime(dt.Rows[0]["etd"]).ToShortDateString();
        }
        this.txt_type_of_move.Text            = dt.Rows[0]["move_type"].ToString();
        this.hAgentAcct.Value                 = dt.Rows[0]["dest_agent_acct"].ToString();
        this.lstAgentName.Text                = dt.Rows[0]["dest_agent_name"].ToString();
        this.txtAgentInfo.Text                = dt.Rows[0]["dest_agent_info"].ToString();
        this.hEmptyPickupAcct.Value           = dt.Rows[0]["empty_container_pick_up_acct"].ToString();
        this.lstEmptyPickupName.Text          = dt.Rows[0]["empty_container_pick_up_name"].ToString();
        this.txtEmptyPickupInfo.Text          = dt.Rows[0]["empty_container_pick_up_info"].ToString();
        this.rbl_dangerous_good.SelectedValue = dt.Rows[0]["dangerous"].ToString();
        this.txt_quantity.Text                = dt.Rows[0]["quantity"].ToString();
        this.ddl_quantity_unit.SelectedValue  = dt.Rows[0]["quantity_unit"].ToString();
        this.txt_description.Text             = dt.Rows[0]["item_desc"].ToString();
        this.txt_weight.Text = dt.Rows[0]["gross_weight"].ToString();
        this.ddl_weight_scale.SelectedValue    = dt.Rows[0]["weight_scale"].ToString();
        this.txt_dimension.Text                = dt.Rows[0]["dimension"].ToString();
        this.ddl_dimension_scale.SelectedValue = dt.Rows[0]["dimension_scale"].ToString();
        this.txt_remark.Text = dt.Rows[0]["remark"].ToString();
    }
예제 #10
0
    protected void LoadScheduleBList()
    {
        string sqlTxt = "";

        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();

        if (hOrgID.Value == "" || hOrgID.Value == "0")
        {
            sqlTxt = "SELECT auto_uid AS sb_id,[description] FROM scheduleB WHERE elt_account_number="
                     + elt_account_number + " ORDER BY [description]";
        }
        else
        {
            sqlTxt = "IF EXISTS (SELECT * FROM ig_schedule_b WHERE elt_account_number="
                     + elt_account_number + " AND org_account_number=" + hOrgID.Value + ")\n"
                     + "SELECT sb_id,[description],org_account_number FROM ig_schedule_b WHERE elt_account_number="
                     + elt_account_number + " AND org_account_number=" + hOrgID.Value + " ORDER BY [description]\n"
                     + "ELSE\n"
                     + "SELECT auto_uid AS sb_id,[description] FROM scheduleB WHERE elt_account_number=" + elt_account_number + " ORDER BY [description]";
        }

        feData.AddToDataSet("ScheduleB", sqlTxt);
        ListBox1.DataSource     = feData.Tables["ScheduleB"];
        ListBox1.DataTextField  = "description";
        ListBox1.DataValueField = "sb_id";
        ListBox1.DataBind();
    }
예제 #11
0
    protected void AddNewAES()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        ArrayList tranStrAL = new ArrayList();
        string    tranStr   = "";

        tranStr = "SET ANSI_WARNINGS OFF";
        tranStrAL.Add(tranStr);

        tranStr = @"INSERT INTO aes_master(elt_account_number,party_to_transaction,export_date,tran_ref_no,consignee_acct,inter_consignee_acct,origin_state,dest_country,tran_method,export_port,unloading_port,carrier_id_code,export_carrier,shipment_ref_no,entry_no,hazardous_materials,route_export_tran,in_bond_type,in_bond_no,ftz,last_modified,shipper_acct,file_type,house_num,master_num)
            VALUES(" + elt_account_number + ",N'" + RCC.SelectedValue + "',N'" + EDA.Text + "',N'" + BN.Text + "'," + MakeNullCase(hConsigneeAcct.Value) + "," + MakeNullCase(hInterConsigneeAcct.Value) + ",N'" + ST.SelectedValue + "',N'" + COD.SelectedValue + "',N'" + MOT.SelectedValue + "',N'" + POE.SelectedValue + "',N'" + POU.SelectedValue
                  + "',N'" + lstCarrier.SelectedValue + "',N'" + lstCarrier.Items[lstCarrier.SelectedIndex].Text + "',N'" + SRN.Text + "','',N'" + HAZ.SelectedValue + "',N'" + RT.SelectedValue + "',N'" + IBT.SelectedValue + "',N'" + IBN.Text + "',N'" + FTZ.Text + "',GETDATE()," + MakeNullCase(hShipperAcct.Value) + ",N'" + hFileType.Value + "',N'" + txtHouse.Text + "',N'" + txtMaster.Text + "')";
        tranStrAL.Add(tranStr);



        if (!feData.DataTransactions((string[])tranStrAL.ToArray(typeof(string))))
        {
            txtResultBox.Text    = feData.GetLastTransactionError();
            txtResultBox.Visible = true;
        }
        else
        {
            feData.AddToDataSet("AESInfo", "SELECT * FROM aes_master WHERE elt_account_number=" + elt_account_number + " AND shipment_ref_no=N'" + SRN.Text + "' AND file_type='OE'");

            if (feData.Tables["AESInfo"].Rows.Count > 0)
            {
                SaveLineItems(Convert.ToInt32(feData.Tables["AESInfo"].Rows[0]["auto_uid"]));
                Response.Redirect("EditOceanAES.aspx?AESID=" + feData.Tables["AESInfo"].Rows[0]["auto_uid"].ToString());
            }
        }
    }
예제 #12
0
 protected void SetFreightEasyData(GridView control, string txtSQL)
 {
     // gvHouseResult.Clear();
     FEData = new FreightEasy.DataManager.FreightEasyData();
     FEData.AddToDataSet("SearchList", txtSQL);
     control.DataSource = FEData.Tables["SearchList"].DefaultView;
     control.DataBind();
     txtResultBox.Text      = FEData.Tables["SearchList"].Rows.Count.ToString() + " Records Found.";
     btnExcelExport.Visible = true;
 }
예제 #13
0
    protected void ListBox1_Load_Data()
    {
        FreightEasy.DataManager.FreightEasyData FEData = new FreightEasy.DataManager.FreightEasyData();
        FEData.AddToDataSet("SetupSteps", "select * from setup_master order by seq_id");
        DataTable tmpDt = FEData.Tables["SetupSteps"];

        ListBox1.DataSource     = tmpDt;
        ListBox1.DataTextField  = tmpDt.Columns["title"].ToString();
        ListBox1.DataValueField = tmpDt.Columns["page_id"].ToString();
        ListBox1.DataBind();
    }
예제 #14
0
    protected void Page_Init(object sender, EventArgs e)
    {
        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"];

        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("Banks", "SELECT * FROM gl WHERE elt_account_number=" + elt_account_number + " AND gl_account_type='Cash in Bank'");
        lstBanks.DataSource     = feData.Tables["Banks"];
        lstBanks.DataTextField  = "gl_account_desc";
        lstBanks.DataValueField = "gl_account_number";
        lstBanks.DataBind();

        feData.AddToDataSet("Revenues", "SELECT * FROM gl WHERE elt_account_number=" + elt_account_number + " AND gl_account_type='Other Revenue'");
        lstRevenues.DataSource     = feData.Tables["Revenues"];
        lstRevenues.DataTextField  = "gl_account_desc";
        lstRevenues.DataValueField = "gl_account_number";
        lstRevenues.DataBind();
    }
예제 #15
0
 protected void SetFreightEasyData(string txtSQL)
 {
     UltraWebGrid1.Clear();
     FEData = new FreightEasy.DataManager.FreightEasyData();
     FEData.AddToDataSet("SearchList", txtSQL);
     UltraWebGrid1.DataSource = FEData.Tables["SearchList"].DefaultView;
     UltraWebGrid1.DataBind();
     UltraWebGrid1.DisplayLayout.Pager.CurrentPageIndex = 1;
     txtResultBox.Text      = FEData.Tables["SearchList"].Rows.Count.ToString() + " Records Found.";
     btnExcelExport.Visible = true;
 }
예제 #16
0
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Email")
        {
            FreightEasy.DataManager.FreightEasyData fe = new FreightEasy.DataManager.FreightEasyData();
            fe.AddToDataSet("SetupSession", "SELECT * FROM setup_session WHERE sid='" + e.CommandArgument.ToString() + "'");
            DataRow dr = fe.Tables["SetupSession"].Rows[0];

            string sid                = dr["sid"].ToString();
            string email              = dr["email"].ToString();
            string password           = dr["password"].ToString();
            string elt_account_number = dr["elt_account_number"].ToString();


            string body = @"
                <html>
                <head>
                <title>FreightEasy Online Application (Setup Information)</title>
                <style type='text/css'>
	                .style3 {	
		                font-family: Verdana, Arial, Helvetica, sans-serif;	
		                font-size: 9px;}
                </style>
                </head>
                <body>
                <p class='style3'><strong>FreightEasy Online Application (Setup Information)</strong></p>
                <p />
                <table class='style3' width='100%' border='0' cellspacing='0' cellpadding='0'>
                <tr>
                <td colspan='2'>
                <a href='http://" + http_host + @"/IFF_MAIN/Authentication/SetupLogin.aspx?sid=" + sid + @"'>click to login</a>
                <p />Email Address: " + email + @"
                <p />Password: "******"</td>
                </tr>
                <tr>
                <td align='left' valign='bottom'>
                <span class='style3'>This message was sent by E-LOGISTICS TECHNOLOGY. (<a href='mailto:[email protected]'>[email protected]</a>)</span>
                </td>
                <td align='right' valign='top'>
                <a href='http://www.e-logitech.net target='_blank'><img src='http://www.e-logitech.net/elt_email/images/powered_logo.gif' width='123' height='50' border='0' /></a>
                </td>
                </tr>
                </table>
                </body>
                </html>";

            MailMessage message = new MailMessage("*****@*****.**", email, "FreightEasy Online Application (Setup Information)", body);
            message.IsBodyHtml = true;
            SmtpClient client = new SmtpClient("localhost", 25);
            client.Send(message);
        }
    }
예제 #17
0
 protected void CheckExistingAES()
 {
     if (AESID == "" || AESID == "0")
     {
         string aesFindSQL = @"SELECT * FROM aes_master WHERE elt_account_number=" + elt_account_number
                             + " AND file_type='OE' AND house_num=N'" + txtHouse.Text + "' AND master_num=N'" + txtMaster.Text + "'";
         FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
         feData.AddToDataSet("AESEntity", aesFindSQL);
         if (feData.Tables["AESEntity"].Rows.Count > 0)
         {
             DataRow drTmp = feData.Tables["AESEntity"].Rows[0];
             AESID = drTmp["auto_uid"].ToString();
         }
     }
 }
예제 #18
0
    protected string GetAgentInfo()
    {
        string agent_info = "";

        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("AgentInfo", "SELECT * FROM agent WHERE elt_account_number=" + elt_account_number);

        if (feData.Tables["AgentInfo"].Rows.Count > 0)
        {
            DataRow dr = feData.Tables["AgentInfo"].Rows[0];
            agent_info = dr["dba_name"] + "\n" + dr["business_address"] + "\n" + dr["business_city"] + "," +
                         dr["business_state"] + " " + dr["business_zip"] + " " + dr["business_country"];
        }

        return(agent_info);
    }
예제 #19
0
    protected void Insert_Booking_Confirm()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();

        ArrayList tranStrAL = new ArrayList();
        string    tranStr   = "";

        tranStr = "SET ANSI_WARNINGS OFF";
        tranStrAL.Add(tranStr);

        tranStr = @"INSERT INTO booking_confirm(elt_account_number,document_date,air_ocean,bc_no,booking_no,master_no,house_no,sub_house_no,shipper_acct,
            shipper_name,shipper_info,deliver_to_acct,deliver_to_name,deliver_to_info,cut_off_date,export_reference,carrier_acct,carrier_name,carrier_no,
            place_of_receipt,place_of_delivery,dep_port,arr_port,eta,etd,move_type,dest_agent_acct,dest_agent_name,dest_agent_info,empty_container_pick_up_acct,
            empty_container_pick_up_name,empty_container_pick_up_info,dangerous,quantity,quantity_unit,item_desc,gross_weight,weight_scale,dimension,dimension_scale,remark)
            VALUES(" + elt_account_number + "," + MakeDateString(this.txt_document_date.Text) + ",'O',N'" + this.ddl_prefix.Items[this.ddl_prefix.SelectedIndex].Text
                  + "-" + this.ddl_prefix.SelectedValue + "',N'" + this.txt_booking_no.Text + "',N'" + this.hf_master_no.Value + "',N'" + this.hf_house_no.Value
                  + "',N'" + this.hf_sub_house_no.Value + "'," + MakeNullCase(this.hShipperAcct.Value) + ",N'" + this.lstShipperName.Text
                  + "',N'" + this.txtShipperInfo.Text + "'," + MakeNullCase(this.hConsigneeAcct.Value) + ",N'" + this.lstConsigneeName.Text
                  + "',N'" + this.txtConsigneeInfo.Text + "',N'" + this.txt_cut_off_date.Text + "',N'" + this.txt_export_reference.Text
                  + "'," + MakeNullCase(this.hCarrierAcct.Value) + ",N'" + this.lstCarrierName.Text + "',N'" + this.txt_carrier_no.Text
                  + "',N'" + this.txt_place_of_receipt.Text + "',N'" + this.txt_place_of_delivery.Text + "',N'" + this.ddl_origin_port.SelectedValue
                  + "',N'" + this.ddl_dest_port.SelectedValue + "'," + MakeDateString(this.txt_eta_date.Text)
                  + "," + MakeDateString(this.txt_etd_date.Text) + ",N'" + this.txt_type_of_move.Text
                  + "'," + MakeNullCase(this.hAgentAcct.Value) + ",N'" + this.lstAgentName.Text + "',N'" + this.txtAgentInfo.Text
                  + "'," + MakeNullCase(this.hEmptyPickupAcct.Value) + ",N'" + this.lstEmptyPickupName.Text + "',N'" + this.txtEmptyPickupInfo.Text
                  + "',N'" + this.rbl_dangerous_good.SelectedValue + "'," + MakeNullCase(this.txt_quantity.Text) + ",N'" + this.ddl_quantity_unit.SelectedValue + "',N'" + this.txt_description.Text
                  + "'," + MakeNullCase(this.txt_weight.Text) + ",N'" + this.ddl_weight_scale.SelectedValue + "'," + MakeNullCase(this.txt_dimension.Text)
                  + ",N'" + this.ddl_dimension_scale.SelectedValue + "',N'" + this.txt_remark.Text + "')";
        tranStrAL.Add(tranStr);

        tranStr = "UPDATE user_prefix SET next_no=next_no+1 WHERE elt_account_number=" + elt_account_number
                  + "AND type='BC' AND prefix=N'" + this.ddl_prefix.Items[this.ddl_prefix.SelectedIndex].Text + "'";
        tranStrAL.Add(tranStr);

        tranStr = "SET ANSI_WARNINGS ON";
        tranStrAL.Add(tranStr);

        if (!feData.DataTransactions((string[])tranStrAL.ToArray(typeof(string))))
        {
            Response.Write(feData.GetLastTransactionError());
        }
        else
        {
            feData.AddToDataSet("BookingConfirmNew", "SELECT * FROM booking_confirm WHERE auto_uid=IDENT_CURRENT('booking_confirm')");
            Load_Booking_Confirm(feData.Tables["BookingConfirmNew"].Rows[0]["auto_uid"].ToString());
        }
    }
예제 #20
0
    protected void LoadAllData()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("SBInfo", "SELECT * FROM scheduleB WHERE elt_account_number=" + elt_account_number + " AND auto_uid=" + hSBID.Value);

        if (feData.Tables["SBInfo"].Rows.Count > 0)
        {
            DataRow drSB = feData.Tables["SBInfo"].Rows[0];
            txtSBCode.Text               = drSB["sb"].ToString();
            txtItemDesc.Text             = drSB["description"].ToString();
            lstSBUnit1.SelectedValue     = drSB["sb_unit1"].ToString();
            lstSBUnit2.SelectedValue     = drSB["sb_unit2"].ToString();
            lstExportCode.SelectedValue  = drSB["export_code"].ToString();
            lstLicenseType.SelectedValue = drSB["license_type"].ToString();
            txtECCN.Text = drSB["eccn"].ToString();
        }
    }
예제 #21
0
    protected void Load_Ports()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("Ports", "select * from port where elt_account_number=" + elt_account_number);

        ddl_dest_port.DataSource     = feData.Tables["Ports"];
        ddl_dest_port.DataTextField  = "port_desc";
        ddl_dest_port.DataValueField = "port_code";
        ddl_dest_port.DataBind();
        ddl_dest_port.Items.Insert(0, new ListItem("", ""));

        ddl_origin_port.DataSource     = feData.Tables["Ports"];
        ddl_origin_port.DataTextField  = "port_desc";
        ddl_origin_port.DataValueField = "port_code";
        ddl_origin_port.DataBind();
        ddl_origin_port.Items.Insert(0, new ListItem("", ""));
    }
예제 #22
0
    protected void Page_Init(object sender, EventArgs e)
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("Countries", "SELECT DISTINCT country_name,country_code FROM all_country_code ORDER BY country_name");

        ddCountry1.DataSource     = feData.Tables["Countries"];
        ddCountry1.DataTextField  = "country_name";
        ddCountry1.DataValueField = "country_code";
        ddCountry1.DataBind();
        ddCountry1.Items.Insert(0, new ListItem("", ""));

        ddCountry2.DataSource     = feData.Tables["Countries"];
        ddCountry2.DataTextField  = "country_name";
        ddCountry2.DataValueField = "country_code";
        ddCountry2.DataBind();
        ddCountry2.Items.Insert(0, new ListItem("", ""));
    }
예제 #23
0
    protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
        FreightEasy.DataManager.FreightEasyData FEData = new FreightEasy.DataManager.FreightEasyData();
        FEData.AddToDataSet("PageEntry", "select * from setup_master where page_id=" + ListBox1.SelectedValue);
        DataTable tmpDt = FEData.Tables["PageEntry"];

        if (tmpDt != null)
        {
            hSeqId.Value               = tmpDt.Rows[0]["seq_id"].ToString();
            hPageId.Value              = tmpDt.Rows[0]["page_id"].ToString();
            txtPageTitle.Text          = tmpDt.Rows[0]["title"].ToString();
            txtPageURL.Text            = tmpDt.Rows[0]["setup_url"].ToString();
            txtValidURL.Text           = tmpDt.Rows[0]["valid_url"].ToString();
            txtRemark.Text             = tmpDt.Rows[0]["remark"].ToString();
            lstSetupType.SelectedValue = tmpDt.Rows[0]["setup_type"].ToString();
        }
    }
예제 #24
0
    protected void Load_Prefix()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        feData.AddToDataSet("PrefixTable", "select * from user_prefix where elt_account_number=" + elt_account_number
                            + " and type='BC'");
        ddl_prefix.DataSource     = feData.Tables["PrefixTable"];
        ddl_prefix.DataTextField  = "prefix";
        ddl_prefix.DataValueField = "next_no";
        ddl_prefix.DataBind();

        if (feData.Tables["PrefixTable"].Rows.Count == 0)
        {
            string script = "<script type='text/javascript'>no_prefix_alert();</script>";
            this.ClientScript.RegisterClientScriptBlock(this.GetType(), "", script);
        }
        else
        {
            lbl_bc_no.Text = ddl_prefix.SelectedValue;
        }
    }
예제 #25
0
    protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
    {
        UltraWebGrid1.Bands[0].Columns.FromKey("gl_account_balance").Hidden = true;

        UltraGridColumn GLMasterType  = UltraWebGrid1.Bands[0].Columns.FromKey("gl_master_type");
        UltraGridColumn GLAccountType = UltraWebGrid1.Bands[0].Columns.FromKey("gl_account_type");

        GLAccountType.Type = ColumnType.DropDownList;
        // start getting gl types
        FreightEasy.DataManager.FreightEasyData glTypes = new FreightEasy.DataManager.FreightEasyData();
        glTypes.AddToDataSet("GLTypes", "select * from gl_reference");
        DataTable GLTypeTable = glTypes.Tables["GLTypes"];

        // end of getting gl types
        GLAccountType.ValueList.DataSource    = GLTypeTable;
        GLAccountType.ValueList.DisplayMember = GLTypeTable.Columns["gl_type"].ToString();
        GLAccountType.ValueList.ValueMember   = GLTypeTable.Columns["gl_type"].ToString();
        GLAccountType.ValueList.DataBind();
        GLAccountType.ValueList.Style.Font.Size = FontUnit.Point(8);
    }
예제 #26
0
    protected void btnPDFExport_Click(object sender, ImageClickEventArgs e)
    {
        ReportDocument rd      = new ReportDocument();
        string         rptFile = Server.MapPath("/IFF_MAIN/CrystalReportResources/rpt/AESList.rpt");
        string         xsdFile = Server.MapPath("/IFF_MAIN/CrystalReportResources/xsd/AESList.xsd");

        AESListDS = new FreightEasy.DataManager.FreightEasyData();
        string selectSQL = @"SELECT a.*, b.dba_name AS consignee_name, c.dba_name AS inter_consignee_name
            FROM aes_master a LEFT OUTER JOIN organization b ON (a.elt_account_number=b.elt_account_number AND a.consignee_acct=b.org_account_number) 
            LEFT OUTER JOIN organization c ON (a.elt_account_number=c.elt_account_number AND a.inter_consignee_acct=c.org_account_number)
            WHERE a.elt_account_number=" + elt_account_number + " AND ISNULL(file_type,'')='AE' ORDER BY a.last_modified desc";

        AESListDS.AddToDataSet("AESList", selectSQL);

        try
        {
            rd.Load(rptFile, OpenReportMethod.OpenReportByTempCopy);
            rd.SetDataSource(AESListDS.Copy());
            AESListDS.WriteXmlSchema(xsdFile);

            Response.Clear();
            Response.Buffer      = true;
            Response.ContentType = "application/pdf";
            Response.AddHeader("Content-Type", "application/pdf");
            Response.AddHeader("Content-disposition", "attachment;filename=AESList.pdf");

            MemoryStream oStream = (MemoryStream)rd.ExportToStream(ExportFormatType.PortableDocFormat);
            Response.BinaryWrite(oStream.ToArray());
        }
        catch { }
        finally
        {
            rd.Close();
            Response.Flush();
            Response.End();
        }
    }
예제 #27
0
    protected void LoadGeneralJournalEntry()
    {
        entry_no = "";
        if (Request.Params["EntryNo"] != null)
        {
            entry_no             = Request.Params["EntryNo"].ToString();
            hEntryNo.Value       = entry_no;
            btnDeleteTop.Visible = true;
            btnDeleteBot.Visible = true;
            FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
            feData.AddToDataSet("EntryInfo", "SELECT a.*,b.dba_name FROM general_journal_entry a LEFT OUTER JOIN organization b ON (a.elt_account_number=b.elt_account_number AND a.org_acct=b.org_account_number) WHERE a.elt_account_number=" + elt_account_number + " AND  a.entry_no=" + entry_no + " ORDER BY credit");
            if (feData.Tables["EntryInfo"].Rows.Count == 2)
            {
                DataRow drTmp = feData.Tables["EntryInfo"].Rows[0];

                lstVendorName.Text        = drTmp["dba_name"].ToString();
                hVendorAcct.Value         = drTmp["org_acct"].ToString();
                lstBanks.SelectedValue    = drTmp["gl_account_number"].ToString();
                lstRevenues.SelectedValue = feData.Tables["EntryInfo"].Rows[1]["gl_account_number"].ToString();
                txtAmount.Text            = drTmp["debit"].ToString();
                txtMemo.Text = drTmp["memo"].ToString();
            }
        }
    }
예제 #28
0
    protected void GetShipOutData()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();

        string txtSQL = "SELECT * FROM warehouse_shipout WHERE elt_account_number="
                        + elt_account_number + " AND so_num=N'" + SONum + "'";

        feData.AddToDataSet("ShipOut", txtSQL);

        if (feData.Tables["ShipOut"].Rows.Count > 0)
        {
            DataRow drTmp = feData.Tables["ShipOut"].Rows[0];
            txtSONum.Text = drTmp["so_num"].ToString();


            if (drTmp["customer_acct"].ToString() != "")
            {
                txtSQL = "SELECT * FROM organization WHERE elt_account_number="
                         + elt_account_number + " AND org_account_number=" + drTmp["customer_acct"].ToString();
                feData.AddToDataSet("ShipperInfo", txtSQL);
                if (feData.Tables["ShipperInfo"].Rows.Count > 0)
                {
                    DataRow drShipperTmp = feData.Tables["ShipperInfo"].Rows[0];
                    txtShipper.Text = drShipperTmp["dba_name"].ToString();
                }
            }

            if (drTmp["consignee_acct"].ToString() != "")
            {
                txtSQL = "SELECT * FROM organization WHERE elt_account_number="
                         + elt_account_number + " AND org_account_number=" + drTmp["consignee_acct"].ToString();
                feData.AddToDataSet("ConsigneeInfo", txtSQL);
                if (feData.Tables["ConsigneeInfo"].Rows.Count > 0)
                {
                    DataRow drConsigneeTmp = feData.Tables["ConsigneeInfo"].Rows[0];
                    txtConsignee.Text = drConsigneeTmp["dba_name"].ToString();
                }
            }

            txtSQL = "SELECT * FROM warehouse_receipt a LEFT OUTER JOIN warehouse_history b "
                     + "ON (a.elt_account_number=b.elt_account_number AND a.wr_num=b.wr_num) "
                     + "WHERE a.elt_account_number=" + elt_account_number + " AND b.so_num=N'"
                     + drTmp["so_num"].ToString() + "' AND history_type='Ship-out Made'";
            feData.AddToDataSet("WarehouseReceipts", txtSQL);

            int item_qty = 0;
            for (int i = 0; i < feData.Tables["WarehouseReceipts"].Rows.Count; i++)
            {
                DataRow drWRTmp = feData.Tables["WarehouseReceipts"].Rows[i];
                if (drWRTmp["item_desc"].ToString() != "")
                {
                    txtItemDesc.Text = txtItemDesc.Text + drWRTmp["item_desc"].ToString() + "\n";
                }

                if (drWRTmp["handling_info"].ToString() != "")
                {
                    txtHandling.Text = txtHandling.Text + drWRTmp["handling_info"].ToString() + "\n";
                }

                item_qty = item_qty + int.Parse(drWRTmp["item_piece_shipout"].ToString());
            }
            txtItemQty.Text = item_qty.ToString();
        }
    }
예제 #29
0
    protected void InitializeAll()
    {
        FreightEasy.DataManager.FreightEasyData feData = new FreightEasy.DataManager.FreightEasyData();
        string  CustomersSQL = "";
        DataRow drTmp        = null;

        // Consolidated House Item
        if (txtHAWB.Text != "")
        {
            CustomersSQL = @"SELECT a.org_account_number,CASE WHEN isnull(a.class_code,'')='' THEN a.dba_name ELSE a.dba_name + '[' + RTRIM(LTRIM(isnull(a.class_code,''))) + ']' END AS dba_name 
                FROM organization a LEFT OUTER JOIN hawb_master b ON (a.elt_account_number=b.elt_account_number AND a.org_account_number=b.agent_no) WHERE a.elt_account_number=" + elt_account_number +
                           " AND b.mawb_num=N'" + txtMAWB.Text + "' GROUP BY a.org_account_number,a.dba_name,a.class_code";
            feData.AddToDataSet("Customers", CustomersSQL);

            if (feData.Tables["Customers"].Rows.Count > 0)
            {
                lstCustomer.DataSource     = feData.Tables["Customers"];
                lstCustomer.DataTextField  = "dba_name";
                lstCustomer.DataValueField = "org_account_number";
                lstCustomer.DataBind();
                lstCustomer.Items.Insert(0, new ListItem("", ""));
            }

            feData.AddToDataSet("HouseInfo", "SELECT * FROM hawb_master WHERE elt_account_number=" + elt_account_number + " AND mawb_num=N'" + txtMAWB.Text + "' AND hawb_num=N'" + txtHAWB.Text + "'");

            if (feData.Tables["HouseInfo"].Rows.Count > 0)
            {
                drTmp = feData.Tables["HouseInfo"].Rows[0];

                lstCustomer.SelectedValue = drTmp["agent_no"].ToString();
                txtWeight.Text            = drTmp["total_chargeable_weight"].ToString();
                txtWeightScale.Text       = drTmp["weight_scale"].ToString();
            }

            // Other Charge
            if (txtItem.Text != "")
            {
                feData.AddToDataSet("ItemInfo", "SELECT * FROM hawb_other_charge WHERE elt_account_number=" + elt_account_number + " AND hawb_num=N'" + txtHAWB.Text + "' AND tran_no=" + txtItem.Text);
                if (feData.Tables["ItemInfo"].Rows.Count > 0)
                {
                    drTmp            = feData.Tables["ItemInfo"].Rows[0];
                    txtItemName.Text = drTmp["charge_desc"].ToString();
                    txtItemAmt.Text  = drTmp["amt_hawb"].ToString();
                    lstCostItem.Text = drTmp["cost_desc"].ToString();
                    hCostItem.Value  = drTmp["cost_code"].ToString();
                    txtCostAmt.Text  = drTmp["cost_amt"].ToString();
                }
            }
            // Weight Charge
            else
            {
                feData.AddToDataSet("ItemInfo", "SELECT * FROM hawb_weight_charge WHERE elt_account_number=" + elt_account_number + " AND hawb_num=N'" + txtHAWB.Text + "'");
                if (feData.Tables["ItemInfo"].Rows.Count > 0)
                {
                    drTmp            = feData.Tables["ItemInfo"].Rows[0];
                    txtItemName.Text = "Freight Charge";
                    txtItemAmt.Text  = drTmp["total_charge"].ToString();
                    lstCostItem.Text = drTmp["cost_desc"].ToString();
                    hCostItem.Value  = drTmp["cost_code"].ToString();
                    txtCostAmt.Text  = drTmp["cost_amt"].ToString();
                }
            }
        }

        // Direct Shipment
        else
        {
            CustomersSQL = @"SELECT a.org_account_number,CASE WHEN isnull(a.class_code,'')='' THEN a.dba_name ELSE a.dba_name + '[' + RTRIM(LTRIM(isnull(a.class_code,''))) + ']' END AS dba_name 
                FROM organization a LEFT OUTER JOIN mawb_master b ON (a.elt_account_number=b.elt_account_number AND a.org_account_number=b.shipper_account_number) WHERE a.elt_account_number=" + elt_account_number +
                           " AND b.mawb_num=N'" + txtMAWB.Text + "' GROUP BY a.org_account_number,a.dba_name,a.class_code";

            feData.AddToDataSet("Customers", CustomersSQL);

            if (feData.Tables["Customers"].Rows.Count > 0)
            {
                lstCustomer.DataSource     = feData.Tables["Customers"];
                lstCustomer.DataTextField  = "dba_name";
                lstCustomer.DataValueField = "org_account_number";
                lstCustomer.DataBind();
                lstCustomer.Items.Insert(0, new ListItem("", ""));
                lstCustomer.SelectedIndex = 1;
            }

            feData.AddToDataSet("MasterInfo", "SELECT * FROM mawb_master WHERE elt_account_number=" + elt_account_number + " AND mawb_num=N'" + txtMAWB.Text + "' AND mawb_num=N'" + txtMAWB.Text + "'");

            if (feData.Tables["MasterInfo"].Rows.Count > 0)
            {
                drTmp               = feData.Tables["MasterInfo"].Rows[0];
                txtWeight.Text      = drTmp["total_chargeable_weight"].ToString();
                txtWeightScale.Text = drTmp["weight_scale"].ToString();
            }

            // Other Charge
            if (txtItem.Text != "")
            {
                feData.AddToDataSet("ItemInfo", "SELECT * FROM mawb_other_charge WHERE elt_account_number=" + elt_account_number + " AND mawb_num=N'" + txtMAWB.Text + "' AND tran_no=" + txtItem.Text);
                if (feData.Tables["ItemInfo"].Rows.Count > 0)
                {
                    drTmp            = feData.Tables["ItemInfo"].Rows[0];
                    txtItemName.Text = drTmp["charge_desc"].ToString();
                    txtItemAmt.Text  = drTmp["amt_mawb"].ToString();
                    lstCostItem.Text = drTmp["cost_desc"].ToString();
                    hCostItem.Value  = drTmp["cost_code"].ToString();
                    txtCostAmt.Text  = drTmp["cost_amt"].ToString();
                }
            }
            // Weight Charge
            else
            {
                feData.AddToDataSet("ItemInfo", "SELECT * FROM mawb_weight_charge WHERE elt_account_number=" + elt_account_number + " AND mawb_num=N'" + txtMAWB.Text + "'");
                if (feData.Tables["ItemInfo"].Rows.Count > 0)
                {
                    drTmp            = feData.Tables["ItemInfo"].Rows[0];
                    txtItemName.Text = "Freight Charge";
                    txtItemAmt.Text  = drTmp["total_charge"].ToString();
                    lstCostItem.Text = drTmp["cost_desc"].ToString();
                    hCostItem.Value  = drTmp["cost_code"].ToString();
                    txtCostAmt.Text  = drTmp["cost_amt"].ToString();
                }
            }
        }

        feData.AddToDataSet("BookingInfo", "SELECT origin_port_id,dest_port_id,carrier_code,carrier_desc FROM mawb_number WHERE elt_account_number=" + elt_account_number + " AND mawb_no=N'" + txtMAWB.Text + "'");

        if (feData.Tables["BookingInfo"].Rows.Count > 0)
        {
            drTmp = feData.Tables["BookingInfo"].Rows[0];

            txtFrom.Text        = drTmp["origin_port_id"].ToString();
            txtTo.Text          = drTmp["dest_port_id"].ToString();
            txtCarrierCode.Text = drTmp["carrier_code"].ToString();
            txtCarrierDesc.Text = drTmp["carrier_desc"].ToString();
        }
    }
예제 #30
0
    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);
    }