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); }