private void btnImportFromDB_Click(object sender, EventArgs e)
{
if (MessageBox.Show("导入将会导致所有现有数据清空，并且导入过程可能需要等待几分钟的时间，确认要进行导入？", "确认导入", MessageBoxButtons.YesNo) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
//photo8668!
string conn = "server=" + txbDBServer.Text + ";database=" + txbDBDbName.Text + ";uid=" + txbDBUserName.Text +
";password="******"从HR系统读取了" + empList.Count + "个用户，点击确定开始导入");
AnnualPartySqlHelper.Instance.DeleteTableData();
foreach (MyEmployee emp in empList)
{
try
{
emp.ShortPinyin = py.GetPinyinShort(emp.Name);
}
catch (Exception ex)
{
log.Error(emp.Name + "拼音获取有误", ex);
}
AnnualPartySqlHelper.Instance.InitEmployee(emp);
if (emp.Photo != null)
{
AnnualPartySqlHelper.Instance.InitPhoto(emp.EmployeeNumber, emp.Photo);
}
}
MessageBox.Show("成功导入员工信息" + empList.Count + "个");
}
catch (Exception ex)
{
MessageBox.Show("导入失败，错误消息：" + ex.Message);
}
}
private void btnImportFromDB_Click(object sender, EventArgs e)
{
if (MessageBox.Show("导入将会导致所有现有数据清空，并且导入过程可能需要等待几分钟的时间，确认要进行导入？", "确认导入", MessageBoxButtons.YesNo) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
string conn = "server=" + txbDBServer.Text + ";database=" + txbDBDbName.Text + ";uid=" + txbDBUserName.Text +
";password="******"从HR系统读取了" + empList.Count + "个用户，点击确定开始导入");
AnnualPartySqlHelper.Instance.DeleteTableData();
foreach (Employee emp in empList)
{
try
{
emp.ShortPinyin = py.GetPinyinShort(emp.Name);
}
catch (Exception ex)
{
log.Error(emp.Name + "拼音获取有误", ex);
}
AnnualPartySqlHelper.Instance.InitEmployee(emp);
if (emp.Photo != null)
{
AnnualPartySqlHelper.Instance.InitPhoto(emp.EmployeeNumber, emp.Photo);
}
}
MessageBox.Show("成功导入员工信息" + empList.Count + "个");
}
catch(Exception ex)
{
MessageBox.Show("导入失败，错误消息：" + ex.Message);
}
}
