protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { List <MED_OPERATION_MASTER> operMasterList = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operMaster = operMasterList[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = ModelHelper <MED_PAT_VISIT> .ConvertDataTableToList(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_ANESTHESIA_RECOVER> anesReconver = ModelHelper <MED_ANESTHESIA_RECOVER> .ConvertDataTableToList(dataSource["MED_ANESTHESIA_RECOVER"]); if (anesReconver != null && anesReconver.Count > 0) { operationInfoRepository.SaveAnesRecoverData(anesReconver[0]); } List <MED_ANESTHESIA_INQUIRY> anesInquiry = ModelHelper <MED_ANESTHESIA_INQUIRY> .ConvertDataTableToList(dataSource["MED_ANESTHESIA_INQUIRY"]); if (anesInquiry != null && anesInquiry.Count > 0) { operationInfoRepository.SaveAnesInquiryData(anesInquiry[0]); } List <MED_POSTOPERATIVE_EXTENDED> postExtended = ModelHelper <MED_POSTOPERATIVE_EXTENDED> .ConvertDataTableToList(dataSource["MED_POSTOPERATIVE_EXTENDED"]); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; List <MED_OPERATION_EXTENDED> operExtended = null; List <MED_PREOPERATIVE_EXPANSION> preExpansion = null; operationInfoRepository.SaveMedicalBasicDoc(new { operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); }
public int SaveAnesPlanPmh(MED_ANESTHESIA_PLAN_PMH item) { int result = dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Save(item) == true ? 1 : 0; dapper.SaveChanges(); return(result); }
public RequestResult <MED_ANESTHESIA_PLAN_PMH> GetAnesthesiaPlanPMH(string patID, int visitID, int operID) { MED_ANESTHESIA_PLAN_PMH data = _careDocService.GetAnesthesiaPlanPMH(patID, visitID, operID); if (data == null) { return(Failed <MED_ANESTHESIA_PLAN_PMH>("获取信息错误。")); } else { return(Success(data)); } }
public MED_ANESTHESIA_PLAN_PMH GetAnesthesiaPlanPMH(string patientID, int visitID, int operID) { MED_ANESTHESIA_PLAN_PMH anesPlanPMH = operationInfoRepository.GetAnesPlanPmh(patientID, visitID, operID).Data; if (anesPlanPMH == null) { anesPlanPMH = new MED_ANESTHESIA_PLAN_PMH(); anesPlanPMH.PATIENT_ID = patientID; anesPlanPMH.VISIT_ID = visitID; anesPlanPMH.OPER_ID = operID; } return(anesPlanPMH); }
/// <summary> /// 根据表名从数据库中获取数据 /// </summary> /// <param name="tableName"></param> /// <returns></returns> private DataTable BuildData(string tableName) { string patientId = ExtendApplicationContext.Current.PatientContextExtend.PatientID; int visitId = ExtendApplicationContext.Current.PatientContextExtend.VisitID; int operId = ExtendApplicationContext.Current.PatientContextExtend.OperID; DataTable data = null; switch (tableName) { case "MED_PAT_MONITOR_DATA_EXT": data = ModelHelper <MED_PAT_MONITOR_DATA_EXT> .ConvertListToDataTable(operationInfoRepository.GetPatMonitorExtList(patientId, visitId, operId).Data); break; case "MED_OPERATION_MASTER": data = ModelHelper <MED_OPERATION_MASTER> .ConvertSingleToDataTable(ExtendApplicationContext.Current.MED_OPERATION_MASTER == null ?new MED_OPERATION_MASTER() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId } : operationInfoRepository.GetOperMaster(patientId, visitId, operId).Data); break; case "MED_PAT_MASTER_INDEX": data = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertSingleToDataTable(ExtendApplicationContext.Current.MED_PAT_MASTER_INDEX == null ?new MED_PAT_MASTER_INDEX() { PATIENT_ID = patientId } : operationInfoRepository.GetPatMasterIndex(patientId).Data); break; case "MED_OPERATION_MASTER_EXT": data = ModelHelper <MED_OPERATION_MASTER_EXT> .ConvertSingleToDataTable(operationInfoRepository.GetOperMasterExt(patientId, visitId, operId).Data); if (data.Rows.Count == 0) { MED_OPERATION_MASTER_EXT model = new MED_OPERATION_MASTER_EXT() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_OPERATION_MASTER_EXT> .ConvertSingleToDataTable(model); } break; case "MED_PAT_VISIT": data = ModelHelper <MED_PAT_VISIT> .ConvertSingleToDataTable(operationInfoRepository.GetPatVisit(patientId, visitId).Data); if (data.Rows.Count == 0) { MED_PAT_VISIT model = new MED_PAT_VISIT() { PATIENT_ID = patientId, VISIT_ID = visitId }; data = ModelHelper <MED_PAT_VISIT> .ConvertSingleToDataTable(model); } break; case "MED_PATS_IN_HOSPITAL": data = ModelHelper <MED_PATS_IN_HOSPITAL> .ConvertSingleToDataTable(docDataRepository.GetPatsInHospital(patientId, visitId)); if (data.Rows.Count == 0) { MED_PATS_IN_HOSPITAL model = new MED_PATS_IN_HOSPITAL() { PATIENT_ID = patientId, VISIT_ID = visitId }; data = ModelHelper <MED_PATS_IN_HOSPITAL> .ConvertSingleToDataTable(model); } break; case "MED_SAFETY_CHECKS": data = ModelHelper <MED_SAFETY_CHECKS> .ConvertSingleToDataTable(docDataRepository.GetSafetyCheckData(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_SAFETY_CHECKS model = new MED_SAFETY_CHECKS() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_SAFETY_CHECKS> .ConvertSingleToDataTable(model); } break; case "MED_ANESTHESIA_PLAN": data = ModelHelper <MED_ANESTHESIA_PLAN> .ConvertSingleToDataTable(docDataRepository.GetAnesthesiaPlan(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_ANESTHESIA_PLAN model = new MED_ANESTHESIA_PLAN() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_ANESTHESIA_PLAN> .ConvertSingleToDataTable(model); } break; case "MED_ANESTHESIA_PLAN_PMH": data = ModelHelper <MED_ANESTHESIA_PLAN_PMH> .ConvertSingleToDataTable(docDataRepository.GetAnesthesiaPlanPMH(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_ANESTHESIA_PLAN_PMH model = new MED_ANESTHESIA_PLAN_PMH() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_ANESTHESIA_PLAN_PMH> .ConvertSingleToDataTable(model); } break; case "MED_ANESTHESIA_PLAN_EXAM": data = ModelHelper <MED_ANESTHESIA_PLAN_EXAM> .ConvertSingleToDataTable(docDataRepository.GetAnesthesiaPlanEXAM(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_ANESTHESIA_PLAN_EXAM model = new MED_ANESTHESIA_PLAN_EXAM() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_ANESTHESIA_PLAN_EXAM> .ConvertSingleToDataTable(model); } break; case "MED_ANESTHESIA_RECOVER": data = ModelHelper <MED_ANESTHESIA_RECOVER> .ConvertSingleToDataTable(docDataRepository.GetAnesRecoverData(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_ANESTHESIA_RECOVER model = new MED_ANESTHESIA_RECOVER() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_ANESTHESIA_RECOVER> .ConvertSingleToDataTable(model); } break; case "MED_ANESTHESIA_INQUIRY": data = ModelHelper <MED_ANESTHESIA_INQUIRY> .ConvertSingleToDataTable(docDataRepository.GetAnesInquiry(patientId, visitId, operId, false)); if (data.Rows.Count == 0) { MED_ANESTHESIA_INQUIRY model = new MED_ANESTHESIA_INQUIRY() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_ANESTHESIA_INQUIRY> .ConvertSingleToDataTable(model); } break; case "MED_OPERATION_EXTENDED": data = ModelHelper <MED_OPERATION_EXTENDED> .ConvertListToDataTable(commonRepository.GetOperExtended(patientId, visitId, operId).Data); if (data.Rows.Count == 0) { data.Columns.Add(new DataColumn("PATIENT_ID", typeof(string))); data.Columns.Add(new DataColumn("VISIT_ID", typeof(int))); data.Columns.Add(new DataColumn("OPER_ID", typeof(int))); data.Columns.Add(new DataColumn("ITEM_NAME", typeof(string))); data.Columns.Add(new DataColumn("ITEM_VALUE", typeof(string))); } break; case "MED_POSTOPERATIVE_EXTENDED": data = ModelHelper <MED_POSTOPERATIVE_EXTENDED> .ConvertListToDataTable(commonRepository.GetPostoperativeExtended(patientId, visitId, operId).Data); if (data.Rows.Count == 0) { data.Columns.Add(new DataColumn("PATIENT_ID", typeof(string))); data.Columns.Add(new DataColumn("VISIT_ID", typeof(int))); data.Columns.Add(new DataColumn("OPER_ID", typeof(int))); data.Columns.Add(new DataColumn("ITEM_NAME", typeof(string))); data.Columns.Add(new DataColumn("ITEM_VALUE", typeof(string))); } break; case "MED_PREOPERATIVE_EXPANSION": data = ModelHelper <MED_PREOPERATIVE_EXPANSION> .ConvertListToDataTable(commonRepository.GetPreoperativeExpansion(patientId, visitId, operId).Data); if (data.Rows.Count == 0) { data.Columns.Add(new DataColumn("PATIENT_ID", typeof(string))); data.Columns.Add(new DataColumn("VISIT_ID", typeof(int))); data.Columns.Add(new DataColumn("OPER_ID", typeof(int))); data.Columns.Add(new DataColumn("ITEM_NAME", typeof(string))); data.Columns.Add(new DataColumn("ITEM_VALUE", typeof(string))); } break; case "MED_OPERATION_ANALGESIC_MASTER": data = ModelHelper <MED_OPERATION_ANALGESIC_MASTER> .ConvertSingleToDataTable(docDataRepository.GetAnalgesicMaster(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_OPERATION_ANALGESIC_MASTER model = new MED_OPERATION_ANALGESIC_MASTER() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_OPERATION_ANALGESIC_MASTER> .ConvertSingleToDataTable(model); } break; case "MED_OPER_RISK_ESTIMATE": data = ModelHelper <MED_OPER_RISK_ESTIMATE> .ConvertSingleToDataTable(docDataRepository.GetRickEstimate(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_OPER_RISK_ESTIMATE model = new MED_OPER_RISK_ESTIMATE() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_OPER_RISK_ESTIMATE> .ConvertSingleToDataTable(model); } break; case "MED_OPER_ANALGESIC_MEDICINE": data = ModelHelper <MED_OPER_ANALGESIC_MEDICINE> .ConvertListToDataTable(operationInfoRepository.GetAnalgesicMedicineList(patientId, visitId, operId).Data); break; case "MED_OPER_ANALGESIC_TOTAL": data = ModelHelper <MED_OPER_ANALGESIC_TOTAL> .ConvertListToDataTable(operationInfoRepository.GetAnalgesicTotalList(patientId, visitId, operId).Data); break; case "MED_QIXIE_QINGDIAN": data = ModelHelper <MED_QIXIE_QINGDIAN> .ConvertListToDataTable(operationInfoRepository.GetOperCheckList(patientId, visitId, operId).Data); break; case "MED_ANESTHESIA_INPUT_DATA": data = ModelHelper <MED_ANESTHESIA_INPUT_DATA> .ConvertSingleToDataTable(docDataRepository.GetAnesthestaInputData(patientId, visitId, operId)); if (data.Rows.Count == 0) { MED_ANESTHESIA_INPUT_DATA model = new MED_ANESTHESIA_INPUT_DATA() { PATIENT_ID = patientId, VISIT_ID = visitId, OPER_ID = operId }; data = ModelHelper <MED_ANESTHESIA_INPUT_DATA> .ConvertSingleToDataTable(model); } break; case "MED_BJCA_SIGN": data = ModelHelper <MED_BJCA_SIGN> .ConvertListToDataTable(commonRepository.GetBjcaSignList(patientId, visitId, operId).Data); break; default: throw new NotImplementedException(string.Format("当前未定义从表{0}中获取数据的方法!", tableName)); } return(data); }
public RequestResult <int> SaveAnesPlanPmh(MED_ANESTHESIA_PLAN_PMH item) { return(Success(_pacuOperationInfoService.SaveAnesPlanPmh(item))); }
public RequestResult <bool> SavePatientOperation(dynamic dyParams) { RequestResult <bool> Result = new RequestResult <bool>(); try { List <MED_OPERATION_NAME> operNameOldList = null; List <MED_OPERATION_NAME> operNameNewList = null; MED_OPERATION_MASTER operMaster = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_PAT_MASTER_INDEX patMasterIndex = null; MED_PAT_VISIT patVisit = null; MED_OPERATION_SCHEDULE operSchedlue = null; MED_OPERATION_MASTER_EXT operMasterExt = null; if (dyParams.operSchedlue != null) { string value = dyParams.operSchedlue.ToString(); operSchedlue = JsonConvert.DeserializeObject <MED_OPERATION_SCHEDULE>(value); } if (dyParams.patVisit != null) { string value = dyParams.patVisit.ToString(); patVisit = JsonConvert.DeserializeObject <MED_PAT_VISIT>(value); } if (dyParams.patMasterIndex != null) { string value = dyParams.patMasterIndex.ToString(); patMasterIndex = JsonConvert.DeserializeObject <MED_PAT_MASTER_INDEX>(value); } if (dyParams.operNameOldList != null) { string value = dyParams.operNameOldList.ToString(); operNameOldList = JsonConvert.DeserializeObject <List <MED_OPERATION_NAME> >(value); } if (dyParams.operNameNewList != null) { string value = dyParams.operNameNewList.ToString(); operNameNewList = JsonConvert.DeserializeObject <List <MED_OPERATION_NAME> >(value); } if (dyParams.operMaster != null) { string value = dyParams.operMaster.ToString(); operMaster = JsonConvert.DeserializeObject <MED_OPERATION_MASTER>(value); } if (dyParams.anesPlan != null) { string value = dyParams.anesPlan.ToString(); anesPlan = JsonConvert.DeserializeObject <MED_ANESTHESIA_PLAN>(value); } if (dyParams.anesPlanPmh != null) { string value = dyParams.anesPlanPmh.ToString(); anesPlanPmh = JsonConvert.DeserializeObject <MED_ANESTHESIA_PLAN_PMH>(value); } if (dyParams.anesPlanExam != null) { string value = dyParams.anesPlanExam.ToString(); anesPlanExam = JsonConvert.DeserializeObject <MED_ANESTHESIA_PLAN_EXAM>(value); } if (dyParams.operMasterExt != null) { string value = dyParams.operMasterExt.ToString(); operMasterExt = JsonConvert.DeserializeObject <MED_OPERATION_MASTER_EXT>(value); } Result = Success(_pacuOperationInfoService.SavePatientOperation(operSchedlue, patVisit, patMasterIndex, operNameOldList, operNameNewList, operMaster, anesPlan, anesPlanPmh, anesPlanExam, operMasterExt)); } catch (Exception ex) { Logger.Error("SavePatientOperation:" + ex.Message); } return(Result); }
/// <summary> /// 保存文书基础表Basic table of medical instruments /// </summary> /// <param name="dyParams"></param> /// <returns></returns> /// <summary> public RequestResult <bool> SaveMedicalBasicDoc(dynamic dyParams) { RequestResult <bool> Result = new RequestResult <bool>(); try { MED_OPERATION_MASTER operMaster = null; MED_PAT_MASTER_INDEX patMasterIndex = null; MED_PAT_VISIT patVisit = null; MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; List <MED_OPERATION_EXTENDED> operExtended = null; List <MED_POSTOPERATIVE_EXTENDED> postExtended = null; List <MED_PREOPERATIVE_EXPANSION> preExpansion = null; if (dyParams.operMaster != null) { string value = dyParams.operMaster.ToString(); operMaster = JsonConvert.DeserializeObject <MED_OPERATION_MASTER>(value); } if (dyParams.patMasterIndex != null) { string value = dyParams.patMasterIndex.ToString(); patMasterIndex = JsonConvert.DeserializeObject <MED_PAT_MASTER_INDEX>(value); } if (dyParams.patVisit != null) { string value = dyParams.patVisit.ToString(); patVisit = JsonConvert.DeserializeObject <MED_PAT_VISIT>(value); } if (dyParams.patsInHospital != null) { string value = dyParams.patsInHospital.ToString(); patsInHospital = JsonConvert.DeserializeObject <MED_PATS_IN_HOSPITAL>(value); } if (dyParams.anesPlan != null) { string value = dyParams.anesPlan.ToString(); anesPlan = JsonConvert.DeserializeObject <MED_ANESTHESIA_PLAN>(value); } if (dyParams.anesPlanExam != null) { string value = dyParams.anesPlanExam.ToString(); anesPlanExam = JsonConvert.DeserializeObject <MED_ANESTHESIA_PLAN_EXAM>(value); } if (dyParams.anesPlanPmh != null) { string value = dyParams.anesPlanPmh.ToString(); anesPlanPmh = JsonConvert.DeserializeObject <MED_ANESTHESIA_PLAN_PMH>(value); } if (dyParams.operExtended != null) { string value = dyParams.operExtended.ToString(); operExtended = JsonConvert.DeserializeObject <List <MED_OPERATION_EXTENDED> >(value); } if (dyParams.postExtended != null) { string value = dyParams.postExtended.ToString(); postExtended = JsonConvert.DeserializeObject <List <MED_POSTOPERATIVE_EXTENDED> >(value); } if (dyParams.preExpansion != null) { string value = dyParams.preExpansion.ToString(); preExpansion = JsonConvert.DeserializeObject <List <MED_PREOPERATIVE_EXPANSION> >(value); } Result = Success(_pacuOperationInfoService.SaveMedicalBasicDoc(operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion)); } catch (Exception ex) { Logger.Error("SaveMedicalBasicDoc:" + ex.Message); } return(Result); }
private MED_OPERATION_SCHEDULE setOperationSubmit(string sql_GetMaxOperationNo, MED_OPERATION_SCHEDULE item) { MED_OPERATION_SCHEDULE dbSCHEDULE = dapper.Set <MED_OPERATION_SCHEDULE>().Single(item); //判断收到已经提交 if (dbSCHEDULE.OPER_STATUS_CODE == 1) //实时判断,没提交才能判断 { #region 获取MED_OPERATION_SCHEDULE_NAME表数据 List <MED_OPERATION_SCHEDULE_NAME> scheduleNameItemList = dapper.Set <MED_OPERATION_SCHEDULE_NAME>().Select(d => d.PATIENT_ID == item.PATIENT_ID && d.VISIT_ID == item.VISIT_ID && d.SCHEDULE_ID == item.SCHEDULE_ID).OrderBy(d => d.OPER_NO).ToList <MED_OPERATION_SCHEDULE_NAME>(); #endregion int OperationNo = GetMaxOperationNo(sql_GetMaxOperationNo, item); string tempOperationName = string.Empty; #region 向MED_OPERATION_NAME表插入数据 List <MED_OPERATION_NAME> operNameItemList = new List <MED_OPERATION_NAME>(); foreach (MED_OPERATION_SCHEDULE_NAME scheduleNameItem in scheduleNameItemList) { MED_OPERATION_NAME operNameItem = new MED_OPERATION_NAME(); operNameItem.PATIENT_ID = scheduleNameItem.PATIENT_ID; operNameItem.VISIT_ID = scheduleNameItem.VISIT_ID; operNameItem.OPER_ID = item.OPER_ID; operNameItem.OPER_NO = ++OperationNo; operNameItem.OPER_NAME = scheduleNameItem.OPER_NAME; operNameItem.OPER_CODE = scheduleNameItem.OPER_CODE; operNameItem.OPER_SCALE = scheduleNameItem.OPER_SCALE; operNameItem.WOUND_TYPE = scheduleNameItem.WOUND_TYPE; operNameItem.RESERVED1 = scheduleNameItem.RESERVED1; operNameItem.RESERVED2 = scheduleNameItem.RESERVED2; operNameItem.RESERVED3 = scheduleNameItem.RESERVED3; operNameItem.RESERVED4 = scheduleNameItem.RESERVED4; operNameItemList.Add(operNameItem); tempOperationName += "," + scheduleNameItem.RESERVED2 + scheduleNameItem.OPER_NAME; } dapper.Set <MED_OPERATION_NAME>().Insert(operNameItemList); #endregion tempOperationName = tempOperationName.TrimStart(','); #region 向MED_OPERATION_MASTER表插入数据 MED_OPERATION_MASTER masterITEM = new MED_OPERATION_MASTER { PATIENT_ID = item.PATIENT_ID, VISIT_ID = item.VISIT_ID, OPER_ID = Convert.ToInt32(item.OPER_ID), HOSP_BRANCH = item.HOSP_BRANCH, WARD_CODE = item.WARD_CODE, DEPT_CODE = item.DEPT_CODE, OPER_DEPT_CODE = item.OPER_DEPT_CODE, OPER_ROOM = item.OPER_ROOM, OPER_ROOM_NO = item.OPER_ROOM_NO, SEQUENCE = item.SEQUENCE, OPER_CLASS = item.OPER_CLASS, DIAG_BEFORE_OPERATION = item.DIAG_BEFORE_OPERATION, DIAG_AFTER_OPERATION = item.DIAG_BEFORE_OPERATION, PATIENT_CONDITION = item.PATIENT_CONDITION, OPER_SCALE = item.OPER_SCALE, WOUND_TYPE = item.WOUND_TYPE, ASA_GRADE = item.ASA_GRADE, EMERGENCY_IND = item.EMERGENCY_IND, OPER_SOURCE = item.OPER_SOURCE, ISOLATION_IND = item.ISOLATION_IND, INFECTED_IND = item.INFECTED_IND, RADIATE_IND = item.RADIATE_IND, SURGEON = item.SURGEON, FIRST_OPER_ASSISTANT = item.FIRST_OPER_ASSISTANT, SECOND_OPER_ASSISTANT = item.SECOND_OPER_ASSISTANT, THIRD_OPER_ASSISTANT = item.THIRD_OPER_ASSISTANT, FOURTH_OPER_ASSISTANT = item.FOURTH_OPER_ASSISTANT, ANES_METHOD = item.ANES_METHOD, ANES_DOCTOR = item.ANES_DOCTOR, FIRST_ANES_ASSISTANT = item.FIRST_ANES_ASSISTANT, SECOND_ANES_ASSISTANT = item.SECOND_ANES_ASSISTANT, THIRD_ANES_ASSISTANT = item.THIRD_ANES_ASSISTANT, FOURTH_ANES_ASSISTANT = item.FOURTH_ANES_ASSISTANT, FIRST_ANES_NURSE = item.FIRST_ANES_NURSE, SECOND_ANES_NURSE = item.SECOND_ANES_NURSE, THIRD_ANES_NURSE = item.THIRD_ANES_NURSE, CPB_DOCTOR = item.CPB_DOCTOR, FIRST_CPB_ASSISTANT = item.FIRST_CPB_ASSISTANT, SECOND_CPB_ASSISTANT = item.SECOND_CPB_ASSISTANT, THIRD_CPB_ASSISTANT = item.THIRD_CPB_ASSISTANT, FOURTH_CPB_ASSISTANT = item.FOURTH_CPB_ASSISTANT, FIRST_OPER_NURSE = item.FIRST_OPER_NURSE, SECOND_OPER_NURSE = item.SECOND_OPER_NURSE, THIRD_OPER_NURSE = item.THIRD_OPER_NURSE, FOURTH_OPER_NURSE = item.FOURTH_OPER_NURSE, FIRST_SUPPLY_NURSE = item.FIRST_SUPPLY_NURSE, SECOND_SUPPLY_NURSE = item.SECOND_SUPPLY_NURSE, THIRD_SUPPLY_NURSE = item.THIRD_SUPPLY_NURSE, FOURTH_SUPPLY_NURSE = item.FOURTH_SUPPLY_NURSE, PACU_DOCTOR = item.PACU_DOCTOR, FIRST_PACU_ASSISTANT = item.FIRST_PACU_ASSISTANT, SECOND_PACU_ASSISTANT = item.SECOND_PACU_ASSISTANT, FIRST_PACU_NURSE = item.FIRST_PACU_NURSE, SECOND_PACU_NURSE = item.SECOND_PACU_NURSE, REQ_DATE_TIME = item.REQ_DATE_TIME, SCHEDULED_DATE_TIME = item.SCHEDULED_DATE_TIME, OPER_POSITION = item.OPER_POSITION, BED_NO = item.BED_NO, OPERATION_NAME = tempOperationName, SPECIAL_EQUIPMENT = item.SPECIAL_EQUIPMENT, SPECIAL_INFECT = item.SPECIAL_INFECT, OPER_STATUS_CODE = item.OPER_STATUS_CODE, HIS_PATIENT_ID = item.HIS_PATIENT_ID, HIS_VISIT_ID = item.HIS_VISIT_ID, HIS_SCHEDULE_ID = item.HIS_SCHEDULE_ID, HIS_OPER_STATUS = item.HIS_OPER_STATUS, MEMO = item.NOTES_ON_OPERATION }; bool flag = dapper.Set <MED_OPERATION_MASTER>().Insert(masterITEM); #endregion item.OPERATION_NAME = tempOperationName; dapper.Set <MED_OPERATION_SCHEDULE>().Update(item, d => new { d.ANES_CONFIRM, d.NURSE_CONFIRM, d.OPER_STATUS_CODE, d.OPER_ID, d.OPERATION_NAME, d.ANES_DOCTOR }); if (flag) { //确认成功后,从visit表中往plan表中写入手术名称,身高体重数据 MED_ANESTHESIA_PLAN anesPlan = dapper.Set <MED_ANESTHESIA_PLAN>().Single(d => d.PATIENT_ID == masterITEM.PATIENT_ID && d.VISIT_ID == masterITEM.VISIT_ID && d.OPER_ID == masterITEM.OPER_ID); if (anesPlan == null) { anesPlan = new MED_ANESTHESIA_PLAN(); anesPlan.PATIENT_ID = masterITEM.PATIENT_ID; anesPlan.VISIT_ID = masterITEM.VISIT_ID; anesPlan.OPER_ID = masterITEM.OPER_ID; } if (!string.IsNullOrEmpty(masterITEM.OPERATION_NAME)) { anesPlan.OPERATION_NAME = masterITEM.OPERATION_NAME; } dapper.Set <MED_ANESTHESIA_PLAN>().Save(anesPlan, d => d.PATIENT_ID == masterITEM.PATIENT_ID && d.VISIT_ID == masterITEM.VISIT_ID && d.OPER_ID == masterITEM.OPER_ID); MED_ANESTHESIA_PLAN_PMH anesPlanPmh = dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Single(d => d.PATIENT_ID == masterITEM.PATIENT_ID && d.VISIT_ID == masterITEM.VISIT_ID && d.OPER_ID == masterITEM.OPER_ID); MED_PAT_VISIT patVisit = dapper.Set <MED_PAT_VISIT>().Single(d => d.PATIENT_ID == masterITEM.PATIENT_ID && d.VISIT_ID == masterITEM.VISIT_ID); if (anesPlanPmh == null) { anesPlanPmh = new MED_ANESTHESIA_PLAN_PMH(); anesPlanPmh.PATIENT_ID = masterITEM.PATIENT_ID; anesPlanPmh.VISIT_ID = masterITEM.VISIT_ID; anesPlanPmh.OPER_ID = masterITEM.OPER_ID; if (patVisit != null) { anesPlanPmh.HEIGHT = patVisit.BODY_HEIGHT.HasValue ? patVisit.BODY_HEIGHT.Value.ToString() : ""; anesPlanPmh.WEIGHT = patVisit.BODY_WEIGHT.HasValue ? patVisit.BODY_WEIGHT.Value.ToString() : ""; anesPlanPmh.BLOOD_TYPE = patVisit.BLOOD_TYPE + " " + patVisit.BLOOD_TYPE_RH; } } else { if (patVisit != null) { anesPlanPmh.HEIGHT = patVisit.BODY_HEIGHT.HasValue ? patVisit.BODY_HEIGHT.Value.ToString() : "";; anesPlanPmh.WEIGHT = patVisit.BODY_WEIGHT.HasValue ? patVisit.BODY_WEIGHT.Value.ToString() : "";; anesPlanPmh.BLOOD_TYPE = patVisit.BLOOD_TYPE + " " + patVisit.BLOOD_TYPE_RH; } } dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Save(anesPlanPmh, d => d.PATIENT_ID == anesPlanPmh.PATIENT_ID && d.VISIT_ID == anesPlanPmh.VISIT_ID && d.OPER_ID == anesPlanPmh.OPER_ID); dapper.SaveChanges(); return(item); } } return(null); }
protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { List <MED_OPERATION_MASTER> operMasterList = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operMaster = operMasterList[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = ModelHelper <MED_PAT_VISIT> .ConvertDataTableToList(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_ANESTHESIA_PLAN> anesPlanList = ModelHelper <MED_ANESTHESIA_PLAN> .ConvertDataTableToList(dataSource["MED_ANESTHESIA_PLAN"]); MED_ANESTHESIA_PLAN anesPlan = null; if (anesPlanList != null && anesPlanList.Count > 0) { anesPlan = anesPlanList[0]; } List <MED_ANESTHESIA_PLAN_PMH> anesPlanPMHList = ModelHelper <MED_ANESTHESIA_PLAN_PMH> .ConvertDataTableToList(dataSource["MED_ANESTHESIA_PLAN_PMH"]); MED_ANESTHESIA_PLAN_PMH anesPlanPMH = null; if (anesPlanPMHList != null && anesPlanPMHList.Count > 0) { anesPlanPMH = anesPlanPMHList[0]; } List <MED_PREOPERATIVE_EXPANSION> preExpansion = ModelHelper <MED_PREOPERATIVE_EXPANSION> .ConvertDataTableToList(dataSource["MED_PREOPERATIVE_EXPANSION"]); List <MED_SAFETY_CHECKS> safetyCheck = ModelHelper <MED_SAFETY_CHECKS> .ConvertDataTableToList(dataSource["MED_SAFETY_CHECKS"]); if (safetyCheck != null && safetyCheck.Count > 0) { operationInfoRepository.SaveSafetyCheck(safetyCheck[0]); } List <MED_OPER_RISK_ESTIMATE> riskEstimate = ModelHelper <MED_OPER_RISK_ESTIMATE> .ConvertDataTableToList(dataSource["MED_OPER_RISK_ESTIMATE"]); if (riskEstimate != null && riskEstimate.Count > 0) { operationInfoRepository.SaveRickEstimate(riskEstimate[0]); } //OperationInfoService.SaveMedicalBasicDoc(operMaster, patIndex, patVisit, null, anesPlan, null, anesPlanPMH, null, null, preExpansion); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; List <MED_OPERATION_EXTENDED> operExtended = null; List <MED_POSTOPERATIVE_EXTENDED> postExtended = null; operationInfoRepository.SaveMedicalBasicDoc(new { operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); }
protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { if (isRoomnoORSequenceChanged) { Dialog.MessageBox("温馨提示:修改手术间号和台次将会影响当前已安排手术,请结合实际情况修改。"); } base.OnSaveData(dataSource); List <MED_OPERATION_MASTER> operMasterList = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operationMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operationMaster = operMasterList[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } //OperationInfoService.SaveMedicalBasicDoc(operationMaster, patIndex, null, null, null, null, null, null, null, null); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; List <MED_OPERATION_EXTENDED> operExtended = null; List <MED_POSTOPERATIVE_EXTENDED> postExtended = null; List <MED_PREOPERATIVE_EXPANSION> preExpansion = null; MED_PAT_VISIT patVisit = null; operationInfoRepository.SaveMedicalBasicDoc(new { operationMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); if (ExtendApplicationContext.Current.PatientInformationExtend.OPER_ROOM_NO != operationMaster.OPER_ROOM_NO) { ExtendApplicationContext.Current.PatientInformationExtend.OPER_ROOM_NO = operationMaster.OPER_ROOM_NO; } if (operationMaster.SEQUENCE.HasValue && ExtendApplicationContext.Current.PatientInformationExtend.SEQUENCE != operationMaster.SEQUENCE) { ExtendApplicationContext.Current.PatientInformationExtend.SEQUENCE = operationMaster.SEQUENCE; } //台次 if (operationMaster.EMERGENCY_IND.HasValue && ExtendApplicationContext.Current.PatientInformationExtend.EMERGENCY_IND != operationMaster.EMERGENCY_IND) { ExtendApplicationContext.Current.PatientInformationExtend.EMERGENCY_IND = operationMaster.EMERGENCY_IND; } if (operationMaster.ISOLATION_IND.HasValue && ExtendApplicationContext.Current.PatientInformationExtend.ISOLATION_IND != operationMaster.EMERGENCY_IND) { ExtendApplicationContext.Current.PatientInformationExtend.ISOLATION_IND = operationMaster.ISOLATION_IND; } }
public bool SaveMedicalBasicDoc(MED_OPERATION_MASTER operMaster, MED_PAT_MASTER_INDEX patMasterIndex, MED_PAT_VISIT patVisit, MED_PATS_IN_HOSPITAL patsInHospital, MED_ANESTHESIA_PLAN anesPlan, MED_ANESTHESIA_PLAN_EXAM anesPlanExam, MED_ANESTHESIA_PLAN_PMH anesPlanPmh, List <MED_OPERATION_EXTENDED> operExtended, List <MED_POSTOPERATIVE_EXTENDED> postExtended, List <MED_PREOPERATIVE_EXPANSION> preExpansion) { bool flag = true; if (operMaster != null) { flag = flag & dapper.Set <MED_OPERATION_MASTER>().Save(operMaster); } if (patVisit != null) { flag = flag & dapper.Set <MED_PAT_VISIT>().Save(patVisit); } if (patMasterIndex != null) { flag = flag & dapper.Set <MED_PAT_MASTER_INDEX>().Save(patMasterIndex); } if (patsInHospital != null) { flag = flag & dapper.Set <MED_PATS_IN_HOSPITAL>().Save(patsInHospital); } if (anesPlan != null) { flag = flag & dapper.Set <MED_ANESTHESIA_PLAN>().Save(anesPlan); } if (anesPlanPmh != null) { flag = flag & dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Save(anesPlanPmh); } if (anesPlanExam != null) { flag = flag & dapper.Set <MED_ANESTHESIA_PLAN_EXAM>().Save(anesPlanExam); } if (operExtended != null && operExtended.Count > 0) { flag = flag & dapper.Set <MED_OPERATION_EXTENDED>().Save(operExtended) > 0 ? true : false; //foreach (var item in operExtended) //{ // flag = flag & dapper.Set<MED_OPERATION_EXTENDED>().Save(item); //} } if (postExtended != null && postExtended.Count > 0) { flag = flag & dapper.Set <MED_POSTOPERATIVE_EXTENDED>().Save(postExtended) > 0 ? true : false; //foreach (var item in postExtended) //{ // flag = flag & dapper.Set<MED_POSTOPERATIVE_EXTENDED>().Save(item); //} } if (preExpansion != null && preExpansion.Count > 0) { flag = flag & dapper.Set <MED_PREOPERATIVE_EXPANSION>().Save(preExpansion) > 0 ? true : false; //foreach (var item in preExpansion) //{ // flag = flag & dapper.Set<MED_PREOPERATIVE_EXPANSION>().Save(item); //} } if (flag) { dapper.SaveChanges(); } return(flag); }
/// <summary> /// 数据保存 /// </summary> /// <param name="dataSource"></param> protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { base.OnSaveData(dataSource); List <MED_OPERATION_MASTER> operMasterList = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operMaster = operMasterList[0]; if (!operMaster.OUT_PACU_DATE_TIME.HasValue && operMaster.OPER_STATUS_CODE == (int)OperationStatus.InPACU) { MED_OPERATION_MASTER master = operationInfoRepository.GetOperMaster(ExtendApplicationContext.Current.PatientContextExtend.PatientID, ExtendApplicationContext.Current.PatientContextExtend.VisitID, ExtendApplicationContext.Current.PatientContextExtend.OperID).Data; if (master.OUT_PACU_DATE_TIME.HasValue) { operMaster.OUT_PACU_DATE_TIME = master.OUT_PACU_DATE_TIME; operMaster.OPER_STATUS_CODE = master.OPER_STATUS_CODE; } } if (operMaster.IN_PACU_DATE_TIME.HasValue && !operMaster.OUT_PACU_DATE_TIME.HasValue) { operMaster.OPER_STATUS_CODE = 45; } } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = ModelHelper <MED_PAT_VISIT> .ConvertDataTableToList(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_ANESTHESIA_PLAN> anesPlanList = ModelHelper <MED_ANESTHESIA_PLAN> .ConvertDataTableToList(dataSource["MED_ANESTHESIA_PLAN"]); MED_ANESTHESIA_PLAN anesPlan = null; if (anesPlanList != null && anesPlanList.Count > 0) { anesPlan = anesPlanList[0]; } List <MED_ANESTHESIA_PLAN_PMH> anesPlanPMHList = ModelHelper <MED_ANESTHESIA_PLAN_PMH> .ConvertDataTableToList(dataSource["MED_ANESTHESIA_PLAN_PMH"]); MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; if (anesPlanPMHList != null && anesPlanPMHList.Count > 0) { anesPlanPmh = anesPlanPMHList[0]; } List <MED_OPERATION_EXTENDED> operExtended = ModelHelper <MED_OPERATION_EXTENDED> .ConvertDataTableToList(dataSource["MED_OPERATION_EXTENDED"]); List <MED_POSTOPERATIVE_EXTENDED> postExtended = ModelHelper <MED_POSTOPERATIVE_EXTENDED> .ConvertDataTableToList(dataSource["MED_POSTOPERATIVE_EXTENDED"]); //OperationInfoService.SaveMedicalBasicDoc(operMaster, patIndex, patVisit, null, anesPlan, null, anesPlanPMH, operExtended, posExtended, null); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; List <MED_PREOPERATIVE_EXPANSION> preExpansion = null; operationInfoRepository.SaveMedicalBasicDoc(new { operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); foreach (IUIElementHandler handler in _UIElementHandlers) { if (handler.GetControlType == typeof(MedVitalSignGraph) && handler.GetCurrentControl != null) { MedVitalSignGraph vitalSign = handler.GetCurrentControl as MedVitalSignGraph; if (vitalSign.NewMonitorData != null) { vitalSign.NewMonitorData.Save(); } } } }
/// <summary> /// 保存麻醉计划表 术前访视(病史) /// </summary> /// <returns><![CDATA[RequestResult<string>]]></returns> public RequestResult <int> SaveAnesPlanPmh(MED_ANESTHESIA_PLAN_PMH item) { string address = "PacuOperationInfo/SaveAnesPlanPmh"; return(BaseRepository.PostCallApi <MED_ANESTHESIA_PLAN_PMH>(address, item)); }
protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { base.OnSaveData(dataSource); List <MED_OPERATION_MASTER> operationMasterDataTable = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER masterRow = operationMasterDataTable.Count > 0 ? operationMasterDataTable[0] : null; if (txtOutRoomTime.Text != "" && masterRow != null) { if (!string.IsNullOrEmpty(masterRow.OPER_STATUS_CODE.ToString()) || masterRow.OPER_STATUS_CODE < (int)OperationStatus.OutOperationRoom) { masterRow.ANES_START_TIME = masterRow.START_DATE_TIME; masterRow.ANES_END_TIME = masterRow.END_DATE_TIME; masterRow.OPER_STATUS_CODE = (int)OperationStatus.OutOperationRoom; ExtendApplicationContext.Current.PatientInformationExtend.IN_DATE_TIME = masterRow.IN_DATE_TIME; ExtendApplicationContext.Current.PatientInformationExtend.OUT_DATE_TIME = masterRow.OUT_DATE_TIME; ExtendApplicationContext.Current.PatientInformationExtend.START_DATE_TIME = masterRow.START_DATE_TIME; ExtendApplicationContext.Current.PatientInformationExtend.END_DATE_TIME = masterRow.END_DATE_TIME; ExtendApplicationContext.Current.PatientInformationExtend.OPER_STATUS_CODE = masterRow.OPER_STATUS_CODE; ExtendApplicationContext.Current.OperationStatus = OperationStatus.OutOperationRoom; } } ExtendApplicationContext.Current.PatientInformationExtend.OPER_ROOM_NO = masterRow.OPER_ROOM_NO; MED_OPERATION_MASTER operMaster = null; if (operationMasterDataTable != null && operationMasterDataTable.Count > 0) { operMaster = operationMasterDataTable[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = ModelHelper <MED_PAT_VISIT> .ConvertDataTableToList(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_OPERATION_EXTENDED> operExtended = ModelHelper <MED_OPERATION_EXTENDED> .ConvertDataTableToList(dataSource["MED_OPERATION_EXTENDED"]); //OperationInfoService.SaveMedicalBasicDoc(operMaster, patIndex, patVisit, null, null, null, null, operExtended, null, null); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; List <MED_POSTOPERATIVE_EXTENDED> postExtended = null; List <MED_PREOPERATIVE_EXPANSION> preExpansion = null; operationInfoRepository.SaveMedicalBasicDoc(new { operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); }
protected override void OnSaveData(Dictionary <string, DataTable> dataSource)//, ref bool bNeedMsg { foreach (MTextBox mtb in textBoxs) { if (string.IsNullOrEmpty(mtb.Text) && !string.IsNullOrEmpty(mtb.InputNeededMessage)) { MessageBoxFormPC.Show("*号为必填项目,请重新填写"); // bNeedMsg = false; return; } } string patientID = BindControls("MED_PAT_MASTER_INDEX", "PATIENT_ID"); if (operationMaster == null) { operationMaster = new MED_OPERATION_MASTER(); } operationMaster.SetValue("PATIENT_ID", patientID); operationMaster.SetValue("VISIT_ID", visitID); operationMaster.SetValue("OPER_ID", operID); operationMaster.SetValue("OPER_ROOM", ExtendAppContext.CurntSelect.OperRoom); operationMaster.SetValue("HOSP_BRANCH", ExtendAppContext.CurntSelect.HospBranchCode); operationMaster.SetValue("EMERGENCY_IND", BindControls("MED_OPERATION_MASTER", "EMERGENCY_IND")); operationMaster.SetValue("DEPT_CODE", BindControls("MED_OPERATION_MASTER", "DEPT_CODE")); operationMaster.SetValue("BED_NO", BindControls("MED_OPERATION_MASTER", "BED_NO")); operationMaster.SetValue("SCHEDULED_DATE_TIME", BindControls("MED_OPERATION_MASTER", "SCHEDULED_DATE_TIME")); operationMaster.SetValue("OPER_ROOM_NO", BindControls("MED_OPERATION_MASTER", "OPER_ROOM_NO")); operationMaster.SetValue("SEQUENCE", BindControls("MED_OPERATION_MASTER", "SEQUENCE")); operationMaster.SetValue("ANES_DOCTOR", BindControls("MED_OPERATION_MASTER", "ANES_DOCTOR")); operationMaster.SetValue("DIAG_BEFORE_OPERATION", BindControls("MED_OPERATION_MASTER", "DIAG_BEFORE_OPERATION")); operationMaster.SetValue("OPERATION_NAME", BindControls("MED_OPERATION_MASTER", "OPERATION_NAME")); operationMaster.SetValue("OPER_STATUS_CODE", 2); if (currentOperSchedule != null) { currentOperSchedule.SetValue("OPER_STATUS_CODE", 2); } if (patVisit == null) { patVisit = new MED_PAT_VISIT(); } patVisit.SetValue("PATIENT_ID", patientID); patVisit.SetValue("VISIT_ID", visitID); patVisit.SetValue("INP_NO", BindControls("MED_PATS_IN_HOSPITAL", "INP_NO")); if (patMasterIndex == null) { patMasterIndex = new MED_PAT_MASTER_INDEX(); } patMasterIndex.SetValue("PATIENT_ID", patientID); patMasterIndex.SetValue("NAME", BindControls("MED_PAT_MASTER_INDEX", "NAME")); patMasterIndex.SetValue("SEX", BindControls("MED_PAT_MASTER_INDEX", "SEX")); patMasterIndex.SetValue("DATE_OF_BIRTH", BindControls("MED_PAT_MASTER_INDEX", "DATE_OF_BIRTH")); string strOperName = BindControls("MED_OPERATION_MASTER", "OPER_NAME"); if (!string.IsNullOrEmpty(strOperName)) { string[] operNameArr = strOperName.Split('+'); for (int i = 0; i < operNameArr.Length; i++) { MED_OPERATION_NAME operName = new MED_OPERATION_NAME(); operName.SetValue("PATIENT_ID", operationMaster.PATIENT_ID); operName.SetValue("VISIT_ID", operationMaster.VISIT_ID); operName.SetValue("OPER_ID", operationMaster.OPER_ID); operName.SetValue("OPER_NO", i + 1); operName.SetValue("OPER_NAME", operNameArr[i].ToString()); operNameNewList.Add(operName); } } MED_ANESTHESIA_PLAN anesPlan = OperationInfoService.GetAnesPlan(patientID, visitID, operID); MED_ANESTHESIA_PLAN_PMH anesPlanPmh = OperationInfoService.GetAnesPlanPmh(patientID, visitID, operID); MED_ANESTHESIA_PLAN_EXAM anesPlanExam = OperationInfoService.GetAnesPlanExam(patientID, visitID, operID); if (anesPlan == null) { anesPlan = new MED_ANESTHESIA_PLAN(); anesPlan.SetValue("PATIENT_ID", patientID); anesPlan.SetValue("VISIT_ID", visitID); anesPlan.SetValue("OPER_ID", operID); } if (anesPlanPmh == null) { anesPlanPmh = new MED_ANESTHESIA_PLAN_PMH(); anesPlanPmh.SetValue("PATIENT_ID", patientID); anesPlanPmh.SetValue("VISIT_ID", visitID); anesPlanPmh.SetValue("OPER_ID", operID); } if (anesPlanExam == null) { anesPlanExam = new MED_ANESTHESIA_PLAN_EXAM(); anesPlanExam.SetValue("PATIENT_ID", patientID); anesPlanExam.SetValue("VISIT_ID", visitID); anesPlanExam.SetValue("OPER_ID", operID); } OperationInfoService.SavePatientOperation(currentOperSchedule, patVisit, patMasterIndex, null, operNameNewList, operationMaster, anesPlan, anesPlanPmh, anesPlanExam, null); }
/// <summary> /// 保存手术室外麻醉 /// </summary> /// <param name="model"></param> /// <returns></returns> public int SaveOutOperatingRoomAnesRecordData(OutOperatingRoomAnesRecordEntity model) { if (model == null) { return(0); } try { if (string.IsNullOrEmpty(model.PATIENT_ID)) { model.PATIENT_ID = model.INP_NO; } //获取master主表是否有改挑手术 MED_OPERATION_MASTER operationMaster = dapper.Set <MED_OPERATION_MASTER>().Single( x => x.PATIENT_ID == model.PATIENT_ID && x.VISIT_ID == model.VISIT_ID && x.OPER_ID == model.OPER_ID); int result = 0; if (operationMaster != null) { operationMaster.DEPT_CODE = model.DEPT_CODE; operationMaster.DIAG_BEFORE_OPERATION = model.DIAG_BEFORE_OPERATION; operationMaster.OPERATION_NAME = model.OPERATION_NAME; operationMaster.ANES_METHOD = model.ANES_METHOD; operationMaster.ANES_DOCTOR = model.ANES_DOCTOR; operationMaster.FIRST_ANES_ASSISTANT = model.FIRST_ANES_ASSISTANT; operationMaster.FIRST_OPER_NURSE = model.FIRST_OPER_NURSE; operationMaster.SECOND_OPER_NURSE = model.SECOND_OPER_NURSE; operationMaster.ASA_GRADE = model.ASA_GRADE; operationMaster.EMERGENCY_IND = Convert.ToInt32(model.EMERGENCY_IND); operationMaster.IN_DATE_TIME = model.IN_DATE_TIME; operationMaster.START_DATE_TIME = model.START_DATE_TIME; operationMaster.END_DATE_TIME = model.END_DATE_TIME; operationMaster.OUT_DATE_TIME = model.OUT_DATE_TIME; operationMaster.LOCAL_ANESTHESIA = 1; operationMaster.OPER_STATUS_CODE = 35; operationMaster.OPER_ROOM = model.OPER_ROOM; operationMaster.OPER_ROOM_NO = model.OPER_ROOM_NO; operationMaster.OPER_SCALE = model.OPER_SCALE; operationMaster.SURGEON = model.SURGEON; operationMaster.FIRST_OPER_ASSISTANT = model.FIRST_OPER_ASSISTANT; result = dapper.Set <MED_OPERATION_MASTER>().Update(operationMaster) > 0 ? 1 : 0; } else { MED_OPERATION_MASTER newModel = new MED_OPERATION_MASTER(); newModel.PATIENT_ID = model.PATIENT_ID; newModel.VISIT_ID = model.VISIT_ID; newModel.OPER_ID = model.OPER_ID; newModel.DEPT_CODE = model.DEPT_CODE; newModel.DIAG_BEFORE_OPERATION = model.DIAG_BEFORE_OPERATION; newModel.OPERATION_NAME = model.OPERATION_NAME; newModel.ANES_METHOD = model.ANES_METHOD; newModel.ANES_DOCTOR = model.ANES_DOCTOR; newModel.FIRST_ANES_ASSISTANT = model.FIRST_ANES_ASSISTANT; newModel.FIRST_OPER_NURSE = model.FIRST_OPER_NURSE; newModel.SECOND_OPER_NURSE = model.SECOND_OPER_NURSE; newModel.ASA_GRADE = model.ASA_GRADE; newModel.EMERGENCY_IND = Convert.ToInt32(model.EMERGENCY_IND); newModel.IN_DATE_TIME = model.IN_DATE_TIME; newModel.SCHEDULED_DATE_TIME = model.SCHEDULED_DATE_TIME; newModel.START_DATE_TIME = model.START_DATE_TIME; newModel.END_DATE_TIME = model.END_DATE_TIME; newModel.OUT_DATE_TIME = model.OUT_DATE_TIME; newModel.LOCAL_ANESTHESIA = 1; newModel.OPER_STATUS_CODE = 35; newModel.OPER_ROOM = model.OPER_ROOM; newModel.OPER_ROOM_NO = model.OPER_ROOM_NO; newModel.OPER_SCALE = model.OPER_SCALE; newModel.SURGEON = model.SURGEON; newModel.FIRST_OPER_ASSISTANT = model.FIRST_OPER_ASSISTANT; result = dapper.Set <MED_OPERATION_MASTER>().Insert(newModel) == true ? 1 : 0; } //手术名称表(先删再增) //删除模版 dapper.Set <MED_OPERATION_NAME>().Delete(d => d.PATIENT_ID == model.PATIENT_ID && d.VISIT_ID == model.VISIT_ID && d.OPER_ID == model.OPER_ID); if (!string.IsNullOrEmpty(model.OPERATION_NAME)) { string[] operNames = model.OPERATION_NAME.Split('+'); for (int i = 1; i <= operNames.Length; i++) { MED_OPERATION_NAME operNameModel = new MED_OPERATION_NAME(); operNameModel.PATIENT_ID = model.PATIENT_ID; operNameModel.VISIT_ID = model.VISIT_ID; operNameModel.OPER_ID = model.OPER_ID; operNameModel.OPER_NO = i; operNameModel.OPER_NAME = operNames[i - 1]; dapper.Set <MED_OPERATION_NAME>().Insert(operNameModel); } } //室外麻醉手术在输入出手术室时间点击保存后,需要把对应的schedule表状态改为4, string OPER_STATUS_CODE = "" ; MED_OPERATION_SCHEDULE scheduleModel = dapper.Set <MED_OPERATION_SCHEDULE>().Single( x => x.PATIENT_ID == model.PATIENT_ID && x.VISIT_ID == model.VISIT_ID && x.OPER_ID == model.OPER_ID); if (scheduleModel != null) { OPER_STATUS_CODE = scheduleModel.OPER_STATUS_CODE.ToString(); scheduleModel.OPER_STATUS_CODE = 4; scheduleModel.ModelStatus = ModelStatus.Modeified; dapper.Set <MED_OPERATION_SCHEDULE>().Update(scheduleModel); } //修改扩展 体重 MED_ANESTHESIA_PLAN_PMH phmModel = dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Single( x => x.PATIENT_ID == model.PATIENT_ID && x.VISIT_ID == model.VISIT_ID && x.OPER_ID == model.OPER_ID); if (phmModel != null) { phmModel.WEIGHT = model.WEIGHT; dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Update(phmModel); } else { phmModel = new MED_ANESTHESIA_PLAN_PMH(); phmModel.PATIENT_ID = model.PATIENT_ID; phmModel.VISIT_ID = model.VISIT_ID; phmModel.OPER_ID = model.OPER_ID; phmModel.WEIGHT = model.WEIGHT; dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Save(phmModel); } dapper.SaveChanges(); //调用HISHIS203回写手术主表信息 //if (OPER_STATUS_CODE != "4") //回写之后不再回写 //{ // if (SyncHIS203(model.PATIENT_ID, model.VISIT_ID,model.OPER_ID) != "") // { // return 2; // } //} } catch (Exception ex) { return(0); } return(1); }
private List <KeyValue> GetFieldNames(string tableName) { List <KeyValue> list = new List <KeyValue>(); DataTable dataTable = new DataTable(); if (tableName.ToUpper().Trim().Equals("MED_OPERATION_MASTER")) { MED_OPERATION_MASTER master = new MED_OPERATION_MASTER(); foreach (string column in master.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPERATION_MASTER_EXT")) { MED_OPERATION_MASTER_EXT ext = new MED_OPERATION_MASTER_EXT(); foreach (string column in ext.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_PAT_MASTER_INDEX")) { MED_PAT_MASTER_INDEX tmp = new MED_PAT_MASTER_INDEX(); foreach (string column in tmp.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_PATS_IN_HOSPITAL")) { MED_PATS_IN_HOSPITAL pats = new MED_PATS_IN_HOSPITAL(); foreach (string column in pats.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_RECOVER")) { MED_ANESTHESIA_RECOVER tmp = new MED_ANESTHESIA_RECOVER(); foreach (string column in tmp.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_INQUIRY")) { MED_ANESTHESIA_INQUIRY tmp = new MED_ANESTHESIA_INQUIRY(); foreach (string column in tmp.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_SAFETY_CHECKS")) { MED_SAFETY_CHECKS safety = new MED_SAFETY_CHECKS(); foreach (string column in safety.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_PAT_VISIT")) { MED_PAT_VISIT visit = new MED_PAT_VISIT(); foreach (string column in visit.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_PLAN")) { MED_ANESTHESIA_PLAN plan = new MED_ANESTHESIA_PLAN(); foreach (string column in plan.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_PLAN_EXAM")) { MED_ANESTHESIA_PLAN_EXAM plan = new MED_ANESTHESIA_PLAN_EXAM(); foreach (string column in plan.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_PLAN_PMH")) { MED_ANESTHESIA_PLAN_PMH plan = new MED_ANESTHESIA_PLAN_PMH(); foreach (string column in plan.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_HIS_USERS")) { MED_HIS_USERS users = new MED_HIS_USERS(); foreach (string column in users.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_DEPT_DICT")) { MED_DEPT_DICT dept = new MED_DEPT_DICT(); foreach (string column in dept.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_DIAGNOSIS_DICT")) { MED_DIAGNOSIS_DICT dept = new MED_DIAGNOSIS_DICT(); foreach (string column in dept.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPERATION_DICT")) { MED_OPERATION_DICT dept = new MED_OPERATION_DICT(); foreach (string column in dept.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_DICT")) { MED_ANESTHESIA_DICT dept = new MED_ANESTHESIA_DICT(); foreach (string column in dept.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPERATING_ROOM")) { MED_OPERATING_ROOM dept = new MED_OPERATING_ROOM(); foreach (string column in dept.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_PREOPERATIVE_EXPANSION")) { MED_PREOPERATIVE_EXPANSION row = new MED_PREOPERATIVE_EXPANSION(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPERATION_EXTENDED")) { MED_OPERATION_EXTENDED row = new MED_OPERATION_EXTENDED(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_POSTOPERATIVE_EXTENDED")) { MED_POSTOPERATIVE_EXTENDED row = new MED_POSTOPERATIVE_EXTENDED(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_PACU_SORCE")) { MED_PACU_SORCE row = new MED_PACU_SORCE(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPERATION_ANALGESIC_MASTER")) { MED_OPERATION_ANALGESIC_MASTER row = new MED_OPERATION_ANALGESIC_MASTER(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPER_ANALGESIC_MEDICINE")) { MED_OPER_ANALGESIC_MEDICINE row = new MED_OPER_ANALGESIC_MEDICINE(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPER_ANALGESIC_TOTAL")) { MED_OPER_ANALGESIC_TOTAL row = new MED_OPER_ANALGESIC_TOTAL(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_OPER_RISK_ESTIMATE")) { MED_OPER_RISK_ESTIMATE row = new MED_OPER_RISK_ESTIMATE(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_INPUT_DICT")) { MED_ANESTHESIA_INPUT_DICT row = new MED_ANESTHESIA_INPUT_DICT(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } else if (tableName.ToUpper().Trim().Equals("MED_ANESTHESIA_INPUT_DATA")) { MED_ANESTHESIA_INPUT_DATA row = new MED_ANESTHESIA_INPUT_DATA(); foreach (string column in row.GetPropsName()) { list.Add(new KeyValue(GetFieldAlias(column), column)); } } if (!string.IsNullOrEmpty(_tableName)) { foreach (DataRow row in dataTable.Rows) { list.Add(new KeyValue(row[_codeField].ToString(), row[_nameField].ToString())); } } else { foreach (DataColumn column in dataTable.Columns) { list.Add(new KeyValue(GetFieldAlias(column.ColumnName), column.ColumnName)); } } return(list); }
protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { #region 手术清点单添加多表格功能 List <MED_QIXIE_QINGDIAN> dataTable = ModelHelper <MED_QIXIE_QINGDIAN> .ConvertDataTableToList(dataSource["MED_QIXIE_QINGDIAN"]); MED_QIXIE_QINGDIAN row = null; string patientID = ExtendApplicationContext.Current.PatientContextExtend.PatientID; int visitID = ExtendApplicationContext.Current.PatientContextExtend.VisitID; int operID = ExtendApplicationContext.Current.PatientContextExtend.OperID; if (dataTable == null) { dataTable = operationInfoRepository.GetOperCheckList(patientID, visitID, operID).Data; } List <MedGridView> grids = base.GetControls <MedGridView>(); foreach (MedGridView grid in grids) { for (int i = 0; i < grid.RowCount; i++) { for (int j = 0; j < grid.ColumnCount; j++) { DataGridViewCell cell = grid[j, i]; List <MED_QIXIE_QINGDIAN> rows = null; rows = dataTable.Where(x => x.PATIENT_ID == patientID && x.VISIT_ID == visitID && x.OPER_ID == operID && x.X_POSITION == j && x.Y_POSITION == i && x.TABLETAG == grid.Name).ToList(); if (rows != null && rows.Count > 0) { row = rows[0]; } else { row = null; } string celltext = string.Empty; if (cell.Value != null && !string.IsNullOrEmpty(cell.Value.ToString().Trim())) { celltext = cell.Value.ToString().Trim(); } if (string.IsNullOrEmpty(celltext)) { if (row != null) { row.POSITION_VALUE = ""; } } else { if (row == null) { row = new MED_QIXIE_QINGDIAN(); row.PATIENT_ID = patientID; row.VISIT_ID = visitID; row.OPER_ID = operID; row.X_POSITION = j; row.Y_POSITION = i; row.TABLETAG = grid.Name; dataTable.Add(row); } row.POSITION_VALUE = celltext; } } } } #endregion List <MED_OPERATION_MASTER> operMasterList = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operMaster = operMasterList[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = ModelHelper <MED_PAT_VISIT> .ConvertDataTableToList(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_OPERATION_EXTENDED> operExtended = ModelHelper <MED_OPERATION_EXTENDED> .ConvertDataTableToList(dataSource["MED_OPERATION_EXTENDED"]); List <MED_POSTOPERATIVE_EXTENDED> postExtended = ModelHelper <MED_POSTOPERATIVE_EXTENDED> .ConvertDataTableToList(dataSource["MED_POSTOPERATIVE_EXTENDED"]); List <MED_PREOPERATIVE_EXPANSION> preExpansion = ModelHelper <MED_PREOPERATIVE_EXPANSION> .ConvertDataTableToList(dataSource["MED_POSTOPERATIVE_EXTENDED"]); List <MED_QIXIE_QINGDIAN> operCheck = dataTable; if (operCheck != null) { operationInfoRepository.SaveOperCheckList(operCheck); } //OperationInfoService.SaveMedicalBasicDoc(operMaster, patIndex, patVisit, null, null, null, null, operExtended, postExtended, preExpansion); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; operationInfoRepository.SaveMedicalBasicDoc(new { operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); }
private void PatientTree_Load(object sender, EventArgs e) { MED_PATIENT_CARD cardRow = patientInfoRepository.GetPatCard(patientID, (int)visitID, (int)operID).Data; labelName.Text = GetValue(cardRow.NAME); labelBaseInfo.Text = string.Format("{0} {1} {2}", GetValue(cardRow.SEX), DateDiff.CalAge(cardRow.DATE_OF_BIRTH.Value, cardRow.SCHEDULED_DATE_TIME.Value), GetValue(cardRow.INP_NO)); MED_PAT_VISIT patVisit = operationInfoRepository.GetPatVisit(patientID, (int)visitID).Data; if (patVisit == null) { patVisit = new MED_PAT_VISIT(); } string admission_date_time = string.Empty; if (patVisit.ADMISSION_DATE_TIME != null) { admission_date_time = patVisit.ADMISSION_DATE_TIME.Value.ToString("yyyy-MM-dd"); } labelZD.Text = string.Format("{0}{1}{2}", admission_date_time, GetValue(patVisit.PAT_ADM_CONDITION), GetValue(patVisit.INSURANCE_TYPE)); #region 术后随访 List <MED_ANESTHESIA_INQUIRY> anesthesia_inquiry = operationInfoRepository.GetAnesInquiryList(patientID, (int)visitID, (int)operID).Data; if (anesthesia_inquiry != null && anesthesia_inquiry.Count > 0) { labelINQUIRY_DATE.Text = anesthesia_inquiry[0].INQUIRY_DATE.ToString("yyyy-MM-dd"); labelDocName.Text = RefUsersDT(anesthesia_inquiry[0].INQUIRY_DOCTOR); } else { labelINQUIRY_DATE.Text = string.Empty; labelDocName.Text = string.Empty; } #endregion #region 患者复苏 string[] tempArr = new string[10] { "", "", "", "", "", "", "", "", "", "" }; StringBuilder sb = new StringBuilder(); sb.Append("入室:{0} 出室:{1}\r\n"); sb.Append("复苏市时长:{2}分钟\r\n"); sb.Append("入室情况:体温{3}℃ 意识:{4} 呼吸:{5}次/分\r\n"); sb.Append("苏醒评分:{6}分\r\n"); sb.Append("出室情况:体温{7}℃ 意识:{8} 呼吸:{9}次/分\r\n"); if (cardRow.IN_PACU_DATE_TIME != null) { labelFuSuDate.Text = cardRow.IN_PACU_DATE_TIME.Value.ToString("yyyy-MM-dd"); tempArr[0] = cardRow.IN_PACU_DATE_TIME.Value.ToString("HH:mm"); } else { labelFuSuDate.Text = string.Empty; } if (cardRow.OUT_PACU_DATE_TIME != null) { tempArr[1] = cardRow.OUT_PACU_DATE_TIME.Value.ToString("HH:mm"); } if (cardRow.IN_PACU_DATE_TIME != null && cardRow.OUT_PACU_DATE_TIME != null) { tempArr[2] = (cardRow.OUT_PACU_DATE_TIME.Value - cardRow.IN_PACU_DATE_TIME.Value).Minutes.ToString(); } //入室 MED_CONFIRMATION_PACU in_confirmation_pacu = operationInfoRepository.GetConfirmationPACU(patientID, (int)visitID, (int)operID, 45).Data; if (in_confirmation_pacu != null) { tempArr[3] = in_confirmation_pacu.BODY_TEMP.Value.ToString(); tempArr[4] = in_confirmation_pacu.CONSCIOUSNESS; tempArr[5] = in_confirmation_pacu.RESP.Value.ToString(); } List <MED_STEWARD_MARK> steward_mark = operationInfoRepository.GetStewardMarkList(patientID, (int)visitID, (int)operID).Data; if (steward_mark != null && steward_mark.Count > 0) { tempArr[6] = steward_mark[steward_mark.Count - 1].TOTAL_MATK.ToString(); } //出室 MED_CONFIRMATION_PACU out_confirmation_pacu = operationInfoRepository.GetConfirmationPACU(patientID, (int)visitID, (int)operID, 55).Data; if (out_confirmation_pacu != null) { tempArr[7] = out_confirmation_pacu.BODY_TEMP.Value.ToString(); tempArr[8] = out_confirmation_pacu.CONSCIOUSNESS; tempArr[9] = out_confirmation_pacu.RESP.Value.ToString(); } labelPACU.Text = string.Format(sb.ToString(), tempArr); #endregion #region 术中麻醉 MED_ANESTHESIA_INPUT_DATA input_data = operationInfoRepository.GetAnesInputData(patientID, (int)visitID, (int)operID).Data; if (cardRow.START_DATE_TIME != null) { labelShouShuZhongDate.Text = cardRow.START_DATE_TIME.Value.ToString("yyyy-MM-dd"); } else { labelShouShuZhongDate.Text = string.Empty; } string ANALGESIA_EFFECT = string.Empty; if (input_data != null) { ANALGESIA_EFFECT = input_data.ANALGESIA_EFFECT; } if (cardRow.OUT_DATE_TIME != null && cardRow.IN_DATE_TIME != null) { TimeSpan span = (TimeSpan)(cardRow.OUT_DATE_TIME - cardRow.IN_DATE_TIME); int hour = span.Days * 24; lbloperTime.Text = string.Format("手术时长:{0}小时 {1}分钟 麻醉效果:{2}", hour + span.Hours, span.Minutes, ANALGESIA_EFFECT); lbInRoomTime.Text = cardRow.IN_DATE_TIME.Value.ToString("HH:mm"); lbAnesStartTime.Text = cardRow.ANES_START_TIME.Value.ToString("HH:mm"); lbOperStartTime.Text = cardRow.START_DATE_TIME.Value.ToString("HH:mm"); lbOperEndTime.Text = cardRow.END_DATE_TIME.Value.ToString("HH:mm"); lbAnesEndTime.Text = cardRow.ANES_END_TIME.Value.ToString("HH:mm"); lbOutRomTime.Text = cardRow.OUT_DATE_TIME.Value.ToString("HH:mm"); } else { lbloperTime.Text = string.Format("手术时长: 麻醉效果:"); lbInRoomTime.Text = "--:--"; lbAnesStartTime.Text = "--:--"; lbAnesStartTime.Text = "--:--"; lbOperStartTime.Text = "--:--"; lbOperEndTime.Text = "--:--"; lbAnesEndTime.Text = "--:--"; lbOutRomTime.Text = "--:--"; } MED_OPERATION_MASTER_EXT master_ext = operationInfoRepository.GetOperMasterExt(patientID, (int)visitID, (int)operID).Data; string[] arrayInOrOut = new string[8] { "", "", "", "", "", "", "", "" }; if (master_ext == null) { master_ext = new MED_OPERATION_MASTER_EXT(); } if (master_ext.INFUSION_TRAN_VOL != null) { arrayInOrOut[0] = GetValue(master_ext.INFUSION_TRAN_VOL.ToString()); } if (master_ext.OUT_FLUIDS_AMOUNT != null) { arrayInOrOut[1] = GetValue(master_ext.OUT_FLUIDS_AMOUNT.ToString()); } if (master_ext.BLOOD_TRANSFUSED != null) { arrayInOrOut[2] = GetValue(master_ext.BLOOD_TRANSFUSED.ToString()); } if (master_ext.CRY_WATHER != null) { arrayInOrOut[3] = GetValue(master_ext.CRY_WATHER.ToString()); } List <MED_VITAL_SIGN> vitalSignList = new OperationVitalSignRepository().GetVitalSignData(patientID, (int)visitID, (int)operID, "0", false); if (vitalSignList != null && vitalSignList.Count > 0) { DateTime lastTime = vitalSignList[vitalSignList.Count - 1].TIME_POINT; vitalSignList = vitalSignList.Where(p => p.TIME_POINT == lastTime).ToList(); foreach (MED_VITAL_SIGN row in vitalSignList) { if (row.ITEM_CODE == "100") //体温 { arrayInOrOut[4] = GetValue(row.ITEM_VALUE); } else if (row.ITEM_CODE == "89")//血压高 { arrayInOrOut[5] = GetValue(row.ITEM_VALUE); } else if (row.ITEM_CODE == "90")//血压低 { arrayInOrOut[6] = GetValue(row.ITEM_VALUE); } else if (row.ITEM_CODE == "44")//脉搏 { arrayInOrOut[7] = GetValue(row.ITEM_VALUE); } } } labelInOrOut.Text = string.Format("术中输液:入量:{0}ml 出量:{1}ml\r\n输血:{2}ml 自体血:{3}\r\n出室时:体温:{4}℃ 血压:{5}/{6} 脉搏:{7}", arrayInOrOut); MED_OPERATION_MASTER master = operationInfoRepository.GetOperMaster(patientID, (int)visitID, (int)operID).Data; labelAnesOper.Text = string.Format("麻:{0} 护:{1}\r\n手:{2}", RefUsersDT(master.ANES_DOCTOR) + " " + RefUsersDT(master.FIRST_ANES_ASSISTANT), RefUsersDT(master.FIRST_OPER_NURSE) + " " + RefUsersDT(master.FIRST_SUPPLY_NURSE), RefUsersDT(master.SURGEON) + " " + RefUsersDT(master.FIRST_OPER_ASSISTANT)); #endregion #region 术前访视 MED_ANESTHESIA_PLAN_EXAM anesPlanExam = operationInfoRepository.GetAnesPlanExam(patientID, (int)visitID, (int)operID).Data; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = operationInfoRepository.GetAnesPlanPmh(patientID, (int)visitID, (int)operID).Data; MED_ANESTHESIA_PLAN anesPlan = operationInfoRepository.GetAnesPlan(patientID, (int)visitID, (int)operID).Data; if (anesPlanExam == null) { anesPlanExam = new MED_ANESTHESIA_PLAN_EXAM(); } if (anesPlanPmh == null) { anesPlanPmh = new MED_ANESTHESIA_PLAN_PMH(); } if (anesPlan == null) { anesPlan = new MED_ANESTHESIA_PLAN(); } if (anesPlan.INQUIRY_BEFORE_DATE != null) { labelFangShiDate.Text = anesPlan.INQUIRY_BEFORE_DATE.Value.ToString("yyyy-MM-dd"); } else { labelFangShiDate.Text = string.Empty; } labelFangShiName.Text = GetValue(anesPlan.INQUIRY_DOCTOR); labelPatient.Text = string.Format("{0}cm,{1}kg{2}/{3}mmHg{4}次/分,{5}次/分", GetValue(anesPlanPmh.HEIGHT.ToString()), GetValue(anesPlanPmh.WEIGHT.ToString()), GetValue(anesPlanExam.BLOOD_PRESS_HIGH.ToString()), GetValue(anesPlanExam.BLOOD_PRESS_LOW.ToString()), GetValue(anesPlanExam.CARDIOTACH.ToString()), GetValue(anesPlanExam.BREATH.ToString())); labelSQ1.Text = string.Format("血常规:{0} 心电图:{1}", "", GetValue(anesPlanExam.ECG_EXAM)); labelSQ2.Text = string.Format("生化:{0} 意识:{1}", "", ""); labelSQ3.Text = string.Format("{0} {1}", "", ""); labelSQ4.Text = string.Format("执行麻醉:{0} ASA分级:{1}", GetValue(anesPlan.ANESTHESIA_METHOD), GetValue(cardRow.ASA_GRADE)); #endregion List <MED_OPERATION_SCHEDULE> operScheduleList = operationInfoRepository.GetOperScheduleList(patientID, (int)visitID).Data.ToList(); if (operScheduleList != null && operScheduleList.Count > 0) { operScheduleList = operScheduleList.Where(x => x.OPER_ID == (int)operID).ToList(); } #region 手术安排 StringBuilder sbschedule1 = new StringBuilder(); sbschedule1.Append("手术安排日期:{0}\r\n"); sbschedule1.Append("麻:{1}\r\n"); sbschedule1.Append("护:{2}\r\n"); sbschedule1.Append("手术间:{3} 台次:{4}"); string[] tempSchedule1Arr = new string[5] { "", "", "", "", "" }; if (operScheduleList != null && operScheduleList.Count > 0) { MED_OPERATION_SCHEDULE tempoperation_schedule1 = operScheduleList[0]; tempSchedule1Arr[0] = tempoperation_schedule1.SCHEDULED_DATE_TIME.Value.ToString("yyyy-MM-dd"); StringBuilder sbOperAnes = new StringBuilder(); sbOperAnes.Append(RefUsersDT(tempoperation_schedule1.ANES_DOCTOR)); sbOperAnes.Append(RefUsersDT(tempoperation_schedule1.FIRST_ANES_ASSISTANT)); sbOperAnes.Append(RefUsersDT(tempoperation_schedule1.SECOND_ANES_ASSISTANT)); sbOperAnes.Append(RefUsersDT(tempoperation_schedule1.THIRD_ANES_ASSISTANT)); sbOperAnes.Append(RefUsersDT(tempoperation_schedule1.FOURTH_ANES_ASSISTANT)); tempSchedule1Arr[1] = sbOperAnes.ToString(); StringBuilder sbOperNurse = new StringBuilder(); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.FIRST_OPER_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.SECOND_OPER_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.THIRD_OPER_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.FOURTH_OPER_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.FIRST_OPER_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.SECOND_SUPPLY_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.THIRD_SUPPLY_NURSE)); sbOperNurse.Append(RefUsersDT(tempoperation_schedule1.FOURTH_SUPPLY_NURSE)); tempSchedule1Arr[2] = sbOperNurse.ToString(); tempSchedule1Arr[3] = GetValue(tempoperation_schedule1.OPER_ROOM_NO); if (tempoperation_schedule1.SEQUENCE != null) { tempSchedule1Arr[4] = tempoperation_schedule1.SEQUENCE.ToString(); } labelSchedule.Text = string.Format(sbschedule1.ToString(), tempSchedule1Arr); labelOperScheduleTime.Text = tempoperation_schedule1.SCHEDULED_DATE_TIME.Value.ToString("yyyy-MM-dd"); } else { labelSchedule.Text = string.Format(sbschedule1.ToString(), tempSchedule1Arr); labelOperScheduleTime.Visible = false; } #endregion #region 手术申请 if (operScheduleList != null && operScheduleList.Count > 0) { MED_OPERATION_SCHEDULE tempoperation_schedule = operScheduleList[0]; string[] tempScheduleArr = new string[7] { "", "", "", "", "", "", "" }; tempScheduleArr[0] = RefDeptDT(tempoperation_schedule.DEPT_CODE); tempScheduleArr[1] = GetValue(tempoperation_schedule.BED_NO); tempScheduleArr[2] = GetValue(tempoperation_schedule.DIAG_BEFORE_OPERATION); tempScheduleArr[3] = GetValue(tempoperation_schedule.OPERATION_NAME); tempScheduleArr[4] = GetValue(tempoperation_schedule.OPER_SCALE); tempScheduleArr[5] = GetValue(tempoperation_schedule.OPER_POSITION); labelOperReg.Text = string.Format("{0}{1}\r\n{2}\r\n{3}{4}\r\n{5}", tempScheduleArr); StringBuilder sbOper = new StringBuilder(); sbOper.Append(RefUsersDT(tempoperation_schedule.SURGEON)); sbOper.Append(RefUsersDT(tempoperation_schedule.FIRST_OPER_ASSISTANT)); sbOper.Append(RefUsersDT(tempoperation_schedule.SECOND_OPER_ASSISTANT)); sbOper.Append(RefUsersDT(tempoperation_schedule.THIRD_OPER_ASSISTANT)); sbOper.Append(RefUsersDT(tempoperation_schedule.FOURTH_ANES_ASSISTANT)); labelOper.Text = string.Format("手:{0}", sbOper.ToString()); labelCreateDate.Text = tempoperation_schedule.REQ_DATE_TIME.Value.ToString("yyyy-Mm-dd"); if (cardRow.EMERGENCY_IND == 1) { pictureBoxJZ.Visible = true; } if (cardRow.RADIATE_IND == 2) { pictureBoxFS.Visible = true; } if (cardRow.ISOLATION_IND == 2) { pictureBoxGL.Visible = true; } } else { labelOperReg.Text = string.Empty; labelOper.Text = "手:"; labelCreateDate.Text = string.Empty; } #endregion }
protected override void OnSaveData(Dictionary <string, DataTable> dataSource) { List <MED_OPERATION_MASTER> operMasterList = ModelHelper <MED_OPERATION_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operMaster = operMasterList[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = ModelHelper <MED_PAT_MASTER_INDEX> .ConvertDataTableToList(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patMasterIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patMasterIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = ModelHelper <MED_PAT_VISIT> .ConvertDataTableToList(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_OPERATION_EXTENDED> operExtended = ModelHelper <MED_OPERATION_EXTENDED> .ConvertDataTableToList(dataSource["MED_OPERATION_EXTENDED"]); List <MED_POSTOPERATIVE_EXTENDED> postExtended = ModelHelper <MED_POSTOPERATIVE_EXTENDED> .ConvertDataTableToList(dataSource["MED_POSTOPERATIVE_EXTENDED"]); List <MED_OPERATION_ANALGESIC_MASTER> analgesicMaster = ModelHelper <MED_OPERATION_ANALGESIC_MASTER> .ConvertDataTableToList(dataSource["MED_OPERATION_ANALGESIC_MASTER"]); if (analgesicMaster != null && analgesicMaster.Count > 0) { operationInfoRepository.SaveAnalgesicMaster(analgesicMaster[0]); } List <MED_OPER_ANALGESIC_MEDICINE> analgesicMedicine = ModelHelper <MED_OPER_ANALGESIC_MEDICINE> .ConvertDataTableToList(dataSource["MED_OPER_ANALGESIC_MEDICINE"]); if (analgesicMedicine != null) { operationInfoRepository.SaveAnalgesicMedicineList(analgesicMedicine); } List <MED_OPER_ANALGESIC_TOTAL> analgesicTotal = ModelHelper <MED_OPER_ANALGESIC_TOTAL> .ConvertDataTableToList(dataSource["MED_OPER_ANALGESIC_TOTAL"]); if (analgesicTotal != null) { operationInfoRepository.SaveAnalgesicTotalList(analgesicTotal); } //OperationInfoService.SaveMedicalBasicDoc(operMaster, patIndex, patVisit, null, null, null, null, operExtended, postExtended, null); MED_PATS_IN_HOSPITAL patsInHospital = null; MED_ANESTHESIA_PLAN anesPlan = null; MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; List <MED_PREOPERATIVE_EXPANSION> preExpansion = null; operationInfoRepository.SaveMedicalBasicDoc(new { operMaster, patMasterIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh, operExtended, postExtended, preExpansion }); }
/// <summary> /// 保存数据源 /// </summary> protected override bool OnSaveData(Dictionary <string, DataTable> dataSource) { List <MED_ANESTHESIA_INPUT_DATA> anesInputData = new ModelHandler <MED_ANESTHESIA_INPUT_DATA>().FillModel(dataSource["MED_ANESTHESIA_INPUT_DATA"]); if (anesInputData != null && anesInputData.Count > 0) { CareDocService.ClientInstance.SaveAnesInputData(anesInputData[0]); } List <MED_OPERATION_MASTER> operMasterList = new ModelHandler <MED_OPERATION_MASTER>().FillModel(dataSource["MED_OPERATION_MASTER"]); MED_OPERATION_MASTER operMaster = null; if (operMasterList != null && operMasterList.Count > 0) { operMaster = operMasterList[0]; } List <MED_PAT_MASTER_INDEX> patIndexList = new ModelHandler <MED_PAT_MASTER_INDEX>().FillModel(dataSource["MED_PAT_MASTER_INDEX"]); MED_PAT_MASTER_INDEX patIndex = null; if (patIndexList != null && patIndexList.Count > 0) { patIndex = patIndexList[0]; } List <MED_PAT_VISIT> patVisitList = new ModelHandler <MED_PAT_VISIT>().FillModel(dataSource["MED_PAT_VISIT"]); MED_PAT_VISIT patVisit = null; if (patVisitList != null && patVisitList.Count > 0) { patVisit = patVisitList[0]; } List <MED_ANESTHESIA_PLAN> anesPlanList = new ModelHandler <MED_ANESTHESIA_PLAN>().FillModel(dataSource["MED_ANESTHESIA_PLAN"]); MED_ANESTHESIA_PLAN anesPlan = null; if (anesPlanList != null && anesPlanList.Count > 0) { anesPlan = anesPlanList[0]; } List <MED_ANESTHESIA_PLAN_PMH> anesPlanPMHList = new ModelHandler <MED_ANESTHESIA_PLAN_PMH>().FillModel(dataSource["MED_ANESTHESIA_PLAN_PMH"]); MED_ANESTHESIA_PLAN_PMH anesPlanPmh = null; if (anesPlanPMHList != null && anesPlanPMHList.Count > 0) { anesPlanPmh = anesPlanPMHList[0]; } List <MED_ANESTHESIA_PLAN_EXAM> anesPlanExamList = new ModelHandler <MED_ANESTHESIA_PLAN_EXAM>().FillModel(dataSource["MED_ANESTHESIA_PLAN_EXAM"]); MED_ANESTHESIA_PLAN_EXAM anesPlanExam = null; if (anesPlanExamList != null && anesPlanExamList.Count > 0) { anesPlanExam = anesPlanExamList[0]; } List <MED_PREOPERATIVE_EXPANSION> preExpansion = new ModelHandler <MED_PREOPERATIVE_EXPANSION>().FillModel(dataSource["MED_PREOPERATIVE_EXPANSION"]); List <MED_PATS_IN_HOSPITAL> patsInHospitalList = new ModelHandler <MED_PATS_IN_HOSPITAL>().FillModel(dataSource["MED_PATS_IN_HOSPITAL"]); MED_PATS_IN_HOSPITAL patsInHospital = null; if (patsInHospitalList != null && patsInHospitalList.Count > 0) { patsInHospital = patsInHospitalList[0]; } List <MED_OPERATION_EXTENDED> operExtended = new ModelHandler <MED_OPERATION_EXTENDED>().FillModel(dataSource["MED_OPERATION_EXTENDED"]); List <MED_POSTOPERATIVE_EXTENDED> postExtended = new ModelHandler <MED_POSTOPERATIVE_EXTENDED>().FillModel(dataSource["MED_POSTOPERATIVE_EXTENDED"]); bool result = CareDocService.ClientInstance.SaveMedicalBasicDoc(new { operMaster, patIndex, patVisit, patsInHospital, anesPlan, anesPlanExam, anesPlanPmh = anesPlanPmh, operExtended, postExtended, preExpansion }); return(result); }
public bool SavePatientOperation(MED_OPERATION_SCHEDULE operSchedule, MED_PAT_VISIT patVisit, MED_PAT_MASTER_INDEX patMasterIndex, List <MED_OPERATION_NAME> operNameOldList, List <MED_OPERATION_NAME> operNameNewList, MED_OPERATION_MASTER operMaster, MED_ANESTHESIA_PLAN anesPlan, MED_ANESTHESIA_PLAN_PMH anesPlanPmh, MED_ANESTHESIA_PLAN_EXAM anesPlanExam, MED_OPERATION_MASTER_EXT operMasterExt) { bool flag = true; if (operSchedule != null) { flag = flag & dapper.Set <MED_OPERATION_SCHEDULE>().Save(operSchedule); } if (patVisit != null) { flag = flag & dapper.Set <MED_PAT_VISIT>().Save(patVisit); } if (patMasterIndex != null) { flag = flag & dapper.Set <MED_PAT_MASTER_INDEX>().Save(patMasterIndex); } if (operNameOldList != null && operNameOldList.Count > 0) { foreach (var item in operNameNewList) { flag = flag & dapper.Set <MED_OPERATION_NAME>().Delete(item); } } if (operNameNewList != null && operNameNewList.Count > 0) { foreach (var item in operNameNewList) { flag = flag & dapper.Set <MED_OPERATION_NAME>().Save(item); } } if (operMaster != null) { flag = flag & dapper.Set <MED_OPERATION_MASTER>().Save(operMaster); } if (anesPlan != null) { flag = flag & dapper.Set <MED_ANESTHESIA_PLAN>().Save(anesPlan); } if (anesPlanPmh != null) { flag = flag & dapper.Set <MED_ANESTHESIA_PLAN_PMH>().Save(anesPlanPmh); } if (anesPlanExam != null) { flag = flag & dapper.Set <MED_ANESTHESIA_PLAN_EXAM>().Save(anesPlanExam); } if (operMasterExt != null) { flag = flag & dapper.Set <MED_OPERATION_MASTER_EXT>().Save(operMasterExt); } if (flag) { dapper.SaveChanges(); } return(flag); }