Flex：具有动态列的 DataGrid，其中包含来自多个数据库表的数据
简介：我正在使用java、oracle、flex、blazeDS等。与我试图完成的任务相关的数据库部分如下图所示： 
Task 表还将有一个名为enabled ，我在下图中忘记了:) 当管理员用户按下 GUI 中的“生成任务列表”按钮时，此字段用于根据各种条件启用某些任务。
基于这一生成的任务列表，系统中的用户应该看到如下图所示的网格： 
此任务列表应显示所有已启用的任务，如上所示。前三列是从数据库中的任务表中检索的，而接下来的列（Column_4....Column_N）是根据用户中的用户数量生成的> 表。这些列应显示用户别名。每个用户都是 UserGroup(Group) 的一部分，我将在单独的表或 User 表本身中对其进行建模，如图 1 所示。网格中的数字基于时间Task_User 表中的字段，而用户下面的第一行显示每个用户的时间总和。
问题：我仍在学习 Flex，并寻找我能获得的一切帮助来实现我的目标:) 我想我必须实现一个带有动态列的数据网格。但在这种情况下，数据提供者将如何工作呢？对于每个启用的任务ID，网格必须用时间值填充正确的用户列。任何提示/帮助将不胜感激！同样重要的是，加载此网格不会花费很长时间:)
是否可以在网格中获取水平和垂直文本（如上所示）？
Introduction: I'm using java, oracle, flex, blazeDS etc. The part of the DB that is relevant to the task i am trying to accomplish is illustrated in the image below:
The Task table will also have a field called enabled , which i forgot in the figure below :) This field is used to enable some of the tasks based on various criteria, when an admin user presses a "Generate task list" button in the GUI.
Based on this generation of the task list, the users in the system should see a grid as the one displayed in the figure below :
This task list should display all the enabled task as illustrated above. The first three columns are retrived from the Task table in the DB, while the next columns(Column_4....Column_N) are generated based on the number of users in the User table. These columns should display the users alias. Each user is part of a UserGroup(Group), which i will model in either a separate table or in the User table itself, as illustrated in figure 1. The Numbers in the grid are based on the Time field in the Task_User table, while the first row below the users shows the sum of the times for each user.
Question: Im still learning Flex, and looking for every help i can get on accomplishing my goal :) I figure i have to implement a datagrid with dynamic columns. But how will the dataprovider work in this scenario? For each enabled taskid the grid has to fill the right user columns with time values. Any tips/help would be much appreciated! It is also important that loading this grid doesnt take to long :)
Is it possible to get horizontal and vertical text in the grid(like shown above)?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论