private void ImpFile(string xlsFile)
{
lblSuccess.Text = "";
lblError.Text = "";
//读取Excel内容
var _mExcelHelper = new ExcelHelper();
var dt = _mExcelHelper.GetDataFromExcelBreakEmptyLine(xlsFile);
if (null == dt)
{
ShowMsg("读取文件数据失败！");
return;
}
try
{
dt.Columns["ENAME"].ColumnName = "English_Name";
dt.Columns["Employee_type"].ColumnName = "EmployeeTypeName";
dt.Columns.Remove("Employee");
if (null == dt.Columns["IDCardNumber"])
{
dt.Columns.Add("IDCardNumber");
}
if (null == dt.Columns["SrcImport"])
{
dt.Columns.Add("SrcImport"); //0-GBSHR import, 1--multek import
}
}
catch (Exception)
{
lblError.Text = "Excel列名不匹配";
return;
}
var tarTable = "TB_LongEmployeeTemp";
var db = DBO.GetInstance();
//delete old
var commSql = db.DbProviderFactory.CreateCommand();
commSql.CommandType = System.Data.CommandType.Text;
commSql.CommandText = "delete from TB_LongEmployeeTemp";
db.ExecuteNonQuery(commSql);
//bulk insert
var sErr = DataTableHelper.BulkToDB(db.CreateConnection().ConnectionString,
dt,
tarTable);
if (!string.IsNullOrEmpty(sErr))
{
lblError.Text = sErr;
return;
}
else
{
lblError.Text = string.Empty;
}
//merge
var comm = db.DbProviderFactory.CreateCommand();
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.CommandText = "Proc_Merge_LongEmployee";
try
{
db.ExecuteNonQuery(comm);
lblSuccess.Text = "上传完成！";
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
