From b1ac791a0e8896ee3d2016949911d44c9f0fb7a9 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 16 三月 2026 13:17:23 +0800
Subject: [PATCH] 封面的构件选项修改为“封面、封内合拼、多单合拼、内页”，默认封面 选择了封面构件后，新增的内页构件中的选项该为“内页、多单合拼”， 默认内页 专版按以上 合版的选项中增加“无”，默认无 无”打印的时候为空白，不显示“无”字
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_SpecificationDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SpecificationDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SpecificationDAL.cs
index 2b14ea5..33e16c1 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SpecificationDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SpecificationDAL.cs
@@ -148,7 +148,7 @@
}
if (!string.IsNullOrEmpty(CommdityName))
{
- Condition += "and c.CommodityName like '%" + CommdityName + "%'";
+ Condition += "and a.GoodsTypeId = " + CommdityName + "";
}
string selectTarget = " t.GoodsId ,t.AorDerNum ";
string fromSource = "(select DISTINCT a.Keyid as GoodsId ,a.GoodsName as GoodsName,c.OrderNum AS AorDerNum,c.CommodityName as CommodityName from dbo.OA_GoodsInfo AS a INNER JOIN dbo.OA_Specification AS b ON a.Keyid=b.GoodsId LEFT JOIN dbo.OA_Commodity AS c ON a.GoodsTypeId= c.Keyid where " + Condition + ") as t";
--
Gitblit v1.9.1