11
pulg
2025-06-05 28bea7128b8c24a6a664e880f1425e1fa24b9b5f
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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<object>().GetInstance();
                    var newDb = chi.CopyNew();
                    var MateItemDD = newDb.Queryable<TN_MateStatisticsEntitys>().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<DingDingHelper>().button1_ClickItem(ghh);
                    }
                }
            }
            catch (System.Exception ex)
            {
                LogHelper.Info("处理自管任务", ex.Message + ex.StackTrace);
            }
        }
    }
}