public Box GetCurrentBox(DirectLine directLine, int warehouseID, int methodID = 0) { MyHelp.Log("Box", null, string.Format("取得當前未出貨的{0} Box", directLine.Abbreviation), Session); boxData = db.Box.Where(b => b.IsEnable && !b.IsReserved && b.DirectLine.Equals(directLine.ID) && b.WarehouseFrom.Equals(warehouseID) && b.FirstMileMethod.Equals(methodID) && b.ShippingStatus.Equals((byte)EnumData.DirectLineStatus.未發貨)) .OrderByDescending(b => b.Create_at).FirstOrDefault(); if (boxData == null) { MyHelp.Log("Box", null, string.Format("開始建立【{0}】新Box", directLine.Abbreviation), Session); string boxID = string.Format("{0}-{1}", directLine.Abbreviation, TimeZoneConvert.Utc.ToString("yyyyMMdd")); int count = db.Box.AsNoTracking().Where(b => b.IsEnable && b.DirectLine.Equals(directLine.ID) && b.BoxID.Contains(boxID)).Select(b => b.MainBox).Distinct().Count() + 1; byte[] Byte = BitConverter.GetBytes(count); Byte[0] += 64; boxData = new Box() { IsEnable = true, BoxID = string.Format("{0}-{1}", boxID, System.Text.Encoding.ASCII.GetString(Byte.Take(1).ToArray())), DirectLine = directLine.ID, FirstMileMethod = methodID, WarehouseFrom = warehouseID, BoxType = (byte)EnumData.DirectLineBoxType.DirectLine, Create_at = TimeZoneConvert.Utc }; boxData.MainBox = boxData.BoxID; db.Entry(boxData).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); MyHelp.Log("Box", boxData.BoxID, string.Format("Box【{0}】建立完成", boxData.BoxID), Session); } return(boxData); }
public void SaveChanges() { try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } }
private void Sendle_Test(int OrderID) { var packageList = db.Box.Where(b => b.BoxID.Contains("ECOF-")).SelectMany(b => b.Packages.Where(p => p.IsEnable.Value)).ToList(); foreach (var package in packageList) { Sendle_API Sendle = new Sendle_API(package.Method.Carriers.CarrierAPI); var order = Sendle.Order(package.TagNo); package.TrackingNumber = order.sendle_reference; db.Entry(package).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); //Packages package = db.Packages.First(p => p.IsEnable.Value && p.OrderID.Value.Equals(OrderID)); //Sendle_API Sendle = new Sendle_API(package.Method.Carriers.CarrierAPI); //TrackOrder track = new TrackOrder(); //track.SetOrder(package.Orders, package); //var result = track.Track(); //var result = Sendle.Create(package); //var order = Sendle.Order(result.order_id); //Sendle.Label(result.order_id, string.Format("{0}-{1}-{2}", package.Items.First().ProductID, package.OrderID.Value, result.sendle_reference), @"C:\Users\qdtuk\Downloads"); //var track = Sendle.Track(package.TrackingNumber); //var cancel = Sendle.Cancel(result.order_id); }
public string Update_Tracking(Packages package) { string Message = ""; try { MyHelp.Log("Packages", package.ID, string.Format("訂單【{0}】包裹SC更新", package.OrderID), Session); if (!SCWS.Is_login) { throw new Exception("SC is not logged in!"); } OrderData orderData = SCWS.Get_OrderData(package.OrderID.Value); Order SC_order = orderData.Order; Package SC_package = SC_order.Packages.FirstOrDefault(p => p.ID.Equals(package.ID)); if (SC_package == null) { MyHelp.Log("Packages", package.ID, "Not find package on SC website!", Session); package.IsEnable = false; SC_package = SC_order.Packages.First(p => p.ID.Equals(SC_order.Items.First(i => i.ID.Equals(package.Items.First(ii => ii.IsEnable.Value).ID)).PackageID)); var newPackage = db.Packages.AsNoTracking().First(p => p.ID.Equals(package.ID)); newPackage.ID = SC_package.ID; db.Packages.Add(newPackage); foreach (var item in package.Items) { item.PackageID = newPackage.ID; } foreach (var pick in db.PickProduct.Where(pick => pick.PackageID.Value.Equals(package.ID))) { pick.PackageID = newPackage.ID; } if (package.Label != null) { package.Label.PackageID = newPackage.ID; } db.SaveChanges(); MyHelp.Log("Packages", package.ID, string.Format("Change package {0} to {1}", package.ID, newPackage.ID), Session); package = newPackage; } string carrier = ""; try { if (package.Method == null) { throw new Exception("Not find method!"); } if (package.Method.Carriers == null) { throw new Exception("Not find carrir"); } carrier = package.Method.Carriers.Name; } catch (Exception e) { MyHelp.Log("Packages", package.ID, e.Message, Session); carrier = db.ShippingMethod.Find(package.ShippingMethod.Value).Carriers.Name; } SCWS.Update_PackageShippingStatus(SC_package, (package.UploadTracking ? package.TrackingNumber : ""), carrier); if (db.Packages.AsNoTracking().Where(p => p.IsEnable.Value && p.OrderID.Value.Equals(package.OrderID.Value)).All(p => p.ProcessStatus.Equals((byte)EnumData.ProcessStatus.已出貨))) { if (SCWS.Update_OrderShippingStatus(SC_order, carrier)) { var updatePackage = db.Packages.Find(package.ID); updatePackage.WorkDays = 0; var paymentDate = new TimeZoneConvert(package.Orders.Payments.FirstOrDefault()?.AuditDate ?? package.Orders.TimeOfOrder.Value, EnumData.TimeZone.EST).Utc; var updateDate = DateTime.UtcNow; var checkPoint = new DateTime(paymentDate.Year, paymentDate.Month, paymentDate.Day, 7, 0, 0, DateTimeKind.Utc); do { if (paymentDate.CompareTo(checkPoint) < 0) { if (!checkPoint.DayOfWeek.Equals(DayOfWeek.Saturday) && !checkPoint.DayOfWeek.Equals(DayOfWeek.Sunday)) { updatePackage.WorkDays++; } } checkPoint = checkPoint.AddDays(1); } while (checkPoint.CompareTo(updateDate) < 0); db.SaveChanges(); MyHelp.Log("Packages", package.ID, string.Format("訂單【{0}】SC完成出貨", package.OrderID), Session); } } foreach (Items item in package.Items.Where(i => i.IsEnable.Value).ToList()) { if (item.SerialNumbers.Any()) { SCWS.Update_ItemSerialNumber(item.ID, item.SerialNumbers.Select(s => s.SerialNumber).ToArray()); } } Message = Sync_Order(package.OrderID.Value); } catch (Exception e) { string[] serials = package.Items.Where(i => i.IsEnable.Value).SelectMany(i => i.SerialNumbers.Select(s => s.SerialNumber)).ToArray(); MyHelp.ErrorLog(e, string.Format("訂單包裹【{0}】更新失敗: #serials {1}", package.OrderID, string.Join(",", serials)), package.OrderID.ToString()); Message = e.InnerException != null && !string.IsNullOrEmpty(e.InnerException.Message) ? e.InnerException.Message : e.Message; } return(Message); }