yhj
2025-05-21 3c766045d34e46f1d5e71f217b4e2dd3c8727634
解析oracle信息
已修改30个文件
62 ■■■■ 文件已修改
gdbg/.vs/gdbg/v17/.suo 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/.vs/gdbg/v17/DocumentLayout.json 17 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/Controllers/PrintController.cs 35 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/Properties/PublishProfiles/FolderProfile.pubxml.user 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Debug/net8.0/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Debug/net8.0/gdbg.exe 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Debug/net8.0/gdbg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Release/net8.0/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Release/net8.0/gdbg.exe 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Release/net8.0/gdbg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Release/net8.0/publish/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Release/net8.0/publish/gdbg.exe 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/bin/Release/net8.0/publish/gdbg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/apphost.exe 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/gdbg.AssemblyInfo.cs 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/gdbg.AssemblyInfoInputs.cache 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/gdbg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/ref/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Debug/net8.0/refint/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/PubTmp/Out/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/PubTmp/Out/gdbg.exe 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/PubTmp/Out/gdbg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/apphost.exe 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/gdbg.AssemblyInfo.cs 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/gdbg.AssemblyInfoInputs.cache 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/gdbg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/ref/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/gdbg/obj/Release/net8.0/refint/gdbg.dll 补丁 | 查看 | 原始文档 | blame | 历史
gdbg/.vs/gdbg/v17/.suo
Binary files differ
gdbg/.vs/gdbg/v17/DocumentLayout.json
@@ -84,7 +84,7 @@
              "RelativeDocumentMoniker": "gdbg\\Controllers\\PrintController.cs",
              "ToolTip": "D:\\dm\\zsbg_jk\\XM_GK_HD\\gdbg\\gdbg\\Controllers\\PrintController.cs",
              "RelativeToolTip": "gdbg\\Controllers\\PrintController.cs",
              "ViewState": "AgIAABEAAAAAAAAAAAAWwCUAAAAgAAAAAAAAAA==",
              "ViewState": "AgIAAHwAAAAAAAAAAAAAAIEAAAAiAAAAAAAAAA==",
              "Icon": "ae27a6b0-e345-4288-96df-5eaf394ee369.000738|",
              "WhenOpened": "2024-10-11T09:39:57.204Z",
              "IsPinned": true,
@@ -216,7 +216,8 @@
              "RelativeToolTip": "gdbg\\Models\\StartProductionRequest.cs",
              "ViewState": "AQIAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
              "Icon": "ae27a6b0-e345-4288-96df-5eaf394ee369.000738|",
              "WhenOpened": "2025-04-10T02:58:24.352Z"
              "WhenOpened": "2025-04-10T02:58:24.352Z",
              "EditorCaption": ""
            },
            {
              "$type": "Document",
@@ -228,7 +229,8 @@
              "RelativeToolTip": "gdbg\\Models\\PrintLogRequest.cs",
              "ViewState": "AQIAAAAAAAAAAAAAAAAAAAoAAAA2AAAA",
              "Icon": "ae27a6b0-e345-4288-96df-5eaf394ee369.000738|",
              "WhenOpened": "2025-03-21T02:12:49.317Z"
              "WhenOpened": "2025-03-21T02:12:49.317Z",
              "EditorCaption": ""
            },
            {
              "$type": "Document",
@@ -240,7 +242,8 @@
              "RelativeToolTip": "gdbg\\Models\\Person.cs",
              "ViewState": "AQIAAAAAAAAAAAAAAADwvwAAAAAAAAAA",
              "Icon": "ae27a6b0-e345-4288-96df-5eaf394ee369.000738|",
              "WhenOpened": "2025-03-21T02:12:31.592Z"
              "WhenOpened": "2025-03-21T02:12:31.592Z",
              "EditorCaption": ""
            },
            {
              "$type": "Document",
@@ -264,7 +267,8 @@
              "RelativeToolTip": "gdbg\\Models\\FirstInspectionRequest.cs",
              "ViewState": "AQIAAAAAAAAAAAAAAAAAAAYAAAAIAAAA",
              "Icon": "ae27a6b0-e345-4288-96df-5eaf394ee369.000738|",
              "WhenOpened": "2024-10-18T08:37:54.826Z"
              "WhenOpened": "2024-10-18T08:37:54.826Z",
              "EditorCaption": ""
            },
            {
              "$type": "Document",
@@ -276,7 +280,8 @@
              "RelativeToolTip": "gdbg\\Models\\Personnel.cs",
              "ViewState": "AQIAAAAAAAAAAAAAAADwvwYAAAAAAAAA",
              "Icon": "ae27a6b0-e345-4288-96df-5eaf394ee369.000738|",
              "WhenOpened": "2024-10-10T06:29:07.394Z"
              "WhenOpened": "2024-10-10T06:29:07.394Z",
              "EditorCaption": ""
            }
          ]
        }
