From d84ac8a7ee3121b791d8d4d59ab6f2b766796948 Mon Sep 17 00:00:00 2001
From: cnf <3200815559@qq.com>
Date: 星期一, 24 三月 2025 13:45:34 +0800
Subject: [PATCH] 异常处置单完成
---
MES.Service/service/SentLaboratory/SentLaboratoryTestingItemsManager.cs | 37 +++++++++++++++++++++++++++++++++++++
1 files changed, 37 insertions(+), 0 deletions(-)
diff --git a/MES.Service/service/BasicData/SentLaboratoryTestingItemsManager.cs b/MES.Service/service/SentLaboratory/SentLaboratoryTestingItemsManager.cs
similarity index 71%
rename from MES.Service/service/BasicData/SentLaboratoryTestingItemsManager.cs
rename to MES.Service/service/SentLaboratory/SentLaboratoryTestingItemsManager.cs
index 8afcff2..c4c69fe 100644
--- a/MES.Service/service/BasicData/SentLaboratoryTestingItemsManager.cs
+++ b/MES.Service/service/SentLaboratory/SentLaboratoryTestingItemsManager.cs
@@ -1,8 +1,15 @@
锘縰sing MES.Service.DB;
+using MES.Service.Dto.webApi.QcIssueResult;
using MES.Service.Modes;
+using MES.Service.Modes.QcIssueResult;
+using MES.Service.Modes.SentLaboratory;
+using Microsoft.Data.SqlClient;
+using Newtonsoft.Json;
+using Oracle.ManagedDataAccess.Client;
using SqlSugar;
using System;
using System.Collections.Generic;
+using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
@@ -72,4 +79,34 @@
.ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
}
+
+ public string GetBillCode(string param1, string param2, string param3)
+ {
+ string result = null;
+ // 杩炴帴瀛楃涓�
+ string connectionString = "User Id=yc_dev;Password=ycdev;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.100)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))";
+
+ // SQL 鏌ヨ
+ string sql = "SELECT getbillcode1(:param1, :param2, :param3) FROM dual";
+
+ using (OracleConnection connection = new OracleConnection(connectionString))
+ {
+ using (OracleCommand command = new OracleCommand(sql, connection))
+ {
+ // 娣诲姞鍙傛暟
+ command.Parameters.Add("param1", OracleDbType.Varchar2).Value = param1;
+ command.Parameters.Add("param2", OracleDbType.Varchar2).Value = param2;
+ command.Parameters.Add("param3", OracleDbType.Varchar2).Value = param3;
+
+ // 鎵撳紑杩炴帴
+ connection.Open();
+
+ // 鎵ц鏌ヨ
+ result = command.ExecuteScalar()?.ToString();
+ }
+ }
+
+ return result;
+ }
+
}
--
Gitblit v1.9.3