Ask next bosses, I want to do with winform + is essentially a theater row piece of functional modules, and how to row which prevent near-end schedule conflict? Is to add the film on the day of judgment when a near-end have up a piece of a certain period of time? I now think of is, as a movie, the film of the start time and end time is not on already arranged time periods, but I'm still a little not too will realize the function, thanks for your bosses teach

CodePudding user response:

Movie start time and end time can't have arranged a few number of time periods
You can add a movie name, determine the date hall
Such as hall 8

Select * from where the table where ppID=8 and add time between ppstartTime and ppendTime

Then in vs judgement,
If there is more than one line of data, will prompt hall 8 existing film this time, please choose again

CodePudding user response:

reference 1st floor ManBOyyy response:

movie start time and end time is not on the number has arranged a few time periods
You can add a movie name, determine the date hall
Such as hall 8

Select * from where the table where ppID=8 and add time between ppstartTime and ppendTime

Then in vs judgement,
If there is more than one line of data, will prompt hall 8 existing film this time, please choose again time

But between.. and.. The scope of the clause is the same field I the start time and end time are two fields

CodePudding user response:

Think about what I sent to your SQL statements mean
Select * from where the table where ppID=8 and add time between ppstartTime and ppendTime