chilo5432's questions

我需要对我需要的对象进行排序并获取前 2 个元素和组。例如：

    CREATE TEMP TABLE signal_info
(
    id      INTEGER NOT NULL,
    signal  INTEGER NOT NULL,
    station CHAR(5) NOT NULL,
    ownerid INTEGER NOT NULL
);
INSERT INTO signal_info VALUES(111, 120, 'Home', 1);
INSERT INTO signal_info VALUES(111, 130, 'Car' , 1);
INSERT INTO signal_info VALUES(111, 135, 'Work', 2);
INSERT INTO signal_info VALUES(222, 98 , 'Home', 2);
INSERT INTO signal_info VALUES(222, 95 , 'Work', 1);
INSERT INTO signal_info VALUES(111, 140, 'Home', 1);
INSERT INTO signal_info VALUES(222, 160 , 'Work', 1);

SELECT station, count(station) as countStation, sum(Signal) as sum
            FROM signal_info
            where station in ('Home', 'Work')
            GROUP BY station

例如，我需要按最大信号排序并取前 2 个元素。需要得到： 工作 - 2 - 295 家庭 - 2 - 260

怎么做？我正在使用 SQL 服务器

我安装了 setup.msi 安装程序，我看到了将日志写入文件的选项，但我需要将日志输出到 StandardOutput？这是代码：

Process process = new Process();
        ProcessStartInfo processInfo = new ProcessStartInfo();
        processInfo.Arguments = $"/l \"Setup.msi\" /q";
        processInfo.FileName = "msiexec";

        processInfo.CreateNoWindow = true;
        processInfo.UseShellExecute = false;
        processInfo.RedirectStandardError = true;
        processInfo.RedirectStandardOutput = true;

        process.StartInfo = processInfo;
        process.Start();
        process.WaitForExit();

        var exitCode = process.ExitCode;
        string output = process.StandardOutput.ReadToEnd();
        string error = process.StandardError.ReadToEnd();

找到这个选项：

var dtCols = con.GetSchema("IndexColumns", new[] { con.Database, null, table });

您需要找到代表标识符 (Id) 的列的名称，上面的代码有助于执行此操作，但并非总是如此。即 index_name - 以“PK_{table name}”形式表示名称。但有些表有不同的名称，例如：PK_HangFire_CounterAggregated。哪里有一个非常不同的顺序，其中 HangFire 是 schema 而 table 是 AggregatedCounter 。问题是，PK总是添加到ID（PRIMARY KEY）还是有其他方法可以找到表ID？

我正在使用 MySql，试图在最佳分组中获得最佳值并返回整个对象，写道：

SELECT t.* 
FROM ( SELECT * 
       FROM trainingobjects 
       ORDER BY SameIndex desc) t 
GROUP BY t.ApplicationUserId 
order by t.SameIndex desc

我不明白为什么它返回的不是最好的结果，而是一个不同的结果。

我有 2 个和 3 个方程，它们可以有多个方程。如何找到多个根？

我知道用 sympy 可以做到这一点。但我不明白怎么做。

例如：我有几个公式：

5+x^2=y
y^2+x=3

你怎么能找到这个方程的所有根？

我正在构建 docker（从这里）更改网络以能够将容器连接到容器。但是由于某种原因，我无法从计算机连接到容器，并且容器无法连接：docker-compose：

version: '3.4'

services:
  webapi:
    image: ${DOCKER_REGISTRY-}webapi
    build:
      context: .
      dockerfile: WebApi/Dockerfile
    depends_on:
      - db  
ports:
  - "8000:80"     
expose:  
  - 80
  
  db:
    image: microsoft/mssql-server-linux:2017-latest
    container_name: webapisqldb
    environment:
        ACCEPT_EULA: Y
        SA_PASSWORD: "Bassword@123"
    ports:  
      - '1433:1433'  
    expose:  
      - 1433
    volumes:  
      - sql-data:/var/opt/mssql3  

volumes:
      sql-data:
networks:
  outside:
    external: true

码头工人：

FROM mcr.microsoft.com/dotnet/core/aspnet:3.0.0-preview7-buster-slim AS base
WORKDIR /app
EXPOSE 80

FROM mcr.microsoft.com/dotnet/core/sdk:3.0.100-preview7-buster AS build
WORKDIR /src
COPY ["WebApi/WebApi.csproj", "WebApi/"]
RUN dotnet restore "WebApi/WebApi.csproj"
COPY . .
WORKDIR "/src/WebApi"
RUN dotnet build "WebApi.csproj" -c Release -o /app

