private string AddDoDet2(string id, string doNo, string doType, string location, string sku, string lotNo, string des, decimal price, int qty1, int qty2, int qty3, string uom1, string uom2, string uom3, string uom4, int qtyPackWhole, int qtyWholeLoose, int qtyLooseBase, string att1, string att2, string att3, string att4, string att5, string att6, string packing, string partyId, string partyName, DateTime doDate) { WhDoDet2 det = new WhDoDet2(); det.DoNo = ""; det.DoType = doType; det.Product = sku; det.Location = location; det.DoDate = doDate;// de_TransferDate.Date; det.LotNo = lotNo; det.Des1 = des; det.Price = price; //det.PkgType = ""; det.Qty1 = qty1; det.Qty2 = qty2; det.Qty3 = qty3; det.Uom1 = uom1; det.Uom2 = uom2; det.Uom3 = uom3; det.Uom4 = uom4; det.QtyPackWhole = qtyPackWhole; det.QtyWholeLoose = qtyWholeLoose; det.QtyLooseBase = qtyLooseBase; det.IsSch = false; det.LastSchQty1 = qty1; det.LastSchQty2 = qty2; det.LastSchQty3 = qty3; det.PreQty1 = qty1; det.PreQty2 = qty2; det.PreQty3 = qty3; det.Att1 = att1; det.Att2 = att2; det.Att3 = att3; det.Att4 = att4; det.Att5 = att5; det.Att6 = att6; det.Packing = packing; det.PartyId = partyId; det.PartyName = partyName; det.CreateBy = EzshipHelper.GetUserName(); det.CreateDateTime = DateTime.Now; det.UpdateBy = EzshipHelper.GetUserName(); det.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(det); return(SafeValue.SafeString(det.Id)); }
public static string Import_Order(string filePath) { XmlDocument xmlDoc = new XmlDocument(); string doNo = ""; string doType = ""; if (filePath.Length > 0) { xmlDoc.Load(filePath); if (xmlDoc.SelectSingleNode("Order") != null) { XmlElement elem = (XmlElement)xmlDoc.SelectSingleNode("Order"); string id = SafeValue.SafeString(elem.GetAttribute("Id")); string relaId = SafeValue.SafeString(elem.GetAttribute("RelaId")); bool isNew = false; WhDo whDo = null; if (id.Length > 0 && relaId.Length == 0)// from company to warehouse { Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhDo), "RelaId='" + id + "'"); whDo = C2.Manager.ORManager.GetObject(query) as WhDo; if (whDo == null) { isNew = true; whDo = new WhDo(); whDo.RelaId = id; whDo.DoDate = DateTime.Today; whDo.PartyId = SafeValue.SafeString(elem.GetAttribute("PartyId")); //whDo.PartyId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("PartyId"))); whDo.PartyName = SafeValue.SafeString(elem.GetAttribute("Party")); whDo.PartyAdd = SafeValue.SafeString(elem.GetAttribute("PartyAddress")); } } else if (id.Length > 0 && relaId.Length > 0)// from warehouse to company { Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhDo), "Id='" + relaId + "'"); whDo = C2.Manager.ORManager.GetObject(query) as WhDo; if (whDo == null) { return(""); //isNew = true; //whDo = new WhDo(); //whDo.RelatId = id; } } else { return(""); } doType = "IN"; string runType = "DOIN";//SIF/SIL/SIC if (SafeValue.SafeString(elem.GetAttribute("OrderType")) == "OUT") { doType = "OUT"; runType = "DOOUT"; } #region ref whDo.PoNo = SafeValue.SafeString(elem.GetAttribute("PoNo")); whDo.PoDate = SafeValue.SafeDate(elem.GetAttribute("PoDate"), DateTime.Today); //whDo.PartyId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Party"))); //whDo.PartyName = SafeValue.SafeString(elem.GetAttribute("Party")); //whDo.PartyAdd = SafeValue.SafeString(elem.GetAttribute("PartyAddress")); //whDo.PartyPostalcode = SafeValue.SafeString(elem.GetAttribute("PartyPostal")); //whDo.PartyCity = SafeValue.SafeString(elem.GetAttribute("PartyCity")); //whDo.PartyCountry = SafeValue.SafeString(elem.GetAttribute("PartyCountry")); whDo.Priority = SafeValue.SafeString(elem.GetAttribute("Type")); whDo.ExpectedDate = SafeValue.SafeDate(elem.GetAttribute("ExpectedDate"), DateTime.Today); whDo.DoStatus = SafeValue.SafeString(elem.GetAttribute("DoStatus")); whDo.Remark1 = SafeValue.SafeString(elem.GetAttribute("Remark1")); whDo.Remark2 = SafeValue.SafeString(elem.GetAttribute("Remark2")); whDo.CollectFrom = SafeValue.SafeString(elem.GetAttribute("PickFrom")); whDo.DeliveryTo = SafeValue.SafeString(elem.GetAttribute("DeliveryTo")); //whDo.CustomerReference = SafeValue.SafeString(elem.GetAttribute("CustomsRef")); //whDo.CustomerDate= SafeValue.SafeDate(elem.GetAttribute("RefDate"), new DateTime(1753, 1, 1)); whDo.CustomerReference = SafeValue.SafeString(elem.GetAttribute("OrderNo")); whDo.CustomerDate = SafeValue.SafeDate(elem.GetAttribute("OrderDate"), new DateTime(1753, 1, 1)); whDo.PartyInvNo = SafeValue.SafeString(elem.GetAttribute("PartyInvNo")); whDo.PartyInvDate = SafeValue.SafeDate(elem.GetAttribute("PartyInvDate"), new DateTime(1753, 5, 1)); //permit no whDo.PermitNo = SafeValue.SafeString(elem.GetAttribute("PermitNo")); whDo.PermitApprovalDate = SafeValue.SafeDate(elem.GetAttribute("PermitApprovalDate"), new DateTime(1753, 5, 1)); whDo.TptMode = SafeValue.SafeString(elem.GetAttribute("TptMode")); whDo.PalletizedInd = SafeValue.SafeBool(elem.GetAttribute("PalletizedInd"), true); whDo.EquipNo = SafeValue.SafeString(elem.GetAttribute("EquipNo")); whDo.Personnel = SafeValue.SafeString(elem.GetAttribute("Personnel")); //shipment whDo.Vessel = SafeValue.SafeString(elem.GetAttribute("Vessel")); whDo.Voyage = SafeValue.SafeString(elem.GetAttribute("Voyage")); whDo.Obl = SafeValue.SafeString(elem.GetAttribute("OceanBl")); whDo.Hbl = SafeValue.SafeString(elem.GetAttribute("HouseBl")); whDo.Pol = SafeValue.SafeString(elem.GetAttribute("Pol")); whDo.Pod = SafeValue.SafeString(elem.GetAttribute("Pod")); whDo.Eta = SafeValue.SafeDate(elem.GetAttribute("Eta"), new DateTime(1753, 1, 1)); whDo.Etd = SafeValue.SafeDate(elem.GetAttribute("Etd"), new DateTime(1753, 1, 1)); whDo.EtaDest = SafeValue.SafeDate(elem.GetAttribute("EtaDest"), new DateTime(1753, 1, 1)); whDo.Vehicle = SafeValue.SafeString(elem.GetAttribute("Vehicle")); whDo.Coo = SafeValue.SafeString(elem.GetAttribute("Coo")); whDo.Carrier = SafeValue.SafeString(elem.GetAttribute("Carrier")); //party whDo.AgentId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Agent"))); whDo.AgentName = SafeValue.SafeString(elem.GetAttribute("Agent")); whDo.AgentZip = SafeValue.SafeString(elem.GetAttribute("AgentZip")); whDo.AgentAdd = SafeValue.SafeString(elem.GetAttribute("AgentAddress")); whDo.AgentTel = SafeValue.SafeString(elem.GetAttribute("AgentTel")); whDo.AgentContact = SafeValue.SafeString(elem.GetAttribute("AgentContact")); whDo.AgentCountry = SafeValue.SafeString(elem.GetAttribute("AgentCountry")); whDo.AgentCity = SafeValue.SafeString(elem.GetAttribute("AgentCity")); whDo.NotifyId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Notify"))); whDo.NotifyName = SafeValue.SafeString(elem.GetAttribute("Notify")); whDo.NotifyZip = SafeValue.SafeString(elem.GetAttribute("NotifyZip")); whDo.NotifyAdd = SafeValue.SafeString(elem.GetAttribute("NotifyAddress")); whDo.NotifyTel = SafeValue.SafeString(elem.GetAttribute("NotifyTel")); whDo.NotifyContact = SafeValue.SafeString(elem.GetAttribute("NotifyContact")); whDo.NotifyCountry = SafeValue.SafeString(elem.GetAttribute("NotifyCountry")); whDo.NotifyCity = SafeValue.SafeString(elem.GetAttribute("NotifyCity")); whDo.ConsigneeId = EzshipHelper.GetPartyId(SafeValue.SafeString(elem.GetAttribute("Cnee"))); whDo.ConsigneeName = SafeValue.SafeString(elem.GetAttribute("Cnee")); whDo.ConsigneeZip = SafeValue.SafeString(elem.GetAttribute("CneeZip")); whDo.ConsigneeAdd = SafeValue.SafeString(elem.GetAttribute("CneeAddress")); whDo.ConsigneeTel = SafeValue.SafeString(elem.GetAttribute("CneeTel")); whDo.ConsigneeContact = SafeValue.SafeString(elem.GetAttribute("CneeContact")); whDo.ConsigneeCountry = SafeValue.SafeString(elem.GetAttribute("CneeCountry")); whDo.ConsigneeCity = SafeValue.SafeString(elem.GetAttribute("CneeCity")); whDo.PermitBy = SafeValue.SafeString(elem.GetAttribute("PermitBy")); whDo.OtherPermit = SafeValue.SafeString(elem.GetAttribute("OtherPermit")); whDo.ModelType = SafeValue.SafeString(elem.GetAttribute("ModelType")); if (isNew) { doNo = C2Setup.GetNextNo("", runType, DateTime.Today); whDo.DoNo = doNo; whDo.DoType = doType; whDo.StatusCode = "USE"; whDo.CreateBy = EzshipHelper.GetUserName(); whDo.CreateDateTime = DateTime.Today; Manager.ORManager.StartTracking(whDo, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(whDo); C2Setup.SetNextNo("", runType, doNo, whDo.DoDate); } else { doNo = whDo.DoNo; whDo.UpdateBy = EzshipHelper.GetUserName(); whDo.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(whDo, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(whDo); } #endregion #region Delete if (!isNew) { string sql_del = string.Format(@"delete from Wh_DoDet where DoNo='{0}'", doNo); SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_del), 0); sql_del = string.Format(@"delete from Wh_DoDet2 where DoNo='{0}'", doNo); SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_del), 0); sql_del = string.Format(@"delete from Wh_DoDet3 where DoNo='{0}'", doNo); SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql_del), 0); } #endregion #region sku XmlNodeList nodeListCont = elem.SelectNodes("Sku"); foreach (XmlNode xnMkg in nodeListCont) { XmlElement elemSku = (XmlElement)xnMkg; if (elemSku.Name == "Sku") { WhDoDet det = new WhDoDet(); det.DoNo = doNo; det.DoType = doType; det.LotNo = SafeValue.SafeString(elemSku.GetAttribute("LotNo")); det.BatchNo = SafeValue.SafeString(elemSku.GetAttribute("BatchNo")); det.CustomsLot = SafeValue.SafeString(elemSku.GetAttribute("CustomsLot")); det.ProductCode = SafeValue.SafeString(elemSku.GetAttribute("Sku")); det.Des1 = SafeValue.SafeString(elemSku.GetAttribute("Des")); det.Qty1 = SafeValue.SafeInt(elemSku.GetAttribute("PackQty"), 0); det.Qty2 = SafeValue.SafeInt(elemSku.GetAttribute("WholeQty"), 0); det.Qty3 = SafeValue.SafeInt(elemSku.GetAttribute("LooseQty"), 0); det.Qty4 = SafeValue.SafeInt(elemSku.GetAttribute("Expected"), 0); det.Qty5 = SafeValue.SafeInt(elemSku.GetAttribute("Transit"), 0); det.QtyPackWhole = SafeValue.SafeInt(elemSku.GetAttribute("QtyPackWhole"), 0); det.QtyWholeLoose = SafeValue.SafeInt(elemSku.GetAttribute("QtyWholeLoose"), 0); det.QtyLooseBase = SafeValue.SafeInt(elemSku.GetAttribute("QtyLooseBase"), 0); det.Uom1 = SafeValue.SafeString(elemSku.GetAttribute("PackUom")); det.Uom2 = SafeValue.SafeString(elemSku.GetAttribute("WholeUom")); det.Uom3 = SafeValue.SafeString(elemSku.GetAttribute("LooseUom")); det.Uom4 = SafeValue.SafeString(elemSku.GetAttribute("BaseUom")); det.Att1 = SafeValue.SafeString(elemSku.GetAttribute("Att1")); det.Att2 = SafeValue.SafeString(elemSku.GetAttribute("Att2")); det.Att3 = SafeValue.SafeString(elemSku.GetAttribute("Att3")); det.Att4 = SafeValue.SafeString(elemSku.GetAttribute("Att4")); det.Att5 = SafeValue.SafeString(elemSku.GetAttribute("Att5")); det.Att6 = SafeValue.SafeString(elemSku.GetAttribute("Att6")); det.Att7 = SafeValue.SafeString(elemSku.GetAttribute("Att7")); det.Att8 = SafeValue.SafeString(elemSku.GetAttribute("Att8")); det.Att9 = SafeValue.SafeString(elemSku.GetAttribute("Att9")); det.Att10 = SafeValue.SafeString(elemSku.GetAttribute("Att10")); det.CreateBy = EzshipHelper.GetUserName(); det.CreateDateTime = DateTime.Now; det.UpdateBy = EzshipHelper.GetUserName(); det.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(det); } } #endregion #region PutAway XmlNodeList nodeListCont1 = elem.SelectNodes("PutAway"); foreach (XmlNode xnMkg in nodeListCont1) { XmlElement elemPutAway = (XmlElement)xnMkg; if (elemPutAway.Name == "PutAway") { WhDoDet2 det = new WhDoDet2(); det.DoNo = doNo; det.DoType = doType; det.LotNo = SafeValue.SafeString(elemPutAway.GetAttribute("LotNo")); det.Product = SafeValue.SafeString(elemPutAway.GetAttribute("Product")); det.Des1 = SafeValue.SafeString(elemPutAway.GetAttribute("Des")); det.BatchNo = SafeValue.SafeString(elemPutAway.GetAttribute("BatchNo")); det.CustomsLot = SafeValue.SafeString(elemPutAway.GetAttribute("CustomsLot")); det.Location = SafeValue.SafeString(elemPutAway.GetAttribute("Location")); det.ProcessStatus = SafeValue.SafeString(elemPutAway.GetAttribute("ProcessStatus")); det.Qty1 = SafeValue.SafeInt(elemPutAway.GetAttribute("PackQty"), 0); det.Qty2 = SafeValue.SafeInt(elemPutAway.GetAttribute("WholeQty"), 0); det.Qty3 = SafeValue.SafeInt(elemPutAway.GetAttribute("LooseQty"), 0); det.QtyPackWhole = SafeValue.SafeInt(elemPutAway.GetAttribute("QtyPackWhole"), 0); det.QtyWholeLoose = SafeValue.SafeInt(elemPutAway.GetAttribute("QtyWholeLoose"), 0); det.QtyLooseBase = SafeValue.SafeInt(elemPutAway.GetAttribute("QtyLooseBase"), 0); det.Uom1 = SafeValue.SafeString(elemPutAway.GetAttribute("PackUom")); det.Uom2 = SafeValue.SafeString(elemPutAway.GetAttribute("WholeUom")); det.Uom3 = SafeValue.SafeString(elemPutAway.GetAttribute("LooseUom")); det.Uom4 = SafeValue.SafeString(elemPutAway.GetAttribute("BaseUom")); det.Att1 = SafeValue.SafeString(elemPutAway.GetAttribute("Att1")); det.Att2 = SafeValue.SafeString(elemPutAway.GetAttribute("Att2")); det.Att3 = SafeValue.SafeString(elemPutAway.GetAttribute("Att3")); det.Att4 = SafeValue.SafeString(elemPutAway.GetAttribute("Att4")); det.Att5 = SafeValue.SafeString(elemPutAway.GetAttribute("Att5")); det.Att6 = SafeValue.SafeString(elemPutAway.GetAttribute("Att6")); det.Att7 = SafeValue.SafeString(elemPutAway.GetAttribute("Att7")); det.Att8 = SafeValue.SafeString(elemPutAway.GetAttribute("Att8")); det.Att9 = SafeValue.SafeString(elemPutAway.GetAttribute("Att9")); det.Att10 = SafeValue.SafeString(elemPutAway.GetAttribute("Att10")); det.CreateBy = EzshipHelper.GetUserName(); det.CreateDateTime = DateTime.Now; det.UpdateBy = EzshipHelper.GetUserName(); det.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(det); } } #endregion #region Container XmlNodeList nodeListCont2 = elem.SelectNodes("Container"); foreach (XmlNode xnMkg in nodeListCont2) { XmlElement elemContainer = (XmlElement)xnMkg; if (elemContainer.Name == "Container") { WhDoDet3 det = new WhDoDet3(); det.DoNo = doNo; det.DoType = doType; det.ContainerNo = SafeValue.SafeString(elemContainer.GetAttribute("ContainerNo")); det.ContainerType = SafeValue.SafeString(elemContainer.GetAttribute("ContainerType")); det.SealNo = SafeValue.SafeString(elemContainer.GetAttribute("SealNo")); det.Weight = SafeValue.SafeDecimal(elemContainer.GetAttribute("Weight")); det.M3 = SafeValue.SafeDecimal(elemContainer.GetAttribute("M3")); det.Qty = SafeValue.SafeInt(elemContainer.GetAttribute("Qty"), 0); det.PkgType = SafeValue.SafeString(elemContainer.GetAttribute("PkgType")); det.CreateBy = EzshipHelper.GetUserName(); det.CreateDateTime = DateTime.Now; det.UpdateBy = EzshipHelper.GetUserName(); det.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(det); } } #endregion } } return("Type=" + doType + " , " + "No=" + doNo); }