gdbg/gdbg/Controllers/PrintController.cs
@@ -1,9 +1,10 @@
using Microsoft.AspNetCore.Mvc;
using System.Threading.Tasks;
using gdbg.Models;
using gdbg.Services;
using System.Collections.Generic;
using Microsoft.AspNetCore.Mvc;
using Oracle.ManagedDataAccess.Client;
using gdbg.Models;
using System.Collections.Generic;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
namespace gdbg.Controllers
{
@@ -93,7 +94,8 @@
                // 其他 Oracle 错误
                return StatusCode(500, new
                {
                    message = "数据库错误:" + ex.Message
                   // message = "数据库错误:" + ex.Message
                    message = ExtractErrorMessage(ex.Message)
                });
            }
            catch (Exception ex)
@@ -117,7 +119,7 @@
            // 如果无法匹配,则返回完整错误信息
            return oracleMessage;
        }*/
        private static string ExtractErrorMessage(string oracleMessage)
 /*       private static string ExtractErrorMessage(string oracleMessage)
        {
            // 匹配多个 ORA-20002: 后的段落,提取最后一个
            var matches = System.Text.RegularExpressions.Regex.Matches(
@@ -133,9 +135,30 @@
            // 默认返回原始错误
            return oracleMessage;
        }*/
        private static string ExtractErrorMessage(string oracleMessage)
        {
            // 匹配所有 ORA-20002: 错误段
            var matches = Regex.Matches(oracleMessage, @"ORA-20002:\s*(.*?)(?=(ORA-\d{5}:|$))", RegexOptions.Singleline);
            if (matches.Count > 0)
            {
                // 返回最里面一条(最后一个)
                string raw = matches[matches.Count - 1].Groups[1].Value;
                // 去掉类似 "Error in PrintAndUpdate procedure:" 开头
                string cleaned = Regex.Replace(raw, @"^Error.*?:", "", RegexOptions.IgnoreCase).Trim();
                return string.IsNullOrWhiteSpace(cleaned) ? raw.Trim() : cleaned;
            }
            return oracleMessage; // fallback
        }
    }
}
gdbg/gdbg/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -5,7 +5,7 @@
<Project>
  <PropertyGroup>
    <_PublishTargetUrl>D:\dm\zsbg_jk\XM_GK_HD\gdbg\gdbg\bin\Release\net8.0\publish\</_PublishTargetUrl>
    <History>True|2025-05-20T03:50:05.8874923Z||;True|2025-04-24T18:57:51.0566027+08:00||;True|2025-04-24T18:48:27.9870459+08:00||;True|2025-04-23T18:40:52.0142120+08:00||;True|2025-04-23T18:17:19.7788189+08:00||;True|2025-04-10T18:39:53.8721188+08:00||;True|2025-04-10T13:27:37.5881899+08:00||;True|2025-04-10T13:13:51.5172172+08:00||;True|2025-04-10T11:03:19.0604211+08:00||;True|2025-03-26T13:09:08.2671005+08:00||;True|2025-03-26T10:37:29.8343689+08:00||;True|2025-03-21T10:54:57.6699590+08:00||;True|2024-12-19T17:27:18.4287797+08:00||;True|2024-12-19T17:13:23.0461294+08:00||;True|2024-12-18T15:50:36.6256178+08:00||;True|2024-12-18T15:42:47.9298230+08:00||;True|2024-12-18T15:27:51.4434661+08:00||;True|2024-11-27T16:24:54.4993253+08:00||;True|2024-11-27T14:25:55.8145582+08:00||;True|2024-10-22T17:46:40.3605389+08:00||;True|2024-10-22T17:34:53.9389999+08:00||;True|2024-10-21T16:05:26.0504255+08:00||;True|2024-10-21T08:25:14.9988546+08:00||;True|2024-10-19T10:37:59.7955853+08:00||;True|2024-10-19T10:32:32.4016881+08:00||;True|2024-10-18T17:46:28.8497763+08:00||;True|2024-10-18T09:22:53.0665883+08:00||;True|2024-10-10T14:54:36.4198748+08:00||;True|2024-10-08T17:44:11.0042794+08:00||;True|2024-10-08T17:41:57.3332759+08:00||;True|2024-09-28T14:33:17.3917223+08:00||;True|2024-09-27T18:01:28.2783102+08:00||;True|2024-09-27T13:50:12.6679792+08:00||;True|2024-09-26T15:06:30.2618099+08:00||;True|2024-09-26T10:46:51.1760062+08:00||;True|2024-09-26T10:18:31.4480538+08:00||;True|2024-09-26T09:56:27.2399253+08:00||;True|2024-09-25T10:48:55.0768042+08:00||;True|2024-09-25T10:37:48.2868208+08:00||;True|2024-09-25T10:30:59.7315683+08:00||;True|2024-09-14T11:16:01.2500037+08:00||;True|2024-09-14T10:20:26.8803653+08:00||;True|2024-09-14T10:01:53.8038244+08:00||;True|2024-09-14T10:01:17.3499329+08:00||;True|2024-09-14T09:58:26.3030810+08:00||;True|2024-09-13T16:59:17.7892526+08:00||;</History>
    <History>True|2025-05-21T08:20:52.0592826Z||;True|2025-05-21T09:28:41.7033879+08:00||;True|2025-05-20T11:50:05.8874923+08:00||;True|2025-04-24T18:57:51.0566027+08:00||;True|2025-04-24T18:48:27.9870459+08:00||;True|2025-04-23T18:40:52.0142120+08:00||;True|2025-04-23T18:17:19.7788189+08:00||;True|2025-04-10T18:39:53.8721188+08:00||;True|2025-04-10T13:27:37.5881899+08:00||;True|2025-04-10T13:13:51.5172172+08:00||;True|2025-04-10T11:03:19.0604211+08:00||;True|2025-03-26T13:09:08.2671005+08:00||;True|2025-03-26T10:37:29.8343689+08:00||;True|2025-03-21T10:54:57.6699590+08:00||;True|2024-12-19T17:27:18.4287797+08:00||;True|2024-12-19T17:13:23.0461294+08:00||;True|2024-12-18T15:50:36.6256178+08:00||;True|2024-12-18T15:42:47.9298230+08:00||;True|2024-12-18T15:27:51.4434661+08:00||;True|2024-11-27T16:24:54.4993253+08:00||;True|2024-11-27T14:25:55.8145582+08:00||;True|2024-10-22T17:46:40.3605389+08:00||;True|2024-10-22T17:34:53.9389999+08:00||;True|2024-10-21T16:05:26.0504255+08:00||;True|2024-10-21T08:25:14.9988546+08:00||;True|2024-10-19T10:37:59.7955853+08:00||;True|2024-10-19T10:32:32.4016881+08:00||;True|2024-10-18T17:46:28.8497763+08:00||;True|2024-10-18T09:22:53.0665883+08:00||;True|2024-10-10T14:54:36.4198748+08:00||;True|2024-10-08T17:44:11.0042794+08:00||;True|2024-10-08T17:41:57.3332759+08:00||;True|2024-09-28T14:33:17.3917223+08:00||;True|2024-09-27T18:01:28.2783102+08:00||;True|2024-09-27T13:50:12.6679792+08:00||;True|2024-09-26T15:06:30.2618099+08:00||;True|2024-09-26T10:46:51.1760062+08:00||;True|2024-09-26T10:18:31.4480538+08:00||;True|2024-09-26T09:56:27.2399253+08:00||;True|2024-09-25T10:48:55.0768042+08:00||;True|2024-09-25T10:37:48.2868208+08:00||;True|2024-09-25T10:30:59.7315683+08:00||;True|2024-09-14T11:16:01.2500037+08:00||;True|2024-09-14T10:20:26.8803653+08:00||;True|2024-09-14T10:01:53.8038244+08:00||;True|2024-09-14T10:01:17.3499329+08:00||;True|2024-09-14T09:58:26.3030810+08:00||;True|2024-09-13T16:59:17.7892526+08:00||;</History>
    <LastFailureDetails />
  </PropertyGroup>
