protected void SaveJob() { try { ASPxGridView g = this.grid_Marking; ASPxTextBox houseId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; int Id = SafeValue.SafeInt(houseId.Text, 0); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(SeaExportMkg), "SequenceId='" + Id + "'"); SeaExportMkg mkg = C2.Manager.ORManager.GetObject(query) as SeaExportMkg; bool isNew = false; if (Id == 0) { isNew = true; mkg = new SeaExportMkg(); } ASPxDateEdit polEta = g.FindEditFormTemplateControl("date_PolEta") as ASPxDateEdit; mkg.PolEta = polEta.Date; ASPxDateEdit polClearDate = g.FindEditFormTemplateControl("date_PolClearDate") as ASPxDateEdit; mkg.PolClearDate = polClearDate.Date; ASPxDateEdit polReturnDate = g.FindEditFormTemplateControl("date_PolReturnDate") as ASPxDateEdit; mkg.PolReturnDate = polReturnDate.Date; ASPxDateEdit podEta = g.FindEditFormTemplateControl("date_PodEta") as ASPxDateEdit; mkg.PodEta = podEta.Date; ASPxDateEdit podClearDate = g.FindEditFormTemplateControl("date_PodClearDate") as ASPxDateEdit; mkg.PodClearDate = podClearDate.Date; ASPxDateEdit podReturnDate = g.FindEditFormTemplateControl("date_PodReturnDate") as ASPxDateEdit; mkg.PodReturnDate = podReturnDate.Date; ASPxMemo polRemark = g.FindEditFormTemplateControl("memo_PolRemark") as ASPxMemo; mkg.PolRemark = polRemark.Text; ASPxMemo podRemark = g.FindEditFormTemplateControl("memo_PodRemark") as ASPxMemo; mkg.PodRemark = podRemark.Text; if (isNew) { C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(mkg); houseId.Text = mkg.SequenceId.ToString(); //this.txt_JobNo.Text = tpt1.JobNo; Session["TptWhere"] = "SequenceId='" + mkg.SequenceId + "'"; this.dsMarking.FilterExpression = Session["TptWhere"].ToString(); if (this.grid_Marking.GetRow(0) != null) { this.grid_Marking.StartEdit(0); } } else { C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(mkg); } } catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); } }
private string Tranship(string impNo) { string user = HttpContext.Current.User.Identity.Name; //string pod = tPod.Text; string refN = SafeValue.SafeString(Request.QueryString["refNo"]); string sql = string.Format("select Pol,Pod,Vessel, Voyage, Eta, Etd, EtaDest from SeaExportRef where RefNo='{0}'", refN); DataTable tab_expRef = ConnectSql.GetTab(sql); if (tab_expRef.Rows.Count == 0) { return("Error"); } string pod = SafeValue.SafeString(tab_expRef.Rows[0]["Pod"]); string pol = SafeValue.SafeString(tab_expRef.Rows[0]["Pol"]); string polName = EzshipHelper.GetPortName(pol, "SINGAPORE"); string podName = EzshipHelper.GetPortName(pod, "SINGAPORE"); SeaExport exp = new SeaExport(); #region export info exp.AsAgent = "N"; string bkgNo = C2Setup.GetNextNo("ExportBooking"); string bkgNPrefix = "SIN"; if (pod.Length == 5) { bkgNPrefix += pod.Substring(2); } exp.BkgRefNo = bkgNPrefix + bkgNo; exp.CollectFrom = ""; exp.CreateBy = EzshipHelper.GetUserName(); exp.CreateDateTime = DateTime.Now; exp.CustomerId = ""; exp.ExpressBl = "N"; exp.FrtTerm = "FP"; exp.HaulierAttention = ""; exp.HaulierCollect = ""; exp.HaulierCrNo = ""; exp.HaulierName = ""; exp.HaulierRemark = ""; exp.HaulierTruck = ""; exp.HblNo = ""; exp.ImpCharge = 0; exp.JobNo = C2Setup.GetSubNo(refN, "SE"); exp.Marking = ""; exp.PermitRmk = ""; exp.PlaceDeliveryId = pod; exp.PlaceDeliveryName = podName; exp.PlaceDeliveryTerm = "CFS"; exp.PlaceDischargeName = podName; exp.PlaceLoadingName = polName; exp.PlaceReceiveId = pol; exp.PlaceReceiveName = polName; exp.PlaceReceiveTerm = "CFS"; exp.Pod = pod; exp.Pol = pol; exp.PreCarriage = ""; exp.RefNo = refN; exp.Remark = ""; exp.SAgentRemark = ""; exp.SConsigneeRemark = ""; exp.ShipLoadInd = "N"; exp.ShipOnBoardDate = DateTime.Today; exp.ShipOnBoardInd = "N"; exp.ShipperContact = ""; exp.ShipperEmail = ""; exp.ShipperFax = ""; exp.ShipperId = ""; exp.ShipperName = ""; exp.ShipperTel = ""; exp.SNotifyPartyRemark = ""; exp.SShipperRemark = ""; exp.StatusCode = "USE"; exp.SurrenderBl = "N"; exp.TsInd = "Y"; exp.TsJobNo = impNo; exp.UpdateBy = EzshipHelper.GetUserName(); exp.UpdateDateTime = DateTime.Now; string finDest = pod; decimal wt = 0; decimal m3 = 0; int qty = 0; string pkgType = ""; sql = string.Format(@"SELECT TsPod, TsPortFinName, TsVessel, TsVoyage, TsColoader, TsEtd, TsEta, TsAgentId, TsRemark, TsAgtRate, TsTotAgtRate, TsImpRate, TsTotImpRate,Weight,Volume,Qty,PackageType FROM SeaImport where JobNo='{0}'", impNo); DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0]; if (tab.Rows.Count > 0) { DataRow row = tab.Rows[0]; pod = row["TsPod"].ToString(); finDest = row["TsPortFinName"].ToString(); wt = SafeValue.SafeDecimal(row["Weight"], 0); m3 = SafeValue.SafeDecimal(row["Volume"], 0); qty = SafeValue.SafeInt(row["Qty"], 0); pkgType = row["PackageType"].ToString(); } exp.FinDest = finDest; exp.Weight = wt; exp.Volume = m3; exp.Qty = qty; exp.PackageType = pkgType; #endregion C2.Manager.ORManager.StartTracking(exp, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(exp); C2Setup.SetNextNo("ExportBooking", bkgNo); //create bkg #region booking and marking Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(SeaImportMkg), "JobNo='" + exp.TsJobNo + "'"); ObjectSet set_impMkgs = C2.Manager.ORManager.GetObjectSet(query); for (int m = 0; m < set_impMkgs.Count; m++) { C2.SeaImportMkg impMkg = set_impMkgs[m] as C2.SeaImportMkg; C2.SeaExportMkg mkg_bkg = new SeaExportMkg(); mkg_bkg.ContainerNo = ""; mkg_bkg.ContainerType = ""; mkg_bkg.Description = impMkg.Description; mkg_bkg.CreateDateTime = DateTime.Now; mkg_bkg.JobNo = exp.JobNo; mkg_bkg.Marking = impMkg.Marking; mkg_bkg.MkgType = "BKG"; mkg_bkg.PackageType = ""; mkg_bkg.Qty = impMkg.Qty; mkg_bkg.RefNo = exp.RefNo; mkg_bkg.Remark = impMkg.Remark; mkg_bkg.SealNo = ""; mkg_bkg.CreateBy = EzshipHelper.GetUserName(); mkg_bkg.Volume = impMkg.Volume; mkg_bkg.Weight = impMkg.Weight; C2.Manager.ORManager.StartTracking(mkg_bkg, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(mkg_bkg); C2.SeaExportMkg mkg = new SeaExportMkg(); mkg.ContainerNo = ""; mkg.ContainerType = ""; mkg.Description = impMkg.Description; mkg.CreateDateTime = DateTime.Now; mkg.JobNo = exp.JobNo; mkg.Marking = impMkg.Marking; mkg.MkgType = "BL"; mkg.PackageType = ""; mkg.Qty = impMkg.Qty; mkg.RefNo = exp.RefNo; mkg.Remark = impMkg.Remark; mkg.SealNo = ""; mkg.CreateBy = EzshipHelper.GetUserName(); mkg.Volume = impMkg.Volume; mkg.Weight = impMkg.Weight; C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(mkg); } #endregion //update import info DataRow row1 = tab_expRef.Rows[0]; string ves = row1["Vessel"].ToString(); string voy = row1["Voyage"].ToString(); DateTime eta = SafeValue.SafeDate(row1["Eta"], new DateTime(1900, 1, 1)); DateTime etd = SafeValue.SafeDate(row1["Etd"], new DateTime(1900, 1, 1)); // DateTime etaDest = SafeValue.SafeDate(row["EtaDest"], new DateTime(1900, 1, 1)); sql = string.Format("Update SeaImport Set TsVessel='{0}', TsVoyage='{1}', TsEtd='{2}', TsEta='{3}',TsSchNo='{4}', TsBkgNo='{5}', TsPortFinName='{6}',tsBkgId='{7}',TsJobNo='{9}',TsRefNo='{10}' where JobNo='{8}'", ves, voy, etd, eta, refN, exp.BkgRefNo, finDest, exp.SequenceId, impNo, exp.JobNo, exp.RefNo); int res = C2.Manager.ORManager.ExecuteCommand(sql); return("Success"); }