using HanHe.Message; using HH.WCS.Hexafluo; using HH.WCS.Hexafluo.util; using HH.WCS.SJML.Bll; using HH.WCS.ZCQTJ.Entitys; using SqlSugar; using System.Linq; namespace HH.WCS.ZCQTJ.core { public class TaskOverItem { private static object locko7 = new object(); public static void CheckCameraTask() { try { lock (locko7) { //任务超时通知 var chi = new SqlHelper().GetInstance(); var newDb = chi.CopyNew(); var MateItemDD = newDb.Queryable().ToList(); var MateGro = MateItemDD.GroupBy(e => e.S_AREA_CODE).Select(f => f.First()).ToList(); foreach (var item in MateGro) { var AreaItem = MateItemDD.FindAll(e => e.S_AREA_CODE == item.S_AREA_CODE).ToList(); AreaItem = AreaItem.GroupBy(f => new { f.S_AREA_CODE, f.N_ROADWAY, f.S_ITEM_CODE, f.S_ITEM_NAME } ).Select(y => new TN_MateStatisticsEntitys { S_ITEM_CODE = y.Key.S_ITEM_CODE, S_ITEM_NAME = y.Key.S_ITEM_NAME, S_AREA_CODE = y.Key.S_AREA_CODE, S_AREA_Name = item.S_AREA_Name, N_ROADWAY = y.Key.N_ROADWAY, S_CODE_COUNT = y.Sum(e => e.S_CODE_COUNT) }).ToList(); var ghh = $"库区:{AreaItem.FirstOrDefault().S_AREA_Name}"; foreach (var item1 in AreaItem) { ghh += " \n\n △ "; ghh += $"{item1.S_ITEM_CODE}[{item1.S_ITEM_NAME}]:巷道:{item1.N_ROADWAY} 统计:{item1.S_CODE_COUNT}"; } BLLCreator.CreateSingleton().button1_ClickItem(ghh); } } } catch (System.Exception ex) { LogHelper.Info("处理自管任务", ex.Message + ex.StackTrace); } } } }