不正常的码写入数据库

schangxiang@126.com

2024-09-04 bd8936f8feb44c0d3e95a0d19685f2ab018670bf

 DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/Utils/MonitorHelper.cs

@@ -1,11 +1,13 @@

using iWare_SCADA_Model;
using log4net;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static Org.BouncyCastle.Math.EC.ECCurve;

namespace iWare_SCADA_BusinessLogical.Utils
{
@@ -21,26 +23,79 @@
        /// <returns></returns>
        public static void MonitorTestForOP3501(DataCaptureConfig _dataCaptureConfig, object value, List<DataCaptureColumnConfig> colConfig, WorkPieceLog wplog)
        {
            try
            Task.Run(() =>
            {
                if (_dataCaptureConfig.DataCapturePointCode == "OP3501")
                try
                {
                    if (_dataCaptureConfig.DataCapturePointCode == "OP3501")
                    {
                        //记录下 触发的点位和找到的二维码值
                        var str = "";
                        str = $"OP3501 触发的点位 DbNumber:{_dataCaptureConfig.DbNumber},Offset:{_dataCaptureConfig.Offset},值是{value.ToString()}";

                        var col = colConfig.First(o => o.DataCapturePointCode == _dataCaptureConfig.DataCapturePointCode && o.DataCapturePointCname == "二维码");

                        str += $",获取二维码值 DbNumber:{col.DbNumber},Offset:{col.Offset},值是{wplog.WorkPieceID.ToString()}";
                        //str += $",整体对象 wplog是{JsonConvert.SerializeObject(wplog)}";

                        Log4NetHelper.WriteInfoLog(LogType.MonitorTest, str);
                    }
                }
                catch (Exception ex)
                {
                    Log4NetHelper.WriteErrorLog(LogType.MonitorTest, "MonitorTestForOP3501异常", ex);
                }
            });
        }


        /// <summary>
        /// 监控上线
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        public static void MonitorTestForLine(DataCaptureConfig _dataCaptureConfig, object value, List<DataCaptureColumnConfig> colConfig, string workPieceID)
        {
            Task.Run(() =>
            {
                LogType _LogType = PLCManger.GetLogTypeForOnLine(_dataCaptureConfig.DataCapturePointCode);
                try
                {
                    //记录下 触发的点位和找到的二维码值
                    var str = "";
                    str = $"OP3501 触发的点位 DbNumber:{_dataCaptureConfig.DbNumber},Offset:{_dataCaptureConfig.Offset},值是{value.ToString()}";

                    var col = colConfig.First(o => o.DataCapturePointCode == _dataCaptureConfig.DataCapturePointCode && o.DataCapturePointCname == "二维码");

                    str += $",获取二维码值 DbNumber:{col.DbNumber},Offset:{col.Offset},值是{wplog.WorkPieceID.ToString()}";
                    str += $",上线获取二维码值 ,值是{workPieceID}";
                    //str += $",整体对象 wplog是{JsonConvert.SerializeObject(wplog)}";

                    Log4NetHelper.WriteInfoLog(LogType.MonitorTest, str);
                    Log4NetHelper.WriteInfoLog(_LogType, str);

                    //不正常的码写入数据库
                    var isRight = SystemBussinessHelper.ValidateIsRightWorkPieceID(workPieceID);
                    if (isRight == false)
                    {
                        WorkPieceLog workPieceLog = new WorkPieceLog()
                        {
                            Id = Yitter.IdGenerator.YitIdHelper.NextId(),
                            WorkPieceID = workPieceID,
                            WorkingProcedure = _dataCaptureConfig.WorkingProcedure,
                            CreatedTime = DateTime.Now,
                            CreatedUserName = _dataCaptureConfig.DataCapturePointCode,
                            MyRemarks = "读码值异常",
                            Remarks = "读码值异常"
                        };
                        using (DbModel db = new DbModel())
                        {
                            db.WorkPieceLog.Add(workPieceLog);
                            db.SaveChanges();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Log4NetHelper.WriteErrorLog(LogType.MonitorTest, "MonitorTestForOP3501异常", ex);
            }
                catch (Exception ex)
                {
                    Log4NetHelper.WriteErrorLog(_LogType, "MonitorTestForLine异常:" + ex.Message, ex);
                }
            });
        }
    }
}