首检\巡检\入库检适配

cnf

2 天以前 8f25fecab6e6a79096b9940ab3432401b9045b39

首检\巡检\入库检适配

 MES.Service/Dto/service/QsItem.cs

@@ -20,7 +20,11 @@
    //备注
    public string? Remarks { get; set; }

    public string? Comments { get; set; }

    public string? StatusUser { get; set; }

    public SJPageResult? Result { get; set; }

    public string? userNo { get; set; }
}

 MES.Service/Dto/service/SJPageResult.cs

@@ -3,7 +3,7 @@

namespace MES.Service.Dto.service;

[SugarTable("QS_ITEM_IPI_REQ")] //用于SqlSugar
[SugarTable("V_MES_SJ")] //用于SqlSugar
public class SJPageResult : Page
{
    public decimal? Id { get; set; }
@@ -15,11 +15,11 @@
    [SugarColumn(ColumnName = "STATUS_DATE")] //用于SqlSugar
    public DateTime? StatusDate { get; set; }

    [SugarColumn(IsIgnore = true)]
    public string? FName { get; set; }
    public string? Result { get; set; }

    [SugarColumn(IsIgnore = true)]
    public string? Result { get; set; }
    public string? SearchValue { get; set; }

    [SugarColumn(ColumnName = "STATUS_USER")] //用于SqlSugar
    public string? StatusUser { get; set; }
@@ -57,8 +57,8 @@
    [SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
    public string? ItemNo { get; set; }

    //[SugarColumn(ColumnName = "DAA001")] //用于SqlSugar
    //public string? daa001 { get; set; }
    [SugarColumn(ColumnName = "DAA001")] //用于SqlSugar
    public string? daa001 { get; set; }

    //LINE
    [SugarColumn(ColumnName = "LINE")] //用于SqlSugar
@@ -68,21 +68,21 @@
    [SugarColumn(ColumnName = "Remarks")] //用于SqlSugar
    public string? Remarks { get; set; }

    ///// <summary>
    /////     äº§å“åç§°
    ///// </summary>
    //[SugarColumn(ColumnName = "DAA003")]
    //public string? Daa003 { get; set; }
    /// <summary>
    ///     äº§å“åç§°
    /// </summary>
    [SugarColumn(ColumnName = "DAA003")]
    public string? Daa003 { get; set; }

    ///// <summary>
    /////     äº§å“è§„æ ¼
    ///// </summary>
    //[SugarColumn(ColumnName = "DAA004")]
    //public string? Daa004 { get; set; }
    /// <summary>
    ///     äº§å“è§„æ ¼
    /// </summary>
    [SugarColumn(ColumnName = "DAA004")]
    public string? Daa004 { get; set; }

    ///// <summary>
    /////     å·¥å•æ•°é‡
    ///// </summary>
    //[SugarColumn(ColumnName = "DAA008")]
    //public decimal? Daa008 { get; set; }
    /// <summary>
    ///     å·¥å•æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "DAA008")]
    public decimal? Daa008 { get; set; }
}

 MES.Service/Dto/service/XJPageResult.cs

@@ -8,4 +8,6 @@
    public string? result { get; set; }

    public string? id { get; set; }

    public string? SearchValue { get; set; }
}

 MES.Service/Modes/LLJDto.cs

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

namespace MES.Service.Modes;

public class LLJDto
{
    public string? userNo { get; set; }

    //检验单号
    public string? releaseNo { get; set; }

    //主表id
    public int? gid { get; set; }

    //子表id
    public int? pid { get; set; }

    //孙表id
    public int? id { get; set; }

    //备注
    public string? Remarks { get; set; }

    //==========================================
    //巡检主子表需要的数据
    public QsItemOqcReq? from { get; set; }

    public List<MesQaItemsDetectDetail5>? items { get; set; }

    //==========================================
    //巡检子孙表需要的数据

    public MesQaItemsDetectDetail5? ItemXj01 { get; set; }

    public List<MesQaItemsDetectDetail12>? ItemXj02s { get; set; }
}

 MES.Service/Modes/MesQaItemsDetectDetail12.cs

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

namespace MES.Service.Modes;

/// <summary>
///     IQC检验
/// </summary>
[SugarTable("MES_QA_ITEMS_DETECT_DETAIL12")]
public class MesQaItemsDetectDetail12
{
    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID",
         IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     æ£€éªŒç»“æžœ
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_RESU")]
    public string? FcheckResu { get; set; }

