各位高人,感谢百忙之中浏览这个帖子。
小弟目前从事J2EE的开发,但是最近主管给了一个任务,需要使用Delphi完成,本人以前没有学Delphi。
我现在要做一个小Demo,但是其中有一个技术难点,希望高人指点,小弟不甚感激。时间比较紧,下个星期
一就要交Demo。
主要技术难点是:有没有一个控件,能显示从数据库里抓出来的数据(分行显示),又能被随意拖放。被放置
的地方要不要有一个什么控件,接收它?(我的环境是Delphi8)感谢您的不吝赐教。
需求如下:
1. Define tables as follows:
Table WorkOrder
PK Work Order No.
Item No.
Expected Starting Date
Work Order Qty
Required Material Availability ("All" / "Partial" / "None")
Table Item Master
PK Item No.
Item Category
Production Capacity Per Day
2. Graphical Display
Select: Date range of Expected Starting Date. e.g. 2005/07/28 to 2005/08/15
Showing a table with columns of each day. e.g. 2005/07/28, 2005/07/29,
2005/07/30, ... , 2005/08/15
Grouping related work orders by the Item Category, and the expected
starting date
For each Item Category, show the production capacity per day and
the summed loading below the day e.g. sum of Work Order Qty
for work orders with Expected Starting Date = 2005/07/28,
(which can be zero if no work order to be started on 2005/07/28)
Below each Item Category/Item, show relevant work orders as movable
rectangle box with text of work order no., the work order qty.
3. Scroll control
The graphical display shall allow user scrolling to different day horizontally
or different item category and item no. vertically very easily. (whereas the
date and the category/item shall always be visible).
4. Drag and Drop of work order for production planning
User may drag and drop the rectangle box from a day to the other. Then, the
graphical display shall be refreshed accordingly showing the newly summed
loading.
5. Saving the produciton planning
When user click a [Save] button, the revised Expected Starting Date of work
orders shall be updated accordingly. Before that, user's work is only a
worksheet draft copy. If user is going to exit the program without saving,
user shall be prompt if he wants to save it or not.
The concept is illustrated in the attahed Excel file
(which can be zero if no work order to be started on 2005/07/28)
Below each Item Category/Item, show relevant work orders as movable
rectangle box with text of work order no., the work order qty.
3. Scroll control
The graphical display shall allow user scrolling to different day horizontally
or different item category and item no. vertically very easily. (whereas the
date and the category/item shall always be visible).
4. Drag and Drop of work order for production planning
User may drag and drop the rectangle box from a day to the other. Then, the
graphical display shall be refreshed accordingly showing the newly summed
loading.
5. Saving the produciton planning
When user click a [Save] button, the revised Expected Starting Date of work
orders shall be updated accordingly. Before that, user's work is only a
worksheet draft copy. If user is going to exit the program without saving,
user shall be prompt if he wants to save it or not.
The concept is illustrated in the attahed Excel file
for work orders with Expected Starting Date = 2005/07/28,
(which can be zero if no work order to be started on 2005/07/28)
Below each Item Category/Item, show relevant work orders as movable
rectangle box with text of work order no., the work order qty.
3. Scroll control
The graphical display shall allow user scrolling to different day horizontally
or different item category and item no. vertically very easily. (whereas the
date and the category/item shall always be visible).
4. Drag and Drop of work order for production planning
User may drag and drop the rectangle box from a day to the other. Then, the
graphical display shall be refreshed accordingly showing the newly summed
loading.
5. Saving the produciton planning
When user click a [Save] button, the revised Expected Starting Date of work
orders shall be updated accordingly. Before that, user's work is only a
worksheet draft copy. If user is going to exit the program without saving,
user shall be prompt if he wants to save it or not.
The concept is illustrated in the attahed Excel file
(which can be zero if no work order to be started on 2005/07/28)
Below each Item Category/Item, show relevant work orders as movable
rectangle box with text of work order no., the work order qty.
3. Scroll control
The graphical display shall allow user scrolling to different day horizontally
or different item category and item no. vertically very easily. (whereas the
date and the category/item shall always be visible).
4. Drag and Drop of work order for production planning
User may drag and drop the rectangle box from a day to the other. Then, the
graphical display shall be refreshed accordingly showing the newly summed
loading.
5. Saving the produciton planning
When user click a [Save] button, the revised Expected Starting Date of work
orders shall be updated accordingly. Before that, user's work is only a
worksheet draft copy. If user is going to exit the program without saving,
user shall be prompt if he wants to save it or not.
The concept is illustrated in the attahed Excel file