网站图片优化器,电脑系统重装wordpress,简单网站如何制作,中国最大的网站建设整个解决方案按照分层思想来划分不同功能模块#xff0c;以提供User服务的Api为需求#xff0c;各个层次的具体实现如下所示#xff1a;
1、新建数据库User表
数据库使用SQLExpress版本#xff0c;表的定义如下所示#xff1a;
CREATE TABLE [dbo].[User] ([Id] …整个解决方案按照分层思想来划分不同功能模块以提供User服务的Api为需求各个层次的具体实现如下所示
1、新建数据库User表
数据库使用SQLExpress版本表的定义如下所示
CREATE TABLE [dbo].[User] ([Id] INT IDENTITY (1, 1) NOT NULL,[Name] NVARCHAR (50) NOT NULL,[Password] NVARCHAR (50) NOT NULL,[Age] INT NOT NULL,[Birthdate] DATE NOT NULL,[CreateTime] DATETIME DEFAULT (getdate()) NOT NULL,[CreateUserId] NVARCHAR (50) NOT NULL,[CreateUserName] NVARCHAR (50) NOT NULL,[ModifiedTime] DATETIME NULL,[ModifiedUserId] NVARCHAR (50) NULL,[ModifiedUserName] NVARCHAR (50) NULL,PRIMARY KEY CLUSTERED ([Id] ASC)
);
2、实体层
新建类库类型的项目.net framework框架版本4.5User实体类如下
public class User{public int Id { get; set; }public string Name { get; set; }public string Password { get; set; }public int Age { get; set; }public DateTime Birthdate { get; set; }public DateTime CreateTime { get; set; }public string CreateUserId { get; set; }public string CreateUserName { get; set; }public DateTime? ModifiedTime { get; set; }public string ModifiedUserId { get; set; }public string ModifiedUserName { get; set; }}
3、数据库层
该层提供数据库接口操作采用EntitFramework4.4.0.0作为ORM实体映射框架
定义数据库操作接口IRepository
public interface IRepositoryTEntity : IDisposable where TEntity : class{IEnumerableTEntity Get();IEnumerableTEntity Get(ExpressionFuncTEntity, bool filter);IEnumerableTEntity GetTOderKey(ExpressionFuncTEntity, bool filter, int pageIndex, int pageSize, ExpressionFuncTEntity, TOderKey sortKeySelector, bool isAsc true);int Count(ExpressionFuncTEntity, bool predicate);void Update(TEntity instance);void Add(TEntity instance);void Delete(TEntity instance);}
定义数据库上下文类BceDbContext
public class BceDbContext:DbContext{public BceDbContext():base(DaLeiDB){Database.SetInitializerAceDbContext(null);}public DbSetUser Users { get; set; }protected override void OnModelCreating(DbModelBuilder modelBuilder){modelBuilder.EntityUser().ToTable(User);base.OnModelCreating(modelBuilder);}}
定义数据库通用操作实现类BceRepository
public class BceRepositoryTEntity : IRepositoryTEntity where TEntity : class{public BceDbContext DbContext { get; private set; }public DbSetTEntity DbSet { get; private set; }public BceRepository(BceDbContext context){Guard.ArgumentNotNull(context, context);this.DbContext context;this.DbSet this.DbContext.SetTEntity();}public IEnumerableTEntity Get(){return this.DbSet.AsQueryable();}public IEnumerableTEntity Get(ExpressionFuncTEntity, bool filter){return this.DbSet.Where(filter).AsQueryable();}public IEnumerableTEntity GetTKey(ExpressionFuncTEntity, bool filter, int pageIndex, int pageSize, ExpressionFuncTEntity, TKey sortKeySelector, bool isAsc true){Guard.ArgumentNotNull(filter, predicate);Guard.ArgumentNotNull(sortKeySelector, sortKeySelector);if (isAsc){return this.DbSet.Where(filter).OrderBy(sortKeySelector).Skip(pageSize * (pageIndex - 1)).Take(pageSize).AsQueryable();}else{return this.DbSet.Where(filter).OrderByDescending(sortKeySelector).Skip(pageSize * (pageIndex - 1)).Take(pageSize).AsQueryable();}}public int Count(ExpressionFuncTEntity, bool predicate){return this.DbSet.Where(predicate).Count();}public void Add(TEntity instance){Guard.ArgumentNotNull(instance, instance);this.DbSet.Attach(instance);this.DbContext.Entry(instance).State EntityState.Added;this.DbContext.SaveChanges();}public void Update(TEntity instance){Guard.ArgumentNotNull(instance, instance);this.DbSet.Attach(instance);this.DbContext.Entry(instance).State EntityState.Modified;this.DbContext.SaveChanges();}public void Delete(TEntity instance){Guard.ArgumentNotNull(instance, instance);this.DbSet.Attach(instance);this.DbContext.Entry(instance).State EntityState.Deleted;this.DbContext.SaveChanges();}public void Dispose(){this.DbContext.Dispose();}}
定义用户表数据库操作额外的接口IUserRepository
namespace DaLei.Repository
{public interface IUserRepository{User FindByName(string name);ListUser FindByAge(int start, int end);}
}
定义用户表数据库操作额外的实现类UserRepository namespace DaLei.Repository
{public class UserRepository : BceRepositoryUser, IUserRepository{public UserRepository(BceDbContext bceDbContext):base(bceDbContext){}public ListUser FindByAge(int start, int end){var rst this.DbSet.AsQueryable().Where(uu.Agestart u.Ageend).ToList();return rst;}public User FindByName(string name){var rst this.DbSet.AsQueryable().Where(u u.Name name).FirstOrDefault();return rst;}}
}
4、服务接口层
定义了对外提供用户服务的接口契约具体如下
namespace DaLei.IService
{public interface IUserService{User FindByName(string name);ListUser FindByAge(int start, int end);ListUser GetList();}
}
5、服务具体实现层
服务基类实现
using System;
using System.Collections.Generic;namespace DaLei.Service
{public abstract class ServiceBase : IDisposable{public IListIDisposable DisposableObjects { get; private set; }public ServiceBase(){this.DisposableObjects new ListIDisposable();}protected void AddDisposableObject(object obj){IDisposable disposable obj as IDisposable;if (null ! disposable){this.DisposableObjects.Add(disposable);}}public void Dispose(){foreach (IDisposable obj in this.DisposableObjects){if (null ! obj){obj.Dispose();}}}}
}
用户服务接口具体实现
using DaLei.IService;
using DaLei.Model;
using DaLei.Repository;
using System.Collections.Generic;namespace DaLei.Service
{public class UserService : ServiceBase,IUserService{private IUserRepository userRepository;public UserService(IUserRepository userRepository){this.userRepository userRepository;this.AddDisposableObject(userRepository);}public ListUser FindByAge(int start, int end){return this.userRepository.FindByAge(start,end);}public User FindByName(string name){return this.userRepository.FindByName(name);}public ListUser GetList(){return this.userRepository.FindByAge(0, 100);}}
}6、应用层
新建Asp.net WebApi项目引用服务接口项目、服务实现项目、实体类项目unity相关程序集EntityFramework程序集。 web.config配置连接字符串和unity相关内容
?xml version1.0 encodingutf-8?
!--有关如何配置 ASP.NET 应用程序的详细信息请访问https://go.microsoft.com/fwlink/?LinkId169433
--
configurationconfigSectionssection nameunity typeMicrosoft.Practices.Unity.Configuration.UnityConfigurationSection, Microsoft.Practices.Unity.Configuration //configSectionsunitysectionExtension typeMicrosoft.Practices.Unity.InterceptionExtension.Configuration.InterceptionConfigurationExtension, Microsoft.Practices.Unity.Interception.Configuration /containerscontainerextension typeInterception /register typeDaLei.IService.IUserService, DaLei.IService mapToDaLei.Service.UserService, DaLei.Service /register typeDaLei.Repository.IUserRepository, DaLei.Repository mapToDaLei.Repository.UserRepository, DaLei.Repositoryinterceptor typeInterfaceInterceptor /policyInjection //register/container/containers/unityconnectionStringsadd nameDaLeiDB connectionStringdata source.\SQLEXPRESS;Integrated SecuritySSPI;Initial CatalogDaleiDB;User IDsa;Passwordanpiel0991; providerNameSystem.Data.SqlClient //connectionStringsappSettingsadd keywebpages:Version value3.0.0.0/add keywebpages:Enabled valuefalse/add keyPreserveLoginUrl valuetrue/add keyClientValidationEnabled valuetrue/add keyUnobtrusiveJavaScriptEnabled valuetrue//appSettingssystem.webcompilation debugtrue targetFramework4.5/httpRuntime targetFramework4.5/pagesnamespacesadd namespaceSystem.Web.Helpers/add namespaceSystem.Web.Mvc/add namespaceSystem.Web.Mvc.Ajax/add namespaceSystem.Web.Mvc.Html/add namespaceSystem.Web.Routing/add namespaceSystem.Web.WebPages//namespaces /pages/system.websystem.webServervalidation validateIntegratedModeConfigurationfalse/handlersremove nameExtensionlessUrlHandler-Integrated-4.0/remove nameOPTIONSVerbHandler/remove nameTRACEVerbHandler/add nameExtensionlessUrlHandler-Integrated-4.0 path*. verb* typeSystem.Web.Handlers.TransferRequestHandlerpreConditionintegratedMode,runtimeVersionv4.0//handlers/system.webServerruntimeassemblyBinding xmlnsurn:schemas-microsoft-com:asm.v1dependentAssemblyassemblyIdentity nameNewtonsoft.Json cultureneutral publicKeyToken30ad4fe6b2a6aeed/bindingRedirect oldVersion0.0.0.0-11.0.0.0 newVersion11.0.0.0//dependentAssemblydependentAssemblyassemblyIdentity nameSystem.Web.Helpers publicKeyToken31bf3856ad364e35/bindingRedirect oldVersion1.0.0.0-3.0.0.0 newVersion3.0.0.0//dependentAssemblydependentAssemblyassemblyIdentity nameSystem.Web.Mvc publicKeyToken31bf3856ad364e35/bindingRedirect oldVersion1.0.0.0-5.2.7.0 newVersion5.2.7.0//dependentAssemblydependentAssemblyassemblyIdentity nameSystem.Web.Optimization publicKeyToken31bf3856ad364e35/bindingRedirect oldVersion1.0.0.0-1.1.0.0 newVersion1.1.0.0//dependentAssemblydependentAssemblyassemblyIdentity nameSystem.Web.WebPages publicKeyToken31bf3856ad364e35/bindingRedirect oldVersion1.0.0.0-3.0.0.0 newVersion3.0.0.0//dependentAssemblydependentAssemblyassemblyIdentity nameWebGrease publicKeyToken31bf3856ad364e35/bindingRedirect oldVersion0.0.0.0-1.6.5135.21930 newVersion1.6.5135.21930//dependentAssembly/assemblyBinding/runtimesystem.codedomcompilerscompiler languagec#;cs;csharp extension.cstypeMicrosoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version2.0.0.0, Cultureneutral, PublicKeyToken31bf3856ad364e35warningLevel4 compilerOptions/langversion:6 /nowarn:1659;1699;1701/compiler languagevb;vbs;visualbasic;vbscript extension.vbtypeMicrosoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version2.0.0.0, Cultureneutral, PublicKeyToken31bf3856ad364e35warningLevel4 compilerOptions/langversion:14 /nowarn:41008 /define:_MYTYPE\quot;Web\quot; /optionInfer//compilers/system.codedom
/configuration
Controller实例化由Unity负责处理需要实现控制器工厂类
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Routing;
using Microsoft.Practices.Unity;
using Microsoft.Practices.Unity.Configuration;
using System.Configuration;namespace WebApi.Extensions
{public class UnityControllerFactory : DefaultControllerFactory{static object syncHelper new object();static Dictionarystring, IUnityContainer containers new Dictionarystring, IUnityContainer();public IUnityContainer UnityContainer { get; private set; }public UnityControllerFactory(string containerName ){if (containers.ContainsKey(containerName)){this.UnityContainer containers[containerName];return;}lock (syncHelper){if (containers.ContainsKey(containerName)){this.UnityContainer containers[containerName];return;}IUnityContainer container new UnityContainer();//配置UnityContainerUnityConfigurationSection configSection ConfigurationManager.GetSection(UnityConfigurationSection.SectionName) as UnityConfigurationSection;if (null configSection !string.IsNullOrEmpty(containerName)){throw new ConfigurationErrorsException(The unity configuration section does not exist.);}if (null ! configSection){if (string.IsNullOrEmpty(containerName)){configSection.Configure(container);}else{configSection.Configure(container, containerName);}}containers.Add(containerName, container);this.UnityContainer containers[containerName];}}protected override IController GetControllerInstance(RequestContext requestContext, Type controllerType){if (null controllerType){return null;}return (IController)this.UnityContainer.Resolve(controllerType);}
//public override void ReleaseController(IController controller)
//{
// this.UnityContainer.Teardown(controller);
//}}
}
设置MVC框架的控制器工厂为自定义类型
using webApi.Extensions;
using System;
using System.Web;
using System.Web.Http;
using System.Web.Mvc;
using System.Web.Routing;namespace WebApp
{public class Global : HttpApplication{void Application_Start(object sender, EventArgs e){// 在应用程序启动时运行的代码AreaRegistration.RegisterAllAreas();GlobalConfiguration.Configure(WebApiConfig.Register);RouteConfig.RegisterRoutes(RouteTable.Routes);ControllerBuilder.Current.SetControllerFactory(new UnityControllerFactory());}}
}
新建Controller基类所有的自定义Controller均继承此类
using WebApi.Extensions;
using System.Web.Mvc;
using System;
using System.Collections.Generic;namespace WebApp.Controllers
{public class BaseController:Controller{public IListIDisposable DisposableObjects { get; private set; }public BaseController(){this.DisposableObjects new ListIDisposable();}protected void AddDisposableObject(object obj){IDisposable disposable obj as IDisposable;if (null ! disposable){this.DisposableObjects.Add(disposable);}}protected override void Dispose(bool disposing){if (disposing){foreach (IDisposable obj in this.DisposableObjects){if (null ! obj){obj.Dispose();}}}base.Dispose(disposing);}}
}
新建测试Controller
using DaLei.IService;
using System.Web.Mvc;namespace WebApp.Controllers
{public class TestController : BaseController{private IUserService userService;public TestController(IUserService userService){this.userService userService;this.AddDisposableObject(userService);}// GET: Testpublic ActionResult Index(){var users this.userService.GetList();return View();}}
}
浏览器输入地址测试TestController
