异常处置单完成

cnf

2025-03-24 d84ac8a7ee3121b791d8d4d59ab6f2b766796948

异常处置单完成

 MES.Service/Dto/webApi/ProductionOrder/ErpProductionOrder.cs

ÎļþÃû´Ó MES.Service/Dto/webApi/ErpProductionOrder.cs ÐÞ¸Ä
@@ -1,4 +1,4 @@
namespace MES.Service.Dto.webApi
namespace MES.Service.Dto.webApi.ProductionOrder
{
   public class ErpProductionOrder
    {

 MES.Service/Dto/webApi/ProductionOrder/ProductionsOrder.cs

ÎļþÃû´Ó MES.Service/Dto/webApi/ProductionOrder.cs ÐÞ¸Ä
@@ -4,9 +4,9 @@
using System.Text;
using System.Threading.Tasks;

namespace MES.Service.Dto.webApi
namespace MES.Service.Dto.webApi.ProductionOrder
{
    public class ProductionOrder
    public class ProductionsOrder
    {
        public ErpProductionOrder erpProductionOrder { get; set; }
    }

 MES.Service/Modes/ProductionOrder/ProductionOrders.cs

ÎļþÃû´Ó MES.Service/Modes/ProductionOrders.cs ÐÞ¸Ä
@@ -1,6 +1,6 @@
using SqlSugar;

namespace MES.Service.Modes;
namespace MES.Service.Modes.ProductionOrder;

//送货单头
[SugarTable("MES_PRODUCTION_ORDER")]

 MES.Service/Modes/QcIssueResult/GetQcIssueResultDetail.cs

@@ -10,19 +10,19 @@
public class GetQcIssueResultDetail
{
    //数量
    [SugarColumn(ColumnName = "FBATCH_QTY")]

    public string? FbatchQty { get; set; }

    //产品名称
    [SugarColumn(ColumnName = "ITEM_NAME")]
  
    public string? ItemName { get; set; }

    //规格型号
    [SugarColumn(ColumnName = "ITEM_MODEL")]

    public string? ItemModel { get; set; }

    //送检单位
    [SugarColumn(ColumnName = "SUPP_NAME")]

    public string? SuppName { get; set; }

    ////订单号(采购单号)

 MES.Service/Modes/QcIssueResult/GetReleaseNoDetail.cs

ÎļþÒÑɾ³ý

 MES.Service/Modes/QcIssueResult/UpdateMesQaItems .cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MES.Service.Modes.QcIssueResult;

[SugarTable("MES_QA_ITEMS_DETECT_01")]
public class UpdateMesQaItems
{
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }
    //送货单号
    [SugarColumn(ColumnName = "RELEASE_NO")]
    public string? ReleaseNo { get; set; }

    //送货单号
    [SugarColumn(ColumnName = "FNG_HANDLE")]
    public string? FngHandle{ get; set; }

}

 MES.Service/Modes/SentLaboratory/GetLaboratoryDetails.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,29 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MES.Service.Modes.SentLaboratory;

public class GetLaboratoryDetails
{
    public string? RELEASE_NO { get; set; }
    public string? DEPARTMENTNAME { get; set; }
    public DateTime? CREATE_DATE1 { get; set; }
    public string? LOT_NO { get; set; }
    public string? ITEM_NAME { get; set; }
    public string? QUANTITY { get; set; }
    public decimal? URGENT_FLAG { get; set; }
    public DateTime? COMPLETE_DATE { get; set; }
    public string? TEST_REQ { get; set; }
    public string? SIM_REQ { get; set; }
    public List<SentLaboratoryTestingItems>? CHECKBOX { get; set; }
    public string? Line04 { get; set; }
    public string? REMARKS { get; set; }
    public string? ITEM_NO { get; set; }
    public string? DEPARTMENTCODE { get; set; }
    public string? JYDH { get; set; }


}

 MES.Service/Modes/SentLaboratory/SentLaboratoryTestingItems.cs

ÎļþÃû´Ó MES.Service/Modes/SentLaboratoryTestingItems.cs ÐÞ¸Ä
@@ -1,6 +1,6 @@
using SqlSugar;

namespace MES.Service.Modes;
namespace MES.Service.Modes.SentLaboratory;

/// <summary>
///     å®žéªŒå®¤é€æ£€é¡¹ç›®è¡¨

 MES.Service/Modes/SentLaboratory/UpdateMesQmsSample.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,146 @@
using SqlSugar;


namespace MES.Service.Modes.SentLaboratory;

//异产品检测单表
[SugarTable("MES_QMS_SAMPLE")]
public class UpdateMesQmsSample
{
    //SEQ_QMS_EQ_CHECK
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_QMS_EQ_CHECK")]
    public decimal Id { get; set; }

    //送检单号
    [SugarColumn(ColumnName = "RELEASE_NO")]
    public string? ReleaseNo { get; set; }

    //产品编码
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    //产品名称
    [SugarColumn(ColumnName = "ITEM_NAME")]
    public string? ItemName { get; set; }

