日期:2014-05-20 浏览次数:21055 次
using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Diagnostics; 
using System.ServiceProcess; 
using System.Text; 
using System.Xml; 
using System.Data.Sql; 
using System.Data.SqlClient; 
using System.Timers; 
namespace WindowsService1 
{ 
    public partial class gzjh : ServiceBase 
    { 
        public System.Timers.Timer serviceTimer1 = new System.Timers.Timer();//定时器
        public gzjh() 
        { 
            
            serviceTimer1.Elapsed += new System.Timers.ElapsedEventHandler(serviceTimer1_Elapsed);
            InitializeComponent(); 
        } 
        void serviceTimer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
        {
            string strconn = "user id=sa;password=123456;Database=wpdb;server=db"; 
            string strcomm = "insert into sysplan (djh,fbr,jsr,zt) values ('SYS20090720001','SYSTEM','SYSTEM','0')"; 
            SqlConnection sqlconn = new SqlConnection(strconn); 
            sqlconn.Open(); 
            SqlCommand sqlcomm = new SqlCommand(strcomm, sqlconn); 
            SqlDataReader sdr = sqlcomm.ExecuteReader(); 
            sqlconn.Close(); 
        }
        protected override void OnStart(string[] args)
        {
            serviceTimer1.Interval = 1 * 60 * 1000;
            serviceTimer1.Enabled = true;
        }
        protected override void OnStop()
        {
            serviceTimer1.Enabled = false;
        }
    }
}