private void buttonCalc_Click(object sender, RoutedEventArgs e)
{
int num = ExcelData.dataTable.Rows.Count;
if (GloableVar.whetherReadSuc == 1 | num >= 2)
{
CalculateYM yM = new CalculateYM();
GloableVar.fringeNum = Convert.ToInt32(this.textBoxNum.Text);
double result = yM.CalResult(GloableVar.fringeNum);
this.textBoxShowAns.Text = Convert.ToString(Math.Round(result, 6));
string exePath = Environment.CurrentDirectory;
string txtPath = null;
txtPath = exePath + "\\result.txt";
TxtWrite(txtPath, this.textBoxShowAns.Text);
string txtPath1 = null;
txtPath1 = exePath + "\\friage.txt";
TxtWrite(txtPath1, this.textBoxNum.Text);
string xlsxPath = null;
xlsxPath = exePath + "\\dataSave.xlsx";
ExcelUtility.DataTableToExcel(xlsxPath, ExcelData.dataTable);
ExportCurrentData();
}
else
{
MessageBox.Show("没有输入数据或者读取数据失败，无法计算！", "Warnning!");
}
}
public void ExportCurrentData()
{
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string folderPath = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments).ToString() + "\\Young Modulus\\";
string excelPath = currentTime.ToString("yyyyMMdd_HHmmss") + "_" + this.textBoxNum.Text + "_" + this.textBoxShowAns.Text;
ExcelUtility.DataTableToExcel(folderPath + excelPath + ".xlsx", ExcelData.dataTable);
}
public void ShowLastData()
{
string exePath = Environment.CurrentDirectory;
string txtPath = null;
string xlsxPath = null;
xlsxPath = exePath + "\\dataSave.xlsx";
ExcelDataTable.dt = ExcelUtility.ExcelToDataTable(xlsxPath, true);
dataGridShowLast.ItemsSource = ExcelDataTable.dt.DefaultView;
}
public void ReadExcelData()
{
string address = "";
string filePath = this.textBoxDataAddress.Text;
int j = 0;
if (filePath[0] == '"')
{
address = filePath.Substring(1, filePath.Length - 2);
}
else
{
address = filePath;
}
ExcelData.dataTable = ExcelUtility.ExcelToDataTable(address, true);
}
public void ExportLastData()
{
try
{
var saveFileDialog = new Microsoft.Win32.SaveFileDialog()
{
Filter = "Excel(*.xlsx *.xls)|*.xlsx;*.xls"
};
var result = saveFileDialog.ShowDialog();
if (result == true)
{
string path = saveFileDialog.FileName;
ExcelUtility.DataTableToExcel(path, ExcelDataTable.dt);
this.textBoxLastDataAddress.Text = "导出数据成功！路径：" + path;
}
}
catch
{
MessageBox.Show("导出数据失败！", "Warnning!");
}
}
public void ExportData()
{
try
{
var saveFileDialog = new Microsoft.Win32.SaveFileDialog()
{
Filter = "Excel(*.xlsx *.xls)|*.xlsx;*.xls"
};
var result = saveFileDialog.ShowDialog();
if (result == true)
{
string path = saveFileDialog.FileName;
ExcelUtility.DataTableToExcel(path, ExcelData.dataTable);
this.textBlockWhetherExport.Text = "导出成功！";
}
Timer();
}
catch
{
MessageBox.Show("导出数据失败！", "Warnning!");
}
}
