using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Xml;
|
using System.Data;
|
using XCore;
|
using XHandler.View;
|
using XImagingXhandler.XDAL;
|
using System.IO;
|
using XHandler.Class;
|
using XCommon.Log;
|
|
namespace XHandler.Controls
|
{
|
public class DataExportControl
|
{
|
string strCurrentCulture = "";
|
public RunWnd launchView = null;
|
DataExportBll dataExportBll = new DataExportBll();
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
public DataExportControl(string strCurrentCulture)
|
{
|
this.strCurrentCulture = strCurrentCulture;
|
}
|
|
#region 执行吸液，返回结果字符串
|
/// <summary>
|
/// 执行吸液，返回结果字符串
|
/// </summary>
|
/// <param name="methodNode">装载方法属性节点对象</param>
|
/// <param name="dataTable">最终的移液数据表</param>
|
/// <param name="isSimulator">0:连接谁；1：仿真</param>
|
/// <returns></returns>
|
public bool ExecuteDataExport( XmlNode methodNode, DataTable dataTable,bool isSimulator)
|
{
|
bool result = true;
|
try
|
{
|
|
if (launchView._cancelSource.IsCancellationRequested)
|
{
|
result = false;
|
return result;
|
}
|
|
if (strCurrentCulture.Equals("zh-CN"))
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + methodNode.SelectSingleNode("name").InnerText + "】" + Properties.MachineRunResource.strStart.ToString());
|
}
|
else
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + methodNode.SelectSingleNode("name").InnerText + "】start:");
|
}
|
|
#region 数据准备
|
string name = methodNode.SelectSingleNode("name").InnerText;
|
string filePath = methodNode.SelectSingleNode("filePath").InnerText;
|
MethodDataExport methodDataExport = dataExportBll.GenerateMethodDataExport(methodNode);
|
List<ReportColumn> reportColumns = methodDataExport.reportColumns;
|
string filePostfix = methodNode.SelectSingleNode("filePostfix").InnerText;
|
string fileName = methodNode.SelectSingleNode("fileName").InnerText;
|
List<DropdownName> dropdownNames = dataExportBll.GenerateReportColumn();
|
#endregion
|
|
#region 数据验证
|
if (string.IsNullOrEmpty(fileName))
|
{
|
if (strCurrentCulture.Equals("zh-CN"))
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + name + "】" + Properties.DataExportResource.strFileNameEmpty.ToString());
|
}
|
else
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + name + "】:" + "file name is empty.");
|
}
|
|
result = false;
|
return result;
|
}
|
|
if(reportColumns.Count==0)
|
{
|
if (strCurrentCulture.Equals("zh-CN"))
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + name + "】" + Properties.DataExportResource.strColumnEmpty.ToString());
|
}
|
else
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + name + "】:" + "file column don't set.");
|
}
|
|
result = false;
|
return result;
|
}
|
|
if (string.IsNullOrEmpty(filePath))
|
{
|
if (strCurrentCulture.Equals("zh-CN"))
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + name + "】" + Properties.DataExportResource.strFilePathEmpty.ToString());
|
}
|
else
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】> Xhandler: 【" + name + "】:" + "file path don't set.");
|
}
|
|
result = false;
|
return result;
|
}
|
|
#endregion
|
|
#region 执行
|
DataTable dt = new DataTable();
|
if(dataTable != null)
|
{
|
//创建表结构
|
foreach(DataColumn c in dataTable.Columns)
|
{
|
foreach (ReportColumn r in reportColumns)
|
{
|
DataColumn d = new DataColumn();
|
d.ColumnName = r.reportcolumn_sname;
|
|
if (r.reportcolumn_name == dropdownNames[0].dropdown_name && c.ColumnName == r.reportcolumn_name)//表Id
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (r.reportcolumn_name== dropdownNames[1].dropdown_name&&c.ColumnName==r.reportcolumn_name)//来源板名称
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[2].dropdown_name && c.ColumnName == r.reportcolumn_name)//来源板barcode
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[3].dropdown_name && c.ColumnName == r.reportcolumn_name)//来源板孔位
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[4].dropdown_name && c.ColumnName == r.reportcolumn_name)//目标板名称
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[5].dropdown_name && c.ColumnName == r.reportcolumn_name)//目标板barcode
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[6].dropdown_name && c.ColumnName == r.reportcolumn_name)//目标板孔位
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[7].dropdown_name && c.ColumnName == r.reportcolumn_name)//移液体积
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[8].dropdown_name && c.ColumnName == r.reportcolumn_name)//移液开始时间
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[9].dropdown_name && c.ColumnName == r.reportcolumn_name)//移液完成时间
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
if (c.ColumnName == dropdownNames[10].dropdown_name && c.ColumnName == r.reportcolumn_name)//移液完成结果
|
{
|
dt.Columns.Add(d);
|
break;
|
}
|
}
|
}
|
|
//复制表数据
|
for(int i=0;i<dataTable.Rows.Count;i++)
|
{
|
DataRow dr = dt.NewRow();
|
foreach (ReportColumn r in reportColumns)
|
{
|
if (dt.Columns.Contains(r.reportcolumn_sname))
|
{
|
dr[r.reportcolumn_sname] = dataTable.Rows[i][r.reportcolumn_name].ToString();
|
}
|
}
|
dt.Rows.Add(dr);
|
}
|
|
//根据设置导出为csv或excel
|
string fileFullPath = filePath + "\\"+fileName + filePostfix;
|
if (filePostfix== ".csv")
|
{
|
if(File.Exists(fileFullPath))
|
{
|
File.Delete(fileFullPath);
|
}
|
ExcelAndCsvHelper.WriteDataTableToCSV(dt, fileFullPath);
|
}
|
else if(filePostfix== ".xls")
|
{
|
if (File.Exists(fileFullPath))
|
{
|
File.Delete(fileFullPath);
|
|
}
|
|
ExcelAndCsvHelper.WriteDataTableToExcelFile(dt, fileFullPath);
|
}
|
|
if (strCurrentCulture.Equals("zh-CN"))
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】>Xhandler: 【" + methodNode.SelectSingleNode("name").InnerText + "】" + Properties.MachineRunResource.strProgress.ToString() + Properties.MachineRunResource.strEnd.ToString());
|
}
|
else
|
{
|
launchView.AddLogs("【" + DateTime.Now.ToString("HH:mm:ss:fff") + "】>Xhandler: 【" + methodNode.SelectSingleNode("name").InnerText + "】progress: complete;");
|
}
|
}
|
#endregion
|
}
|
catch(Exception ex)
|
{
|
LoggerHelper.ErrorLog("ERROR:", ex);
|
result = false;
|
}
|
return result;
|
}
|
#endregion
|
}
|
}
|
