public async Task <ApiJsonResultData> UpdateMedicalInsuranceResidentInfo([FromBody] UpdateMedicalInsuranceResidentInfoParam param) { return(await new ApiJsonResultData(ModelState).RunWithTryAsync(async y => { var data = await _dataBaseSqlServerService.UpdateMedicalInsuranceResidentInfo(param); y.Data = data; })); }
/// <summary> /// 更新医保病人信息 /// </summary> /// <param name="param"></param> /// <returns></returns> public async Task <int> UpdateMedicalInsuranceResidentInfo( UpdateMedicalInsuranceResidentInfoParam param) { using (var _sqlConnection = new SqlConnection(_connectionString)) { var resultData = new MedicalInsuranceResidentInfoDto(); _sqlConnection.Open(); string strSql = @" update MedicalInsuranceResidentInfo set "; if (!string.IsNullOrWhiteSpace(param.DataType)) { strSql += $" DataType='{param.DataType}'"; } if (!string.IsNullOrWhiteSpace(param.ContentJson)) { strSql += $" ,ContentJson='{param.ContentJson}'"; } if (!string.IsNullOrWhiteSpace(param.ResultDatajson)) { strSql += $" ,ResultDatajson='{param.ResultDatajson}'"; } if (!string.IsNullOrWhiteSpace(param.DataId)) { strSql += $" ,DataId='{param.DataId}'"; } if (!string.IsNullOrWhiteSpace(param.IdCard)) { strSql += $" ,DataId='{param.IdCard}'"; } strSql += $" where IsDelete=0 and DataAllId='{param.DataAllId}'"; var data = await _sqlConnection.ExecuteAsync(strSql); _sqlConnection.Close(); return(data); } }