From 1b9037dc460ee7caed5954e3b935bf89f9e0524e Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 06 五月 2025 09:39:31 +0800
Subject: [PATCH] 三升小诸葛数据同步
---
WebAPI/Controllers/数据同步/小诸葛同步/XZG_DataSynchronizationController.cs | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git "a/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\345\260\217\350\257\270\350\221\233\345\220\214\346\255\245/XZG_DataSynchronizationController.cs" "b/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\345\260\217\350\257\270\350\221\233\345\220\214\346\255\245/XZG_DataSynchronizationController.cs"
index cb4da41..caf5a42 100644
--- "a/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\345\260\217\350\257\270\350\221\233\345\220\214\346\255\245/XZG_DataSynchronizationController.cs"
+++ "b/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\345\260\217\350\257\270\350\221\233\345\220\214\346\255\245/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)
--
Gitblit v1.9.1