From 2cf0aaaca070d1423ab8412431690befef39fa89 Mon Sep 17 00:00:00 2001
From: yyk <2336760928@qq.com>
Date: 星期四, 29 八月 2024 11:49:30 +0800
Subject: [PATCH] 修改自动数据库链接，修改周期报表默认时间，修改年度报表显示不全问题。
---
Wms/WMS.BLL/DataServer/StockInfoServer.cs | 2 +-
Wms/Wms/appsettings.json | 2 +-
Wms/WMS.BLL/DataServer/StockServer.cs | 2 +-
3 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/Wms/WMS.BLL/DataServer/StockInfoServer.cs b/Wms/WMS.BLL/DataServer/StockInfoServer.cs
index 2514636..b340c3a 100644
--- a/Wms/WMS.BLL/DataServer/StockInfoServer.cs
+++ b/Wms/WMS.BLL/DataServer/StockInfoServer.cs
@@ -382,7 +382,7 @@
//楠岃瘉鏄惁瀛樺湪閫変腑鏃堕棿 涓嶅瓨鍦ㄥ垯璧嬪�间粖鏃ユ椂闂�
if (string.IsNullOrEmpty(StartDate))
{
- StartDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ff");
+ StartDate = DateTime.Now.ToString("yyyy-MM-dd");
}
//鏍规嵁鏃堕棿鑾峰彇瀵瑰簲鏃ユ湡鐨勫簱瀛樹俊鎭�
diff --git a/Wms/WMS.BLL/DataServer/StockServer.cs b/Wms/WMS.BLL/DataServer/StockServer.cs
index 6ee61f6..c891cd8 100644
--- a/Wms/WMS.BLL/DataServer/StockServer.cs
+++ b/Wms/WMS.BLL/DataServer/StockServer.cs
@@ -568,7 +568,7 @@
try
{
string str = "select* from SysMaterials where SkuNo in (select a.SkuNo from BllArrivalNoticeDetail a " +
- "inner join BllExportNoticeDetail b on a.SkuNo = b.SkuNo";
+ "left join BllExportNoticeDetail b on a.SkuNo = b.SkuNo";
//鍒ゆ柇寮�濮嬫椂闂存槸鍚︿负绌�
if (!string.IsNullOrWhiteSpace(StartTime))
diff --git a/Wms/Wms/appsettings.json b/Wms/Wms/appsettings.json
index 72dd5a9..b1357b1 100644
--- a/Wms/Wms/appsettings.json
+++ b/Wms/Wms/appsettings.json
@@ -47,7 +47,7 @@
},
"Quartz": {
"dbProviderName": "SqlServer",
- "connectionString": "Server=.;Database=QRTZ;User ID=sa;Password=sql2019;Integrated Security=False;"
+ "connectionString": "Server=192.168.62.200;Database=QRTZ;User ID=sa;Password=sql2019;Integrated Security=False;"
}
--
Gitblit v1.8.0