在 ASP.NET 中编写旧版 ASP 应用程序
我在尝试重写遗留应用程序时需要帮助来选择正确的路径。只是有一点疏忽，当前的应用程序是一个网络报告工具，其中的列和查询文本是从数据库读取的。用户将过滤并点击“创建”按钮，然后报告将显示在 html 页面上。出于性能原因，最大限制为 1000 行，对于超过此数量的结果，应用程序将导出到 Excel。
新的要求是在 asp.net/Silverlight 中重写相同的应用程序，使其具有新的外观和感觉以及几乎相同的功能（更多数量的报告）。重要的是客户希望报表显示在一种 DataGrid 中（具有排序和分组功能），并且他希望增加 1000 行限制。此外，他不想要分页（他想要向下滚动行并分析数据，而不是打太多页）。
你建议我应该选择什么？ Silverlight 还是 Asp.net？你们知道有什么报告框架吗？水晶报表呢？对于制作有吸引力的动态报告 Web 应用程序有什么建议吗？
没有分页似乎不现实，但我可以理解用户的观点。就像你在 Excel 中有一些 2-3k 行，你想向下滚动并查看你的数据是什么样子，如果你想进一步分析它，你可以进行排序、分组等... 用户知道最终应该在 Web 应用程序上显示多少数据。他只是想通过排序和分组功能来增加当前的 1000 限制。 我想到并测试它的一件事是 Infragistics“UltraWebGrid”。 DotNet 版本的性能非常差，以至于我不得不使用分页，但使用 silverlight XamGrid 版本，我在不到 3 分钟的时间内成功显示了多达 15K 条记录（具有所有分组和排序功能）。我使用 silverlight 时遇到的问题是，所有报告都是动态的，我将被迫将数据源设为数据表。我无法将实体集合传递到 silverlight 网格，因为我不知道事先要显示的列。
I need help in choosing the right path while trying to rewrite a legacy application. Just a little bit of oversight, the current application is a web reporting tool in which the columns and the query texts are read from database. Users will filter and hit on a button “Create”, then the report will be displayed on an html page. For performance reasons, the maximum limit is 1000 rows, for a result more than that, the application will export to Excel.
The new requirement is to rewrite the same application in asp.net/Silverlight with a new look and feel and pretty much the same functionality (More number of reports). What is important is the client wants the reports to be displayed in a kind of DataGrid (with Sorting and Grouping capability) and he wants to increase the 1000 row limitation. In addition, he doesn’t want the Paging (he wants to scroll down the rows and analyze the data instead of punching too many pages).
What do you suggest that I should choose? Silverlight or Asp.net? Is there any reporting framework that you guys know? What about crystal reports? Any suggestion to produce an attractive dynamic reporting web application?
It seems unrealistic not to have paging but I can understand the user perspective. It is like you have some 2-3k rows in Excel and you want to scroll down and see what your data looks like and if you want further analyze it you go head and sort, group etc...
The user know that ultimately there is a limit on how many data should be displayed on a web application. He just wanted to increase the current 1000 limit with a sorting and grouping capability.
One thing that comes in to my mind and tested it with is the Infragistics "UltraWebGrid". The DotNet version is so poor in performance that I have to use paging but with the silverlight XamGrid one, I have good success in displaying as many as 15K records in less than 3min(with all grouping and sorting capability). The problem I have using silverlight is the fact that all reports are dynamic that I will be forced to make my datasource to be a datatable. I can't pass entity collection to the silverlight grid since I don't know the columns to be displayed before hand.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我已经在多个项目中非常成功地使用了 SSRS（SQL Server Reporting Services）。它非常适合进行查询或存储存储过程，并且只需获取一些具有可导出性和内置分页功能的报告。
取消分页的要求让我感到惊讶。如果这个人能够向下滚动 1K+ 项目的列表并“分析”数据，那么他一定具有某种摄影超级大脑。如果他不能被说服，那么无论你使用什么技术，你都需要尽快运行该报告的查询，因为下载那么多数据（是的，即使是在 html 中） “下载”）将花费很多时间。
I've use SSRS (SQL Server Reporting Services) quite successfully for several projects. It's great for taking a query or stored sproc and just getting some reports with exportability and paging already built in.
The requirement to do away with paging kind of makes me raise my eyebrow. The guy must have some kind of photographic super brain if he can scroll down a list of 1K+ items and "analyze" the data. If he can't be talked out of it, then regardless of the technology you use, you'll need to make the query that runs that report work as quickly as possible, because downloading that much data (yes, even in html it gets "downloaded") is going to take a lot of time.