duhe
2025-05-06 1b9037dc460ee7caed5954e3b935bf89f9e0524e
三升小诸葛数据同步
2个文件已修改
10 ■■■■■ 已修改文件
LMES/XiaoZhuGe_autoGetData.Designer.cs 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/数据同步/小诸葛同步/XZG_DataSynchronizationController.cs 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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)