From a7711b47c02807531f04313ae829584310f37aba Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 28 十一月 2025 12:17:10 +0800
Subject: [PATCH] 你们明天在那个公文管理公文管理那个操作操作界面增加一个审核, 好点审核呢,实际上是修改这个只有我才有一个权限, 只是只有我一个人,因为现在来看他们。相当于说, 没经过我审核,他们整些你看嘛,发你妈一些公文, 像狗屎一样,格式都不对头,在这儿乱在这儿乱写啊, 必须就是我,我审核,我点审核,你相就是复制一个修改过嘛, 相当于就是。好,必须是我,我点了审核好后头我修改好了, 提交好了才能发布。只要我没在审核里头的话,好,这个就发布不了 。好怀疑着呢,怀疑怀疑着来修改,还是在修改里头整?

---
 CY_ECommercePlatform/CY.SQLDAL/OA/OA_GoodsInfoDAL.cs |    8 ++++++--
 1 files changed, 6 insertions(+), 2 deletions(-)

diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_GoodsInfoDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_GoodsInfoDAL.cs
index aafa92a..d4e204e 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_GoodsInfoDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_GoodsInfoDAL.cs
@@ -153,7 +153,7 @@
             throw new NotImplementedException();
         }
 
-        public IEnumerable<Model.OA_GoodsInfo> SelectModelPage(Pagination pa, Guid FirmId, string GoodsName, string CommodityName)
+        public IEnumerable<Model.OA_GoodsInfo> SelectModelPage(Pagination pa, Guid FirmId, string GoodsName, string CommodityName ,string selGoodsStatus)
         {
 
             string Condition = " where a.FirmId='" + FirmId + "' ";
@@ -163,7 +163,11 @@
             }
             if (!string.IsNullOrEmpty(CommodityName))
             {
-                Condition += "  and e.CommodityName like '%" + CommodityName + "%' ";
+                Condition += "  and a.GoodsTypeId = " + CommodityName + " ";
+            }
+            if (!string.IsNullOrEmpty(selGoodsStatus))
+            {
+                Condition += "  and a.StatusId = " + selGoodsStatus + " ";
             }
             string selTarget = "a.* ,b.Name AS brandName,c.Name as SpecificationName,d.Name as  StatusName,e.CommodityName as CommodityName";
 

--
Gitblit v1.9.1