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 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); }