Merge branch 'master' of http://gitblit.broconcentric.com:8088/r/M071

xcd

2020-07-14 6ca2f993973295e4da82634761da0e5c00e0ef8e

 src/ExcelTest/Form1.cs

New file
@@ -0,0 +1,122 @@
using Bro.M071.DBManager;
using Bro.M071.Model.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace ExcelTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SaveExcel();
            //SaveTxt();
        }

        public async void SaveExcel()
        {
            //if (!Config.IsCSVOutputEnabled)
            //    return;

            await Task.Run(() =>
            {
                var measurementUnitResultAndKeyUnitDataSet = new ProductionMeasurementUnitResultAndKeyUnitDataSet();
                measurementUnitResultAndKeyUnitDataSet.KeyUnitDataList = new List<KeyUnitData>();
                measurementUnitResultAndKeyUnitDataSet.MeasurementUnitResultList = new List<MeasurementUnitResult>();
                for (int i = 0; i < 10; i++)
                {
                    KeyUnitData keyUnitData = new KeyUnitData();
                    keyUnitData.Key = "A" + i;
                    keyUnitData.MeasurementItem = "Z" + i;
                    keyUnitData.ItemValue = (i / 10).ToString();
                    measurementUnitResultAndKeyUnitDataSet.KeyUnitDataList.Add(keyUnitData);


                    MeasurementUnitResult measurementUnitResult = new MeasurementUnitResult();
                    measurementUnitResult.ProductionMeasurementRecordsId = Guid.NewGuid().ToString();
                    measurementUnitResult.MeasurementName = "测试" + i;
                    measurementUnitResult.MeasurementType = "Slant";
                    measurementUnitResult.MeasurementValue = (i + 10).ToString();
                    measurementUnitResult.MeasurementResult = (i % 2) == 1? "OK":"NG";

                    measurementUnitResultAndKeyUnitDataSet.MeasurementUnitResultList.Add(measurementUnitResult);
                }


                ExcelExportSet excelExportDto = new ExcelExportSet();
                excelExportDto.Worksheets = new List<string>() { "原始数据", "检测结果" };
                var keyUnitColumns = new Dictionary<string, string>()
                {
                    {"Key", "键"},
                    {"MeasurementItem", "检测项"},
                    {"ItemValue", "检测值"}
                };
                var measurementUnitResultColumns = new Dictionary<string, string>()
                {
                    {"MeasurementName", "检测名称"},
                    {"MeasurementType", "检测类型"},
                    {"MeasurementValue", "检测值"},
                    {"MeasurementResult", "检测结果"},
                };
                excelExportDto.WorksheetColumns[excelExportDto.Worksheets[0]] = keyUnitColumns;
                excelExportDto.WorksheetColumns[excelExportDto.Worksheets[1]] = measurementUnitResultColumns;

                excelExportDto.WorksheetDataTable[excelExportDto.Worksheets[0]] = ExcelExportHelper.ListToDataTable(measurementUnitResultAndKeyUnitDataSet.KeyUnitDataList, keyUnitColumns);
                excelExportDto.WorksheetDataTable[excelExportDto.Worksheets[1]] = ExcelExportHelper.ListToDataTable(measurementUnitResultAndKeyUnitDataSet.MeasurementUnitResultList, measurementUnitResultColumns); ;

               
                string dir = Path.Combine(@"D:\PROJECTS\M071", DateTime.Now.ToString("yyyyMMdd"));
                if (!Directory.Exists(dir))
                {
                    Directory.CreateDirectory(dir);
                }
                var fileName = Path.Combine(dir, $"test_133536.xlsx");
                byte[] filecontent = ExcelExportHelper.CreateOrAppendExcel(excelExportDto, fileName);
                FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write);
                fs.Write(filecontent, 0, filecontent.Length);
                fs.Flush();
                fs.Close();
            });
        }
        public void SaveTxt()
        {
            FileStream fs = null;
            string filePath = "D:\\file1.txt";
            //将待写的入数据从字符串转换为字节数组  
            Encoding encoder = Encoding.UTF8;
            byte[] bytes = encoder.GetBytes("Hello World! \n\r");
            try
            {
                //fs = File.OpenWrite(filePath);
                ////设定书写的开始位置为文件的末尾  
                //fs.Position = fs.Length;

                fs = File.Open(filePath, FileMode.Append, FileAccess.Write);
                //将待写入内容追加到文件末尾  
                fs.Write(bytes, 0, bytes.Length);
               
            }
            catch (Exception ex)
            {
                Console.WriteLine("文件打开失败{0}", ex.ToString());
            }
            finally
            {
                fs.Close();
            }
        }
    }
}