From 111fae25722710296a2ed9dce65dced57bb79419 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 25 三月 2025 08:43:25 +0800 Subject: [PATCH] 20250324 修改供应商名字不能重复 外协供应商对应 完成 --- 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