private void btnSelect_Click(object sender, EventArgs e)
{
var filePath = string.Empty;
dataGridView1.DataSource = null;
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.InitialDirectory = "c:\\";
openFileDialog.Filter = "Excel文件|*.xlsx";
openFileDialog.FilterIndex = 2;
openFileDialog.RestoreDirectory = true;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
if (openFileDialog.FileName.Length > 0)
{
textBox1.Text = openFileDialog.FileName;
filePath = openFileDialog.FileName;
ExcelHelper excelHelper = new ExcelHelper(filePath);
DataTable dt_import = excelHelper.ExcelToDataTable(filePath, true);
if (dt_import.Columns.Contains("应出勤天数") && dt_import.Columns.Contains("UserId"))
{
dt_import = objKaoQinService.GetDingDingDataTable(Program.salaryDate.last_year_month, Program.salaryDate.current_year_month, dt_import);
string[] strs = objControlService.GetColumnsByDataTable(dt_import);
var index = strs.ToList().IndexOf("应出勤");
var index_end = strs.ToList().IndexOf("工作时长");
//给dt里面的空值赋值为0，否则遇到空值会报错。
for (int i = 0; i < dt_import.Rows.Count; i++)
{
for (int j = index; j <= index_end; j++)
{
if (dt_import.Rows[i][j].ToString() == "")
{
dt_import.Rows[i][j] = 0;
}
}
}
}
dataGridView1.DataSource = dt_import;
init_dgvImport();
btnImport.Enabled = true;
}
}
else
{
return; //未选中文件
}
}