不良处理接口开发

yl

2022-08-23 0dd2c49c7123f177338985686fe5a0a00a851fbc

 VueWebApi/DLL/DAL/ProductModelDAL.cs

@@ -1188,12 +1188,14 @@
                        }
                    }
                    //当前工序类型与关联工作站中的类型是否匹配,不匹配则清除关联工作站数据，同时清理工序标(关联工作站标识字段为N)
                    var sql_10 = @"select *  from TFlw_Rteqp where step_code=@stepcode";
                    var sql_10 = @"select S.flwtype  from TFlw_Rteqp  A
                                   inner join TStep S on A.step_code=S.stepcode
                                   where A.step_code=@stepcode";
                    dynamicParams.Add("@stepcode", stepcode);
                    var data_10 = DapperHelper.selectdata(sql_10, dynamicParams);
                    if (data_10.Rows.Count > 0)
                    {
                        if (data_10.Rows[0]["STYLE"].ToString() != "steptypecode") 
                        if (data_10.Rows[0]["FLWTYPE"].ToString() != steptypecode) 
                        {
                            //删除工序关联工作站表
                            sql_1 = @"delete TFlw_Rteqp  where step_code=@stepcode";