From a980cd04341d71216e0f59bd4b7327fe9fc50032 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 21 五月 2025 11:41:46 +0800 Subject: [PATCH] 提交 --- CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs index e8a0d05..1ab3933 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs @@ -252,6 +252,41 @@ /// <summary> + /// 杩斿洖table绫诲瀷鐨勬墍鏈夊垪琛� + /// </summary> + /// <param name="FirmId"></param> + /// <returns></returns> + public IEnumerable<Model.OA_Suppliers> getSupplierByFirmId(Guid FirmId, string Name) + { + try + { + if (FirmId == null || FirmId == Guid.Empty) + return null;//閿欒鏁版嵁杩斾細绌� + + string condition = " FirmId='" + FirmId + "' "; + + if (!string.IsNullOrEmpty(Name)) + { + condition += " and [Name]='" + Name + "' "; + } + + + IList<Model.OA_Suppliers> result = _dataBase.SelectModel<Model.OA_Suppliers>("*", "OA_Suppliers", condition) as IList<Model.OA_Suppliers>;//鎵ц鏌ヨ + + return result;//杩斿洖缁撴灉 + } + catch (Exception ex) + { + throw ex; + } + + } + + + + + + /// <summary> /// 鑾峰彇鍗曚釜渚涘簲鍟� /// </summary> /// <param name="Keyid"></param> -- Gitblit v1.9.1