public Result PostSmartTaskOrder([FromBody] IEnumerable <SmartTaskOrder> taskOrders) { if (taskOrders == null || !taskOrders.Any()) { return(Result.GenError <Result>(Error.ParamError)); } if (taskOrders.Any(x => x.TaskOrder.IsNullOrEmpty())) { return(Result.GenError <Result>(Error.SmartTaskOrderNotEmpty)); } if (taskOrders.GroupBy(x => x.TaskOrder).Any(y => y.Count() > 1)) { return(Result.GenError <Result>(Error.SmartTaskOrderDuplicate)); } var wId = taskOrders.FirstOrDefault()?.WorkshopId ?? 0; var sames = taskOrders.Select(x => x.TaskOrder); if (SmartTaskOrderHelper.GetHaveSame(wId, sames)) { return(Result.GenError <Result>(Error.SmartTaskOrderIsExist)); } var userId = Request.GetIdentityInformation(); var markedDateTime = DateTime.Now; foreach (var taskOrder in taskOrders) { taskOrder.CreateUserId = userId; taskOrder.MarkedDateTime = markedDateTime; taskOrder.Remark = taskOrder.Remark ?? ""; } SmartTaskOrderHelper.Instance.Add(taskOrders); return(Result.GenError <Result>(Error.Success)); }
public DataResult GetSmartWorkOrder([FromQuery] int qId, int wId, bool menu) { var result = new DataResult(); if (menu) { var data = SmartWorkOrderHelper.GetMenu(qId, wId); if (qId != 0 && !data.Any()) { result.errno = Error.SmartWorkOrderNotExist; return(result); } result.datas.AddRange(data); } else { var data = SmartWorkOrderHelper.GetDetail(qId, wId).Select(ClassExtension.ParentCopyToChild <SmartWorkOrder, SmartWorkOrderDetail>); if (qId != 0 && !menu) { var d = data.First(); if (d.State != SmartWorkOrderState.未加工) { var taskOrders = SmartTaskOrderHelper.GetDetailByWorkOrderId(d.Id); var flowCards = SmartFlowCardHelper.GetSmartFlowCardsByTaskOrderIds(taskOrders.Select(x => x.Id)); var processes = SmartFlowCardProcessHelper.GetSmartFlowCardProcessesByFlowCardIds(flowCards.Select(x => x.Id)); if (processes.Any()) { var st = processes.Where(x => x.StartTime != default(DateTime)).Min(y => y.StartTime); var et = processes.Where(x => x.EndTime != default(DateTime)).Min(y => y.EndTime); if (d.State == SmartWorkOrderState.已完成 || d.State == SmartWorkOrderState.已取消) { d.Consume = (int)(et - st).TotalSeconds; } else { d.Consume = (int)(DateTime.Now - st).TotalSeconds; } } } } result.datas.AddRange(data); } if (qId != 0 && !result.datas.Any()) { result.errno = Error.SmartWorkOrderNotExist; return(result); } return(result); }
public Result PutSmartTaskOrder([FromBody] IEnumerable <SmartTaskOrder> taskOrders) { if (taskOrders == null || !taskOrders.Any()) { return(Result.GenError <Result>(Error.ParamError)); } if (taskOrders.Any(x => x.TaskOrder.IsNullOrEmpty())) { return(Result.GenError <Result>(Error.SmartTaskOrderNotEmpty)); } if (taskOrders.GroupBy(x => x.TaskOrder).Any(y => y.Count() > 1)) { return(Result.GenError <Result>(Error.SmartTaskOrderDuplicate)); } var wId = taskOrders.FirstOrDefault()?.WorkshopId ?? 0; var sames = taskOrders.Select(x => x.TaskOrder); var ids = taskOrders.Select(x => x.Id); if (SmartTaskOrderHelper.GetHaveSame(wId, sames, ids)) { return(Result.GenError <Result>(Error.SmartTaskOrderIsExist)); } var cnt = SmartTaskOrderHelper.Instance.GetCountByIds(ids); if (cnt != taskOrders.Count()) { return(Result.GenError <Result>(Error.SmartTaskOrderNotExist)); } var markedDateTime = DateTime.Now; foreach (var taskOrder in taskOrders) { taskOrder.MarkedDateTime = markedDateTime; taskOrder.Remark = taskOrder.Remark ?? ""; } SmartTaskOrderHelper.Instance.Update(taskOrders); return(Result.GenError <Result>(Error.Success)); }
public object PostSmartTaskOrderLevel([FromBody] IEnumerable <SmartTaskOrder> taskOrders) { if (taskOrders == null || !taskOrders.Any()) { return(Result.GenError <Result>(Error.ParamError)); } var wId = taskOrders.FirstOrDefault()?.WorkshopId ?? 0; var taskIds = taskOrders.GroupBy(x => x.Id).Select(y => y.Key); if (taskIds.Count() != taskOrders.Count()) { return(Result.GenError <Result>(Error.SmartTaskOrderDuplicate)); } var result = new DataResult(); var tOrders = SmartTaskOrderHelper.Instance.GetByIds <SmartTaskOrder>(taskIds); if (taskIds.Count() != tOrders.Count()) { result.errno = Error.SmartTaskOrderNotExist; result.datas.AddRange(taskOrders.Where(x => tOrders.All(y => y.Id != x.Id)).Select(x => x.TaskOrder)); return(result); } var notArranged = tOrders.Where(x => !x.Arranged); if (notArranged.Any()) { result.errno = Error.SmartTaskOrderNotArranged; result.datas.AddRange(notArranged.Select(x => x.TaskOrder)); return(result); } SmartTaskOrderHelper.ArrangedUpdate(taskOrders); return(Result.GenError <Result>(Error.Success)); }
public object GetArrangedTaskOrderPutAndWarehouse([FromQuery] int wId, DateTime startTime, DateTime endTime, DateTime deliveryTime, bool all) { var result = new SmartTaskOrderNeedOrderTimeResult(); if (startTime == default(DateTime) || endTime == default(DateTime)) { return(result); } var schedules = SmartTaskOrderScheduleHelper.GetSmartTaskOrderSchedule(wId, startTime, endTime); var tasks = SmartTaskOrderHelper.GetAllArrangedButNotDoneSmartTaskOrderDetails(wId, deliveryTime, all); var taskIds = tasks.Select(x => x.Id).Concat(schedules.Select(y => y.TaskOrderId)).Distinct(); if (!taskIds.Any()) { return(result); } tasks = SmartTaskOrderHelper.GetAllArrangedButNotDoneSmartTaskOrderDetails(wId, taskIds); var taskNeeds = SmartTaskOrderNeedHelper.GetSmartTaskOrderNeedsByTaskOrderIds(wId, taskIds, true); var orders = taskNeeds.GroupBy(y => new { y.PId, y.Order, y.Process, y.CategoryId }).Select(z => new SmartTaskOrderNeedWithOrder { Id = z.Key.PId, Process = z.Key.Process, CategoryId = z.Key.CategoryId, Order = z.Key.Order }); result.StartTime = startTime; result.EndTime = endTime; result.Orders.AddRange(orders.OrderBy(z => z.Order)); //设备型号数量 var deviceList = SmartDeviceHelper.GetNormalSmartDevices(wId); //人员等级数量 var operatorList = SmartOperatorHelper.GetNormalSmartOperators(wId); var modelCount = deviceList.GroupBy(x => new { x.CategoryId }).Select(y => new SmartDeviceModelCount { CategoryId = y.Key.CategoryId, Count = y.Count() }); var operatorCount = operatorList.GroupBy(x => new { x.ProcessId }).Select(y => new SmartOperatorCount { ProcessId = y.Key.ProcessId, Count = y.Count() }); //if (schedules.Any()) //{ // var productIds = schedules.Select(x => x.ProductId); // // 任务单计划号 // var products = SmartProductHelper.Instance.GetByIds<SmartProduct>(productIds); // var capacityIds = products.Select(x => x.CapacityId); // // 产能设置 // var smartCapacityLists = SmartCapacityListHelper.Instance.GetAllSmartCapacityListsWithOrder(capacityIds); // //if () // //{ // //} // ////产能配置 // //var capacityList = smartCapacityLists.Where(x => x.CapacityId == task.CapacityId); // ////工序单日产能配置 // //var cList = capacityList.FirstOrDefault(x => x.ProcessId == y.ProcessId); // //sc.Index //} var ts = taskNeeds.Where(n => tasks.Any(task => task.Id == n.TaskOrderId)).Select(x => { var task = tasks.First(t => t.Id == x.TaskOrderId); var need = new SmartTaskOrderScheduleSumInfoResult { Id = x.Id, TaskOrderId = x.TaskOrderId, TaskOrder = x.TaskOrder, ProductId = x.ProductId, Product = x.Product, DeliveryTime = task.DeliveryTime, ArrangedTime = task.ArrangedTime, PId = x.PId, ProcessId = x.ProcessId, Process = x.Process, Order = x.Order, Put = x.Put, HavePut = x.HavePut, Target = x.Target, DoneTarget = x.DoneTarget, }; var schedule = schedules.Where(sc => sc.TaskOrderId == need.TaskOrderId && sc.ProcessId == need.ProcessId && sc.PId == need.PId).ToList(); for (var i = 0; i < (result.EndTime - result.StartTime).TotalDays + 1; i++) { var t = result.StartTime.AddDays(i); if (schedule.All(p => p.ProcessTime != t)) { schedule.Add(new SmartTaskOrderScheduleDetail() { ProcessTime = t }); } } schedule = schedule.OrderBy(sc => sc.ProcessTime).ToList(); need.Schedules.AddRange(schedule.Select(y => new SmartTaskOrderScheduleInfoResult { Id = y.Id, ProductType = y.ProductType, ProcessTime = y.ProcessTime, Put = y.Put, HavePut = y.HavePut, Target = y.Target, DoneTarget = y.DoneTarget, })); return(need); }); result.datas.AddRange(ts.OrderBy(x => x.DeliveryTime).ThenBy(x => x.ArrangedTime)); var indexes = SmartTaskOrderScheduleIndexHelper.GetSmartTaskOrderScheduleIndex(wId, startTime, endTime).ToList(); var arrangeIndexes = new List <SmartTaskOrderScheduleIndex>(); foreach (var order in result.Orders) { for (var i = 0; i < (result.EndTime - result.StartTime).TotalDays + 1; i++) { var t = result.StartTime.AddDays(i); if (!indexes.Any(p => p.ProcessTime == t && p.PId == order.Id)) { arrangeIndexes.Add(new SmartTaskOrderScheduleIndex { ProcessTime = t, PId = order.Id, }); } else { var ins = indexes.Where(p => p.ProcessTime == t && p.PId == order.Id); decimal index = 0; if (ins.Any()) { var cnt = ins.First().ProductType == 0 ? (modelCount.FirstOrDefault(x => x.CategoryId == order.CategoryId)?.Count ?? 0) : (operatorCount.FirstOrDefault(x => x.ProcessId == order.Id)?.Count ?? 0); index = cnt == 0 ? 0 : (ins.Sum(x => x.Index) / cnt).ToRound(2); } arrangeIndexes.Add(new SmartTaskOrderScheduleIndex { ProcessTime = t, PId = order.Id, Index = index }); } } } result.Indexes.AddRange(arrangeIndexes.OrderBy(x => result.Orders.FirstOrDefault(y => y.Id == x.PId)?.Order ?? 0).ThenBy(z => z.ProcessTime)); return(result); }
public object PostSmartSchedulePreview([FromBody] SmartTaskOrderArrangeParam arrange) { var taskOrders = arrange.Previews; var wId = arrange.WorkshopId; if (taskOrders == null) { return(Result.GenError <Result>(Error.ParamError)); } var taskIds = taskOrders.GroupBy(x => x.Id).Select(y => y.Key); if (taskIds.Count() != taskOrders.Count()) { return(Result.GenError <Result>(Error.SmartTaskOrderDuplicate)); } var result = new DataResult(); var allTasks = new List <SmartTaskOrderPreview>(); if (taskOrders.Any()) { var tOrders = SmartTaskOrderHelper.Instance.GetByIds <SmartTaskOrderPreview>(taskIds); if (taskIds.Count() != tOrders.Count()) { result.errno = Error.SmartTaskOrderNotExist; result.datas.AddRange(taskOrders.Where(x => tOrders.All(y => y.Id != x.Id)).Select(x => x.TaskOrder.IsNullOrEmpty() ? x.Id.ToString() : x.TaskOrder)); return(result); } //var arranged = tOrders.Where(x => x.Arranged); //if (arranged.Any()) //{ // result.errno = Error.SmartTaskOrderArranged; // result.datas.AddRange(arranged.Select(x => x.TaskOrder)); // return result; //} foreach (var task in tOrders) { var t = taskOrders.FirstOrDefault(x => x.Id == task.Id); if (t == null) { result.errno = Error.SmartTaskOrderNotExist; result.datas.Add(task.TaskOrder); } else { //页面选择顺序 task.Order = !t.Arranged && t.Order == 0 ? int.MaxValue : t.Order; task.StartTime = t.StartTime; task.EndTime = t.EndTime; task.Needs = t.Needs; } } allTasks.AddRange(tOrders); } if (result.errno != Error.Success) { return(result); } var otherTasks = SmartTaskOrderHelper.GetArrangedButNotDoneSmartTaskOrders(wId); if (otherTasks.Any()) { taskIds = otherTasks.Select(x => x.Id); var taskNeeds = SmartTaskOrderNeedHelper.GetSmartTaskOrderNeedsByTaskOrderIds(wId, taskIds); foreach (var otherTask in otherTasks) { var aTask = allTasks.FirstOrDefault(x => x.Id == otherTask.Id); var needs = taskNeeds.Where(need => need.TaskOrderId == otherTask.Id); if (aTask != null) { aTask.Arranged = true; if (!aTask.Needs.Any()) { aTask.Needs.AddRange(needs); } else { aTask.Needs = aTask.Needs.Select(x => { var need = needs.FirstOrDefault(y => y.TaskOrderId == x.TaskOrderId && y.PId == x.PId); if (need != null) { x.DoneTarget = need.DoneTarget; x.HavePut = need.HavePut; } return(x); }).ToList(); } } else { var t = ClassExtension.ParentCopyToChild <SmartTaskOrder, SmartTaskOrderPreview>(otherTask); t.Arranged = true; t.Needs.AddRange(needs); allTasks.Add(t); } } } if (result.errno != Error.Success) { return(result); } var productIds = allTasks.GroupBy(x => x.ProductId).Select(y => y.Key); if (!productIds.Any()) { return(Result.GenError <Result>(Error.SmartProductNotExist)); } var products = SmartProductHelper.Instance.GetByIds <SmartProduct>(productIds); if (products.Count() != productIds.Count()) { return(Result.GenError <Result>(Error.SmartProductNotExist)); } var productCapacities = SmartProductCapacityHelper.GetSmartProductCapacities(productIds); if (!productCapacities.Any()) { return(Result.GenError <Result>(Error.SmartProductCapacityNotExist)); } var capacityIds = products.GroupBy(x => x.CapacityId).Select(y => y.Key); if (!capacityIds.Any()) { return(Result.GenError <Result>(Error.SmartCapacityNotExist)); } var capacityLists = SmartCapacityListHelper.GetSmartCapacityListsWithOrder(capacityIds); foreach (var productId in productIds) { var tasks = allTasks.Where(x => x.ProductId == productId); var product = products.FirstOrDefault(x => x.Id == productId); var pCapacities = productCapacities.Where(x => x.ProductId == productId); var cLists = capacityLists.Where(x => x.CapacityId == product.CapacityId); if (cLists.Count() != pCapacities.Count()) { result.errno = Error.SmartProductCapacityNotExist; result.datas.AddRange(tasks.Select(x => x.TaskOrder)); } } if (result.errno != Error.Success) { return(result); } var data = allTasks.ToDictionary(x => x.Id, x => { var t = ClassExtension.ParentCopyToChild <SmartTaskOrder, SmartTaskOrderPreview>(x); t.Product = products.FirstOrDefault(y => y.Id == x.ProductId)?.Product ?? ""; return(t); }); foreach (var task in allTasks) { var productId = task.ProductId; var product = products.FirstOrDefault(x => x.Id == productId); var pCapacities = productCapacities.Where(x => x.ProductId == productId); var cLists = capacityLists.Where(x => x.CapacityId == product.CapacityId); var target = task.Target; foreach (var list in cLists.Reverse()) { var need = task.Needs.FirstOrDefault(x => x.Order == list.Order && x.ProcessId == list.ProcessId); var stock = need?.Stock ?? 0; var doneTarget = need?.DoneTarget ?? 0; var havePut = need?.HavePut ?? 0; if (target < stock) { stock = target; target = 0; } else { target -= stock; } var pCapacity = pCapacities.FirstOrDefault(x => x.ProcessId == list.ProcessId); var rate = 0m; var y = pCapacity; if (y.DeviceList.Any()) { rate = y.DeviceList.First().Rate; } else if (y.OperatorList.Any()) { rate = y.OperatorList.First().Rate; } var put = rate != 0 ? (int)Math.Ceiling((target) * 100 / rate) : 0; data[task.Id].Needs.Insert(0, new SmartTaskOrderNeedDetail { TaskOrderId = task.Id, ProductId = productId, ProcessId = list.ProcessId, PId = list.PId, Target = target, DoneTarget = doneTarget, Stock = stock, Rate = rate, Put = put, HavePut = havePut, Process = list.Process, Order = list.Order }); target = put; } } var r = new SmartTaskOrderNeedWithOrderResult(); r.datas.AddRange(data.Values.OrderBy(x => x.Arranged).ThenBy(x => x.ModifyId)); var orders = data.Values.SelectMany(x => x.Needs).GroupBy(y => new { y.PId, y.Order, y.Process }).Select(z => new SmartTaskOrderNeedWithOrder { Id = z.Key.PId, Process = z.Key.Process, Order = z.Key.Order }); r.Orders.AddRange(orders.OrderBy(z => z.Order)); return(r); }