20250324 修改供应商名字不能重复 外协供应商对应 完成

username@email.com

2025-03-25 111fae25722710296a2ed9dce65dced57bb79419

 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>