智云MES后端API代码
parent: b99fd65a | 补丁 | 提交 | ignore whitespace
duhe
2025-05-06 da4534f2356a2f7215b8735d6f2e936dc35b15de 
三升小诸葛接口：物料同步调试
1个文件已修改
8 ■■■■■ 已修改文件
WebAPI/Controllers/数据同步/小诸葛同步/XZG_DataSynchronizationController.cs 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/Êý¾Ýͬ²½/СÖî¸ðͬ²½/XZG_DataSynchronizationController.cs


@@ -735,7 +735,7 @@


                {"key", DBUtility.ClsPub.isStrNull(material.key)},


                {"productName", DBUtility.ClsPub.isStrNull(material.productName)},


                {"partNum",DBUtility.ClsPub.isStrNull(material.partNum)},


                {"sepc", DBUtility.ClsPub.isStrNull(material.sepc)},


                {"Spec", DBUtility.ClsPub.isStrNull(material.sepc)},


                {"weight", DBUtility.ClsPub.isStrNull(material.weight)},


                {"headWeight", DBUtility.ClsPub.isStrNull(material.headWeight)},


                {"cycletime", DBUtility.ClsPub.isStrNull(material.cycleTime)},


@@ -781,7 +781,7 @@


                {"productName", DBUtility.ClsPub.isStrNull(material.productName)},


                {"partNum",DBUtility.ClsPub.isStrNull(material.partNum)},


                {"cycletime", DBUtility.ClsPub.isStrNull(material.cycleTime)},


                {"sepc", DBUtility.ClsPub.isStrNull(material.sepc)},


                {"Spec", DBUtility.ClsPub.isStrNull(material.sepc)},


                {"weight", DBUtility.ClsPub.isStrNull(material.weight)},


                {"headWeight", DBUtility.ClsPub.isStrNull(material.headWeight)},


                {"fightsPartnum", DBUtility.ClsPub.isStrNull(material.flightsPartnum)},


@@ -832,13 +832,13 @@


                            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_MATERIALPRODUCE proce with(nolock) on a.FMATERIALID = proce.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 proce.FWORKSHOPID = 477069                   --生产车间(477069：注塑车间)


                            and b.FErpClsID = 2                             --物料属性(2：自制)


                            and


                                (