    /// <summary>
    ///     æ£€éªŒé¡¹ç›®
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_ITEM")]
    public string? FcheckItem { get; set; }

    /// <summary>
    ///     æ£€éªŒå•å·
    /// </summary>
    [SugarColumn(ColumnName = "RELEASE_NO")]
    public string? ReleaseNo { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "MAIN_ID")]
    public decimal? MainId { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string? Company { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string? Factory { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "FSTAND")]
    public string? Fstand { get; set; }

    /// <summary>
    ///     ç”Ÿæˆäºº
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string? CreateBy { get; set; }

    [SugarColumn(IsIgnore = true)] public int? count { get; set; }
}

 MES.Service/Modes/SJ/MESQMCHECKITEM.cs

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

namespace MES.Service.Modes.SJ
{
    internal class MESQMCHECKITEM
    {
    }
}

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

Binary files differ

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

Binary files differ

 MES.Service/service/QC/RKJService.cs

@@ -454,48 +454,61 @@
    }


    public List<QsItemOqcReq> getPage(XJPageResult queryObj)
    public (List<QsItemOqcReq> items, int TotalCount) GetPage(XJPageResult queryObj)
    {
        var db = SqlSugarHelper.GetInstance();
        var totalCount = 0;

        return db
            .Queryable<QsItemOqcReq, Womdaa, MesItems, MesInvItemIns, Womdab,
                MesInvTransaction, RKJDaa001>(
                (a, da, b, c, d, ca, m) => new JoinQueryInfos(
                    JoinType.Left, da.Daa001 == a.BillNo,
                    JoinType.Left, a.ItemId == b.Id,
                    JoinType.Left, a.BillNo == c.BillNo,
                    JoinType.Left, c.CbillNo == d.Dab001,
                    JoinType.Left,
                    c.TransctionNo == ca.TransactionNo.ToString() &&
                    c.Company == ca.Company && c.Factory == ca.Factory,
                    JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo
                ))
            .Select((a, da, b, c, d, ca, m) => new QsItemOqcReq
        // èŽ·å–用户关联的线体编号
        string[] lineNo = null;
        if (!string.IsNullOrEmpty(queryObj.createUser))
            {
                BillNo = a.BillNo,
                Remarks = a.Remarks,
            lineNo = _baseService.getUserLineNo(queryObj.createUser);
        }

        var query = db.Queryable<QsItemOqcReq, MesItems, Womdaa>((a, b, da) =>
            new JoinQueryInfos(
                JoinType.Left, a.ItemNo == b.ItemNo,       // å…³è”物料信息
                JoinType.Left, a.BillNo == da.Daa001        // å…³è”工单信息
            ))
            // ç”¨æˆ·çº¿ä½“过滤条件
            //.WhereIF(lineNo != null && lineNo.Length > 0 && !"PL017".Equals(queryObj.createUser),
            //    (a, b, da) => lineNo.Contains(da.Daa015))
            // ID精确查询
            .WhereIF(!string.IsNullOrEmpty(queryObj.id),
                (a, b, da) => a.Id.ToString() == queryObj.id)
            // å®ŒæˆçŠ¶æ€è¿‡æ»¤
            .WhereIF("未完成".Equals(queryObj.result), (a, b, da) => a.FcheckResu == null)
            .WhereIF(!"未完成".Equals(queryObj.result), (a, b, da) => a.FcheckResu != null)
            // æœç´¢æ¡ä»¶ï¼ˆç‰©æ–™åç§°/编号）
            .WhereIF(!string.IsNullOrEmpty(queryObj.SearchValue),
                (a, b, da) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                              a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
            // æŸ¥è¯¢å­—段
            .Select((a, b, da) => new QsItemOqcReq
            {
                Id = a.Id,
                BillNo = a.BillNo,
                ItemNo = a.ItemNo,
                ItemName = b.ItemName,
                ItemModel = b.ItemModel,
                CreateDate = a.CreateDate,
                CreateBy = a.CreateBy,
                FcheckResu = a.FcheckResu,
                ItemNo = a.ItemNo,
                FcheckBy = a.FcheckBy,
                FcheckDate = a.FcheckDate,
                ReleaseNo = a.ReleaseNo,
                // æ·»åŠ å…¶ä»–字段
                // å¦‚果在 QsItemOqcReq ä¸­å®šä¹‰äº†é¢å¤–字段，则需要将它们赋值
                // ä¾‹å¦‚:
                ItemName = b.ItemName,
                ItemModel = b.ItemModel,
                TaskNo = c.TaskNo,
                CbillNo = c.CbillNo,
                Dab001 = d.Dab001,
                Daa015 = da.Daa015,
                LineNo = c.LineNo,
                Quantity = m.Quantity
            }).OrderBy(a => a.CreateDate, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit);
                Remarks = a.Remarks,
                Daa015 = da.Daa015,  // å·¥å•çº¿ä½“
                Fsubmit = a.Fsubmit
            })
            // æŽ’序
            .OrderBy(a => a.CreateDate, OrderByType.Desc);

        // åˆ†é¡µæŸ¥è¯¢
        var result = query.ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);

        return (result, totalCount);
    }

    //删除主表并且连级删除子表和孙表

 MES.Service/service/QC/SJService.cs

