private int XmlSKUIDUpdateCommand(WMSContext dc, XElement update)
{
try
{
XNamespace ns = XDocument.Root.Name.Namespace;
foreach (var sk in update.Elements(ns + "SKUID"))
{
string key = sk.Element(ns + "ID").Value;
SKU_ID skuid = dc.SKU_IDs.Find(key);
if (skuid == null)
{
skuid = new SKU_ID {
ID = key
};
dc.SKU_IDs.Add(skuid);
}
skuid.Description = sk.Element(ns + "Description").Value;
skuid.DefaultQty = double.Parse(sk.Element(ns + "Quantity").Value, System.Globalization.NumberStyles.Any);
skuid.Unit = sk.Element(ns + "Unit").Value;
skuid.Weight = double.Parse(sk.Element(ns + "Weight").Value, System.Globalization.NumberStyles.Any);
skuid.Layout = int.Parse(sk.Element(ns + "Size").Element("Layout").Value);
skuid.Capacity = int.Parse(sk.Element(ns + "Size").Element("Capacity").Value);
skuid.Height = int.Parse(sk.Element(ns + "Size").Element("Height").Value);
}
return(0);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
SimpleLog.AddException(ex, nameof(XmlReadERPCommand));
throw;
}
}
public SKUIDViewModel()
{
_skuid = new SKU_ID();
Validator = new PropertyValidator();
ValidationEnabled = false;
AllowChangeIndex = false;
}
public override string BuildXml()
{
XElement el0 = null;
LoadSchema();
XDocument XDocument = new XDocument(new XDeclaration("1.0", "UTF-8", "yes"),
el0 = new XElement("Belgeler"));
XNamespace ns = XDocument.Root.Name.Namespace;
// belgeler
el0.Add(new XElement("Baslik"));
el0.Add(new XElement("Detaylar"));
// baslik
el0.Element(ns + "Baslik").Add(new XElement("BelgeKodu", XmlConvert.ToString(DocumentID)));
el0.Element(ns + "Baslik").Add(new XElement("Tesis", "Aksaray"));
using (var dc = new WMSContext())
{
foreach (var cmd in Commands)
{
if (cmd.Order_ID.HasValue)
{
Order order = dc.Orders.Find(cmd.Order_ID.Value);
SKU_ID skuid = dc.SKU_IDs.Find(order.SKU_ID);
TU tu = dc.TUs.FirstOrDefault(prop => prop.TU_ID == cmd.TU_ID);
// Detay
el0.Element(ns + "Detaylar").Add(new XElement("Detay"));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("BelgeKodu", XmlConvert.ToString(order.ERP_ID.HasValue ? order.SubOrderERPID: 0)));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("RefBelgeDetayNo"));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("UrunKod", tu.SKU_ID));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("Miktar", XmlConvert.ToString(tu.Qty)));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("Birim", skuid.Unit));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("NetAgirLik"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("AgirlikBirimi"));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("KaynakBatchNo", tu.Batch));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("HedefBatchNo"), tu.Batch);
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("SeriNo"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("KaynakLokasyon"));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("HedefLokasyon", order.Destination));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("KaynakStatus"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("HedefStatu"));
(el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("PaletNo", $"{cmd.TU_ID:d9}"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("Po"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("PoLine"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("SKT"));
// (el0.Element(ns + "Detaylar").LastNode as XElement).Add(new XElement("URT"));
}
}
}
return(XDocument.ToString());
}