</Project>
gdbg/gdbg/bin/Debug/net8.0/gdbg.dll
Binary files differ
gdbg/gdbg/bin/Debug/net8.0/gdbg.exe
Binary files differ
gdbg/gdbg/bin/Debug/net8.0/gdbg.pdb
Binary files differ
gdbg/gdbg/bin/Release/net8.0/gdbg.dll
Binary files differ
gdbg/gdbg/bin/Release/net8.0/gdbg.exe
Binary files differ
gdbg/gdbg/bin/Release/net8.0/gdbg.pdb
Binary files differ
gdbg/gdbg/bin/Release/net8.0/publish/gdbg.dll
Binary files differ
gdbg/gdbg/bin/Release/net8.0/publish/gdbg.exe
Binary files differ
gdbg/gdbg/bin/Release/net8.0/publish/gdbg.pdb
Binary files differ
gdbg/gdbg/obj/Debug/net8.0/apphost.exe
Binary files differ
gdbg/gdbg/obj/Debug/net8.0/gdbg.AssemblyInfo.cs
@@ -14,7 +14,7 @@
[assembly: System.Reflection.AssemblyCompanyAttribute("gdbg")]
[assembly: System.Reflection.AssemblyConfigurationAttribute("Debug")]
[assembly: System.Reflection.AssemblyFileVersionAttribute("1.0.0.0")]
[assembly: System.Reflection.AssemblyInformationalVersionAttribute("1.0.0+7b34a626f1e0d8db378ff877429464c008b42bd3")]
[assembly: System.Reflection.AssemblyInformationalVersionAttribute("1.0.0+cbe08bda49cd076c16895853954db17e5b754008")]
[assembly: System.Reflection.AssemblyProductAttribute("gdbg")]
[assembly: System.Reflection.AssemblyTitleAttribute("gdbg")]
[assembly: System.Reflection.AssemblyVersionAttribute("1.0.0.0")]
gdbg/gdbg/obj/Debug/net8.0/gdbg.AssemblyInfoInputs.cache
@@ -1 +1 @@
f76ca7f3a194454dd7007694beb73f9c43f4b053c7aede410f4cc1041121b984
7dd711d198944f40c4a9c91d279fd054ce9084f5fb28c48eea978769808f9fdb
gdbg/gdbg/obj/Debug/net8.0/gdbg.dll
Binary files differ
gdbg/gdbg/obj/Debug/net8.0/gdbg.pdb
Binary files differ
gdbg/gdbg/obj/Debug/net8.0/ref/gdbg.dll
Binary files differ
gdbg/gdbg/obj/Debug/net8.0/refint/gdbg.dll
Binary files differ
gdbg/gdbg/obj/Release/net8.0/PubTmp/Out/gdbg.dll
Binary files differ
gdbg/gdbg/obj/Release/net8.0/PubTmp/Out/gdbg.exe
Binary files differ
gdbg/gdbg/obj/Release/net8.0/PubTmp/Out/gdbg.pdb
Binary files differ
gdbg/gdbg/obj/Release/net8.0/apphost.exe
Binary files differ
gdbg/gdbg/obj/Release/net8.0/gdbg.AssemblyInfo.cs
@@ -14,7 +14,7 @@
[assembly: System.Reflection.AssemblyCompanyAttribute("gdbg")]
[assembly: System.Reflection.AssemblyConfigurationAttribute("Release")]
[assembly: System.Reflection.AssemblyFileVersionAttribute("1.0.0.0")]
[assembly: System.Reflection.AssemblyInformationalVersionAttribute("1.0.0+60fd52175b5e3c788ddca4c11b4329dbfe959694")]
[assembly: System.Reflection.AssemblyInformationalVersionAttribute("1.0.0+cbe08bda49cd076c16895853954db17e5b754008")]
[assembly: System.Reflection.AssemblyProductAttribute("gdbg")]
[assembly: System.Reflection.AssemblyTitleAttribute("gdbg")]
[assembly: System.Reflection.AssemblyVersionAttribute("1.0.0.0")]
gdbg/gdbg/obj/Release/net8.0/gdbg.AssemblyInfoInputs.cache
@@ -1 +1 @@
753b0e4b875ba7e07ee18a32e617a3c0694e3d911647b848089d1c3987abcb29
2174de2ad3d6fdd04a104be75e4bd89f8a44f9ed527a8ef8ebfd93a12b6bd780
gdbg/gdbg/obj/Release/net8.0/gdbg.dll
Binary files differ
gdbg/gdbg/obj/Release/net8.0/gdbg.pdb
Binary files differ
gdbg/gdbg/obj/Release/net8.0/ref/gdbg.dll
Binary files differ
gdbg/gdbg/obj/Release/net8.0/refint/gdbg.dll
Binary files differ