private void afterProgStateChanged(object sender, EventArgs e)
        {
            DateTime now = new DateTime();

            now = DateTime.Now;
            JDMonitorRealTimeModel mode = sender as JDMonitorRealTimeModel;

            using (Materiel_NoScan_V2Entities CIE = new  Materiel_NoScan_V2Entities())
            {
                using (System.Data.Entity.DbContextTransaction mytran = CIE.Database.BeginTransaction())
                {
                    try
                    {
                        var StateID = CIE.JDJS_WMS_Device_ProgState_Info.Where(r => r.CncID == mode.ID && r.EndTime == null);
                        if (StateID.Count() < 1)
                        {
                            JDJS_WMS_Device_ProgState_Info state = new JDJS_WMS_Device_ProgState_Info()
                            {
                                CncID     = mode.ID,
                                ProgState = mode.ProgState,
                                StartTime = now
                            };
                            CIE.JDJS_WMS_Device_ProgState_Info.Add(state);
                            CIE.SaveChanges();
                        }
                        else
                        {
                            foreach (var item in StateID)
                            {
                                item.EndTime = now;
                            }
                            JDJS_WMS_Device_ProgState_Info state = new JDJS_WMS_Device_ProgState_Info()
                            {
                                CncID     = mode.ID,
                                ProgState = mode.ProgState,
                                StartTime = now
                            };
                            CIE.JDJS_WMS_Device_ProgState_Info.Add(state);
                            CIE.SaveChanges();
                        }
                        var alarmstate = CIE.JDJS_WMS_Device_Alarm_History_Table.Where(r => r.CncID == mode.ID && r.EndTime == null);
                        foreach (var item in alarmstate)
                        {
                            item.EndTime = now;
                        }
                        CIE.SaveChanges();


                        mytran.Commit();
                        CIE.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        if (!Directory.Exists("log"))
                        {
                            Directory.CreateDirectory("log");
                        }
                        using (StreamWriter write = new StreamWriter("log/" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + ".log", true))
                        {
                            write.WriteLine(DateTime.Now.ToString() + " " + ex);
                        }
                        mytran.Rollback();
                    }
                }
            }
        }
