| | |
| | | |
| | | |
| | | //è·åå¥çæ°é |
| | | public WebResponseContent GetSleeveandStep(string gruops) |
| | | public WebResponseContent GetSleeveandStep() |
| | | { |
| | | try |
| | | { |
| | | var result = BaseDal.QueryData(x => x.CraftType == gruops) // å
çé CraftType |
| | | var result = BaseDal.QueryData() // å
æ¥åºå
¨é¨ |
| | | .GroupBy(x => x.CraftType) // æ CraftType åç» |
| | | .Select(g => new |
| | | { |
| | | maxNodal = g.Max(a => a.Nodal), |
| | | sumTorqueSum = g.Sum(a => a.TorqueSum) |
| | | //å°½éåç«¯æ°æ®ç»åç«¯çæ°æ®ï¼è°ä¸æ¬¡æ¥å£å°±å¯ä»¥æ¿å°ï¼ä¸è¦è®©åç«¯å¤æ¬¡è°ç¨ |
| | | CraftType = g.Key, // æ·»å CraftType |
| | | maxNodal = g.Max(a => a.Nodal),//æå¤§æ¥éª¤ |
| | | sumTorqueSum = g.Sum(a => a.TorqueSum),//å¥çæ°é |
| | | }).ToList(); |
| | | |
| | | return new WebResponseContent { Status = true, Data = result }; |
| | |
| | | if (addProcessDTO.id == 0) // æ·»å |
| | | { |
| | | // æ£æ¥æ¯å¦å·²ç»åå¨ç¸åç setnum |
| | | if (allProcesses.Any(x => x.SetpNum == addProcessDTO.setnum && x.CraftType == addProcessDTO.craftstype)) |
| | | if (allProcesses.Any(x => x.SetpNum == addProcessDTO.setpNum && x.CraftType == addProcessDTO.craftstype)) |
| | | { |
| | | return new WebResponseContent { Status = false, Message = $"æ¥éª¤ {addProcessDTO.setnum} å·²åå¨ï¼ä¸è½é夿·»å ï¼" }; |
| | | return new WebResponseContent { Status = false, Message = $"æ¥éª¤ {addProcessDTO.setpNum} å·²åå¨ï¼ä¸è½é夿·»å ï¼" }; |
| | | } |
| | | |
| | | // éè¦è°æ´åç»æ¥éª¤çåºå· |
| | | foreach (var process in allProcesses.Where(x => x.SetpNum >= addProcessDTO.setnum)) |
| | | foreach (var process in allProcesses.Where(x => x.SetpNum >= addProcessDTO.setpNum)) |
| | | { |
| | | process.SetpNum++; // åç§»ä¸ä½ |
| | | BaseDal.UpdateData(process); |
| | |
| | | // å建æ°å·¥èºæ¥éª¤ |
| | | var proces = new Dt_Process |
| | | { |
| | | SetpNum = addProcessDTO.setnum, |
| | | Nodal=addProcessDTO.Nodal, |
| | | SetpNum = addProcessDTO.setpNum, |
| | | CraftType = addProcessDTO.craftstype, |
| | | CraftsStep = addProcessDTO.craftsstep, |
| | | CraftContent = addProcessDTO.craftcontent, |
| | |
| | | ArticleOne = addProcessDTO.articleone, |
| | | ArticleTowid = addProcessDTO.aritcletowid, |
| | | ArticleTwo = addProcessDTO.articletwo, |
| | | CreateDate = DateTime.Now |
| | | CreateDate = DateTime.Now, |
| | | //为空就æ¯0ï¼ä¸ä¸ºç©ºå°±æ¯1 |
| | | TorqueSum = (string.IsNullOrEmpty(addProcessDTO.articleone) ? 0 : 1) + (string.IsNullOrEmpty(addProcessDTO.articletwo) ? 0 : 1) |
| | | }; |
| | | |
| | | |
| | | BaseDal.AddData(proces); |
| | | return new WebResponseContent { Status = true, Data = proces }; |
| | |
| | | } |
| | | |
| | | int oldSetNum = existingProcess.SetpNum; |
| | | int newSetNum = addProcessDTO.setnum; |
| | | int newSetNum = addProcessDTO.setpNum; |
| | | |
| | | if (oldSetNum == newSetNum) // å¦ææ²¡æ¹é¡ºåºï¼ç´æ¥æ´æ°å
¶ä»å
容 |
| | | { |
| | |
| | | existingProcess.ArticleTowid = addProcessDTO.aritcletowid; |
| | | existingProcess.ArticleTwo = addProcessDTO.articletwo; |
| | | existingProcess.CreateDate = DateTime.Now; |
| | | existingProcess.TorqueSum = (string.IsNullOrEmpty(addProcessDTO.articleone) ? 0 : 1) + (string.IsNullOrEmpty(addProcessDTO.articletwo) ? 0 : 1); |
| | | |
| | | BaseDal.UpdateData(existingProcess); |
| | | return new WebResponseContent { Status = true, Data = existingProcess }; |
| | | } |
| | | // æ´æ° TorqueSum |
| | | |
| | | |
| | | |
| | | |
| | | // è°æ´é¡ºåº |
| | | if (newSetNum < oldSetNum) // ååç§»å¨ï¼åç»æ°æ®å¾åç§» |
| | |
| | | return new WebResponseContent { Status = false, Message = "æ¥è¯¢å¤±è´¥ï¼" + ex.Message }; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 读åå½åå·¥èºæ¥éª¤çæåå¼ä¸æ¬¡æ° |
| | | /// </summary> |
| | | /// <param name="grop"></param> |
| | | /// <param name="setnum"></param> |
| | | /// <returns></returns> |
| | | /// <exception cref="NotImplementedException"></exception> |
| | | public WebResponseContent GetValueandNumber(string grop, int setnum) |
| | | { |
| | | try |
| | | { |
| | | var result = BaseDal.QueryData(x => x.CraftType == grop && x.SetpNum == setnum) |
| | | .Select(g => new |
| | | { |
| | | g.TorqueOne, |
| | | g.TorqueOneQuantity, |
| | | g.TorqueTwo, |
| | | g.TorqueTwoQuantity |
| | | }); |
| | | return new WebResponseContent { Status = true, Data = result }; |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return new WebResponseContent { Status = false,Message="é误ï¼"+ex }; throw; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |