public async Task <ApiJsonResultData> QueryInpatientInfo([FromBody] QueryInpatientInfoParam param)
{
return(await new ApiJsonResultData(ModelState).RunWithTryAsync(async y =>
{
var data = await _webServiceBasicService.QueryInpatientInfo(param);
if (string.IsNullOrWhiteSpace(data.Id))//如果当前无数据
{
var verificationCode = await GetUserBaseInfo();
if (verificationCode != null)
{
var inputInpatientInfo = new InpatientInfoParam()
{
验证码 = verificationCode.验证码,
机构编码 = verificationCode.机构编码,
身份证号码 = param.IdCard,
开始时间 = DateTime.Now.AddYears(-4).ToString("yyyy-MM-dd HH:mm:ss"),
结束时间 = "2020-04-27 11:09:00",
状态 = "0"
};
string inputInpatientInfoJson =
JsonConvert.SerializeObject(inputInpatientInfo, Formatting.Indented);
var inputInpatientInfoData = await _webServiceBasicService
.GetInpatientInfo(verificationCode, inputInpatientInfoJson);
}
var dataNew = await _webServiceBasicService.QueryInpatientInfo(param);
y.Data = dataNew;
}
else
{
y.Data = data;
}
}));
}
/// <summary>
/// 住院病人查询
/// </summary>
/// <returns></returns>
public async Task <QueryInpatientInfoDto> QueryInpatientInfo(QueryInpatientInfoParam param)
{
using (var _sqlConnection = new SqlConnection(_connectionString))
{
_sqlConnection.Open();
string strSql = $@"SELECT top 1 [Id]
,[医院名称]
,[入院日期]
,[出院日期]
,[住院号]
,[业务ID]
,[姓名]
,[身份证号]
,[性别]
,[出生日期]
,[联系人姓名]
,[联系电话]
,[家庭地址]
,[入院科室]
,[入院科室编码]
,[入院诊断医生]
,[入院床位]
,[入院主诊断]
,[入院主诊断ICD10]
,[入院次诊断]
,[入院次诊断ICD10]
,[入院病区]
,[入院经办人]
,[入院经办时间]
,[住院总费用]
,[备注]
,[出院科室]
,[出院科室编码]
,[出院病区]
,[出院床位]
,[出院主诊断]
,[出院主诊断ICD10]
,[出院次诊断]
,[出院次诊断ICD10]
,[在院状态]
,[入院诊断医生编码]
,[入院床位编码]
,[入院病区编码]
,[出院床位编码]
,[出院病区编码]
FROM [dbo].[住院病人] where IsDelete=0 and 业务ID='{param.BusinessId}' and OrgCode='{param.InstitutionalNumber}'
";
var data = await _sqlConnection.QueryFirstAsync <QueryInpatientInfoDto>(strSql);
_sqlConnection.Close();
return(data);
}
}
/// <summary>
/// 职工生育结算
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public WorkerHospitalizationPreSettlementDto WorkerBirthSettlement(WorkerBirthSettlementUiParam param)
{
//获取操作人员信息
var userBase = _serviceBasicService.GetUserBaseInfo(param.UserId);
userBase.TransKey = param.TransKey;
var infoData = new GetInpatientInfoParam()
{
User = userBase,
BusinessId = param.BusinessId,
};
//获取his结算
var hisSettlement = _serviceBasicService.GetHisHospitalizationSettlement(infoData);
var queryResidentParam = new QueryMedicalInsuranceResidentInfoParam()
{
BusinessId = param.BusinessId,
OrganizationCode = userBase.OrganizationCode
};
//获取医保病人信息
var residentData = _medicalInsuranceSqlRepository.QueryMedicalInsuranceResidentInfo(queryResidentParam);
if (residentData.MedicalInsuranceState == MedicalInsuranceState.HisSettlement)
{
throw new Exception("当前病人已办理医保结算,不能办理预结算!!!");
}
if (residentData.MedicalInsuranceState != MedicalInsuranceState.MedicalInsurancePreSettlement)
{
throw new Exception("当前病人未办理预结算,不能办理结算!!!");
}
var inpatientInfoParam = new QueryInpatientInfoParam()
{
BusinessId = param.BusinessId
};
//获取住院病人
var inpatientInfoData = _hisSqlRepository.QueryInpatientInfo(inpatientInfoParam);
if (inpatientInfoData == null)
{
throw new Exception("该病人未在中心库中,请检查是否办理医保入院!!!");
}
var infoParam = new WorkerBirthSettlementParam()
{
LeaveHospitalInpatientState = param.LeaveHospitalInpatientState,
FetusNumber = param.FetusNumber,
MedicalCategory = param.MedicalCategory,
Operator = userBase.UserName,
MedicalInsuranceHospitalizationNo = residentData.MedicalInsuranceHospitalizationNo,
LeaveHospitalDate = Convert.ToDateTime(hisSettlement.LeaveHospitalDate).ToString("yyyyMMdd"),
};
//获取诊断
var diagnosisData = CommonHelp.GetDiagnosis(param.DiagnosisList);
infoParam.AdmissionMainDiagnosisIcd10 = diagnosisData.AdmissionMainDiagnosisIcd10;
infoParam.DiagnosisIcd10Two = diagnosisData.DiagnosisIcd10Two;
infoParam.DiagnosisIcd10Three = diagnosisData.DiagnosisIcd10Three;
infoParam.AdmissionMainDiagnosis = diagnosisData.DiagnosisDescribe;
// 医保
var resultData = _workerMedicalInsuranceRepository.WorkerBirthSettlement(infoParam);
//报销金额 =统筹支付+补充医疗保险支付金额+专项基金支付金额+
//公务员补贴+公务员补助+其它支付金额
decimal reimbursementExpenses = resultData.BasicOverallPay + resultData.SupplementPayAmount + resultData.SpecialFundPayAmount
+ resultData.CivilServantsSubsidies + resultData.CivilServantsSubsidy + resultData.OtherPaymentAmount;
resultData.ReimbursementExpenses = reimbursementExpenses;
var updateData = new UpdateMedicalInsuranceResidentSettlementParam()
{
UserId = userBase.UserId,
ReimbursementExpensesAmount = CommonHelp.ValueToDouble(reimbursementExpenses),
SelfPayFeeAmount = resultData.CashPayment,
OtherInfo = JsonConvert.SerializeObject(resultData),
Id = residentData.Id,
SettlementNo = resultData.DocumentNo,
MedicalInsuranceAllAmount = resultData.TotalAmount,
SettlementTransactionId = userBase.UserId,
MedicalInsuranceState = MedicalInsuranceState.MedicalInsuranceSettlement
};
//存入中间层
_medicalInsuranceSqlRepository.UpdateMedicalInsuranceResidentSettlement(updateData);
//添加日志
var logParam = new AddHospitalLogParam()
{
JoinOrOldJson = JsonConvert.SerializeObject(param),
ReturnOrNewJson = JsonConvert.SerializeObject(resultData),
User = userBase,
Remark = "职工住院结算",
RelationId = residentData.Id,
};
//存入基层
var userInfoData = _residentMedicalInsuranceRepository.GetUserInfo(new ResidentUserInfoParam()
{
IdentityMark = residentData.IdentityMark,
AfferentSign = residentData.AfferentSign,
});
// 回参构建
var xmlData = new HospitalSettlementXml()
{
MedicalInsuranceHospitalizationNo = residentData.MedicalInsuranceHospitalizationNo,
CashPayment = resultData.CashPayment,
SettlementNo = resultData.DocumentNo,
PaidAmount = resultData.PaidAmount,
AllAmount = resultData.TotalAmount,
PatientName = userInfoData.PatientName,
AccountBalance = userInfoData.WorkersInsuranceBalance,
AccountAmountPay = resultData.AccountPayment,
};
var strXmlBackParam = XmlSerializeHelper.HisXmlSerialize(xmlData);
var saveXml = new SaveXmlDataParam()
{
User = userBase,
MedicalInsuranceBackNum = resultData.DocumentNo,
MedicalInsuranceCode = "41",
BusinessId = param.BusinessId,
BackParam = strXmlBackParam
};
//结算存基层
_webBasicRepository.SaveXmlData(saveXml);
var updateParamData = new UpdateMedicalInsuranceResidentSettlementParam()
{
UserId = param.UserId,
Id = residentData.Id,
MedicalInsuranceState = MedicalInsuranceState.HisSettlement,
IsHisUpdateState = true
};
// 更新中间层
_medicalInsuranceSqlRepository.UpdateMedicalInsuranceResidentSettlement(updateParamData);
//结算后保存信息
var saveParam = AutoMapper.Mapper.Map <SaveInpatientSettlementParam>(hisSettlement);
saveParam.Id = (Guid)inpatientInfoData.Id;
saveParam.User = userBase;
saveParam.LeaveHospitalDiagnosisJson = JsonConvert.SerializeObject(param.DiagnosisList);
_hisSqlRepository.SaveInpatientSettlement(saveParam);
return(resultData);
}
/// <summary>
/// 居民住院结算
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public HospitalizationPresettlementDto LeaveHospitalSettlement(LeaveHospitalSettlementUiParam param)
{
// 获取操作人员信息
var userBase = _webserviceBasicService.GetUserBaseInfo(param.UserId);
var queryResidentParam = new QueryMedicalInsuranceResidentInfoParam()
{
BusinessId = param.BusinessId,
OrganizationCode = userBase.OrganizationCode
};
userBase.TransKey = param.TransKey;
var infoData = new GetInpatientInfoParam()
{
User = userBase,
BusinessId = param.BusinessId,
};
//获取his结算
var hisSettlement = _webserviceBasicService.GetHisHospitalizationSettlement(infoData);
//获取医保病人信息
var residentData = _medicalInsuranceSqlRepository.QueryMedicalInsuranceResidentInfo(queryResidentParam);
if (residentData.MedicalInsuranceState != MedicalInsuranceState.MedicalInsurancePreSettlement)
{
throw new Exception("当前病人未办理预结算,不能办理结算!!!");
}
if (residentData.MedicalInsuranceState == MedicalInsuranceState.HisSettlement)
{
throw new Exception("当前病人已办理医保结算,不能办理再次结算!!!");
}
var inpatientInfoParam = new QueryInpatientInfoParam()
{
BusinessId = param.BusinessId
};
//获取住院病人
var inpatientInfoData = _hisSqlRepository.QueryInpatientInfo(inpatientInfoParam);
if (inpatientInfoData == null)
{
throw new Exception("该病人未在中心库中,请检查是否办理医保入院!!!");
}
var settlementParam = new LeaveHospitalSettlementParam()
{
MedicalInsuranceHospitalizationNo = residentData.MedicalInsuranceHospitalizationNo,
LeaveHospitalDate = Convert.ToDateTime(hisSettlement.LeaveHospitalDate).ToString("yyyyMMdd"),
UserId = hisSettlement.LeaveHospitalOperator,
LeaveHospitalInpatientState = param.LeaveHospitalInpatientState,
};
//获取诊断
var diagnosisData = CommonHelp.GetDiagnosis(param.DiagnosisList);
settlementParam.LeaveHospitalMainDiagnosisIcd10 = diagnosisData.AdmissionMainDiagnosisIcd10;
settlementParam.LeaveHospitalDiagnosisIcd10Two = diagnosisData.DiagnosisIcd10Two;
settlementParam.LeaveHospitalDiagnosisIcd10Three = diagnosisData.DiagnosisIcd10Three;
settlementParam.LeaveHospitalMainDiagnosis = diagnosisData.DiagnosisDescribe;
var infoParam = new LeaveHospitalSettlementInfoParam()
{
User = userBase,
Id = residentData.Id,
InsuranceNo = residentData.InsuranceNo,
BusinessId = inpatientInfoData.BusinessId,
IdCardNo = inpatientInfoData.IdCardNo,
};
//医保执行
var data = _residentMedicalInsuranceRepository.LeaveHospitalSettlement(settlementParam, infoParam);
if (data == null)
{
throw new Exception("居民住院结算反馈失败");
}
var updateData = new UpdateMedicalInsuranceResidentSettlementParam()
{
UserId = userBase.UserId,
ReimbursementExpensesAmount = CommonHelp.ValueToDouble(data.ReimbursementExpenses),
SelfPayFeeAmount = data.CashPayment,
OtherInfo = JsonConvert.SerializeObject(data),
Id = residentData.Id,
SettlementNo = data.DocumentNo,
MedicalInsuranceAllAmount = data.TotalAmount,
SettlementTransactionId = userBase.UserId,
MedicalInsuranceState = MedicalInsuranceState.MedicalInsuranceSettlement
};
//存入中间层
_medicalInsuranceSqlRepository.UpdateMedicalInsuranceResidentSettlement(updateData);
//添加日志
var logParam = new AddHospitalLogParam()
{
JoinOrOldJson = JsonConvert.SerializeObject(param),
ReturnOrNewJson = JsonConvert.SerializeObject(data),
User = userBase,
Remark = "居民住院结算",
RelationId = residentData.Id,
BusinessId = param.BusinessId,
};
var userInfoData = _residentMedicalInsuranceRepository.GetUserInfo(new ResidentUserInfoParam()
{
IdentityMark = residentData.IdentityMark,
AfferentSign = residentData.AfferentSign,
});
// 回参构建
var xmlData = new HospitalSettlementXml()
{
MedicalInsuranceHospitalizationNo = residentData.MedicalInsuranceHospitalizationNo,
CashPayment = data.CashPayment,
SettlementNo = data.DocumentNo,
PaidAmount = data.PaidAmount,
AllAmount = data.TotalAmount,
PatientName = userInfoData.PatientName,
AccountBalance = userInfoData.WorkersInsuranceBalance,
AccountAmountPay = 0,
};
var strXmlBackParam = XmlSerializeHelper.HisXmlSerialize(xmlData);
var saveXml = new SaveXmlDataParam()
{
User = userBase,
MedicalInsuranceBackNum = data.DocumentNo,
MedicalInsuranceCode = "41",
BusinessId = param.BusinessId,
BackParam = strXmlBackParam
};
//结算存基层
_webBasicRepository.SaveXmlData(saveXml);
var updateParamData = new UpdateMedicalInsuranceResidentSettlementParam()
{
UserId = param.UserId,
Id = residentData.Id,
MedicalInsuranceState = MedicalInsuranceState.HisSettlement,
IsHisUpdateState = true
};
// 更新中间层
_medicalInsuranceSqlRepository.UpdateMedicalInsuranceResidentSettlement(updateParamData);
//结算后保存信息
var saveParam = AutoMapper.Mapper.Map <SaveInpatientSettlementParam>(hisSettlement);
saveParam.Id = (Guid)inpatientInfoData.Id;
saveParam.User = userBase;
saveParam.LeaveHospitalDiagnosisJson = JsonConvert.SerializeObject(param.DiagnosisList);
_hisSqlRepository.SaveInpatientSettlement(saveParam);
return(data);
}
/// <summary>
/// 测试函数
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task <dynamic> TestFun(QueryInpatientInfoParam param)
{
var data = await _dataBaseHelpService.QueryInpatientInfo(param);
return(data);
}
public async Task <QueryInpatientInfoDto> QueryInpatientInfo(QueryInpatientInfoParam param)
{
var data = await _dataBaseHelpService.QueryInpatientInfo(param);
return(data);
}
