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);
        }
Пример #2
0
        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);
        }