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); } }