获取所有检验单图片接口上传

zjh

2025-05-12 76cdb99e924eebdd5025584c103fa9bfdf0adecc

获取所有检验单图片接口上传

 StandardPda/MES.Service/service/QC/BaseService.cs

@@ -1,5 +1,6 @@
using MES.Service.DB;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service.QC;

@@ -50,4 +51,17 @@
        });
        return mesQsImages;
    }
    public List<MesQsImage> getLljAllImgByFid(string id, string qsType)
    {
        var db = SqlSugarHelper.GetInstance();
        var mesQsImages = db.Queryable<MesQsImage,MesQaItemsDetectDetail5>((a,b)=>
        new JoinQueryInfos(JoinType.Left,a.Fid==b.Id))
            .Where((a,b)=> b.ReleaseNo == id && a.Id != null).ToList();
        mesQsImages.ForEach(s =>
        {
            if (s.ImageData is { Length: > 0 })
                s.base64Date = Convert.ToBase64String(s.ImageData);
        });
        return mesQsImages;
    }
}

 StandardPda/MES.Service/service/QC/LljService.cs

@@ -762,6 +762,17 @@
        }
        return Components;
    }

    public DataTable getBlmsItem()
    {
        OracleSQLHelper SQLHelper = new();
        //查不良描述
        var sql1 = string.Format(@"select DEFECT_NAME
                                    from MES_DEFECT_CODE A
                                    left join MES_DEFECT_TYPE X ON X.TYPE_NO = A.DEFECT_SORT AND X.COMPANY = A.COMPANY AND X.FACTORY = A.FACTORY");
      
        return SQLHelper.ExecuteQuery(sql1);
    }
    public void saveYzxBDlist(string id,DataTable DB)
    {
        OracleSQLHelper SQLHelper = new();

 StandardPda/MESApplication/Controllers/QC/BaseController.cs

@@ -81,4 +81,34 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    /// 获取来料检单个检验单上传的所有图片
    /// </summary>
    /// <param name="data"></param>
    /// <returns></returns>
    [HttpPost("getLljAllImgByFid")]
    public ResponseResult getLljAllImgByFid([FromBody] JObject data)
    {
        var id = data["id"].ToString();
        var qsType = data["qsType"].ToString();
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new BaseService().getLljAllImgByFid(id, qsType);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

}

 StandardPda/MESApplication/Controllers/QC/LljController.cs

@@ -280,6 +280,35 @@
    }


    /// <summary>
    /// 获取不良描述信息
    /// </summary>
    /// <param name="data"></param>
    /// <returns></returns>
    [HttpPost("getBlmsItem")]
    public ResponseResult getBlmsItem([FromBody] JObject data)
    {

       
        try
        {
            var tbBillList = new LljService().getBlmsItem();
            string[] arrRate = tbBillList.AsEnumerable().Select(d => d.Field<string>("DEFECT_NAME")).ToArray();
             

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


    [HttpPost("SetQSItemDetail")]
    public ResponseResult SetQSItemDetail(