1.App 智能分析，生产进度看板接口 2.PC端设备点检项目、保养项目、点检标准、保养标准、点检记录、保养记录、维修记录 3.工序检验扫码添加判断(...

yl

2023-12-11 22af5bed0da8a5852bd824a1e21e6fc43df6df2a

 VueWebCoreApi/DLL/DAL/QualityManagementDAL.cs

@@ -784,6 +784,31 @@
                        ordercode = arra[0]; //获取指定字符串前面的字符
                        stepcode = arra[1]; //获取指定字符串前面的字符
                    }
                    //0.判断当前条码工序任务不存在
                    sql = @"select *   from TK_Wrk_Step where wo_code=@ordercode and step_code=@step_code";
                    dynamicParams.Add("@ordercode", ordercode);
                    dynamicParams.Add("@step_code", stepcode);
                    var da1 = DapperHelper.selectdata(sql, dynamicParams);
                    if (da1.Rows.Count <= 0)
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.message = "当前条码,工序任务不存在,请联系管理员!";
                        mes.data = null;
                        return mes;
                    }
                    //判断当前工单是否关闭
                    sql = @"select *   from TK_Wrk_Man where wo_code=@ordercode  and status='CLOSED'";
                    dynamicParams.Add("@ordercode", ordercode);
                    var da0 = DapperHelper.selectdata(sql, dynamicParams);
                    if (da0.Rows.Count > 0)
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.message = "当前工单已关闭,不允许检验操作!";
                        mes.data = null;
                        return mes;
                    }                 
                    //通过扫描二维码信息查找任务信息
                    sql = @"select A.wo_code,A.good_qty,M.partcode,M.partname,M.partspec,M.idinventoryclass as stocktype_code,S.stepcode,S.stepname  
                            from TK_Wrk_Step A