YoFi's questions

如何检查文件是否被选中？

private void BrowseFilesButton_Click(object sender, RoutedEventArgs e)
        {
            var ofd = new OpenFileDialog {Multiselect = true};
            ofd.ShowDialog();
            ViewModel.ChoosenFiles = ofd.FileNames;
            FileBox.Text = $"Selected {ofd.FileNames.Length} scripts";
        }

        private void ExecFilesButton_Click(object sender, RoutedEventArgs e)
        {   
            List<Script> scriptToRun = ViewModel.ChoosenFiles.Select(item => new Script(item)).ToList();

            SetProgressBar(scriptToRun.Count);
            var runner = new Runner(ViewModel.SelectedConnection);
            runner.RunQueries(scriptToRun, UpdateProgressBar());

            MessageBox.Show("ok");
        }

如何传值List<string> scriptsToRun给另一个类（给方法runQueries）？

从这里：

private void ExecAllSkrypty_Click(object sender, EventArgs e)
        {
            string[] dir = Directory.GetFiles(skryptyDirBox.Text);

            List<string> scriptsToRun = new List<string>();

            foreach (var item in dir)
            {
                string query = File.ReadAllText(item);
                var fileName = Path.GetFileName(item);
                scriptsToRun.Add(fileName);
            }
            GetRunner().runQueries(fileName, query);
        }

这里：

public void runQueries(string sName, string query)
        {
            using (var c = new Context(connection,true))
            {
                var scriptRunned = c.Scripts.Where(x => scriptsToRun.Contains(x.ScriptName)).Select(s => s.ScriptName).ToList();

                scriptsToRun.RemoveAll(s => scriptRunned.Contains(s));

                foreach (var sname in scriptRunned)
                {
                    //read the file sname
                    Insertquery(sname,query);
                }
            }
        }

如何使用所需模式向数据库添加条目？求问题。如果你没有指定模式名称，那么它会写入公共，如果我指定那么我会得到一个错误。

public void insertquery(string sName)
        {
            command.CommandText = $"INSERT INTO rpsql.s_test(script_name) values ('{sName}')";
            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
        }

Form1 http://i12.pixs.ru/storage/0/5/2/form1jpg_4473358_24731052.jpg Form1 http://i12.pixs.ru/storage/0/7/1/form2jpg_1765146_24731071.jpg

如何将名称为 Name(TextBox) 的第二种形式的 TexBox 中输入的值保存在 ComboBox 中。以及如何在从 ComboBox 中进行选择时，将这些值传递给 connectionString？

class Connection
    {
        private string connectionString;
        protected NpgsqlCommand command;
        protected NpgsqlConnection connection;
        protected NpgsqlDataReader reader;


        public PostgreConnection()
        {
            connectionString = @"Server ="+ ServerBox.Text +
                                ";Port="+ PortBox.Text +
                                ";Database="+ DatabaseBox.Text +
                                ";User ID=" + UserIDBox.Text +
                                ";Password=" + PasswordBox.Text;

            connection = new NpgsqlConnection(connectionString);
            command = connection.CreateCommand();
        }
    }

我需要显示所有相互依赖的表的名称。有 200 个这样的表 + 从属表。例如，表 X 具有来自 Y 的 FK，Y 具有来自 Z 的 FK。即，查找 FK。是否可以从表列表和找到的表中实现 FK 查找？

这是一个查找一个表 (M_KONTRAH_GL) 名称的查询：

SELECT
   master_relation_constraints.rdb$relation_name AS reference_table
FROM
   rdb$relation_constraints detail_relation_constraints
   JOIN rdb$index_segments detail_index_segments ON detail_relation_constraints.rdb$index_name = detail_index_segments.rdb$index_name 
   JOIN rdb$ref_constraints ON detail_relation_constraints.rdb$constraint_name = rdb$ref_constraints.rdb$constraint_name 
   JOIN rdb$relation_constraints master_relation_constraints ON rdb$ref_constraints.rdb$const_name_uq = master_relation_constraints.rdb$constraint_name
WHERE
   detail_relation_constraints.rdb$constraint_type = 'FOREIGN KEY'
   AND detail_relation_constraints.rdb$relation_name = 'M_KONTRAH_GL'

文件监控。出于某种原因，当对文件进行更改时，Change. 如何解决？

这是代码：

public void monitoring(string path)
{
    this.sPath = path;
    string first = Path.GetDirectoryName(path);
    string second = Path.GetFileName(path);
    FileSystemWatcher fsw = new FileSystemWatcher(first, second);
    fsw.Changed += new FileSystemEventHandler(watcher_Changed);
    fsw.EnableRaisingEvents = true;
}

public void watcher_Changed(object sender, FileSystemEventArgs e)
{
    MessageBox.Show("Be happy :3");
    SplitAndQuery(this.sPath);
}

如何在行之间和行后忽略 TextFile 中的空行？ 文本文件格式：

2016-01-01 20:23;Work;5;чистка;5000.00  
2016-01-03 00:40;Custom;1;2;6;3

2016-01-03 00:41;Custom;1;1;10;1  

第 48 行if (element[1] == "Card")

这是代码本身：

public void SplitAndQuery(string path)
{
    char[] separatorLines = { '\n' };
    char[] separatorWords = { ';' };
    string[] lines = File.ReadAllText(path, Encoding.Default).Split(separatorLines, StringSplitOptions.RemoveEmptyEntries);
    for (int i = 0; i <= lines.Length - 1; i++)
    {
      string[] element = lines[i].Split(separatorWords, StringSplitOptions.RemoveEmptyEntries);

        if (element[1] == "Card")
        {
            if (checkCard(element[2]) == false)
            {
                insertCard(element[2], element[3], element[4], element[5], element[6], element[7], element[8]);

                if (checkDiscount(element[2]) == "-1")
                {
                    connection.Close();
                    MessageBox.Show("ups");
                }
                else
                {
                    insertDiscount(element[0],element[9]);
                }
            }
            else if (checkCard(element[2]) == true)
            {
                updateCard(element[3], element[4], element[5], element[6], element[7], element[8], element[2]);
                if (checkDiscount(element[2]) == "-1")
                {
                    connection.Close();
                    MessageBox.Show("ups");
                }
                else
                {
                    insertDiscount(element[0],element[9]);
                    connection.Close();
                }
            }
        }