using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;
using System.IO;
using System.Data.SqlClient;
using System.Threading;
using System.Data;
class Program
{
static void Main(string[] args)
{
//循环读取TXT文档
while (true)
{
//Console.Write("请输入指定的文件路径(请拖拽文件到此处):");
//string path = Console.ReadLine();
PrintFileVersionInfo(@"\\192.168.0.15\CadPrint\FactoryNumber.txt");
}
}
/// <summary>
/// 打印指定文件的详细信息
/// </summary>
/// <param name="path">指定文件的路径</param>
static void PrintFileVersionInfo(string path)
{
FileInfo fileInfo = null;
try
{
fileInfo = new FileInfo(path);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
// 其他处理异常的代码
}
// 如果文件存在
if (fileInfo != null && fileInfo.Exists)
{
//计算文本里有无内容,无为0,有为1
FileVersionInfo info = FileVersionInfo.GetVersionInfo(path);
int fileLen = Convert.ToInt16(Math.Ceiling(fileInfo.Length / 1024.0));
//判断文件有无内容,有内容执行存储过程
if (fileLen>0)
{
//执行SQL代码或存储过程
SqlConnection sqlConnection = new SqlConnection("server=192.168.0.15;uid=sa;pwd=sa;database=数据库");
SqlCommand sqlCommand = new SqlCommand("存储过程名称", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
Console.Write("时间:" + DateTime.Now + ",标记文本数据导入到数据库中。。。。。");
Thread.Sleep(6000);
sqlConnection.Close();
//清空文本文件里的内容
File.WriteAllText(path, string.Empty);
}
else
{
Console.Write("时间:" + DateTime.Now + ",标记文本无内容");
Thread.Sleep(6000);
}
}
else
{
Console.WriteLine("时间:" + DateTime.Now + ",标记文本文件路径不存在");
File.WriteAllText(path,string.Empty);
Thread.Sleep(500);
}
// 末尾空一行
Console.WriteLine();
}
}