    //申请部门编号
    [SugarColumn(ColumnName = "DEPARTMENTCODE")]
    public string? DEPARTMENTCODE { get; set; }

    //申请部门名称
    [SugarColumn(ColumnName = "DEPARTMENTNAME")]
    public string? DEPARTMENTNAME { get; set; }

    //申请日期
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    //样本数量
    [SugarColumn(ColumnName = "QUANTITY")]
    public string? QUANTITY { get; set; }

    //要求完成时间
    [SugarColumn(ColumnName = "COMPLETE_DATE")]
    public DateTime? CompleteDate { get; set; }

    //测试要求
    [SugarColumn(ColumnName = "TEST_REQ")]
    public string? TestReq { get; set; }

    //急料标识
    [SugarColumn(ColumnName = "URGENT_FLAG")]
    public decimal? UrgentFlag { get; set; }

    //送货单号
    [SugarColumn(ColumnName = "PAPER_BILL_NO")]
    public string? PAPERBILLNO { get; set; }

    //备注
    [SugarColumn(ColumnName = "REMARKS")]
    public string? REMARKS { get; set; }

    //模拟要求
    [SugarColumn(ColumnName = "SIM_REQ")]
    public string? SimReq { get; set; }

    //磁铁拉力
    [SugarColumn(ColumnName = "CHECK_01")]
    public decimal? Check01 { get; set; }

    //磁铁承重
    [SugarColumn(ColumnName = "CHECK_02")]
    public decimal? Check02 { get; set; }

    //盐雾
    [SugarColumn(ColumnName = "CHECK_03")]
    public decimal? Check03 { get; set; }

    //IP
    [SugarColumn(ColumnName = "CHECK_04")]
    public decimal? Check04 { get; set; }

    //老化测试
    [SugarColumn(ColumnName = "CHECK_05")]
    public decimal? Check05 { get; set; }

    //传导辐射
    [SugarColumn(ColumnName = "CHECK_06")]
    public decimal? Check06 { get; set; }

    //跌落测试
    [SugarColumn(ColumnName = "CHECK_07")]
    public decimal? Check07 { get; set; }

    //电线拉力
    [SugarColumn(ColumnName = "CHECK_08")]
    public decimal? Check08 { get; set; }

    //接口插拔
    [SugarColumn(ColumnName = "CHECK_09")]
    public decimal? Check09 { get; set; }

    //光谱测试
    [SugarColumn(ColumnName = "CHECK_10")]
    public decimal? Check10 { get; set; }

    //ROHS
    [SugarColumn(ColumnName = "CHECK_11")]
    public decimal? Check11 { get; set; }

    //电池充放电
    [SugarColumn(ColumnName = "CHECK_12")]
    public decimal? Check12 { get; set; }

    //高温
    [SugarColumn(ColumnName = "CHECK_13")]
    public decimal? Check13 { get; set; }

    //低温
    [SugarColumn(ColumnName = "CHECK_14")]
    public decimal? Check14 { get; set; }

    //IK
    [SugarColumn(ColumnName = "CHECK_15")]
    public decimal? Check15 { get; set; }

    //温升测试
    [SugarColumn(ColumnName = "CHECK_16")]
    public decimal? Check16 { get; set; }

    //寿命
    [SugarColumn(ColumnName = "CHECK_17")]
    public decimal? Check17 { get; set; }

    //其它
    [SugarColumn(ColumnName = "CHECK_18")]
    public decimal? Check18 { get; set; }

    //其它的内容
    [SugarColumn(ColumnName = "LINE_04")]
    public string? Line04 { get; set; }

    //检验单号
    [SugarColumn(ColumnName = "JYDH")]
    public string? JYDH { get; set; }

}

 MES.Service/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/service/BasicData/ProductionOrderManager.cs

ÎļþÒÑɾ³ý

 MES.Service/service/ProductionOrder/ProductionOrderManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,278 @@
using AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models;
using AlibabaCloud.SDK.Dingtalkyida_1_0.Models;
using AlibabaCloud.TeaUtil.Models;
using MES.Service.DB;
using MES.Service.Dto.webApi.DeliveryNote;
using MES.Service.Dto.webApi.ProductionOrder;
using MES.Service.Modes.DeliveryNote;
using MES.Service.Modes.ProductionOrder;
using MES.Service.service;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using Tea;

public class ProductionOrderManager : Repository<ProductionOrders>
{
    /**
        * åˆå§‹åŒ–账号Client，用于获取token
        * @return Client
        * @throws Exception
        */
    public static AlibabaCloud.SDK.Dingtalkoauth2_1_0.Client CreateClient1()
    {
        AlibabaCloud.OpenApiClient.Models.Config config = new AlibabaCloud.OpenApiClient.Models.Config();
        config.Protocol = "https";
        config.RegionId = "central";
        return new AlibabaCloud.SDK.Dingtalkoauth2_1_0.Client(config);
    }

