优化HMI;

alielie

2025-10-13 e3868d4d61ded0e76fc8fe3fdacdd9e6d9113cf1

 HMI.Util/ExcelHelper.cs

@@ -45,7 +45,7 @@
                {
                    var attr = attrs[j];
                    var value = attr.IgnoreExport ? "" : properties[j].GetValue(datas[i]);
                    rowTemp.CreateCell(j).SetCellValue(value.ToString());
                    rowTemp.CreateCell(j).SetCellValue(value?.ToString());
                }
            }

@@ -72,74 +72,86 @@
            using (FileStream fileStream1 = new FileStream(sourcePath, FileMode.Open, FileAccess.Read))
            {
                IWorkbook workbook = null;
                if (sourcePath.EndsWith(".xlsx"))
                {
                    workbook = new XSSFWorkbook(fileStream1);
                }
                else if (sourcePath.EndsWith(".xls"))
                if (sourcePath.EndsWith(".xls"))
                {
                    workbook = new HSSFWorkbook(fileStream1);
                }

                ISheet sheet = workbook.GetSheetAt(0);
                IRow titleRow = sheet.GetRow(0);

                List<T> result = new List<T>();
                IRow row;
                for (int i = 1; i < (sheet.LastRowNum + 1); i++)
                else
                {
                    row = sheet.GetRow(i);
                    if (row != null)
                    {
                        T obj = (T)Activator.CreateInstance(type);
                        bool isEmpty = true;
                        for (int j = 0; j < row.Count(); j++)
                        {
                            string title = titleRow.GetCell(j).StringCellValue;
                            if (dict.ContainsKey(title))
                            {
                                var cell = row.GetCell(j);
                                if (cell == null || cell.CellType == CellType.Blank)
                                    continue;
                                CellType ct = cell.CellType;
                                object value = null;
                                if (ct == CellType.String)
                                    value = row.GetCell(j).StringCellValue;
                                else if (ct == CellType.Numeric)
                                    value = row.GetCell(j).NumericCellValue;
                                else if (ct == CellType.Boolean)
                                    value = row.GetCell(j).BooleanCellValue;

                                var prop = dict[title];
                                if (prop.PropertyType == typeof(string))
                                {
                                    value = Convert.ToString(value);
                                }
                                else if (prop.PropertyType == typeof(double) || prop.PropertyType == typeof(double?))
                                {
                                    value = Convert.ToDouble(value);
                                }
                                else if (prop.PropertyType == typeof(int) || prop.PropertyType == typeof(int?))
                                {
                                    value = Convert.ToInt16(value);
                                }
                                else if (prop.PropertyType == typeof(bool) || prop.PropertyType == typeof(bool?))
                                {
                                    value = Convert.ToBoolean(value);
                                }
                                else if (prop.PropertyType.IsEnum)
                                {
                                    value = Enum.Parse(prop.PropertyType, value.ToString());
                                }
                                prop.SetValue(obj, value);
                                isEmpty = false;
                            }
                        }
                        if (!isEmpty) result.Add(obj);
                    }
                    workbook = new XSSFWorkbook(fileStream1);
                }
                workbook.Close();
                return result;
                int currentRow = 1;
                try
                {
                    ISheet sheet = workbook.GetSheetAt(0);
                    IRow titleRow = sheet.GetRow(0);

                    List<T> result = new List<T>();
                    IRow row;
                    for (currentRow = 1; currentRow < (sheet.LastRowNum + 1); currentRow++)
                    {
                        row = sheet.GetRow(currentRow);
                        if (row != null)
                        {
                            T obj = (T)Activator.CreateInstance(type);
                            bool isEmpty = true;
                            for (int j = 0; j < row.Count(); j++)
                            {
                                string title = titleRow.Cells[j].StringCellValue;
                                if (dict.ContainsKey(title))
                                {
                                    var cell = row.GetCell(j);
                                    if (cell == null || cell.CellType == CellType.Blank)
                                        continue;
                                    CellType ct = cell.CellType;
                                    object value = null;
                                    if (ct == CellType.String)
                                        value = row.GetCell(j).StringCellValue;
                                    else if (ct == CellType.Numeric)
                                        value = row.GetCell(j).NumericCellValue;
                                    else if (ct == CellType.Boolean)
                                        value = row.GetCell(j).BooleanCellValue;
                                    else
                                        value = row.GetCell(j).StringCellValue;

                                    var prop = dict[title];
                                    if (prop.PropertyType == typeof(string))
                                    {
                                        value = Convert.ToString(value);
                                    }
                                    else if (prop.PropertyType == typeof(double) || prop.PropertyType == typeof(double?))
                                    {
                                        value = Convert.ToDouble(value);
                                    }
                                    else if (prop.PropertyType == typeof(int) || prop.PropertyType == typeof(int?))
                                    {
                                        value = Convert.ToInt16(value);
                                    }
                                    else if (prop.PropertyType == typeof(bool) || prop.PropertyType == typeof(bool?))
                                    {
                                        value = Convert.ToBoolean(value);
                                    }
                                    else if (prop.PropertyType.IsEnum)
                                    {
                                        value = Enum.Parse(prop.PropertyType, value.ToString());
                                    }
                                    prop.SetValue(obj, value);
                                    isEmpty = false;
                                }
                            }
                            if (!isEmpty) result.Add(obj);
                        }
                    }
                    return result;
                }
                catch (Exception ex)
                {
                    throw new Exception($"第{currentRow}行解析错误：{ex.Message}", ex);
                }
                finally
                {
                    workbook.Close();
                }
            }
        }
    }