private void btnDoLaod_Click(object sender, EventArgs e)
{
string SQL = "SELECT BADGENUMBER,NAME,BIRTHDAY FROM USERINFO";
string SQLInsert = "INSERT INTO Employee(EmployeeNO, EmployName, Birthday)VALUES (@EmployeeNO,@EmployName,@Birthday)";
ICommonAccess Action = DataFactory.CreateOledbProvider(AppSettings.GetValue("ConStringAccess"));
DataTable dt = Action.GetDataTable(SQL);
if (dt != null && dt.Rows.Count > 0)
{
DbHelperSQL.Instance.Open();
DbTransaction trans = DbHelperSQL.Instance.BeginTranscation();
try
{
for (int i = 0; iparameters = DbHelperSQL.Instance.CreateParameterList();
parameters.Add(DbHelperSQL.Instance.CreateParameter("@EmployeeNO", dt.Rows["BADGENUMBER"].ToString()));
parameters.Add(DbHelperSQL.Instance.CreateParameter("@EmployName", dt.Rows["NAME"].ToString()));
parameters.Add(DbHelperSQL.Instance.CreateParameter("@Birthday", Utilities.ConvertDateTime(dt.Rows["BIRTHDAY"].ToString())));
DbHelperSQL.Instance.ExcuteTransNonQuery(SQLInsert, parameters, trans);
parameters.Clear();
}
}
trans.Commit();
BigMessageBox.Show("下载员工信息成功,需要重新启动该系统", "员工信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
//this.Dispose();
//Application.Exit();
//GC.Collect();
}
|
