/// <summary>
        /// 合并文件
        /// </summary>
        private async void ExecuteMergeLibraryCommand()
        {
            IsEnabled = false;
            bool error = IsPathValid(SourceDirectory, MergePath);
            if (error)
            {
                List<String> fileList = new List<string>();
                DirectoryInfo theFolder = new DirectoryInfo(SourceDirectory);
                FileInfo[] fileInfo = theFolder.GetFiles("*.lib", SearchOption.TopDirectoryOnly);
                foreach (FileInfo File in fileInfo)  //遍历文件
                {
                    string _datasource = string.Format("data source={0}", File.FullName);
                    if (ValidateDataBase.Validate(_datasource))
                    {
                        fileList.Add(File.FullName);
                    }
                    else
                    {
                        MessageBoxPlus.Show(App.Current.MainWindow, string.Format("文件“{0}”已加密或者它不是一个有效的库文件", File.FullName), "错误", MessageBoxButton.OK, MessageBoxImage.Error);
                        IsEnabled = true;
                        return;
                    }
                }
                if (fileList.Count==1)
                {
                    MessageBoxPlus.Show(App.Current.MainWindow, "至少两个库才能合并", "提示", MessageBoxButton.OK, MessageBoxImage.Information);
                    IsEnabled = true;
                    return;
                }
                DataTable[] dts = new DataTable[fileList.Count];
                for (int i = 0; i < fileList.Count; i++)
                {
                    using (SQLiteConnection conn = new SQLiteConnection(string.Format("data source={0}", fileList[i])))
                    {
                        using (SQLiteCommand cmd = new SQLiteCommand())
                        {
                            cmd.Connection = conn;
                            conn.Open();
                            SQLiteHelper sh = new SQLiteHelper(cmd);
                            dts[i] = sh.Select("select * from QuestionInfo");
                            conn.Close();
                        }
                    }
                }
                bool isSame = false;
                int j;
                for (j = 1; j < dts.Length; j++)
                {
                    isSame = CompareDataTable(dts[0], dts[j]);
                    if (!isSame)
                    {
                        break;
                    }
                }
                if (!isSame)
                {
                    MessageBoxPlus.Show(App.Current.MainWindow, string.Format("“{0}”与“{1}”的问卷结构不一致,无法合并!", Path.GetFileName(fileList[0]), Path.GetFileName(fileList[j])), "错误", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
                else
                {
                    using (SQLiteConnection conn = new SQLiteConnection(string.Format("data source={0}", fileList[0])))
                    {
                        using (SQLiteCommand cmd = new SQLiteCommand())
                        {
                            cmd.Connection = conn;
                            conn.Open();
                            SQLiteHelper sh = new SQLiteHelper(cmd);
                            if (File.Exists(MergePath))
                            {
                                try
                                {
                                    File.Delete(MergePath);
                                    Visibility = "Visible";
                                    File.Copy(fileList[0], MergePath);
                                    Progress = 1 * 100.0 / fileList.Count;
                                    ProgressMessage = string.Format("已完成 {0:0.0}%", Progress);
                                }
                                catch (Exception e)
                                {
                                    MessageBoxPlus.Show(App.Current.MainWindow, e.Message, "错误", MessageBoxButton.OK, MessageBoxImage.Error);
                                    LogWritter.Log(e, "合库错误");
                                    IsEnabled = true;
                                    return;
                                }
                            }
                            else
                            {
                                Visibility = "Visible";
                                File.Copy(fileList[0], MergePath);
                            }
                        }
                    }

                    await Task.Run(() =>
                    {
                        using (SQLiteConnection conn = new SQLiteConnection(string.Format("data source={0}", MergePath)))
                        {
                            using (SQLiteCommand cmd = new SQLiteCommand())
                            {
                                cmd.Connection = conn;
                                conn.Open();
                                SQLiteHelper sh = new SQLiteHelper(cmd);
                                int recordCount;
                                try
                                {
                                    recordCount = sh.ExecuteScalar<int>("select max(A_Record) from QuestionAnwser");
                                }
                                catch (Exception e)
                                {
                                    MessageBoxPlus.Show(App.Current.MainWindow, "记录为空!", "错误", MessageBoxButton.OK, MessageBoxImage.Error);
                                    LogWritter.Log(e, "合库时记录为空");
                                    IsEnabled = true;
                                    return;
                                }
                                //创建临时表
                                sh.Execute("create table temp as select * from QuestionAnwser where 1=0");
                                for (int i = 1; i < fileList.Count; i++)
                                {
                                    string dataBase = "db";
                                    sh.AttachDatabase(fileList[i], dataBase);
                                    int _recordCount = sh.ExecuteScalar<int>("select max(A_Record) from db.QuestionAnwser");
                                    sh.Execute("insert into temp select * from db.QuestionAnwser");
                                    sh.Execute(string.Format("Update temp set A_record=A_record+{0}", recordCount));
                                    sh.Execute("insert into QuestionAnwser select * from temp");
                                    sh.Execute("delete from temp");
                                    sh.DetachDatabase(dataBase);
                                    recordCount = recordCount + _recordCount;
                                    Progress = (i + 1) * 100.0 / fileList.Count;
                                    ProgressMessage = string.Format("已完成 {0:0.0}%", Progress);
                                }
                                sh.Execute("drop table temp");
                                conn.Close();
                                Visibility = "Hidden";
                            }
                        }
                    });
                    MessageBoxPlus.Show(App.Current.MainWindow, "合并成功", "提示", MessageBoxButton.OK, MessageBoxImage.Information);
                }
            }
            IsEnabled = true;
        }