From f782248da68c035aae12f902f29d828e9867abb0 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 29 9月 2025 12:45:51 +0800
Subject: [PATCH] 222
---
DEmon/iWareDataCore/BASE/Service/PlaceMaterialViewService.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/DEmon/iWareDataCore/BASE/Service/PlaceMaterialViewService.cs b/DEmon/iWareDataCore/BASE/Service/PlaceMaterialViewService.cs
index 729152b..5eb4d49 100644
--- a/DEmon/iWareDataCore/BASE/Service/PlaceMaterialViewService.cs
+++ b/DEmon/iWareDataCore/BASE/Service/PlaceMaterialViewService.cs
@@ -87,7 +87,8 @@
{
string sql = @"SELECT A.id, ISNULL(C.createtime,'1990-01-01') as createtime, ISNULL(C.updatetime,'1990-01-01') as updatetime, A.code AS placecode, A.status,
A.islock, A.isexecute, B.name as placetypename, B.remark as placetyperemark, D.name, D.code AS materialcode, D.description, D.typeremark, D.typename,
-ISNULL(D.status,0) AS materialstatus, A.id as placeid, ISNULL(C.materialid,0) as materialid, D.remark, A.layer, A.col, A.row, A.typeid as placetypeid
+ISNULL(D.status,0) AS materialstatus, A.id as placeid, ISNULL(C.materialid,0) as materialid, D.remark, A.layer, A.col, A.row, A.typeid as placetypeid,
+D.thick, D.wide, D.length,D.IssueProjectNo,D.ProcurementProjectNo,D.SerialNo,D.ClassificationSociety,D.CuttingType,D.Version
FROM dbo.BASEPlace AS A LEFT OUTER JOIN
dbo.BASEPlaceType AS B ON A.typeid = B.id LEFT OUTER JOIN
dbo.BASEPlaceMaterial as C on A.id=C.placeid LEFT OUTER JOIN
--
Gitblit v1.9.3