检验

啊鑫

6 天以前 83e42fa6d2797cf4e0b2769426348cbc7a5d7289

检验

 MES.Service/service/QC/RKJService.cs

@@ -585,6 +585,18 @@

        return withOracle;
    }
    
    public int saveNotesPid(RKJDto dto)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<QsItemOqcItem>()
                .SetColumns(it =>
                    it.Notes == dto.Remarks) //SetColumns是可以叠加的 写2个就2个字段赋值
                .Where(it => it.Id == dto.pid)
                .ExecuteCommand();
        });
    }


    public RKJDto getXjDetail02ById(decimal? id)

 MES.Service/service/QC/SJService.cs

@@ -426,6 +426,20 @@
                .ExecuteCommand();
        });
    }
    
     
    //NOTES
    public int saveNotesPid(QsItem dto)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<QsItemIpiItem>()
                .SetColumns(it =>
                    it.Notes == dto.Remarks) //SetColumns是可以叠加的 写2个就2个字段赋值
                .Where(it => it.Id == dto.pid)
                .ExecuteCommand();
        });
    }

    //孙表修改备注字段
    public int saveRemarksById(QsItem dto)

 MES.Service/service/QC/XJService.cs

@@ -686,6 +686,18 @@
                .ExecuteCommand();
        });
    }
    
    public int saveNotesPid(XJDto dto)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<QsQaItemXj01>()
                .SetColumns(it =>
                    it.Notes == dto.Remarks) //SetColumns是可以叠加的 写2个就2个字段赋值
                .Where(it => it.Id == dto.pid)
                .ExecuteCommand();
        });
    }

    //孙表修改备注字段
    public int saveRemarksById(XJDto dto)

 MESApplication/Controllers/QC/RKJController.cs

@@ -365,6 +365,29 @@
            return ResponseResult.ResponseError(ex);
        }
    }
    
    //saveNotesPid  修改整改措施
    [HttpPost("saveNotesPid")]
    public ResponseResult saveNotesPid([FromBody] RKJDto rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new RKJService().saveNotesPid(rkjDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("IqcQaSubmit")]
    public ResponseResult IqcQaSubmit(RKJDto rkjDto)

 MESApplication/Controllers/QC/SJController.cs

@@ -272,6 +272,29 @@
            return ResponseResult.ResponseError(ex);
        }
    }
    
    //saveNotesPid
    [HttpPost("saveNotesPid")]
    public ResponseResult saveNotesPid([FromBody] QsItem rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new SJService().saveNotesPid(rkjDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //saveRemarksById
    [HttpPost("saveRemarksById")]

 MESApplication/Controllers/QC/XJController.cs

@@ -419,6 +419,29 @@
            return ResponseResult.ResponseError(ex);
        }
    }
    
    //saveNotesPid  修改整改措施
    [HttpPost("saveNotesPid")]
    public ResponseResult saveNotesPid([FromBody] XJDto rkjDto)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var tbBillList =
                new XJService().saveNotesPid(rkjDto);
            resultInfos.tbBillList = tbBillList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //saveRemarksById
    [HttpPost("saveRemarksById")]