| | |
| | | using NewPdaSqlServer.util; |
| | | using SqlSugar; |
| | | using static Azure.Core.HttpHeader; |
| | | using static Microsoft.EntityFrameworkCore.DbLoggerCategory; |
| | | |
| | | namespace NewPdaSqlServer.service.QC; |
| | | |
| | |
| | | a.FcheckResu, |
| | | a.Order, |
| | | a.Ybsl, |
| | | a.YbslIn |
| | | a.ISRZXX, |
| | | a.IPQCRZXX |
| | | }).Select((a, b) => new MesQaItemsDetectDetail5 |
| | | { |
| | | Guid = a.Guid, |
| | |
| | | Order = a.Order, |
| | | Ybsl = a.Ybsl, |
| | | YbslIn = Ybsl_In, |
| | | ISRZXX = a.ISRZXX, |
| | | IPQCRZXX = a.IPQCRZXX |
| | | }).OrderBy(a => a.Order) |
| | | .ToList(); |
| | | } |
| | |
| | | |
| | | 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; |
| | | } |
| | | } |