private void BtnDownLoadExcelModel_Click(object sender, RoutedEventArgs e)
{
Microsoft.Win32.SaveFileDialog fileDialog = new Microsoft.Win32.SaveFileDialog
{
Title = "导出Excel",
FileName = "订单Excel模板",
Filter = "xlsx 文件(*.xlsx)|*.xlsx|xls 文件(*.xls)|*.xls"
};
if (fileDialog.ShowDialog() == true)
{
DataTable dt = new DataTable();
#region ==DataTable组装==
dt.Columns.Add("规格型号");
dt.Columns.Add("订单号");
dt.Columns.Add("编号范围");
dt.Columns.Add("环境温度");
dt.Columns.Add("环境湿度");
dt.Columns.Add("检验员");
dt.Columns.Add("检验日期");
dt.Columns.Add("审核人");
dt.Columns.Add("审核日期");
DataRow row2 = dt.NewRow();
row2["规格型号"] = "从此行开始导入，温湿度填入不带单位,湿度为百分比";
dt.Rows.Add(row2);
#endregion
var fileName = fileDialog.FileName;
using (var helper = new NPOIExcelHepler(fileName))
{
helper.DataTableToExcel(dt, "订单信息", true);
}
}
}
/// <summary>
/// 上传
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnUpLoadWoExcel_Click(object sender, RoutedEventArgs e)
{
try
{
if (string.IsNullOrWhiteSpace(txtModelDirPath.Text))
{
MessageBox.Show("请先选择检验报告模板所在文件夹");
return;
}
var workOrderInfos = new List <WorkOrderInfo>();
//上传，读取数据
Microsoft.Win32.OpenFileDialog ofd = new Microsoft.Win32.OpenFileDialog
{
Filter = "*.xls;*.xlsx| *.xls;*.xlsx"
};
if (ofd.ShowDialog() == true)
{
using (var eh = new NPOIExcelHepler(ofd.FileName))
{
DataTable DtExcelBoms;
DtExcelBoms = eh.ExcelToDataTable(null);
if (DtExcelBoms == null)
{
MessageBox.Show("文件格式不正确，无法读取数据！");
eh.Dispose();
}
else if (DtExcelBoms.Rows.Count == 0)
{
MessageBox.Show("文件无有效数据！");
eh.Dispose();
}
else
{
var rowcount = DtExcelBoms.Rows.Count;
Dictionary <string, string> columnMap = new Dictionary <string, string>();
List <string> checkcolumnNames = new List <string> {
"规格型号", "订单号", "编号范围", "环境温度", "环境湿度", "检验员", "检验日期", "审核人", "审核日期"
};
List <string> columnNames = new List <string>();
foreach (DataColumn colum in DtExcelBoms.Columns)
{
columnNames.Add(colum.ColumnName);
}
var exlist = checkcolumnNames.Except(columnNames);
int excount = exlist.Count();
if (excount > 0)
{
MessageBox.Show("文件格式不正确，无法正确读取数据！");
return;
}
for (int i = 0; i < DtExcelBoms.Rows.Count; i++)
{
WorkOrderInfo workOrderInfo = new WorkOrderInfo
{
Spec = Convert.ToString(DtExcelBoms.Rows[i]["规格型号"]).Trim(),
WorkOrderNo = Convert.ToString(DtExcelBoms.Rows[i]["订单号"]).Trim(),
NumberRange = Convert.ToString(DtExcelBoms.Rows[i]["编号范围"]).Trim(),
Temperature = Convert.ToDouble(DtExcelBoms.Rows[i]["环境温度"]),
Humidity = Convert.ToDouble(DtExcelBoms.Rows[i]["环境湿度"]),
Tester = Convert.ToString(DtExcelBoms.Rows[i]["检验员"]).Trim(),
TestDate = Convert.ToDateTime(DtExcelBoms.Rows[i]["检验日期"]),
Auditor = Convert.ToString(DtExcelBoms.Rows[i]["审核人"]).Trim(),
AuditDate = Convert.ToDateTime(DtExcelBoms.Rows[i]["审核日期"])
};
workOrderInfos.Add(workOrderInfo);
}
}
}
}
foreach (var woinfo in workOrderInfos)
{
CreateReportWord(woinfo, txtModelDirPath.Text);
}
MessageBox.Show("报告文件生成结束。");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
