如何在一段时间后更新ASP应用程序中的数据？ [英] How to update data in ASP application after some time period?
问题描述
hi
我的申请必须每天维护员工出勤详情。
在应用程序中，我通过使用IN& amp;获得员工IN时间和OUT时间。 OUT按钮。
员工进入办公室时必须单击输入按钮，同时他点击退出按钮
他离开从办公室申请。
通过使用OUT Time按钮点击，我保留当天的出勤详情。
我的要求：
假设员工没有上任（缺席），我将不会获得IN& OUT细节该员工当天。
所以经过一段时间后假设在下午6点办公室关闭时间后，应用程序将搜索所有员工的IN和OUT时间，然后它将会为那些缺席的员工自动存储（将数据发送到数据库）。
我如何实现它？
谢谢提前..
克里希纳..
使用sql轻松完成此任务
只需创建sp，找到缺少的员工并在sql中转储数据表格
然后为这个sp设置一个sql作业，每天运行6点或者你想要设置的时间
Happy编码！ ：）
按照这个...使用您自己的商店程序并根据您的项目更改时间。
< a href =http://asp-arka.blogspot.in/2014/09/how-to-execute-perform-task-at-specific-time-12-night-sql-server.html> http：/ /asp-arka.blogspot.in/2014/09/how-to-execute-perform-task-at-specific-time-12-night-sql-server.html [ ^ ]
hi
My application have to maintain employee attendance details daily.
In the Application, i am getting employee IN Time and OUT Time by using IN & OUT Buttons.
The employee has to Click IN button when he enter in to office and similarly he Click on OUT button when
he leaving from office in application.
By using OUT Time button click, i maintain the attendance details on that day.
My requirement:
Suppose the employee is not came to office(absent), i will not get IN&OUT details for that employee on that day.
so after some time suppose After 6 PM office closing time,the application will have search all employee IN and OUT times, then and it will automatically store(send data as Absent to database) for those employee who are absent.
How can i achieve it?
Thanks Advance ..
Krishna..
it's easy to do this task with sql
simply create sp which find absent employees and dump data in sql table
then set a sql job for this sp which run every day 6 o'clock or what ever time you want to set
Happy Coding! :)
follow this one...with your own store procedure and change the time as per your project.
http://asp-arka.blogspot.in/2014/09/how-to-execute-perform-task-at-specific-time-12-night-sql-server.html[^]
这篇关于如何在一段时间后更新ASP应用程序中的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
