1.删除特征值.2.image_delete3.entity

南骏 池

2025-03-21 aa9e526bdcab9e817dbc2b112126aa0328e91a2b

1.删除特征值.2.image_delete3.entity

 Controllers/QC/LljController.cs

@@ -295,4 +295,71 @@
            return ResponseResult.ResponseError(ex);
        }
    }


    //删除特征值 
    [HttpPost("deleteDetail13")]
    public ResponseResult deleteDetail13(LLJDto rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList = new LljService().deleteDetail13(rkjDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //更新不合格描述 
    [HttpPost("updateRemarks")]
    public ResponseResult updateRemarks(LLJDto rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList = new LljService().updateRemarks(rkjDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //更新不合格描述 
    [HttpPost("getImage")]
    public ResponseResult getImage(LLJDto rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList = new LljService().updateRemarks(rkjDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
}

 Dto/service/LLJDto.cs

@@ -17,6 +17,8 @@

    //孙表id
    public string? id { get; set; }
    //孙表id2（样本值id）
    public string? id13 { get; set; }

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

 entity/LLJView.cs

@@ -152,4 +152,10 @@
    /// </summary>
    [SugarColumn(ColumnName = "F_TYPE")]
    public bool? Ftype { get; set; }

    /// <summary>
    ///     å§”外标识（0：采购 ã€1：委外）
    /// </summary>
    [SugarColumn(ColumnName = "remarks")]
    public string? Remarks { get; set; }
}

 entity/MesQaItemsDetectDetail13.cs

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

namespace MES.Service.Models;

/// <summary>
///     IQC检验样例表
/// </summary>
[SugarTable("MES_QA_ITEMS_DETECT_DETAIL13")]
public class MesQaItemsDetectDetail13
{
    /// <summary>
    ///     ä¸»é”®
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid? Guid { get; set; }

    /// <summary>
    ///     çˆ¶äº²Guid
    /// </summary>
    [SugarColumn(ColumnName = "parent_guid")]
    public Guid? ParentGuid { get; set; }

    /// <summary>
    ///     çˆ·çˆ·Guid
    /// </summary>
    [SugarColumn(ColumnName = "grandpa_guid")]
    public Guid? GrandpaGuid { get; set; }

    /// <summary>
    ///     æ£€éªŒç»“果值
    /// </summary>
    [SugarColumn(ColumnName = "fcheck_resu")]
    public decimal? FCheckResu { get; set; }

    /// <summary>
    ///     åˆ¤å®šæ ‡å¿—
    /// </summary>
    [SugarColumn(ColumnName = "fstand")]
    public string? FStand { get; set; }

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

    /// <summary>
    ///     åˆ›å»ºæ—¥æœŸï¼ˆæ£€éªŒæ—¶é—´ï¼‰
    /// </summary>
    [SugarColumn(ColumnName = "create_date")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     åˆ›å»ºäººï¼ˆæ£€éªŒäººï¼‰
    /// </summary>
    [SugarColumn(ColumnName = "create_by")]
    public string? CreateBy { get; set; }
}

 entity/MesQaItemsDetectDetail5.cs

@@ -27,7 +27,7 @@
    ///     æ ‡å‡†å€¼
    /// </summary>
    [SugarColumn(ColumnName = "fstand")]
    public int? Fstand { get; set; }
    public string? Fstand { get; set; }

    /// <summary>
    ///     ä¸Šå…¬å·®
@@ -183,5 +183,18 @@
    [SugarColumn(ColumnName = "remarks")]
    public string? Remarks { get; set; }


    /// <summary>
    ///     æŽ’序
    /// </summary>
    [SugarColumn(ColumnName = "forder")]
    public int? Order { get; set; }

    /// <summary>
    ///     æ ·æœ¬æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "ybsl")]
    public int? Ybsl { get; set; }

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

 service/QC/LljService.cs

@@ -1,9 +1,11 @@
using Microsoft.IdentityModel.Tokens;
using MES.Service.Models;
using Microsoft.IdentityModel.Tokens;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
using static Azure.Core.HttpHeader;

namespace NewPdaSqlServer.service.QC;

@@ -69,7 +71,7 @@
                    FcheckItem = b.FcheckItem,
                    FdownAllow = b.FdownAllow,
                    FcheckLevel = b.FREQUENCY,
                    Fstand = Convert.ToInt32(b.FSTAND),
                    Fstand = b.FSTAND,
                    FupAllow = b.FupAllow,
                    SampleSizeNo = b.SampleSizeNo,
                    FenterQty = 0,
@@ -229,7 +231,9 @@
                a.FspecRequ,
                a.FreQty,
                a.CheckQyt,
                a.FcheckResu
                a.FcheckResu,
                a.Order,
                a.Ybsl
            }).Select((a, b) => new MesQaItemsDetectDetail5
            {
                Guid = a.Guid,
@@ -249,8 +253,11 @@
                Factory = "1000",
                Company = "1000",
                FenterQty = SqlFunc.AggregateCount(b.Guid),
                FcheckResu = a.FcheckResu
            }).ToList();
                FcheckResu = a.FcheckResu,
                Order = a.Order,
                Ybsl = a.Ybsl,
            }).OrderBy(a => a.Order)
            .ToList();
    }

    public int SetQSItemDetail(MesQaItemsDetectDetail12 detail)
@@ -717,4 +724,26 @@

        return [isNullCount, isNotNullCount];
    }



    //删除特征值 
    public int deleteDetail13(LLJDto dto)
    {
        var withOracle = Db.Deleteable<MesQaItemsDetectDetail13>()
                .Where(s => s.Guid.ToString() == dto.id13)
                .ExecuteCommand();

        return withOracle;
    }

    //删除特征值 
    public List<MesFile> updateRemarks(LLJDto dto)
    {
        var withOracle = Db.Queryable<MesFile>()
                .Where(s => s.ParentGuid.ToString() == dto.gid)
                .ToList();

        return withOracle;
    }
}