@@ -3,6 +3,9 @@
using MES.Service.Modes;
using MES.Service.util;
using SqlSugar;
using DbType = System.Data.DbType;
using System.Data;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace MES.Service.service.QC;

@@ -34,7 +37,7 @@
    }

    //获取所有数据分页
    public List<SJPageResult> getPage(SJPageResult queryObj)
    public (List<SJPageResult> items, int totalCount) getPage(SJPageResult queryObj)
    {
        var db = SqlSugarHelper.GetInstance();

@@ -52,15 +55,16 @@
            .WhereIF(
                StringUtil.IsNotNullOrEmpty(queryObj.Result) &&
                "未完成".Equals(queryObj.Result),
                a => a.Remarks == queryObj.Result)
                a => a.Result == queryObj.Result)
            .WhereIF(
                StringUtil.IsNotNullOrEmpty(queryObj.Result) &&
                !"未完成".Equals(queryObj.Result),
                a => a.Remarks != "未完成")
            .OrderBy(a => a.BillNo, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit);
                a => a.Result != "未完成")
            .OrderBy(a => a.BillNo, OrderByType.Desc);
             var totalCount = data.Count();
        var items = data.ToPageList(queryObj.PageIndex, queryObj.Limit);

        return data;
        return (items, totalCount);
    }


@@ -223,7 +227,7 @@
        item.Items = getQSItems(qsItemIpiReq.Id, null);
        var sjPageResult = new SJPageResult
            { Id = item.From.Id, Limit = 1, PageIndex = 1 };
        item.Result = getPage(sjPageResult)[0];
        item.Result = getPage(sjPageResult).items[0];

        return item;
    }
@@ -347,28 +351,28 @@
        if (icount == 0) return 1;

        //实际个数等于理论个数时对检验单进行判定
        if (sum == icount)
        {
            result = 0;
        //if (sum == icount)
        //{
        //    result = 0;

            //获取这个检验单下的所有合格的检验结果
            passCount = db.Queryable<QsItemIpiItemDetail>()
                .Where(s => s.Gid == detail.Gid && s.Fstand == "√").Count();
        //    //获取这个检验单下的所有合格的检验结果
        //    passCount = db.Queryable<QsItemIpiItemDetail>()
        //        .Where(s => s.Gid == detail.Gid && s.Fstand == "√").Count();

            //合格的检验结果等于总检验数视为合格
            if (icount == passCount) result = 1;
        //    //合格的检验结果等于总检验数视为合格
        //    if (icount == passCount) result = 1;

            useTransactionWithOracle += SqlSugarHelper.UseTransactionWithOracle(
                db =>
                {
                    return db.Updateable<QsItemIpiReq>()
                        .SetColumns(s => s.IsPass == result)
                        .SetColumns(s => s.StatusUser == detail.CreateBy)
                        .SetColumns(s => s.CompleteTime == DateTime.Now)
                        .Where(s => s.Id == detail.Gid)
                        .ExecuteCommand();
                });
        }
        //    useTransactionWithOracle += SqlSugarHelper.UseTransactionWithOracle(
        //        db =>
        //        {
        //            return db.Updateable<QsItemIpiReq>()
        //                .SetColumns(s => s.IsPass == result)
        //                .SetColumns(s => s.StatusUser == detail.CreateBy)
        //                .SetColumns(s => s.CompleteTime == DateTime.Now)
        //                .Where(s => s.Id == detail.Gid)
        //                .ExecuteCommand();
        //        });
        //}

        return useTransactionWithOracle;
    }
