public void btnRevert_Click()
{
string lotno = hidLotNo.Text;
if (lotno != "")
{
DataSet result = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_DirectMAWB_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "Revert").Append("air_Seed", hidSeed.Text)
.Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
}).GetList();
if (result != null && result.Tables[0].Rows.Count > 0)
{
string type = "";
if (result.Tables[0].Rows[0][0].ToString() == "s")
{
Response.Redirect("../AEShipAndColIn/List.aspx?type=s&seed=" + result.Tables[0].Rows[0][1]);
}
else
{
Response.Redirect("../AEShipAndColIn/List.aspx?type=c&seed=" + result.Tables[0].Rows[0][1]);
}
}
else
{
ControlBinder.pageTitleMsg(false, showname + hidLotNo.Text, "<p class=\"error\">Status : Deleted failed, please check the data . </p>", div_bottom);
}
}
}
/// <summary>
/// 新增
/// </summary>
protected void btnAddNew_Click(object sender, EventArgs e)
{
txtVoyageID.Text = "";
ControlInit();
txtVoyage.Focus();
ControlBinder.pageTitleMsg(false, "New Voyage", "<p>Status : New Blank Voyage . </p>", div_bottom);
}
public void btnVoid_Click()
{
string seedid = hidSeed.Text;
hidDelByRowId.Text = "";
//if (!VoidCheckAC.CheckisAC("DO", hidSeed.Text))
//{
// X.MessageBox.Alert("Status", VoidCheckAC.Message).Show();
// return;
//}
if (seedid.Length > 1)
{
string voidflag = hidVoid.Text == "0" ? "Y" : "N";
DataSet l = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallVoid_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "D").Append("VoidFlag", voidflag)
.Append("seed", hidSeed.Text == "" ? null:hidSeed.Text)
}).GetList();
if (l == null)
{
ControlBinder.pageTitleMsg(false, "DO:" + labDO.Text, "<p class=\"error\"> Status : Void failed , please check the data . </p>", div_bottom);
}
DataBinder();
ControlBinder.pageTitleMsg(true, "DO:" + labDO.Text, "<p>Status : Edit DO of <span>" + labDO.Text + "</span></p>", div_bottom);
}
}
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);
}
}
public void btnVoid_Click()
{
string seedid = hidSeed.Text;
if (!VoidCheckAC.CheckisAC("OI", hidSeed.Text))
{
X.MessageBox.Alert("Status", VoidCheckAC.Message).Show();
return;
}
if (seedid.Length > 1)
{
string voidflag = hidVoid.Text == "0" ? "Y" : "N";
DataSet l = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallVoid_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "O").Append("Type", "HBL").Append("VoidFlag", voidflag)
.Append("seed", hidSeed.Text == ""?null:hidSeed.Text)
}).GetList();
if (l != null && l.Tables[0].Rows[0][0].ToString() == "Y")
{
X.AddScript("$('#img_void').css('display','inline');");
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
X.AddScript("$('#showContainer').hide();");
}
else if (l != null && l.Tables[0].Rows[0][0].ToString() == "N")
{
X.AddScript("$('#img_void').css('display','none');");
btnSave.Disabled = false;
btnCancel.Disabled = false;
btnNext.Disabled = false;
btnVoid.Text = "Void";
hidVoid.Text = "0";
X.AddScript("$('#showContainer').show();");
}
else if (l != null && l.Tables[0].Rows[0][0].ToString() == "S")
{
X.Msg.Alert("Information", "HBL can't be active,because MBL is void.").Show();
}
else
{
ControlBinder.pageTitleMsg(false, "OI-H:" + labImpLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data . </p>", div_bottom);
}
DataBindList();
ControlBinder.pageTitleMsg(true, "OI-H:" + labImpLotNo.Text, "<p>Status : Edit HBL of <span>" + labImpLotNo.Text + "</span>. </p>", div_bottom);
}
}
/// <summary>
/// 复制
/// </summary>
protected void btnCopy_Click(object sender, EventArgs e)
{
ControlInit();
txtVoyageID.Text = "";
txtVoyage.Text = "";
txtETD.Text = "";
txtETA.Text = "";
txtOnboard.Text = "";
txtCFS.Text = "";
txtCY.Text = "";
txtVoyage.Focus(true);
ControlBinder.pageTitleMsg(false, "New Voyage", "<p>Status : New Blank Voyage . </p>", div_bottom);
}
/// <summary>
/// 数据绑定
/// </summary>
#region ///Grid 数据绑定 Author：Micro (2011-09-27)
void DataBinder()
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_MBLList_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Single")
.Append("o_Seed", hidSeed.Text == "0"?(object)DBNull.Value:(object)hidSeed.Text)
}).GetList();
if (ds != null)
{
DataBinder(ds.Tables[0]);
storeHBL.DataSource = ds.Tables[1];
storeHBL.DataBind();
if (ds.Tables[1].Rows.Count > 0)
{
double GWT = 0.000, Pieces = 0, CBM = 0.000, wm = 0.000;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["CWT"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["CWT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["PKGS"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["PKGS"].ToString());
CBM += Convert.ToDouble(ds.Tables[1].Rows[i]["CBM"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["CBM"].ToString());
wm += Convert.ToDouble(ds.Tables[1].Rows[i]["WM"].ToString() == "" ? "0.000" : ds.Tables[1].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();
}
}
StoreInvoice.DataSource = ds.Tables[2];
StoreInvoice.DataBind();
}
else
{
ControlBinder.pageTitleMsg(false, "OI-M New", "<p>Status : New Blank MBL </p>", div_bottom);
}
}
public void btnVoid_Click()
{
string seedid = hidSeed.Text;
if (!VoidCheckAC.CheckisAC("AI", hidSeed.Text))
{
X.MessageBox.Alert("Status", VoidCheckAC.Message).Show();
return;
}
if (seedid.Length > 1)
{
string voidflag = hidVoid.Text == "0" ? "Y" : "N";
DataSet l = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallVoid_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "A").Append("Type", "MAWB").Append("VoidFlag", voidflag)
.Append("seed", hidSeed.Text == ""?null:hidSeed.Text)
}).GetList();
if (l != null && l.Tables[0].Rows[0][0].ToString() == "Y")
{
X.AddScript("$('#img_void').css('display','inline');");
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnNext.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
X.AddScript("$('#showHBL').hide();");
btnUpdateLotNo.Hide();
}
else if (l != null && l.Tables[0].Rows[0][0].ToString() == "N")
{
X.AddScript("$('#img_void').css('display','none');");
btnSave.Disabled = false;
btnCancel.Disabled = false;
btnNext.Disabled = false;
btnVoid.Text = "Void";
hidVoid.Text = "0";
X.AddScript("$('#showHBL').show();");
}
else
{
ControlBinder.pageTitleMsg(false, "AI-M:" + labLotNo.Text, "<p class=\"error\"> Status : Saving failed ! ! ! </p>", div_bottom);
}
DataBinder();
StoreInvoice.DataSource = GetList("FW_AirImport_Invoice_SP", "List", "inv_Seed", hidSeed.Text);
StoreInvoice.DataBind();
ControlBinder.pageTitleMsg(true, "AI-M:" + labLotNo.Text, "<p>Status : Edit MAWB of <span>" + labLotNo.Text + "</span></p>", div_bottom);
}
}
public void btnVoid_Click()
{
string seedid = hidSeed.Text;
if (!VoidCheckAC.CheckisAC("AE", hidSeed.Text))
{
X.MessageBox.Alert("Status", VoidCheckAC.Message).Show();
return;
}
if (seedid.Length > 1)
{
string voidflag = hidVoid.Text == "0" ? "Y1" : "N1";
DataSet l = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallVoid_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "A").Append("Type", "MAWB").Append("VoidFlag", voidflag)
.Append("seed", hidSeed.Text == ""?null:hidSeed.Text)
}).GetList();
if (l != null && l.Tables[0].Rows[0][0].ToString() == "Y")
{
X.AddScript("$('#img_void').css('display','inline');");
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnRevert.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
X.AddScript("$('#showGenerate').hide();");
btnUpdateLotNo.Hide();
}
else if (l != null && l.Tables[0].Rows[0][0].ToString() == "N")
{
X.AddScript("$('#img_void').css('display','none');");
btnSave.Disabled = false;
btnCancel.Disabled = false;
btnRevert.Disabled = false;
X.AddScript("$('#showGenerate').show();");
btnVoid.Text = "Void";
hidVoid.Text = "0";
}
else
{
ControlBinder.pageTitleMsg(false, showname + hidLotNo.Text, "<p class=\"error\">Status : Void failed, please check the data . </p>", div_bottom);
}
DataBindList();
ControlBinder.pageTitleMsg(true, showname + ":" + hidLotNo.Text, "<p>Status : Edit No. of <span>" + hidLotNo.Text + "</span></p>", div_bottom);
}
}
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);
}
}
public void btnDelete_Click()
{
DataFactory dal = new DataFactory();
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_Container_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "Delete")
.Append("oc_ROWID", hidID.Text).Append("oc_User", FSecurityHelper.CurrentUserDataGET()[0])
}).GetTable();
if (dt != null && dt.Rows.Count > 0)
{ //X.Msg.Alert("status", " Delete successfully").Show();
ControlBinder.pageTitleMsg(true, "OI-C:" + txtContainer.Text, "<p class=\"success\">Status : Delete successfully . </p>", div_bottom);
X.Redirect("OceanShipmentHouse.aspx?MBL=" + dt.Rows[0]["HBL"] + "&seed=" + dt.Rows[0]["MBL"]);
}
else
{
ControlBinder.pageTitleMsg(false, "OI-C:" + txtContainer.Text, "<p class=\"error\">Status : Save failed, please check the data . </p>", div_bottom);
}
}
public void btnUpdateLotNo_Click()
{
object etd = ControlBinder.getDate(string.IsNullOrEmpty(txtJob.RawText.Trim()) ? DBNull.Value : (object)txtJob.RawText.Trim());
string lotNo = ControlBinder.GetNewLotNo("BK", hidSeed.Text, etd);
if (lotNo == "-1")
{
X.MessageBox.Alert("Status", "The cost of this LOT is transfered to AC, LOT NUMBER updating is aborted!").Show();
ControlBinder.pageTitleMsg(true, "Brokerage Shipment:" + hidLotNo.Text, "<p class=\"success\">Status : Saved failed ! ! ! </p>", div_bottom);
}
else if (lotNo != "0")
{
labLotNo.Text = lotNo;
hidLotNo.Text = lotNo;
ControlBinder.pageTitleMsg(true, "Brokerage Shipment:" + hidLotNo.Text, "<p class=\"success\">Status : Saved successfully ! ! ! </p>", div_bottom);
btnUpdateLotNo.Hide();
}
}
public void btnUpdateLotNo_Click()
{
object eta = ControlBinder.getDate(string.IsNullOrEmpty(txtETADischarge.RawText.Trim()) ? DBNull.Value : (object)txtETADischarge.RawText);
string lotNo = ControlBinder.GetNewLotNo("OI", hidSeed.Text, eta);
if (lotNo == "-1")
{
X.MessageBox.Alert("Status", "The cost of this LOT is transfered to AC, LOT NUMBER updating is aborted!").Show();
ControlBinder.pageTitleMsg(true, "OI-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Saved failed ! ! ! </p>", div_bottom);
}
else
{
labImpLotNo.Text = lotNo;
hidLotNo.Text = lotNo;
ControlBinder.pageTitleMsg(true, "OI-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Record Saved with <span>" + labImpLotNo.Text + " </span> </p>", div_bottom);
btnUpdateLotNo.Hide();
}
}
void DataBinder()
{
DataFactory dal = new DataFactory();
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_ComplexCost_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "GetDetailList")
.Append("cxh_ROWID", Request["CostingID"])
.Append("cxd_Seed", Request["CostingDetailSeed"])
}).GetList();
if (ds != null && ds.Tables.Count > 0)
{
if (Request["CostingID"] != "0" && Request["CostingID"] != null)
{
hidID.Text = ds.Tables[0].Rows[0]["cxh_ROWID"].ToString();
hidHeadSeed.Text = ds.Tables[0].Rows[0]["cxh_Seed"].ToString();
cmbShipperCode.setValue(ds.Tables[0].Rows[0]["cxh_Company"].ToString());
cmbShipperCode.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();
txtDate.Text = ds.Tables[0].Rows[0]["cxh_Date"].ToString();
txtInv.Text = ds.Tables[0].Rows[0]["cxh_InvoiceNo"].ToString();
txtAmount.Text = ds.Tables[0].Rows[0]["cxh_Amount"].ToString();
}
}
storeList.DataSource = ds.Tables[1];
storeList.DataBind();
if (hidID.Text != "0")
{
ControlBinder.pageTitleMsg(false, "Combine Cost:Edit", "<p>Status : Edit Combine Cost </p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "Combine Cost:New", "<p>Status : New Combine Cost </p>", div_bottom);
}
X.AddScript("getSelectPos('cmbShipperCode');");
}
/// <summary>
/// 初始化控件绑定
/// </summary>
void ControlInit()
{
int voyageID = -1;
try
{
voyageID = Convert.ToInt32(txtVoyageID.Text);
}
catch
{
txtVoyageID.Text = voyageID.ToString();
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_Voyage_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "Single").
Append("voy_ROWID", voyageID.ToString())
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
txtVoyageID.Text = ds.Tables[0].Rows[0]["voy_ROWID"].ToString();
txtVoyage.Text = ds.Tables[0].Rows[0]["voy_Voyage"].ToString();
cmbPOL.setValue(ds.Tables[0].Rows[0]["voy_POL"].ToString());
cmbPOD.setValue(ds.Tables[0].Rows[0]["voy_POD"].ToString());
txtETD.Text = ds.Tables[0].Rows[0]["voy_ETD"].ToString();
txtETA.Text = ds.Tables[0].Rows[0]["voy_ETA"].ToString();
txtOnboard.Text = ds.Tables[0].Rows[0]["voy_Onboard"].ToString();
txtCFS.Text = ds.Tables[0].Rows[0]["voy_CFS"].ToString();
txtCY.Text = ds.Tables[0].Rows[0]["voy_CY"].ToString();
chcActive.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["voy_Active"]);
storeVoyageRoute.DataSource = ds.Tables[1];
storeVoyageRoute.DataBind();
ControlBinder.pageTitleMsg(false, "Edit Voyage", "<p>Status : Edit Voyage . </p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "New Voyage", "<p>Status : New Blank Voyage . </p>", div_bottom);
}
}
public void btnDelete_Click()
{
if (hidID.Text != "-1")
{
DataFactory dal = new DataFactory();
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanExport_Container_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "Delete")
.Append("oc_ROWID", hidID.Text).Append("oc_User", FSecurityHelper.CurrentUserDataGET()[0])
}).Update();
if (b)
{
ControlBinder.pageTitleMsg(true, "OE-C:" + txtContainer.Text.ToUpper(), "<p class=\"success\">Status : Delete successfully . </p>", div_bottom);
X.AddScript("window.opener=null;window.open('','_self');window.close();");
}
else
{
ControlBinder.pageTitleMsg(false, "OE-C:" + txtContainer.Text.ToUpper(), "<p class=\"error\">Status : Delete failed, please check the data . </p>", div_bottom);
}
}
}
void DataBinder()
{
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_DeliveryOrder_Control_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "List")
.Append("Seed", hidSeed.Text == "0"?(object)DBNull.Value:(object)hidSeed.Text)
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataBinder(ds.Tables[0]);
storeList.DataSource = ds.Tables[1];
storeList.DataBind();
ControlBinder.pageTitleMsg(true, "DO:" + labDO.Text, "<p>Status : Edit DO of <span>" + labDO.Text + "</span></p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "DO:New", "<p>Status : New Blank DO </p>", div_bottom);
}
}
public void btnUpdateLotNo_Click()
{
object etd = ControlBinder.getDate(string.IsNullOrEmpty(txtETD.RawText.Trim()) ? DBNull.Value : (object)txtETD.RawText.Trim());
string lotNo = ControlBinder.GetNewLotNo("OE", hidSeed.Text, etd);
if (lotNo == "-1")
{
X.MessageBox.Alert("Status", "The cost of this LOT is transfered to AC, LOT NUMBER updating is aborted!").Show();
ControlBinder.pageTitleMsg(true, "OE-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Saved failed ! ! ! </p>", div_bottom);
}
else if (lotNo != "0")
{
labImpLotNo.Text = lotNo;
string tempmawb = txtMBL.Text.Trim() == "" ? "" : "MBL# " + "<span style='color:#ff0000;'>" + txtMBL.Text.Trim().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>");
ControlBinder.pageTitleMsg(true, "OE-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Saved successfully ! ! ! </p>", div_bottom);
btnUpdateLotNo.Hide();
}
}
protected void btnSave_Click(object sender, DirectEventArgs e)
{
if (string.IsNullOrEmpty(CmbShipperCode.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Shipper can't be empty!</p>";
CmbShipperCode.Focus();
return;
}
if (string.IsNullOrEmpty(CmbConsignee.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Consignee can't be empty!</p>";
CmbConsignee.Focus();
return;
}
if (GridFlightList.Store.Count == 0)
{
div_bottom.Html = "<p class='error'> Save failed, Flight Routing is no data!</p>";
l_flightno.Focus();
return;
}
List <IFields> UpdateHAWB = new List <IFields>();
UpdateHAWB.Add(dal.CreateIFields().Append("Option", "Update")
.Append("air_Seed", hidSeed.Text == "" ? null : hidSeed.Text)
.Append("air_MAWB", txtMAWB.Text.Trim().Replace(" ", "").ToUpper())
//.Append("air_LocReceived",CmbDeparture.Value)
//.Append("air_LocFinal", CmbFinalDest.Value)
.Append("air_Sales", CmbSalesman.Value)
.Append("air_Shipper", CmbShipperCode.Value)
//.Append("air_Shipper", CmbShipperName.SelectedItem.Value)
.Append("air_Consignee", CmbConsignee.Value)
//.Append("air_Consignee", CmbConsigneeName.SelectedItem.Value)
.Append("air_CoLoader", CmbColoader.Value)
.Append("air_Carrier", CmbCarrierRight.Value)
.Append("air_Flight", txtFlightRight.Text.ToUpper())
.Append("air_LocLoad", CmbFromRight.Value)
.Append("air_LocDischarge", CmbToRight.Value)
.Append("air_ETD", ControlBinder.getDate(txtETD.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtETD.RawText.Trim()))
.Append("air_ETA", ControlBinder.getDate(txtETA.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtETA.RawText.Trim()))
.Append("air_ATD", ControlBinder.getDate(txtATD.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtATD.RawText.Trim()))
.Append("air_ATA", ControlBinder.getDate(txtATA.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtATA.RawText.Trim()))
.Append("air_GWT", string.IsNullOrEmpty(txtGWT.Text) ? DBNull.Value : (object)txtGWT.Text)
.Append("air_VWT", string.IsNullOrEmpty(txtVWT.Text) ? DBNull.Value : (object)txtVWT.Text)
.Append("air_CWT", string.IsNullOrEmpty(txtCWT.Text) ? DBNull.Value : (object)txtCWT.Text)
.Append("air_Piece", string.IsNullOrEmpty(txtPiece.Text) ? DBNull.Value : (object)txtPiece.Text)
.Append("air_Pallet", string.IsNullOrEmpty(txtPallet.Text) ? DBNull.Value : (object)txtPallet.Text)
.Append("air_Rate", string.IsNullOrEmpty(txtRate.Text) ? DBNull.Value : (object)txtRate.Text)
.Append("code", FSecurityHelper.CurrentUserDataGET()[4].ToString() + sys)
.Append("code1", FSecurityHelper.CurrentUserDataGET()[4].ToString() + sys + "SN")
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("air_SYS", sys)
.Append("type", typename)
.Append("air_Remark", string.IsNullOrEmpty(txtRemark.Text) ? "" : txtRemark.Text.Trim().ToUpper())
.Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
try
{
DataSet ds = GetDs("FW_AirExport_ViewConsol_SP", UpdateHAWB);
hidSeed.Text = ds.Tables[0].Rows[0][0].ToString();
string newFlag = ds.Tables[0].Rows[0][1].ToString();
hidLotNo.Text = ds.Tables[0].Rows[0][2].ToString();
#region FlightRouting
var ShipmentRoute = JSON.Deserialize <List <ShipmentRoute> >(e.ExtraParams["p_safety_l"]);
List <IFields> Routelist = new List <IFields>();
string RouteID = "";
for (int i = 0; i < ShipmentRoute.Count; ++i)
{
Routelist.Add(dal.CreateIFields().Append("Option", "Update").
Append("sr_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString()).
Append("sr_ToMaster", hidSeed.Text).
Append("sr_ShipKind", "FREIGHT").
Append("sr_Carrier", ShipmentRoute[i].Carrier).
Append("sr_OrderID", i).
Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).
Append("sr_Flight", ShipmentRoute[i].FlightNo.ToUpper()).
Append("sr_From", ShipmentRoute[i].From).
Append("sr_To", ShipmentRoute[i].To).
Append("sr_ETD", ControlBinder.getDate(ShipmentRoute[i].ETD.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ETD)).
Append("sr_ETA", ControlBinder.getDate(ShipmentRoute[i].ETA.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ETA)).
Append("sr_ATD", ControlBinder.getDate(ShipmentRoute[i].ATD.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ATD)).
Append("sr_ATA", ControlBinder.getDate(ShipmentRoute[i].ATA.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ATA)).
Append("sr_ROWID", ShipmentRoute[i].RowID));
RouteID += "," + ShipmentRoute[i].RowID;
}
if (RouteID.Length > 1)
{
RouteID = RouteID.Substring(1, RouteID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentRoute_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "Delete").Append("sr_ToMaster", hidSeed.Text).Append("str", RouteID)
}).Update();
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentRoute_SP", Routelist).Update();
#endregion
#region HAWBList
var HAWBList = JSON.Deserialize <List <HAWBList> >(e.ExtraParams["p_safety_2"]);
List <IFields> HAWBLists = new List <IFields>();
string RowID = "";
for (int i = 0; i < HAWBList.Count; ++i)
{
// HAWBLists.Add(dal.CreateIFields().Append("Option", "UpdateEmptyHAWB").
// Append("air_ROWID", HAWBList[i].RowID)
// .Append("air_ToMAWB", hidSeed.Text));
RowID += HAWBList[i].RowID.ToString() + ",";
}
bool result = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ViewConsol_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "AddMakeConsolByIDList").Append("air_LotNo", hidLotNo.Text)
.Append("str", RowID).Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).Append("air_ToMAWB", hidSeed.Text).Append("air_MAWB", txtMAWB.Text.Trim().Replace(" ", "").ToUpper())
}).Update();
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ViewConsol_SP", HAWBLists).Update();
#endregion
#region LocalInvoice
//var InvocieList = JSON.Deserialize<List<Invocie>>(e.ExtraParams["p_safety_3"]);
//string InvoiceID = "";
//for (int i = 0; i < InvocieList.Count; ++i)
//{
// InvoiceID += "," + InvocieList[i].RowID;
//}
//if (InvoiceID.Length > 1)
//{
// InvoiceID = InvoiceID.Substring(1, InvoiceID.Length - 1);
//}
//bool inv = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ViewConsol_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteInvoice")
//.Append("air_ToMAWB",hidSeed.Text)
//.Append("str",InvoiceID)}).Update();
#endregion
#region Costing
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
#endregion
//update cost(Qty,unit,total)
//ControlBinder.UpdateCostData(hidSeed.Text, "AE", "MAWB");
if (newFlag == "N")
{
DataBindList();
X.AddScript("if(window.opener!=null){if(typeof(window.opener.RefreshList)!='undefined'){window.opener.RefreshList();}}");
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p class=\"success\">Status : Save successfully ! </p>", div_bottom);
}
else
{
X.AddScript("if(window.opener!=null){if(typeof(window.opener.RefreshList)!='undefined'){window.opener.RefreshList();}}");
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p class=\"success\">Status : Save successfully ! </p>", div_bottom);
X.Redirect("List.aspx?type=" + typename + "&seed=" + ds.Tables[0].Rows[0][0]);
}
}
catch
{
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data !</p>", div_bottom);
}
}
private void DataBindList()
{
txtMAWB.Focus(true);
List <IFields> Getlist = new List <IFields>();
Getlist.Add(dal.CreateIFields().Append("Option", "GetAEMakeConsol")
.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_ViewConsol_SP", Getlist);
if (ds != null && ds.Tables[0].Rows.Count > 0 && hidSeed.Text != null && hidSeed.Text != "")
{
labLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
hidLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
txtMAWB.Text = ds.Tables[0].Rows[0]["MAWB"].ToString();
//CmbDeparture.setValue(ds.Tables[0].Rows[0]["Departure"].ToString());
//CmbFinalDest.setValue(ds.Tables[0].Rows[0]["Destination"].ToString());
CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"].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();
CmbColoader.setValue(ds.Tables[0].Rows[0]["CoLoader"].ToString());
CmbColoader.Text = ds.Tables[0].Rows[0]["CoLoaderName"].ToString();
CmbCarrierRight.setValue(ds.Tables[0].Rows[0]["Carrier"].ToString());
txtFlightRight.Text = ds.Tables[0].Rows[0]["FlightNo"].ToString();
CmbFromRight.setValue(ds.Tables[0].Rows[0]["From"].ToString());
CmbToRight.setValue(ds.Tables[0].Rows[0]["To"].ToString());
txtETD.Text = ds.Tables[0].Rows[0]["ETD"].ToString();
txtETA.Text = ds.Tables[0].Rows[0]["ETA"].ToString();
txtATD.Text = ds.Tables[0].Rows[0]["ATD"].ToString();
txtATA.Text = ds.Tables[0].Rows[0]["ATA"].ToString();
txtRemark.Text = ds.Tables[0].Rows[0]["Remark"].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();
}
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]["Rate"].ToString()))
{
txtRate.Text = ds.Tables[0].Rows[0]["Rate"].ToString();
}
bool ismakeMawb = ds.Tables[0].Rows[0]["air_MakeMAWB"].ToString() == "" ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["air_MakeMAWB"]);
string flag = "N";
if (ismakeMawb)
{
flag = "Y";
}
X.AddScript("isMawbFlag='" + flag + "';");
//if (ismakeMawb == true)
//{
// txtGWT.Disabled = true;
// txtVWT.Disabled = true;
// txtCWT.Disabled = true;
// txtPiece.Disabled = true;
// isMawbFlag.Style.Add("display", "none");
//}
//else
//{
// txtGWT.Disabled = false;
// txtVWT.Disabled = false;
// txtCWT.Disabled = false;
// txtPiece.Disabled = false;
// isMawbFlag.Style.Add("display", "block");
//}
if (ds.Tables[1].Rows.Count > 0)
{
GridFlightList.GetStore().DataSource = ds.Tables[1];
GridFlightList.GetStore().DataBind();
}
if (ds.Tables[2].Rows.Count > 0)
{
gpHAWB.GetStore().DataSource = ds.Tables[2];
gpHAWB.GetStore().DataBind();
double GWT = 0, VWT = 0, CWT = 0, Pieces = 0, Pallets = 0;
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
if (ds.Tables[2].Rows[i]["IsSub"].ToString() == "0")
{
GWT += Convert.ToDouble(ds.Tables[2].Rows[i]["GWT"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["GWT"].ToString());
VWT += Convert.ToDouble(ds.Tables[2].Rows[i]["VWT"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["VWT"].ToString());
CWT += Convert.ToDouble(ds.Tables[2].Rows[i]["CWT"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["CWT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[2].Rows[i]["Piece"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["Piece"].ToString());
Pallets += Convert.ToDouble(ds.Tables[2].Rows[i]["Pallet"].ToString() == "" ? "0" : ds.Tables[2].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();
}
if (ds.Tables[3].Rows.Count > 0)
{
gpInvoice.GetStore().DataSource = ds.Tables[3];
gpInvoice.GetStore().DataBind();
}
if (ControlBinder.IsDisplayLotNo(txtETD.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;
btnPull.Disabled = true;
btnNew.Disabled = true;
btnVoid.Text = "Active";
hidVoid.Text = "1";
btnUpdateLotNo.Hide();
}
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p>Status : Edit No. of <span>" + hidLotNo.Text + "</span></p>", div_bottom);
}
else
{
if (ds.Tables[2].Rows.Count > 0)
{
gpHAWB.GetStore().DataSource = ds.Tables[2];
gpHAWB.GetStore().DataBind();
double GWT = 0, VWT = 0, CWT = 0, Pieces = 0, Pallets = 0;
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
if (ds.Tables[2].Rows[i]["IsSub"].ToString() == "0")
{
GWT += Convert.ToDouble(ds.Tables[2].Rows[i]["GWT"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["GWT"].ToString());
VWT += Convert.ToDouble(ds.Tables[2].Rows[i]["VWT"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["VWT"].ToString());
CWT += Convert.ToDouble(ds.Tables[2].Rows[i]["CWT"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["CWT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[2].Rows[i]["Piece"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["Piece"].ToString());
Pallets += Convert.ToDouble(ds.Tables[2].Rows[i]["Pallet"].ToString() == "" ? "0" : ds.Tables[2].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();
}
ControlBinder.pageTitleMsg(false, showname, "<p>Status : New Blank No. </p>", div_bottom);
}
}
private void DataBindList()
{
txtMAWB.Focus(true);
List <IFields> Getlist = new List <IFields>();
Getlist.Add(dal.CreateIFields().Append("Option", "GetAEColoaderDirect")
.Append("air_Seed", hidSeed.Text == "" ? null : hidSeed.Text)
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("air_SYS", sys)
);
DataSet ds = GetDs("FW_AirExport_CoLoaderDirect_SP", Getlist);
if (ds != null && ds.Tables[0].Rows.Count > 0 && hidSeed.Text != "0" && hidSeed.Text != "")
{
labLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
hidLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
txtMAWB.Text = ds.Tables[0].Rows[0]["MAWB"].ToString();
//CmbDeparture.setValue(ds.Tables[0].Rows[0]["Departure"].ToString());
//CmbFinalDest.setValue(ds.Tables[0].Rows[0]["Destination"].ToString());
CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"].ToString());
CmbColoader.setValue(ds.Tables[0].Rows[0]["CoLoader"].ToString());
CmbColoader.Text = ds.Tables[0].Rows[0]["CoLoaderName"].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();
CmbNP.SelectedItem.Value = ds.Tables[0].Rows[0]["NP"].ToString();
CmbCarrierRight.setValue(ds.Tables[0].Rows[0]["Carrier"].ToString());
txtFlightRight.Text = ds.Tables[0].Rows[0]["FlightNo"].ToString();
CmbFromRight.setValue(ds.Tables[0].Rows[0]["From"].ToString());
CmbToRight.setValue(ds.Tables[0].Rows[0]["To"].ToString());
txtETD.Text = ds.Tables[0].Rows[0]["ETD"].ToString();
txtETA.Text = ds.Tables[0].Rows[0]["ETA"].ToString();
txtATD.Text = ds.Tables[0].Rows[0]["ATD"].ToString();
txtATA.Text = ds.Tables[0].Rows[0]["ATA"].ToString();
txtMAWBRemark.Text = ds.Tables[0].Rows[0]["air_Remark"].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();
}
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]["Rate"].ToString()))
{
txtRate.Text = ds.Tables[0].Rows[0]["Rate"].ToString();
}
bool ismakeMawb = ds.Tables[0].Rows[0]["air_MakeMAWB"].ToString() == "" ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["air_MakeMAWB"]);
if (ismakeMawb == true)
{
txtGWT.Disabled = true;
txtVWT.Disabled = true;
txtCWT.Disabled = true;
txtPiece.Disabled = true;
isMawbFlag.Style.Add("display", "none");
}
else
{
txtGWT.Disabled = false;
txtVWT.Disabled = false;
txtCWT.Disabled = false;
txtPiece.Disabled = false;
isMawbFlag.Style.Add("display", "block");
}
if (ds.Tables[1].Rows.Count > 0)
{
GridFlightList.GetStore().DataSource = ds.Tables[1];
GridFlightList.GetStore().DataBind();
}
if (ds.Tables[2].Rows.Count > 0)
{
gpInvoice.GetStore().DataSource = ds.Tables[2];
gpInvoice.GetStore().DataBind();
}
if (ControlBinder.IsDisplayLotNo(txtETD.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();
}
ControlBinder.pageTitleMsg(false, "AE-M:" + hidLotNo.Text, "<p>Status : Edit MAWB of <span>" + hidLotNo.Text + "</span></p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "AE-M New", "<p>Status : New Blank MAWB </p>", div_bottom);
}
}
protected void btnSave_Click(object sender, DirectEventArgs e)
{
if (string.IsNullOrEmpty(CmbShipperCode.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Shipper can't be empty!</p>";
CmbShipperCode.Focus();
return;
}
if (string.IsNullOrEmpty(CmbConsignee.Value.Trim()))
{
div_bottom.Html = "<p class='error'> Save failed, Consignee can't be empty!</p>";
CmbConsignee.Focus();
return;
}
if (GridFlightList.Store.Count == 0)
{
div_bottom.Html = "<p class='error'> Save failed, Flight Routing is no data!</p>";
l_flightno.Focus();
return;
}
List <IFields> UpdateHAWB = new List <IFields>();
UpdateHAWB.Add(dal.CreateIFields().Append("Option", "Update")
.Append("air_Seed", hidSeed.Text == "" ? null : hidSeed.Text)
.Append("air_MAWB", txtMAWB.Text.Trim().Replace(" ", "").ToUpper())
.Append("air_LotNo", hidLotNo.Text)
//.Append("air_LocReceived",CmbDeparture.Value)
//.Append("air_LocFinal", CmbFinalDest.Value)
.Append("air_Sales", CmbSalesman.Value)
.Append("air_Shipper", CmbShipperCode.Value)
.Append("air_Consignee", CmbConsignee.Value)
.Append("air_Carrier", CmbCarrierRight.Value)
.Append("air_Flight", txtFlightRight.Text.ToUpper())
.Append("air_LocLoad", CmbFromRight.Value)
.Append("air_LocDischarge", CmbToRight.Value)
.Append("air_ETD", ControlBinder.getDate(txtETD.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtETD.RawText.Trim()))
.Append("air_ETA", ControlBinder.getDate(txtETA.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtETA.RawText.Trim()))
.Append("air_ATD", ControlBinder.getDate(txtATD.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtATD.RawText.Trim()))
.Append("air_ATA", ControlBinder.getDate(txtATA.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtATA.RawText.Trim()))
.Append("air_GWT", string.IsNullOrEmpty(txtGWT.Text) ? DBNull.Value : (object)txtGWT.Text)
.Append("air_VWT", string.IsNullOrEmpty(txtVWT.Text) ? DBNull.Value : (object)txtVWT.Text)
.Append("air_CWT", string.IsNullOrEmpty(txtCWT.Text) ? DBNull.Value : (object)txtCWT.Text)
.Append("air_Piece", string.IsNullOrEmpty(txtPiece.Text) ? DBNull.Value : (object)txtPiece.Text)
.Append("air_Pallet", string.IsNullOrEmpty(txtPallet.Text) ? DBNull.Value : (object)txtPallet.Text)
.Append("air_Rate", string.IsNullOrEmpty(txtRate.Text) ? DBNull.Value : (object)txtRate.Text)
.Append("air_Remark", txtRemark.Text.Trim())
.Append("air_OperationRemark", txtOperation.Text.Trim())
.Append("air_AccountRemark", txtAccount.Text.Trim())
.Append("code", FSecurityHelper.CurrentUserDataGET()[4].ToString() + sys)
.Append("code1", FSecurityHelper.CurrentUserDataGET()[4].ToString() + sys + "SN")
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("air_SYS", sys)
.Append("type", typename)
.Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
try
{
DataSet ds = GetDs("FW_AirExport_DirectMAWB_SP", UpdateHAWB);
hidSeed.Text = ds.Tables[0].Rows[0][0].ToString();
string newFlag = ds.Tables[0].Rows[0][1].ToString();
hidLotNo.Text = ds.Tables[0].Rows[0][2].ToString();
#region FlightRouting
var ShipmentRoute = JSON.Deserialize <List <ShipmentRoute> >(e.ExtraParams["p_safety_l"]);
List <IFields> Routelist = new List <IFields>();
string RouteID = "";
for (int i = 0; i < ShipmentRoute.Count; ++i)
{
Routelist.Add(dal.CreateIFields().Append("Option", "Update").
Append("sr_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString()).
Append("sr_ToMaster", hidSeed.Text).
Append("sr_ShipKind", "FREIGHT").
Append("sr_Carrier", ShipmentRoute[i].Carrier).
Append("sr_OrderID", i).
Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).
Append("sr_Flight", ShipmentRoute[i].FlightNo.ToUpper()).
Append("sr_From", ShipmentRoute[i].From).
Append("sr_To", ShipmentRoute[i].To).
Append("sr_ETD", ControlBinder.getDate(ShipmentRoute[i].ETD.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ETD)).
Append("sr_ETA", ControlBinder.getDate(ShipmentRoute[i].ETA.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ETA)).
Append("sr_ATD", ControlBinder.getDate(ShipmentRoute[i].ATD.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ATD)).
Append("sr_ATA", ControlBinder.getDate(ShipmentRoute[i].ATA.ToString().StartsWith("0001") ? DBNull.Value : (object)ShipmentRoute[i].ATA)).
Append("sr_ROWID", ShipmentRoute[i].RowID));
RouteID += "," + ShipmentRoute[i].RowID;
}
if (RouteID.Length > 1)
{
RouteID = RouteID.Substring(1, RouteID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentRoute_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "Delete").Append("sr_ToMaster", hidSeed.Text).Append("str", RouteID)
}).Update();
bool b = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentRoute_SP", Routelist).Update();
#endregion
#region LocalInvoice
//var InvocieList = JSON.Deserialize<List<Invocie>>(e.ExtraParams["p_safety_2"]);
//string InvoiceID = "";
//for (int i = 0; i < InvocieList.Count; ++i)
//{
// InvoiceID += "," + InvocieList[i].RowID;
//}
//if (InvoiceID.Length > 1)
//{
// InvoiceID = InvoiceID.Substring(1, InvoiceID.Length - 1);
//}
//bool inv = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_DirectMAWB_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteInvoice")
//.Append("air_ToMAWB",hidSeed.Text)
//.Append("str",InvoiceID)}).Update();
#endregion
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
#region Foreign
var Foreign = JSON.Deserialize <List <Foreign> >(e.ExtraParams["p_safety_4"]);
List <IFields> Foreignlist = new List <IFields>();
string ForeignID = "";
for (int i = 0; i < Foreign.Count; ++i)
{
if (Foreign[i].CompanyCode.Trim() != "" && Foreign[i].Item.Trim() != "" && Foreign[i].CalcKind.Trim() != "")
{
Foreignlist.Add(dal.CreateIFields().Append("Option", "UpdateForeign").
Append("si_BillTo", Foreign[i].CompanyCode.Trim().ToUpper()).
Append("si_Total", string.IsNullOrEmpty(Foreign[i].Total) ? DBNull.Value : (object)Foreign[i].Total).
Append("si_Item", Foreign[i].Item.Trim().ToUpper()).
Append("si_Description", Foreign[i].Description).
Append("si_QtyKind", Foreign[i].CalcKind.Trim().ToUpper()).
//Append("si_Currency", CmbForeign.SelectedItem.Value == null ? "USD" : CmbForeign.SelectedItem.Value).
Append("si_Currency", string.IsNullOrEmpty(Foreign[i].Currency) ? "USD" : (object)Foreign[i].Currency).
Append("si_Quantity", string.IsNullOrEmpty(txtCWT.Text) ? null : (object)txtCWT.Text).
Append("si_Unit", Foreign[i].Unit).
Append("si_ExRate", string.IsNullOrEmpty(Foreign[i].EX) ? DBNull.Value : (object)Foreign[i].EX).
Append("si_Rate", string.IsNullOrEmpty(Foreign[i].Rate) ? DBNull.Value : (object)Foreign[i].Rate).
Append("si_Amount", string.IsNullOrEmpty(Foreign[i].Amount) ? DBNull.Value : (object)Foreign[i].Amount).
Append("si_Min", string.IsNullOrEmpty(Foreign[i].Min) ? DBNull.Value : (object)Foreign[i].Min).
Append("si_ShowIn", Foreign[i].Show.Trim().ToUpper())
.Append("si_ROWID", Foreign[i].RowID)
.Append("si_ToMaster", hidSeed.Text)
.Append("si_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("si_Sys", sys)
.Append("si_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
ForeignID += "," + Foreign[i].RowID;
}
}
//delete
if (ForeignID.Length > 1)
{
ForeignID = ForeignID.Substring(1, ForeignID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActualForeign").Append("si_Seed", hidSeed.Text).Append("str", ForeignID)
}).Update();
bool resultForeign = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", Foreignlist).Update();
#endregion
#region Foreign Freight
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "UpdateForFreight").Append("si_ROWID", string.IsNullOrEmpty(hidForeignID.Text) ? null : (object)hidForeignID.Text)
.Append("si_User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).Append("si_Sys", sys).Append("si_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString()).Append("si_ToMaster", hidSeed.Text)
.Append("si_BillTo", CmbCompany.Value).Append("si_Min", string.IsNullOrEmpty(txtFor.Text) ? "0" : (object)txtFor.Text).Append("si_Currency", CmbForeign.SelectedItem.Value == null ? "USD" : CmbForeign.SelectedItem.Value).Append("si_Quantity", string.IsNullOrEmpty(txtCWT.Text) ? null : (object)txtCWT.Text).Append("si_Unit", "")
}).Update();
#endregion
#region Local
var Local = JSON.Deserialize <List <Local> >(e.ExtraParams["p_safety_5"]);
List <IFields> Locallist = new List <IFields>();
string LocalID = "";
for (int i = 0; i < Local.Count; ++i)
{
if (Local[i].CompanyCode.Trim() != "" && Local[i].Item.Trim() != "" && Local[i].CalcKind.Trim() != "")
{
Locallist.Add(dal.CreateIFields().Append("Option", "UpdateLocal").
Append("si_BillTo", Local[i].CompanyCode.Trim().ToUpper()).
Append("si_Total", string.IsNullOrEmpty(Local[i].Total) ? DBNull.Value : (object)Local[i].Total).
Append("si_Item", Local[i].Item.Trim().ToUpper()).
Append("si_Description", Local[i].Description).
Append("si_QtyKind", Local[i].CalcKind.Trim().ToUpper()).
Append("si_Currency", CmbLocal.SelectedItem.Value == null ? "HKD" : CmbLocal.SelectedItem.Value).
Append("si_Quantity", string.IsNullOrEmpty(txtCWT.Text) ? null : (object)txtCWT.Text).
Append("si_Unit", Local[i].Unit).
Append("si_ExRate", string.IsNullOrEmpty(Local[i].EX) ? DBNull.Value : (object)Local[i].EX).
Append("si_Rate", string.IsNullOrEmpty(Local[i].Rate) ? DBNull.Value : (object)Local[i].Rate).
Append("si_Amount", string.IsNullOrEmpty(Local[i].Amount) ? DBNull.Value : (object)Local[i].Amount).
Append("si_Min", string.IsNullOrEmpty(Local[i].Min) ? DBNull.Value : (object)Local[i].Min).
Append("si_ShowIn", Local[i].Show.Trim().ToUpper())
.Append("si_ROWID", Local[i].RowID)
.Append("si_ToMaster", hidSeed.Text)
.Append("si_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("si_Sys", sys)
.Append("si_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
LocalID += "," + Local[i].RowID;
}
}
//delete
if (LocalID.Length > 1)
{
LocalID = LocalID.Substring(1, LocalID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActualLocal").Append("si_Seed", hidSeed.Text).Append("str", LocalID)
}).Update();
bool resultLocal = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", Locallist).Update();
#endregion
#region Local Freight
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "UpdateLocFreight").Append("si_ROWID", string.IsNullOrEmpty(hidLocalID.Text) ? null : (object)hidLocalID.Text)
.Append("si_User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).Append("si_Sys", sys).Append("si_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString()).Append("si_ToMaster", hidSeed.Text)
.Append("si_BillTo", CmbCompany1.Value).Append("si_Min", string.IsNullOrEmpty(txtLoc.Text) ? "0" : (object)txtLoc.Text).Append("si_Currency", CmbLocal.SelectedItem.Value == null ? "HKD" : CmbLocal.SelectedItem.Value).Append("si_Quantity", string.IsNullOrEmpty(txtCWT.Text) ? null : (object)txtCWT.Text).Append("si_Unit", "")
}).Update();
#endregion
#region WTForeign
var WTForeign = JSON.Deserialize <List <WTForeign> >(e.ExtraParams["p_safety_6"]);
List <IFields> WTForeignlist = new List <IFields>();
string WTForeignID = "";
for (int i = 0; i < WTForeign.Count; ++i)
{
if (WTForeign[i].Rate != null)
{
WTForeignlist.Add(dal.CreateIFields().Append("Option", "UpdateSellRateForeign").
Append("aer_Weight", string.IsNullOrEmpty(WTForeign[i].WT) ? "0.000" : (object)WTForeign[i].WT).
Append("aer_Rate", string.IsNullOrEmpty(WTForeign[i].Rate) ? DBNull.Value : (object)WTForeign[i].Rate)
.Append("aer_ROWID", WTForeign[i].RowID)
.Append("aer_Seed", hidSeed.Text)
.Append("aer_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("aer_Sys", sys)
.Append("aer_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
WTForeignID += "," + WTForeign[i].RowID;
}
}
//delete
if (WTForeignID.Length > 1)
{
WTForeignID = WTForeignID.Substring(1, WTForeignID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActualSellRateForeign").Append("aer_Seed", hidSeed.Text).Append("str", WTForeignID)
}).Update();
bool resultWTForeign = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", WTForeignlist).Update();
#endregion
#region WTLocal
var WTLocal = JSON.Deserialize <List <WTLocal> >(e.ExtraParams["p_safety_7"]);
List <IFields> WTLocallist = new List <IFields>();
string WTLocalID = "";
for (int i = 0; i < WTLocal.Count; ++i)
{
if (WTLocal[i].Rate != null)
{
WTLocallist.Add(dal.CreateIFields().Append("Option", "UpdateSellRateLocal").
Append("aer_Weight", string.IsNullOrEmpty(WTLocal[i].WT) ? "0.000" : (object)WTLocal[i].WT).
Append("aer_Rate", string.IsNullOrEmpty(WTLocal[i].Rate) ? DBNull.Value : (object)WTLocal[i].Rate)
.Append("aer_ROWID", WTLocal[i].RowID)
.Append("aer_Seed", hidSeed.Text)
.Append("aer_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("aer_Sys", sys)
.Append("aer_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
WTLocalID += "," + WTLocal[i].RowID;
}
}
//delete
if (WTLocalID.Length > 1)
{
WTLocalID = WTLocalID.Substring(1, WTLocalID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActualSellRateLocal").Append("aer_Seed", hidSeed.Text).Append("str", WTLocalID)
}).Update();
bool resultWTLocal = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_ShipmentItemForDirectMAWB_SP", WTLocallist).Update();
#endregion
#region updateFreightTotal
string type1 = "N", type2 = "N";
if (CmbCompany.Value != "")
{
type1 = "Y";
}
if (CmbCompany1.Value != "")
{
type2 = "Y";
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_CoLoaderInFreight_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "UpdateTotal").Append("air_Seed", hidSeed.Text).Append("CWT", string.IsNullOrEmpty(txtCWT.Text) ? "0" : txtCWT.Text)
.Append("Type1", type1).Append("Type2", type2).Append("F_Min", string.IsNullOrEmpty(txtFor.Text) ? "0" : txtFor.Text).Append("L_Min", string.IsNullOrEmpty(txtLoc.Text) ? "0" : txtLoc.Text).Append("M", "Y")
}).Update();
#endregion
//update cost(Qty,unit,total)
//ControlBinder.UpdateCostData(hidSeed.Text, "AE", "MAWB");
if (newFlag == "N")
{
//---
DataBindList();
X.AddScript("if(window.opener!=null){if(typeof(window.opener.RefreshList)!='undefined'){window.opener.RefreshList();}}");
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p class=\"success\">Status : Save successfully ! </p>", div_bottom);
}
}
catch
{
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data !</p>", div_bottom);
}
}
private void DataBindList()
{
List <IFields> Getlist = new List <IFields>();
Getlist.Add(dal.CreateIFields().Append("Option", "GetAEDirectMAWB")
.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_DirectMAWB_SP", Getlist);
if (ds != null && ds.Tables[0].Rows.Count > 0 && hidSeed.Text != null && hidSeed.Text != "")
{
labLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
if (labLotNo.Text != "")
{
labLot.Text = "Lot# ";
}
hidLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString();
txtMAWB.Text = ds.Tables[0].Rows[0]["MAWB"].ToString();
CmbSalesman.setValue(ds.Tables[0].Rows[0]["air_Sales"].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();
CmbCarrierRight.setValue(ds.Tables[0].Rows[0]["Carrier"].ToString());
txtFlightRight.Text = ds.Tables[0].Rows[0]["FlightNo"].ToString();
CmbFromRight.setValue(ds.Tables[0].Rows[0]["From"].ToString());
CmbToRight.setValue(ds.Tables[0].Rows[0]["To"].ToString());
txtETD.Text = ds.Tables[0].Rows[0]["ETD"].ToString();
txtETA.Text = ds.Tables[0].Rows[0]["ETA"].ToString();
txtATD.Text = ds.Tables[0].Rows[0]["ATD"].ToString();
txtATA.Text = ds.Tables[0].Rows[0]["ATA"].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();
}
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]["Rate"].ToString()))
{
txtRate.Text = ds.Tables[0].Rows[0]["Rate"].ToString();
}
txtRemark.Text = ds.Tables[0].Rows[0]["air_Remark"].ToString();
txtAccount.Text = ds.Tables[0].Rows[0]["air_AccountRemark"].ToString();
txtOperation.Text = ds.Tables[0].Rows[0]["air_OperationRemark"].ToString();
bool ismakeMawb = ds.Tables[0].Rows[0]["air_MakeMAWB"].ToString() == "" ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["air_MakeMAWB"]);
string flag = "N";
if (ismakeMawb)
{
flag = "Y";
}
X.AddScript("isMawbFlag='" + flag + "';");
if (ds.Tables[1].Rows.Count > 0)
{
GridFlightList.GetStore().DataSource = ds.Tables[1];
GridFlightList.GetStore().DataBind();
}
if (ds.Tables[2].Rows.Count > 0)
{
gpInvoice.GetStore().DataSource = ds.Tables[2];
gpInvoice.GetStore().DataBind();
}
if (ds.Tables[4].Rows.Count > 0)
{
lblCurForeign.Text = ds.Tables[4].Rows[0]["Currency"].ToString();
CmbForeign.SelectedItem.Value = ds.Tables[4].Rows[0]["Currency"].ToString();
gpForeign.GetStore().DataSource = ds.Tables[4];
gpForeign.GetStore().DataBind();
}
if (ds.Tables[5].Rows.Count > 0)
{
hidForeignID.Text = ds.Tables[5].Rows[0]["RowID"].ToString();
CmbCompany.setValue(ds.Tables[5].Rows[0]["CompanyCode"].ToString());
CmbCompany.Text = ds.Tables[5].Rows[0]["CompanyName"].ToString();
txtFor.Text = ds.Tables[5].Rows[0]["Min"].ToString();
}
if (ds.Tables[6].Rows.Count > 0)
{
lblCurLocal.Text = ds.Tables[6].Rows[0]["Currency"].ToString();
CmbLocal.SelectedItem.Value = ds.Tables[6].Rows[0]["Currency"].ToString();
gpLocal.GetStore().DataSource = ds.Tables[6];
gpLocal.GetStore().DataBind();
}
if (ds.Tables[7].Rows.Count > 0)
{
hidLocalID.Text = ds.Tables[7].Rows[0]["RowID"].ToString();
CmbCompany1.setValue(ds.Tables[7].Rows[0]["CompanyCode"].ToString());
CmbCompany1.Text = ds.Tables[7].Rows[0]["CompanyName"].ToString();
txtLoc.Text = ds.Tables[7].Rows[0]["Min"].ToString();
}
if (ds.Tables[8].Rows.Count > 0)
{
gpWTForeign.GetStore().DataSource = ds.Tables[8];
gpWTForeign.GetStore().DataBind();
}
if (ds.Tables[9].Rows.Count > 0)
{
gpWTLocal.GetStore().DataSource = ds.Tables[9];
gpWTLocal.GetStore().DataBind();
}
if (ds.Tables.Count > 10)
{
l_from.setValue(ds.Tables[10].Rows[0]["From"].ToString());
l_to.setValue(ds.Tables[10].Rows[0]["To"].ToString());
l_etd.Text = ds.Tables[10].Rows[0]["ETD"].ToString();
l_eta.Text = ds.Tables[10].Rows[0]["ETA"].ToString();
}
if (hidLotNo.Text != "")
{
if (ControlBinder.IsDisplayLotNo(txtETD.Text.Trim(), hidLotNo.Text))
{
btnUpdateLotNo.Show();
}
else
{
btnUpdateLotNo.Hide();
}
}
if (ds.Tables[0].Rows[0]["Active"].ToString() == "Y")
{
img_void.Style.Value = "display:none";
if (labLotNo.Text != "")
{
X.AddScript("$('#showGenerate').show();");
}
}
else
{
img_void.Style.Value = "display:inline";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnRevert.Disabled = true;
X.AddScript("$('#showGenerate').hide();");
btnVoid.Text = "Active";
hidVoid.Text = "1";
btnUpdateLotNo.Hide();
}
ControlBinder.pageTitleMsg(false, showname + ":" + hidLotNo.Text, "<p>Status : Edit No. of <span>" + hidLotNo.Text + "</span></p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, showname, "<p>Status : New Blank No. </p>", div_bottom);
}
}
/// <summary>
/// 保存全部
/// </summary>
#region ///Button 事件 保存全部 Author：Micro (2011-09-27)
protected void btnSave_Click(object sender, DirectEventArgs e)
{
string code = (FSecurityHelper.CurrentUserDataGET()[12].Length > 3) ? FSecurityHelper.CurrentUserDataGET()[12].Substring(4, 3) + "OE" : FSecurityHelper.CurrentUserDataGET()[12] + "OE";
#region ///Update OCEAN
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanExport_MBL_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "UpdateMBL")
.Append("o_Seed", hidSeed.Text == ""?null:hidSeed.Text)
.Append("o_LotNo", labImpLotNo.Text)
.Append("o_MBL", txtMBL.Text.ToUpper())
.Append("o_ServiceMode", cmbMode.Value)
.Append("o_ServiceType", CmbGroup.SelectedItem.Value)
.Append("o_PaymentMode", cmbPPD.Text)
.Append("o_Sales", cmbSales.Value)
.Append("o_Carrier", cmbCarrierCode.Value)
.Append("o_VesselID", cmbVesselCode.SelectedItem.Value)
.Append("o_VoyageID", cmbVesselText.SelectedItem.Value)
.Append("o_Shipper", cmbShipperCode.Value)
.Append("o_Consignee", cmbConsigneeCode.Value)
.Append("o_PartyA", CmbNotify1.Value)
.Append("o_PartyB", CmbNotify2.Value)
.Append("o_Coloader", cmbDischargeCode.Value)
.Append("o_Broker", cmbBrokerCode.Value)
.Append("o_M_to", txtM_to.Value.Trim().ToUpper())
.Append("o_CWT", string.IsNullOrEmpty(txtCGWT.Text)?DBNull.Value:(object)txtCGWT.Text)
.Append("o_AWT", string.IsNullOrEmpty(txtAGWT.Text)?DBNull.Value:(object)txtAGWT.Text)
.Append("o_CCBM", string.IsNullOrEmpty(txtCCBM.Text)?DBNull.Value:(object)txtCCBM.Text)
.Append("o_ACBM", string.IsNullOrEmpty(txtACBM.Text)?DBNull.Value:(object)txtACBM.Text)
.Append("o_CPKGS", string.IsNullOrEmpty(txtCPiece.Text)?DBNull.Value:(object)txtCPiece.Text)
.Append("o_APKGS", string.IsNullOrEmpty(txtAPiece.Text)?DBNull.Value:(object)txtAPiece.Text)
.Append("o_CWM", string.IsNullOrEmpty(txtCWM.Text)?DBNull.Value:(object)txtCWM.Text)
.Append("o_AWM", string.IsNullOrEmpty(txtAWM.Text)?DBNull.Value:(object)txtAWM.Text)
.Append("o_Unit", CmbUnit.Value)
.Append("o_LocFinal", cmbFinalDest.Text)
.Append("o_LocPOL", cmbLoading.Value)
.Append("o_LocPOD", cmbPort.Value)
.Append("o_CFS", ControlBinder.getDate(txtCFSClosing.RawText.StartsWith("0001")?DBNull.Value:(object)txtCFSClosing.RawText))
.Append("o_CY", ControlBinder.getDate(txtCYClosing.RawText.StartsWith("0001")?DBNull.Value:(object)txtCYClosing.RawText))
.Append("o_ScheduleDate", ControlBinder.getDate(txtOnBoard.RawText.StartsWith("0001")?DBNull.Value:(object)txtOnBoard.RawText))
.Append("o_ETD", ControlBinder.getDate(txtETD.RawText.StartsWith("0001")?DBNull.Value:(object)txtETD.RawText))
.Append("o_ETA", ControlBinder.getDate(txtETADischarge.RawText.StartsWith("0001")?DBNull.Value:(object)txtETADischarge.RawText))
.Append("o_ETAFinal", ControlBinder.getDate(txtETAFinal.RawText.StartsWith("0001")?DBNull.Value:(object)txtETAFinal.RawText))
.Append("o_ATD", ControlBinder.getDate(txtATD.RawText.StartsWith("0001")?DBNull.Value:(object)txtATD.RawText))
.Append("o_STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("o_SYS", SYS)
.Append("User", FSecurityHelper.CurrentUserDataGET()[0])
.Append("code", code)//FSecurityHelper.CurrentUserDataGET()[4]
.Append("o_DeclareRemark", txtclpRemark.Text.ToUpper())
.Append("o_AccountRemark", txtAccRemark.Text.ToUpper())
.Append("o_Remark", txtMAWBRemark.Text.ToUpper())
.Append("o_PreVesselID", cmbpreVessel.SelectedItem.Value)
.Append("o_PreVoyageID", cmbpreVoyage.SelectedItem.Value)
.Append("o_PreOnboard", ControlBinder.getDate(txtpreonboard.RawText.StartsWith("0001")?DBNull.Value:(object)txtpreonboard.RawText))
}).GetTable();
if (dt == null || dt.Rows.Count == 0)
{
ControlBinder.pageTitleMsg(false, "OE-M New", "<p class=\"error\">Status : Save failed, please check the data . </p>", div_bottom);
return;
}
hidSeed.Text = dt.Rows[0]["o_Seed"].ToString();
string lotno = dt.Rows[0]["o_LotNo"].ToString();
#endregion
#region Update HBLList ，Local Invoice
var HBLList = JSON.Deserialize <List <HBL> >(e.ExtraParams["gridHBL"]);
string RowID = "0,";
//List<IFields> listHBL = new List<IFields>();
for (int i = 0; i < HBLList.Count; ++i)
{
//listHBL.Add(dal.CreateIFields().Append("Option", "UpdateHBLActReceipt")
// .Append("o_ROWID", HBLList[i].o_ROWID).Append("o_AReceiptDate", HBLList[i].ActReceipt==null ? null : ControlBinder.getDate((object)HBLList[i].ActReceipt))
// );
RowID += HBLList[i].o_ROWID + ",";
}
RowID = RowID.Substring(0, RowID.Length - 1);
bool hbl = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanExport_MBL_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "Delete_HBL").Append("o_MBL", txtMBL.Text.Trim().ToUpper())
.Append("o_Seed", hidSeed.Text == ""?null:hidSeed.Text).Append("ROWID", RowID).Append("o_LotNo", lotno)
}).Update();
#endregion
//update Data
bool updatealldata = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanExport_MBL_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "UpdateAllData")
.Append("o_Seed", hidSeed.Text == ""?null:hidSeed.Text)
}).Update();
//updatecost
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
bool l = true;
if (l)
{
if (i == 1)
{
hidSeed.Text = "";
ControlBinder.pageTitleMsg(true, "OE-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Record Saved with <span>" + labImpLotNo.Text + " </span> </p>", div_bottom);
X.Redirect("List.aspx");
}
else
{
if (hidSeed.Text != Request["seed"])
{
ControlBinder.pageTitleMsg(true, "OE-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Record Saved with <span>" + labImpLotNo.Text + " </span> </p>", div_bottom);
X.Redirect("List.aspx?seed=" + hidSeed.Text);
}
else
{
DataBinder();
ControlBinder.pageTitleMsg(true, "OE-M:" + labImpLotNo.Text, "<p class=\"success\">Status : Record Saved with <span>" + labImpLotNo.Text + " </span> </p>", div_bottom);
}
}
}
else
{
ControlBinder.pageTitleMsg(false, "OE-M:" + labImpLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data . </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 ///Grid 数据绑定 Author：Micro (2011-09-27)
void DataBinder()
{
//tooltip.Html = ControlBinder.GetCostTotal(hidSeed.Text);
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanExport_MBL_SP", new List <IFields>()
{
dal.CreateIFields()
.Append("Option", "Single")
.Append("o_Seed", hidSeed.Text == ""?null:hidSeed.Text)
.Append("str", hidIDList.Text)
.Append("o_STAT", FSecurityHelper.CurrentUserDataGET()[12])
.Append("o_LocPOL", FSecurityHelper.CurrentUserDataGET()[4])
}).GetList();
if (ds != null && hidSeed.Text.Length > 1)
{
DataBinder(ds.Tables[0]);
if (ds.Tables[1].Rows.Count > 0)
{
storeHBL.DataSource = ds.Tables[1];
storeHBL.DataBind();
double GWT = 0.000, Pieces = 0, CBM = 0.000, wm = 0.000;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["o_WT"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["o_WT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["o_PKGS"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["o_PKGS"].ToString());
CBM += Convert.ToDouble(ds.Tables[1].Rows[i]["o_CBM"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["o_CBM"].ToString());
wm += Convert.ToDouble(ds.Tables[1].Rows[i]["o_WM"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["o_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();
}
totalPiece.Text = txtAPiece.Text;
totalGWT.Text = txtAGWT.Text;
totalCBM.Text = txtACBM.Text;
}
StoreInvoice.DataSource = ds.Tables[2];
StoreInvoice.DataBind();
}
else if (ds != null && hidSeed.Text == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
CmbUnit.Value = ds.Tables[0].Rows[0]["Unit"].ToString();
cmbPPD.SelectedItem.Value = ds.Tables[0].Rows[0]["PPD"].ToString();
cmbLoading.Value = ds.Tables[0].Rows[0]["Loading"].ToString();
cmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString());
cmbShipperCode.Text = ds.Tables[0].Rows[0]["ShipperName"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
storeHBL.DataSource = ds.Tables[1];
storeHBL.DataBind();
double GWT = 0.000, Pieces = 0, CBM = 0.000, wm = 0.000;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["o_WT"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["o_WT"].ToString());
Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["o_PKGS"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["o_PKGS"].ToString());
CBM += Convert.ToDouble(ds.Tables[1].Rows[i]["o_CBM"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["o_CBM"].ToString());
wm += Convert.ToDouble(ds.Tables[1].Rows[i]["o_WM"].ToString() == "" ? "0.000" : ds.Tables[1].Rows[i]["o_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();
}
totalPiece.Text = txtAPiece.Text;
totalGWT.Text = txtAGWT.Text;
totalCBM.Text = txtACBM.Text;
}
ControlBinder.pageTitleMsg(false, "OE-M New", "<p>Status : New Blank MBL. </p>", div_bottom);
}
else
{
ControlBinder.pageTitleMsg(false, "OE-M New", "<p>Status : New Blank MBL. </p>", div_bottom);
}
//txtMBL.Focus(true);
CmbGroup.Focus(true);
}
/// <summary>
/// Button 事件 修改保存
/// </summary>
#region btnSave_Click() 修改保存 Author：Micro (2011-09-05)
protected void btnSave_Click(object sender, DirectEventArgs e)
{
object job = ControlBinder.getDate(string.IsNullOrEmpty(txtJob.RawText.Trim()) ? DBNull.Value : (object)txtJob.RawText.Trim());
object ETD = ControlBinder.getDate(string.IsNullOrEmpty(txtDepartDate.RawText.Trim()) ? DBNull.Value : (object)txtDepartDate.RawText.Trim());
object ETA = ControlBinder.getDate(string.IsNullOrEmpty(txtArrivalDate.RawText.Trim()) ? DBNull.Value : (object)txtArrivalDate.RawText.Trim());
if (cmbVesselCode.SelectedItem.Value == cmbVesselCode.SelectedItem.Text)
{
cmbVesselCode.SelectedItem.Value = "0";
}
if (cmbVesselText.SelectedItem.Value == cmbVesselText.SelectedItem.Text)
{
cmbVesselText.SelectedItem.Value = "0";
}
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_Other_Domestic_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "Update")
.Append("tri_Seed", hidSeed.Text == ""?null:hidSeed.Text)
.Append("tri_MBL", txtMAWB.Text.Trim().ToUpper())
.Append("tri_HBL", txtHAWB.Text.Trim().ToUpper())
.Append("tri_VesselID", string.IsNullOrEmpty(cmbVesselCode.SelectedItem.Value)?"0":cmbVesselCode.SelectedItem.Value.Trim().ToUpper())
.Append("tri_Vessel", string.IsNullOrEmpty(cmbVesselCode.SelectedItem.Text)?"":cmbVesselCode.SelectedItem.Text.Trim().ToUpper())
.Append("tri_VoyageID", string.IsNullOrEmpty(cmbVesselText.SelectedItem.Value)?"0":cmbVesselText.SelectedItem.Value.Trim().ToUpper())
.Append("tri_Voyage", string.IsNullOrEmpty(cmbVesselText.SelectedItem.Text)?"":cmbVesselText.SelectedItem.Text.Trim().ToUpper())
.Append("tri_EReceipt", job)
.Append("tri_ETD", ETD)
.Append("tri_ETA", ETA)
.Append("tri_LocReceived", string.IsNullOrEmpty(CmbDeparture.Value)?DBNull.Value:(object)CmbDeparture.Value.Trim().ToUpper())
.Append("tri_LocFinal", string.IsNullOrEmpty(CmbDest.Value)?DBNull.Value:(object)CmbDest.Value.Trim().ToUpper())
.Append("tri_LocReceivedL", txtDepL.Text.Trim().ToUpper())
.Append("tri_LocFinalL", txtDesL.Text.Trim().ToUpper())
.Append("tri_Sales", string.IsNullOrEmpty(CmbSalesman.Value)?DBNull.Value:(object)CmbSalesman.Value.Trim().ToUpper())
.Append("tri_Container", string.IsNullOrEmpty(txtContainer.Text.Trim())?DBNull.Value:(object)txtContainer.Text.Trim())
.Append("tri_Shipper", CmbShipperCode.Value.Trim().ToUpper())
.Append("tri_ShipperLine", CmbShipperCode_name.Text.Trim().ToUpper())
.Append("tri_Consignee", CmbConsigneeCode.Value.Trim().ToUpper())
.Append("tri_ConsigneeLine", CmbConsigneeCode_name.Text.Trim().ToUpper())
.Append("tri_PartyA", CmbNotify1Code.Value.Trim().ToUpper())
.Append("tri_PartyALine", CmbNotify1Code_name.Text.Trim().ToUpper())
.Append("tri_PartyB", CmbNotify2Code.Value.Trim().ToUpper())
.Append("tri_PartyBLine", CmbNotify2Code_name.Text.Trim().ToUpper())
.Append("tri_Carrier", CmbCarrierCode.Value.Trim().ToUpper())
.Append("tri_CarrierLine", CmbCarrierCode_name.Text.Trim().ToUpper())
.Append("tri_CoLoader", CmbCoLoader.Value.Trim().ToUpper())
.Append("tri_CoLoaderLine", CmbCoLoader_name.Text.Trim().ToUpper())
.Append("tri_GWT", string.IsNullOrEmpty(txtGWT.Text.Trim())?DBNull.Value:(object)txtGWT.Text)
.Append("tri_CBM", string.IsNullOrEmpty(txtCBM.Text.Trim())?DBNull.Value:(object)txtCBM.Text)
.Append("tri_CWT", string.IsNullOrEmpty(txtCWT.Text.Trim())?DBNull.Value:(object)txtCWT.Text)
.Append("tri_Piece", string.IsNullOrEmpty(txtPiece.Text.Trim())?DBNull.Value:(object)txtPiece.Text)
.Append("tri_Unit", CmbUnit.Value)
.Append("tri_LastUser", FSecurityHelper.CurrentUserDataGET()[0].ToString())
.Append("tri_STAT", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("tri_SYS", "DM")
.Append("tri_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
.Append("code", FSecurityHelper.CurrentUserDataGET()[4].ToString() + "DM")
.Append("tri_Remark", string.IsNullOrEmpty(txtMAWBRemark.Text) ? "" : txtMAWBRemark.Text.ToUpper())
}).GetTable();
if (dt != null && dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0][0].ToString()))
{
hidSeed.Text = dt.Rows[0][0].ToString();
}
#region Invoice
//string rowID = "0,";
//var InvoiceList = JSON.Deserialize<List<Invocie>>(e.ExtraParams["p_safety_4"]);
//rowID = "0,";
//for (int i = 0; i < InvoiceList.Count; ++i)
//{
// rowID += InvoiceList[i].RowID + ",";
//}
//rowID = rowID.Substring(0, rowID.Length - 1);
//bool inv = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_Other_Domestic_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteActive")
// .Append("tri_Seed",hidSeed.Text)
// .Append("str",rowID)}).Update();
#endregion
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
if (dt != null)
{
//update cost(Qty,unit,total)
//ControlBinder.UpdateCostData(hidSeed.Text, "DM", "");
ControlBinder.pageTitleMsg(true, "Domestic Shipment:" + labLotNo.Text, "<p class=\"success\">Status : Record Saved with Lot No. <span>" + labLotNo.Text + "</span> </p>", div_bottom);
if (dt != null && dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0][0].ToString()))
{
X.Redirect("List.aspx?seed=" + dt.Rows[0][0]);
}
else
{
DataBinder();
}
}
else
{
ControlBinder.pageTitleMsg(false, "Domestic Shipment:" + labLotNo.Text, "<p class=\"error\">Status : Saved failed ! ! ! </p>", div_bottom);
}
txtMAWB.Focus(true);
}
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);
}
}
protected void btnSave_Click(object sender, DirectEventArgs e)
{
if (string.IsNullOrEmpty(txtHawb.Text))
{
div_bottom.Html = "<p class='error'> Save failed, HAWB can't be empty ! ! !</p>";
txtHawb.Focus(true);
return;
}
List <IFields> UpdateHAWB = new List <IFields>();
UpdateHAWB.Add(dal.CreateIFields().Append("Option", "UpdateHAWB")
.Append("air_Seed", hidSeed.Text)
.Append("air_ToMAWB", hidMAWB.Text)
.Append("air_LotNo", "")
.Append("air_HAWB", txtHawb.Text.Trim().ToUpper())
.Append("air_CompanyReferance", txtReference.Text.Trim().ToUpper())
.Append("imp_Clearance", txtClearance.Text.Trim().ToUpper())
.Append("air_Insurance", chkInsurance.Checked)
.Append("air_LocReceived", CmbReceipt.Value)
.Append("air_LocFinal", CmbFinalDest.Value)
.Append("air_Sales", CmbSalesman.Value)
.Append("air_DG", chkDG.Checked)
.Append("imp_Surrender", chkSurrender.Checked)
.Append("air_Shipper", CmbShipperCode.Value)
//.Append("air_Shipper", CmbShipperName.SelectedItem.Value)
.Append("air_Consignee", CmbConsignee.Value)
//.Append("air_Consignee", CmbConsigneeName.SelectedItem.Value)
.Append("air_PartyA", CmbNotify1.Value)
//.Append("air_PartyA", CmbNotify1Name.SelectedItem.Value)
.Append("air_PartyB", CmbNotify2.Value)
//.Append("air_PartyB", CmbNotify2Name.SelectedItem.Value)
.Append("air_CoLoader", CmbCoLoader.Value)
//.Append("air_CoLoader", CmbCoLoaderName.SelectedItem.Value)
.Append("air_Broker", CmbBroker.Value)
//.Append("air_Broker", CmbBrokerName.SelectedItem.Value)
.Append("air_GWT", string.IsNullOrEmpty(txtGWT.Text) ? DBNull.Value : (object)txtGWT.Text)
.Append("air_VWT", string.IsNullOrEmpty(txtVWT.Text) ? DBNull.Value : (object)txtVWT.Text)
.Append("air_CWT", string.IsNullOrEmpty(txtCWT.Text) ? DBNull.Value : (object)txtCWT.Text)
.Append("air_Piece", string.IsNullOrEmpty(txtPiece.Text) ? DBNull.Value : (object)txtPiece.Text)
.Append("air_Unit", CmbUnit.Value)
.Append("air_Pallet", string.IsNullOrEmpty(txtPallet.Text) ? DBNull.Value : (object)txtPallet.Text)
.Append("imp_Warehouse", CmbWarehouse.Value)
//.Append("imp_Warehouse", CmbWarehouseName.SelectedItem.Value)
.Append("imp_StorageFrom", ControlBinder.getDate(txtFreeStorageStart.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtFreeStorageStart.RawText))
.Append("imp_StorageTo", ControlBinder.getDate(txtFreeStorageEnd.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtFreeStorageEnd.RawText))
.Append("imp_FreeDays", NumFreeStorage.Text.Trim().ToUpper().StartsWith("-1") ? DBNull.Value : (object)NumFreeStorage.Text)
.Append("imp_PickupDate", ControlBinder.getDate(txtPickUp.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtPickUp.RawText))
.Append("air_Remark", txtRemark.Text.Trim())
.Append("code", FSecurityHelper.CurrentUserDataGET()[4].ToString() + SYS)
.Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("air_SYS", SYS)//FSecurityHelper.CurrentUserDataGET()[11].ToString()[0])
.Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
try
{
DataSet ds = GetDs("FW_AirImport_Joblist_SP", UpdateHAWB);
hidSeed.Text = ds.Tables[0].Rows[0][0].ToString();
string newFlag = ds.Tables[0].Rows[0][1].ToString();
#region LocalCosting
//X.AddScript("saveCost('" + hidSeed.Text + "');");
ucCost.costseed = hidSeed.Text;
ucCost.btnCostEvent(sender, e);
#endregion
#region ForeignInvoice
var ForeignInvoice = JSON.Deserialize <List <ForeignInvoice> >(e.ExtraParams["p_safety_2"]);
List <IFields> ForeignInvoicelist = new List <IFields>();
string ForeignInvoiceID = "";
for (int i = 0; i < ForeignInvoice.Count; ++i)
{
ForeignInvoicelist.Add(dal.CreateIFields().Append("Option", "Update").
Append("inv_Payment", ForeignInvoice[i].Kind.Trim().ToUpper()).
Append("inv_InvoiceDate", ControlBinder.getDate(ForeignInvoice[i].Date.ToString().StartsWith("0001") ? DBNull.Value : (object)ForeignInvoice[i].Date)).
Append("inv_InvoiceNo", ForeignInvoice[i].DN_CNNO.Trim().ToUpper()).
Append("inv_CompanyCode", ForeignInvoice[i].CompanyCode.Trim().ToUpper()).
Append("inv_CompanyName", ForeignInvoice[i].CompanyName.ToUpper()).
Append("inv_Currency", ForeignInvoice[i].Currency.Trim().ToUpper()).
Append("inv_Total", string.IsNullOrEmpty(ForeignInvoice[i].Amount) ? DBNull.Value : (object)ForeignInvoice[i].Amount).
Append("inv_RowID", ForeignInvoice[i].RowID)
.Append("inv_ToHouse", hidSeed.Text)
.Append("inv_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("inv_Sys", SYS)
.Append("inv_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
ForeignInvoiceID += "," + ForeignInvoice[i].RowID;
}
//delete
if (ForeignInvoiceID.Length > 1)
{
ForeignInvoiceID = ForeignInvoiceID.Substring(1, ForeignInvoiceID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActual").Append("inv_Seed", hidSeed.Text).Append("str", ForeignInvoiceID)
}).Update();
bool resultForeignInvoice = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", ForeignInvoicelist).Update();
#endregion
#region LocalDeliveryRoute
var LocalDeliveryRoute = JSON.Deserialize <List <LocalDeliveryRoute> >(e.ExtraParams["p_safety_3"]);
List <IFields> LocalDeliveryRoutelist = new List <IFields>();
string LocalDeliveryRouteID = "";
for (int i = 0; i < LocalDeliveryRoute.Count; ++i)
{
LocalDeliveryRoutelist.Add(dal.CreateIFields().Append("Option", "Update").
Append("sr_ShipKind", LocalDeliveryRoute[i].Kind.Trim().ToUpper()).
Append("sr_Carrier", LocalDeliveryRoute[i].CompanyCode.Trim().ToUpper()).
//Append("sr_Carrier", LocalDeliveryRoute[i].CompanyName).
Append("sr_To", LocalDeliveryRoute[i].Dest.Trim().ToUpper()).
Append("sr_Voyage", LocalDeliveryRoute[i].Voyage.Trim().ToUpper()).
Append("sr_ETD", ControlBinder.getDate(LocalDeliveryRoute[i].ETD.ToString().StartsWith("0001") ? DBNull.Value : (object)LocalDeliveryRoute[i].ETD)).
Append("sr_ETA", ControlBinder.getDate(LocalDeliveryRoute[i].ETA.ToString().StartsWith("0001") ? DBNull.Value : (object)LocalDeliveryRoute[i].ETA)).
Append("sr_RowID", LocalDeliveryRoute[i].RowID)
.Append("sr_ToHouse", hidSeed.Text)
.Append("sr_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("sr_Sys", SYS)
.Append("sr_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
LocalDeliveryRouteID += "," + LocalDeliveryRoute[i].RowID;
}
//delete
if (LocalDeliveryRouteID.Length > 1)
{
LocalDeliveryRouteID = LocalDeliveryRouteID.Substring(1, LocalDeliveryRouteID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentRoute_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActual").Append("sr_Seed", hidSeed.Text).Append("str", LocalDeliveryRouteID)
}).Update();
bool resultLocalDeliveryRoute = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentRoute_SP", LocalDeliveryRoutelist).Update();
#endregion
#region ContactInformation
var ContactInformation = JSON.Deserialize <List <ContactInformation> >(e.ExtraParams["p_safety_4"]);
List <IFields> ContactInformationlist = new List <IFields>();
string ContactinformationID = "";
for (int i = 0; i < ContactInformation.Count; ++i)
{
ContactInformationlist.Add(dal.CreateIFields().Append("Option", "Update").
Append("sc_Type", ContactInformation[i].Kind.Trim().ToUpper()).
Append("sc_Company", ContactInformation[i].CompanyCode.Trim().ToUpper()).
//Append("sc_Company", ContactInformation[i].CompanyName).
Append("sc_Dept", ContactInformation[i].Dept.Trim().ToUpper()).
Append("sc_RowID", ContactInformation[i].RowID)
.Append("sc_ToHouse", hidSeed.Text)
.Append("sc_Stat", FSecurityHelper.CurrentUserDataGET()[12].ToString())
.Append("sc_Sys", SYS)
.Append("sc_User", FSecurityHelper.CurrentUserDataGET()[0].ToString())
);
ContactinformationID += "," + ContactInformation[i].RowID;
}
//delete
if (ContactinformationID.Length > 1)
{
ContactinformationID = ContactinformationID.Substring(1, ContactinformationID.Length - 1);
}
dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentContact_SP", new List <IFields> {
dal.CreateIFields().Append("Option", "DeleteActual").Append("sc_Seed", hidSeed.Text).Append("str", ContactinformationID)
}).Update();
bool resultContactInformation = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_ShipmentContact_SP", ContactInformationlist).Update();
#endregion
//update cost(Qty,unit,total)
//ControlBinder.UpdateCostData(hidSeed.Text, "AI", "HAWB");
if (newFlag == "N")
{
ControlBinder.pageTitleMsg(true, "AI-H:" + labLotNo.Text, "<p class=\"success\">Status : Saved successfully ! ! ! </p>", div_bottom);
}
else
{
X.Redirect("hawb.aspx?seed=" + ds.Tables[0].Rows[0][0] + "&MAWB=" + hidMAWB.Value);
}
ControlBinder.pageTitleMsg(true, "AI-H:" + labLotNo.Text, "<p class=\"success\">Status : Saved successfully ! ! ! </p>", div_bottom);
}
catch
{
ControlBinder.pageTitleMsg(false, "AI-H:" + labLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data .</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);
}
}