111

啊鑫

2025-03-18 13b875793c17b3eb9437a8d2db65bab04f027e39

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

@@ -319,15 +319,10 @@
            .Where(o => o.Id == detail.Gid)
            .First();

        if (qsItemOqcReq == null)
        {
            throw new Exception("该检验单不存在，请回到入库检列表重新查看");
        }
        if (qsItemOqcReq == null) throw new Exception("该检验单不存在，请回到入库检列表重新查看");

        if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu))
        {
            throw new Exception("该检验单已" + qsItemOqcReq.FcheckResu + "，不运行修改结果");
        }

        var oracle = SqlSugarHelper.UseTransactionWithOracle(db =>
        {
@@ -462,10 +457,7 @@
                })
            .ToList();

        if (oqcReqList.Count <= 0)
        {
            return;
        }
        if (oqcReqList.Count <= 0) return;

        var qsItemOqcReq = oqcReqList.First(); // 获取第一个元素  

@@ -507,13 +499,11 @@
                .ExecuteCommand();

            if (executeCommand > 0)
            {
                //womdaa 已生产量 DAA011加回条码报工数量
                db.Updateable<Womdaa>()
                    .SetColumns(b => b.Daa011 == b.Daa011 + sumQty)
                    .Where(b => b.Daa001 == qsItemOqcReq.Daa001)
                    .ExecuteCommand();
            }
        }
        else if ("不合格".Equals(FcheckResu))
        {
@@ -530,13 +520,11 @@
                .ExecuteCommand();

            if (executeCommand > 0)
            {
                //womdaa 已生产量 DAA011加回条码报工数量
                db.Updateable<Womdaa>()
                    .SetColumns(b => b.Daa011 == b.Daa011 - sumQty)
                    .Where(b => b.Daa001 == qsItemOqcReq.Daa001)
                    .ExecuteCommand();
            }
        }
    }

@@ -629,8 +617,11 @@
            //加筛选条件,根据供应商，物料编码，物料名称搜索
            //.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue )
            .WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "",
            (a, b, c, ca, m, da, z) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower())
            || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
                (a, b, c, ca, m, da, z) =>
                    b.ItemName.ToLower()
                        .Contains(queryObj.SearchValue.ToLower())
                    || a.ItemNo.ToLower()
                        .Contains(queryObj.SearchValue.ToLower()))
            .Select((a, b, c, ca, m, da, z) => new QsItemOqcReq
            {
                BillNo = a.BillNo,
@@ -650,7 +641,7 @@
                ItemInId = m.ItemInId,
                Daa015 = da.Daa015,
                LineNo = c.LineNo,
                Quantity = m.Quantity,
                Quantity = m.Quantity
                //Bgr = d.UserName
            })
            .OrderBy(a => a.CreateDate, OrderByType.Desc)
@@ -727,15 +718,10 @@
            .Where(o => o.Id == detail.Gid)
            .First();

        if (qsItemOqcReq == null)
        {
            throw new Exception("该检验单不存在，请回到入库检列表重新查看");
        }
        if (qsItemOqcReq == null) throw new Exception("该检验单不存在，请回到入库检列表重新查看");

        if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu))
        {
            throw new Exception("该检验单已" + qsItemOqcReq.FcheckResu + "，不运行修改结果");
        }

        var withOracle = SqlSugarHelper.UseTransactionWithOracle(db =>
        {
@@ -852,7 +838,9 @@
    private bool isRk(int? gid)
    {
        var db = SqlSugarHelper.GetInstance();
        return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,MesInvItemStocks>(
        return db
            .Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,
                MesInvItemStocks>(
                (a, b, c,d) => new JoinQueryInfos(
                    JoinType.Inner, a.BillNo == b.BillNo,
                    JoinType.Inner, b.Id == c.ItemInId,