Example #2
0
        public bool CncDataSave(Dictionary <int, IMonitorRealTimeModel> models)
        {
            using (Materiel_NoScan_V2Entities CIE = new Materiel_NoScan_V2Entities())
            {
                using (System.Data.Entity.DbContextTransaction mytran = CIE.Database.BeginTransaction())
                {
                    try
                    {
                        foreach (var mode in models.ToArray())
                        {
                            var device = CIE.JDJS_WMS_Device_Info.Where(r => r.ID == mode.Key);
                            if (device.Count() > 0)
                            {
                                JDMonitorRealTimeModel mo = mode.Value as JDMonitorRealTimeModel;
                                //保存实时数据
                                if (!(mo.MachCoord == null))
                                {
                                    var id = CIE.JDJS_WMS_Device_RealTime_Data.Where(r => r.CncID == mode.Key);
                                    if (id.Count() < 1)
                                    {
                                        JDJS_WMS_Device_RealTime_Data jDMachRealTimeData = new JDJS_WMS_Device_RealTime_Data()
                                        {
                                            CncID        = mode.Key,
                                            MachCoord_X  = mo.MachCoord[0],
                                            MachCoord_Y  = mo.MachCoord[1],
                                            MachCoord_Z  = mo.MachCoord[2],
                                            MachCoord_A  = mo.MachCoord[3],
                                            MachCoord_B  = mo.MachCoord[4],
                                            MachCoord_C  = mo.MachCoord[5],
                                            AbsCoord_X   = mo.AbsCoord[0],
                                            AbsCoord_Y   = mo.AbsCoord[1],
                                            AbsCoord_Z   = mo.AbsCoord[2],
                                            AbsCoord_A   = mo.AbsCoord[3],
                                            AbsCoord_B   = mo.AbsCoord[4],
                                            AbsCoord_C   = mo.AbsCoord[5],
                                            RelCoord_X   = mo.RelCoord[0],
                                            RelCoord_Y   = mo.RelCoord[1],
                                            RelCoord_Z   = mo.RelCoord[2],
                                            RelCoord_A   = mo.RelCoord[3],
                                            RelCoord_B   = mo.RelCoord[4],
                                            RelCoord_C   = mo.RelCoord[5],
                                            ProgState    = mo.ProgState,
                                            CurrWCoord   = mo.CurrWCoord,
                                            FeedRate     = mo.FeedRate,
                                            SpindleSpeed = mo.SpindleSpeed,
                                            ToolNo       = mo.ToolNO,
                                            MachTime     = mo.MachTime,
                                            CurrO        = mo.CurrO,
                                            CurrOMainO   = mo.CurrMainO,
                                            CountNum     = mo.WorkCount,
                                            SpindleRate  = mo.Rates[0],
                                            Rate         = mo.Rates[1],
                                            SInfo_A      = mo.Sinfo[0],
                                            SInfo_NM     = mo.Sinfo[1],
                                            SInfo_W      = mo.Sinfo[2],
                                            CurLineNo    = mo.CurLineNo[0],
                                            //CurLineText =mo.CurrLineText ,
                                            Time_Y    = mo.time[0],
                                            Time_M    = mo.time[1],
                                            Time_D    = mo.time[2],
                                            Time_H    = mo.time[3],
                                            Time_MIT  = mo.time[4],
                                            Time_S    = mo.time[5],
                                            Time_zone = mo.time[6],
                                            Mode      = mo.Mode
                                        };
                                        CIE.JDJS_WMS_Device_RealTime_Data.Add(jDMachRealTimeData);
                                        //CIE.SaveChanges();
                                    }
                                    else//已存在则修改
                                    {
                                        foreach (var item in id)
                                        {
                                            item.MachCoord_X  = mo.MachCoord[0];
                                            item.MachCoord_Y  = mo.MachCoord[1];
                                            item.MachCoord_Z  = mo.MachCoord[2];
                                            item.MachCoord_A  = mo.MachCoord[3];
                                            item.MachCoord_B  = mo.MachCoord[4];
                                            item.MachCoord_C  = mo.MachCoord[5];
                                            item.AbsCoord_X   = mo.AbsCoord[0];
                                            item.AbsCoord_Y   = mo.AbsCoord[1];
                                            item.AbsCoord_Z   = mo.AbsCoord[2];
                                            item.AbsCoord_A   = mo.AbsCoord[3];
                                            item.AbsCoord_B   = mo.AbsCoord[4];
                                            item.AbsCoord_C   = mo.AbsCoord[5];
                                            item.RelCoord_X   = mo.RelCoord[0];
                                            item.RelCoord_Y   = mo.RelCoord[1];
                                            item.RelCoord_Z   = mo.RelCoord[2];
                                            item.RelCoord_A   = mo.RelCoord[3];
                                            item.RelCoord_B   = mo.RelCoord[4];
                                            item.RelCoord_C   = mo.RelCoord[5];
                                            item.ProgState    = mo.ProgState;
                                            item.CurrWCoord   = mo.CurrWCoord;
                                            item.FeedRate     = mo.FeedRate;
                                            item.SpindleSpeed = mo.SpindleSpeed;
                                            item.ToolNo       = mo.ToolNO;
                                            item.MachTime     = mo.MachTime;
                                            item.CurrO        = mo.CurrO;
                                            item.CurrOMainO   = mo.CurrMainO;
                                            item.CountNum     = mo.WorkCount;
                                            item.SpindleRate  = mo.Rates[0];
                                            item.Rate         = mo.Rates[1];
                                            item.SInfo_A      = mo.Sinfo[0];
                                            item.SInfo_NM     = mo.Sinfo[1];
                                            item.SInfo_W      = mo.Sinfo[2];
                                            item.CurLineNo    = mo.CurLineNo[0];
                                            item.CurLineText  = mo.CurrLineText;
                                            item.Time_Y       = mo.time[0];
                                            item.Time_M       = mo.time[1];
                                            item.Time_D       = mo.time[2];
                                            item.Time_H       = mo.time[3];
                                            item.Time_MIT     = mo.time[4];
                                            item.Time_S       = mo.time[5];
                                            item.Time_zone    = mo.time[6];
                                            item.Mode         = mo.Mode;
                                            //CIE.SaveChanges();
                                        }
                                    }
                                }
                                else
                                {
                                    var id = CIE.JDJS_WMS_Device_RealTime_Data.Where(r => r.CncID == mode.Key);
                                    if (id.Count() < 1)
                                    {
                                        JDJS_WMS_Device_RealTime_Data jDMachRealTimeData = new JDJS_WMS_Device_RealTime_Data()
                                        {
                                            CncID        = mode.Key,
                                            MachCoord_X  = -1,
                                            MachCoord_Y  = -1,
                                            MachCoord_Z  = -1,
                                            MachCoord_A  = -1,
                                            MachCoord_B  = -1,
                                            MachCoord_C  = -1,
                                            AbsCoord_X   = -1,
                                            AbsCoord_Y   = -1,
                                            AbsCoord_Z   = -1,
                                            AbsCoord_A   = -1,
                                            AbsCoord_B   = -1,
                                            AbsCoord_C   = -1,
                                            RelCoord_X   = -1,
                                            RelCoord_Y   = -1,
                                            RelCoord_Z   = -1,
                                            RelCoord_A   = -1,
                                            RelCoord_B   = -1,
                                            RelCoord_C   = -1,
                                            ProgState    = -1,
                                            CurrWCoord   = -1,
                                            FeedRate     = -1,
                                            SpindleSpeed = -1,
                                            ToolNo       = -1,
                                            MachTime     = -1,
                                            CurrO        = -1,
                                            CurrOMainO   = -1,
                                            CountNum     = -1,
                                            SpindleRate  = -1,
                                            Rate         = -1,
                                            SInfo_A      = -1,
                                            SInfo_NM     = -1,
                                            SInfo_W      = -1,
                                            CurLineNo    = -1,
                                            //CurLineText =mo.CurrLineText ,
                                            Time_Y    = -1,
                                            Time_M    = -1,
                                            Time_D    = -1,
                                            Time_H    = -1,
                                            Time_MIT  = -1,
                                            Time_S    = -1,
                                            Time_zone = -1,
                                            Mode      = -1
                                        };
                                        CIE.JDJS_WMS_Device_RealTime_Data.Add(jDMachRealTimeData);
                                        //CIE.SaveChanges();
                                    }
                                    else//已存在则修改
                                    {
                                        foreach (var item in id)
                                        {
                                            item.MachCoord_X  = -1;
                                            item.MachCoord_Y  = -1;
                                            item.MachCoord_Z  = -1;
                                            item.MachCoord_A  = -1;
                                            item.MachCoord_B  = -1;
                                            item.MachCoord_C  = -1;
                                            item.AbsCoord_X   = -1;
                                            item.AbsCoord_Y   = -1;
                                            item.AbsCoord_Z   = -1;
                                            item.AbsCoord_A   = -1;
                                            item.AbsCoord_B   = -1;
                                            item.AbsCoord_C   = -1;
                                            item.RelCoord_X   = -1;
                                            item.RelCoord_Y   = -1;
                                            item.RelCoord_Z   = -1;
                                            item.RelCoord_A   = -1;
                                            item.RelCoord_B   = -1;
                                            item.RelCoord_C   = -1;
                                            item.ProgState    = -1;
                                            item.CurrWCoord   = -1;
                                            item.FeedRate     = -1;
                                            item.SpindleSpeed = -1;
                                            item.ToolNo       = -1;
                                            item.MachTime     = -1;
                                            item.CurrO        = -1;
                                            item.CurrOMainO   = -1;
                                            item.CountNum     = -1;
                                            item.SpindleRate  = -1;
                                            item.Rate         = -1;
                                            item.SInfo_A      = -1;
                                            item.SInfo_NM     = -1;
                                            item.SInfo_W      = -1;
                                            item.CurLineNo    = -1;
                                            //item.CurLineText = -1;
                                            item.Time_Y    = -1;
                                            item.Time_M    = -1;
                                            item.Time_D    = -1;
                                            item.Time_H    = -1;
                                            item.Time_MIT  = -1;
                                            item.Time_S    = -1;
                                            item.Time_zone = -1;
                                            item.Mode      = -1;
                                            //CIE.SaveChanges();
                                        }
                                    }
                                }
                            }
                        }
                        CIE.SaveChanges();
                        mytran.Commit();

                        return(true);
                    }
                    catch (Exception ex)
                    {
                        if (!Directory.Exists("log"))
                        {
                            Directory.CreateDirectory("log");
                        }
                        using (StreamWriter write = new StreamWriter("log/" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + ".log", true))
                        {
                            write.WriteLine(DateTime.Now.ToString() + " " + ex);
                        }
                        mytran.Rollback();
                        return(false);
                    }
                }
            }
        }
