Startup.cs 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ServiceModel;
  4. using Microsoft.AspNetCore.Builder;
  5. using Microsoft.AspNetCore.Hosting;
  6. using Microsoft.AspNetCore.Http;
  7. using Microsoft.AspNetCore.Http.Features;
  8. using Microsoft.AspNetCore.Rewrite;
  9. using Microsoft.AspNetCore.StaticFiles;
  10. using Microsoft.Extensions.Configuration;
  11. using Microsoft.Extensions.DependencyInjection;
  12. using Microsoft.Extensions.FileProviders;
  13. using Microsoft.Extensions.Hosting;
  14. using MySystem.PublicClass.GraphQL;
  15. using System.Text;
  16. using Microsoft.IdentityModel.Tokens;
  17. using System.Linq;
  18. using Microsoft.AspNetCore.Mvc.Razor;
  19. using Microsoft.AspNetCore.Server.Kestrel.Core;
  20. namespace MySystem
  21. {
  22. public class Startup
  23. {
  24. public Startup(IConfiguration configuration)
  25. {
  26. Configuration = configuration;
  27. }
  28. public IConfiguration Configuration { get; }
  29. // This method gets called by the runtime. Use this method to add services to the container.
  30. public void ConfigureServices(IServiceCollection services)
  31. {
  32. services.AddControllersWithViews();
  33. services.AddRouting(options =>
  34. {
  35. options.LowercaseUrls = true;
  36. });
  37. services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>();
  38. services.Configure<Setting>(Configuration.GetSection("Setting"));
  39. // services.AddCors(option => option.AddPolicy("cors", policy => policy.AllowAnyHeader().AllowAnyMethod().AllowCredentials().SetIsOriginAllowed(_ => true)));
  40. services.Configure<KestrelServerOptions>(x => x.AllowSynchronousIO = true).Configure<IISServerOptions>(x => x.AllowSynchronousIO = true);
  41. services.AddMvc(options =>
  42. {
  43. options.EnableEndpointRouting = false;
  44. options.Filters.Add(typeof(GlobalExceptions));
  45. });
  46. //配置模版视图路径
  47. services.Configure<RazorViewEngineOptions>(options =>
  48. {
  49. options.ViewLocationExpanders.Add(new TemplateViewLocationExpander());
  50. });
  51. services.AddSession(options =>
  52. {
  53. // 设置 Session 过期时间
  54. options.IdleTimeout = TimeSpan.FromDays(1);
  55. options.Cookie.HttpOnly = true;
  56. });
  57. services.AddSingleton<IRepository, Repository>();
  58. services.Configure<FormOptions>(x =>
  59. {
  60. x.MultipartBodyLengthLimit = 50 * 1024 * 1024;//不到300M
  61. });
  62. //生成密钥
  63. var symmetricKeyAsBase64 = Configuration["Setting:JwtSecret"];
  64. var keyByteArray = Encoding.ASCII.GetBytes(symmetricKeyAsBase64);
  65. var signingKey = new SymmetricSecurityKey(keyByteArray);
  66. //认证参数
  67. services.AddAuthentication("Bearer").AddJwtBearer(o =>
  68. {
  69. o.TokenValidationParameters = new TokenValidationParameters
  70. {
  71. ValidateIssuerSigningKey = true,//是否验证签名,不验证的画可以篡改数据,不安全
  72. IssuerSigningKey = signingKey,//解密的密钥
  73. ValidateIssuer = true,//是否验证发行人,就是验证载荷中的Iss是否对应ValidIssuer参数
  74. // ValidIssuer = Configuration["Setting:JwtIss"],//发行人
  75. IssuerValidator = (m, n, z) =>
  76. {
  77. return n.Issuer;
  78. },
  79. ValidateAudience = true,//是否验证订阅人,就是验证载荷中的Aud是否对应ValidAudience参数
  80. // ValidAudience = Configuration["Setting:JwtAud"],//订阅人
  81. AudienceValidator = (m, n, z) =>
  82. {
  83. string check = RedisDbconn.Instance.Get<string>("utoken:" + n.Issuer);
  84. return m != null && m.FirstOrDefault().Equals(check);
  85. },
  86. ValidateLifetime = true,//是否验证过期时间,过期了就拒绝访问
  87. ClockSkew = TimeSpan.Zero,//这个是缓冲过期时间,也就是说,即使我们配置了过期时间,这里也要考虑进去,过期时间+缓冲,默认好像是7分钟,你可以直接设置为0
  88. RequireExpirationTime = true,
  89. };
  90. });
  91. MySystemLib.SystemPublicFuction.appcheck = "success";
  92. RedisDbconn.csredis = new CSRedis.CSRedisClient(Configuration["Setting:RedisConnStr"]);
  93. }
  94. // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
  95. public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
  96. {
  97. if (env.IsDevelopment())
  98. {
  99. app.UseDeveloperExceptionPage();
  100. Library.ConfigurationManager.EnvironmentFlag = 1;
  101. }
  102. else
  103. {
  104. app.UseHsts();
  105. Library.ConfigurationManager.EnvironmentFlag = 2;
  106. }
  107. Library.function.WritePage("/", "WebRootPath.txt", env.WebRootPath);
  108. app.UseStaticFiles();
  109. app.UseStaticFiles(new StaticFileOptions
  110. {
  111. ContentTypeProvider = new FileExtensionContentTypeProvider(new Dictionary<string, string>
  112. {
  113. { ".apk", "application/vnd.android.package-archive" },
  114. { ".xlsx", "application/vnd.ms-excel" },
  115. { ".pag", "application/octet-stream" },
  116. { ".mp3", "audio/mpeg3" }
  117. })
  118. });
  119. app.UseCors("cors");
  120. app.UseAuthentication();
  121. app.UseRouting();
  122. app.UseAuthorization();
  123. app.UseSession();
  124. app.UseEndpoints(endpoints =>
  125. {
  126. endpoints.MapControllerRoute(
  127. name: "default",
  128. pattern: "{controller=Home}/{action=Index}/{Id?}");
  129. });
  130. initBsServer();
  131. }
  132. //初始化数据结构
  133. private void initBsServer()
  134. {
  135. Dictionary<string, Dictionary<string, string>> tables = new Dictionary<string, Dictionary<string, string>>();
  136. string connstr = Configuration["Setting:BsSqlConnStr"];
  137. System.Data.DataTable tablecollection = Library.CustomerSqlConn.dtable("select DISTINCT TABLE_NAME from information_schema.columns where table_schema = 'CybSystemServer'", connstr);
  138. foreach (System.Data.DataRow subtable in tablecollection.Rows)
  139. {
  140. Dictionary<string, string> Columns = new Dictionary<string, string>();
  141. System.Data.DataTable columncollection = Library.CustomerSqlConn.dtable("select COLUMN_NAME,DATA_TYPE from information_schema.columns where table_schema = 'CybSystemServer' and TABLE_NAME='" + subtable["TABLE_NAME"].ToString() + "'", connstr);
  142. foreach (System.Data.DataRow column in columncollection.Rows)
  143. {
  144. string datatype = column["DATA_TYPE"].ToString();
  145. if (datatype == "decimal")
  146. {
  147. datatype = "numeric";
  148. }
  149. Columns.Add(column["COLUMN_NAME"].ToString(), datatype);
  150. }
  151. tables.Add(subtable["TABLE_NAME"].ToString(), Columns);
  152. }
  153. PublicFunction.BsTables = tables;
  154. }
  155. }
  156. }