@@ -455,4 +459,56 @@

        return withOracle;
    }

    public bool SJQaSubmit(QsItem item)
    {

        if (item == null)
            throw new ArgumentNullException(nameof(item), "质检项数据不能为空");

        if (string.IsNullOrWhiteSpace(item.userNo))
            throw new ArgumentException("用户编号不能为空", nameof(item.userNo));

        var (factory, company) = UserUtil.GetFactory(item.userNo);
        try
        {
            // å®šä¹‰è¾“出参数
            var outputResult = new SugarParameter("o_Result", null, DbType.Int32, ParameterDirection.Output,
                4000);

            var outputMessage = new SugarParameter("o_Msg", null, DbType.String, ParameterDirection.Output, 4000);

            // å®šä¹‰è¾“入参数
            var parameters = new List<SugarParameter>
         {

             new("p_Id", item.gid, DbType.Int32,ParameterDirection.Input),
             new("p_Flag", 1, DbType.Int32,ParameterDirection.Input),
             new("p_User", item.userNo, DbType.String, ParameterDirection.Input),
             outputResult,
             outputMessage
         };

            var db = SqlSugarHelper.GetInstance();

            // ä½¿ç”¨ SqlSugar æ‰§è¡Œå­˜å‚¨è¿‡ç¨‹
            db.Ado.ExecuteCommand(
                "BEGIN PRC_WOMDAA_SJ_UPDATE_RES(:p_Id,:p_Flag,:p_User,:o_Result, :o_Msg); END;",
                parameters.ToArray());

            // èŽ·å–输出参数的值
            var resultValue = outputResult.Value?.ToString();
            var messageValue = outputMessage.Value?.ToString();

            if ("1".Equals(resultValue)) { throw new Exception(messageValue); }
            if ("0".Equals(resultValue)) { throw new Exception(messageValue); }

            return true;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }

}

 MES.Service/service/QC/XJService.cs

@@ -3,6 +3,7 @@
using MES.Service.Modes;
using MES.Service.util;
using SqlSugar;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace MES.Service.service.QC;

@@ -106,7 +107,7 @@
                }).ToList();
    }

    public List<QsQaItemXj> getPage(XJPageResult queryObj)
    public (List<QsQaItemXj> items, int totalCount) getPage(XJPageResult queryObj)
    {
        var db = SqlSugarHelper.GetInstance();

@@ -114,10 +115,10 @@

        string[]? lineNo = null;

        if (StringUtil.IsNotNullOrEmpty(queryObj.createUser))
            lineNo = _baseService.getUserLineNo(queryObj.createUser);
        //if (StringUtil.IsNotNullOrEmpty(queryObj.createUser))
        //    lineNo = _baseService.getUserLineNo(queryObj.createUser);

        return db
       var query= db
            .Queryable<QsQaItemXj, Womdaa, MesLine,
                MesItems>((s, a, c, b) =>
                new JoinQueryInfos(
@@ -126,8 +127,8 @@
                    JoinType.Left, s.ItemId == b.Id
                )
            )
            .WhereIF(lineNo != null && lineNo.Length > 0,
                (s, a, c, b) => lineNo.Contains(c.LineNo))
            //.WhereIF(lineNo != null && lineNo.Length > 0,
            //    (s, a, c, b) => lineNo.Contains(c.LineNo))
            .WhereIF(
                StringUtil.IsNotNullOrEmpty(queryObj.result) &&
                "未完成".Equals(queryObj.result),
@@ -152,8 +153,11 @@
                FcheckBy = s.FcheckBy,
                FcheckResu = s.FcheckResu,
                Remarks = s.Remarks
            }).OrderBy(s => s.CreateDate, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit);
            }).OrderBy(s => s.CreateDate, OrderByType.Desc);
           var totalCount = query.Count();
        var items = query.ToPageList(queryObj.PageIndex, queryObj.Limit);

        return (items, totalCount);
    }



 MES.Service/util/ResponseResult.cs

