Exemple #1
0
        private void BindBillToAddress()
        {
            //[pCustomerAddressID],[Type],[fCustomerMasterID],[Name2],[AddrLine1],[AddrLine2],[AddrLine3],[AddrLine4],
            //[AddrLine5],[City],[State],[PostCd],[Country],[PhoneNo],[CustContacts],[fCustContactsID],[UPSZone],
            //[FaxPhoneNo],[EDIPhoneNo],[UPSShipperNo],[Email],CustomerAddress.[EntryID],CustomerAddress.[EntryDt]
            //,CustomerAddress.[ChangeID],CustomerAddress.[ChangeDt],CustomerAddress.[StatusCd],[LocationName]
            if (CustomerNumber != "")
            {
                if (CustType == CustomerType.BT || CustType == CustomerType.BTST)
                {
                    dsValue = customerDetails.GetCustomerAddress(CustomerNumber);
                }
                else
                {
                    dsValue = customerDetails.GetCustomerAddress(BillToCustomerNo);
                }

                if (dsValue != null && dsValue.Rows.Count > 0)
                {
                    lblBillCity.Text             = dsValue.Rows[0]["City"].ToString();
                    lblBillCountry.Text          = dsValue.Rows[0]["Country"].ToString();
                    lblBillFax.Text              = customerDetails.FormatPhoneFax(dsValue.Rows[0]["FaxPhoneNo"].ToString());
                    lblBillLine1.Text            = dsValue.Rows[0]["AddrLine1"].ToString();
                    lblBillName.Text             = dsValue.Rows[0]["CustName"].ToString();
                    lblBillPhone.Text            = customerDetails.FormatPhoneFax(dsValue.Rows[0]["PhoneNo"].ToString());
                    lblBillToCustomerNumber.Text = dsValue.Rows[0]["CustNo"].ToString();

                    lblBillChangeDate.Text = (dsValue.Rows[0]["ChangeDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["ChangeDt"].ToString()).ToShortDateString();
                    lblBillChangeID.Text   = dsValue.Rows[0]["ChangeID"].ToString();
                    lblBillEntryDate.Text  = (dsValue.Rows[0]["EntryDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["EntryDt"].ToString()).ToShortDateString();
                    lblBillEntryID.Text    = dsValue.Rows[0]["EntryID"].ToString();

                    lblCustMastChnageDt.Text = (dsValue.Rows[0]["CustMasterChangeDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["CustMasterChangeDt"].ToString()).ToShortDateString();
                    lblCustMastChangeID.Text = dsValue.Rows[0]["CustMasterChangeID"].ToString();
                    lblCustMastEntryDt.Text  = (dsValue.Rows[0]["CustMasterEntryDt"].ToString() == "") ? "" : Convert.ToDateTime(dsValue.Rows[0]["CustMasterEntryDt"].ToString()).ToShortDateString();
                    lblCustMastEntryID.Text  = dsValue.Rows[0]["CustMasterEntryID"].ToString();
                    tblEntryPanel.Visible    = true;
                }
                else
                {
                    ClearBillControls();
                }


                if (CustType == CustomerType.BTST)
                {
                    DataTable dtsoldto = customerDetails.GetCustomerSoldToAddress(CustomerNumber);
                    if (dtsoldto != null && dtsoldto.Rows.Count > 0)
                    {
                        dsValue = dtsoldto.Copy();
                    }
                    BindSoldToAddress();
                }
                else if (CustType == CustomerType.ST)
                {
                    dsValue = customerDetails.GetCustomerAddress(CustomerNumber);
                    BindSoldToAddress();
                }
                else
                {
                    tdSoldAddress.Style.Add(HtmlTextWriterStyle.Display, "none");
                }
            }
            else
            {
                ClearBillControls();
                ClearSoldControls();
            }
        }