博主在Delphi开发中遇到一个挑战，需要一个控件展示数据库数据并支持拖放功能。问题涉及如何创建一个可以显示工作订单（按行显示）且可拖放的控件，并询问是否需要接收它的目标控件。需求包括：1. 显示特定日期的工作订单；2. 具备滚动功能；3. 实现工作订单的拖放计划调整；4. 保存更新的生产计划；5. 提供未保存提示。附件中提供了一个Excel文件作为概念说明。
各位高人，感谢百忙之中浏览这个帖子。
小弟目前从事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
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