Example #3
0
        public List <CncInfo> GetCncInfo()
        {
            List <CncInfo> infos = new List <CncInfo>();

            try
            {
                using (Materiel_NoScan_V2Entities model = new Materiel_NoScan_V2Entities())
                {
                    var dataList = from cnc in model.JDJS_WMS_Device_Info
                                   join type in model.JDJS_WMS_Device_Type_Info on cnc.MachType equals type.ID
                                   join brand in model.JDJS_WMS_Device_Brand_Info on type.BrandID equals brand.ID
                                   select new
                    {
                        cnc.ID,
                        cnc.IP,
                        cnc.MachNum,
                        cnc.MachState,
                        cnc.MachType,
                        cnc.Position,
                        type.Type,
                        type.BrandID,
                        brand.Brand
                    };
                    if (dataList.Count() > 0)
                    {
                        foreach (var item in dataList)
                        {
                            switch (item.BrandID)//判断机床品牌
                            {
                            case 1:
                                JDInfo jd = new JDInfo();
                                jd.ID        = item.ID;
                                jd.MachNum   = item.MachNum;
                                jd.MachBrand = item.Brand;
                                jd.MachType  = item.Type;
                                jd.IP        = item.IP;
                                jd.MachState = item.MachState;
                                infos.Add(jd);
                                break;

                            case 2:
                                break;

                            case 3:
                                break;

                            case 4:
                                break;

                            case 5:
                                break;

                            case 6:
                                break;
                            }
                        }
                    }
                }

                return(infos);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
Example #4
0
        public override bool GetData(IMonitorRealTimeModel model)
        {
            try
            {
                JDMonitorRealTimeModel monitorRealTimeModel = model as JDMonitorRealTimeModel;

                //机床坐标
                double[] machCorrd = new double[6];
                double[] absCorrd  = new double[6];
                double[] relCorrd  = new double[6];
                if (Function.GetMachPos(ptr, machCorrd, absCorrd, relCorrd))
                {
                    monitorRealTimeModel.MachCoord = machCorrd;
                    monitorRealTimeModel.AbsCoord  = absCorrd;
                    monitorRealTimeModel.RelCoord  = relCorrd;
                }
                else
                {
                    return(false);
                }
                //机床程序状态
                int progState = -1;
                int almInfo   = -1;
                if (Function.GetMachAlmInfo(ptr, ref almInfo))
                {
                    if (almInfo == 0)
                    {
                        if (Function.GetProgState(ptr, ref progState))
                        {
                            monitorRealTimeModel.ProgState = progState;
                        }
                        else
                        {
                            return(false);
                        }
                    }
                    else
                    {
                        progState = 4;
                        monitorRealTimeModel.ProgState = progState;
                        int   errCount    = -1;
                        int[] errCodeList = new int[50];
                        byte[,] errDescList = new byte[50, 128];
                        List <string> errDesc = new List <string>();

                        if (Function.GetCncErrList(ptr, ref errCount, errCodeList, errDescList))
                        {
                            byte[] buff = new byte[128];
                            for (int i = 0; i < 50; i++)
                            {
                                for (int j = 0; j < 128; j++)
                                {
                                    buff[j] = errDescList[i, j];
                                }
                                string str = Encoding.Default.GetString(buff).Replace("\0", "").Replace("\r", "").Replace("\n", "");
                                errDesc.Add(str);
                            }
                            {
                                using (Materiel_NoScan_V2Entities cie = new Materiel_NoScan_V2Entities())
                                {
                                    var alarminfo = cie.JDJS_WMS_Device_Alarm_History_Table.Where(r => r.CncID == this.cncInfo.ID && r.EndTime == null);
                                    if (alarminfo.Count() < 1)
                                    {
                                        for (int i = 0; i < errCount; i++)
                                        {
                                            JDJS_WMS_Device_Alarm_History_Table alarms = new JDJS_WMS_Device_Alarm_History_Table()
                                            {
                                                CncID     = this.cncInfo.ID,
                                                ErrCode   = errCodeList[i].ToString(),
                                                ErrDesc   = errDesc[i],
                                                StartTime = DateTime.Now,
                                            };
                                            cie.JDJS_WMS_Device_Alarm_History_Table.Add(alarms);
                                        }
                                        cie.SaveChanges();
                                    }
                                }
                            }
                        }
                        else
                        {
                            errCount = -1; errCodeList = null; errDescList = null;
                        }
                        monitorRealTimeModel.ErrCount    = errCount;
                        monitorRealTimeModel.ErrCodeList = errCodeList;
                        monitorRealTimeModel.ErrDescList = errDesc.ToArray();
                    }
                }
                else
                {
                    return(false);
                }
                //机床模态
                int   currwCorrd   = -1;
                float feedrate     = -1;
                int   spindlespeed = -1;
                int   toolno       = -1;
                float machTime     = -1;
                int   curro        = -1;
                int   curroMaino   = -1;
                if (Function.GetBasicModalInfo(ptr, ref currwCorrd, ref feedrate, ref spindlespeed, ref toolno, ref machTime, ref curro, ref curroMaino))
                {
                    monitorRealTimeModel.CurrWCoord   = currwCorrd;
                    monitorRealTimeModel.FeedRate     = feedrate;
                    monitorRealTimeModel.SpindleSpeed = spindlespeed;
                    monitorRealTimeModel.ToolNO       = toolno;
                    monitorRealTimeModel.MachTime     = machTime;
                    monitorRealTimeModel.CurrO        = curro;
                    monitorRealTimeModel.CurrMainO    = curroMaino;
                }
                else
                {
                    return(false);
                }

                //机床时间信息
                double[] times = new double[3];
                if (Function.GetTime(ptr, times))
                {
                    //model.Times = times;
                    monitorRealTimeModel.Times = times;
                }
                else
                {
                    return(false);
                }
                //工件计数
                int count = -1;
                if (Function.GetMachinedWorkpieceCount(ptr, ref count))
                {
                    monitorRealTimeModel.WorkCount = count;
                }
                else
                {
                    return(false);
                }
                //倍率信息
                int[] rates = new int[2];
                if (Function.GetRate(ptr, rates))
                {
                    monitorRealTimeModel.Rates = rates;
                }
                else
                {
                    return(false);
                }
                //主轴信息
                double[] sinfo = new double[3];
                if (Function.GetSpindleInfo(ptr, sinfo))
                {
                    monitorRealTimeModel.Sinfo = sinfo;
                }
                else
                {
                    return(false);
                }
                //当前运行行号
                int[] curlineno = new int[3];
                if (Function.GetCurLineNo(ptr, curlineno))
                {
                    monitorRealTimeModel.CurLineNo = curlineno;
                }
                else
                {
                    return(false);
                }
                //当前运行行文本
                StringBuilder curlinetext = new StringBuilder();
                curlinetext.Capacity = 200000;
                if (Function.GetCurrLineText(ptr, curlinetext))
                {
                    monitorRealTimeModel.CurrLineText = curlinetext.ToString();
                }
                else
                {
                    return(false);
                }

                //机床系统时间
                int[] time = new int[7];
                if (Function.GetMachTime(ptr, time))
                {
                    //model.time = time;
                    monitorRealTimeModel.time = time;
                }
                else
                {
                    return(false);
                }
                //当前xyzabc剩余量没有相关函数
                //当前工作模式 获取机床的操作模式:
                //1、回参考点是128
                //2、打再寸动上是32
                //3、又打到回参考点之后又是128
                //3、打到手轮上,是64
                //4、程序运行 是 2
                //5、MDI是4
                //6、编辑是1
                //7、点动是16
                int modell = -1;
                int mode   = -1;
                if (Function.GetOprationMode(ptr, ref mode))
                {
                    switch (mode)
                    {
                    case 1:
                        modell = 1;    //编辑
                        break;

                    case 2:
                        modell = 2;    //程序运行
                        break;

                    case 4:
                        modell = 3;    //mdi
                        break;

                    case 8:
                        modell = 8;    //程序自动远程运行
                        break;

                    case 16:
                        modell = 4;    //点动
                        break;

                    case 32:
                        modell = 5;    //寸动
                        break;

                    case 64:
                        modell = 6;    //手轮
                        break;

                    case 128:
                        modell = 7;    //回参考点
                        break;

                    case 256:
                        modell = 9;
                        break;
                    }
                    monitorRealTimeModel.Mode = modell;
                }
                else
                {
                    return(false);
                }
                model = monitorRealTimeModel as IMonitorRealTimeModel;
                return(true);
            }
            catch (Exception ex)
            {
                if (!Directory.Exists("log"))
                {
                    Directory.CreateDirectory("log");
                }
                using (StreamWriter write = new StreamWriter("log/" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + ".log", true))
                {
                    write.WriteLine(DateTime.Now.ToString() + " " + ex);
                }
                return(false);
            }
        }