http://www.cnblogs.com/TivonStone/archive/2012/05/29/2523899.html按照里面的方法创建的服务,然后在服务器上用http://wenku.baidu.com/view/a02bb325af45b307e871974d.html这个方法安装了服务,可以启动,但是并没有进行我要的操作,是我的安装方法错了还是代码有问题
protected override void OnStart(string[] args)
{
timer1 = new System.Timers.Timer();
timer1.Interval = 1000;
timer1.Elapsed += new System.Timers.ElapsedEventHandler(timer1_Elapsed);
timer1.Enabled = true;
timer1.AutoReset = true;
}
protected override void OnStop()
{
timer1.Enabled = false;
}
protected void LogMessage()
{
string str = "Server=192.168.0.137;Database=ENTERPRISES_WORKDIARY;Persist Security Info=True;User Id=sa;Password=pass@word1";
SqlConnection connection =new SqlConnection(str);
string sr = "update WorkDiary set Work_Warn_State=@state where datediff(day,Work_StartTime,GETDATE())=0 and Work_Warn_State=0 and Work_WarnID=1 and Work_IsAllDayEvent=1";
SqlCommand cmdd = new SqlCommand(sr, connection);
cmdd.Parameters.AddWithValue("@state", 1);
using (connection)
{
connection.Open();
cmdd.ExecuteNonQuery();
connection.Close();
}
}
private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
if (DateTime.Now.Hour == 14)
{
this.LogMessage();
}
}
以前没接触过服务,代码稍有点多,帮忙看看
protected override void OnStart(string[] args)
{
timer1 = new System.Timers.Timer();
timer1.Interval = 1000;
timer1.Elapsed += new System.Timers.ElapsedEventHandler(timer1_Elapsed);
timer1.Enabled = true;
timer1.AutoReset = true;
}
protected override void OnStop()
{
timer1.Enabled = false;
}
protected void LogMessage()
{
string str = "Server=192.168.0.137;Database=ENTERPRISES_WORKDIARY;Persist Security Info=True;User Id=sa;Password=pass@word1";
SqlConnection connection =new SqlConnection(str);
string sr = "update WorkDiary set Work_Warn_State=@state where datediff(day,Work_StartTime,GETDATE())=0 and Work_Warn_State=0 and Work_WarnID=1 and Work_IsAllDayEvent=1";
SqlCommand cmdd = new SqlCommand(sr, connection);
cmdd.Parameters.AddWithValue("@state", 1);
using (connection)
{
connection.Open();
cmdd.ExecuteNonQuery();
connection.Close();
}
}
private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
if (DateTime.Now.Hour == 14)
{
this.LogMessage();
}
}
以前没接触过服务,代码稍有点多,帮忙看看
解决方案 »
- 放到IIS上 显示 名称以无效字符开头
- table嵌套样式被撑大
- |zyciis| 如何将 $("#frmManager [name=CreateTime]").datepicker(); 改为onfocus方法 谢谢
- asp.net获取cookie值的问题
- 字符串的匹配
- datalist中放label绑定数据库中数据,当记录长时一行只显示一笔记录,记录短时显示两笔记录,可以实现吗?
- 文件下载问题???
- 如何让从数据库取数据绑定的datagrid控件的一列是超级链接列?
- 我数组里存了10个LONG型的数,我要把他们从小到大排序,并取出其中第2个数?
- 怎样在 98 下跑 asp.net ?
- 求 MVC实现编辑功能
- 为什么现在很多的企业系统(b/s)都只支持IE?
麻烦高手看看这是什么原因
参考:http://www.cnblogs.com/superfeeling/p/3158914.html
另外,楼主服务程序中的条件是 DateTime.Now.Hour == 14,难道在下午2点之后的一个小时,每秒都要执行吗,共3600次?