FROM build AS publish
RUN dotnet publish "WebApi.csproj" -c Release -o /app

FROM base AS final
WORKDIR /app
COPY --from=publish /app .
ENTRYPOINT ["dotnet", "WebApi.dll"]

有没有人有将 docker 与数据库连接并使一切正常的示例？

我按照说明将 swagger 连接到 asp.net，当我转到 swagger/v1/swagger.json 时，我用我的方法看到了 json。

public void ConfigureServices(IServiceCollection services)
    {

        services.AddControllersWithViews();
        services.AddSwaggerGen(c =>
        {
            c.SwaggerDoc("v1", new OpenApiInfo { Title = "My API", Version = "v1" });
        });

        services.AddSingleton<IUserService, UserService>();

        services.AddAuthentication(x =>
        {
            x.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme;
            x.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme;
        })
       .AddJwtBearer(x =>
       {
           x.RequireHttpsMetadata = false;
           x.SaveToken = true;
           x.TokenValidationParameters = new TokenValidationParameters
           {
               ValidateIssuerSigningKey = true,
               IssuerSigningKey = new SymmetricSecurityKey(Encoding.ASCII.GetBytes("**")),
               ValidateIssuer = false,
               ValidateAudience = false,
           };
       });

        services.AddMvcCore()
            .AddNewtonsoftJson();

    }

    public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
    {
        if (env.IsDevelopment())
        {
            app.UseDeveloperExceptionPage();
        }
        else
        {
            app.UseExceptionHandler("/Error");
            // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
            app.UseHsts();
        }

        app.UseHttpsRedirection();
        app.UseStaticFiles();
        app.UseSpaStaticFiles();

        app.UseRouting();

        app.UseSwagger();
        app.UseSwaggerUI(c =>
        {
            c.SwaggerEndpoint("/swagger/v1/swagger.json", "Test API V1");
            c.RoutePrefix = string.Empty;
        });


        app.UseCors(x => x
            .AllowAnyOrigin()
            .AllowAnyMethod()
            .AllowAnyHeader());

        app.UseAuthentication();
        app.UseAuthorization();


        app.UseEndpoints(endpoints =>
        {
            endpoints.MapControllerRoute(
                name: "default",
                pattern: "{controller}/{action=Index}/{id?}");
        });
    }

但是我怎样才能连接以便有一个 UI？而不仅仅是json？

当开始一个项目时，它说：

/.../library-0.88/res/values/values.xml:7:5-12:25: AAPT: error: duplicate value for resource 'attr/font' with config ''.

如何解决这个错误？

如何通过 jquery 在“Accept-Language”中设置语言？我通过“Accept-Language”定义语言。我正在尝试使所有请求都与对另一种语言的请求一起进行，但未设置标头。

<script>
var myHeaders = new Headers();
    myHeaders.set('Accept-Language', 'en-EN,');
    console.log(myHeaders.get('Accept-Language'))
</script>

LINQ 我有一个用户成功列表，模型：

{
"id",
"username",
"result"
}

如何使用 LINQ 表对列表进行排序，以便只显示用户的最佳结果？1 个用户只有 1 次

我正在尝试将 Moxy 与 androidX 连接，但它编写了重复的类：

Duplicate class com.arellomobile.mvp.DefaultView found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.DefaultViewState found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.InjectViewState found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.MvpDelegate found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.MvpFacade found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.MvpPresenter found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.MvpPresenter$Binder found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.MvpProcessor found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.MvpView found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.PresenterBinder found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.PresenterStore found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.PresentersCounter found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.RegisterMoxyReflectorPackages found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.ViewStateProvider found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.presenter.InjectPresenter found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.presenter.PresenterField found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.presenter.ProvidePresenter found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.presenter.ProvidePresenterTag found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.MvpViewState found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.ViewCommand found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.ViewCommands found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.AddToEndSingleStrategy found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.AddToEndStrategy found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.OneExecutionStateStrategy found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.SingleStateStrategy found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.SkipStrategy found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.StateStrategy found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)
Duplicate class com.arellomobile.mvp.viewstate.strategy.StateStrategyType found in modules moxy-1.5.6.jar (com.arello-mobile:moxy:1.5.6) and moxy-x-1.7.0.jar (tech.schoolhelper:moxy-x:1.7.0)

