Nå, nu fandt jeg ud af det med et timestamp samt configuration file, og dette virker perfekt efter hensigten som almindeligt program. Jeg ville så overføre koden til en Windows service, men her opstår en masse fejl som jeg ikke forstår. Nogle der kan give mig nogle hints. Herunder kan man se min Service1.cs samt App.config, som er det eneste jeg har overført (ved ikke om dette er nok)?
using System;
using System.Timers;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
namespace Scanservice
{
public partial class Service1 : ServiceBase
{
public Service1()
{
InitializeComponent();
string interval = ConfigurationSettings.AppSettings["tid"];
System.Timers.Timer myTimer = new System.Timers.Timer();
myTimer.Elapsed += new ElapsedEventHandler( DisplayTimeEvent );
interval = myTimer.Interval.ToString(interval);
}
protected override void OnStart(string[] args)
{
myTimer.Start();
EventLog.WriteEntry(eventLogSourceName, "Scanservicen er blevet startet.", EventLogEntryType.Information); }
}
public static void DisplayTimeEvent( object source, ElapsedEventArgs e )
{
string fileName = "test.txt";
string fileNames = "test.txt";
string sourcePath = ConfigurationSettings.AppSettings["kildesti"];
string targetPath = ConfigurationSettings.AppSettings["destinationsti"];
string sourceFile = System.IO.Path.Combine(sourcePath, fileName);
string destFile = System.IO.Path.Combine(targetPath, fileName);
string destFiles = System.IO.Path.Combine(targetPath, fileName);
if (!System.IO.Directory.Exists(targetPath))
{
System.IO.Directory.CreateDirectory(targetPath);
}
string[] files = System.IO.Directory.GetFiles(sourcePath, "*.txt");
string forbindelse = ConfigurationSettings.AppSettings["forbind"];
SqlConnection con = new SqlConnection(forbindelse);
con.Open();
foreach (string s in files)
{
fileName = System.IO.Path.GetFileName(s);
destFile = System.IO.Path.Combine(targetPath, fileName);
DateTime tid = DateTime.Now;
String tiden;
tiden = tid.ToString("ddMMyyyy-HH.mm.ss.fff-");
destFiles = System.IO.Path.Combine(targetPath, tiden + fileName);
if (!System.IO.File.Exists(destFile))
{
System.IO.File.Move(s, destFile);
System.IO.File.Move(destFile, destFiles);
fileNames = tiden + fileName;
SqlCommand sel = new SqlCommand("INSERT INTO data (filnavn, dato) values ('" + fileNames + "', getDate())", con);
sel.ExecuteNonQuery();
}
}
con.Close();
protected override void OnStop()
{
// TODO: Add code here to perform any tear-down necessary to stop your service.
myTimer.Stop();
EventLog.WriteEntry(eventLogSourceName, "Scanservicen er blevet stoppet.", EventLogEntryType.Information); }
}
}
}
----------
config
----------
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="forbind" value="server=servernavn;Integrated Security=SSPI;database=DB" />
<add key="kildesti" value="C:\\test\\fra" />
<add key="destinationsti" value="C:\\test\\til" />
<add key="tid" value="2000" />
</appSettings>
</configuration>
