public List <StoreDoctorDetial> GetStoreDoctorDetialList(DataTable table)
{
var storeDoctorDetialList = new List <StoreDoctorDetial>();
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
try
{
if (string.IsNullOrEmpty(ConvertDataRow(row["序号"])))
{
/// table.Rows.Remove(row);
}
StoreDoctorDetial storeDoctorDetial = new StoreDoctorDetial
{
No = int.Parse(ConvertDataRow(row["序号"])),
Name = ConvertDataRow(row["姓名"]),
Sex = ConvertDataRow(row["性别"]),
Age = ConvertDataRow(row["年龄"]),
MedicalStatus = ConvertDataRow(row["医疗状态"]),
ImageNo = ConvertDataRow(row["影像号"]),
CheckNo = ConvertDataRow(row["检查号"]),
CheckType = ConvertDataRow(row["检查类型"]),
ExaminationNo = ConvertDataRow(row["体检号"]),
CheckPart = ConvertDataRow(row["检查部位"]),
CheckProject = ConvertDataRow(row["检查项目"]),
CheckResult = ConvertDataRow(row["阴阳性"]),
RegistrationTime = GetDateTime(ConvertDataRow(row["登记时间"])).Value,
Operator = ConvertDataRow(row["操作技师"]),
CheckTime = GetDateTime(ConvertDataRow(row["检查时间"])).Value,
DiagnosisDoctor = ConvertDataRow(row["诊断医生"]),
DiagnosisTime = GetDateTime(ConvertDataRow(row["诊断时间"])).Value,
AuditDoctor = ConvertDataRow(row["终审医生"]),
AuditTime = GetDateTime(ConvertDataRow(row["终审时间"])).Value,
StoreName = ConvertDataRow(row["申请科室"]),
};
storeDoctorDetialList.Add(storeDoctorDetial);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
Logger.Info($"调用函数GetStoreDoctorDetialList失败！" + ex.Message);
Logger.Info($"调用函数GetStoreDoctorDetialList失败！" + ex.StackTrace);
}
}
return(storeDoctorDetialList);
}
public void InsertOrgionDataIntoDatabase(List <StoreDoctorDetial> list)
{
for (int i = 0; i < list.Count; i++)
{
StoreDoctorDetial storeDoctorDetial = list[i];
if (_storeDoctorDetialRepository.Find(s => s.ImageNo.Equals(storeDoctorDetial.ImageNo) && s.CheckNo.Equals(storeDoctorDetial.CheckNo) && s.CheckPart.Equals(storeDoctorDetial.CheckPart) && s.CheckProject.Equals(storeDoctorDetial.CheckProject) && s.ExaminationNo.Equals(storeDoctorDetial.ExaminationNo)).Count() >= 1)
{
List <StoreDoctorDetial> findedStoreDoctorDetial = _storeDoctorDetialRepository.Find(s => s.ImageNo.Equals(storeDoctorDetial.ImageNo) && s.CheckNo.Equals(storeDoctorDetial.CheckNo) && s.CheckPart.Equals(storeDoctorDetial.CheckPart) && s.CheckProject.Equals(storeDoctorDetial.CheckProject) && s.ExaminationNo.Equals(storeDoctorDetial.ExaminationNo)).ToList();
foreach (var item in findedStoreDoctorDetial)
{
//findedStoreDoctorDetial.ImageNo = storeDoctorDetial.ImageNo;
//findedStoreDoctorDetial.MedicalStatus = storeDoctorDetial.MedicalStatus;
//findedStoreDoctorDetial.Name = storeDoctorDetial.Name;
//findedStoreDoctorDetial.No = storeDoctorDetial.No;
//findedStoreDoctorDetial.Operator = storeDoctorDetial.Operator;
//findedStoreDoctorDetial.RegistrationTime = storeDoctorDetial.RegistrationTime;
//findedStoreDoctorDetial.Sex = storeDoctorDetial.Sex;
item.StoreName = storeDoctorDetial.StoreName;
//findedStoreDoctorDetial.ExaminationNo = storeDoctorDetial.ExaminationNo;
//findedStoreDoctorDetial.DiagnosisTime = storeDoctorDetial.DiagnosisTime;
//findedStoreDoctorDetial.DiagnosisDoctor = storeDoctorDetial.DiagnosisDoctor;
//findedStoreDoctorDetial.CheckType = storeDoctorDetial.CheckType;
//findedStoreDoctorDetial.CheckTime = storeDoctorDetial.CheckTime;
//findedStoreDoctorDetial.CheckResult = storeDoctorDetial.CheckResult;
//findedStoreDoctorDetial.CheckProject = storeDoctorDetial.CheckProject;
//findedStoreDoctorDetial.CheckPart = storeDoctorDetial.CheckPart;
//findedStoreDoctorDetial.CheckNo = storeDoctorDetial.CheckNo;
//findedStoreDoctorDetial.AuditTime = storeDoctorDetial.AuditTime;
//findedStoreDoctorDetial.AuditDoctor = storeDoctorDetial.AuditDoctor;
//findedStoreDoctorDetial.Age = storeDoctorDetial.Age;
_storeDoctorDetialRepository.Update(item);
}
}
else
{
_storeDoctorDetialRepository.Create(storeDoctorDetial);
}
if (i % 100 == 0)
{
_storeDoctorDetialRepository.Commit();
}
}
_storeDoctorDetialRepository.Commit();
}