Go to the documentation to learn how to Fix dependency resolution errors.

依赖项：

implementation 'com.arello-mobile:moxy:1.5.6'
implementation 'tech.schoolhelper:moxy-x-androidx:1.7.0'
implementation 'tech.schoolhelper:moxy-x-material:1.7.0'
annotationProcessor 'com.github.moxy-community:moxy-compiler:2.0.2'

应该有哪些依赖？

我的 iPad 键盘上有一个发送按钮，但是当我按下它时没有任何反应。如何向此按钮添加侦听器？

我有几个 div，我需要通过函数更改 div 中的文本。 例子

$(this).text(id)

我正在尝试像这样更改代码。但它不起作用

我遍历每个元素，但由于某种原因，在添加 .is 后它会写一个错误：TypeError: j.is is not a function

代码链接：

$('input[name=chсl]').click(function () {
for(var i=0;i<$('input[name=chсl]').length;i++)
 {
  var j = $('input[name=chсl]')[i]
    alert(j.is(':checked') + " " + $('.ch-checkbox')[i].find('.count'));
  }
});

我将方程放入solve方法，该方法返回一个公式列表：

[-3.08250265220643 + 0.e-21*I, 0.204826458650812 - 0.366241504255597*I, 0.204826458650812 + 0.366241504255597*I, 1.21696879784 + 0.e-21*I]

我真的不明白如何从中获取我正在寻找的变量。您需要一个替换号才能在任何地方获得 0。或者它是如何工作的？

同情图书馆。我将一个带有一个未知数的方程放入方法中，我如何得到未知数？

方程看起来像：

(self.f+self.k)*self.s**4+4*(1-self.k*self.f)*self.s**3+2\
           *(self.k*self.f**2-3*self.f-2*self.k)*self.s**2+4*self.f*\
           (self.f+self.k)*self.s+self.f-self.k-2*self.k*self.f**2

未知 s.

k,s- 被进程中的数字代替

我正在尝试添加距离和方向以获得类向量：“Vector3”如何指定我理解的距离：Vector3 direction = new Vector3(0, Distation, 0); 以及如何指定角度，例如沿 Y？

如何正确填写表格？创建了自定义 IdentityUser，创建了 AccountDatabase.mdf，似乎我创建了正确的 IdentityDbContex（一切如下例所示）

public class ApplicationUser : IdentityUser
{
    [Display(Name="Full Name"),Required]
    public string FullName { get; set; }
    [Display(Name = "Rang"), Required]
    public string Rang { get; set; }

    public async Task<ClaimsIdentity> GenerateUserIdentityAsync(UserManager<ApplicationUser> manager)
    {
        // Обратите внимание, что authenticationType должен совпадать с типом, определенным в CookieAuthenticationOptions.AuthenticationType
        var userIdentity = await manager.CreateIdentityAsync(this, DefaultAuthenticationTypes.ApplicationCookie);
        // Здесь добавьте утверждения пользователя
        return userIdentity;
    }
}
public class AccountContext: IdentityDbContext<ApplicationUser>
{
    public AccountContext() : base("AccountDatabase")
    { }
    DbSet<ApplicationUser> ApplicationUsers { get; set; }
    DbSet<SettingModel> SettingModels { get; set; }
}

如何正确创建表 AccountDatabase？然后在创建新用户时它说：

Несколько наборов объектов на тип не поддерживаются. Наборы объектов "ApplicationUsers" и "Users" могут оба содержать экземпляры типа "ExampleCustomUserAndRole.Models.ApplicationUser".

如何让部分脚本在场景开始前通过？有必要在游戏开始时，通过在后台创建树的脚本部分。怎么做？

我有一个 Collider sphere，如何确保它不会自行释放，即当一个物体试图退出对撞机时，发生了碰撞？

我通过会话将对象传递给视图，我不知道如何在 jquery 中从中获取参数。在控制器中，我传递了对象：

Session["object"] = objectTR;//Некоторый объект

在表示中，我尝试从它接收参数。但它不起作用（

@model IEnumerable<...Models.TrainingObject>
TrainingObject traingObj = (TrainingObject)@HttpContext.Current.Session["object"];
traingObj.number;
traingObj["number"];

但仍然一切都是空的。如何从会话中的对象获取参数