private void ClearControls() { txtHawb.Text = ""; CmbService.setValue(""); CmbPPD.SelectedItem.Value = ""; CmbSalesman.setValue(""); txtColoader.Text = ""; txtReference.Text = ""; txtClearance.Text = ""; txtDO.Text = ""; CmbReceipt.setValue(""); CmbFinalDest.setValue(""); chkInsurance.Checked = false; chkDG.Checked = false; chkSurrender.Checked = false; CmbShipperCode.setValue(""); //CmbShipperName.SelectedItem.Value = ""; CmbConsignee.setValue(""); //CmbConsigneeName.SelectedItem.Value = ""; CmbNotify1.setValue(""); //mbNotify1Name.SelectedItem.Value = ""; CmbNotify2.setValue(""); //CmbNotify2Name.SelectedItem.Value = ""; CmbCoLoader.setValue(""); //CmbCoLoaderName.SelectedItem.Value = ""; CmbBroker.setValue(""); //CmbBrokerName.SelectedItem.Value = ""; txtGWT.Text = ""; txtCWT.Text = ""; txtCBM.Text = ""; txtPiece.Text = ""; CmbUnit.setValue(""); txtContainer.Text = ""; CmbWarehouse.setValue(""); //CmbWarehouseName.SelectedItem.Value = ""; txtFreeStorageStart.Text = ""; txtFreeStorageEnd.Text = ""; txtPickUp.Text = ""; //CmbCompany.Text = ""; // CmbCompanyName.Text = ""; //CmbCurrency.Text = ""; txtRemark.Text = ""; }
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(CmbReceipt.Value.Trim())) { div_bottom.Html = "<p class='error'> Save failed, From can't be empty!</p>"; CmbReceipt.Focus(); return; } if (string.IsNullOrEmpty(CmbFinalDest.Value.Trim())) { div_bottom.Html = "<p class='error'> Save failed, To can't be empty!</p>"; CmbFinalDest.Focus(); return; } if (string.IsNullOrEmpty(txtEst.RawText.Trim())) { div_bottom.Html = "<p class='error'> Save failed, Est Receipt can't be empty!</p>"; txtEst.Focus(true); return; } 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 (string.IsNullOrEmpty(CmbSalesman.Value.Trim())) { div_bottom.Html = "<p class='error'> Save failed, Salesman can't be empty!</p>"; CmbSalesman.Focus(); return; } if (string.IsNullOrEmpty(txtPiece.Text.Trim())) { div_bottom.Html = "<p class='error'> Save failed, Piece(s) can't be empty!</p>"; txtPiece.Focus(true); return; } List <IFields> UpdateHAWB = new List <IFields>(); UpdateHAWB.Add(dal.CreateIFields().Append("Option", "Update") .Append("air_Seed", hidSeed.Text == ""?null:hidSeed.Text) .Append("air_ToMAWB", hidMAWB.Text == ""?null:hidMAWB.Text) .Append("air_HAWB", txtHawb.Text.Trim().ToUpper()) .Append("air_CompanyReferance", txtReference.Text.Trim().ToUpper()) .Append("air_SpecicalDeal", chkSpecial.Checked ? "Y" : "N") .Append("air_LocReceived", CmbReceipt.Value) .Append("air_LocFinal", CmbFinalDest.Value) .Append("air_EReceipt", ControlBinder.getDate(txtEst.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtEst.RawText.Trim())) .Append("air_AReceipt", ControlBinder.getDate(txtAct.RawText.Trim().ToUpper().StartsWith("0001") ? DBNull.Value : (object)txtAct.RawText.Trim())) .Append("air_Sales", CmbSalesman.Value) //.Append("air_CSMode",txtCS.Text) .Append("air_NP", CmbNP.SelectedItem.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_PartyA", CmbNotify1.Value) //.Append("air_PartyA", CmbNotify1Name.SelectedItem.Value) .Append("air_PartyB", CmbNotify2.Value) //.Append("air_PartyB", CmbNotify2Name.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("air_CBM", string.IsNullOrEmpty(txtCbf.Text) ? DBNull.Value : (object)txtCbf.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("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()) ); try { DataSet ds = GetDs("FW_AirExport_SubShipment_SP", UpdateHAWB); hidSeed.Text = ds.Tables[0].Rows[0][0].ToString(); string newFlag = ds.Tables[0].Rows[0][1].ToString(); #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_ToHAWB", hidSeed.Text)); RowID += "," + HAWBList[i].RowID.ToString(); } bool result = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_SubShipment_SP", new List <IFields> { dal.CreateIFields().Append("Option", "AddSubShipmentByIDList") .Append("str", RowID).Append("User", FSecurityHelper.CurrentUserDataGET()[0].ToString()).Append("air_ToHAWB", hidSeed.Text) }).Update(); dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_SubShipment_SP", HAWBLists).Update(); #endregion #region Costing //X.AddScript("saveCost('" + hidSeed.Text + "');"); ucCost.costseed = hidSeed.Text; ucCost.btnCostEvent(sender, e); #endregion #region LocalInvoice //var InvocieList = JSON.Deserialize<List<Invocie>>(e.ExtraParams["p_safety_invoice"]); //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_SubShipment_SP", new List<IFields>() { dal.CreateIFields().Append("Option", "DeleteInvoice") //.Append("air_ToHAWB",hidSeed.Text) //.Append("str",InvoiceID)}).Update(); #endregion //update cost(Qty,unit,total) //ControlBinder.UpdateCostData(hidSeed.Text, "AE", "HAWB"); if (newFlag == "N") { DataBindList(); X.AddScript("if(window.opener!=null){if(typeof(window.opener.RefreshList)!='undefined'){window.opener.RefreshList();}}"); ControlBinder.pageTitleMsg(false, "AE-H:" + 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, "AE-H:" + hidLotNo.Text, "<p class=\"success\">Status : Save successfully ! </p>", div_bottom); X.Redirect("List.aspx?seed=" + ds.Tables[0].Rows[0][0] + "&MAWB=" + hidMAWB.Value); } } catch { ControlBinder.pageTitleMsg(false, "AE-H:" + hidLotNo.Text, "<p class=\"error\">Status : Save failed, please check the data !</p>", div_bottom); } }
private void DataBindList() { CmbUnit.setValue("PKG"); List <IFields> Getlist = new List <IFields>(); Getlist.Add(dal.CreateIFields().Append("Option", "List") .Append("seed", hidSeed.Text) .Append("o_ToMBL", Request["MBL"]) .Append("STAT", FSecurityHelper.CurrentUserDataGET()[12]) .Append("SYS", SYS) ); DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_HBL_SP", Getlist).GetList(); if (ds != null && ds.Tables[0].Rows.Count > 0) { txtHawb.Text = ds.Tables[0].Rows[0]["HBL"].ToString(); CmbService.setValue(ds.Tables[0].Rows[0]["ServiceMode"]); CmbPPD.SelectedItem.Value = ds.Tables[0].Rows[0]["PPD"].ToString(); CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"]); labImpLotNo.Text = ds.Tables[0].Rows[0]["LotNo"].ToString(); txtColoader.Text = ds.Tables[0].Rows[0]["ColoaderHBL"].ToString(); txtReference.Text = ds.Tables[0].Rows[0]["Reference"].ToString(); txtClearance.Text = ds.Tables[0].Rows[0]["Clearance"].ToString(); txtDO.Text = ds.Tables[0].Rows[0]["DO"].ToString(); labMBL.Text = ds.Tables[0].Rows[0]["MBL"].ToString(); CmbReceipt.setValue(ds.Tables[0].Rows[0]["Receipt"]); CmbFinalDest.setValue(ds.Tables[0].Rows[0]["FinalDest"].ToString()); chkInsurance.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Insurance"]); chkDG.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["DG"]); chkSurrender.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["Surrender"]); CmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString()); CmbShipperCode.Text = ds.Tables[0].Rows[0]["ShipperName"].ToString(); CmbConsignee.setValue(ds.Tables[0].Rows[0]["Consignee"].ToString()); CmbConsignee.Text = ds.Tables[0].Rows[0]["ConsigneeName"].ToString(); CmbNotify1.setValue(ds.Tables[0].Rows[0]["Notify1"].ToString()); CmbNotify1.Text = ds.Tables[0].Rows[0]["Notify1Name"].ToString(); CmbNotify2.setValue(ds.Tables[0].Rows[0]["Notify2"].ToString()); CmbNotify2.Text = ds.Tables[0].Rows[0]["Notify2Name"].ToString(); CmbCoLoader.setValue(ds.Tables[0].Rows[0]["Coloader"].ToString()); CmbCoLoader.Text = ds.Tables[0].Rows[0]["ColoaderName"].ToString(); CmbBroker.setValue(ds.Tables[0].Rows[0]["Broker"].ToString()); CmbBroker.Text = ds.Tables[0].Rows[0]["BrokerName"].ToString(); //if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString())) // txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString(); //if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CWT"].ToString())) // txtCWT.Text = ds.Tables[0].Rows[0]["CWT"].ToString(); //if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CBM"].ToString())) // txtCBM.Text = ds.Tables[0].Rows[0]["CBM"].ToString(); //if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Piece"].ToString())) // txtPiece.Text = ds.Tables[0].Rows[0]["Piece"].ToString(); if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString())) { txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["AWT"].ToString())) { txtAGWT.Text = ds.Tables[0].Rows[0]["AWT"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CBM"].ToString())) { txtCBM.Text = ds.Tables[0].Rows[0]["CBM"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["ACBM"].ToString())) { txtACBM.Text = ds.Tables[0].Rows[0]["ACBM"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["PKGS"].ToString())) { txtPiece.Text = ds.Tables[0].Rows[0]["PKGS"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["APKGS"].ToString())) { txtAPiece.Text = ds.Tables[0].Rows[0]["APKGS"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["WM"].ToString())) { txtCWT.Text = ds.Tables[0].Rows[0]["WM"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["AWM"].ToString())) { txtAWM.Text = ds.Tables[0].Rows[0]["AWM"].ToString(); } CmbUnit.setValue(ds.Tables[0].Rows[0]["Unit"].ToString()); if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Container"].ToString())) { txtContainer.Text = ds.Tables[0].Rows[0]["Container"].ToString(); } CmbWarehouse.setValue(ds.Tables[0].Rows[0]["Warehouse"].ToString()); CmbWarehouse.Text = ds.Tables[0].Rows[0]["WarehouseName"].ToString(); txtFreeStorageStart.Text = ds.Tables[0].Rows[0]["FreeStorageStart"].ToString(); txtFreeStorageEnd.Text = ds.Tables[0].Rows[0]["FreeStorageEnd"].ToString(); txtPickUp.Text = ds.Tables[0].Rows[0]["PickUp"].ToString(); txtRemark.Text = ds.Tables[0].Rows[0]["Remark"].ToString(); GridPanelInvoice.GetStore().DataSource = ds.Tables[1]; GridPanelInvoice.GetStore().DataBind(); GridPanelContainer.GetStore().DataSource = ds.Tables[2]; GridPanelContainer.GetStore().DataBind(); if (ds.Tables[2].Rows.Count > 0) { double GWT = 0.000, Pieces = 0, CBM = 0.000, wm = 0.000; for (int i = 0; i < ds.Tables[2].Rows.Count; i++) { GWT += Convert.ToDouble(ds.Tables[2].Rows[i]["GWT"].ToString() == "" ? "0.000" : ds.Tables[2].Rows[i]["GWT"].ToString()); Pieces += Convert.ToDouble(ds.Tables[2].Rows[i]["PKGS"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["PKGS"].ToString()); CBM += Convert.ToDouble(ds.Tables[2].Rows[i]["CBM"].ToString() == "" ? "0.000" : ds.Tables[2].Rows[i]["CBM"].ToString()); wm += Convert.ToDouble(ds.Tables[2].Rows[i]["WM"].ToString() == "" ? "0.000" : ds.Tables[2].Rows[i]["WM"].ToString()); } if (Pieces.ToString() != "0") { txtAPiece.Text = Pieces.ToString(); } if (GWT.ToString() != "0") { txtAGWT.Text = GWT.ToString(); } if (CBM.ToString() != "0") { txtACBM.Text = CBM.ToString(); } if (wm.ToString() != "0") { txtAWM.Text = wm.ToString(); } } if (Convert.ToBoolean(ds.Tables[0].Rows[0]["active"])) { img_void.Style.Value = "display:none"; } else { img_void.Style.Value = "display:inline"; btnSave.Disabled = true; btnCancel.Disabled = true; btnNext.Disabled = true; btnVoid.Text = "Active"; hidVoid.Text = "1"; X.AddScript("$('#showContainer').hide();"); } GridPanelOther.GetStore().DataSource = ds.Tables[3]; GridPanelOther.GetStore().DataBind(); GridPanelForeign.GetStore().DataSource = ds.Tables[5]; GridPanelForeign.GetStore().DataBind(); GridPanelRoute.GetStore().DataSource = ds.Tables[6]; GridPanelRoute.GetStore().DataBind(); GridPanelContact.GetStore().DataSource = ds.Tables[7]; GridPanelContact.GetStore().DataBind(); } if (!string.IsNullOrEmpty(Request["seed"])) { ControlBinder.pageTitleMsg(false, "OI-H:" + labImpLotNo.Text, "<p>Status : Edit HBL of <span>" + labImpLotNo.Text + "</span>. </p>", div_bottom); } else { ControlBinder.pageTitleMsg(false, "OI-H New", "<p>Status : New Blank HBL . </p>", div_bottom); } txtHawb.Focus(true); }
private void DataBindList() { txtHawb.Focus(true); List <IFields> Getlist = new List <IFields>(); Getlist.Add(dal.CreateIFields().Append("Option", "GetSubShipment") .Append("air_Seed", hidSeed.Text == ""?null:hidSeed.Text) .Append("str", hidIDList.Text) .Append("air_STAT", FSecurityHelper.CurrentUserDataGET()[12]) .Append("air_SYS", sys) ); DataSet ds = GetDs("FW_AirExport_SubShipment_SP", Getlist); if (ds != null && ds.Tables[0].Rows.Count > 0 && hidSeed.Text != "0" && hidSeed.Text != "") { string tempmawb = ds.Tables[0].Rows[0]["MAWB"].ToString().ToUpper() == "" ? "" : "MAWB# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["MAWB"].ToString().ToUpper() + "</span>"; string tempLotNo = ds.Tables[0].Rows[0]["LotNo"].ToString().ToUpper() == "" ? "" : "Lot# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["LotNo"].ToString().ToUpper() + "</span>"; labHeader.Html = "Book# " + "<span style='color:#ff0000;'>" + ds.Tables[0].Rows[0]["BookNo"].ToString().ToUpper() + "</span>" + (tempmawb == "" ? "" : "<span style='padding-left:10px'>" + tempmawb + "</span>") + (tempLotNo == "" ? "" : "<span style='padding-left:10px'>" + tempLotNo + "</span>"); hidLotNo.Text = ds.Tables[0].Rows[0]["BookNo"].ToString(); txtHawb.Text = ds.Tables[0].Rows[0]["HAWB"].ToString(); txtReference.Text = ds.Tables[0].Rows[0]["Reference"].ToString(); chkSpecial.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["SpecicalDeal"].ToString() == "N" ? 0 : 1); CmbReceipt.setValue(ds.Tables[0].Rows[0]["Receipt"].ToString()); CmbFinalDest.setValue(ds.Tables[0].Rows[0]["Destination"].ToString()); CmbSalesman.setValue(ds.Tables[0].Rows[0]["Salesman"].ToString()); txtEst.Text = ds.Tables[0].Rows[0]["EstReceipt"].ToString(); txtAct.Text = ds.Tables[0].Rows[0]["ActReceipt"].ToString(); txtCS.Text = ds.Tables[0].Rows[0]["air_User"].ToString(); CmbNP.SelectedItem.Value = ds.Tables[0].Rows[0]["NP"].ToString(); CmbShipperCode.setValue(ds.Tables[0].Rows[0]["Shipper"].ToString()); CmbShipperCode.Text = ds.Tables[0].Rows[0]["ShipperName"].ToString(); CmbConsignee.setValue(ds.Tables[0].Rows[0]["Consignee"].ToString()); CmbConsignee.Text = ds.Tables[0].Rows[0]["ConsigneeName"].ToString(); CmbNotify1.setValue(ds.Tables[0].Rows[0]["Notify1"].ToString()); CmbNotify1.Text = ds.Tables[0].Rows[0]["Notify1Name"].ToString(); CmbNotify2.setValue(ds.Tables[0].Rows[0]["Notify2"].ToString()); CmbNotify2.Text = ds.Tables[0].Rows[0]["Notify2Name"].ToString(); if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["GWT"].ToString())) { txtGWT.Text = ds.Tables[0].Rows[0]["GWT"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["VWT"].ToString())) { txtVWT.Text = ds.Tables[0].Rows[0]["VWT"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CWT"].ToString())) { txtCWT.Text = ds.Tables[0].Rows[0]["CWT"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Piece"].ToString())) { txtPiece.Text = ds.Tables[0].Rows[0]["Piece"].ToString(); } CmbUnit.setValue(ds.Tables[0].Rows[0]["Unit"].ToString()); if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Pallet"].ToString())) { txtPallet.Text = ds.Tables[0].Rows[0]["Pallet"].ToString(); } if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["CBF"].ToString())) { txtCbf.Text = ds.Tables[0].Rows[0]["CBF"].ToString(); } bool ismakehawb = ds.Tables[0].Rows[0]["air_MakeHAWB"].ToString() == "" ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["air_MakeHAWB"]); if (ismakehawb == true) { txtGWT.Disabled = true; txtVWT.Disabled = true; txtCWT.Disabled = true; txtPiece.Disabled = true; } else { txtGWT.Disabled = false; txtVWT.Disabled = false; txtCWT.Disabled = false; txtPiece.Disabled = false; } if (ds.Tables[0].Rows[0]["Active"].ToString() == "Y") { img_void.Style.Value = "display:none"; } else { img_void.Style.Value = "display:inline"; btnSave.Disabled = true; btnCancel.Disabled = true; btnPull.Disabled = true; btnNew.Disabled = true; btnVoid.Text = "Active"; hidVoid.Text = "1"; } if (ds.Tables[1].Rows.Count > 0) { gpHAWB.GetStore().DataSource = ds.Tables[1]; gpHAWB.GetStore().DataBind(); double GWT = 0, VWT = 0, CWT = 0, Pieces = 0, Pallets = 0; for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["GWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["GWT"].ToString()); VWT += Convert.ToDouble(ds.Tables[1].Rows[i]["VWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["VWT"].ToString()); CWT += Convert.ToDouble(ds.Tables[1].Rows[i]["CWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["CWT"].ToString()); Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["Piece"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Piece"].ToString()); Pallets += Convert.ToDouble(ds.Tables[1].Rows[i]["Pallet"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Pallet"].ToString()); } lblGWT.Text = GWT.ToString("0.000"); lblVWT.Text = VWT.ToString("0.000"); lblCWT.Text = CWT.ToString("0.000"); lblPiece.Text = Pieces.ToString(); lblPallet.Text = Pallets.ToString(); } gpInvoice.GetStore().DataSource = ds.Tables[3]; gpInvoice.GetStore().DataBind(); ControlBinder.pageTitleMsg(false, "AE-H:" + hidLotNo.Text, "<p>Status : Edit HAWB of <span>" + hidLotNo.Text + "</span></p>", div_bottom); } else { if (ds.Tables[1].Rows.Count > 0) { gpHAWB.GetStore().DataSource = ds.Tables[1]; gpHAWB.GetStore().DataBind(); double GWT = 0, VWT = 0, CWT = 0, Pieces = 0, Pallets = 0; for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { GWT += Convert.ToDouble(ds.Tables[1].Rows[i]["GWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["GWT"].ToString()); VWT += Convert.ToDouble(ds.Tables[1].Rows[i]["VWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["VWT"].ToString()); CWT += Convert.ToDouble(ds.Tables[1].Rows[i]["CWT"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["CWT"].ToString()); Pieces += Convert.ToDouble(ds.Tables[1].Rows[i]["Piece"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Piece"].ToString()); Pallets += Convert.ToDouble(ds.Tables[1].Rows[i]["Pallet"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["Pallet"].ToString()); } lblGWT.Text = GWT.ToString("0.000"); lblVWT.Text = VWT.ToString("0.000"); lblCWT.Text = CWT.ToString("0.000"); lblPiece.Text = Pieces.ToString(); lblPallet.Text = Pallets.ToString(); txtGWT.Text = lblGWT.Text; txtVWT.Text = lblVWT.Text; txtCWT.Text = lblCWT.Text; txtPiece.Text = lblPiece.Text; txtPallet.Text = lblPallet.Text; } ControlBinder.pageTitleMsg(false, "AE-H New", "<p>Status : New Blank HAWB </p>", div_bottom); } }