设备点检标准、保养标准关联工作站接口去掉最后过滤条件

yl

2023-01-10 f246165de1e2e6bcca4275e31458c5625c0c84fb

 VueWebApi/DLL/DAL/DeviceManagerDAL.cs

@@ -1362,7 +1362,7 @@
                             inner join TEqpchk_Eqp B on A.code=B.eqp_code
                             where A.wksp_code=@wkspcode and B.eqpchkmain_code=@checkstand_code and A.is_delete<>'1'
                            ) as BB on AA.code=BB.code
                            ) as CC where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1";
                            ) as CC ";//where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1
                    dynamicParams.Add("@checkstand_code", checkstand_code);
                    dynamicParams.Add("@wkspcode", data.Rows[i]["WKSP_CODE"].ToString());
                    var data0 = DapperHelper.selectdata(sql, dynamicParams);
@@ -1800,7 +1800,7 @@
                             inner join TEqpmai_Eqp B on A.code=B.eqp_code
                             where A.wksp_code=@wkspcode and B.eapmai_code=@repairstand_code and A.is_delete<>'1'
                            ) as BB on AA.code=BB.code
                            ) as CC where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1";
                            ) as CC ";//where case when flag ='N' and flage1 ='Y' then 0 else 1 end=1
                    dynamicParams.Add("@repairstand_code", repairstand_code);
                    dynamicParams.Add("@wkspcode", data.Rows[i]["WKSP_CODE"].ToString());
                    var data0 = DapperHelper.selectdata(sql, dynamicParams);