    /**
     * èŽ·å–钉钉的 Access Token
     * @return string è¿”回获取到的 Access Token
     */
    public string GetToken()
    {
        AlibabaCloud.SDK.Dingtalkoauth2_1_0.Client client = CreateClient1();
        AlibabaCloud.SDK.Dingtalkoauth2_1_0.Models.GetAccessTokenRequest getAccessTokenRequest = new AlibabaCloud.SDK.Dingtalkoauth2_1_0.Models.GetAccessTokenRequest
        {
            AppKey = "dingyzos0r1bizj7g6lr",
            AppSecret = "-HP4RvK2OUbqhG3iBUpd_TPe5MZRj8cfLc0b8Skt8rhC3I38kVLY9SS8P3kLWFcH",
        };

        try
        {
            var response = client.GetAccessToken(getAccessTokenRequest);
            return response.Body.AccessToken; // è¿”回获取到的 Access Token
        }
        catch (TeaException err)
        {
            Console.WriteLine($"TeaException: Code={err.Code}, Message={err.Message}");
            return null;
        }
        catch (Exception _err)
        {
            Console.WriteLine($"Exception: {_err.Message}");
            return null;
        }
    }


    /**
         * åˆå§‹åŒ–账号Client,用于OA审批相关功能
         * @return Client
         * @throws Exception
         */
    public static AlibabaCloud.SDK.Dingtalkworkflow_1_0.Client CreateClientOa()
    {
        AlibabaCloud.OpenApiClient.Models.Config config = new AlibabaCloud.OpenApiClient.Models.Config();
        config.Protocol = "https";
        config.RegionId = "central";
        return new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Client(config);
    }

    public string GetSpaceId()
    {
        string accessToken = GetToken();
        if (string.IsNullOrEmpty(accessToken))
        {
            return "获取 Access Token å¤±è´¥";
        }
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Client client = CreateClientOa();
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetAttachmentSpaceHeaders getAttachmentSpaceHeaders = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetAttachmentSpaceHeaders();
        getAttachmentSpaceHeaders.XAcsDingtalkAccessToken = accessToken;
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetAttachmentSpaceRequest getAttachmentSpaceRequest = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetAttachmentSpaceRequest
        {
            UserId = "923188102",
            AgentId = 3179487642,
        };
        try
        {

            var response = client.GetAttachmentSpaceWithOptions(getAttachmentSpaceRequest, getAttachmentSpaceHeaders, new AlibabaCloud.TeaUtil.Models.RuntimeOptions());
            return (Newtonsoft.Json.JsonConvert.SerializeObject(response.Body));
        }
        catch (TeaException err)
        {
            return $"TeaException: Code={err.Code}, Message={err.Message}";
        }
        catch (Exception _err)
        {
            return $"Exception: {_err.Message}";
        }
     }
    public string GetProcessList()
    {

        DateTime targetTime = new DateTime(2025, 3, 10, 0, 0, 0, DateTimeKind.Utc);
        // è½¬æ¢ä¸º Unix æ—¶é—´æˆ³
        long unixTimestamp = ((DateTimeOffset)targetTime).ToUnixTimeMilliseconds();
        Debug.WriteLine(unixTimestamp);  

        long currentTimestamp = ((DateTimeOffset)DateTime.UtcNow).ToUnixTimeMilliseconds();
        Debug.WriteLine(currentTimestamp);  // è¾“出当前时间的 Unix æ—¶é—´æˆ³

        string accessToken = GetToken();
        if (string.IsNullOrEmpty(accessToken))
        {
            return "获取 Access Token å¤±è´¥";
        }
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Client client = CreateClientOa();
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.ListProcessInstanceIdsHeaders listProcessInstanceIdsHeaders = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.ListProcessInstanceIdsHeaders();
        listProcessInstanceIdsHeaders.XAcsDingtalkAccessToken = accessToken;
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.ListProcessInstanceIdsRequest listProcessInstanceIdsRequest = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.ListProcessInstanceIdsRequest
        {
            ProcessCode = "PROC-BBA5632D-DC7C-4267-A3E2-757E2B7023BC",
            StartTime = unixTimestamp,
            EndTime = currentTimestamp,
            NextToken = 0,
            MaxResults = 10,
            UserIds = new List<string>
                {
                    "923188102"
                },
            //Statuses = new List<string>
            //    {
                
            //    },
        };

        try
        {
            var response = client.ListProcessInstanceIdsWithOptions(listProcessInstanceIdsRequest, listProcessInstanceIdsHeaders, new AlibabaCloud.TeaUtil.Models.RuntimeOptions());
            return (Newtonsoft.Json.JsonConvert.SerializeObject(response.Body));
        }
        catch (TeaException err)
        {
            return $"TeaException: Code={err.Code}, Message={err.Message}";
        }
        catch (Exception _err)
        {
            return $"Exception: {_err.Message}";
        }

    }

