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();
}
}
|