From 570a85557b7013df6bf82c4c324793d96a1b0dfb Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 10 10月 2025 13:32:39 +0800
Subject: [PATCH] 优化提示
---
DEmon/iWareLog/Report/Service/InOutService.cs | 44 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 42 insertions(+), 2 deletions(-)
diff --git a/DEmon/iWareLog/Report/Service/InOutService.cs b/DEmon/iWareLog/Report/Service/InOutService.cs
index ee41eb4..36635d0 100644
--- a/DEmon/iWareLog/Report/Service/InOutService.cs
+++ b/DEmon/iWareLog/Report/Service/InOutService.cs
@@ -51,7 +51,7 @@
{
string sql = @"select count(B.typename)quantity,B.typename materialcode from InOutStorageDetail A left join WGQ_WB19011_CORE.[dbo].[BASEMaterialView] B on A.materialid=B.id
where A.type=@p0 and A.updatetime>=@p1 and A.updatetime<@p2 group by B.typename";
- List<InOutHelper> data = context.Database.SqlQuery<InOutHelper>(sql,type, start, end).ToList();
+ List<InOutHelper> data = context.Database.SqlQuery<InOutHelper>(sql, type, start, end).ToList();
return data;
}
catch (Exception ex)
@@ -62,6 +62,46 @@
}
}
-
+
+ /// <summary>
+ /// 鏌ヨ鍑哄叆搴撴槑缁嗗強鐗╂枡淇℃伅锛堣仈鏌� InOutStorageDetail 鍜� BASEMaterialView锛�
+ /// </summary>
+ /// <returns>杩斿洖鍖呭惈鍨嬫潗缂栫爜銆佽埞鍙枫�佸垎娈靛彿銆佷笟鍔℃爣璇嗐�佸簱浣嶃�佹椂闂寸瓑淇℃伅鐨勫垪琛�</returns>
+ public List<InOutStorageDetailResultForMes> GetInOutStorageDetailListForMes()
+ {
+ using (DbModelLog context = new DbModelLog())
+ {
+ try
+ {
+ string sql = @"
+ SELECT
+ A.id AS Id,
+ B.code AS Code,
+ B.issueprojectno AS IssueProjectNo,
+ B.serialno AS SerialNo,
+ A.type AS BusinessFlag,
+ A.toplacecode AS PlaceCode,
+ A.createtime AS Timestamp,
+ A.createtime AS OccurrenceTime
+ FROM
+ InOutStorageDetail A
+ INNER JOIN
+ WGQ_WB19011_CORE.[dbo].[BASEMaterialView] B
+ ON A.materialid = B.id And A.isSendToMes=1 ";
+
+ // 鎵ц SQL 鏌ヨ锛屽苟鏄犲皠鍒拌嚜瀹氫箟绫� InOutStorageDetailResult
+ var data = context.Database.SqlQuery<InOutStorageDetailResultForMes>(sql).ToList();
+
+ return data;
+ }
+ catch (Exception ex)
+ {
+ // 璁板綍寮傚父鏃ュ織锛堝拰浣犲師鏈夋柟娉曚繚鎸佷竴鑷达級
+ LogTextHelper.WriteLine("InOutService", "GetInOutStorageDetailList", ex.ToString());
+ return null; // 鎴栬�呰繑鍥� new List<InOutStorageDetailResult>()锛屾牴鎹綘鐨勪笟鍔￠渶姹�
+ }
+ }
+ }
+
}
}
--
Gitblit v1.9.3