username@email.com
2 天以前 a001acc104e149c73f375638e1ba8224d0d28462
CY_ECommercePlatform/CY.SQLDAL/OA/OA_SuppliersDAL.cs
@@ -67,6 +67,9 @@
                    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) ,
                    new SqlParameter("@CreateTime",trueModel.CreateTime),
            };
            try
            {
@@ -126,6 +129,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
            {
@@ -231,7 +235,7 @@
          
            
            return _dataBase.SelectModelPage<Model.OA_Suppliers>(pa, selectTarget, fromSource, "a.OrderNum  ");
            return _dataBase.SelectModelPage<Model.OA_Suppliers>(pa, selectTarget, fromSource, "a.CreateTime desc  ");
        
        }
        /// <summary>
@@ -249,6 +253,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>