public bool Insert(personalfiles dto)
{
dto.Create();
if (dto.Height == null)
{
Random random = new Random();
dto.Height = 1 + random.Next(6, 9) * 0.1 + random.Next(0, 9) * 0.01;
}
return(personalfilesManager.Insert(dto));
}
public bool Save(personalfiles personalfiles)
{
if (string.IsNullOrEmpty(personalfiles.Guid))
{
personalfiles.Create();
return(personalfilesManager.Insert(personalfiles));
}
else if (personalfilesManager.GetById(personalfiles.Guid) != null)
{
return(personalfilesManager.Update(personalfiles));
}
else
{
return(personalfilesManager.Insert(personalfiles));
}
}
public object ImportPersonalfileExcel()
{
string Message = string.Empty;
string Error = string.Empty;
HttpFileCollection files = System.Web.HttpContext.Current.Request.Files;
if (files.Count > 0)
{
var file = files[0];
string dir = HttpContext.Current.Server.MapPath("/Temp");
if (Directory.Exists(dir) == false)
{
Directory.CreateDirectory(dir);
}
string filePath = Path.Combine(dir, Guid.NewGuid().ToString() + file.FileName);
file.SaveAs(filePath);
List <string> sheetNames = ExcelReader.GetExcelSheetName(filePath);
DataTable dt = ExcelReader.GetExcelContext(filePath, "基础数据$");
if (dt != null && dt.Rows.Count > 0)
{
List <personalfiles> lstInsertFiles = new List <personalfiles>();
List <personalfiles> lstUpdateFiles = new List <personalfiles>();
int index = 0;
foreach (DataRow row in dt.Rows)
{
if (row[0] == null || row[0].ToString() == "")
{
continue;
}
try
{
personalfiles personalfiles = new personalfiles()
{
Name = row[0].ToString(),
Company = row[1].ToString(),
Department = row[2].ToString(),
Duty = row[3].ToString(),
Level = row[4].ToString(),
BrithDate = DateTime.Parse(row[5].ToString()),
Age = int.Parse(row[6].ToString()),
EnlistedDate = DateTime.Parse(row[7].ToString()),
PoliticalFace = row[8].ToString(),
Education = row[9].ToString(),
Nation = row[10].ToString(),
NavtivePlace = row[11].ToString(),
Height = double.Parse(row[12].ToString()),
Weight = int.Parse(row[13].ToString()),
Bust = int.Parse(row[14].ToString()),
Waist = int.Parse(row[15].ToString()),
BMI = double.Parse(row[16].ToString()),
PBF = double.Parse(row[17].ToString()),
ModyfiedDate = DateTime.Now
};
//姓名年龄一致判断为重复数据，更新
personalfiles temp = personalfilesManager.GetList(t => t.Name == personalfiles.Name && t.Age.Value == personalfiles.Age.Value).FirstOrDefault();
if (temp == null)
{
personalfiles.Create();
personalfiles.CreateDate = DateTime.Now;
lstInsertFiles.Add(personalfiles);
}
else
{
personalfiles.Guid = temp.Guid;
lstUpdateFiles.Add(personalfiles);
}
index++;
}
catch (Exception ex)
{
Error += $"导入第{index}行数据异常:{ex.Message}";
Error += Environment.NewLine;
}
}
if (lstInsertFiles.Count > 0)
{
personalfilesManager.Insert(lstInsertFiles);
}
if (lstUpdateFiles.Count > 0)
{
personalfilesManager.Update(lstUpdateFiles);
}
Message = $"导入成功,新增人员信息{lstInsertFiles.Count}条，更新人员信息{lstUpdateFiles.Count}条";
}
else
{
Error += "模板中未找到人员信息";
}
}
else
{
Error = "请求参数错误！";
throw new ArgumentNullException(typeof(HttpPostedFile).Name);
}
return(new
{
Message = Message,
Error = Error
});
}