分支自 SuZhouGuanHong/TaiYuanTaiZhong
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
dengjunjie
2024-06-28 1e38f44af86775a341e4d0e4411d24ad35e417d3 
 ´úÂë¹ÜÀí/PCS/WCS_Server/WIDESEA_WCS/Common/Gantry.cs


@@ -4,6 +4,7 @@


using System;


using System.Collections.Generic;


using System.Linq;


using System.Net;


using System.Security.Cryptography.Xml;


using System.Text;


using System.Threading.Tasks;


@@ -45,7 +46,6 @@


                Idt_geometry_dataRepository dataRepository = new dt_geometry_dataRepository(Context);


                Idt_mes_detailRepository mes_DetailRepository = new dt_mes_detailRepository(Context);


                Idt_mes_headRepository mes_HeadRepository = new dt_mes_headRepository(Context);


                Idt_geometry_data_detectionlineRepository detectionlineRepository = new dt_geometry_data_detectionlineRepository(Context);


                var plc = repository.FindFirst(x => x.plcinfo_name == client.PLCName);


                List<string> names = new List<string>() { "1单元辊道下料查询车轮", "2单元辊道下料查询车轮", "3单元辊道下料查询车轮", "辊道上料查询车轮" };


                foreach (string name in names)


@@ -63,151 +63,69 @@


                        if (name == "辊道上料查询车轮") number = "辊道上料查询订单";


                        var wp_id = client.ReadByOrder<string>("R_o_wp_id", number);




                        var Mes_Work = workinfoRepository.Find(x => x.SN == wp_id && x.processCode == (name != "辊道上料查询车轮" ? "17" : "28")).FirstOrDefault();


                        if (name == "辊道上料查询车轮")


                        {


                            var wp_id1 = client.ReadByOrder<string>("W_Wheel_id", "上料区");//车轮SN号


                            if (wp_id != wp_id1)


                            {


                                client.WriteByOrder("W_i_status", (byte)2, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n查询车轮SN：{wp_id}\n上料申请SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单信息");


                                continue;


                            }


                        }




                        var Mes_Work = workinfoRepository.Find(x => x.SN == wp_id && x.processCode == (name != "辊道上料查询车轮" ? "17" : "28")).OrderByDescending(x => x.CreateTime).FirstOrDefault();


                        if (Mes_Work == null)


                        {


                            client.WriteByOrder("W_i_status", (byte)2, name);


                            client.WriteByOrder("R_oi_on", (byte)0, name);


                            #region æ—¥å¿—记录


                            //WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单信息", "PCS");


                            WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单信息");


                            #endregion


                            continue;


                        }




                        #region MyRegion


                        //var mes_Detail = mes_DetailRepository.FindFirst(x => x.SN == wp_id);


                        //if (mes_Detail == null)


                        //{


                        //    client.WriteByOrder("W_i_status", (byte)2, name);


                        //    client.WriteByOrder("R_oi_on", (byte)0, name);


                        //    #region æ—¥å¿—记录


                        //    WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单详情", "PCS");


                        //    #endregion


                        //    continue;


                        //}


                        //var mes_Head = mes_HeadRepository.FindFirst(x => x.jobID == mes_Detail.jobID);


                        //if (mes_Head == null)


                        //{


                        //    client.WriteByOrder("W_i_status", (byte)2, name);


                        //    client.WriteByOrder("R_oi_on", (byte)0, name);


                        //    #region æ—¥å¿—记录


                        //    WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单头表", "PCS");


                        //    #endregion


                        //    continue;


                        //}


                        #endregion






                        if (name != "辊道上料查询车轮")


                        var geometry = Pipeline.QueryMateriel(Mes_Work.drawingNo);


                        if (geometry == null)


                        {


                            //var geometry = dataRepository.FindFirst(x => x.TypeId == (Int32)wp_type);


                            var geometry = dataRepository.Find(x => x.Description == Mes_Work.drawingNo).FirstOrDefault();


                            var geometry1 = detectionlineRepository.Find(x => x.Description == Mes_Work.drawingNo).FirstOrDefault();


                            if (geometry == null && geometry1 == null)


                            {


                                //DBExtension.Write(details.Where(x => x.plcdetail_name == "W_i_status").First(), client, (Int16)2);


                                //1-找到数据，2-未找到工件类型数据


                                client.WriteByOrder("W_i_status", (byte)2, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Error(name, $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到机加工车轮信息", "PCS");


                                WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到机加工车轮信息");


                                #endregion


                            }


                            else


                            {


                                //1-找到数据，2-未找到工件类型数据


                                client.WriteByOrder("W_i_status", (byte)1, name);


                                client.WriteByOrder("W_i_parameter_a", geometry == null ? (float)geometry1.a : (float)geometry.a, name);


                                client.WriteByOrder("W_i_parameter_b", geometry == null ? (float)geometry1.b : (float)geometry.b, name);


                                client.WriteByOrder("W_i_parameter_c", geometry == null ? (float)geometry1.c : (float)geometry.c, name);


                                client.WriteByOrder("W_i_parameter_d", geometry == null ? (float)geometry1.d : (float)geometry.d, name);


                                client.WriteByOrder("W_i_parameter_e", geometry == null ? (float)geometry1.e : (float)geometry.e, name);


                                client.WriteByOrder("W_i_parameter_f", geometry == null ? (float)geometry1.f : (float)geometry.f, name);


                                client.WriteByOrder("W_i_parameter_g", geometry == null ? (float)geometry1.g : (float)geometry.g, name);


                                client.WriteByOrder("W_i_parameter_h", geometry == null ? (float)geometry1.h : (float)geometry.h, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Success(name, $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\n" +


                                //    $"a：{(geometry == null ? (float)geometry1.a : (float)geometry.a)}\n" +


                                //    $"b：{(geometry == null ? (float)geometry1.b : (float)geometry.b)}\n" +


                                //    $"c：{(geometry == null ? (float)geometry1.c : (float)geometry.c)}\n" +


                                //    $"d：{(geometry == null ? (float)geometry1.d : (float)geometry.d)}\n" +


                                //    $"e：{(geometry == null ? (float)geometry1.e : (float)geometry.e)}\n" +


                                //    $"f：{(geometry == null ? (float)geometry1.f : (float)geometry.f)}\n" +


                                //    $"g：{(geometry == null ? (float)geometry1.g : (float)geometry.g)}\n" +


                                //    $"h：{(geometry == null ? (float)geometry1.h : (float)geometry.h)}\n" +


                                //    $"R_oi_on：0", "PCS");


                                WriteLog.Write_Log(name, wp_id, "写入信息！", $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\n" +


                                    $"a：{(geometry == null ? (float)geometry1.a : (float)geometry.a)}\n" +


                                    $"b：{(geometry == null ? (float)geometry1.b : (float)geometry.b)}\n" +


                                    $"c：{(geometry == null ? (float)geometry1.c : (float)geometry.c)}\n" +


                                    $"d：{(geometry == null ? (float)geometry1.d : (float)geometry.d)}\n" +


                                    $"e：{(geometry == null ? (float)geometry1.e : (float)geometry.e)}\n" +


                                    $"f：{(geometry == null ? (float)geometry1.f : (float)geometry.f)}\n" +


                                    $"g：{(geometry == null ? (float)geometry1.g : (float)geometry.g)}\n" +


                                    $"h：{(geometry == null ? (float)geometry1.h : (float)geometry.h)}\n" +


                                    $"R_oi_on：0");


                                #endregion


                            }


                            //1-找到数据，2-未找到工件类型数据


                            client.WriteByOrder("W_i_status", (byte)2, name);


                            client.WriteByOrder("R_oi_on", (byte)0, name);


                            #region æ—¥å¿—记录


                            WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到机加工车轮信息");


                            #endregion


                        }


                        else


                        {


                            var geometry = detectionlineRepository.Find(x => x.Description == Mes_Work.drawingNo).FirstOrDefault();


                            var geometry1 = dataRepository.Find(x => x.Description == Mes_Work.drawingNo).FirstOrDefault();


                            if (geometry == null && geometry1 == null)


                            {


                                client.WriteByOrder("W_i_status", (byte)2, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Error(name, $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到检测线车轮信息", "PCS");


                                WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到检测线车轮信息");


                                #endregion


                            }


                            else


                            {


                                client.WriteByOrder("W_i_status", (byte)1, name);


                                client.WriteByOrder("W_i_parameter_a", geometry == null ? (float)geometry1.a : (float)geometry.a, name);


                                client.WriteByOrder("W_i_parameter_b", geometry == null ? (float)geometry1.b : (float)geometry.b, name);


                                client.WriteByOrder("W_i_parameter_c", geometry == null ? (float)geometry1.c : (float)geometry.c, name);


                                client.WriteByOrder("W_i_parameter_d", geometry == null ? (float)geometry1.d : (float)geometry.d, name);


                                client.WriteByOrder("W_i_parameter_e", geometry == null ? (float)geometry1.e : (float)geometry.e, name);


                                client.WriteByOrder("W_i_parameter_f", geometry == null ? (float)geometry1.f : (float)geometry.f, name);


                                client.WriteByOrder("W_i_parameter_g", geometry == null ? (float)geometry1.g : (float)geometry.g, name);


                                client.WriteByOrder("W_i_parameter_h", geometry == null ? (float)geometry1.h : (float)geometry.h, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Success(name, $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\n" +


                                //    $"a：{(geometry == null ? (float)geometry1.a : (float)geometry.a)}\n" +


                                //    $"b：{(geometry == null ? (float)geometry1.b : (float)geometry.b)}\n" +


                                //    $"c：{(geometry == null ? (float)geometry1.c : (float)geometry.c)}\n" +


                                //    $"d：{(geometry == null ? (float)geometry1.d : (float)geometry.d)}\n" +


                                //    $"e：{(geometry == null ? (float)geometry1.e : (float)geometry.e)}\n" +


                                //    $"f：{(geometry == null ? (float)geometry1.f : (float)geometry.f)}\n" +


                                //    $"g：{(geometry == null ? (float)geometry1.g : (float)geometry.g)}\n" +


                                //    $"h：{(geometry == null ? (float)geometry1.h : (float)geometry.h)}\n" +


                                //    $"R_oi_on：0", "PCS");


                                WriteLog.Write_Log(name, wp_id, "写入信息！", $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\n" +


                                    $"a：{(geometry == null ? (float)geometry1.a : (float)geometry.a)}\n" +


                                    $"b：{(geometry == null ? (float)geometry1.b : (float)geometry.b)}\n" +


                                    $"c：{(geometry == null ? (float)geometry1.c : (float)geometry.c)}\n" +


                                    $"d：{(geometry == null ? (float)geometry1.d : (float)geometry.d)}\n" +


                                    $"e：{(geometry == null ? (float)geometry1.e : (float)geometry.e)}\n" +


                                    $"f：{(geometry == null ? (float)geometry1.f : (float)geometry.f)}\n" +


                                    $"g：{(geometry == null ? (float)geometry1.g : (float)geometry.g)}\n" +


                                    $"h：{(geometry == null ? (float)geometry1.h : (float)geometry.h)}\n" +


                                    $"R_oi_on：0");


                                #endregion


                            }


                            //1-找到数据，2-未找到工件类型数据


                            client.WriteByOrder("W_i_status", (byte)1, name);


                            client.WriteByOrder("W_i_parameter_a", (float)geometry.a, name);


                            client.WriteByOrder("W_i_parameter_b", (float)geometry.b, name);


                            client.WriteByOrder("W_i_parameter_c", (float)geometry.c, name);


                            client.WriteByOrder("W_i_parameter_d", (float)geometry.d, name);


                            client.WriteByOrder("W_i_parameter_e", (float)geometry.e, name);


                            client.WriteByOrder("W_i_parameter_f", (float)geometry.f, name);


                            client.WriteByOrder("W_i_parameter_g", (float)geometry.g, name);


                            client.WriteByOrder("W_i_parameter_h", (float)geometry.h, name);


                            client.WriteByOrder("R_oi_on", (byte)0, name);


                            #region æ—¥å¿—记录


                            WriteLog.Write_Log(name, wp_id, "写入信息！", $"读取桁架信息：\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\n" +


                                $"a：{(float)geometry.a}\n" +


                                $"b：{(float)geometry.b}\n" +


                                $"c：{(float)geometry.c}\n" +


                                $"d：{(float)geometry.d}\n" +


                                $"e：{(float)geometry.e}\n" +


                                $"f：{(float)geometry.f}\n" +


                                $"g：{(float)geometry.g}\n" +


                                $"h：{(float)geometry.h}\n" +


                                $"R_oi_on：0");


                            #endregion


                        }




                    }


                }


            }


            catch (Exception ex)


            {


                //WriteDBLog.Error("查询车轮数据", $"错误信息：{ex.Message}", "PCS");


                WriteLog.Write_Log("报错日志", namea, "错误信息！", $"错误信息：{ex.Message}");


            }


        }


@@ -227,7 +145,6 @@


                Idt_plcinfoheadRepository repository = new dt_plcinfoheadRepository(Context);


                Idt_plcinfodetailRepository plcRepository = new dt_plcinfodetailRepository(Context);


                Idt_geometry_dataRepository dataRepository = new dt_geometry_dataRepository(Context);


                Idt_geometry_data_detectionlineRepository detectionlineRepository = new dt_geometry_data_detectionlineRepository(Context);


                Idt_mes_detailRepository mes_DetailRepository = new dt_mes_detailRepository(Context);


                IVV_Mes_WorkinfoRepository workinfoRepository = new VV_Mes_WorkinfoRepository(Context);


                Idt_mes_headRepository mes_HeadRepository = new dt_mes_headRepository(Context);


@@ -256,132 +173,54 @@


                        }


                        var wp_type = DBExtension.Read(details.Where(x => x.plcdetail_name == "R_o_wp_type").First(), client);




                        var Mes_Work = workinfoRepository.Find(x => x.SN == wp_id && x.processCode == (name != "辊道上料查询订单" ? "17" : "28")).FirstOrDefault();


                        var Mes_Work = workinfoRepository.Find(x => x.SN == wp_id && x.processCode == (name != "辊道上料查询订单" ? "17" : "28")).OrderByDescending(x => x.CreateTime).FirstOrDefault();


                        if (Mes_Work == null)


                        {


                            client.WriteByOrder("W_i_status", (byte)2, name);


                            client.WriteByOrder("R_oi_on", (byte)0, name);


                            #region æ—¥å¿—记录


                            //WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单详情", "PCS");


                            WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单详情");


                            #endregion


                            continue;


                        }


                        #region MyRegion


                        //var mes_Detail = mes_DetailRepository.FindFirst(x => x.SN == wp_id);


                        //if (mes_Detail == null)


                        //{


                        //    client.WriteByOrder("W_i_status", (byte)2, name);


                        //    client.WriteByOrder("R_oi_on", (byte)0, name);


                        //    #region æ—¥å¿—记录


                        //    WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单详情", "PCS");


                        //    #endregion


                        //    continue;


                        //}


                        //var mes_Head = mes_HeadRepository.FindFirst(x => x.jobID == mes_Detail.jobID);


                        //if (mes_Head == null)


                        //{


                        //    client.WriteByOrder("W_i_status", (byte)2, name);


                        //    client.WriteByOrder("R_oi_on", (byte)0, name);


                        //    #region æ—¥å¿—记录


                        //    WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到工单头表", "PCS");


                        //    #endregion


                        //    continue;


                        //}


                        #endregion




                        var mes_Head = mes_HeadRepository.FindFirst(x => x.jobID == Mes_Work.jobID);




                        if (name != "辊道上料查询订单")


                        var geometry = Pipeline.QueryMateriel(Mes_Work.drawingNo);


                        if (geometry == null)


                        {


                            //需添加查询车轮SN号订单逻辑   éœ€æ·»åŠ å…¥åº“模式判断，手动入库模式需人工添加入库库区，否则报警


                            var pattern = patternRepository.FindFirst(x => x.pattern_name == "入库模式").pattern_state;


                            if (pattern != 1 && string.IsNullOrEmpty(mes_Head.area))


                            {


                                client.WriteByOrder("W_i_status", (byte)4, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：4\nR_oi_on：0\n\n手动入库模式未选择库区", "PCS");


                                WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n\n写入桁架信息：\nW_i_status：4\nR_oi_on：0\n\n手动入库模式未选择库区");


                                #endregion


                                continue;


                            }


                            //var geometry = dataRepository.FindFirst(x => x.TypeId == (Int32)wp_type);


                            var geometry = dataRepository.Find(x => x.Description == mes_Head.drawingNo /*&& x.TypeId == (Int32)wp_type*/).FirstOrDefault();


                            var geometry1 = detectionlineRepository.Find(x => x.Description == mes_Head.drawingNo).FirstOrDefault();


                            if (geometry == null && geometry1 == null)


                            {


                                //1-好,允许加工，2-不在列表中，3-不加工车轮类型，4-手动入库模式人工未选择库区


                                client.WriteByOrder("W_i_status", (byte)2, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到机加工车轮信息", "PCS");


                                WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到机加工车轮信息");


                                #endregion


                                continue;


                            }


                            else


                            {


                                //1-好,允许加工，2-不在列表中，3-不加工车轮类型，4-手动入库模式人工未选择库区


                                client.WriteByOrder("W_i_status", (byte)1, name);


                                client.WriteByOrder("W_i_job_id", Mes_Work.jobID, name);


                                client.WriteByOrder("W_i_drawing_id", Mes_Work.drawingNo, name);


                                client.WriteByOrder("W_i_heat_id", Mes_Work.heatID, name);


                                //client.WriteByOrder("W_i_sourceheat", "", name);


                                client.WriteByOrder("W_i_batch_id", Mes_Work.heatBatchID, name);




                                //屏蔽工艺(屏蔽视觉检测/屏蔽涂油)


                                //if (name != "辊道上料查询车轮")


                                //{


                                client.WriteByOrder("W_i_skip_op_SJ1", name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_1, name);//屏蔽视觉检测设备1


                                client.WriteByOrder("W_i_skip_op_SJ2", name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_2, name);//屏蔽视觉检测设备2


                                client.WriteByOrder("W_i_skip_op_LT", mes_Head.skip_op_3, name);//屏蔽链条机


                                //}


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                WriteLog.Write_Log(name, wp_id, "写入信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" +


                                    $"\nW_i_job_id：{Mes_Work.jobID}\nW_i_drawing_id：{Mes_Work.drawingNo}\nW_i_heat_id：{Mes_Work.heatID}\nW_i_batch_id：{Mes_Work.heatBatchID}" +


                                    $"\nW_i_skip_op_SJ1：{(name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_1)}\nW_i_skip_op_SJ2：{(name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_2)}" +


                                    $"\nW_i_skip_op_LT：{mes_Head.skip_op_3}\nR_oi_on：0");


                                //WriteDBLog.Success(name, $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" +


                                //    $"\nW_i_job_id：{Mes_Work.jobID}\nW_i_drawing_id：{Mes_Work.drawingNo}\nW_i_heat_id：{Mes_Work.heatID}\nW_i_batch_id：{Mes_Work.heatBatchID}" +


                                //    $"\nW_i_skip_op_SJ1：{(name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_1)}\nW_i_skip_op_SJ2：{(name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_2)}" +


                                //    $"\nW_i_skip_op_LT：{mes_Head.skip_op_3}\nR_oi_on：0", "PCS");


                                #endregion


                            }


                            //1-好,允许加工，2-不在列表中，3-不加工车轮类型，4-手动入库模式人工未选择库区


                            client.WriteByOrder("W_i_status", (byte)2, name);


                            client.WriteByOrder("R_oi_on", (byte)0, name);


                            #region æ—¥å¿—记录


                            WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到机加工车轮信息");


                            #endregion


                            continue;


                        }


                        else


                        {


                            var geometry = detectionlineRepository.Find(x => x.Description == mes_Head.drawingNo /*&& x.TypeId == (Int32)wp_type*/).FirstOrDefault();


                            var geometry1 = dataRepository.Find(x => x.Description == mes_Head.drawingNo).FirstOrDefault();


                            if (geometry == null && geometry1 == null)


                            //1-好,允许加工，2-不在列表中，3-不加工车轮类型，4-手动入库模式人工未选择库区


                            client.WriteByOrder("W_i_status", (byte)1, name);


                            client.WriteByOrder("W_i_job_id", Mes_Work.jobID, name);


                            client.WriteByOrder("W_i_drawing_id", Mes_Work.drawingNo, name);


                            client.WriteByOrder("W_i_heat_id", Mes_Work.heatID, name);


                            //client.WriteByOrder("W_i_sourceheat", "", name);


                            client.WriteByOrder("W_i_batch_id", Mes_Work.heatBatchID, name);




                            //屏蔽工艺(屏蔽视觉检测/屏蔽涂油)


                            if (name != "辊道上料查询订单")


                            {


                                //1-好,允许加工，2-不在列表中，3-不加工车轮类型，4-手动入库模式人工未选择库区


                                client.WriteByOrder("W_i_status", (byte)2, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                //WriteDBLog.Error(name, $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到检测线车轮信息", "PCS");


                                WriteLog.Write_Log(name, wp_id, "错误信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：2\nR_oi_on：0\n\n未查询到检测线车轮信息");


                                #endregion


                                continue;


                                client.WriteByOrder("W_i_skip_op_SJ1", name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_1, name);//屏蔽视觉检测设备1


                                client.WriteByOrder("W_i_skip_op_SJ2", name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_2, name);//屏蔽视觉检测设备2


                                client.WriteByOrder("W_i_skip_op_LT", mes_Head.skip_op_3, name);//屏蔽链条机


                            }


                            else


                            {


                                //1-好,允许加工，2-不在列表中，3-不加工车轮类型，4-手动入库模式人工未选择库区


                                client.WriteByOrder("W_i_status", (byte)1, name);


                                client.WriteByOrder("W_i_job_id", Mes_Work.jobID, name);


                                client.WriteByOrder("W_i_drawing_id", Mes_Work.drawingNo, name);


                                client.WriteByOrder("W_i_heat_id", Mes_Work.heatID, name);


                                //client.WriteByOrder("W_i_sourceheat", "", name);


                                client.WriteByOrder("W_i_batch_id", Mes_Work.heatBatchID, name);


                                client.WriteByOrder("R_oi_on", (byte)0, name);


                                #region æ—¥å¿—记录


                                WriteLog.Write_Log(name, wp_id, "写入信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\nW_i_job_id：{Mes_Work.jobID}" +


                                    $"\nW_i_drawing_id：{mes_Head.drawingNo}\nW_i_heat_id：{Mes_Work.heatID}\nW_i_batch_id：{Mes_Work.heatBatchID}\nR_oi_on：0");


                                //WriteDBLog.Success(name, $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" + $"\nW_i_job_id：{Mes_Work.jobID}" +


                                //    $"\nW_i_drawing_id：{mes_Head.drawingNo}\nW_i_heat_id：{Mes_Work.heatID}\nW_i_batch_id：{Mes_Work.heatBatchID}\nR_oi_on：0", "PCS");


                                #endregion


                            }


                            client.WriteByOrder("R_oi_on", (byte)0, name);


                            #region æ—¥å¿—记录


                            WriteLog.Write_Log(name, wp_id, "写入信息！", $"读取桁架信息：\n车轮SN：{wp_id}\n轮型ID：{wp_type}\n\n写入桁架信息：\nW_i_status：1" +


                                $"\nW_i_job_id：{Mes_Work.jobID}\nW_i_drawing_id：{Mes_Work.drawingNo}\nW_i_heat_id：{Mes_Work.heatID}\nW_i_batch_id：{Mes_Work.heatBatchID}" +


                                $"\nW_i_skip_op_SJ1：{(name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_1)}\nW_i_skip_op_SJ2：{(name == "3单元辊道下料查询订单" ? true : mes_Head.skip_op_2)}" +


                                $"\nW_i_skip_op_LT：{mes_Head.skip_op_3}\nR_oi_on：0");


                            #endregion


                        }


                    }


                }


@@ -408,7 +247,6 @@


                Idt_plcinfodetailRepository plcRepository = new dt_plcinfodetailRepository(Context);


                Idt_stationinfoRepository stationinfoRepository = new dt_stationinfoRepository(Context);


                Idt_geometry_dataRepository dataRepository = new dt_geometry_dataRepository(Context);


                Idt_geometry_data_detectionlineRepository detectionlineRepository = new dt_geometry_data_detectionlineRepository(Context);


                Idt_mes_detailRepository mes_DetailRepository = new dt_mes_detailRepository(Context);


                Idt_mes_headRepository mes_HeadRepository = new dt_mes_headRepository(Context);


                IVV_Mes_WorkinfoRepository workinfoRepository = new VV_Mes_WorkinfoRepository(Context);


@@ -461,7 +299,7 @@


                            }




                            //var Wheel_id = DBExtension.Read(details.Where(x => x.plcdetail_name == "R_Wheel_id").First(), client).ToString();


                            var Mes_Work = workinfoRepository.Find(x => x.SN == Wheel_SN && x.processCode == "17").FirstOrDefault();


                            var Mes_Work = workinfoRepository.Find(x => x.SN == Wheel_SN && x.processCode == "17").OrderByDescending(x => x.CreateTime).FirstOrDefault();


                            if (Mes_Work == null)


                            {


                                #region æ—¥å¿—记录


@@ -470,7 +308,7 @@


                                #endregion


                                continue;


                            }




                            var geometry = Pipeline.QueryMateriel(Mes_Work.drawingNo);


                            #endregion




                            var AreaNr = (Int16)DBExtension.Read(details.Where(x => x.plcdetail_name == "W_AreaNr").First(), client);


@@ -496,7 +334,8 @@


                            var station = stationinfoRepository.Find(x => x.area == areaCode && x.stationCode.Substring(x.stationCode.Length - 1, 1) == AreaNr.ToString()).FirstOrDefault();


                            if (station != null)


                            {


                                if (station.quantity >= 5)


                                if (station.quantity >= geometry.stackNoRange)


                                //if (station.quantity >= 5)


                                {


                                    Pipeline_client.WriteByOrder("W_AlarmSignal", (Int16)2, name);//报警


                                    WriteLog.Write_Log(name + "放料完成出错", Wheel_SN, "车轮数量已满！", $"区域号：{AreaNr}；\n车轮数：{station.quantity}\n错误信息：区域号车轮数量已满！");


@@ -556,13 +395,13 @@


                                var Detail = mes_DetailRepository.FindFirst(x => x.jobID == Mes_Work.jobID && x.SN == Mes_Work.SN);


                                Detail.Status = "下线";


                                Detail.FinishTime = DateTime.Now;


                                count = mes_DetailRepository.Update(Detail, true);


                                count = mes_DetailRepository.Update(Detail, x => new { x.Status, x.FinishTime }, true);


                                if (count < 1)


                                    throw new Exception($"工单子表信息更新失败！车轮SN号：{Detail.SN}");


                                var Head = mes_HeadRepository.FindFirst(x => x.jobID == Detail.jobID);


                                Head.finishNum = Head.finishNum + 1;


                                if (Head.finishNum == Head.quantity) Head.FinishTime = DateTime.Now;


                                count = mes_HeadRepository.Update(Head, true);


                                count = mes_HeadRepository.Update(Head, x => new { x.finishNum, x.FinishTime }, true);


                                if (count < 1)


                                    throw new Exception($"工单头表信息更新失败！工单号：{Head.jobID}");


                                #endregion


@@ -590,9 +429,7 @@


                            WriteLog.Write_Log(name + "申请放料异常", "车轮SN号为空", "", $"读取桁架信息：\n车轮SN号：{Wheel_id}为空");


                            continue;


                        }






                        var Work = workinfoRepository.Find(x => x.SN == Wheel_id && x.processCode == "17").FirstOrDefault();


                        var Work = workinfoRepository.Find(x => x.SN == Wheel_id && x.processCode == "17").OrderByDescending(x => x.CreateTime).FirstOrDefault();


                        if (Work == null)


                        {


                            client.WriteByOrder("W_Enabl_Load", false, name);//信号为false桁架停止进入


@@ -600,26 +437,11 @@


                            WriteLog.Write_Log(name + "申请放料异常", Wheel_id, "查询机加工工单", $"读取桁架信息：\n车轮SN号：{Wheel_id}未查询到工单信息\n写入桁架信息：\n是否允许下料：{false}");


                            continue;


                        }






                        #endregion








                        #region MyRegion


                        //var currentAreaNr = (Int16)DBExtension.Read(details.Where(x => x.plcdetail_name == "W_Are00aNr").First(), client);


                        //var currentAreaCode = PipelineJob.area_code(name);   //根据下料口单元名获取区域代码


                        //var currentStation = stationinfoRepository.FindFirst(x => x.area == currentAreaCode && x.stationCode.Substring(x.stationCode.Length - 1, 1) == currentAreaNr.ToString());


                        //if (!currentStation.enable || currentStation.location_state == LocationStateEnum.Empty.ToString())


                        //    client.WriteByOrder("W_Enabl_Load", false, name);//信号为false桁架停止进入


                        #endregion










                        var wheel = Pipeline.QueryMateriel(Work.drawingNo);


                        var wheel1 = Pipeline.QueryMateriel1(Work.drawingNo);


                        if (wheel == null && wheel1 == null)


                        //var wheel1 = Pipeline.QueryMateriel1(Work.drawingNo);


                        if (wheel == null /*&& wheel1 == null*/)


                        {


                            #region æ—¥å¿—记录


                            client.WriteByOrder("W_Enabl_Load", false, name);//信号为false桁架停止进入


@@ -640,6 +462,22 @@


                        }


                        #endregion




                        #region æ‰˜ç›˜ç±»åž‹ä¸ä¸€è‡´éœ€æ›´æ¢æ‰˜ç›˜


                        stations = Stations.Where(x => x.enable).ToList();


                        foreach (var Stationinfo in stations)


                        {


                            if (Stationinfo.tray_type != "LargeTray" && /*(wheel == null ? wheel1.e :)*/ wheel.e > 1100)


                            {


                                client.WriteByOrder("W_Enabl_Load", false, name);//信号为false桁架停止进入


                                Stationinfo.location_state = LocationStateEnum.Trayswitching.ToString();


                                Stationinfo.remark = "托盘类型不一致需更换托盘";


                                stationinfoRepository.Update(Stationinfo, x => new { x.location_state }, true);


                            }


                        }


                        #endregion




                        Stations = stationinfoRepository.Find(x => x.area == Pipeline.area_code(name)).OrderBy(x => x.lastUpdateTime).ToList();




                        var PartStatus = DBExtension.Read(details.Where(x => x.plcdetail_name == "R_PartStatus").First(), client);//1:ok;2:nok




                        var load_zone = (bool)DBExtension.Read(details.Where(x => x.plcdetail_name == "R_load_zone").First(), client);


@@ -659,7 +497,8 @@


                           .Where(x => x.enable


                           && x.stationCode != NGStation


                           && x.location_state == LocationStateEnum.Stroge.ToString()


                           && x.quantity < 5


                           && x.quantity < wheel.stackNoRange


                           //&& x.quantity < 5


                           && x.stationType == Work.drawingNo


                           && x.Number == Work.workOrder


                           && x.heatNumber == Work.heatID)


@@ -672,7 +511,8 @@


                           .Where(x => x.enable


                           && x.stationCode != NGStation


                           && x.location_state == LocationStateEnum.Stroge.ToString()


                           && x.quantity < 5


                           && x.quantity < wheel.stackNoRange


                           //&& x.quantity < 5


                           && x.stationType == Work.drawingNo


                           && x.Number == Work.workOrder)


                           .OrderByDescending(x => x.quantity)


@@ -701,25 +541,14 @@


                                #endregion




                                #region æ‰˜ç›˜è½¦è½®å †åž›ç¬¬å››ä¸ªæ—¶ä¸‹å‘另外一个炉号的入库任务


                                if (Stationinfo.quantity + 1 >= 4)


                                //if (Stationinfo.quantity + 1 >= 4)


                                if (Stationinfo.quantity + 1 >= wheel.stackNoRange - 1)


                                {


                                    var stationinfo = Stations.Where(x => x.enable && x.stationCode != NGStation && x.stationCode != Stationinfo.stationCode && x.location_state == LocationStateEnum.Stroge.ToString() && x.quantity > 0).FirstOrDefault();


                                    if (stationinfo != null)


                                        agvtask(stationinfoRepository, stationinfo, Work, name == "3单元下料区" ? "TaskType_OutsourceInbound" : "TaskType_Inbound");


                                }




                                #endregion




                                #region æ‰˜ç›˜ç±»åž‹ä¸ä¸€è‡´éœ€æ›´æ¢æ‰˜ç›˜


                                if (Stationinfo.tray_type != "LargeTray" && (wheel == null ? wheel1.e : wheel.e) > 1100)


                                {


                                    client.WriteByOrder("W_Enabl_Load", false, name);//信号为false桁架停止进入


                                    Stationinfo.location_state = LocationStateEnum.Abnormal.ToString();


                                    Stationinfo.tray_type = Stationinfo.tray_type == "SmallTray" ? "SmallTray/LargeTray" : "LargeTray/SmallTray";


                                    Stationinfo.remark = "托盘类型不一致需更换托盘";


                                    stationinfoRepository.Update(Stationinfo, true);


                                    continue;


                                }


                                #endregion




                                var Pipelinedetails = plcRepository.Find(x => x.plcdetail_iotype == Pipelineplc.plcinfo_iotyep && x.plcdetail_number == Stationinfo.stationCode).ToList();


@@ -812,7 +641,8 @@


                            dt_stationinfo Stationinfo = Stations.Where(x => x.enable


                            && x.stationCode == NGStation


                            && x.location_state == LocationStateEnum.Stroge.ToString()


                            && x.quantity < 5


                            && x.quantity < wheel.stackNoRange


                            //&& x.quantity < 5


                            && x.stationType == Work.drawingNo).FirstOrDefault();




                            if (Stationinfo == null)


@@ -831,17 +661,6 @@


                            }


                            if (Stationinfo != null)


                            {


                                #region æ‰˜ç›˜ç±»åž‹ä¸ä¸€è‡´éœ€æ›´æ¢æ‰˜ç›˜


                                //if (Stationinfo.tray_type != ((wheel == null ? wheel1.e : wheel.e) < 1100 ? "SmallTray" : "LargeTray"))


                                if (Stationinfo.tray_type != "LargeTray" && (wheel == null ? wheel1.e : wheel.e) > 1100)


                                {


                                    Stationinfo.location_state = LocationStateEnum.Abnormal.ToString();


                                    Stationinfo.tray_type = Stationinfo.tray_type == "SmallTray" ? "SmallTray/LargeTray" : "LargeTray/SmallTray";


                                    Stationinfo.remark = "托盘类型不一致需更换托盘";


                                    stationinfoRepository.Update(Stationinfo, true);


                                    continue;


                                }


                                #endregion


                                var Pipelinedetails = plcRepository.Find(x => x.plcdetail_iotype == Pipelineplc.plcinfo_iotyep && x.plcdetail_number == Stationinfo.stationCode).ToList();


                                var PalletSignal = (Int16)DBExtension.Read(Pipelinedetails.Where(x => x.plcdetail_name == "R_PalletSignal").First(), Pipeline_client);//读取托盘信号:1:有,2无


                                var MaterialSignal = (Int16)DBExtension.Read(Pipelinedetails.Where(x => x.plcdetail_name == "R_MaterialSignal").First(), Pipeline_client);//读取货物信号:1:有,2无


@@ -899,7 +718,7 @@


                                    //WriteDBLog.Success(name + "允许放料", $"读取桁架信息：\n车轮SN：{Wheel_id}\n轮型ID：{Wheel_Type}\n车轮状态：NG" +$"\n读取托盘光电信号：{PalletSignal}" +


                                    //    $"\n\n写入桁架信息：\n下料位号：{area}\n第几个车轮：{(Stationinfo.quantity + 1)}\n托盘类型：1\nW_Enabl_Load：true", "PCS");


                                    WriteLog.Write_Log(name + "申请放料", Wheel_id, "允许放料",


                                        $"读取桁架信息：\n车轮SN：{Wheel_id}\n轮型ID：{Wheel_Type}\n车轮状态：合格" +


                                        $"读取桁架信息：\n车轮SN：{Wheel_id}\n轮型ID：{Wheel_Type}\n车轮状态：不合格" +


                                        $"\n读取托盘光电信号：{PalletSignal}" +


                                        $"\n\n写入桁架信息：\n下料位号：{area}\n第几个车轮：{(Stationinfo.quantity + 1)}\n托盘类型：1\n是否允许下料：true");


                                    #endregion


@@ -930,77 +749,13 @@


            VOLContext Context = new VOLContext();


            Idt_agvtaskRepository agvtaskRepository = new dt_agvtaskRepository(Context);


            IVV_Mes_WorkinfoRepository workinfoRepository = new VV_Mes_WorkinfoRepository(Context);


            Work = workinfoRepository.Find(x => x.workOrder == stationinfo.Number && x.processCode == "17").FirstOrDefault();


            Work = workinfoRepository.Find(x => x.workOrder == stationinfo.Number && x.processCode == "17").OrderByDescending(x => x.CreateTime).FirstOrDefault();


            var task = agvtaskRepository.Find(x => x.agv_fromaddress == stationinfo.stationCode).FirstOrDefault();


            if (task != null) return;


            if (!string.IsNullOrEmpty(Work.area))


                tasktype = "TaskType_OutsourceInbound";


            AGVTask.AddQueueTask(stationinfoRepository, agvtaskRepository, stationinfo, tasktype, Work);


        }




        #region MyRegion


        /// <summary>


        /// AGV任务


        /// </summary>


        //public void agvtask(Idt_stationinfoRepository stationinfoRepository, dt_stationinfo stationinfo, VV_Mes_Workinfo Work, string tasktype)


        //{


        //    VOLContext Context = new VOLContext();


        //    Idt_agvtaskRepository agvtaskRepository = new dt_agvtaskRepository(Context);


        //    Idt_mes_headRepository mes_HeadRepository = new dt_mes_headRepository(Context);




        //    var task = agvtaskRepository.Find(x => x.agv_fromaddress == stationinfo.stationCode).FirstOrDefault();


        //    if (task != null) return;


        //    //var mes_Head = mes_HeadRepository.Find(x => x.jobID == Work.jobID).FirstOrDefault();


        //    //if (mes_Head == null)


        //    //{


        //    //    stationinfo.remark = "触发入库任务,但未找到工单头表！";


        //    //    stationinfo.location_state = LocationStateEnum.Abnormal.ToString();


        //    //    stationinfoRepository.Update(stationinfo, true);


        //    //    return;


        //    //}




        //    dt_stationinfo TargetLocation = null;


        //    //int CompeletedNum = Convert.ToInt32(mes_Head.quantity) - Convert.ToInt32(mes_Head.finishNum);


        //    //if (mes_Head.quantity <= 50) tasktype = "TaskType_OutsourceInbound";




        //    if (tasktype == "TaskType_OutsourceInbound" || !string.IsNullOrEmpty(Work.area))


        //        TargetLocation = StationTask.GetEmptyLocation(stationinfoRepository);


        //    else if (tasktype == "TaskType_Inbound")


        //        TargetLocation = GetLocation.GetEmptyLocation(stationinfoRepository, Work, stationinfo);


        //    //TargetLocation = GetLocation.GetEmptyLocation(stationinfoRepository, mes_Head, stationinfo);


        //    if (TargetLocation != null)


        //    {


        //        dt_agvtask agvtask = new dt_agvtask()


        //        {


        //            agv_fromaddress = stationinfo.stationCode,


        //            agv_id = Guid.NewGuid(),


        //            agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),


        //            agv_grade = 1,


        //            agv_createtime = DateTime.Now,


        //            agv_taskstate = "Create",


        //            agv_materielid = stationinfo.stationType,


        //            agv_qty = stationinfo.quantity,


        //            agv_tasktype = tasktype,


        //            agv_toaddress = TargetLocation.stationCode,


        //            agv_userid = "系统",


        //            bindSN = stationinfo.bindSN,


        //            agv_worktype = Convert.ToInt32(Work.processCode),


        //            agv_materbarcode = Work.materialCode,


        //            agv_Traytype = stationinfo.tray_type,


        //            jobID = stationinfo.Number,


        //            agv_TrayStatus = stationinfo.tray_status


        //        };


        //        agvtaskRepository.Add(agvtask, true);


        //        stationinfo.location_state = LocationStateEnum.InBusy.ToString();


        //        stationinfoRepository.Update(stationinfo, true);


        //        TargetLocation.location_state = LocationStateEnum.InBusy.ToString();


        //        TargetLocation.stationType = agvtask.agv_materielid;


        //        TargetLocation.heatNumber = stationinfo.heatNumber;


        //        TargetLocation.Number = agvtask.jobID;


        //        stationinfoRepository.Update(TargetLocation, true);


        //    }


        //}


        #endregion




    }


}