private int ReadCSVData()
{
if (DialogExcelDataLoad.ShowDialog() == DialogResult.OK)
{
if (evokWork.showFilePathLabel == null)
{
evokWork.showFilePathLabel = label13;
}
evokWork.SetDataShowCb(listBox1);
evokWork.SetDataShowLbl(label14);
ConstantMethod.SaveDirectoryByFileDialog(DialogExcelDataLoad);
int num = ConstantMethod.IsWhichFile(DialogExcelDataLoad.FileName);
if (num == Constant.CsvFile)
{
evokWork.LoadCsvData(DialogExcelDataLoad.FileName);
}
if (num == Constant.ExcelFile)
{
evokWork.LoadExcelData(DialogExcelDataLoad.FileName);
}
}
return(0);
}
private void button4_Click(object sender, EventArgs e)
{
if (DialogExcelDataLoad.ShowDialog() == DialogResult.OK)
{
dataLoad(DialogExcelDataLoad.FileName);
}
}
private void 导入excel文件ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (DialogExcelDataLoad.ShowDialog() == DialogResult.OK)
{
ConstantMethod.SaveDirectoryByFileDialog(DialogExcelDataLoad);
UserDt = null;
string localFilePath = DialogExcelDataLoad.FileName;
string FileExt = Path.GetExtension(localFilePath).ToLower();
if (FileExt.Equals(Constant.ExcelFileEX0) || FileExt.Equals(Constant.ExcelFileEX1))
{
UserDt = exop.ImportExcel(DialogExcelDataLoad.FileName);
if (UserDt != null && UserDt.Columns.Count > 3)
{
dgv.DataSource = UserDt;
showColName();
}
else
{
MessageBox.Show("加载文件错误！");
}
}
else
{
MessageBox.Show("文件格式错误！");
}
}
}
int ReadSimiData()
{
if (DialogExcelDataLoad.ShowDialog() == DialogResult.OK)
{
//if (evokWork.showFilePathLabel == null) evokWork.showFilePathLabel = label8;
evokWork.SetDataShowCb(listBox2);
evokWork.SetDataShowLbl(label14);
ConstantMethod.SaveDirectoryByFileDialog(DialogExcelDataLoad);
evokWork.LoadSimiData(DialogExcelDataLoad.FileName);
}
return(0);
}
private int ReadCSVData()
{
if (DialogExcelDataLoad.ShowDialog() == DialogResult.OK)
{
int num = ConstantMethod.IsWhichFile(DialogExcelDataLoad.FileName);
if (num == Constant.CsvFile)
{
evokWork.LoadCsvData(DialogExcelDataLoad.FileName);
}
if (num == Constant.ExcelFile)
{
evokWork.LoadExcelData(DialogExcelDataLoad.FileName);
}
}
return(0);
}
