借助网络配置,控制Modbus工具的日志显示,避免卡死界面
智能大石头 authored at 2021-12-11 22:09:19
5.50 KiB
XCoder
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Text;
using NewLife;

namespace NewLife.XCoder.Tools.Coord;

/// <summary>批量坐标行</summary>
/// <param name="Index">行号(从 1 开始,便于用户对上原始文件)</param>
/// <param name="Lng">经度</param>
/// <param name="Lat">纬度</param>
/// <param name="Name">可选名称列</param>
public sealed record CoordPoint(Int32 Index, Double Lng, Double Lat, String Name = "");

/// <summary>坐标批量转换:解析文本、逐行转换、输出 CSV</summary>
/// <remarks>
/// 支持每行「经度,纬度」或「经度,纬度,名称」,忽略空行与 # 注释行,
/// 解析失败的行不中断整批,只记录到 <see cref="CoordBatchResult.Failed"/> 里回报用户。
/// </remarks>
public static class CoordBatch
{
    /// <summary>解析批量文本</summary>
    /// <param name="text">文本,每行一条坐标</param>
    /// <param name="points">解析成功的坐标</param>
    /// <param name="failedLines">解析失败的行号</param>
    public static void Parse(String? text, out IReadOnlyList<CoordPoint> points, out IReadOnlyList<Int32> failedLines)
    {
        var list = new List<CoordPoint>();
        var failed = new List<Int32>();

        points = list;
        failedLines = failed;
        if (text.IsNullOrWhiteSpace()) return;

        var lines = text!.Split('\n');
        for (var i = 0; i < lines.Length; i++)
        {
            var line = lines[i].Trim().Trim('\r');
            if (line.Length == 0 || line.StartsWith("#", StringComparison.Ordinal)) continue;

            var parts = SplitFields(line);
            if (parts.Length < 2)
            {
                failed.Add(i + 1);
                continue;
            }

            if (!Double.TryParse(parts[0].Trim(), NumberStyles.Float, CultureInfo.InvariantCulture, out var lng)
                || !Double.TryParse(parts[1].Trim(), NumberStyles.Float, CultureInfo.InvariantCulture, out var lat))
            {
                failed.Add(i + 1);
                continue;
            }

            var name = parts.Length > 2 ? parts[2].Trim() : "";
            list.Add(new CoordPoint(i + 1, lng, lat, name));
        }
    }

    /// <summary>按逗号拆分字段,支持双引号包裹(名称里带逗号时必用)</summary>
    /// <param name="line">一整行</param>
    /// <returns>字段数组</returns>
    public static String[] SplitFields(String? line)
    {
        var list = new List<String>();
        if (line == null) return [];

        var sb = new StringBuilder();
        var inQuotes = false;
        for (var i = 0; i < line.Length; i++)
        {
            var ch = line[i];
            if (inQuotes)
            {
                if (ch == '"')
                {
                    // 连续两个引号表示一个转义引号
                    if (i + 1 < line.Length && line[i + 1] == '"')
                    {
                        sb.Append('"');
                        i++;
                    }
                    else
                    {
                        inQuotes = false;
                    }
                }
                else
                {
                    sb.Append(ch);
                }
            }
            else if (ch == '"')
            {
                inQuotes = true;
            }
            else if (ch == ',')
            {
                list.Add(sb.ToString());
                sb.Clear();
            }
            else
            {
                sb.Append(ch);
            }
        }

        list.Add(sb.ToString());

        return [.. list];
    }

    /// <summary>批量转换</summary>
    /// <param name="points">输入坐标</param>
    /// <param name="from">源坐标系</param>
    /// <param name="to">目标坐标系</param>
    /// <returns>转换结果</returns>
    public static IReadOnlyList<(CoordPoint Source, Double Lng, Double Lat)> Convert(IReadOnlyList<CoordPoint> points, String from, String to)
    {
        var list = new List<(CoordPoint, Double, Double)>();
        if (points == null) return [];

        foreach (var point in points)
        {
            var (lng, lat) = CoordConverter.Convert(point.Lng, point.Lat, from, to);
            list.Add((point, lng, lat));
        }

        return list;
    }

    /// <summary>把转换结果格式化为 CSV 文本</summary>
    /// <param name="rows">转换结果</param>
    /// <param name="from">源坐标系(写进表头)</param>
    /// <param name="to">目标坐标系(写进表头)</param>
    /// <returns>CSV 文本</returns>
    public static String ToCsv(IReadOnlyList<(CoordPoint Source, Double Lng, Double Lat)> rows, String from, String to)
    {
        if (rows == null || rows.Count == 0) return "";

        var sb = new StringBuilder();
        sb.AppendLine($"名称,原经度({from}),原纬度({from}),新经度({to}),新纬度({to}),行号");

        foreach (var row in rows)
        {
            var name = row.Source.Name;
            if (name.Contains(',') || name.Contains('"')) name = "\"" + name.Replace("\"", "\"\"") + "\"";

            sb.AppendLine(String.Join(',',
                name,
                row.Source.Lng.ToString("F7", CultureInfo.InvariantCulture),
                row.Source.Lat.ToString("F7", CultureInfo.InvariantCulture),
                row.Lng.ToString("F7", CultureInfo.InvariantCulture),
                row.Lat.ToString("F7", CultureInfo.InvariantCulture),
                row.Source.Index.ToString()));
        }

        return sb.ToString();
    }
}