| | |
| | | OrderByParameters = new Dictionary<string, OrderByType> |
| | | { |
| | | { nameof(Dt_Process.SetpNum), OrderByType.Asc },//æä»ä¹å段æåº |
| | | { nameof(Dt_Process.CraftType), OrderByType.Asc } |
| | | }; |
| | | return base.GetPageData(options); |
| | | } |
| | | |
| | | public WebResponseContent GetProcess(string gruop) |
| | | { |
| | | try |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | var proce = BaseDal.QueryData(i => i.CraftType == gruop); |
| | | |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | if (proce != null) |
| | | { |
| | | return new WebResponseContent { Status = true, Data = proce }; |
| | | } |
| | | else |
| | | { |
| | | return new WebResponseContent { Status = false, Message = "æ°æ®ä¸ºç©º" }; |
| | | } |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return new WebResponseContent { Status = false, Message = "失败" + ex.Message }; |
| | | } |
| | | } |
| | | |
| | | |
| | | //è·åå¥çæ°é |
| | | public WebResponseContent GetSleeveandStep(string gruops) |
| | | { |
| | | try |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | var result = BaseDal.QueryData(x => x.CraftType == gruops) // å
çé CraftType |
| | | .GroupBy(x => x.CraftType) // æ CraftType åç» |
| | | .Select(g => new |
| | |
| | | maxNodal = g.Max(a => a.Nodal), |
| | | sumTorqueSum = g.Sum(a => a.TorqueSum) |
| | | }).ToList(); |
| | | _unitOfWorkManage.CommitTran(); |
| | | |
| | | return new WebResponseContent { Status = true, Data = result }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return new WebResponseContent { Status = false, Message = "æ¥è¯¢å¤±è´¥ï¼" + ex.Message }; |
| | | } |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | _unitOfWorkManage.BeginTran(); // å¼å¯äºå¡ |
| | | var allProcesses = BaseDal.QueryData(); // ä»
æ¥è¯¢ä¸æ¬¡æææ°æ® |
| | | |
| | | // å¤ææ¯æ·»å è¿æ¯æ´æ° |
| | | if (addProcessDTO.id == 0)//æ·»å |
| | | if (addProcessDTO.id == 0) // æ·»å |
| | | { |
| | | // æ£æ¥æ¯å¦å·²ç»åå¨ç¸åç setnum |
| | | bool isExist = BaseDal.QueryData(x => x.SetpNum == addProcessDTO.setnum && x.CraftType == addProcessDTO.craftstype).Any(); |
| | | if (isExist) |
| | | if (allProcesses.Any(x => x.SetpNum == addProcessDTO.setnum && x.CraftType == addProcessDTO.craftstype)) |
| | | { |
| | | return new WebResponseContent { Status = false, Message = $"æ¥éª¤ {addProcessDTO.setnum} å·²åå¨ï¼ä¸è½é夿·»å ï¼" }; |
| | | } |
| | |
| | | ArticleOne = addProcessDTO.articleone, |
| | | ArticleTowid = addProcessDTO.aritcletowid, |
| | | ArticleTwo = addProcessDTO.articletwo, |
| | | Creater = "admin", |
| | | CreateDate = DateTime.Now |
| | | }; |
| | | |
| | | BaseDal.AddData(proces); |
| | | _unitOfWorkManage.CommitTran(); // æäº¤äºå¡ |
| | | return new WebResponseContent { Status = true, Data = proces }; |
| | | } |
| | | else |
| | | else // æ´æ° |
| | | { |
| | | // æ¥è¯¢å½åè¦æ´æ°çè®°å½ |
| | | var existingProcess = BaseDal.QueryFirst(x => x.CraftID == addProcessDTO.id); |
| | | var existingProcess = allProcesses.FirstOrDefault(x => x.CraftID == addProcessDTO.id); |
| | | if (existingProcess == null) |
| | | { |
| | | return new WebResponseContent { Status = false, Message = "æªæ¾å°è¯¥å·¥èºæ¥éª¤ï¼æ æ³æ´æ°ï¼" }; |
| | | } |
| | | |
| | | // åªæå½ setnum åçååæ¶ï¼æè¿è¡é夿§æ£æ¥ |
| | | if (existingProcess.Nodal != addProcessDTO.setnum) |
| | | if (existingProcess.SetpNum != addProcessDTO.setnum && |
| | | allProcesses.Any(x => x.SetpNum == addProcessDTO.setnum && x.CraftType == addProcessDTO.craftstype && x.CraftID != addProcessDTO.id)) |
| | | { |
| | | bool isExist = BaseDal.QueryData(x => x.Nodal == addProcessDTO.setnum && x.CraftType == addProcessDTO.craftstype && x.CraftID != addProcessDTO.id).Any(); |
| | | if (isExist) |
| | | { |
| | | return new WebResponseContent { Status = false, Message = $"æ¥éª¤ {addProcessDTO.setnum} å·²åå¨ï¼ä¸è½éå¤ï¼" }; |
| | | } |
| | | return new WebResponseContent { Status = false, Message = $"æ¥éª¤ {addProcessDTO.setnum} å·²åå¨ï¼ä¸è½éå¤ï¼" }; |
| | | } |
| | | |
| | | // æ´æ°æ°æ® |
| | | existingProcess.Nodal = addProcessDTO.Nodal; |
| | | existingProcess.SetpNum = addProcessDTO.setnum; |
| | | existingProcess.CraftType = addProcessDTO.craftstype; |
| | | existingProcess.CraftsStep = addProcessDTO.craftsstep; |
| | |
| | | existingProcess.ArticleTowid = addProcessDTO.aritcletowid; |
| | | existingProcess.ArticleTwo = addProcessDTO.articletwo; |
| | | existingProcess.CreateDate = DateTime.Now; |
| | | BaseDal.UpdateData(existingProcess); |
| | | _unitOfWorkManage.CommitTran(); // æäº¤äºå¡ |
| | | |
| | | BaseDal.UpdateData(existingProcess); |
| | | return new WebResponseContent { Status = true, Data = existingProcess }; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); // äºå¡åæ» |
| | | return new WebResponseContent { Status = false, Message = "æä½å¤±è´¥ï¼" + ex.Message }; |
| | | } |
| | | } |
| | |
| | | |
| | | //è·åModifier ="true" 表示æ¯å¼ºå¶æ§è¡ |
| | | var Mod = torp.Select(x => x.Modifier).FirstOrDefault(); |
| | | |
| | | //æ¥åºå·¥èºè¡¨ |
| | | var process = BaseDal.QueryData(x => x.CraftType == group); |
| | | |