变更时间表C＃，ASP.NET [英] Timelines of Changes C#, ASP.NET

问题描述

How can I make timeline of changes like attached picture - check link-
https://dl.dropboxusercontent.com/u/2018829/Capture.PNG
my site is related to students marks, the teachers will fill there marks,
so I want to know what each teacher did ?
for example:
Sara add marks for class 2B at 2:00 PM
Sara Update 2C Marks at 8:00 AM

推荐答案

时间轴只是一个可能被使用的奇特名称通过该服务，您尝试将我们连接到该图像。然而，在许多其他服务中，它也称为版本控制，就像在GitHub中一样，每个更改都称为提交，依此类推。这就是每个服务持有者想要为其产品和功能命名的方式。



实际上发生了类似于数据源的简单数据查询并在HTML标记中表示的内容。好的，让我为你简化一下。您在那里使用的服务允许用户对对象（在这种情况下为文件）进行更改，然后将每个更改存储在数据库中。每次更改时，都会向数据库添加一条新记录（行），使其成为用户要查看的新记录。例如，当用户添加文件时，它会保存记录和其他一些细节，如FileName，IsUpload等，然后保存这些细节以创建HTML标记。



一旦创建了应用程序的这一部分，每次用户访问该页面时。应用程序在数据库上运行查询，数据库返回对该对象执行的所有操作（在本例中为文件）。您可以使用属性（在记录的属性中）更改HTML内容的外观（每个操作的图标;创建，编辑等），如IsUpload，FileName，UserID等，并创建HTML标记。



在您的情况下，您需要存储学生的个人资料，其学生ID（也可以使用RegistrationID），姓名等，然后是其他详细信息。对象（2B类，在您的情况下为2C类）和执行动作的时间。一旦你完成了所有这些，你就可以将它们存储在数据库中。执行的每个操作都可以存储在数据库中。哪个将构成记录，并且在查询时，它们将根据其插入日期返回。您可以使用 ORDER BY 子句根据时间对记录进行排序，并在HTML标记内显示所有记录。



这里需要学习的唯一语言和技术是SQL和数据库;关系数据库系统，例如SQL Server等。如果你对它们有足够的把握。您将能够自己创建这样一个系统。

Timeline is just a fancy name that might be used by that service that you're trying to connect us to in that image. Whereas, in many other services it is also called versioning, like in GitHub every change is called a commit and so on. It is just the way each and every service holder would like to name their product and features to be.

What actually is happening there is something like a simple data query from the data source and represented in the HTML markup. Ok, let me simplify things up for you. The service that you're using there, is allowing the users to make changes to the objects (files in this case) and then it stores every change inside the database. Upon every change, a new record (row) is added to the database making it a new record for the user to view. For example, when the user added a file, it saved the record and a few other details like, FileName, IsUpload etc which was then saved to create the HTML markup.

Once that part of the application has been created, each time a user visits the page. Application runs a query on the database, and the database returns all of the actions performed on the object (file in this case). You can change the appearance of the HTML content (icons for every action; created, edited etc) using the properties (in attributes of the record) like, IsUpload, FileName, UserID etc and create up the HTML markup.

In your case, you need to store the profile of the Student, having their StudentID (RegistrationID can also be used), Name etc, and then other details for the object (Class 2B, Class 2C in your case) and the time of the action performed. Once you've got them all, you can store them inside the database. Each of the action performed can be stored inside the database. Which will make up the records and upon a query, they will return according to their date of insert. You can use the ORDER BY clause to order the records according to their time and show it all inside the HTML markup.

The only language and technology you need to learn here, is SQL and Database; Relational Database systems, such as SQL Server etc. If you get enough hold on them. You will be able to create such a system yourself.

这篇关于变更时间表C＃，ASP.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！