how can I make this scheduling program
Hi everyone,
I'm trying to come up with a scheduling program for our cnc machines, and was wondering what would be the best way to go. To start, this program will be made in visual studio 2010 using C# (I also want it to connect with a SQL server database). When we get a job in, we put it on one of our cnc machines for initial roughing, then it leaves the shop for additional work (painting, texturing etc), then it comes back to the shop and gets put on another cnc machine for finishing. I would like to use a drag and drop system to manipulate the schedule.
So lets say we get orders for 4 widgets, I would enter them into a field widget1, widget2...etc, and this would store in the database. Then when it comes time to put them on a machine, I would search there job number, drag them onto a row/machine. I would like each widget to be sizeable horizantally only, so I can set the time accordingly (the background of the form will be a generic week). Now, when we send a block out, I can then drag it off the schedule into a field representing "out of shop".
What can I put on a form to handle this kind of action? Each machine needs it's own row for the database, and each item needs to be in it's own horizontally sizeable field. I know this is a tough one, but any ideas would be appreciated.
Thanks