public SalePackageDomainModel GetSalePackageDomainModelByIdFromDatabase(string salePackageId) { if (salePackageId == null) { return(null); } SalePackageDomainModel result = null; SalesPackageInfoModel basicInfo = Retrieve(salePackageId); if (basicInfo != null) { string sql = "SELECT * FROM [product_sales_group_info] WHERE sale_package_id = $sale_package_id$"; ParameterCollection pc = new ParameterCollection(); pc.Add("sale_package_id", salePackageId); DataTable dt = ExecuteDataTable(sql, pc); if (dt != null && dt.Rows.Count > 0) { result = new SalePackageDomainModel(); result.BasicInfo = basicInfo; result.ProductCategoryList = ModelConvertFrom <ProductSalesGroupInfoModel>(dt, "product_category_id"); } } return(result); }
// 在此添加你的代码... public SalePackageDomainModel GetSalePackageDomainModelById(string salePackageId, bool clear) { if (string.IsNullOrEmpty(salePackageId)) { return(null); } string cacheKey = CacheKey.SALE_PACKAGE_DOMAINMODEL.GetKeyDefine(salePackageId); SalePackageDomainModel result = CacheUtil.Get <SalePackageDomainModel>(cacheKey); if (result == null || clear) { result = GetSalePackageDomainModelByIdFromDatabase(salePackageId); if (result != null) { CacheUtil.Set(cacheKey, result); } } return(result); }