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