提交

username@email.com

2025-05-15 6fe02a16e55f17e45a3997171e1b2284d45af25b

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs

@@ -67,6 +67,8 @@
                    new SqlParameter("@OrderNum",trueModel.OrderNum) ,
                        new SqlParameter("@Bank",string.IsNullOrEmpty(trueModel.Bank)?"":trueModel.Bank) ,
                    new SqlParameter("@AccountID",string.IsNullOrEmpty(trueModel.AccountID)?"":trueModel.AccountID) ,

                    new SqlParameter("@Huming",string.IsNullOrEmpty(trueModel.Huming)?"":trueModel.Huming) ,
            };
            try
            {
@@ -126,6 +128,7 @@
                    new SqlParameter("@OrderNum",trueModel.OrderNum)  ,
                        new SqlParameter("@Bank",string.IsNullOrEmpty(trueModel.Bank)?"":trueModel.Bank) ,
                    new SqlParameter("@AccountID",string.IsNullOrEmpty(trueModel.AccountID)?"":trueModel.AccountID) ,
                     new SqlParameter("@Huming",string.IsNullOrEmpty(trueModel.Huming)?"":trueModel.Huming) ,
            };
            try
            {
@@ -249,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>