private void btnViewData_Click(object sender, EventArgs e)
{
try
{
if (txtFilePath.Text != "")
{
DataTable dt = OpenFileExcel.getDataExcelFromFileToDataTable(txtFilePath.Text);
dt.Rows.RemoveAt(0);
UC_ViewData uc = new UC_ViewData(dt);
frmShowWindow frm = new frmShowWindow();
frm.Controls.Clear();
uc.Dock = DockStyle.Fill;
frm.Text = "Hiển thị dữ liệu";
frm.Controls.Add(uc);
frm.ShowDialog();
}
else
{
XtraMessageBox.Show("Bạn chưa chọn file để hiển thị");
}
}
catch (Exception ex)
{
XtraMessageBox.Show("" + ex.Message, "Lỗi");
}
}
private void btnOpenFile_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel .xlsx|*.xlsx|Excel .xls|*.xls";
if (DialogResult.OK == op.ShowDialog())
{
btnStart.Enabled = false;
btnStart2.Enabled = false;
txtFilePath.Text = op.FileName.Trim();
Thread t = new Thread(new ThreadStart(() =>
{
try
{
lsData = OpenFileExcel.getDataExcelFromFileToList(op.FileName.Trim());
lsData.RemoveAt(0);
lsAllData = loadDataToList(lsData);
btnStart.Invoke((MethodInvoker) delegate { btnStart.Enabled = true; });
btnStart2.Invoke((MethodInvoker) delegate { btnStart2.Enabled = true; });
}
catch (Exception ex)
{
XtraMessageBox.Show("" + ex.Message, "Thông báo lỗi");
}
}));
t.Start();
}
}
catch (Exception ex)
{
XtraMessageBox.Show("" + ex.Message, "Lỗi");
}
}
private void cbbSheet_SelectedIndexChanged(object sender, EventArgs e)
{
_dataTempView = new DataTable();
string selectSheet = cbbSheet.Text;
_dataTempView = OpenFileExcel.getDataExcelFromFileToDataTable(txtPathFile1.Text, selectSheet);
gridControl1.DataSource = _dataTempView;
}
private void btnGetForm_Click(object sender, EventArgs e)
{
FolderBrowserDialog f = new FolderBrowserDialog();
f.Description = "Chọn thư mục lưu trữ form dữ liệu";
string filePath = "";
if (f.ShowDialog() == DialogResult.OK)
{
filePath = OpenFileExcel.moveFile(f.SelectedPath);
if (DialogResult.OK == XtraMessageBox.Show("Mở file \"" + Path.GetFileName(filePath) + "\" ?", "", MessageBoxButtons.OKCancel))
{
System.Diagnostics.Process.Start(filePath);
}
}
}
private void btnChooseFile1_Click(object sender, EventArgs e)
{
try
{
Dictionary <string, object> data = OpenFileExcel.getInfoFiles();
if (data != null)
{
txtPathFile1.Text = data["fileName"].ToString();
data.Remove("fileName");
foreach (var item in data)
{
cbbSheet.Properties.Items.Add(item.Value.ToString().Trim(new char['\'']).Replace("\'", ""));
}
cbbSheet.SelectedIndex = 0;
}
}
catch (Exception ex) { XtraMessageBox.Show("Lỗi: " + ex.Message); }
}