    public string GetPermissions()
    {
        string accessToken = GetToken();
        if (string.IsNullOrEmpty(accessToken))
        {
            return "获取 Access Token å¤±è´¥";
        }
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Client client = CreateClientOa();
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetSpaceWithDownloadAuthHeaders getSpaceWithDownloadAuthHeaders = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetSpaceWithDownloadAuthHeaders();
        getSpaceWithDownloadAuthHeaders.XAcsDingtalkAccessToken = accessToken;
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetSpaceWithDownloadAuthRequest getSpaceWithDownloadAuthRequest = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.GetSpaceWithDownloadAuthRequest
        {
            UserId = "071839512032683883",
            AgentId = 3179487642,
            ProcessInstanceId = "3vHyv40ZQUe2zK6wvl11dg06561742534701",
            FileId = "173564282626",
            //FileIdList = new List<string>
            //    {
            //        "123"
            //    },
        };
        try
        {
            var response = client.GetSpaceWithDownloadAuthWithOptions(getSpaceWithDownloadAuthRequest, getSpaceWithDownloadAuthHeaders, new AlibabaCloud.TeaUtil.Models.RuntimeOptions());
            return (Newtonsoft.Json.JsonConvert.SerializeObject(response.Body));
        }
        catch (TeaException err)
        {
            return $"TeaException: Code={err.Code}, Message={err.Message}";
        }
        catch (Exception _err)
        {
            return $"Exception: {_err.Message}";
        }
    }


     /**
         * åˆå§‹åŒ–账号Client,用于申请文件临时免登地址
         * @return Client
         * @throws Exception
         */
    public static AlibabaCloud.SDK.Dingtalkyida_1_0.Client CreateClient()
    {
        AlibabaCloud.OpenApiClient.Models.Config config = new AlibabaCloud.OpenApiClient.Models.Config();
        config.Protocol = "https";
        config.RegionId = "central";
        return new AlibabaCloud.SDK.Dingtalkyida_1_0.Client(config);
    }

    public string GetFileUrl(string imageUrl)
    {

        string accessToken = GetToken();
        if (string.IsNullOrEmpty(accessToken))
        {
            return "获取 Access Token å¤±è´¥";
        }
        AlibabaCloud.SDK.Dingtalkyida_1_0.Client client = CreateClient();
        AlibabaCloud.SDK.Dingtalkyida_1_0.Models.GetOpenUrlHeaders getOpenUrlHeaders = new AlibabaCloud.SDK.Dingtalkyida_1_0.Models.GetOpenUrlHeaders();
        getOpenUrlHeaders.XAcsDingtalkAccessToken = accessToken;
        AlibabaCloud.SDK.Dingtalkyida_1_0.Models.GetOpenUrlRequest getOpenUrlRequest = new AlibabaCloud.SDK.Dingtalkyida_1_0.Models.GetOpenUrlRequest
        {
            SystemToken = "54A66HC1YDSSO9DP61Y93CWQ2W9B36IZZOY6MC81",
            UserId = "923188102",
            Language = "zh_CN",
            FileUrl = imageUrl,
            Timeout = 3600000,
        };
        try
        {
           
            var response = client.GetOpenUrlWithOptions("APP_Q7PLYKXMKFUJ5HY6DMWR", getOpenUrlRequest, getOpenUrlHeaders, new AlibabaCloud.TeaUtil.Models.RuntimeOptions());
            return (Newtonsoft.Json.JsonConvert.SerializeObject(response.Body));
        }
        catch (TeaException err)
        {
            return $"TeaException: Code={err.Code}, Message={err.Message}";
        }
        catch (Exception _err)
        {
            return $"Exception: {_err.Message}";
        }
    }


    public dynamic Save(ErpProductionOrder erpProductionOrder)
    {
        //var erpProductionOrder = productionOrder.erpProductionOrder;
        var mesProductionOrder = GetMesProductionOrder(erpProductionOrder);

        return UseTransaction(db =>
        {
            return SaveOrUpdateData(db, mesProductionOrder) ? 1 : 0;
        }) > 0;
    }

    public dynamic SaveList(List<ErpProductionOrder> erpProductionOrder)
    {
        var result = erpProductionOrder.Select(Save).ToList();
        return result.All(b => b);
    }

    public ProductionOrders GetMesProductionOrder(ErpProductionOrder erpProductionOrder)
    {
        var mesProductionOrders = new ProductionOrders
        {
            ImageUrl = erpProductionOrder.ImageUrl,
            SalesOrder = erpProductionOrder.SalesOrder
        };

        return mesProductionOrders;
    }

    private bool SaveOrUpdateData(SqlSugarScope db, ProductionOrders productionOrders)
    {
        var orUpdate = base.Insert(productionOrders);
        if (orUpdate) return true;
        throw new NotImplementedException("插入或更新失败");
    }
}

 MES.Service/service/ProductionOrder/ResultDataAndSpaceId.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MES.Service.service.ProductionOrder;

public class ResultDataAndSpaceId
{
    public ResultInfo Result { get; set; }
    public bool Success { get; set; }
}
public class ResultInfo
{
    public string SpaceId { get; set; }
}

