三升小诸葛数据同步

duhe

2025-05-06 1b9037dc460ee7caed5954e3b935bf89f9e0524e

三升小诸葛数据同步

 LMES/XiaoZhuGe_autoGetData.Designer.cs

@@ -43,7 +43,7 @@
            // timer2
            // 
            this.timer2.Enabled = true;
            this.timer2.Interval = 3600;
            this.timer2.Interval = 300000;
            this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
            // 
            // notifyIcon_Icon

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

@@ -558,7 +558,8 @@
        #endregion

        #region erp数据库名称
        string erpDatabaseName = "AIS20210811135644..";
        //string erpDatabaseName = "AIS20210811135644..";           //47金蝶云数据库名称
        string erpDatabaseName = "AIS20201117213251..";             //三升金蝶云数据库名称
        #endregion

        #region èŽ·å–服务地址
@@ -834,11 +835,12 @@
                            Where l.FLOCALEID=2052
                            and unit.FLOCALEID = 2052
                            and a.FFORBIDSTATUS='A'
                            and a.FUSEORGID = 1
                            and
                                (
                                     convert(varchar(100),a.FCREATEDATE,23) >= convert(varchar(100),DATEADD(day,-7,getdate()),23)
                                     convert(varchar(100),a.FCREATEDATE,23) >= convert(varchar(100),DATEADD(day,-1,getdate()),23)
                                     or
                                     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)
                                )";
                DataSet ds = oCN.RunProcReturn(sql, "" +  erpDatabaseName + @"T_BD_MATERIAL");
                if (ds != null && ds.Tables.Count > 0)