提交

username@email.com

2025-05-15 6fe02a16e55f17e45a3997171e1b2284d45af25b

 CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs

@@ -64,7 +64,11 @@
               new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
               new SqlParameter("@Operator",trueModel.Operator),
               new SqlParameter("@Remark",trueModel.Remark) ,
                    new SqlParameter("@OrderNum",trueModel.OrderNum) 
                    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
            {
@@ -121,7 +125,10 @@
               new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
               new SqlParameter("@Operator",trueModel.Operator),
               new SqlParameter("@Remark",trueModel.Remark) ,
                    new SqlParameter("@OrderNum",trueModel.OrderNum) 
                    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
            {
@@ -245,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>