三升小诸葛接口：生产订单同步修改

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");