void DataBinder()
{
txtContainer.Focus(true);
DataFactory dal = new DataFactory();
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanExport_Container_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "List").Append("oc_ROWID", hidID.Text)
.Append("oc_ToHBL", Request["HBL"])
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string temphawb = ds.Tables[0].Rows[0]["HBL"].ToString().ToUpper() == "" ? "" : "HBL# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["HBL"].ToString().ToUpper() + "</span>";
string tempmawb = ds.Tables[0].Rows[0]["MBL"].ToString().ToUpper() == "" ? "" : "MBL# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["MBL"].ToString().ToUpper() + "</span>";
string tempLotNo = ds.Tables[0].Rows[0]["LotNo"].ToString().ToUpper() == "" ? "" : "Lot# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["LotNo"].ToString().ToUpper() + "</span>";
labHeader.Html = (temphawb == "" ? "" : "<span style='padding-left:10px'>" + temphawb + "</span>") + (tempmawb == "" ? "" : "<span style='padding-left:10px'>" + tempmawb + "</span>") + (tempLotNo == "" ? "" : "<span style='padding-left:10px'>" + tempLotNo + "</span>");
chkIsMain.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["oc_isMain"]);
txtContainer.Text = ds.Tables[0].Rows[0]["oc_CtnrNo"].ToString();
txtSeal.Text = ds.Tables[0].Rows[0]["oc_SealNo"].ToString();
CmbSize.setValue(ds.Tables[0].Rows[0]["oc_CtnrSize"].ToString());
CmbSerMode.setValue(ds.Tables[0].Rows[0]["oc_Servicemode"].ToString());
txtSO.Text = ds.Tables[0].Rows[0]["oc_SONo"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["oc_GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["oc_GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["oc_CBM"].ToString()))
{
txtCBM.Text = ds.Tables[0].Rows[0]["oc_CBM"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["oc_Piece"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["oc_Piece"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["oc_Unit"].ToString());
txtMarks1.Text = ds.Tables[0].Rows[0]["oc_OrderMarks"].ToString();
txtMarks2.Text = ds.Tables[0].Rows[0]["oc_OrderDescription"].ToString();
txtmarks3.Text = ds.Tables[0].Rows[0]["oc_OrderNoOfPackage"].ToString();
lblPiece.Text = txtPiece.Text;
//lblUnit.Text = ds.Tables[0].Rows[0]["oc_Unit"].ToString();
X.AddScript("var r = StoreUnit.getById($('#CmbUnit').val());if(!Ext.isEmpty(r)){#{lblUnit}.setValue(r.data.short);}");
txtRemark.Text = ds.Tables[0].Rows[0]["oc_Remark"].ToString();
if (string.IsNullOrEmpty(Request["ID"]))
{
ControlBinder.pageTitleMsg(false, "OE-C New", "<p>Status: New Blank Container .</p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "OE-C:" + txtContainer.Text, "<p>Status: Edit Container of <span>" + txtContainer.Text.ToUpper() + "</span>.</p>", div_bottom);
}
}
else
{
ControlBinder.pageTitleMsg(false, "OE-C New", "<p>Status: New Blank Container .</p>", div_bottom);
}
}
private void ClearControls()
{
txtHawb.Text = "";
CmbService.setValue("");
CmbPPD.SelectedItem.Value = "";
CmbSalesman.setValue("");
txtColoader.Text = "";
txtReference.Text = "";
txtClearance.Text = "";
txtDO.Text = "";
CmbReceipt.setValue("");
CmbFinalDest.setValue("");
chkInsurance.Checked = false;
chkDG.Checked = false;
chkSurrender.Checked = false;
CmbShipperCode.setValue("");
//CmbShipperName.SelectedItem.Value = "";
CmbConsignee.setValue("");
//CmbConsigneeName.SelectedItem.Value = "";
CmbNotify1.setValue("");
//mbNotify1Name.SelectedItem.Value = "";
CmbNotify2.setValue("");
//CmbNotify2Name.SelectedItem.Value = "";
CmbCoLoader.setValue("");
//CmbCoLoaderName.SelectedItem.Value = "";
CmbBroker.setValue("");
//CmbBrokerName.SelectedItem.Value = "";
txtGWT.Text = "";
txtCWT.Text = "";
txtCBM.Text = "";
txtPiece.Text = "";
CmbUnit.setValue("");
txtContainer.Text = "";
CmbWarehouse.setValue("");
//CmbWarehouseName.SelectedItem.Value = "";
txtFreeStorageStart.Text = "";
txtFreeStorageEnd.Text = "";
txtPickUp.Text = "";
//CmbCompany.Text = "";
// CmbCompanyName.Text = "";
//CmbCurrency.Text = "";
txtRemark.Text = "";
}
protected void Page_PreRender(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
if (!IsPostBack)
{
CmbUnit.setValue("PKG");
ComboBoxBinding();
DataBinder();
LockControl();
}
}
}
/// <summary>
/// 控件初始化
/// </summary>
#region ComboBoxBinder() Author ：Micro (2011-09-06)
void ControlsInit()
{
txtMawb.Focus(true);
labLotNo.Text = "";
labAeLotNo.Text = "";
txtMawb.Text = "";
txtReference.Text = "";
txtClearence.Text = "";
CmbCarrierCode.Text = "";
//CmbCarrierText.Value = "";
CmbShipperCode.Text = "";
//CmbShipperText.Value = "";
CmbConsigneeCode.Text = "";
//CmbConsigneeText.Value = "";
CmbNotify1Code.Text = "";
//CmbNotify1Text.Value = "";
CmbNotify2Code.Text = "";
//CmbNotify2Text.Value = "";
CmbDischargeCode.Text = "";
//CmbDischargeText.Value = "";
CmbSalesman.Text = "";
chbDirect.Checked = false;
txtGWT.Text = "";
txtVWT.Text = "";
txtCWT.Text = "";
txtPiece.Text = "";
txtPallet.Text = "";
//CmbUnit.Text = "";
txtRemark.Text = "";
txtATA.Text = "";
txtATD.Text = "";
txtETA.Text = "";
txtETD.Text = "";
txtFlightRight.Text = "";
CmbCarrierRight.Text = "";
CmbFromRight.setValue("");
CmbToRight.setValue("");
// CmbCompanyRightCode.Text = "";
// CmbCompanyRightText.Text = "";
//CmbCurrencyRight.Text = "";
CmbUnit.setValue("CTN");
//CmbUnit.Text="CTN";
//td_sales1.Style.Value = "display:none";
td_sales2.Style.Value = "display:none";
}
void DataBinder()
{
txtContainer.Focus(true);
DataFactory dal = new DataFactory();
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_Container_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "List").Append("oc_ROWID", hidID.Text)
.Append("oc_ToHBL", Request["HBL"])
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
txtContainer.Text = ds.Tables[0].Rows[0]["oc_CtnrNo"].ToString();
txtSeal.Text = ds.Tables[0].Rows[0]["oc_SealNo"].ToString();
CmbSize.setValue(ds.Tables[0].Rows[0]["oc_CtnrSize"].ToString());
CmbSerMode.setValue(ds.Tables[0].Rows[0]["oc_Servicemode"].ToString());
txtSO.Text = ds.Tables[0].Rows[0]["oc_SONo"].ToString();
txtGWT.Text = ds.Tables[0].Rows[0]["oc_GWT"].ToString();
txtCBM.Text = ds.Tables[0].Rows[0]["oc_CBM"].ToString();
txtPiece.Text = ds.Tables[0].Rows[0]["oc_Piece"].ToString();
CmbUnit.setValue(ds.Tables[0].Rows[0]["oc_Unit"].ToString());
txtMarks1.Text = ds.Tables[0].Rows[0]["oc_OrderMarks"].ToString();
txtMarks2.Text = ds.Tables[0].Rows[0]["oc_OrderDescription"].ToString();
txtmarks3.Text = ds.Tables[0].Rows[0]["oc_OrderNoOfPackage"].ToString();
lblPiece.Text = ds.Tables[0].Rows[0]["oc_Piece"].ToString();
lblUnit.Text = ds.Tables[0].Rows[0]["oc_Unit"].ToString();
txtRemark.Text = ds.Tables[0].Rows[0]["oc_Remark"].ToString();
if (string.IsNullOrEmpty(Request["ID"]))
{
ControlBinder.pageTitleMsg(false, "OI-C New", "<p>Status: New Blank Container .</p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "OI-C:" + txtContainer.Text, "<p>Status: Edit Container of <span>" + txtContainer.Text + "</span>.</p>", div_bottom);
}
}
else
{
ControlBinder.pageTitleMsg(false, "OI-C New", "<p>Status: New Blank Container .</p>", div_bottom);
}
}
private void DataBindList()
{
txtHawb.Focus(true);
UserSheet1.seed = hidSeed.Text;
List <IFields> Getlist = new List <IFields>();
Getlist.Add(dal.CreateIFields().Append("Option", "List")
.Append("seed", hidSeed.Text)
.Append("air_ToMAWB", hidMAWB.Text)
.Append("STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("SYS", SYS)
);
DataSet ds = GetDs("FW_AirImport_HAWB_SP", Getlist);
if (ds != null && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["RowID"].ToString() != "")
{
txtHawb.Text = ds.Tables[0].Rows[0]["HAWB"].ToString();
txtReference.Text = ds.Tables[0].Rows[0]["Reference"].ToString();
txtClearance.Text = ds.Tables[0].Rows[0]["Clearance"].ToString();
chkInsurance.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Insurance"].ToString() == "" ? 0 : ds.Tables[0].Rows[0]["Insurance"]);
labMAWB.Text = ds.Tables[0].Rows[0]["MAWB"].ToString();
labLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
CmbReceipt.setValue(ds.Tables[0].Rows[0]["Receipt"].ToString());
CmbFinalDest.setValue(ds.Tables[0].Rows[0]["FinalDest"].ToString());
CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"].ToString());
chkDG.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["DG"].ToString() == "" ? 0 : ds.Tables[0].Rows[0]["DG"]);
chkSurrender.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Surrender"].ToString() == "" ? 0 : ds.Tables[0].Rows[0]["Surrender"]);
CmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString());
CmbShipperCode.Text = ds.Tables[0].Rows[0]["ShipperName"].ToString();
CmbConsignee.setValue(ds.Tables[0].Rows[0]["Consignee"].ToString());
CmbConsignee.Text = ds.Tables[0].Rows[0]["ConsigneeName"].ToString();
CmbNotify1.setValue(ds.Tables[0].Rows[0]["Notify1"].ToString());
CmbNotify1.Text = ds.Tables[0].Rows[0]["Notify1Name"].ToString();
CmbNotify2.setValue(ds.Tables[0].Rows[0]["Notify2"].ToString());
CmbNotify2.Text = ds.Tables[0].Rows[0]["Notify2Name"].ToString();
CmbCoLoader.setValue(ds.Tables[0].Rows[0]["Coloader"].ToString());
CmbCoLoader.Text = ds.Tables[0].Rows[0]["ColoaderName"].ToString();
CmbBroker.setValue(ds.Tables[0].Rows[0]["Broker"].ToString());
CmbBroker.Text = ds.Tables[0].Rows[0]["BrokerName"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["VWT"].ToString()))
{
txtVWT.Text = ds.Tables[0].Rows[0]["VWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CWT"].ToString()))
{
txtCWT.Text = ds.Tables[0].Rows[0]["CWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Piece"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["Piece"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["Unit"].ToString());
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Pallet"].ToString()))
{
txtPallet.Text = ds.Tables[0].Rows[0]["Pallet"].ToString();
}
CmbWarehouse.setValue(ds.Tables[0].Rows[0]["Warehouse"].ToString());
CmbWarehouse.Text = ds.Tables[0].Rows[0]["WarehouseName"].ToString();
txtFreeStorageStart.Text = ds.Tables[0].Rows[0]["FreeStorageStart"].ToString();
txtFreeStorageEnd.Text = ds.Tables[0].Rows[0]["FreeStorageEnd"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["FreeStorage"].ToString()))
{
NumFreeStorage.Text = ds.Tables[0].Rows[0]["FreeStorage"].ToString();
}
txtPickUp.Text = ds.Tables[0].Rows[0]["PickUp"].ToString();
txtRemark.Text = ds.Tables[0].Rows[0]["Remark"].ToString();
if (Convert.ToBoolean(ds.Tables[0].Rows[0]["active"]))
{
img_void.Style.Add("display", "none");
}
else
{
img_void.Style.Add("display", "inline");
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
}
GridPanelInvoice.GetStore().DataSource = ds.Tables[1];
GridPanelInvoice.GetStore().DataBind();
GridPanelForeign.GetStore().DataSource = ds.Tables[3];
GridPanelForeign.GetStore().DataBind();
GridPanelRoute.GetStore().DataSource = ds.Tables[4];
GridPanelRoute.GetStore().DataBind();
GridPanelContact.GetStore().DataSource = ds.Tables[5];
GridPanelContact.GetStore().DataBind();
ControlBinder.pageTitleMsg(false, "AI-H:" + labLotNo.Text, "<p>Status : Edit HAWB of <span>" + labLotNo.Text + "</span></p>", div_bottom);
}
else
{
labMAWB.Text = ds.Tables[0].Rows[0]["MAWB"].ToString();
labLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
CmbReceipt.setValue(ds.Tables[0].Rows[0]["Receipt"].ToString());
CmbFinalDest.setValue(ds.Tables[0].Rows[0]["FinalDest"].ToString());
CmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString());
CmbConsignee.setValue(ds.Tables[0].Rows[0]["Consignee"].ToString());
CmbCoLoader.setValue(ds.Tables[0].Rows[0]["Coloader"].ToString());
CmbBroker.setValue(ds.Tables[0].Rows[0]["Broker"].ToString());
CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"].ToString());
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["VWT"].ToString()))
{
txtVWT.Text = ds.Tables[0].Rows[0]["VWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CWT"].ToString()))
{
txtCWT.Text = ds.Tables[0].Rows[0]["CWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Piece"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["Piece"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["Unit"].ToString());
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Pallet"].ToString()))
{
txtPallet.Text = ds.Tables[0].Rows[0]["Pallet"].ToString();
}
ControlBinder.pageTitleMsg(false, "AI-H New", "<p>Status : New Blank Hawb </p>", div_bottom);
}
}
void DataBinder(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0)
{
ControlBinder.pageTitleMsg(false, "OE-M New", "<p>Status : New Blank MBL . </p>", div_bottom);
return;
}
labImpLotNo.Text = dt.Rows[0]["LotNo"].ToString();
string tempmawb = dt.Rows[0]["MBL"].ToString().ToUpper() == "" ? "" : "MBL# " + "<span style='color:#ff0000;'>" + dt.Rows[0]["MBL"].ToString().ToUpper() + "</span>";
string tempLotNo = labImpLotNo.Text == "" ? "" : "Lot# " + "<span style='color:#ff0000;'>" + labImpLotNo.Text + "</span>";
labHeader.Html = (tempmawb == "" ? "" : "<span>" + tempmawb + "</span>") + (tempLotNo == "" ? "" : "<span style='padding-left:10px'>" + tempLotNo + "</span>");
txtMBL.Text = dt.Rows[0]["MBL"].ToString();
cmbMode.setValue(dt.Rows[0]["ServiceMode"].ToString());
CmbGroup.SelectedItem.Value = dt.Rows[0]["o_ServiceType"].ToString();
cmbPPD.Text = dt.Rows[0]["PPD"].ToString();
cmbSales.setValue(dt.Rows[0]["Salesman"].ToString());
cmbCarrierCode.setValue(dt.Rows[0]["Carrier"].ToString());
cmbCarrierCode.Text = dt.Rows[0]["CarrierName"].ToString();
cmbShipperCode.setValue(dt.Rows[0]["Shipper"].ToString());
cmbShipperCode.Text = dt.Rows[0]["ShipperName"].ToString();
cmbConsigneeCode.setValue(dt.Rows[0]["Consignee"].ToString());
cmbConsigneeCode.Text = dt.Rows[0]["ConsigneeName"].ToString();
cmbDischargeCode.setValue(dt.Rows[0]["Coloader"].ToString());
cmbDischargeCode.Text = dt.Rows[0]["ColoaderName"].ToString();
CmbNotify1.setValue(dt.Rows[0]["Notify1"].ToString());
CmbNotify1.Text = dt.Rows[0]["Notify1Name"].ToString();
CmbNotify2.setValue(dt.Rows[0]["Notify2"].ToString());
CmbNotify2.Text = dt.Rows[0]["Notify2Name"].ToString();
cmbBrokerCode.setValue(dt.Rows[0]["Broker"].ToString());
cmbBrokerCode.Text = dt.Rows[0]["BrokerName"].ToString();
cmbVesselCode.SelectedItem.Value = dt.Rows[0]["Vessel"].ToString();
StoreVoyage.RemoveAll();
DataTable dt1 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageList").
Append("sys", FSecurityHelper.CurrentUserDataGET()[12]).
Append("STAT", cmbVesselCode.Text)
}).GetTable();
StoreVoyage.DataSource = dt1;
StoreVoyage.DataBind();
if (dt1 != null && dt1.Rows.Count > 0)
{
cmbVesselText.SelectedItem.Value = dt.Rows[0]["Voyage"].ToString();
}
cmbLoading.setValue(dt.Rows[0]["Loading"].ToString());
cmbPort.setValue(dt.Rows[0]["Port"].ToString());
cmbFinalDest.setValue(dt.Rows[0]["FinalDest"].ToString());
txtCFSClosing.Text = dt.Rows[0]["CFS"].ToString();
txtCYClosing.Text = dt.Rows[0]["CY"].ToString();
txtOnBoard.Text = dt.Rows[0]["OnBoard"].ToString();
txtETD.Text = dt.Rows[0]["ETD"].ToString();
txtETADischarge.Text = dt.Rows[0]["ETAdischarge"].ToString();
txtETAFinal.Text = dt.Rows[0]["ETAFinal"].ToString();
txtATD.Text = dt.Rows[0]["ATD"].ToString();
#region ///pre-Carriage
cmbpreVessel.SelectedItem.Value = dt.Rows[0]["PreVessel"].ToString();
StorePreVoyage.RemoveAll();
DataTable dt2 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageList").
Append("sys", FSecurityHelper.CurrentUserDataGET()[12]).
Append("STAT", cmbpreVessel.Text)
}).GetTable();
StorePreVoyage.DataSource = dt2;
StorePreVoyage.DataBind();
if (dt2 != null && dt2.Rows.Count > 0)
{
cmbpreVoyage.SelectedItem.Value = dt.Rows[0]["PreVoyage"].ToString();
}
txtpreonboard.Text = dt.Rows[0]["PreOnBoard"].ToString();
#endregion
if (!string.IsNullOrEmpty(dt.Rows[0]["GWT"].ToString()))
{
txtCGWT.Text = dt.Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["AWT"].ToString()))
{
txtAGWT.Text = dt.Rows[0]["AWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["CBM"].ToString()))
{
txtCCBM.Text = dt.Rows[0]["CBM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["ACBM"].ToString()))
{
txtACBM.Text = dt.Rows[0]["ACBM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["PKGS"].ToString()))
{
txtCPiece.Text = dt.Rows[0]["PKGS"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["APKGS"].ToString()))
{
txtAPiece.Text = dt.Rows[0]["APKGS"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["WM"].ToString()))
{
txtCWM.Text = dt.Rows[0]["WM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["AWM"].ToString()))
{
txtAWM.Text = dt.Rows[0]["AWM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Container"].ToString()))
{
txtContainer.Text = dt.Rows[0]["Container"].ToString();
}
CmbUnit.setValue(dt.Rows[0]["Unit"].ToString());
txtM_to.Value = dt.Rows[0]["M_to"].ToString();
txtM_to.Text = dt.Rows[0]["M_toName"].ToString();
txtclpRemark.Text = dt.Rows[0]["o_DeclareRemark"].ToString();
txtAccRemark.Text = dt.Rows[0]["o_AccountRemark"].ToString();
txtMAWBRemark.Text = dt.Rows[0]["o_Remark"].ToString();
if (ControlBinder.IsDisplayLotNo(txtETD.Text.Trim(), labImpLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
if (dt.Rows[0]["Active"].ToString() == "Y")
{
img_void.Style.Value = "display:none";
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnPull.Disabled = true;
btnNewBooking.Disabled = true;
btnAddBooking.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
btnUpdateLotNo.Hide();
}
hidSeed.Text = dt.Rows[0]["seed"].ToString();
ControlBinder.pageTitleMsg(false, "OE-M:" + labImpLotNo.Text, "<p>Status : Edit MBL of <span>" + dt.Rows[0]["LotNo"] + "</span> </p>", div_bottom);
}
/// <summary>
/// 初始数据
/// </summary>
#region 初始数据 DataBinder() Author：Micro (2011-09-05)
void DataBinder()
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_Other_Domestic_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "GetList").Append("tri_Seed", hidSeed.Text)
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
labLotNo.Text = ds.Tables[0].Rows[0]["tri_LotNo"].ToString();
hidLotNo.Text = ds.Tables[0].Rows[0]["tri_LotNo"].ToString();
txtMAWB.Text = ds.Tables[0].Rows[0]["tri_MBL"].ToString();
txtHAWB.Text = ds.Tables[0].Rows[0]["tri_HBL"].ToString();
if (ds.Tables[0].Rows[0]["tri_VesselID"].ToString() == "0" || ds.Tables[0].Rows[0]["tri_VesselID"].ToString() == "")
{
cmbVesselCode.SelectedItem.Value = ds.Tables[0].Rows[0]["tri_Vessel"].ToString();
cmbVesselText.SelectedItem.Value = ds.Tables[0].Rows[0]["tri_Voyage"].ToString();
}
else
{
cmbVesselCode.SelectedItem.Value = ds.Tables[0].Rows[0]["tri_VesselID"].ToString();
StoreVoyage.RemoveAll();
DataTable dt1 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageList").
Append("sys", FSecurityHelper.CurrentUserDataGET()[12]).
Append("STAT", cmbVesselCode.Text)
}).GetTable();
StoreVoyage.DataSource = dt1;
StoreVoyage.DataBind();
if (ds.Tables[0].Rows[0]["tri_VoyageID"].ToString() == "0" || ds.Tables[0].Rows[0]["tri_VoyageID"].ToString() == "")
{
cmbVesselText.SelectedItem.Value = ds.Tables[0].Rows[0]["tri_Voyage"].ToString();
}
else if (dt1 != null && dt1.Rows.Count > 0)
{
cmbVesselText.SelectedItem.Value = ds.Tables[0].Rows[0]["tri_VoyageID"].ToString();
}
}
CmbDeparture.setValue(ds.Tables[0].Rows[0]["tri_LocReceived"].ToString());
CmbDest.setValue(ds.Tables[0].Rows[0]["tri_LocFinal"].ToString());
txtDepartDate.Text = ds.Tables[0].Rows[0]["tri_ETD"].ToString();
txtDepL.Text = ds.Tables[0].Rows[0]["tri_LocReceivedL"].ToString();
txtDesL.Text = ds.Tables[0].Rows[0]["tri_LocFinalL"].ToString();
txtArrivalDate.Text = ds.Tables[0].Rows[0]["tri_ETA"].ToString();
txtJob.Text = ds.Tables[0].Rows[0]["tri_EReceipt"].ToString();
txtMAWBRemark.Text = ds.Tables[0].Rows[0]["tri_Remark"].ToString();
CmbSalesman.setValue(ds.Tables[0].Rows[0]["tri_Sales"].ToString());
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_Container"].ToString()))
{
txtContainer.Text = ds.Tables[0].Rows[0]["tri_Container"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["tri_GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_CBM"].ToString()))
{
txtCBM.Text = ds.Tables[0].Rows[0]["tri_CBM"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_CWT"].ToString()))
{
txtCWT.Text = ds.Tables[0].Rows[0]["tri_CWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_Piece"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["tri_Piece"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["tri_Unit"].ToString());
CmbShipperCode.setValue(ds.Tables[0].Rows[0]["tri_Shipper"].ToString());
CmbShipperCode1.Text = ds.Tables[0].Rows[0]["tri_Shipper"].ToString();
CmbShipperCode_name.Text = ds.Tables[0].Rows[0]["tri_ShipperLine"].ToString();
CmbConsigneeCode.setValue(ds.Tables[0].Rows[0]["tri_Consignee"].ToString());
CmbConsigneeCode1.Text = ds.Tables[0].Rows[0]["tri_Consignee"].ToString();
CmbConsigneeCode_name.Text = ds.Tables[0].Rows[0]["tri_ConsigneeLine"].ToString();
CmbNotify1Code.setValue(ds.Tables[0].Rows[0]["tri_PartyA"].ToString());
CmbNotify1Code1.Text = ds.Tables[0].Rows[0]["tri_PartyA"].ToString();
CmbNotify1Code_name.Text = ds.Tables[0].Rows[0]["tri_PartyALine"].ToString();
CmbNotify2Code.setValue(ds.Tables[0].Rows[0]["tri_PartyB"].ToString());
CmbNotify2Code1.Text = ds.Tables[0].Rows[0]["tri_PartyB"].ToString();
CmbNotify2Code_name.Text = ds.Tables[0].Rows[0]["tri_PartyBLine"].ToString();
CmbCarrierCode.setValue(ds.Tables[0].Rows[0]["tri_Carrier"].ToString());
CmbCarrierCode1.Text = ds.Tables[0].Rows[0]["tri_Carrier"].ToString();
CmbCarrierCode_name.Text = ds.Tables[0].Rows[0]["tri_CarrierLine"].ToString();
CmbCoLoader.setValue(ds.Tables[0].Rows[0]["tri_CoLoader"].ToString());
CmbCoLoader1.Text = ds.Tables[0].Rows[0]["tri_CoLoader"].ToString();
CmbCoLoader_name.Text = ds.Tables[0].Rows[0]["tri_CoLoaderLine"].ToString();
if (ControlBinder.IsDisplayLotNo(txtJob.Text.Trim(), hidLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
if (ds.Tables[0].Rows[0]["Active"].ToString() == "Y")
{
img_void.Style.Value = "display:none";
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
btnUpdateLotNo.Hide();
}
gridInvoice.GetStore().DataSource = ds.Tables[1];
gridInvoice.GetStore().DataBind();
ControlBinder.pageTitleMsg(false, "Domestic Shipment:" + ds.Tables[0].Rows[0]["tri_LotNo"].ToString(), "<p>Status : Edit Domestic Shipment of <span>" + ds.Tables[0].Rows[0]["tri_LotNo"].ToString() + "</span></p>", div_bottom);
}
else
{
txtJob.RawText = DateTime.Now.ToString("dd/MM/yyyy");
txtJob.Text = DateTime.Now.ToString("yyyy/MM/dd");
txtDepartDate.RawText = DateTime.Now.ToString("dd/MM/yyyy");
txtDepartDate.Text = DateTime.Now.ToString("yyyy/MM/dd");
txtArrivalDate.RawText = DateTime.Now.ToString("dd/MM/yyyy");
txtArrivalDate.Text = DateTime.Now.ToString("yyyy/MM/dd");
//CmbUnit.setValue("CTN");
ControlBinder.pageTitleMsg(false, "Domestic Shipment:New", "<p>Status : New Blank Domestic Shipment </p>", div_bottom);
}
}
void DataBinder(DataTable dt)
{
CmbUnit.setValue("PKG");
if (dt == null || dt.Rows.Count == 0)
{
ControlBinder.pageTitleMsg(false, "OI-M New", "<p>Status : New Blank MBL </p>", div_bottom);
return;
}
labImpLotNo.Text = dt.Rows[0]["LotNo"].ToString();
hidLotNo.Text = dt.Rows[0]["LotNo"].ToString();
txtMBL.Text = dt.Rows[0]["MBL"].ToString();
cmbMode.setValue(dt.Rows[0]["ServiceMode"].ToString());
cmbPPD.Text = dt.Rows[0]["PPD"].ToString();
cmbSales.setValue(dt.Rows[0]["Salesman"].ToString());
txtColoader.Text = dt.Rows[0]["ColoaderMBL"].ToString();
txtReference.Text = dt.Rows[0]["Reference"].ToString();
txtClearance.Text = dt.Rows[0]["Clearance"].ToString();
cmbCarrierCode.setValue(dt.Rows[0]["Carrier"].ToString());
cmbCarrierCode.Text = dt.Rows[0]["CarrierName"].ToString();
cmbShipperCode.setValue(dt.Rows[0]["Shipper"].ToString());
cmbShipperCode.Text = dt.Rows[0]["ShipperName"].ToString();
cmbConsigneeCode.setValue(dt.Rows[0]["Consignee"].ToString());
cmbConsigneeCode.Text = dt.Rows[0]["ConsigneeName"].ToString();
cmbDischargeCode.setValue(dt.Rows[0]["Discharge"].ToString());
cmbDischargeCode.Text = dt.Rows[0]["DischargeName"].ToString();
cmbBrokerCode.setValue(dt.Rows[0]["Boroker"].ToString());
cmbBrokerCode.Text = dt.Rows[0]["BorokerName"].ToString();
cmbVesselCode.SelectedItem.Value = dt.Rows[0]["Vessel"].ToString();
ComList();
cmbVesselText.SelectedItem.Value = dt.Rows[0]["Voyage"].ToString();
X.AddScript("getVessel('" + dt.Rows[0]["Vessel"].ToString() + "','" + dt.Rows[0]["Voyage"].ToString() + "');");
cmbLoading.setValue(dt.Rows[0]["Loading"].ToString());
cmbPort.setValue(dt.Rows[0]["Port"].ToString());
cmbFinalDest.setValue(dt.Rows[0]["FinalDest"].ToString());
txtETD.Text = dt.Rows[0]["ETD"].ToString();
txtETADischarge.Text = dt.Rows[0]["ETAdischarge"].ToString();
txtETAFinal.Text = dt.Rows[0]["ETAFinal"].ToString();
txtOELot.Text = dt.Rows[0]["OELotNo"].ToString();
txtATD.Text = dt.Rows[0]["ATD"].ToString();
txtATA.Text = dt.Rows[0]["ATA"].ToString();
//if (!string.IsNullOrEmpty(dt.Rows[0]["GWT"].ToString()))
// txtGWT.Text = dt.Rows[0]["GWT"].ToString();
//if (!string.IsNullOrEmpty(dt.Rows[0]["CWT"].ToString()))
// txtCWT.Text = dt.Rows[0]["CWT"].ToString();
//if (!string.IsNullOrEmpty(dt.Rows[0]["CBM"].ToString()))
// txtCBM.Text = dt.Rows[0]["CBM"].ToString();
//if (!string.IsNullOrEmpty(dt.Rows[0]["Piece"].ToString()))
// txtPiece.Text = dt.Rows[0]["Piece"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["GWT"].ToString()))
{
txtGWT.Text = dt.Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["AWT"].ToString()))
{
txtAGWT.Text = dt.Rows[0]["AWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["CBM"].ToString()))
{
txtCBM.Text = dt.Rows[0]["CBM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["ACBM"].ToString()))
{
txtACBM.Text = dt.Rows[0]["ACBM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["PKGS"].ToString()))
{
txtPiece.Text = dt.Rows[0]["PKGS"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["APKGS"].ToString()))
{
txtAPiece.Text = dt.Rows[0]["APKGS"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["WM"].ToString()))
{
txtCWT.Text = dt.Rows[0]["WM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["AWM"].ToString()))
{
txtAWM.Text = dt.Rows[0]["AWM"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Container"].ToString()))
{
txtContainer.Text = dt.Rows[0]["Container"].ToString();
}
CmbUnit.setValue(dt.Rows[0]["Unit"].ToString());
cmbWarehouse.setValue(dt.Rows[0]["WareHouse"].ToString());
cmbWarehouse.Text = dt.Rows[0]["WareHouseName"].ToString();
txtFreeStorageStart.Text = dt.Rows[0]["FreeStorageStart"].ToString();
txtFreeStorageEnd.Text = dt.Rows[0]["FreeStorageEnd"].ToString();
txtPickup.Text = dt.Rows[0]["PickUp"].ToString();
chbDirect.Checked = Convert.ToBoolean(dt.Rows[0]["Direct"]);
hidSeed.Text = dt.Rows[0]["seed"].ToString();
txtM_to.Value = dt.Rows[0]["M_to"].ToString();
txtM_to.Text = dt.Rows[0]["M_toName"].ToString();
txtMAWBRemark.Text = dt.Rows[0]["o_Remark"].ToString();
txtAccRemark.Text = dt.Rows[0]["o_AccountRemark"].ToString();
if (ControlBinder.IsDisplayLotNo(txtETADischarge.Text, hidLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
if (Convert.ToBoolean(dt.Rows[0]["active"]))
{
img_void.Style.Value = "display:none";
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
X.AddScript("$('#showHBL').hide();");
btnUpdateLotNo.Hide();
}
ControlBinder.pageTitleMsg(false, "OI-M:" + labImpLotNo.Text, "<p>Status : Edit MBL of <span>" + dt.Rows[0]["LotNo"] + "</span> </p>", div_bottom);
}
private void DataBindList()
{
CmbUnit.setValue("PKG");
List <IFields> Getlist = new List <IFields>();
Getlist.Add(dal.CreateIFields().Append("Option", "List")
.Append("seed", hidSeed.Text)
.Append("o_ToMBL", Request["MBL"])
.Append("STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("SYS", SYS)
);
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_HBL_SP", Getlist).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
txtHawb.Text = ds.Tables[0].Rows[0]["HBL"].ToString();
CmbService.setValue(ds.Tables[0].Rows[0]["ServiceMode"]);
CmbPPD.SelectedItem.Value = ds.Tables[0].Rows[0]["PPD"].ToString();
CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"]);
labImpLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
txtColoader.Text = ds.Tables[0].Rows[0]["ColoaderHBL"].ToString();
txtReference.Text = ds.Tables[0].Rows[0]["Reference"].ToString();
txtClearance.Text = ds.Tables[0].Rows[0]["Clearance"].ToString();
txtDO.Text = ds.Tables[0].Rows[0]["DO"].ToString();
labMBL.Text = ds.Tables[0].Rows[0]["MBL"].ToString();
CmbReceipt.setValue(ds.Tables[0].Rows[0]["Receipt"]);
CmbFinalDest.setValue(ds.Tables[0].Rows[0]["FinalDest"].ToString());
chkInsurance.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Insurance"]);
chkDG.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["DG"]);
chkSurrender.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Surrender"]);
CmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString());
CmbShipperCode.Text = ds.Tables[0].Rows[0]["ShipperName"].ToString();
CmbConsignee.setValue(ds.Tables[0].Rows[0]["Consignee"].ToString());
CmbConsignee.Text = ds.Tables[0].Rows[0]["ConsigneeName"].ToString();
CmbNotify1.setValue(ds.Tables[0].Rows[0]["Notify1"].ToString());
CmbNotify1.Text = ds.Tables[0].Rows[0]["Notify1Name"].ToString();
CmbNotify2.setValue(ds.Tables[0].Rows[0]["Notify2"].ToString());
CmbNotify2.Text = ds.Tables[0].Rows[0]["Notify2Name"].ToString();
CmbCoLoader.setValue(ds.Tables[0].Rows[0]["Coloader"].ToString());
CmbCoLoader.Text = ds.Tables[0].Rows[0]["ColoaderName"].ToString();
CmbBroker.setValue(ds.Tables[0].Rows[0]["Broker"].ToString());
CmbBroker.Text = ds.Tables[0].Rows[0]["BrokerName"].ToString();
//if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString()))
// txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString();
//if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CWT"].ToString()))
// txtCWT.Text = ds.Tables[0].Rows[0]["CWT"].ToString();
//if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CBM"].ToString()))
// txtCBM.Text = ds.Tables[0].Rows[0]["CBM"].ToString();
//if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Piece"].ToString()))
// txtPiece.Text = ds.Tables[0].Rows[0]["Piece"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["AWT"].ToString()))
{
txtAGWT.Text = ds.Tables[0].Rows[0]["AWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CBM"].ToString()))
{
txtCBM.Text = ds.Tables[0].Rows[0]["CBM"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["ACBM"].ToString()))
{
txtACBM.Text = ds.Tables[0].Rows[0]["ACBM"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["PKGS"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["PKGS"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["APKGS"].ToString()))
{
txtAPiece.Text = ds.Tables[0].Rows[0]["APKGS"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["WM"].ToString()))
{
txtCWT.Text = ds.Tables[0].Rows[0]["WM"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["AWM"].ToString()))
{
txtAWM.Text = ds.Tables[0].Rows[0]["AWM"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["Unit"].ToString());
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Container"].ToString()))
{
txtContainer.Text = ds.Tables[0].Rows[0]["Container"].ToString();
}
CmbWarehouse.setValue(ds.Tables[0].Rows[0]["Warehouse"].ToString());
CmbWarehouse.Text = ds.Tables[0].Rows[0]["WarehouseName"].ToString();
txtFreeStorageStart.Text = ds.Tables[0].Rows[0]["FreeStorageStart"].ToString();
txtFreeStorageEnd.Text = ds.Tables[0].Rows[0]["FreeStorageEnd"].ToString();
txtPickUp.Text = ds.Tables[0].Rows[0]["PickUp"].ToString();
txtRemark.Text = ds.Tables[0].Rows[0]["Remark"].ToString();
GridPanelInvoice.GetStore().DataSource = ds.Tables[1];
GridPanelInvoice.GetStore().DataBind();
GridPanelContainer.GetStore().DataSource = ds.Tables[2];
GridPanelContainer.GetStore().DataBind();
if (ds.Tables[2].Rows.Count > 0)
{
double GWT = 0.000, Pieces = 0, CBM = 0.000, wm = 0.000;
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
GWT += Convert.ToDouble(ds.Tables[2].Rows[i]["GWT"].ToString() == "" ? "0.000" : ds.Tables[2].Rows[i]["GWT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[2].Rows[i]["PKGS"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["PKGS"].ToString());
CBM += Convert.ToDouble(ds.Tables[2].Rows[i]["CBM"].ToString() == "" ? "0.000" : ds.Tables[2].Rows[i]["CBM"].ToString());
wm += Convert.ToDouble(ds.Tables[2].Rows[i]["WM"].ToString() == "" ? "0.000" : ds.Tables[2].Rows[i]["WM"].ToString());
}
if (Pieces.ToString() != "0")
{
txtAPiece.Text = Pieces.ToString();
}
if (GWT.ToString() != "0")
{
txtAGWT.Text = GWT.ToString();
}
if (CBM.ToString() != "0")
{
txtACBM.Text = CBM.ToString();
}
if (wm.ToString() != "0")
{
txtAWM.Text = wm.ToString();
}
}
if (Convert.ToBoolean(ds.Tables[0].Rows[0]["active"]))
{
img_void.Style.Value = "display:none";
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
X.AddScript("$('#showContainer').hide();");
}
GridPanelOther.GetStore().DataSource = ds.Tables[3];
GridPanelOther.GetStore().DataBind();
GridPanelForeign.GetStore().DataSource = ds.Tables[5];
GridPanelForeign.GetStore().DataBind();
GridPanelRoute.GetStore().DataSource = ds.Tables[6];
GridPanelRoute.GetStore().DataBind();
GridPanelContact.GetStore().DataSource = ds.Tables[7];
GridPanelContact.GetStore().DataBind();
}
if (!string.IsNullOrEmpty(Request["seed"]))
{
ControlBinder.pageTitleMsg(false, "OI-H:" + labImpLotNo.Text, "<p>Status : Edit HBL of <span>" + labImpLotNo.Text + "</span>. </p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "OI-H New", "<p>Status : New Blank HBL . </p>", div_bottom);
}
txtHawb.Focus(true);
}
/// <summary>
/// 初始数据
/// </summary>
#region 初始数据 DataBinder() Author：Micro (2011-09-05)
void DataBinder()
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_Triangle_Air_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "GetList").Append("tri_Seed", hidSeed.Text)
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
labLotNo.Text = ds.Tables[0].Rows[0]["tri_LotNo"].ToString();
hidLotNo.Text = ds.Tables[0].Rows[0]["tri_LotNo"].ToString();
txtMAWB.Text = ds.Tables[0].Rows[0]["tri_MBL"].ToString();
txtHAWB.Text = ds.Tables[0].Rows[0]["tri_HBL"].ToString();
txtFlightNo.Text = ds.Tables[0].Rows[0]["tri_Flight"].ToString();
CmbDeparture.setValue(ds.Tables[0].Rows[0]["tri_LocReceived"].ToString());
CmbDest.setValue(ds.Tables[0].Rows[0]["tri_LocFinal"].ToString());
txtDepL.Text = ds.Tables[0].Rows[0]["tri_LocReceivedL"].ToString();
txtDesL.Text = ds.Tables[0].Rows[0]["tri_LocFinalL"].ToString();
txtDepartDate.Text = ds.Tables[0].Rows[0]["tri_ETD"].ToString();
txtArrivalDate.Text = ds.Tables[0].Rows[0]["tri_ETA"].ToString();
txtJob.Text = ds.Tables[0].Rows[0]["tri_EReceipt"].ToString();
CmbSalesman.setValue(ds.Tables[0].Rows[0]["tri_Sales"].ToString());
txtMAWBRemark.Text = ds.Tables[0].Rows[0]["tri_Remark"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["tri_GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_VWT"].ToString()))
{
txtVWT.Text = ds.Tables[0].Rows[0]["tri_VWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_CWT"].ToString()))
{
txtCWT.Text = ds.Tables[0].Rows[0]["tri_CWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["tri_Piece"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["tri_Piece"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["tri_Unit"].ToString());
CmbShipperCode.setValue(ds.Tables[0].Rows[0]["tri_Shipper"].ToString());
CmbShipperCode1.Text = ds.Tables[0].Rows[0]["tri_Shipper"].ToString();
CmbShipperCode_name.Text = ds.Tables[0].Rows[0]["tri_ShipperLine"].ToString();
CmbConsigneeCode.setValue(ds.Tables[0].Rows[0]["tri_Consignee"].ToString());
CmbConsigneeCode1.Text = ds.Tables[0].Rows[0]["tri_Consignee"].ToString();
CmbConsigneeCode_name.Text = ds.Tables[0].Rows[0]["tri_ConsigneeLine"].ToString();
CmbNotify1Code.setValue(ds.Tables[0].Rows[0]["tri_PartyA"].ToString());
CmbNotify1Code1.Text = ds.Tables[0].Rows[0]["tri_PartyA"].ToString();
CmbNotify1Code_name.Text = ds.Tables[0].Rows[0]["tri_PartyALine"].ToString();
CmbNotify2Code.setValue(ds.Tables[0].Rows[0]["tri_PartyB"].ToString());
CmbNotify2Code1.Text = ds.Tables[0].Rows[0]["tri_PartyB"].ToString();
CmbNotify2Code_name.Text = ds.Tables[0].Rows[0]["tri_PartyBLine"].ToString();
CmbCarrierCode.setValue(ds.Tables[0].Rows[0]["tri_Carrier"].ToString());
CmbCarrierCode1.Text = ds.Tables[0].Rows[0]["tri_Carrier"].ToString();
CmbCarrierCode_name.Text = ds.Tables[0].Rows[0]["tri_CarrierLine"].ToString();
CmbCoLoader.setValue(ds.Tables[0].Rows[0]["tri_CoLoader"].ToString());
CmbCoLoader1.Text = ds.Tables[0].Rows[0]["tri_CoLoader"].ToString();
CmbCoLoader_name.Text = ds.Tables[0].Rows[0]["tri_CoLoaderLine"].ToString();
if (ControlBinder.IsDisplayLotNo(txtJob.Text.Trim(), hidLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
if (ds.Tables[0].Rows[0]["Active"].ToString() == "Y")
{
img_void.Style.Value = "display:none";
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
btnUpdateLotNo.Hide();
}
gridInvoice.GetStore().DataSource = ds.Tables[1];
gridInvoice.GetStore().DataBind();
ControlBinder.pageTitleMsg(false, "Air Shipment:" + ds.Tables[0].Rows[0]["tri_LotNo"].ToString(), "<p>Status : Edit Air Shipment of <span>" + ds.Tables[0].Rows[0]["tri_LotNo"].ToString() + "</span></p>", div_bottom);
}
else
{
txtJob.RawText = DateTime.Now.ToString("dd/MM/yyyy");
txtJob.Text = DateTime.Now.ToString("yyyy/MM/dd");
txtDepartDate.RawText = DateTime.Now.ToString("dd/MM/yyyy");
txtDepartDate.Text = DateTime.Now.ToString("yyyy/MM/dd");
txtArrivalDate.RawText = DateTime.Now.ToString("dd/MM/yyyy");
txtArrivalDate.Text = DateTime.Now.ToString("yyyy/MM/dd");
//CmbUnit.setValue("CTN");
ControlBinder.pageTitleMsg(false, "Air Shipment:New", "<p>Status : New Blank Air Shipment </p>", div_bottom);
}
}
private void DataBindList()
{
txtHawb.Focus(true);
List <IFields> Getlist = new List <IFields>();
Getlist.Add(dal.CreateIFields().Append("Option", "GetSubShipment")
.Append("air_Seed", hidSeed.Text == ""?null:hidSeed.Text)
.Append("str", hidIDList.Text)
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("air_SYS", sys)
);
DataSet ds = GetDs("FW_AirExport_SubShipment_SP", Getlist);
if (ds != null && ds.Tables[0].Rows.Count > 0 && hidSeed.Text != "0" && hidSeed.Text != "")
{
string tempmawb = ds.Tables[0].Rows[0]["MAWB"].ToString().ToUpper() == "" ? "" : "MAWB# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["MAWB"].ToString().ToUpper() + "</span>";
string tempLotNo = ds.Tables[0].Rows[0]["LotNo"].ToString().ToUpper() == "" ? "" : "Lot# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["LotNo"].ToString().ToUpper() + "</span>";
labHeader.Html = "Book# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["BookNo"].ToString().ToUpper() + "</span>" + (tempmawb == "" ? "" : "<span style='padding-left:10px'>" + tempmawb + "</span>") + (tempLotNo == "" ? "" : "<span style='padding-left:10px'>" + tempLotNo + "</span>");
hidLotNo.Text = ds.Tables[0].Rows[0]["BookNo"].ToString();
txtHawb.Text = ds.Tables[0].Rows[0]["HAWB"].ToString();
txtReference.Text = ds.Tables[0].Rows[0]["Reference"].ToString();
chkSpecial.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["SpecicalDeal"].ToString() == "N" ? 0 : 1);
CmbReceipt.setValue(ds.Tables[0].Rows[0]["Receipt"].ToString());
CmbFinalDest.setValue(ds.Tables[0].Rows[0]["Destination"].ToString());
CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"].ToString());
txtEst.Text = ds.Tables[0].Rows[0]["EstReceipt"].ToString();
txtAct.Text = ds.Tables[0].Rows[0]["ActReceipt"].ToString();
txtCS.Text = ds.Tables[0].Rows[0]["air_User"].ToString();
CmbNP.SelectedItem.Value = ds.Tables[0].Rows[0]["NP"].ToString();
CmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString());
CmbShipperCode.Text = ds.Tables[0].Rows[0]["ShipperName"].ToString();
CmbConsignee.setValue(ds.Tables[0].Rows[0]["Consignee"].ToString());
CmbConsignee.Text = ds.Tables[0].Rows[0]["ConsigneeName"].ToString();
CmbNotify1.setValue(ds.Tables[0].Rows[0]["Notify1"].ToString());
CmbNotify1.Text = ds.Tables[0].Rows[0]["Notify1Name"].ToString();
CmbNotify2.setValue(ds.Tables[0].Rows[0]["Notify2"].ToString());
CmbNotify2.Text = ds.Tables[0].Rows[0]["Notify2Name"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString()))
{
txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["VWT"].ToString()))
{
txtVWT.Text = ds.Tables[0].Rows[0]["VWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CWT"].ToString()))
{
txtCWT.Text = ds.Tables[0].Rows[0]["CWT"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Piece"].ToString()))
{
txtPiece.Text = ds.Tables[0].Rows[0]["Piece"].ToString();
}
CmbUnit.setValue(ds.Tables[0].Rows[0]["Unit"].ToString());
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Pallet"].ToString()))
{
txtPallet.Text = ds.Tables[0].Rows[0]["Pallet"].ToString();
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CBF"].ToString()))
{
txtCbf.Text = ds.Tables[0].Rows[0]["CBF"].ToString();
}
bool ismakehawb = ds.Tables[0].Rows[0]["air_MakeHAWB"].ToString() == "" ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["air_MakeHAWB"]);
if (ismakehawb == true)
{
txtGWT.Disabled = true;
txtVWT.Disabled = true;
txtCWT.Disabled = true;
txtPiece.Disabled = true;
}
else
{
txtGWT.Disabled = false;
txtVWT.Disabled = false;
txtCWT.Disabled = false;
txtPiece.Disabled = false;
}
if (ds.Tables[0].Rows[0]["Active"].ToString() == "Y")
{
img_void.Style.Value = "display:none";
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnPull.Disabled = true;
btnNew.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
}
if (ds.Tables[1].Rows.Count > 0)
{
gpHAWB.GetStore().DataSource = ds.Tables[1];
gpHAWB.GetStore().DataBind();
double GWT = 0, VWT = 0, CWT = 0, Pieces = 0, Pallets = 0;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["GWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["GWT"].ToString());
VWT += Convert.ToDouble(ds.Tables[1].Rows[i]["VWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["VWT"].ToString());
CWT += Convert.ToDouble(ds.Tables[1].Rows[i]["CWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["CWT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["Piece"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Piece"].ToString());
Pallets += Convert.ToDouble(ds.Tables[1].Rows[i]["Pallet"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Pallet"].ToString());
}
lblGWT.Text = GWT.ToString("0.000");
lblVWT.Text = VWT.ToString("0.000");
lblCWT.Text = CWT.ToString("0.000");
lblPiece.Text = Pieces.ToString();
lblPallet.Text = Pallets.ToString();
}
gpInvoice.GetStore().DataSource = ds.Tables[3];
gpInvoice.GetStore().DataBind();
ControlBinder.pageTitleMsg(false, "AE-H:" + hidLotNo.Text, "<p>Status : Edit HAWB of <span>" + hidLotNo.Text + "</span></p>", div_bottom);
}
else
{
if (ds.Tables[1].Rows.Count > 0)
{
gpHAWB.GetStore().DataSource = ds.Tables[1];
gpHAWB.GetStore().DataBind();
double GWT = 0, VWT = 0, CWT = 0, Pieces = 0, Pallets = 0;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["GWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["GWT"].ToString());
VWT += Convert.ToDouble(ds.Tables[1].Rows[i]["VWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["VWT"].ToString());
CWT += Convert.ToDouble(ds.Tables[1].Rows[i]["CWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["CWT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["Piece"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Piece"].ToString());
Pallets += Convert.ToDouble(ds.Tables[1].Rows[i]["Pallet"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Pallet"].ToString());
}
lblGWT.Text = GWT.ToString("0.000");
lblVWT.Text = VWT.ToString("0.000");
lblCWT.Text = CWT.ToString("0.000");
lblPiece.Text = Pieces.ToString();
lblPallet.Text = Pallets.ToString();
txtGWT.Text = lblGWT.Text;
txtVWT.Text = lblVWT.Text;
txtCWT.Text = lblCWT.Text;
txtPiece.Text = lblPiece.Text;
txtPallet.Text = lblPallet.Text;
}
ControlBinder.pageTitleMsg(false, "AE-H New", "<p>Status : New Blank HAWB </p>", div_bottom);
}
}
/// <summary>
/// 初始数据
/// </summary>
#region 初始数据 DataBinder() Author：Micro (2011-09-05)
void DataBinder()
{
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Joblist_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "MAWBByID").Append("air_ROWID", hidRowID.Text)
}).GetTable();
if (dt != null && dt.Rows.Count > 0)
{
//hidRowID.Text = dt.Rows[0]["RowID"].ToString();
labLotNo.Text = dt.Rows[0]["LotNo"].ToString();
hidLotNo.Text = dt.Rows[0]["LotNo"].ToString();
labAeLotNo.Text = dt.Rows[0]["AeLotNo"].ToString();
txtMawb.Text = dt.Rows[0]["MAWB"].ToString();
txtReference.Text = dt.Rows[0]["Reference"].ToString();
txtClearence.Text = dt.Rows[0]["Clearance"].ToString();
CmbCarrierCode.setValue(dt.Rows[0]["Coloader"].ToString());
CmbCarrierCode.Text = dt.Rows[0]["ColoaderName"].ToString();
CmbShipperCode.setValue(dt.Rows[0]["Shipper"].ToString());
CmbShipperCode.Text = dt.Rows[0]["ShipperName"].ToString();
CmbConsigneeCode.setValue(dt.Rows[0]["Consignee"].ToString());
CmbConsigneeCode.Text = dt.Rows[0]["ConsigneeName"].ToString();
CmbNotify1Code.setValue(dt.Rows[0]["Notify1"].ToString());
CmbNotify1Code.Text = dt.Rows[0]["Notify1Name"].ToString();
CmbNotify2Code.setValue(dt.Rows[0]["Notify2"].ToString());
CmbNotify2Code.Text = dt.Rows[0]["Notify2Name"].ToString();
CmbDischargeCode.setValue(dt.Rows[0]["Discharge"].ToString());
CmbDischargeCode.Text = dt.Rows[0]["DischargeName"].ToString();
chbDirect.Checked = Convert.ToBoolean(dt.Rows[0]["Direct"].ToString());
CmbSalesman.setValue(dt.Rows[0]["Salesman"].ToString());
if (Convert.ToBoolean(dt.Rows[0]["Direct"].ToString()))
{
//td_sales1.Style.Value = "visibility:visible; width:210px;";
td_sales2.Style.Value = "visibility:visible;width:70px;padding-left:0px;";
X.AddScript("HawbShow(true);");
}
else
{
//td_sales1.Style.Value = "visibility:hidden;width:210px;";
td_sales2.Style.Value = "visibility:hidden;width:70px;padding-left:0px;";
X.AddScript("HawbShow(false);");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["GWT"].ToString()))
{
txtGWT.Text = dt.Rows[0]["GWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["VWT"].ToString()))
{
txtVWT.Text = dt.Rows[0]["VWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["CWT"].ToString()))
{
txtCWT.Text = dt.Rows[0]["CWT"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Piece"].ToString()))
{
txtPiece.Text = dt.Rows[0]["Piece"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Pallet"].ToString()))
{
txtPallet.Text = dt.Rows[0]["Pallet"].ToString();
}
CmbUnit.setValue(dt.Rows[0]["Unit"].ToString());
//CmbUnit.Text=dt.Rows[0]["Unit"].ToString();
txtRemark.Text = dt.Rows[0]["Remark"].ToString();
txtATA.Text = dt.Rows[0]["ATA"].ToString();
txtATD.Text = dt.Rows[0]["ATD"].ToString();
txtETA.Text = dt.Rows[0]["ETA"].ToString();
txtETD.Text = dt.Rows[0]["ETD"].ToString();
CmbCarrierRight.setValue(dt.Rows[0]["Carrier"].ToString());
txtFlightRight.Text = dt.Rows[0]["FlightNo"].ToString();
CmbFromRight.setValue(dt.Rows[0]["From"].ToString());
CmbToRight.setValue(dt.Rows[0]["To"].ToString());
//CmbFromRight.Text=dt.Rows[0]["From"].ToString();
//CmbToRight.Text=dt.Rows[0]["To"].ToString();
if (ControlBinder.IsDisplayLotNo(txtETA.Text, labLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
txtVoid.Text = Convert.ToBoolean(dt.Rows[0]["Action"]) ? "1" : "0";
if (txtVoid.Text == "0")
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
X.AddScript("$('#showHBL').hide();");
btnUpdateLotNo.Hide();
}
else
{
img_void.Style.Value = "display:none";
}
ControlBinder.pageTitleMsg(false, "AI-M:" + dt.Rows[0]["LotNo"].ToString(), "<p>Status : Edit MAWB of <span>" + dt.Rows[0]["LotNo"].ToString() + "</span></p>", div_bottom);
}
else
{
//td_sales1.Style.Value = "visibility:hidden;width:210px;";
td_sales2.Style.Value = "visibility:hidden;width:70px;padding-left:0px;";
X.AddScript("HawbShow(false);");
ControlBinder.pageTitleMsg(false, "AI-M:New", "<p>Status : New Blank MAWB </p>", div_bottom);
}
}
