煜昌接口代码
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
cnf
2025-03-24 d84ac8a7ee3121b791d8d4d59ab6f2b766796948 
 MES.Service/service/SentLaboratory/SentLaboratoryTestingItemsManager.cs


ÎļþÃû´Ó MES.Service/service/BasicData/SentLaboratoryTestingItemsManager.cs ÐÞ¸Ä


@@ -1,8 +1,15 @@


using 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;


    }




}