public new bool Add(string SortingLineCode, string DeliverLineCodes, string orderDate) { if (orderDate == string.Empty || orderDate == null) { orderDate = DateTime.Now.ToString("yyyyMMdd"); } else { orderDate = Convert.ToDateTime(orderDate).ToString("yyyyMMdd"); } var sortOder = SortOrderRepository.GetQueryable().Where(s => DeliverLineCodes.Contains(s.DeliverLineCode) && s.OrderDate == orderDate) .GroupBy(s => new { s.DeliverLineCode, s.OrderDate }) .Select(s => new { DeliverLineCode = s.Key.DeliverLineCode, OrderDate = s.Key.OrderDate }); foreach (var item in sortOder.ToArray()) { var sortOrderDispatch = new SortOrderDispatch(); sortOrderDispatch.SortingLineCode = SortingLineCode; sortOrderDispatch.DeliverLineCode = item.DeliverLineCode; sortOrderDispatch.WorkStatus = "1"; sortOrderDispatch.OrderDate = item.OrderDate; sortOrderDispatch.IsActive = "1"; sortOrderDispatch.UpdateTime = DateTime.Now; SortOrderDispatchRepository.Add(sortOrderDispatch); } SortOrderDispatchRepository.SaveChanges(); return(true); }
public bool Save(SortOrderDispatch sortDispatch) { var sortOrderDispatch = SortOrderDispatchRepository.GetQueryable().FirstOrDefault(s => s.ID == sortDispatch.ID); sortOrderDispatch.SortingLineCode = sortDispatch.SortingLineCode; sortOrderDispatch.DeliverLineCode = sortDispatch.DeliverLineCode; sortOrderDispatch.WorkStatus = "1"; sortOrderDispatch.OrderDate = sortDispatch.OrderDate; sortOrderDispatch.IsActive = sortDispatch.IsActive; sortOrderDispatch.UpdateTime = DateTime.Now; SortOrderDispatchRepository.SaveChanges(); return(true); }
public bool Delete(string id) { int ID = Convert.ToInt32(id); var sortOrderDispatch = SortOrderDispatchRepository.GetQueryable() .FirstOrDefault(s => s.ID == ID); if (sortOrderDispatch != null) { SortOrderDispatchRepository.Delete(sortOrderDispatch); SortOrderDispatchRepository.SaveChanges(); } else { return(false); } return(true); }
public new bool Add(string SortingLineCode, string DeliverLineCodes) { var sortOder = SortOrderRepository.GetQueryable().Where(s => DeliverLineCodes.Contains(s.DeliverLineCode)) .GroupBy(s => new { s.DeliverLineCode, s.OrderDate }) .Select(s => new { DeliverLineCode = s.Key.DeliverLineCode, OrderDate = s.Key.OrderDate }); foreach (var item in sortOder.ToArray()) { var sortOrderDispatch = new SortOrderDispatch(); sortOrderDispatch.SortingLineCode = SortingLineCode; sortOrderDispatch.DeliverLineCode = item.DeliverLineCode; sortOrderDispatch.WorkStatus = "1"; sortOrderDispatch.OrderDate = item.OrderDate; sortOrderDispatch.IsActive = "1"; sortOrderDispatch.UpdateTime = DateTime.Now; SortOrderDispatchRepository.Add(sortOrderDispatch); } SortOrderDispatchRepository.SaveChanges(); return(true); }