三升小诸葛接口：物料同步根据车间和物料属性进行过滤

duhe

2025-05-06 b99fd65a54812cc3213fa378e9cae7654186e72d

三升小诸葛接口：物料同步根据车间和物料属性进行过滤

 WebAPI/Controllers/Êý¾Ýͬ²½/СÖî¸ðͬ²½/XZG_DataSynchronizationController.cs

@@ -830,12 +830,16 @@
                                ,convert(varchar(100),a.FMODIFYDATE,20) HUpdateDate
                            from " +  erpDatabaseName + @"T_BD_MATERIAL a with(nolock)
                            inner join " +  erpDatabaseName + @"T_BD_MATERIAL_L l with(nolock) on a.FMATERIALID=l.FMATERIALID 
                            inner join " +  erpDatabaseName + @"T_BD_MATERIALBASE b with(nolock) on a.FMATERIALID=b.FMATERIALID 
                            inner join " +  erpDatabaseName + @"T_BD_MATERIALSTOCK s with(nolock) on a.FMATERIALID=s.FMATERIALID 
                            inner join " +  erpDatabaseName + @"T_BD_MATERIALPRODUCE proc with(nolock) on a.FMATERIALID = proc.FMATERIALID
                            inner join " +  erpDatabaseName + @"T_BD_Unit_L unit with(nolock) on isnull(s.FSTOREUNITID,0) = unit.FUNITID
                            Where l.FLOCALEID=2052
                            and unit.FLOCALEID = 2052
                            and a.FFORBIDSTATUS='A'
                            and a.FUSEORGID = 1
                            and proc.FWORKSHOPID = 477069                   --生产车间(477069：注塑车间)
                            and b.FErpClsID = 2                             --物料属性(2：自制)
                            and
                                (
                                     convert(varchar(100),a.FCREATEDATE,23) >= convert(varchar(100),DATEADD(day,-1,getdate()),23)