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;
}
}
