public void GetStringPart_ShouldBeNotEqual() { var input = "TP001"; var result = ReadUploadedExcel.GetStringPart(input); Assert.NotEqual("T", result); }
public void IsTargetSampleName_ShouldBeFalse() { var targetPreFix = new StringCollection { "T" }; var sampleNames = "TP001"; var result = ReadUploadedExcel.IsTargetSampleName(targetPreFix, sampleNames); Assert.False(result); }
private void OpenFileButton_Click(object sender, RoutedEventArgs e) { // 打开NIMBUS移液平台工作清单 OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Title = "打开NIMBUS移液平台工作清单"; openFileDialog.DefaultExt = ".xls"; openFileDialog.Filter = "Excel files (*.xls;*.xlsx)|*.xls;*.xlsx"; if (openFileDialog.ShowDialog().GetValueOrDefault() != true) { return; } FileName.Text = openFileDialog.SafeFileName; // 打开每日操作清单 OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.Title = "打开每日操作清单"; openFileDialog1.DefaultExt = ".xls"; openFileDialog1.Filter = "Excel files (*.xls;*.xlsx)|*.xls;*.xlsx"; if (openFileDialog1.ShowDialog().GetValueOrDefault() != true) { return; } FileName1.Text = openFileDialog1.SafeFileName; // 用户再次点击上传文件时清空之前的数据 SampleTable = new SampleTable(); DocumentPage.Document = null; try { // 读取数据 SampleTable = ReadUploadedExcel.ReadNIMBUSWorkBook(openFileDialog.FileName); SampleTable = ReadUploadedExcel.ReadOperateWorkBook(SampleTable, openFileDialog1.FileName); // 生成96孔板工作清单 var flowDocument = new FlowDocument() { ColumnWidth = RowTitleWidth + CellColWidth * 12 + 50, }; foreach (var plate in SampleTable.PlateNumber) { flowDocument.Blocks.Add(new BlockUIContainer(Create96WellPlateForm(plate))); } DocumentPage.Document = flowDocument; PrintButton.IsEnabled = true; OutputButton.IsEnabled = true; } catch (IOException ex) { MessageBox.Show($"读取Excel文件时出现错误:{ex.Message}", "错误", MessageBoxButton.OK, MessageBoxImage.Error); return; } catch (Exception ex) { MessageBox.Show($"生成前处理工作清单时出现错误:{ex.Message}", "错误", MessageBoxButton.OK, MessageBoxImage.Error); return; } }