private void OnStartImport(object obj)
{
if (String.IsNullOrEmpty(this.FilePath))
{
return;
}
FileStream fileStream = null;
StringBuilder sb = new StringBuilder();
try
{
fileStream = new FileStream(this.FilePath, FileMode.Open);
//read file line by line using StreamReader
using (StreamReader reader = new StreamReader(fileStream))
{
string terminalName = null, siteName = null;
string line = "";
sb = new StringBuilder();
string[] temps = null;
List <TagData> tagDataLst = new List <TagData>();
TagData tagData;
while ((line = reader.ReadLine()) != null)
{
// 解析终端名称和站点名称
if (line.StartsWith("Reader:"))
{
temps = System.Text.RegularExpressions.Regex.Split(line, @"\ +");
terminalName = temps[1];
siteName = temps[3];
Log.Information("读取Reader: {0}, Site: {1}", terminalName, siteName);
sb.Append(string.Format("读取Reader: {0}, Site: {1}", terminalName, siteName)).Append("\r\n");
}
else if (line.StartsWith("D "))
{
temps = System.Text.RegularExpressions.Regex.Split(line, @"\ +");
tagData = new TagData
{
TerminalName = terminalName,
SiteName = siteName,
TagName = temps[5],
RecordDateTime = DateTime.Parse(temps[1] + "T" + temps[2]),
FlagColumn1 = temps[6],
FlagColumn2 = temps[7]
};
tagDataLst.Add(tagData);
Log.Information("读取数据标签: {0}, 日期: {1}, 时间: {2}", tagData.TagName, tagData.RecordDateTime.ToShortDateString(), tagData.RecordDateTime.ToShortTimeString());
sb.Append(string.Format("读取数据标签: {0}, 日期: {1}, 时间: {2}", tagData.TagName, tagData.RecordDateTime.ToLongDateString(), tagData.RecordDateTime.ToShortTimeString())).Append("\r\n");
}
this.LogData = sb.ToString();
}
_owner.scrollToEnd();
if (tagDataLst.Count > 0)
{
this.tagDataService.BulkAdd(tagDataLst);
Log.Information("=================批量插入{0}条数据.===============================", tagDataLst.Count);
sb.Append(string.Format("==================批量插入{0}条数据.=============================", tagDataLst.Count)).Append("\r\n");
this.LogData = sb.ToString();
tagDataLst = null;
}
}
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
sb.Append("=====================批量插入出现错误，请查看系统日志。=========================").Append("\r\n");
this.LogData = sb.ToString();
}
finally
{
if (fileStream != null)
{
fileStream.Close();
}
}
}