 MES.Service/service/QcIssueResult/QcIssueResultManager.cs

@@ -16,11 +16,12 @@
using MES.Service.Dto.webApi.QcIssueResult;
using MES.Service.Dto.webApi.DeliveryNote;
using MES.Service.Modes.DeliveryNote;
using Newtonsoft.Json;

namespace MES.Service.service.QcIssueResult;

//异常处置单结果表
[SugarTable("MES_QCISSUE_RESULT")]
[SugarTable("MES_QA_ITEMS_DETECT_01")]
public class QcIssueResultManager: Repository<QcIssueResults>
{
    /**
@@ -138,11 +139,14 @@
               DingDingCode=t.DingDingCode,
            })
            .ToList();
        if (mapping.Any())
        {
        string UserId = mapping.FirstOrDefault().DingDingCode;



        Debug.WriteLine(UserId);
            // ä½¿ç”¨ JSON åºåˆ—化输出对象的详细内容
            string getQcIssueResultDetailJson = JsonConvert.SerializeObject(getQcIssueResultDetail, Formatting.Indented);
            Debug.WriteLine("GetQcIssueResultDetail: " + getQcIssueResultDetailJson);

        // èŽ·å– Access Token
        string accessToken = GetToken();
@@ -158,22 +162,22 @@
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues1 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
            Name = "TextField-K2AD4O5B",
            Value = "产品名称",
                Value = getQcIssueResultDetail.ItemName,
        };
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues2 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
            Name = "TextField_DYFD1EESLVC0",
            Value = "规格型号",
                Value = getQcIssueResultDetail.ItemModel,
        };
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues3 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
            Name = "TextField_1AVN2BNVY1OG0",
            Value = "数量",
                Value = getQcIssueResultDetail.FbatchQty,
        };
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues4 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
            Name = "TextField_1DKEMESOOGSG0",
            Value = "送检单位",
                Value = getQcIssueResultDetail.SuppName,
        };
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues5 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
@@ -188,7 +192,7 @@
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues7 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
            Name = "TextareaField_1ZP3BDPMYY800",
            Value = "对不合格或潜在不合格的描述:",
                Value = getQcIssueResultDetail.remark,
        };
        AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues formComponentValues8 = new AlibabaCloud.SDK.Dingtalkworkflow_1_0.Models.StartProcessInstanceRequest.StartProcessInstanceRequestFormComponentValues
        {
@@ -278,26 +282,32 @@
            CcPosition = "START",

        };
        return "1";
        //try
        //{
        //    string requestContent = Newtonsoft.Json.JsonConvert.SerializeObject(startProcessInstanceRequest);
        //    Debug.WriteLine("startProcessInstanceRequest内容：");
        //    Debug.WriteLine(requestContent);
        //    var response = client.StartProcessInstanceWithOptions(startProcessInstanceRequest, startProcessInstanceHeaders, new RuntimeOptions());
        //    return $"钉钉工作流实例启动成功: {Newtonsoft.Json.JsonConvert.SerializeObject(response.Body)}";
        //}
        //catch (TeaException err)
        //{
        //    string requestContent = Newtonsoft.Json.JsonConvert.SerializeObject(startProcessInstanceRequest);
        //    Debug.WriteLine("startProcessInstanceRequest内容：");
        //    Debug.WriteLine(startProcessInstanceRequest);
        //    return $"TeaException: Code={err.Code}, Message={err.Message}";
        //}
        //catch (Exception _err)
        //{
        //    return $"Exception: {_err.Message}";
        //}
            // åºåˆ—化 FormComponentValues åˆ—表为 JSON æ ¼å¼
            string formComponentValuesJson = JsonConvert.SerializeObject(startProcessInstanceRequest.FormComponentValues, Formatting.Indented);
            Debug.WriteLine("FormComponentValues: " + formComponentValuesJson);
            try
            {
                string requestContent = Newtonsoft.Json.JsonConvert.SerializeObject(startProcessInstanceRequest);
                Debug.WriteLine("startProcessInstanceRequest内容：");
                Debug.WriteLine(requestContent);
                var response = client.StartProcessInstanceWithOptions(startProcessInstanceRequest, startProcessInstanceHeaders, new RuntimeOptions());
                return $"钉钉工作流实例启动成功: {Newtonsoft.Json.JsonConvert.SerializeObject(response.Body)}";
            }
            catch (TeaException err)
            {
                string requestContent = Newtonsoft.Json.JsonConvert.SerializeObject(startProcessInstanceRequest);
                Debug.WriteLine("startProcessInstanceRequest内容：");
                Debug.WriteLine(startProcessInstanceRequest);
                return $"TeaException: Code={err.Code}, Message={err.Message}";
            }
            catch (Exception _err)
            {
                return $"Exception: {_err.Message}";
            }
        }
        else {
            return "您不是公司成员或还未被加入到数据库中或名字填写错误，总之未找到匹配的用户信息";
        }
    }


@@ -357,24 +367,54 @@
    private bool SaveOrUpdateData(SqlSugarScope db, QcIssueResults qcIssueResults)
    {

        // æ£€æŸ¥ProcessNo是否已经存在于数据库中
        var existingRecord = db.Queryable<QcIssueResults>()
                               .Where(it => it.ProcessNo == qcIssueResults.ProcessNo)
                               .First(); // ä½¿ç”¨FirstOrDefault替代
        // æŸ¥è¯¢ QcIssueResults è¡¨ä¸­æ˜¯å¦å­˜åœ¨åŒ¹é…çš„记录
        var mapping = db.Queryable<QcIssueResults>()
            .Where(t => t.ProcessNo == qcIssueResults.ProcessNo)
            .Select(t => new QcIssueResults
            {
                ReleaseNo = t.ReleaseNo,
            })
            .ToList();

        if (mapping.Any())
        {
            string ReleaseNo = mapping.FirstOrDefault().ReleaseNo;

            // åªæ›´æ–° ReleaseNo å’Œ FReview ä¸¤ä¸ªå­—段
            var updateResult = db.Updateable<QcIssueResults>()
                .SetColumns(t => new QcIssueResults
                {
                    ReleaseNo = ReleaseNo,
                    FReview = qcIssueResults.FReview
                })
                .Where(t => t.ProcessNo == qcIssueResults.ProcessNo) // æ˜¾å¼æŒ‡å®šæ›´æ–°æ¡ä»¶
                .ExecuteCommand();

            // æŸ¥è¯¢ UpdateMesQaItems è¡¨ä¸­æ˜¯å¦å­˜åœ¨åŒ¹é…çš„记录
            var existingRecord = db.Queryable<UpdateMesQaItems>()
                .Where(it => it.ReleaseNo == ReleaseNo)
                .First(); // ä½¿ç”¨ First èŽ·å–第一条记录

            Debug.WriteLine($"查询到的 mapping: {JsonConvert.SerializeObject(existingRecord)}");

        if (existingRecord != null)
        {
            // å¦‚果存在，更新记录
            existingRecord.ProcessNo = qcIssueResults.ProcessNo; // å‡è®¾Data是需要更新的字段
            existingRecord.FReview = qcIssueResults.FReview; // æ›´æ–°å…¶ä»–字段
                                                                   // ... æ›´æ–°å…¶ä»–需要更新的字段
                // æ›´æ–° UpdateMesQaItems è¡¨ä¸­çš„字段
                existingRecord.FngHandle = qcIssueResults.FReview;

            // æ‰§è¡Œæ›´æ–°æ“ä½œ
            var updateResult = db.Updateable(existingRecord).ExecuteCommand();

                updateResult = db.Updateable(existingRecord).ExecuteCommand();
            return updateResult > 0; // å¦‚果更新成功，返回true
        }
        else
        {
                throw new Exception("未找到需要更新的记录");
            }
        }
        else
        {
            // å¦‚æžœ mapping ä¸ºç©ºï¼Œæ’入新记录到 QcIssueResults è¡¨
            var orUpdate = base.Insert(qcIssueResults);
            if (orUpdate) return true;
            throw new NotImplementedException("插入或更新失败");
@@ -382,20 +422,5 @@
       
    }

    ///**
    // * å°†å¸¦æœ‰æµç¨‹å·å’Œæ£€éªŒå•å·çš„新记录插入表中
    // */
    //public dynamic GetDingUserId()
    //{

