From ef0360bd1befc35cc5af197a92ce462bad3af50f Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 18 9月 2025 18:30:01 +0800 Subject: [PATCH] 解决 时间格式不对的问题 --- siemenswmssditcode/wmsService/wcftest/wcf/apitest.cs | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/siemenswmssditcode/wmsService/wcftest/wcf/apitest.cs b/siemenswmssditcode/wmsService/wcftest/wcf/apitest.cs index d13c268..412f660 100644 --- a/siemenswmssditcode/wmsService/wcftest/wcf/apitest.cs +++ b/siemenswmssditcode/wmsService/wcftest/wcf/apitest.cs @@ -2673,7 +2673,7 @@ if (page.datatime.Length == 2) { - StockWhere = StockWhere + " and creatTime > '" + page.datatime[0].ToString() + "' and creatTime < '" + page.datatime[1].ToString() + "'"; + StockWhere = StockWhere + " and CreateTime > '" + page.datatime[0].ToString() + "' and CreateTime < '" + page.datatime[1].ToString() + "'"; } } @@ -3306,16 +3306,16 @@ /// <returns></returns> public string QueryPageDeviceGeneralInfo(string param) { - msgss<deviceGeneralInfo> msg = new msgss<deviceGeneralInfo>(); + msgss<deviceGeneralInfoForDetail> msg = new msgss<deviceGeneralInfoForDetail>(); DeviceGeneralInfoInput page = JsonConvert.DeserializeObject<DeviceGeneralInfoInput>(param); try { using (dbModel mod = new dbModel()) { - List<deviceGeneralInfo> fiveDayDeviceInfo = null; + List<deviceGeneralInfoForDetail> fiveDayDeviceInfo = null; if (page.datatime == null) { - fiveDayDeviceInfo = mod.deviceGeneralInfo + fiveDayDeviceInfo = mod.deviceGeneralInfoForDetail .OrderByDescending(x => x.createTime) .ToList(); } @@ -3323,7 +3323,7 @@ { DateTime _startTime = Convert.ToDateTime(page.datatime[0]); DateTime _endTime = Convert.ToDateTime(page.datatime[1]); - fiveDayDeviceInfo = mod.deviceGeneralInfo + fiveDayDeviceInfo = mod.deviceGeneralInfoForDetail .Where(x => x.createTime >= _startTime && x.createTime <= _endTime) .OrderByDescending(x => x.createTime) .ToList(); @@ -3338,7 +3338,7 @@ } } - List<deviceGeneralInfo> fenyeRerult = new List<deviceGeneralInfo>(); + List<deviceGeneralInfoForDetail> fenyeRerult = new List<deviceGeneralInfoForDetail>(); if (fiveDayDeviceInfo.Count > 0) { msg.status = 200; -- Gitblit v1.9.3