| | |
| | | // 字段映射配置(字段名 -> 数据库列名) |
| | | var fieldMappings = new Dictionary<string, (string Field, string Default)> |
| | | { |
| | | ["sqr"] = ("sqr", "0"), // 默认值改为数字 |
| | | ["sqrq"] = ("sqrq", ""), // 空字符串用于日期格式化 |
| | | ["szbm"] = ("szbm", "0"), // 默认值改为数字 |
| | | ["szdw"] = ("szdw", "0"), // 默认值改为数字 |
| | | ["ycczdh"] = ("ycczdh", "N/A"), |
| | | ["wlbm"] = ("wlbm", "N/A"), |
| | | ["lh"] = ("lh", "N/A"), |
| | | ["khgys"] = ("khgys", "N/A"), |
| | | ["jzmcwlmc"] = ("jzmcwlmc", "N/A"), |
| | | ["dhdhmes"] = ("dhdhmes", "N/A"), |
| | | ["dhdhtxt"] = ("dhdhtxt", "N/A"), |
| | | ["bhgpqxms"] = ("bhgpqxms", "无缺陷描述") |
| | | }; |
| | | |
| | |
| | | var result = new JArray(); |
| | | foreach (var mapping in fieldMappings) |
| | | { |
| | | var value = GetDynamicValue(firstRecord, mapping.Value.Field, mapping.Value.Default); |
| | | var value = mapping.Key switch |
| | | { |
| | | "sqr" or "szbm" or "szdw" => |
| | | int.TryParse(GetDynamicValue(firstRecord, mapping.Value.Field, mapping.Value.Default), out int num) |
| | | ? num : 0, |
| | | "sqrq" => DateTime.TryParse(GetDynamicValue(firstRecord, mapping.Value.Field, ""), out DateTime date) |
| | | ? date.ToString("yyyy-MM-dd") |
| | | : DateTime.Now.ToString("yyyy-MM-dd"), |
| | | _ => GetDynamicValue(firstRecord, mapping.Value.Field, mapping.Value.Default) |
| | | }; |
| | | result.Add(new JObject |
| | | { |
| | | ["fieldName"] = mapping.Key, |