识别时间表已经存在或没有 [英] identifying schedule already exist or not

问题描述

你好朋友，



i有关于调度方案的查询。



i设计了一个调度仪表板对于vb.net和sql server.in中的机器，用户输入他必须使用的机器的日程表。现在的问题是我能够停止重复的调度条目，但我不知道如何实现以下提到的问题：





假设用户从凌晨3点到凌晨4点输入时间表，那么我可以在此时间表上停止输入但是如何我应该限制条目说：从凌晨2点到凌晨5点，已经采取了凌晨3点到凌晨4点的时间表。



i想要限制和检查这些条目。



需要帮助....



谢谢。

hello friends,

i have query regarding a scheduling scheme.

i have designed a scheduling dashboard for machines in vb.net and sql server.in which a user enters the schedules for machines which he has to use.now the problem is i am able to stop the duplicate scheduling entries but i dont have any idea on how to achieve the following mentioned problem:


suppose a user enters the schedule from 3 AM to 4AM then i am able to stop entries on this schedule but how should i restrict the entries from say: 2AM to 5AM coz the schedule of 3 AM to 4AM is already taken.

i want to restrict and check such entries.

needed help....

thanks.

推荐答案

没有任何一个代码可以帮助您解决此问题。你需要检查重叠。绘制图表可以帮助您查看它。您需要确保现有的开始时间不在新的开始时间内，也不是结束时间。然后检查其他方案，但绘制图表应该可以帮助您将其可视化。

There isn't a single piece of code anyone can give you to fix this issue. You need to check for overlapping. Drawing out a diagram may help you see it. You need to make sure your start time of the existing one is not in the range of the new one nor is the end time. Then check the other scenarios but drawing a diagram should help you visualize it.

这篇关于识别时间表已经存在或没有的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！