    //    return UseTransaction(db =>
    //    {
    //        return SaveOrUpdateData(db) ? 1 : 0;
    //    }) > 0;
    //}

    //public string FindDingUserId(SqlSugarScope db,DingNameCode dingNameCode)
    //{

    //}
}

 MES.Service/service/SentLaboratory/SaveLaboratoryManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,157 @@
using MES.Service.DB;
using MES.Service.Modes.QcIssueResult;
using MES.Service.Modes.SentLaboratory;
using Newtonsoft.Json;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MES.Service.service.SentLaboratory;

public class SaveLaboratoryManager:Repository<UpdateMesQmsSample>
{
    public dynamic Save(GetLaboratoryDetails getLaboratoryDetails)
    {

        var mesUpdateMesQmsSample = GetMesQcIssueResults(getLaboratoryDetails);

        return UseTransaction(db =>
        {
            return SaveOrUpdateData(db, mesUpdateMesQmsSample) ? 1 : 0;
        }) > 0;
    }

    public UpdateMesQmsSample GetMesQcIssueResults(GetLaboratoryDetails getLaboratoryDetails)
    {
        var mesUpdateMesQmsSample = new UpdateMesQmsSample
        {
            ReleaseNo = getLaboratoryDetails.RELEASE_NO,
            DEPARTMENTNAME = getLaboratoryDetails.DEPARTMENTNAME,
            CreateDate = getLaboratoryDetails.CREATE_DATE1,
            QUANTITY = getLaboratoryDetails.QUANTITY,
            CompleteDate = getLaboratoryDetails.COMPLETE_DATE,
            TestReq=getLaboratoryDetails.TEST_REQ,
            SimReq = getLaboratoryDetails.SIM_REQ,
            ItemNo = getLaboratoryDetails.ITEM_NO,
            UrgentFlag = getLaboratoryDetails.URGENT_FLAG,
            JYDH = getLaboratoryDetails.JYDH,
            REMARKS = getLaboratoryDetails.REMARKS,
            ItemName = getLaboratoryDetails.ITEM_NAME,
            DEPARTMENTCODE = getLaboratoryDetails.DEPARTMENTCODE,
            PAPERBILLNO = getLaboratoryDetails.LOT_NO,

        };

        // éåŽ† CHECKBOX å¹¶èµ‹å€¼
        foreach (var item in getLaboratoryDetails.CHECKBOX)
        {
            switch (item.InspectionItems)
            {
                case "磁铁拉力":
                    mesUpdateMesQmsSample.Check01 = 1;
                    break;
                case "磁铁承重":
                    mesUpdateMesQmsSample.Check02 = 1;
                    break;
                case "盐雾":
                    mesUpdateMesQmsSample.Check03 = 1;
                    break;
                case "IP":
                    mesUpdateMesQmsSample.Check04 = 1;
                    break;
                case "老化测试":
                    mesUpdateMesQmsSample.Check05 = 1;
                    break;
                case "传导辐射":
                    mesUpdateMesQmsSample.Check06 = 1;
                    break;
                case "跌落测试":
                    mesUpdateMesQmsSample.Check07 = 1;
                    break;
                case "电线拉力":
                    mesUpdateMesQmsSample.Check08 = 1;
                    break;
                case "接口插拔":
                    mesUpdateMesQmsSample.Check09 = 1;
                    break;
                case "光谱测试":
                    mesUpdateMesQmsSample.Check10 = 1;
                    break;
                case "ROHS":
                    mesUpdateMesQmsSample.Check11 = 1;
                    break;
                case "电池充放电":
                    mesUpdateMesQmsSample.Check12 = 1;
                    break;
                case "高温":
                    mesUpdateMesQmsSample.Check13 = 1;
                    break;
                case "低温":
                    mesUpdateMesQmsSample.Check14 = 1;
                    break;
                case "IK":
                    mesUpdateMesQmsSample.Check15 = 1;
                    break;
                case "温升测试":
                    mesUpdateMesQmsSample.Check16 = 1;
                    break;
                case "寿命":
                    mesUpdateMesQmsSample.Check17 = 1;
                    break;
                case "其它":
                    mesUpdateMesQmsSample.Check18 = 1;
                    mesUpdateMesQmsSample.Line04 = getLaboratoryDetails.Line04;
                    break;
                default:
                    // å¦‚æžœ InspectionItems ä¸åŒ¹é…ä»»ä½•æ¡ä»¶ï¼Œå¯ä»¥é€‰æ‹©å¿½ç•¥æˆ–记录日志
                    break;
            }
        }
        return mesUpdateMesQmsSample;
    }

