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