安灯呼叫绑定人员加上已删除的人员过滤条件 App班组计件工资(平均)接口开发

yl

2022-12-19 51123c1c38884cb8a16e0060aa28b1988bf7de81

 VueWebApi/DLL/DAL/BasicSettingDAL.cs

@@ -1839,7 +1839,7 @@
                sql = @"select B.id,B.ando_cogfigid,U.usercode,U.username,A.enable  from TAnDon_Roul_ConFig A
                        inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
                        left  join TUser U on B.usercode=U.usercode
                        where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode";
                        where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode and U.is_delete=0";
                dynamicParams.Add("@wkshopcode", wkshopcode);
                dynamicParams.Add("@calltypecode", calltypecode);
                var data = DapperHelper.selectdata(sql, dynamicParams);