/// <summary> /// 医保对码 /// </summary> /// <param name="param"></param> /// <returns></returns> public void MedicalInsurancePairCode(MedicalInsurancePairCodesUiParam param) { using (var sqlConnection = new SqlConnection(_connectionString)) { string insertSql = null; try { sqlConnection.Open(); if (param.PairCodeList.Any()) { string updateSql = ""; var pairCodeIdList = param.PairCodeList.Where(c => c.PairCodeId != null) .Select(d => d.PairCodeId.ToString()).ToList(); var updateId = CommonHelp.ListToStr(pairCodeIdList); //更新对码 if (pairCodeIdList.Any()) { updateSql += $@"update [dbo].[ThreeCataloguePairCode] set [IsDelete]=1, [DeleteUserId]='{param.UserId}',DeleteTime=GETDATE() where [Id] in ({updateId});"; sqlConnection.Execute(updateSql); } var insertParam = param.PairCodeList.ToList(); //新增对码 if (insertParam.Any()) { foreach (var items in insertParam) { insertSql += $@"insert into [dbo].[ThreeCataloguePairCode] ([Id],[OrganizationCode],[OrganizationName],[DirectoryCategoryCode],[State],[ProjectCode], [FixedEncoding],[CreateTime],[IsDelete],[CreateUserId],[UploadState],[DirectoryCode]) values ( '{Guid.NewGuid()}','{param.OrganizationCode}','{param.OrganizationName}','{items.DirectoryCategoryCode}',0,'{items.ProjectCode}', '{BitConverter.ToInt64(Guid.Parse(items.DirectoryCode).ToByteArray(), 0)}',GETDATE(),0,'{param.UserId}',0,'{items.DirectoryCode}') "; } sqlConnection.Execute(insertSql); sqlConnection.Close(); } } } catch (Exception e) { _log.Debug(insertSql); throw new Exception(e.Message); } } }
public ApiJsonResultData HospitalThreeCatalogBatchUpload([FromBody] UiInIParam param) { return(new ApiJsonResultData(ModelState, new UiInIParam()).RunWithTry(y => { var userBase = webServiceBasicService.GetUserBaseInfo(param.UserId); var paramIni = new MedicalInsurancePairCodesUiParam(); if (userBase != null && string.IsNullOrWhiteSpace(userBase.OrganizationCode) == false) { paramIni.OrganizationCode = userBase.OrganizationCode; paramIni.OrganizationName = userBase.OrganizationName; webServiceBasicService.ThreeCataloguePairCodeUpload( new UpdateThreeCataloguePairCodeUploadParam() { User = userBase, ProjectCodeList = new List <string>() } ); } ImedicalInsuranceSqlRepository.HospitalThreeCatalogBatchUpload(userBase); })); }