public void BindVoyag(string id)
{
if (id != "")
{
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();
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageByID").
Append("STAT", id)
}).GetTable();
cmbVesselText.SelectedItem.Value = id;
CmbDeparture.setValue(dt.Rows[0][4].ToString());
CmbDest.setValue(dt.Rows[0][5].ToString());
txtDepartDate.Text = dt.Rows[0][2].ToString();
txtArrivalDate.Text = dt.Rows[0][3].ToString();
X.AddScript("$('#txtDepL').val(StoreLocation.getById($('#CmbDeparture').val()).data.text);$('#txtDesL').val(StoreLocation.getById($('#CmbDest').val()).data.text);");
}
}
void ComList()
{
StoreVoyage.RemoveAll();
DataTable dt = 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 = dt;
StoreVoyage.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
cmbVesselText.SelectedItem.Value = dt.Rows[0][1].ToString();
CmbDeparture.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][4].ToString()));
CmbDest.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][5].ToString()));
txtDepartDate.Text = dt.Rows[0][2].ToString();
txtArrivalDate.Text = dt.Rows[0][3].ToString();
X.AddScript("$('#txtDepL').val(StoreLocation.getById($('#CmbDeparture').val()).data.text);$('#txtDesL').val(StoreLocation.getById($('#CmbDest').val()).data.text);");
}
else
{
CmbDeparture.setValue("");
CmbDest.setValue("");
txtArrivalDate.Text = "";
txtDepartDate.Text = "";
txtDepL.Text = "";
txtDesL.Text = "";
}
}
protected void cmbVesselText_Select(object sender, DirectEventArgs e)
{
if (cmbVesselText.SelectedItem.Value != "")
{
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "VoyageByID").
Append("STAT", cmbVesselText.SelectedItem.Value)
}).GetTable();
if (dt != null && dt.Rows.Count > 0)
{
CmbDeparture.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][4].ToString()));
CmbDest.setValue(BaseCheckCode.locationCheckCode(dt.Rows[0][5].ToString()));
txtDepartDate.Text = dt.Rows[0][2].ToString();
txtArrivalDate.Text = dt.Rows[0][3].ToString();
X.AddScript("$('#txtDepL').val(StoreLocation.getById($('#CmbDeparture').val()).data.text);$('#txtDesL').val(StoreLocation.getById($('#CmbDest').val()).data.text);");
}
}
}
/// <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);
}
}
/// <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);
}
}
