//保存到数据库
private void btnSaveToDB_Click(object sender, EventArgs e)
{
//【1】验证数据（保证List集合中有数据）
if (stuList == null || stuList.Count == 0)
{
MessageBox.Show("目前没有要导入的数据！", "导入提示");
return;
}
//【2】遍历集合（方法1，每查询一个对象，就提交一次到数据；方法2，每遍历一次，就生成一条SQL语句，基于事务保存对象）
try
{
if (objImport.Import(this.stuList))
{
MessageBox.Show("数据导入成功！", "导入提示");
this.dgvStudentList.DataSource = null;
this.stuList.Clear();
}
else
{
MessageBox.Show("数据导入失败！", "导入提示");
}
}
catch (Exception ex)
{
MessageBox.Show("数据导入失败！具体原因：" + ex.Message, "导入提示");
}
}
//save
private void btnSaveToDB_Click(object sender, EventArgs e)
{
if (stuList == null || stuList.Count == 0)
{
MessageBox.Show("No data import", "Warning");
return;
}
try
{
if (objImportData.Import(this.stuList))
{
MessageBox.Show("Import Sussessfully", "Warning");
this.dgvStudentList.DataSource = null;
this.stuList.Clear();
}
else
{
MessageBox.Show("Fail", "Warning");
return;
}
}
catch (Exception ex)
{
MessageBox.Show("Import data error:" + ex.Message, "Warning");
}
}
private void 导入员工ToolStripMenuItem_Click(object sender, EventArgs e)
{
OpenFileDialog dialog = new OpenFileDialog();
DialogResult result = dialog.ShowDialog();
if (result == DialogResult.OK)
{
string path = dialog.FileName;
var sfList = ImportDataFromExcel.GetStudentByExcel(path);
if (sfList.Count > 0)
{
ImportDataFromExcel.Import(sfList);
MessageBox.Show("导入成功！");
}
}
}