// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, OrderManagementDB DBContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseStaticFiles(); app.UseRouting(); app.UseHQMysqlDBContext(DBContext); ////启用授权服务 app.UseHQAuthorization(); //设置跨域 //app.UseCors(); app.UseCors("CorsPolicy"); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute( name: "default", pattern: "{controller=Authority}/{action=Index}/{upar1?}/{upar2?}/{upar3?}", new { area = "Authority" }); endpoints.MapControllerRoute( name: "areaDefault", pattern: "{area=Main}/{controller=Authority}/{action=Index}/{upar1?}/{upar2?}/{upar3?}"); }); }
public List <OrderManagementModel.DBModel.Authority.Authority_PermissionBase> GetPermissionList() { OrderManagementDB DBcontext = new OrderManagementDB(); var vl = DBcontext.Authority_PermissionBase.OrderByDescending(o => o.ID); return(vl.ToList()); }
public List <OrderManagementModel.DBModel.Authority.Authority_Account> GetAccountList() { OrderManagementDB DBcontext = new OrderManagementDB(); var vl = DBcontext.Authority_Account.OrderByDescending(o => o.ID); return(vl.ToList()); }
public HQResult <string> AddRole(string RoleName, string Description) { HQResult <string> result = new HQResult <string>(); OrderManagementDB DBcontext = new OrderManagementDB(); DBcontext.Authority_Role.Add(new Authority_Role { RoleName = RoleName, Description = Description }); DBcontext.SaveChanges(); return(result.SetResult(1, "ok")); }
public HQResult <string> AddAccount(string Account, string Name, string Pass) { HQResult <string> result = new HQResult <string>(); OrderManagementDB DBcontext = new OrderManagementDB(); DBcontext.Authority_Account.Add(new Authority_Account { Account = Account, Name = Name, Pass = Pass, }); DBcontext.SaveChanges(); return(result.SetResult(1, "ok")); }
public HQResult <string> RelatedPerBase(int RoleId, int BaseId) { HQResult <string> result = new HQResult <string>(); OrderManagementDB DBcontext = new OrderManagementDB(); DBcontext.Authority_RelatedRoleBasePer.Add(new OrderManagementModel.DBModel.Authority.Authority_RelatedRoleBasePer() { BasePerID = BaseId, RoleID = RoleId }); DBcontext.SaveChanges(); return(result.SetResult(1, "ok")); }
public HQResult <string> RelatedRole(int AccountId, int RoleId) { HQResult <string> result = new HQResult <string>(); OrderManagementDB DBcontext = new OrderManagementDB(); DBcontext.Authority_RelatedAccountRole.Add(new OrderManagementModel.DBModel.Authority.Authority_RelatedAccountRole() { AccountID = AccountId, RoleID = RoleId }); DBcontext.SaveChanges(); return(result.SetResult(1, "ok")); }
public PagingResult <Authority_PermissionBase> GetPaging(Authority_PermissionBaseWhere where) { PagingResult <Authority_PermissionBase> Result = new PagingResult <Authority_PermissionBase>(); OrderManagementDB DBcontext = new OrderManagementDB(); IQueryable <Authority_PermissionBase> Queryable; Queryable = DBcontext.Authority_PermissionBase .OrderByDescending(o => o.ID); if (where.ID > 0) { Queryable = Queryable.Where(w => w.ID == where.ID); } if (string.IsNullOrWhiteSpace(where.Action)) { Queryable = Queryable.Where(w => w.Action == where.Action); } if (string.IsNullOrWhiteSpace(where.Area)) { Queryable = Queryable.Where(w => w.Area == where.Area); } if (string.IsNullOrWhiteSpace(where.Control)) { Queryable = Queryable.Where(w => w.Control == where.Control); } if (string.IsNullOrWhiteSpace(where.Description)) { Queryable = Queryable.Where(w => w.Description.Contains(where.Description)); } if (where.PageIndex > 0 && where.PageCount > 0) { Queryable = DBcontext.Authority_PermissionBase.Skip((where.PageIndex - 1) * where.PageCount).Take(where.PageCount); } Result.list = Queryable.ToList(); return(Result); }
public HQResult <Authority_Account> Sigin(string Account, string Password) { HQResult <Authority_Account> result = new HQResult <Authority_Account>(); OrderManagementDB DBcontext = new OrderManagementDB(); var user = DBcontext.Authority_Account.Where(w => w.Account == Account && w.Pass == Password) .Include(p => p.RelatedRoles) .ThenInclude(p => p.Role) .ThenInclude(p => p.RelatedRoleBases) .ThenInclude(p => p.BasePer).FirstOrDefault(); if (user == null) { return(result.SetResult(-1, null)); } return(result.SetResult(1, "ok", user)); }
public List <OrderManagementModel.DBModel.Authority.Authority_Account> GetAccountWhere(AccountWhere where) { OrderManagementDB DBcontext = new OrderManagementDB(); //List<int> ids = new List<int>(); //ids.Add(1); //ids.Add(2); //ids.Add(3); //ids.Add(4); //ids.Add(5); //int[] idarray = new int[] { 1, 3, 5, 7, 9 }; //var test1 = DBcontext.Authority_Account.AsQueryable(); //var test2 = test1.Where(o => idarray.Contains(o.ID)); //var v3= test2.ToList(); var Queryable = DBcontext.Authority_Account.AsQueryable().GetWhere(new PageQueryParam <AccountWhere>(where)); return(Queryable.ToList()); }
/// <summary> /// 启用授权服务 /// 一定要放在 UseRouting 下面.放在UseEndpoints 上面.否则会影响系统正常运行. /// </summary> /// <param name="app"></param> /// <returns></returns> public static IApplicationBuilder UseHQMysqlDBContext(this IApplicationBuilder app, OrderManagementDB context) { context.Database.Migrate(); return(app); }