From 50d433602441964d905abe6e516ad258ba66627d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 21 十一月 2025 12:06:16 +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