/// <summary> /// 批量新增外包人员的体检信息 /// </summary> /// <param name="keyValue"></param> /// <param name="entity"></param> /// <returns></returns> public void SummitPhyInfo(string keyValue, PhyInfoEntity entity) { try { service.SummitPhyInfo(keyValue, entity); } catch (Exception) { throw; } }
/// <summary> /// 批量新增外包人员的体检信息 /// </summary> /// <param name="keyValue"></param> /// <param name="entity"></param> /// <returns></returns> public void SummitPhyInfo(string keyValue, PhyInfoEntity entity) { string[] ids = entity.ids.Split(','); string strIds = string.Join(",", ids).Replace(",", "','"); string strUpdate = string.Empty; if (!string.IsNullOrWhiteSpace(entity.PhysicalUnit)) { strUpdate += string.Format(" PhysicalUnit='{0}',", entity.PhysicalUnit); } if (!string.IsNullOrWhiteSpace(entity.IsComtraindication)) { strUpdate += string.Format(" IsComtraindication='{0}',", entity.IsComtraindication); } if (entity.PhysicalTime != null) { strUpdate += string.Format(" PhysicalTime=to_date('{0}','yyyy-MM-dd'),", entity.PhysicalTime.Value.ToString("yyyy-MM-dd")); } if (!string.IsNullOrWhiteSpace(entity.ComtraindicationName)) { strUpdate += string.Format(" ComtraindicationName='{0}',", entity.ComtraindicationName); } var files = new FileInfoService().GetFiles(keyValue); if (files.Rows.Count > 0) { for (int i = 0; i < ids.Length; i++) { var key = ids[i] + "01"; foreach (DataRow item in files.Rows) { FileInfoEntity itemFile = new FileInfoEntity(); itemFile.FileName = item["FileName"].ToString(); itemFile.FilePath = item["filepath"].ToString(); itemFile.FileSize = item["filesize"].ToString(); itemFile.RecId = key; new FileInfoService().SaveForm("", itemFile); } } } if (!string.IsNullOrWhiteSpace(strUpdate)) { strUpdate = strUpdate.Substring(0, strUpdate.Length - 1); var sql = string.Format("update epg_aptitudeinvestigatepeople set {0} where id in('{1}')", strUpdate, strIds); this.BaseRepository().ExecuteBySql(sql); } }