private void xlueSheet_EditValueChanged(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowDefaultWaitForm();
if (xlueSheet.ItemIndex >= 0)
{
FormatterHelper.LoadExcel(openFileDialog.FileName, xlueSheet.ItemIndex, ref _listSheetsName,
ref _dtExcelData);
}
}
catch (Exception exception)
{
XtraMessageBox.Show(exception.Message + "\r\n" + exception.StackTrace);
}
finally
{
SplashScreenManager.CloseDefaultWaitForm();
}
}
private void xbeExcelFile_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
SplashScreenManager.ShowDefaultWaitForm();
if (openFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
xbeExcelFile.Text = openFileDialog.FileName;
FormatterHelper.LoadExcel(xbeExcelFile.Text, 0, ref _listSheetsName, ref _dtExcelData);
xlueSheet.Properties.DataSource = _listSheetsName;
}
catch (Exception exception)
{
XtraMessageBox.Show(exception.Message + "\r\n" + exception.StackTrace);
}
finally
{
SplashScreenManager.CloseDefaultWaitForm();
}
}
private void FormatData()
{
switch (xlueFormatType.EditValue.ToString())
{
case "A":
xgcResult.DataSource = FormatterHelper.FormatDemand(_dtExcelData);
break;
case "B":
xgcResult.DataSource = FormatterHelper.FormatEntity(_dtExcelData);
break;
case "C":
xgcResult.DataSource = FormatterHelper.GetCaseType(_dtExcelData);
break;
case "D":
xgcResult.DataSource = FormatterHelper.MergeInventorInfo(_dtExcelData);
break;
default:
break;
}
}