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 | 14 +++++++
CY_ECommercePlatform/CY.WebForm/Pages/business/Caigoufukuanshenqing.aspx.cs | 12 ++++++
CY_ECommercePlatform/CY.IDAL/OA/IOA_FukuanshenqingDAL.cs | 9 ++++
CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs | 35 +++++++++++++++++
4 files changed, 70 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_FukuanshenqingBLL.cs
index 18388a4..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>
diff --git a/CY_ECommercePlatform/CY.IDAL/OA/IOA_FukuanshenqingDAL.cs b/CY_ECommercePlatform/CY.IDAL/OA/IOA_FukuanshenqingDAL.cs
index ee196a5..5a3a03e 100644
--- a/CY_ECommercePlatform/CY.IDAL/OA/IOA_FukuanshenqingDAL.cs
+++ b/CY_ECommercePlatform/CY.IDAL/OA/IOA_FukuanshenqingDAL.cs
@@ -34,5 +34,14 @@
/// <param name="Keyid">缂栧彿</param>
/// <returns></returns>
int InserModelbackid(OA_Fukuanshenqing oA_Fukuanshenqing);
+
+
+
+ /// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ OA_Fukuanshenqing GetModelListByshifoushenqing(int keyid);
}
}
\ No newline at end of file
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs
index 2fd0b7a..80c06c9 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_FukuanshenqingDAL.cs
@@ -249,6 +249,41 @@
}
+
+
+ /// <summary>
+ /// 鏌ヨ鏄惁鐢宠浜嗕粯娆�
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public OA_Fukuanshenqing GetModelListByshifoushenqing(int keyid)
+ {
+ try
+ {
+ string condition = " ";
+ if (keyid > 0)
+ {
+ condition = " b.[ApprovalStatus] != 2 and ( a.DindanId = '" + keyid + "' or a.DindanId like CONCAT('%','," + keyid + ",','%') or a.DindanId like CONCAT('','" + keyid + ",','%') or a.DindanId like CONCAT('%','," + keyid + "','') ) ";
+ }
+ else
+ {
+ return null;
+ }
+
+ // return null;//閿欒鏁版嵁杩斾細绌�
+
+ IList<OA_Fukuanshenqing> result = _dataBase.SelectModel<OA_Fukuanshenqing>("a.*", " OA_Fukuanshenqing a inner join [OA_WorkPlan] b on CAST(a.[Keyid] AS varchar(50)) = b.[PlanComplany] and b.[PlanDataType] =16 ", condition) as IList<OA_Fukuanshenqing>;//鎵ц鏌ヨ
+
+ return (null == result || result.Count == 0) ? null : result[0];//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+
/// <summary>
/// 鍏ㄩ儴鏌ヨ
/// </summary>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/Caigoufukuanshenqing.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/Caigoufukuanshenqing.aspx.cs
index d5823cd..74feec1 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/Caigoufukuanshenqing.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/Caigoufukuanshenqing.aspx.cs
@@ -95,6 +95,18 @@
pa.PageSize = 1000;
pa.PageIndex = 1;
var models = _OA_ProcurementBLL.getModelList(pa, CurrentUser.MemberId,orderIdStr).ToList();
+
+
+ foreach (var oA_Procurement in models)
+ {
+ if(oA_Procurement.ClearingStatusId == 204)
+ {
+ JavaScript.MessageBox("鏈夐噰璐崟宸茬粡浠樻锛�", this,true,false);
+ return;
+ }
+ _oA_FukuanshenqingBLL.GetModelListByshifoushenqing(oA_Procurement.Keyid.Value);
+ }
+
if (models.Count > 0)
{
var sss = _OA_SuppliersBLL.getSingleSupplier(models[0].SuppliersId.Value.ToString());
--
Gitblit v1.9.1