如何按计划检测冲突？ [英] How to detect a conflict on schedule?
问题描述
Hello all
我的日历表上有这些记录，我的完整数据库表请点击这里
1. M
2. T
3。 W $ / $
4. TH
5. F
6. S
7. MTH
8. TF
9. WS
* ScheduleID = 10001
* StartTime = 8:30 AM
* EndTime = 1:00 PM
* Day = M
*房间= AVR
*课程= BSN
然后如果我添加这个新条目
* ScheduleID = 10002
* StartTime = 9:00 AM
* EndTime = 10:00 AM
*日= MTH
*房间= AVR
*课程= BSN
这应该引发计划冲突，因为那里已经是一个时间表了星期一，然后不应该添加新条目。 ：）
注意：MTH表示''星期一''和''星期四''，如果它们具有相同的时间表，我会使用它。因为如果为星期一添加新的时间表并且在同一天，时间，房间和课程的星期四添加另一个时间表将变得多余。也与 TF 和 WS 相同。我只能检测冲突，如果它不是两天的组合（例如MTH，TF，......）我真的花了很多时间来解决这个问题。我真的需要你的帮助：（
这是我的示例代码：
这是我的原始代码，请< a href =http://www.thescripts.com/forum/thread743829.html\"target =_ blank>请点击这里
Hello all
I have these records on my Day Table for my complete database table please click here
1. M
2. T
3. W
4. TH
5. F
6. S
7. MTH
8. TF
9. WS
Let say if I have this existing schedule:
* ScheduleID = 10001
* StartTime = 8:30 AM
* EndTime = 1:00 PM
* Day = M
* Room = AVR
* Course = BSN
Then If I add this new entry
* ScheduleID = 10002
* StartTime = 9:00 AM
* EndTime = 10:00 AM
* Day = MTH
* Room = AVR
* Course = BSN
This should prompt a conflict in schedule because there is already a schedule for monday, then the new entry shouldn''t be added. : )
Note: MTH means ''Monday'' AND ''Thursday'', I used this if they have both the same schedule. Because it would become redundant if add a new schedule for monday and add another for thursday with the same day, time, room and course. Also the same as TF and WS. I can only detect conflict if it is not a combination of both Days (e.g MTH, TF, ...) I really spend a lot of time regarding this issue. Please I really need your help : (
Here are my sample codes:
This was my original code, please please click here
推荐答案
你好......
有谁可以帮帮我这个？
Hello....
Could anyone help me this out?
我刚从假期回来。由于其他人似乎没有帮助，我会在第二天或者试着看看它如果你愿意的话，我可以把它移到Access论坛，在那里我认为你会发现更多这方面的专业知识。
I''ve just got back from vacation. Since nobody else seems to be helping, I''ll try to have a look at it within the next day or two. If you like though, I can move it to the Access forum, where I think you''ll find much more expertise with this kind of thing.
我刚从假期回来。由于其他人似乎没有帮助，我会在接下来的一两天内试一试。如果您愿意，我可以将其移至Access论坛，在那里我认为您会发现更多这方面的专业知识。
I''ve just got back from vacation. Since nobody else seems to be helping, I''ll try to have a look at it within the next day or two. If you like though, I can move it to the Access forum, where I think you''ll find much more expertise with this kind of thing.
嗨Killer42
感谢您的回复和关注
Rey Sean
Hi Killer42
Thanks for your reply and concern
Rey Sean
这篇关于如何按计划检测冲突？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