    /**
    * æ’入数据库表
    */
    private bool SaveOrUpdateData(SqlSugarScope db, UpdateMesQmsSample updateMesQmsSample)
    {

        ////// æŸ¥è¯¢ QcIssueResults è¡¨ä¸­æ˜¯å¦å­˜åœ¨åŒ¹é…çš„记录
        ////var mapping = db.Queryable<UpdateMesQmsSample>()
        ////    .Where(t => t.ReleaseNo == updateMesQmsSample.ReleaseNo)
        ////    .Select(t => new QcIssueResults
        ////    {
        ////        ReleaseNo = t.ReleaseNo,
        ////    })
        ////    .ToList();

        //// æŸ¥è¯¢ UpdateMesQmsSample è¡¨ä¸­æ˜¯å¦å­˜åœ¨åŒ¹é…çš„记录
        //var existingRecord = db.Queryable<UpdateMesQmsSample>()
        //    .Where(t => t.ReleaseNo == updateMesQmsSample.ReleaseNo)
        //    .First(); // ä½¿ç”¨ First èŽ·å–第一条记录

        //if (existingRecord != null)
        //{
        //    // æ›´æ–° UpdateMesQaItems è¡¨ä¸­çš„字段
        //    updateMesQmsSample.Id = existingRecord.Id;

        //    // æ‰§è¡Œæ›´æ–°æ“ä½œ
        //    var updateResult = db.Updateable(updateMesQmsSample).ExecuteCommand();
        //      return updateResult > 0; // å¦‚果更新成功，返回 true
        
        //}
        //else
        //{
        //    Debug.WriteLine("插入");
            // å¦‚æžœ mapping ä¸ºç©ºï¼Œæ’入新记录到 QcIssueResults è¡¨
            var orUpdate = base.Insert(updateMesQmsSample);
            if (orUpdate) return true;
            throw new NotImplementedException("插入或更新失败");
        //}

    }
}

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

}

