//后台导入
        void worker_DoWork(object sender, DoWorkEventArgs e)
        {
            Model.ImportDataErrorModel errorModel;//错误模型

            int currentManagerID = AddTestManagerModel();//添加测试项目

            for (int i = 0; i < choosedFileNames.Length; i++)
            {
                if (importFlag == 1) {
                    break;

                }
                if (importFlag == 2) {
                    i--;
                    continue;
                }

                string fileName = choosedFileNames[i];
                string[] contents = File.ReadAllLines(fileName);

                //检查数据文件是否是测试数据文件
                if (!CheckFile(fileName, contents))
                {
                    worker.ReportProgress(i + 1, null);
                    continue;
                }
                else {
                    worker.ReportProgress(i + 1, contents);
                }

                string testDate = GetLineValue(contents[2]);
                string testTime = GetLineValue(contents[3]);
                DateTime testDateTime = DateTime.Now;
                if (testDate != "" && testTime != "")
                {
                    try
                    {
                        testDateTime = Convert.ToDateTime(testDate + " " + testTime, dtPointFormat);
                    }
                    catch {
                        testDateTime = DateTime.Now;
                    }
                }

                //添加人员信息
                Model.TB_AthleteInfo athModel = new Model.TB_AthleteInfo();
                athModel.Ath_PinYin = athModel.Ath_Name = GetLineValue(contents[4]);
                athModel.Ath_TestID = currentManagerID;
                athModel.Ath_Sex = DataUtil.AthleteSexUtil.GetSex(GetLineValue(contents[29]));
                athModel.Ath_TestDate = testDateTime;
                string birthdayStr = GetLineValue(contents[27]);
                if (birthdayStr != "")
                {
                    try
                    {
                        athModel.Ath_Birthday = Convert.ToDateTime(birthdayStr, dtLineFormat);
                    }
                    catch {
                        athModel.Ath_Birthday = DateTime.Now;
                    }
                }
                athModel.Ath_Height = GetLineValue(contents[26]);
                athModel.Ath_Weight = GetLineValue(contents[25]);

                int athID = AddAthInfo(athModel);
                if (athID == -1)
                {//添加失败,继续
                    errorModel = new Model.ImportDataErrorModel();
                    errorModel.ErrorString = "添加人员信息出错";
                    errorModel.FileName = fileName;
                    errorModelList.Add(errorModel);
                    continue;
                }

                string Gravitycomp = GetLineValue(contents[31]);
                string dataFileName = "";
                //处理数据文件
                try
                {
                    BaseDataUtil dataUtil = new BaseDataUtil();
                    dataUtil.SmoothValue = (int)smoothValue;
                    dataUtil.Weight = athModel.Ath_Weight;
                    if (Gravitycomp != "")
                    {
                        dataUtil.Gravitycomp = Gravitycomp;
                    }
                    dataFileName = dataUtil.WriteBaseData(contents);
                }
                catch
                {
                    errorModel = new Model.ImportDataErrorModel();
                    errorModel.ErrorString = "计算出错";
                    errorModel.FileName = fileName;
                    errorModelList.Add(errorModel);
                    continue;
                }
                //添加到数据库
                try
                {
                    Model.TB_TestInfo testInfoModel = new Model.TB_TestInfo();
                    testInfoModel.Gravitycomp = Gravitycomp;
                    testInfoModel.DataFileName = dataFileName;
                    testInfoModel.BaseFileName = contents[0].Trim();
                    testInfoModel.Ath_ID = athID;

                    testInfoModel.TestDate = testInfoModel.TestTime = testDateTime;

                    testInfoModel.Joint_Side = GetLineValue(contents[5]);
                    testInfoModel.Test_Mode = GetLineValue(contents[6]);
                    testInfoModel.Joint = GetLineValue(contents[7]);
                    testInfoModel.Plane = GetLineValue(contents[8]);
                    testInfoModel.Motion_Start = GetLineValue(contents[10]);
                    testInfoModel.Motion_End = GetLineValue(contents[11]);
                    testInfoModel.Speed1 = GetLineValue(contents[12]);
                    testInfoModel.Speed2 = GetLineValue(contents[13]);
                    testInfoModel.Acceleration1 = GetLineValue(contents[14]);
                    testInfoModel.Acceleration2 = GetLineValue(contents[15]);
                    testInfoModel.Break = GetLineValue(contents[18]);
                    testInfoModel.NOOfSets = GetLineValue(contents[22]);
                    testInfoModel.NOOfRepetitions = GetLineValue(contents[23]);
                    testInfoModel.InsuredSide = GetLineValue(contents[28]);
                    testInfoModel.Therapist = GetLineValue(contents[30]);

                    testInfoBLL.Add(testInfoModel);
                }
                catch
                {
                    errorModel = new Model.ImportDataErrorModel();
                    errorModel.ErrorString = "保存测试信息出错";
                    errorModel.FileName = fileName;
                    errorModelList.Add(errorModel);
                    continue;
                }
            }
        }
        //导入方法
        private void Import(string [] fileNames,bool ischeckRepeate)
        {
            importProgress.Maximum = fileNames.Count();
            importProgress.Minimum = 0;
            importProgress.Value = 0;
            double value = 0;
            UpdateProgressBarDelegate updatePbDelegate = new UpdateProgressBarDelegate(importProgress.SetValue);
            for (int i = 0; i < fileNames.Count(); i++) {
                if (importFlag == 1) {
                    break;
                }
                if (importFlag == 2) {
                    i--;
                    continue;
                }
                value += 1;
                Dispatcher.Invoke(updatePbDelegate,
                    System.Windows.Threading.DispatcherPriority.Background,
                    new object[] { ProgressBar.ValueProperty, value });

                Model.ImportDataErrorModel errorModel=null;

                string baseFileName=fileNames[i];

                #region 写入进度
                tbFileName.Text = "文件名:" + baseFileName.Substring(baseFileName.LastIndexOf("\\") + 1);
                tbContent1.Text = "";
                tbContent2.Text = "";
                tbContent3.Text = "";
                tbProgress.Text = (i + 1) + "/" + fileNames.Count();
                #endregion

                #region 读取数据文件信息
                string[] contents = File.ReadAllLines(baseFileName);

                if (!CheckFile(baseFileName, contents))
                {
                    continue;
                }
                for (int a = 0; a < 11; a++)
                {
                    tbContent1.Text += contents[a] + "\r\n";
                    tbContent2.Text += contents[11 + a] + "\r\n";
                    tbContent3.Text += contents[22 + a] + "\r\n";
                }

                string testDate = GetLineValue(contents[2]);
                string testTime = GetLineValue(contents[3]);
                DateTime testDateTime = DateTime.Now;
                if (testDate != "" && testTime != "")
                {
                    try
                    {
                        testDateTime = Convert.ToDateTime(testDate + " " + testTime, dtPointFormat);
                    }
                    catch {
                        testDateTime = DateTime.Now;
                    }
                }

                Model.TB_AthleteInfo athModel = new Model.TB_AthleteInfo();
                athModel.Ath_PinYin = athModel.Ath_Name = GetLineValue(contents[4]);
                athModel.Ath_Sex = DataUtil.AthleteSexUtil.GetSex(GetLineValue(contents[29]));
                athModel.Ath_TestDate = testDateTime;
                string birthdayStr = GetLineValue(contents[27]);
                if (birthdayStr != "")
                {
                    try
                    {
                        athModel.Ath_Birthday = Convert.ToDateTime(birthdayStr, dtLineFormat);
                    }
                    catch {
                        athModel.Ath_Birthday = DateTime.Now;
                    }
                }
                else {
                    athModel.Ath_Birthday = null;
                }
                athModel.Ath_Height = GetLineValue(contents[26]);
                athModel.Ath_Weight = GetLineValue(contents[25]);

                Model.TB_AthleteInfo testAthInfoModel = CheckAthInfo(athModel);
                if (testAthInfoModel == null) {
                    continue;
                }

                Model.TB_TestInfo testInfo = new Model.TB_TestInfo();
                testInfo.BaseFileName = contents[0].Trim();
                testInfo.TestTime = testInfo.TestDate = testDateTime;
                testInfo.Joint_Side = GetLineValue(contents[5]);
                testInfo.Test_Mode = GetLineValue(contents[6]);
                testInfo.Joint = GetLineValue(contents[7]);
                testInfo.Plane = GetLineValue(contents[8]);
                testInfo.Motion_Start = GetLineValue(contents[10]);
                testInfo.Motion_End = GetLineValue(contents[11]);
                testInfo.Speed1 = GetLineValue(contents[12]);
                testInfo.Speed2 = GetLineValue(contents[13]);
                testInfo.Acceleration1 = GetLineValue(contents[14]);
                testInfo.Acceleration2 = GetLineValue(contents[15]);
                testInfo.Break = GetLineValue(contents[18]);
                testInfo.NOOfSets = GetLineValue(contents[22]);
                testInfo.NOOfRepetitions = GetLineValue(contents[23]);
                testInfo.InsuredSide = GetLineValue(contents[28]);
                testInfo.Therapist = GetLineValue(contents[30]);
                testInfo.Gravitycomp = GetLineValue(contents[31]);

                testInfo.DataFileName = "";

                testInfo.Ath_ID = testAthInfoModel.ID;
                #endregion

                #region 检查是否重复导入
                if (ischeckRepeate) {
                    //检测是否有相同时间的数据导入
                    try
                    {
                        //判断该测试信息是否导入,判断条件 用户ID 测试日期,数据文件名
                        List<Model.TB_TestInfo> existsTestInfoList = testInfoBLL.GetModelList("ath_id=" + testInfo.Ath_ID + " and testdate=#" + testInfo.TestDate + "# and BaseFileName='" + testInfo.BaseFileName + "'");
                        if (existsTestInfoList.Count > 0)//有重复数据
                        {
                            existsIDs += existsTestInfoList[0].ID + ",";
                            Model.ExistsFileModel exFileModel = new Model.ExistsFileModel();
                            exFileModel.FileName = baseFileName;
                            exFileModel.RealName = baseFileName.Substring(baseFileName.LastIndexOf("\\") + 1);
                            existsFiles.Add(exFileModel);
                            continue;
                        }
                    }
                    catch (Exception ee)
                    {
                        MessageBox.Show("检查此文件是否导入时出错!\r\n" + ee.Message, "系统错误");
                        errorModel = new Model.ImportDataErrorModel();
                        errorModel.ErrorString = "3";
                        errorModel.FileName = baseFileName;
                        errorModelList.Add(errorModel);
                        continue;
                    }
                }
                #endregion

                //导入
                try
                {
                    BaseDataUtil dataUtil = new BaseDataUtil();
                    dataUtil.SmoothValue = (int)smoothValue;
                    dataUtil.Weight = testAthInfoModel.Ath_Weight;
                    if (testInfo.Gravitycomp.Trim() != "") {
                        dataUtil.Gravitycomp = testInfo.Gravitycomp;
                    }
                    string fileName = dataUtil.WriteBaseData(contents);

                    testInfo.DataFileName = fileName;
                }
                catch (Exception ee)
                {
                    MessageBox.Show("计算出错!\r\n" + ee.Message, "系统错误");
                    errorModel = new Model.ImportDataErrorModel();
                    errorModel.ErrorString = "4";
                    errorModel.FileName = baseFileName;
                    errorModelList.Add(errorModel);
                    continue;
                }
                //添加到数据库
                try
                {
                    testInfoBLL.Add(testInfo);
                }
                catch (Exception ee)
                {
                    MessageBox.Show("添加测试信息出错,请稍候重试!\r\n" + ee.Message, "系统错误");
                    errorModel = new Model.ImportDataErrorModel();
                    errorModel.ErrorString = "5";
                    errorModel.FileName = baseFileName;
                    errorModelList.Add(errorModel);
                    continue;
                }

            }

            if (errorModelList.Count > 0) {
                tbErrorCount.Text = errorModelList.Count + "个文件导入错误";
                ErrorPanel.Visibility = Visibility.Visible;
            }

            if (ischeckRepeate)
            {//如果检查重复并且存在重复数据就刷新数据列表
                if (existsFiles.Count > 0)
                {
                    btnReImport.IsEnabled = true;
                    RefrenshDataGridSource();
                }
                else {
                    btnReImport.IsEnabled = false;
                }
            }
        }