数据清理

schangxiang@126.com

2025-09-02 cf5ef52a94c25e2ce92d0a0b7ebca62d81852873

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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
using iWareCommon.Utils;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using yunneiWCS.EnumDefine;
using yunneiWCS.ExtendFunction;
using yunneiWCS.mes;
using yunneiWCS.ORM;
using yunneiWCS.SystemInteraction.mes2.dto;
 
namespace yunneiWCS.ThreadTask
{
    /// <summary>
    /// MES出入库数据传输(真正的MES)
    /// </summary>
    public class mesDataTranfficForRealMes
    {
        public static LogType _logType = LogType.mesDataTranfficForRealMes;
        public static async void Handler()
        {
            while (true)
            {
                try
                {
                    Thread.Sleep(5000);
                    //Log4NetHelper.WriteErrorLog(_logType, "测试啊啊啊啊 ");
                    //Log4NetHelper.WriteInfoLog(_logType, "测试啊啊啊啊 ");
                    using (dbmodel mod = new dbmodel())
                    {
                        List<Wms_outInStockRecord_V2_Mes> sendMesData = mod.Wms_outInStockRecord_V2_Mes.Where(x => x.isSendToMes == 0).ToList();
 
                        if (sendMesData.Count > 0)
                        {
                            SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},要推送{sendMesData.Count()}条!";
                            foreach (var itemTask in sendMesData)
                            {
                                try
                                {
                                    ApiResponse<object> ret = null;
 
                                    //获取信息明细
                                    var details = mod.Wms_outInStockRecord_Details_V2_Mes.Where(x => x.mainId == itemTask.ID).ToList();
                                    List<InboundStockInfoToMes> pushData = new List<InboundStockInfoToMes>();
                                    foreach (var de in details)
                                    {
                                        pushData.Add(new InboundStockInfoToMes()
                                        {
                                            containerCode = itemTask.containerCode,
                                            createTime = itemTask.CreateTime?.ToString("yyyy-MM-dd HH:mm:ss"),
                                            materialCode = de.productCode,
                                            materialName = de.productName,
                                            positionName = itemTask.sourcePlace,
                                            productName = itemTask.materialName,
                                            serialNumber = de.serialNumber,
                                            supplier = itemTask.supplier,
                                            version = itemTask.version,
                                        });
                                    }
 
 
                                    switch (itemTask.outInFlag)
                                    {
                                        case (int)OutInFlag.入库:
                                            ret = PushMesHandler.Mes_InStockSend(pushData, itemTask.ID.ToString(), _logType);
                                            break;
                                        case (int)OutInFlag.出库:
                                            ret = PushMesHandler.Mes_OutStockSend(pushData, itemTask.ID.ToString(), _logType);
                                            break;
                                        default:
                                            break;
                                    }
 
                                    SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},已推送结束，返回:{JsonConvert.SerializeObject(ret)}";
                                    if (ret.Success)
                                    {
                                        itemTask.isSendToMes = 1;
                                    }
                                    else
                                    {
                                        itemTask.isSendToMes = 0;
                                    }
                                    itemTask.SendToMesTime = DateTime.Now;
                                    itemTask.MesRet = ret.Message;
                                    itemTask.SendToMesCount = (itemTask.SendToMesCount ?? 0) + 1;
                                    mod.SaveChanges();
 
                                }
                                catch (Exception ex)
                                {
                                    SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},推送给MES数据异常:" + JsonConvert.SerializeObject(ex);
                                    Log4NetHelper.WriteErrorLog(_logType, SystemWarningMsg.msg_mesDataTranfficForRealMes, ex);
                                }
                            }
                        }
                        else
                        {
                            SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},没有数据要推送给MES!";
                        }
                    }
                }
                catch (Exception ex)
                {
                    SystemWarningMsg.msg_mesDataTranfficForRealMes = $"{MyExtend.MsgTimeStr()},数据要推送给MES出现异常:" + ex.Message;
                    Log4NetHelper.WriteErrorLog(_logType, SystemWarningMsg.msg_mesDataTranfficForRealMes, ex);
                }
            }
        }
    }
}