@@ -15,6 +15,8 @@
    //返回的数据
    public object data { get; set; }

    public int TotalCount { get; set; } = 0;

    //失败的返回结果
    public static ResponseResult ResponseError(Exception e)
    {

 MES.Service/util/UserUtil.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
using MES.Service.DB;

namespace MES.Service.util;

public class UserUtil : RepositoryNoEntity
{
    public static (string factory, string company) GetFactory(string user)
    {
        var sql =
            "select t.Ffactory factory, t.Fcompany company from sys_user t where t.fcode = upper(trim('" +
            user + "'))";

        var sqlQuerySingle = Db.Ado.SqlQuerySingle<dynamic>(sql);

        return (sqlQuerySingle.FACTORY, sqlQuerySingle.COMPANY);
    }
}

 MESApplication/Controllers/QC/RKJController.cs

@@ -135,14 +135,15 @@
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new RKJService().getPage(queryObj);
            var (items, totalCount) = new RKJService().GetPage(queryObj);
            var tbBillList = items;
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
                data = resultInfos,
                TotalCount = totalCount
            };
        }
        catch (Exception ex)
@@ -364,4 +365,25 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("IqcQaSubmit")]
    public ResponseResult IqcQaSubmit(RKJDto rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();

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

}

 MESApplication/Controllers/QC/SJController.cs

@@ -41,14 +41,14 @@
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new SJService().getPage(queryObj);
            resultInfos.tbBillList = tbBillList;
            var (items, totalCount) = new SJService().getPage(queryObj);
            resultInfos.tbBillList = items;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
                data = resultInfos,
                TotalCount = totalCount
            };
        }
        catch (Exception ex)
@@ -319,4 +319,27 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("SJQaSubmit")]
    public ResponseResult SJQaSubmit([FromBody] QsItem item)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList = new SJService();
            var detail021 = tbBillList.SJQaSubmit(item);
            resultInfos.tbBillList = detail021;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

}

 MESApplication/Controllers/QC/XJController.cs

@@ -236,14 +236,14 @@
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new XJService().getPage(queryObj);
            resultInfos.tbBillList = tbBillList;
            var (items, totalCount) = new XJService().getPage(queryObj);
            resultInfos.tbBillList = items;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
                data = resultInfos,
                TotalCount = totalCount
            };
        }
        catch (Exception ex)

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

Binary files differ

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

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/log/2025070917.log

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
2025-07-09 17:23:16:805 æŽ¥å£å¼‚常：{"ClassName":"System.NullReferenceException","Message":"Object reference not set to an instance of an object.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":"   at MESApplication.Controllers.QC.SJController.SetQSItems(JObject data) in D:\\VISUAL STUDIOS JOB\\YC\\MESApplication\\Controllers\\QC\\SJController.cs:line 65\r\n   at lambda_method403(Closure, Object, Object[])\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467261,"Source":"MESApplication","WatsonBuckets":null}
2025-07-09 17:23:16:818 å¼‚常提示信息："Object reference not set to an instance of an object."
==================================================================================================================================
2025-07-09 17:25:47:183 æŽ¥å£å¼‚常：{"ClassName":"System.NullReferenceException","Message":"Object reference not set to an instance of an object.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":"   at MESApplication.Controllers.QC.SJController.SetQSItems(JObject data) in D:\\VISUAL STUDIOS JOB\\YC\\MESApplication\\Controllers\\QC\\SJController.cs:line 65\r\n   at lambda_method187(Closure, Object, Object[])\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467261,"Source":"MESApplication","WatsonBuckets":null}
2025-07-09 17:25:47:187 å¼‚常提示信息："Object reference not set to an instance of an object."
==================================================================================================================================
2025-07-09 17:38:13:106 æŽ¥å£å¼‚常：{"ClassName":"System.NullReferenceException","Message":"Object reference not set to an instance of an object.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":"   at MESApplication.Controllers.QC.SJController.SetQSItems(JObject data) in D:\\VISUAL STUDIOS JOB\\YC\\MESApplication\\Controllers\\QC\\SJController.cs:line 65\r\n   at lambda_method181(Closure, Object, Object[])\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467261,"Source":"MESApplication","WatsonBuckets":null}
2025-07-09 17:38:13:110 å¼‚常提示信息："Object reference not set to an instance of an object."
==================================================================================================================================