| | |
| | | using System.Data; |
| | | using Microsoft.IdentityModel.Tokens; |
| | | using Microsoft.IdentityModel.Tokens; |
| | | using NewPdaSqlServer.DB; |
| | | using NewPdaSqlServer.Dto.service; |
| | | using NewPdaSqlServer.entity; |
| | | using NewPdaSqlServer.util; |
| | | using SqlSugar; |
| | | using DbType = System.Data.DbType; |
| | | |
| | | |
| | | namespace NewPdaSqlServer.service.QC; |
| | | |
| | |
| | | var parsedGuid = Guid.Empty; |
| | | if (!queryObj.id.IsNullOrEmpty()) |
| | | { |
| | | bool isValid = Guid.TryParse(queryObj.id, out parsedGuid); |
| | | var isValid = Guid.TryParse(queryObj.id, out parsedGuid); |
| | | if (!isValid) |
| | | throw new ApplicationException("GUID转换错误"); |
| | | } |
| | |
| | | .WhereIF( |
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
| | | "未完成".Equals(queryObj.result), |
| | | a => a.FcheckResu == null) |
| | | a => (a.FcheckResu ?? "") == "") |
| | | .WhereIF( |
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
| | | !"未完成".Equals(queryObj.result), |
| | | a => a.FcheckResu != null) |
| | | a => (a.FcheckResu ?? "") != "") |
| | | .WhereIF(UtilityHelper.CheckGuid(parsedGuid), |
| | | a => a.guid == parsedGuid) |
| | | .OrderByDescending(a => a.CreateDate) |
| | |
| | | |
| | | mesQaIqcItem.ForEach(item => |
| | | { |
| | | string LEV = item.FcheckLevel switch |
| | | var LEV = item.FcheckLevel switch |
| | | { |
| | | null => "" // 默认值 |
| | | , |
| | |
| | | { |
| | | foreach (var item in items) item.ReleaseNo = rkjDto.releaseNo; |
| | | |
| | | return db.Insertable(items).ExecuteCommand(); |
| | | return db.Insertable(items).IgnoreColumns(true).ExecuteCommand(); |
| | | }); |
| | | |
| | | rkjDto.items = GetItems(rkjDto.releaseNo, null); |
| | |
| | | } |
| | | |
| | | public List<MesQaItemsDetectDetail5> GetItems(string? releaseNo, |
| | | decimal? id) |
| | | string? id) |
| | | { |
| | | var parsedGuid = Guid.Empty; |
| | | |
| | | if (id != null) |
| | | { |
| | | var isValid = Guid.TryParse(id, out parsedGuid); |
| | | if (!isValid) |
| | | throw new ApplicationException("GUID转换错误"); |
| | | } |
| | | |
| | | return Db.Queryable<MesQaItemsDetectDetail5, MesQaItemsDetectDetail12>( |
| | | (a, b) => |
| | | new JoinQueryInfos(JoinType.Left, a.Guid == b.ParentGuid)) |
| | | .Where((a, b) => a.ReleaseNo == releaseNo) |
| | | // .WhereIF(id > 0, (a, b) => a.Id == id) |
| | | .WhereIF(UtilityHelper.CheckGuid(parsedGuid), |
| | | (a, b) => a.Guid == parsedGuid) |
| | | .GroupBy((a, b) => new |
| | | { |
| | | a.Guid, |
| | | a.ParentGuid, |
| | | a.ReleaseNo, |
| | | a.FacLevel, |
| | | a.FcheckItem, |
| | |
| | | }).Select((a, b) => new MesQaItemsDetectDetail5 |
| | | { |
| | | Guid = a.Guid, |
| | | ParentGuid = a.ParentGuid, |
| | | ReleaseNo = a.ReleaseNo, |
| | | CheckQyt = a.CheckQyt, |
| | | FacLevel = a.FacLevel, |
| | |
| | | { |
| | | var item = new MesQaItemsDetectDetail12(); |
| | | item.ParentGuid = detail.ParentGuid; |
| | | item.GrandpaGuid = detail.GrandpaGuid; |
| | | item.Fstand = detail.Fstand; |
| | | item.FcheckResu = detail.FcheckResu; |
| | | item.CreateBy = detail.LastupdateBy; |
| | |
| | | result.Add(item); |
| | | } |
| | | |
| | | return db.Insertable(result).ExecuteCommand(); |
| | | return db.Insertable(result).IgnoreColumns(true).ExecuteCommand(); |
| | | }); |
| | | |
| | | detail.CreateBy = detail.LastupdateBy; |
| | |
| | | { |
| | | var rkjDto = new LLJDto(); |
| | | |
| | | bool isValid = Guid.TryParse(id, out var parsedGuid); |
| | | var isValid = Guid.TryParse(id, out var parsedGuid); |
| | | |
| | | if (!isValid) |
| | | { |
| | | throw new Exception("GUID转换错误"); |
| | | } |
| | | if (!isValid) throw new Exception("GUID转换错误"); |
| | | |
| | | var qsItemOqcItem = |
| | | Db.Queryable<MesQaItemsDetectDetail5>() |
| | |
| | | rkjDto.ItemXj02s = Db.Queryable<MesQaItemsDetectDetail12>() |
| | | .Where(s => s.ParentGuid == parsedGuid) |
| | | .ToList(); |
| | | |
| | | foreach (var mesQaItemsDetectDetail12 in rkjDto.ItemXj02s) |
| | | { |
| | | //this.formData.fupAllow && this.formData.fdownAllow && this.formData.fstand |
| | | mesQaItemsDetectDetail12.isNumber = true; |
| | | if (qsItemOqcItem.FupAllow.IsNullOrEmpty() |
| | | && qsItemOqcItem.FdownAllow.IsNullOrEmpty() |
| | | && qsItemOqcItem.Fstand == null) |
| | | mesQaItemsDetectDetail12.isNumber = false; |
| | | } |
| | | |
| | | return rkjDto; |
| | | } |
| | |
| | | //子表修改备注字段 |
| | | public int saveRemarksPid(LLJDto dto) |
| | | { |
| | | bool isValid = Guid.TryParse(dto.pid, out var parsedGuid); |
| | | var isValid = Guid.TryParse(dto.pid, out var parsedGuid); |
| | | |
| | | if (isValid) |
| | | { |
| | | return UseTransaction(db => |
| | | { |
| | | return db.Updateable<MesQaItemsDetectDetail5>() |
| | |
| | | .Where(it => it.Guid == parsedGuid) |
| | | .ExecuteCommand(); |
| | | }); |
| | | } |
| | | |
| | | throw new Exception("GUID转换错误"); |
| | | } |
| | |
| | | { |
| | | mesQaItemsDetectDetail5.FenterQty ??= 0; |
| | | if (mesQaItemsDetectDetail5.FenterQty == 0) |
| | | { |
| | | throw new Exception("检验项目:" + |
| | | mesQaItemsDetectDetail5.FcheckItem + |
| | | " 已录入数量为0,请确认。"); |
| | | } |
| | | } |
| | | |
| | | var com = UseTransaction(db => |
| | |
| | | TotalOkRkQty = SqlFunc.AggregateSum(b.OkRkqty) |
| | | }) |
| | | .First(); |
| | | |
| | | |
| | | var totalQuantity = first.TotalQuantity ?? 0; |
| | | var totalOkRkQty = first.TotalOkRkQty ?? 0; |
| | | |
| | |
| | | executeCommand += db.Updateable<MesInvItemArnDetail>() |
| | | .SetColumns(s => s.CheckStates == "不合格待审批") |
| | | .SetColumns(s => s.Ischeck == 1) |
| | | .SetColumns(s => s.CheckRes == mesQaItemsDetect01.FcheckResu) |
| | | .SetColumns( |
| | | s => s.CheckRes == mesQaItemsDetect01.FcheckResu) |
| | | .SetColumns(s => s.CheckDate == DateTime.Now) |
| | | .Where(s => s.ParentGuid == mesInvItemArn.Guid |
| | | && s.ItemId == mesQaItemsDetect01.ItemId) |
| | | .ExecuteCommand(); |
| | | |
| | | |
| | | executeCommand += db.Updateable<MesQaItemsDetect01>() |
| | | .SetColumns(s => s.IqcDate == DateTime.Now) |
| | | .SetColumns(s => s.FcheckDate == DateTime.Now) |
| | |
| | | .ExecuteCommand(); |
| | | } |
| | | |
| | | if (executeCommand >=3) |
| | | if (executeCommand >= 3) |
| | | return executeCommand; |
| | | |
| | | throw new Exception("更新失败"); |
| | |
| | | |
| | | return com > 0; |
| | | } |
| | | |
| | | public int[] getBadge() |
| | | { |
| | | var isNullCount = Db.Queryable<MesQaItemsDetect01>() |
| | | .Where(a => (a.FcheckResu ?? "") == "").Count(); |
| | | |
| | | var isNotNullCount = Db.Queryable<MesQaItemsDetect01>() |
| | | .Where(a => (a.FcheckResu ?? "") != "").Count(); |
| | | |
| | | return [isNullCount, isNotNullCount]; |
| | | } |
| | | } |