智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2025-05-06 349ae30efbec2f279047e9b134971f544b636d4e 
 WebAPI/Controllers/Êý¾Ýͬ²½/СÖî¸ðͬ²½/XZG_DataSynchronizationController.cs


@@ -1099,7 +1099,7 @@


                List<ICMO> icmos = new List<ICMO>();


                string sql = @"select 


                               cast(a.FBILLNO as varchar(100)) + '_' + cast(b.FSEQ as varchar(10)) + '_' +  cast(b.FENTRYID as varchar(10)) è®¡åˆ’单号


                               ,cast(b.FQTY as int) è®¡åˆ’数量


                               ,cast(b.FQTY as int) - cast(c.FSTOCKINQUAAUXQTY as int) è®¡åˆ’数量


                               ,m.FNUMBER äº§å“ç¼–号


                               ,convert(varchar(100),b.FPLANSTARTDATE,20) è®¡åˆ’开工日期


                               ,convert(varchar(100),b.FPLANFINISHDATE,20) è®¡åˆ’完工日期


@@ -1111,7 +1111,7 @@


                               ,'' è‰²ç²‰åç§°


                               ,'' ææ–™ç¼–号


                               ,'' ææ–™åç§°


                               ,a.FBILLNO è®¢å•ç¼–号


                               ,ISNULL(b.F_sans_Text,'') è®¢å•ç¼–号


                               ,ISNULL(convert(varchar(100),c.FSTARTDATE ,20),'') å¼€å·¥æ—¥æœŸ


                               ,convert(varchar(100),a.FMODIFYDATE,20) ä¿®æ”¹æ—¥æœŸ


                            from " +  erpDatabaseName + @"T_PRD_MO as a


@@ -1122,11 +1122,13 @@


                            where m_l.FLOCALEID=2052


                            and isnull(a.FAPPROVERID,0)<> 0            --已经审核


                            and isnull(c.fstatus,0) in (4)               --业务状态（1:计划；2:计划确认；3:下达；4:开工；5:完工；6:结案）


                            and b.FWORKSHOPID in (477069)                   --生产车间(477069：注塑车间)


                            --and a.FBillNo = 'MO233207'


                            and 


                               (


                               convert(varchar(100),a.fmodifydate,23) >= convert(varchar(100),dateadd(day,-7,getdate()),23)


                               convert(varchar(100),a.fmodifydate,23) >= convert(varchar(100),dateadd(day,-1,getdate()),23)


                               or


                               convert(varchar(100),c.fstartdate ,23) >= convert(varchar(100),dateadd(day,-7,getdate()),23)


                               convert(varchar(100),c.fstartdate ,23) >= convert(varchar(100),dateadd(day,-1,getdate()),23)


                               )


                            --and cast(a.FBILLNO as varchar(100)) + '_' + cast(b.FSEQ as varchar(10)) = 'MO000269_1'";


                DataSet ds = oCN.RunProcReturn(sql, "" +  erpDatabaseName + @"T_PRD_MO");