public int SaveRickEstimate(MED_OPER_RISK_ESTIMATE item) { int result = dapper.Set <MED_OPER_RISK_ESTIMATE>().Save(item) == true ? 1 : 0; dapper.SaveChanges(); return(result); }
public RequestResult <MED_OPER_RISK_ESTIMATE> GetRickEstimate(string patID, int visitID, int operID) { MED_OPER_RISK_ESTIMATE data = _careDocService.GetRickEstimate(patID, visitID, operID); if (data == null) { return(Failed <MED_OPER_RISK_ESTIMATE>("获取信息错误。")); } else { return(Success(data)); } }
public MED_OPER_RISK_ESTIMATE GetRickEstimate(string patientID, int visitID, int operID) { MED_OPER_RISK_ESTIMATE riskEstimater = operationInfoRepository.GetRickEstimate(patientID, visitID, operID).Data; if (riskEstimater == null) { riskEstimater = new MED_OPER_RISK_ESTIMATE(); riskEstimater.PATIENT_ID = patientID; riskEstimater.VISIT_ID = visitID; riskEstimater.OPER_ID = operID; } return(riskEstimater); }
public RequestResult <bool> SaveRickEstimate(MED_OPER_RISK_ESTIMATE data) { return(Success(_careDocService.SaveRickEstimate(data))); }
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); }
/// <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> SaveRickEstimate(MED_OPER_RISK_ESTIMATE item) { return(Success(_pacuOperationInfoService.SaveRickEstimate(item))); }
public RequestResult <int> SaveRickEstimate(MED_OPER_RISK_ESTIMATE item) { string address = "PacuOperationInfo/SaveRickEstimate"; return(BaseRepository.PostCallApi <MED_OPER_RISK_ESTIMATE>(address, item)); }