public async Task <ApiJsonResultData> SaveMedicalInsuranceDataAll([FromBody] MedicalInsuranceDataAllParam param)
{
return(await new ApiJsonResultData(ModelState).RunWithTryAsync(async y =>
{
//var userBase = await GetUserBaseInfo();
//var paramData=new MedicalInsuranceDataAllParam()
//{ DataAllId = Guid.NewGuid().ToString("N").ToUpper(),
// ParticipationJson = "123",
// ResultDataJson = "123",
// CreateCode = userBase.职员ID,
// DataType = 1,
//};
await _dataBaseHelpService.SaveMedicalInsuranceDataAll(param);
//y.Data = "更新机构" + data + "条";
}));
}
/// <summary>
/// 医保反馈数据保存
/// </summary>
/// <param name="user"></param>
/// <param name="param"></param>
/// <returns></returns>
public async Task SaveMedicalInsuranceDataAll(MedicalInsuranceDataAllParam param)
{
using (var _sqlConnection = new SqlConnection(_connectionString))
{
_sqlConnection.Open();
IDbTransaction transaction = _sqlConnection.BeginTransaction();
try
{
string strSql =
$@"update MedicalInsuranceDataAll set DeleteTime=GETDATE(),DeleteUserId='{param.CreateUserId}' where DeleteTime is null and DataId='{param.DataId}' and BusinessId='{param.BusinessId}'";
var num = await _sqlConnection.ExecuteAsync(strSql, null, transaction);
string insertSql = $@"INSERT INTO [dbo].[MedicalInsuranceDataAll]
([DataAllId]
,[ParticipationJson]
,[ResultDataJson]
,[DataType]
,[DataId]
,[Remark]
,[CreateUserId]
,[CreateTime]
,BusinessId
,HisMedicalInsuranceId
,OrgCode
,IDCard
)
VALUES ('{param.DataAllId}','{param.ParticipationJson}','{param.ResultDataJson}','{param.DataType}','{param.DataId}'
, '{param.Remark}','{param.CreateUserId}', GETDATE(),'{param.BusinessId}'
,'{param.HisMedicalInsuranceId}','{param.OrgCode}','{param.IdCard}')";
var nums = await _sqlConnection.ExecuteAsync(insertSql, null, transaction);
transaction.Commit();
}
catch (Exception exception)
{
transaction.Rollback();
throw new Exception(exception.Message);
}
}
}
/// <summary>
/// 获取医保构建参数
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task SaveXmlData(SaveXmlData param)
{
var data = await _webServiceBasic.HIS_InterfaceListAsync("38", JsonConvert.SerializeObject(param), param.操作人员ID);
if (data.Result == "1")
{
var saveParam = new MedicalInsuranceDataAllParam()
{
DataAllId = Guid.NewGuid().ToString("N"),
BusinessId = param.业务ID,
CreateUserId = param.操作人员ID,
DataId = param.发起交易的动作ID,
DataType = param.医保交易码,
OrgCode = param.机构ID,
ParticipationJson = param.入参,
ResultDataJson = param.出参,
HisMedicalInsuranceId = param.发起交易的动作ID,
Remark = param.Remark,
IdCard = param.IDCard,
};
await _dataBaseHelpService.SaveMedicalInsuranceDataAll(saveParam);
}
}
