FiolDoll's questions

控制台将通过命令打开ping ...。几秒钟后（完成时），所需的结果到达 resultText 中。完整结果。如何使变量随着字符串的每次新出现而改变resultat？

Ps 特别是，您需要ping ... -t. 由于显而易见的原因，绝对没有显示任何内容。

        private void OpenProcces() // Открытие консоли
        {
            resultat = "";
            PSI.RedirectStandardOutput = true;
            PSI.UseShellExecute = false;
            PSI.CreateNoWindow = true;
            Process proc = new Process();
            proc.StartInfo = PSI;
            proc.Start();
            var stream = proc.StandardOutput.BaseStream;
            using (var reader = new StreamReader(stream, Encoding.GetEncoding(866))) // Чтение
            {
                resultat = reader.ReadToEnd();
                Console.WriteLine(resultat);
                if (InvokeRequired)
                {
                    Invoke((MethodInvoker)(() =>
                    {
                        UpdateResultat(resultat);
                    }
                    ));
                }
                else
                    UpdateResultat(resultat);      
            }
        }

        void UpdateResultat(string res) => resultText.Text = res; // Текст в потоке

        private void buttonActivate_Click(object sender, EventArgs e)
        {
            resultText.Text = "";
            for (int i = 0; i < buttonsInScene.buttons.Count; i++)
            {
                if (totalAction == buttonsInScene.buttons[i].name)
                {
                    if (buttonsInScene.buttons[i].command == "cmd")
                    {
                        try
                        {
                            PSI = new ProcessStartInfo("cmd", $@"/c {buttonsInScene.buttons[i].action} {textBoxInfo.Text}"); // Создание процесса

                            Thread thread1 = new Thread(OpenProcces); // Создание потока
                            thread1.Start();
                        }
                        catch (Exception objException)
                        {
                            Console.WriteLine(objException.Message);
                        }
                        break;
                    }
                }
            }
        }

我的数据库中有一个包含字典的 TEXT 列。问题是 - 如何从那里提取所有元素？

cur.execute("""CREATE TABLE IF NOT EXISTS info (
    id INT,
    cards TEXT,
    wins INT,
    defeat INT,
    duel TEXT
)""")
con.commit()
...
cur.execute(f"""INSERT INTO info (id, cards, wins, defeat, duel) VALUES ({member.id}, '[]', 0, 0, Null)""")
...
test = cur.execute(f"""SELECT cards FROM info WHERE id = {ctx.author.id}""").fetchone()[0]
print(test) #["", "", ""]

我有一个显示某些文本的代码。如果玩家不在房间内，则写入“???”。

如何优化？

else if (item == "bathroom" && PlayerPrefs.GetInt("bathroomOpenTime") == 1){_textInfo.text = "Войти в ванную";}
else if (item == "bathroom" && PlayerPrefs.GetInt("bathroomOpenTime") == 0){_textInfo.text = "???";}

else if (item == "bedroom" && PlayerPrefs.GetInt("bedroomOpenTime") == 1){_textInfo.text = "Войти в спальню";}      
else if (item == "bedroom" && PlayerPrefs.GetInt("bedroomOpenTime") == 0){_textInfo.text = "???";}      

else if (item == "kitchen" && PlayerPrefs.GetInt("kitchenOpenTime") == 1){_textInfo.text = "Войти на кухню";} 
else if (item == "kitchen" && PlayerPrefs.GetInt("kitchenOpenTime") == 0){_textInfo.text = "???";} 

else if (item == "basement" && PlayerPrefs.GetInt("basementOpen") == 0){_textInfo.text = "???";}
else if (item == "basement" && PlayerPrefs.GetInt("basementOpen") == 1){_textInfo.text = "Войти в подвал";}

我有 10 个按钮。单击每个更改文本。问题是，是否有可能以某种方式减少函数和行数？

我的代码：

    public void PreceptView()
    {
        PreceptViewManager("Заповедь №1\nСатана олицетворяет потворство, а не в-здержание!");
    }
    public void PreceptView1()
    {
        PreceptViewManager("За-ВедЬ №2\nСатана оли-цеоотворяет жизненную суть вместо несбыточных духовных мечтаний.");
    }
    public void PreceptView2()
    {
        PreceptViewManager("Заповedь №3\nSatan олицетворяет неOsквернённую мудрость вместо лицемерного самообмана!");
    }
...

我正在用 C# 学习 SQLite 数据库。我需要帮助。如何进行检查 - 当没有列时（例如， with login，然后 output label1.text = "Такого пользователь нету!"）

        public Form1()
        {
            InitializeComponent();
            if (!File.Exists(@"F:\c#Learn\DataBaseAndUILearn\logining\login\login\logins.db"))
            {
                SQLiteConnection.CreateFile(@"F:\c#Learn\DataBaseAndUILearn\logining\login\login\logins.db");
            }
            using (SQLiteConnection Connect = new SQLiteConnection(@"Data Source = F:\c#Learn\DataBaseAndUILearn\logining\login\login\logins.db"))
            {
                string commandDb = "CREATE TABLE IF NOT EXISTS [user](" +
                    "[login] TEXT," +
                    "[password] TEXT)";
                SQLiteCommand command = new SQLiteCommand(commandDb, Connect);
                command.Connection.Open();
                command.ExecuteNonQuery();
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string logins = $"SELECT [login] FROM [user] WHERE [login] = '{loginInput.Text}'";
            using (SQLiteConnection Connect = new SQLiteConnection(@"Data Source = F:\c#Learn\DataBaseAndUILearn\logining\login\login\logins.db"))
            {
                SQLiteCommand command = new SQLiteCommand(logins, Connect);
                command.Connection.Open();
                SQLiteDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    label1.Text = "Добро пожаловать," + reader.GetString(0);
                }
            }
        }

UPD

        private void button1_Click(object sender, EventArgs e)
        {
            string logins = $"SELECT [login] FROM [user] WHERE [login] = '{loginInput.Text}'";
            using (SQLiteConnection Connect = new SQLiteConnection(@"Data Source = F:\c#Learn\DataBaseAndUILearn\logining\login\login\logins.db"))
            {
                SQLiteCommand command = new SQLiteCommand(logins, Connect);
                command.Connection.Open();
                SQLiteDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    string userName = reader.GetString(0);
                    label1.Text = userName;
                    if (userName == null)
                    {
                        label1.Text = "test";
                    }
                    else
                    {
                        label1.Text = "Добро пожаловать," + reader.GetString(0);
                    }
                }
            }
        }