public async Task <ApiJsonResultData> SaveMedicalInsuranceResidentInfo([FromBody] MedicalInsuranceResidentInfoParam param)
{
return(await new ApiJsonResultData(ModelState).RunWithTryAsync(async y =>
{
var data = await _dataBaseSqlServerService.SaveMedicalInsuranceResidentInfo(param);
y.Data = data;
}));
}
/// <summary>
/// 医保病人信息保存
/// </summary>
/// <param name="user"></param>
/// <param name="param"></param>
/// <returns></returns>
public async Task <Int32> SaveMedicalInsuranceResidentInfo(
MedicalInsuranceResidentInfoParam param)
{
Int32 counts = 0;
using (var _sqlConnection = new SqlConnection(_connectionString))
{
_sqlConnection.Open();
IDbTransaction transaction = _sqlConnection.BeginTransaction();
try
{
string insertSql =
$@"update [dbo].[MedicalInsuranceResidentInfo] set [IsDelete] =1 ,DeleteTime=GETDATE(),DeleteUserId='{param.EmpID}' where [IsDelete]=0
and BusinessId='{param.BusinessId}' and OrgCode='{param.OrgCode}' and DataId='{param.DataId}'";
await _sqlConnection.ExecuteAsync(insertSql, null, transaction);
string strSql = $@"
INSERT INTO [dbo].[MedicalInsuranceResidentInfo]
([DataAllId]
,[ContentJson]
,[ResultData]
,[DataType]
,[DataId]
,IsDelete
,[BusinessId]
,[IdCard]
,[OrgCode]
,[CreateUserId]
,[CreateTime]
)
VALUES
('{param.DataAllId}','{param.ContentJson}',,'{param.ResultDatajson}','{param.DataType}','{param.DataId}',0,
'{param.BusinessId}','{param.IdCard}','{param.OrgCode}','{param.EmpID}',GETDATE())";
counts = await _sqlConnection.ExecuteAsync(strSql, null, transaction);
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.Message);
}
_sqlConnection.Close();
}
return(counts);
}
