From 31c1cc0e839b72c26c8aaa5a9a7b61b81ecf3307 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 23 十二月 2025 12:19:51 +0800
Subject: [PATCH] 修改采购申请付款,结账的不能申请

---
 CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs |   26 ++++++++++++++++++++++----
 1 files changed, 22 insertions(+), 4 deletions(-)

diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs
index 7f4b51f..4224dd9 100644
--- a/CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs
@@ -94,6 +94,20 @@
         }
 
 
+
+        /// <summary>
+        /// 鑾峰彇鍏ㄩ儴鍚堜綔瀹㈡埛
+        /// </summary>
+        /// <param name="Keyid">涓婚敭id</param>
+        /// <returns></returns>
+        public OA_Fukuanshenqing GetModelListByshifoushenqing(int keyid)
+        {
+            
+            return _IOA_FukuanshenqingDAL.GetModelListByshifoushenqing(keyid);
+        }
+
+
+
         /// <summary>
         /// 鏍规嵁formid鑾峰緱淇℃伅
         /// </summary>
@@ -140,7 +154,7 @@
         /// <param name="pa"></param>
         /// <returns></returns>
         public IEnumerable<OA_Fukuanshenqing> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
-   string Creater, string SupplierName,string shifoufukuan)
+   string Creater, string SupplierName,string shifoufukuan,string selFukuanyongtu)
         {
             string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 ";
 
@@ -154,9 +168,11 @@
                 Condition += " and  ok.Creater like '%" + Creater + "%'";
 
             if (!string.IsNullOrEmpty(SupplierName))
-                Condition += " and  oe.Name like '%" + SupplierName + "%'";
+                Condition += " and  ok.SupplierName like '%" + SupplierName + "%'    ";
             if (!string.IsNullOrEmpty(shifoufukuan))
                 Condition += " and  ok.FukuanStatus = '" + shifoufukuan + "'";
+            if (!string.IsNullOrEmpty(selFukuanyongtu))
+                Condition += " and  ok.[Fukuanyongtu] = '" + selFukuanyongtu + "'";
 
             Query query = new Query();
             IList<Criterion> criterias = new List<Criterion>()
@@ -176,7 +192,7 @@
         /// <param name="pa"></param>
         /// <returns></returns>
         public IEnumerable<OA_Fukuanshenqing> SelectModelPageweikaipiao(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
-   string Creater, string SupplierName, string shifoufukuan)
+   string Creater, string SupplierName, string shifoufukuan, string selFukuanyongtu)
         {
             string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 and ok.Youwufapiao !=2 and ok.FukuanStatus = 2 ";
 
@@ -190,9 +206,11 @@
                 Condition += " and  ok.Creater like '%" + Creater + "%'";
 
             if (!string.IsNullOrEmpty(SupplierName))
-                Condition += " and  oe.Name like '%" + SupplierName + "%'";
+                Condition += " and  ok.SupplierName like '%" + SupplierName + "%'    ";
             if (!string.IsNullOrEmpty(shifoufukuan))
                 Condition += " and  ok.FukuanStatus = '" + shifoufukuan + "'";
+            if (!string.IsNullOrEmpty(selFukuanyongtu))
+                Condition += " and  ok.[Fukuanyongtu] = '" + selFukuanyongtu + "'";
 
             Query query = new Query();
             IList<Criterion> criterias = new List<Criterion>()

--
Gitblit v1.9.1