 MESApplication/Controllers/BasicData/SentLaboratoryTestingItemsControllor.cs

@@ -1,11 +1,16 @@
using System.Dynamic;
using System.Diagnostics;
using System.Dynamic;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using MES.Service.Modes.QcIssueResult;
using MES.Service.Modes.SentLaboratory;
using MES.Service.service;
using MES.Service.service.BasicData;
using MES.Service.service.SentLaboratory;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers.BasicData;

@@ -15,6 +20,7 @@
{
    private readonly MessageCenterManager _manager = new();
    private readonly SentLaboratoryTestingItemsManager m = new();
    private readonly SaveLaboratoryManager n = new();

    private readonly string METHOD = "POST";

@@ -33,6 +39,8 @@
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetList();
            resultInfos.ReleaseNo = m.GetBillCode("1000", "1000", "SJDH");
         
            return new ResponseResult
            {
                status = 0,
@@ -45,4 +53,55 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("GetLaboratoryList")]
    public ResponseResult GetLaboratoryList()
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = n.GetList();

            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("SaveLaboratoryDetails")]
    public IActionResult SaveLaboratoryDetails([FromBody] GetLaboratoryDetails getLaboratoryDetails)
    {

        try
        {

            var result = n.Save(getLaboratoryDetails);

            string getLaboratoryDetailsJson = JsonConvert.SerializeObject(getLaboratoryDetails, Formatting.Indented);
            Debug.WriteLine("getLaboratoryDetails: " + getLaboratoryDetailsJson);


            //return Ok(result);
            return Ok(result);
        }
        catch (Exception ex)
        {
            // æ•èŽ·å¼‚常并返回错误信息
            return StatusCode(500, $"{ex.Message}");
        }
    }

    //[HttpPost("DeleteLaboratoryDetails")]
    //public IActionResult DeleteLaboratoryDetails(string JYDH)
    //{

    //}

}

 MESApplication/Controllers/ProductionOrder/ProductionOrderController.cs

ÎļþÃû´Ó MESApplication/Controllers/BasicData/ProductionOrderController.cs ÐÞ¸Ä
@@ -1,8 +1,11 @@
using MES.Service.Dto.webApi;
using MES.Service.Dto.webApi.DeliveryNote;
using MES.Service.Dto.webApi.ProductionOrder;
using MES.Service.Modes;
using MES.Service.Modes.ProductionOrder;
using MES.Service.Modes.QcIssueResult;
using MES.Service.service;
using MES.Service.service.ProductionOrder;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;
@@ -10,7 +13,7 @@
using System.Diagnostics;
using System.Dynamic;

namespace MESApplication.Controllers.BasicData;
namespace MESApplication.Controllers.ProductionOrder;

[ApiController]
[Route("api/ProductionOrder")]
@@ -136,12 +139,17 @@
    }

    [HttpPost("GetFileUrl")]
    public IActionResult StartGetUrl() {
    public IActionResult StartGetUrl(string imageUrl)
    {

        try
        {
            // è°ƒç”¨ QcIssueResultManager ä¸­çš„ GetProcessNo æ–¹æ³•æ¥å¯åŠ¨é’‰é’‰å·¥ä½œæµå®žä¾‹
            string result = m.GetFileUrl();

            //string result = m.GetSpaceId();
            //ResultDataAndSpaceId resultData = JsonConvert.DeserializeObject<ResultDataAndSpaceId>(result);
            //string SpaceId = resultData.Result.SpaceId;
            //string result = m.GetPermissions();

            //string jsonPart = result.Substring(result.IndexOf("{"));
            //Debug.WriteLine(jsonPart);
@@ -155,6 +163,9 @@
            ////var save = m.SaveProcessNo(ReleaseNo, instanceId);
            ////resultInfos.tbBillList = save;

            Debug.WriteLine(imageUrl);
            string result = m.GetFileUrl(imageUrl);
            Debug.WriteLine(result);
            return Ok(result);
        }
        catch (Exception ex)

 MESApplication/Controllers/QcIssueResult/QcIssueResultController.cs

@@ -33,6 +33,7 @@
   
        try
        {

            // è°ƒç”¨ QcIssueResultManager ä¸­çš„ GetProcessNo æ–¹æ³•æ¥å¯åŠ¨é’‰é’‰å·¥ä½œæµå®žä¾‹
            string result = m.GetProcessNo(getQcIssueResultDetail);

@@ -45,8 +46,8 @@

            dynamic resultInfos = new ExpandoObject();
            string ProcessNo = instanceId;
            //var save = m.SaveProcessNo(ReleaseNo, instanceId);
            //resultInfos.tbBillList = save;
            var save = m.SaveProcessNo(getQcIssueResultDetail.ReleaseNo, instanceId);
            resultInfos.tbBillList = save;

            return Ok(result);
        }

 MESApplication/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.xml

@@ -462,12 +462,6 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.ProductionOrderController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Save(MES.Service.Dto.webApi.SaleDeliveryNotice)">
            <summary>
                å•æ¡ä¸»è¡¨æ•°æ®ä¿å­˜æ“ä½œ
@@ -870,6 +864,12 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.ProductionOrder.ProductionOrderController.GetList">
            <summary>
                èŽ·å–所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.QC.MesLineUserController.GetList">
            <summary>
                èŽ·å–所有