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);
|
}
|
}
|
}
|
}
|