1.首检认证信息输入 2.现场收料优化

南骏 池

2025-05-12 c418ccde908642c73f86ff43cc999be835a1e77d

1.首检认证信息输入
2.现场收料优化

 Controllers/QC/IpqcController.cs

@@ -97,5 +97,27 @@
        }
    }

    //更新检验项目认证信息 
    [HttpPost("updateIpqcRzxx")]
    public ResponseResult updateIpqcRzxx(LLJDto ipqcDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList = m.updateIpqcRzxx(ipqcDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


}

 Dto/service/LLJDto.cs

@@ -23,6 +23,8 @@
    //备注
    public string? Remarks { get; set; }

    public string? inRzxxValue { get; set; }

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

 entity/MesQaItemsDetectDetail5.cs

@@ -197,6 +197,18 @@
    public int? Ybsl { get; set; }

    /// <summary>
    ///     是否为首检认证信息
    /// </summary>
    [SugarColumn(ColumnName = "IS_RZXX")]
    public int? ISRZXX { get; set; }

    /// <summary>
    ///     首检认证信息
    /// </summary>
    [SugarColumn(ColumnName = "ipqc_rzxx")]
    public string? IPQCRZXX { get; set; }

    /// <summary>
    ///     样本已录入数
    /// </summary>
    [SugarColumn(IsIgnore = true)]

 service/QC/IpqcService.cs

@@ -6,6 +6,7 @@
using NewPdaSqlServer.util;
using SqlSugar;
using static Azure.Core.HttpHeader;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace NewPdaSqlServer.service.QC;

@@ -83,7 +84,8 @@
                a.FcheckResu,
                a.Order,
                a.Ybsl,
                a.YbslIn
                a.ISRZXX,
                a.IPQCRZXX
            }).Select((a, b) => new MesQaItemsDetectDetail5
            {
                Guid = a.Guid,
@@ -107,6 +109,8 @@
                Order = a.Order,
                Ybsl = a.Ybsl,
                YbslIn = Ybsl_In,
                ISRZXX = a.ISRZXX,
                IPQCRZXX = a.IPQCRZXX
            }).OrderBy(a => a.Order)
            .ToList();
    }
@@ -142,4 +146,22 @@

        return (pageList, totalCount);
    }


    //更新不合格描述
    public int updateIpqcRzxx(LLJDto dto)
    {
        if (dto == null) throw new ArgumentNullException(nameof(dto), "参数对象不能为 null");

        // 参数校验（根据存储过程新增参数）
        if (string.IsNullOrEmpty(dto.pid?.ToString()))
            throw new ArgumentException("项目明细id存在问题，请联系管理员！", nameof(dto.pid));

        var withOracle = Db.Updateable<MesQaItemsDetectDetail5>()
                .SetColumns(s => s.IPQCRZXX == dto.inRzxxValue)
                .Where(s => s.Guid.ToString() == dto.pid)
                .ExecuteCommand();

        return withOracle;
    }
}

 service/Warehouse/MesXkyService.cs

@@ -26,7 +26,7 @@
        ApiCommonParam Apiparam = ApiCommonParam.NewApiCommon();
        try
        {
            string data_inserted = "{\r\n  \"startDate\": 1745260800000,\r\n  \"endDate\": 1745261100000,\r\n  \"erpCode\": \"GXF001\"\r\n}";
            string data_inserted = "{\r\n  \"startDate\": 1746759300000,\r\n  \"endDate\": 1746762300000,\r\n  \"erpCode\": \"GXF001\"\r\n}";
            ArrayList SQLStringList = new ArrayList();
            // var client = new HttpClient();
            var url = "https://openapi.xiekeyun.com/delivery/getNoList.json";