基于Power BI的螺栓拧紧数据智能管理系统

为保证整车装配的安全和质量,需要采用大量带监控拧紧工具完成整车零部件的装配工作,并借助拧紧数据完成拧紧工作的日常管理。然而,该过程产生的数据量庞大,传统方式采用人工统计分析拧紧数据,存在统计效率低下、数据处理工作繁琐、可视化效果不佳等问题。为了解决该问题,文章基于智能分析软件Power BI对拧紧数据进行建模处理,并搭建螺栓拧紧数据智能管理系统,实现拧紧数据的自动化管理和分析。该系统包含了海量拧紧数据的自动加载、自动统计和自动生成可视化报表等功能,业务人员可以随时访问系统查询报表,大幅提升了现场拧紧管理的工作效率。

Predicting prolonged postoperative ileus in gastric cancer patients based on bowel sounds using intelligent auscultation and machine learning

BACKGROUND Prolonged postoperative ileus(PPOI)delays the postoperative recovery of gastrointestinal function in patients with gastric cancer(GC),leading to longer hospitalization and higher healthcare expenditure.However,effective monitoring of gastrointestinal recovery in patients with GC remains challenging because of AIM To explore the risk factors for delayed postoperative bowel function recovery and evaluate bowel sound indicators collected via an intelligent auscultation system to guide clinical practice.METHODS This study included data from 120 patients diagnosed with GC who had undergone surgical treatment and postoperative bowel sound monitoring in the Department of General Surgery II at Shaanxi Provincial People's Hospital between January 2019 and January 2021.Among them,PPOI was reported in 33 cases.The patients were randomly divided into the training and validation cohorts.Significant variables from the training cohort were identified using univariate and multivariable analyses and were included in the model.RESULTS The analysis identified six potential variables associated with PPOI among the included participants.The incidence rate of PPOI was 27.5%.Age≥70 years,cTNM stage(Ⅰ and Ⅳ),preoperative hypoproteinemia,recovery time of bowel sounds(RTBS),number of bowel sounds(NBS),and frequency of bowel sounds(FBS)were independent risk factors for PPOI.The Bayesian model demonstrated good performance with internal validation:Training cohort[area under the curve(AUC)=0.880,accuracy=0.823,Brier score=0.139]and validation cohort(AUC=0.747,accuracy=0.690,Brier score=0.215).The model showed a good fit and calibration in the decision curve analysis,indicating a significant net benefit.CONCLUSION PPOI is a common complication following gastrectomy in patients with GC and is associated with age,cTNM stage,preoperative hypoproteinemia,and specific bowel sound-related indices(RTBS,NBS,and FBS).To facilitate early intervention and improve patient outcomes,clinicians should consider these factors,optimize preoperative nutritional status,and implement routine postoperative bowel sound monitoring.This study introduces an accessible machine learning model for predicting PPOI in patients with GC.

Research on Professional Teaching Reform of the E-Commerce Major in Vocational Colleges Under the Internet Era

With the rapid development of science and technology,the face of human society has undergone great changes;with the emergence of the Internet era,all kinds of educational technology,equipment,and software in vocational colleges have been widely used to carry out education and teaching,and has achieved remarkable results.Based on this,colleges and universities’electronic commerce(e-commerce)professional teachers should try to rely on the Internet to build information teaching classrooms,introduce advanced methods to build efficient classrooms by integrating teaching resources,and optimize the top-level design,so as to activate the classroom atmosphere,mobilize students’emotions,make them immersed in the teaching of electronic commerce courses.In view of this,this paper combines the existing theory and experience,first analyzes the dilemma faced by the current teaching of e-commerce in vocational colleges,then discusses the practical significance of teaching reform based on the Internet era,and lastly puts forward the specific practice path.

单孔与多孔胸腔镜肺叶切除术后3个月患者生活质量比较

背景与目的肺癌术后3个月的生活质量在不同手术入路之间的关系尚不明确,本研究旨在对比单孔与多孔胸腔镜肺叶切除术后3个月患者的生活质量。方法收集2021年4月至2021年10月在四川省肿瘤医院胸外科行肺部手术患者的资料,采用欧洲癌症研究与治疗组织生活质量核心量表C30 (European Organization for Research and Treatment of Cancer quality of life core 30,EORTC QLQ-C30)和肺癌生活质量量表29 (Quality of Life QuestionnaireLung Cancer 29,QLQ-LC29)收集患者的生活质量资料。将基线资料中潜在混杂因素纳入多因素回归模型中校正,比较两组患者术后3个月的生活质量与传统临床结局。结果共纳入130例肺癌患者,男性57例(43.8%),女性73例(56.2%),平均年龄(57.1±9.5)岁。两组患者基线资料中,放置引流管数量具有统计学差异(P<0.001)。经回归模型校正后,在术后3个月时,两组患者全部症状及功能状态评分无明显差异(P均>0.05)。多孔组的手术时间(120.0 min vs 85.0 min,P=0.001)、术后住院时间(6.0 d vs 4.0 d,P=0.020)比单孔组更长,早期>2级并发症发生率(39.0%vs 10.1%,P=0.011)比单孔组更高。结论单孔与多孔胸腔镜肺叶切除术患者在术后3个月时具有相似的生活质量。单孔组在手术时间、术后住院时间及术后早期并发症等传统临床结局指标上可能具有一定的优势。

长河流域枯水期水体硝酸盐源解析

通过识别研究区枯水期地表水和浅层地下水中溶解态无机氮(DIN)的分布特征,结合硝酸盐稳定同位素技术与水化学方法,并利用贝叶斯稳定同位素混合模型(SIAR),定量解析长河流域水体硝酸盐污染源,为流域水生态环境的修复治理提供理论支持。结果显示,研究区枯水期水体溶解态无机氮(DIN)以NO_(3)^(-)-N为主,NO_(3)^(-)-N平均占比为91.56%;水体生物地球化学过程以硝化作用为主;硝酸盐主要来自粪便和污水;SIAR模型计算结果表明,粪便和污水、土壤氮、化肥、大气沉降对研究区地表水硝酸盐的贡献比例分别为40.80%、30.60%、25.60%和3.00%;对浅层地下水硝酸盐的贡献比例分别为39.92%、32.11%、25.87%和2.10%。研究显示,人类活动对研究区水体影响强烈,加强排污设施基础建设,改善污水排放现象,是减少区域氮污染的关键因素。

长河流域δD、δ^(18)O特征及水体补给关系

研究流域不同水体δD、δ^(18)O特征及补给关系,可以进一步弄清流域水循环特征。以长河流域为对象,对枯、丰两水期各水体δD、δ^(18)O组成及分布特征进行分析。结果表明:(1)大气降水是长河流域主要补给源之一,受蒸发作用影响,同位素分馏导致水体中δD、δ^(18)O呈现出“枯水期较丰水期富集”的特征。(2)流域氘盈余值表现出枯水期低、丰水期高的差异,两个时期地表水与浅层地下水均受到了蒸发与水-岩作用影响,且枯水期影响更加强烈。(3)流域上游主要是地表水补给浅层地表水,中游两水间在季节上存在交替补给现象,下游为浅层地下水补给地表水。

系统性红斑狼疮患者的血清IgG糖链特征

系统性红斑狼疮(systemic lupus erythematosus,SLE)是一种发病机制不明、临床表型异质性大的自身免疫性疾病。目前已有的SLE血清生物标志物灵敏度或特异性有限,使得SLE的早期精准诊断存在困难。在本研究中,通过对389例SLE患者及304例健康对照者进行深入的糖组学分析,鉴定出血清免疫球蛋白G(IgG)上的两种N-糖链能够作为SLE的诊断生物标志物。在其他易与SLE混淆的系统性自身免疫性疾病(如类风湿性关节炎、原发性干燥综合征或系统性硬化症)中,这两种生物标志物没有出现显著变化,提示这两种N-糖链生物标志物对诊断SLE具有特异性。值得注意的是,这两种N-糖链生物标志物被证明是自身抗体非依赖性的,并且适用于所有阶段的SLE患者。基于片段特异性糖链分析和糖肽分析,发现这两种N-糖链生物标志物位于IgG上的Fc区域,并与疾病活动性密切相关。而酶学分析结果则提示,SLE患者体内一系列糖转移酶的失调可能是观察到的糖链产生变化的原因。研究结果为基于血清IgG糖基化的高效人群筛查和SLE潜在的新致病因素提供了新的思路。

SW-Net: A novel few-shot learning approach for disease subtype prediction

Few-shot learning is becoming more and more popular in many fields,especially in the computer vision field.This inspires us to introduce few-shot learning to the genomic field,which faces a typical few-shot problem because some tasks only have a limited number of samples with high-dimensions.The goal of this study was to investigate the few-shot disease sub-type prediction problem and identify patient subgroups through training on small data.Accurate disease subtype classification allows clinicians to efficiently deliver investigations and interventions in clinical practice.We propose the SW-Net,which simulates the clinical process of extracting the shared knowledge from a range of interrelated tasks and generalizes it to unseen data.Our model is built upon a simple baseline,and we modified it for genomic data.Supportbased initialization for the classifier and transductive fine-tuning techniques were applied in our model to improve prediction accuracy,and an Entropy regularization term on the query set was appended to reduce over-fitting.Moreover,to address the high dimension and high noise issue,we future extended a feature selection module to adaptively select important features and a sample weighting module to prioritize high-confidence samples.Experiments on simulated data and The Cancer Genome Atlas meta-dataset show that our new baseline model gets higher prediction accuracy compared to other competing algorithms.

QC工具在降低某车型横拉杆连接螺母返工率的应用

某车型生产线在新车型批量投产后,频繁出现横拉杆连接螺母不合格问题,导致月度返工率激增。针对该问题,通过应用质量管理(QC)工具进行原因分析,调查确定了套筒找螺母失败、锁止孔找锁止销失败是导致横拉杆连接螺母返工的关键因素。按照5W1H原则制定对策并组织优化改善措施,使返工率由攻关前的12.53%降低至1.25%。

Wheat powdery mildew resistance gene Pm64 derived from wild emmer (Triticum turgidum var.dicoccoides) is tightly linked in repulsion with stripe rust resistance gene Yr5

Stripe rust and powdery mildew are both devastating diseases for durum and common wheat.Pyramiding of genes conferring resistance to one or more diseases in a single cultivar is an important breeding approach to provide broader spectra of resistances in wheat improvement. A new powdery mildew resistance gene originating from wild emmer(Triticum turgidum var.dicoccoides) backcrossed into common wheat(T. aestivum) line WE35 was identified. It conferred an intermediate level of resistance to Blumeria graminis f. sp. tritici isolate E09 at the seedling stage and a high level of resistance at the adult plant stage. Genetic analysis showed that the powdery mildew resistance in WE35 was controlled by a dominant gene designated Pm64. Bulked segregant analysis(BSA) and molecular mapping indicated that Pm64 was located in chromosome bin 2 BL4-0.50–0.89. Polymorphic markers were developed from the corresponding genomic regions of Chinese Spring wheat and wild emmer accession Zavitan to delimit Pm64 to a 0.55 cM genetic interval between markers WGGBH1364 and WGGBH612, corresponding to a 15 Mb genomic region on Chinese Spring and Zavitan 2 BL, respectively. The genetic linkage map of Pm64 is critical for fine mapping and cloning. Pm64 was completely linked in repulsion with stripe rust resistance gene Yr5. Analysis of a larger segregating population might identify a recombinant line with both genes as a valuable resource in breeding for resistance to powdery mildew and stripe rust.

Combined probiotic bacteria promotes intestinal epithelial barrier function in interleukin-10-gene-deficient mice

AIM: To investigate the protective effects of combinations of probiotic (Bifico) on interleukin (IL)-10-gene-deficient (IL-10 KO) mice and Caco-2 cell monolayers.

Effect of liniment levamisole on cellular immune functions of patients with chronic hepatitis B

AIM: To explore the effects of liniment levamisole on cellular immune functions of patients with chronic hepatitis B. METHODS: The levels of T lymphocyte subsets and mlL-2R in peripheral blood mononuclear cells (PBMCs) were measured by biotin-streptavidin (BSA) technique in patients with chronic hepatitis B before and after the treatment with liniment levamisole. RESULTS: After one course of treatment with liniment levamisole, the levels of CD3+, CD4+, and the ratio of CD4+/CD8+ increased as compared to those before the treatment but the level of CD8+ decreased. The total expression level of mIL-2R in PBMCs increased before and after the treatment with liniment levamisole. CONCLUSION: Liniment levamisole may reinforce cellular immune functions of patients with chronic hepatitis B.

Protective effect of extracorporeal membrane pulmonary oxygenation combined with cardiopulmonary resuscitation on post-resuscitation lung injury

BACKGROUND: Cardiac arrest(CA) is a critical condition that is a concern to healthcare workers. Comparative studies on extracorporeal cardiopulmonary resuscitation(ECPR) and conventional cardiopulmonary resuscitation(CCPR) technologies have shown that ECPR is superior to CCPR. However, there is a lack of studies that compare the protective effects of these two resuscitative methods on organs. Therefore, we aim to perform experiments in swine models of ventricular fibrillation-induced CA to study whether the early application of ECPR has advantages over CCPR in the lung injury and to explore the protective mechanism of ECPR on the post-resuscitation pulmonary injury.METHODS: Sixteen male swine were randomized to CCPR(CCPR;n=8;CCPR alone) and ECPR(ECPR;n=8;extracorporeal membrane oxygenation with CCPR) groups, with the restoration of spontaneous circulation at 6 hours as an endpoint. RESULTS: For the two groups, the survival rates between the two groups were not statistically significant(P>0.05), the blood and lung biomarkers were statistically significant(P<0.05), and the extravascular lung water and pulmonary vascular permeability index were statistically significant(P<0.01). Compared with the ECPR group, electron microscopy revealed mostly vacuolated intracellular alveolar type II lamellar bodies and a fuzzy lamellar structure with widening and blurring of the blood-gas barrier in the CCPR group.CONCLUSIONS: ECPR may have pulmonary protective effects, possibly related to the regulation of alveolar surface-active proteins and mitigated oxidative stress response postresuscitation.

Alternative splicing of VEGFA,APP and NUMB genes in colorectal cancer

AIM:To investigate alternative splicing in vascular endothelial growth factor A(VEGFA),amyloid beta precursor protein(APP),and Numb homolog(NUMB) in colorectal cancer(CRC).METHODS:Real-time quantitative reverse transcriptase polymerase chain reaction(q RT-PCR) and PCRrestriction fragment length polymorphism analyses were performed to detect the expression of VEGFA,APP,and NUMB mR NA in 20 CRC tissues and matched adjacent normal tissues,as well as their alternative splicing variants.RESULTS:q RT-PCR analysis revealed that the expression of APP,NUMB,and VEGFA 165 b m RNA were significantly downregulated,while VEGFA m RNA was upregulated,in CRC tissues(all P < 0.05).PCRrestriction fragment length polymorphism analysis revealed that the expression of VEGFA 165a/b in CRC tissues was significantly higher than in adjacent normal tissues(P < 0.05).Compared with adjacent normal tissues,the expression of NUMB-PRRS in CRC tissues was significantly decreased(P < 0.05),and the expression of NUMB-PRRL was increased(P < 0.05).CONCLUSION:Alternative splicing of VEGFA,APP,and NUMB may regulate the development of CRC,and represent new targets for its diagnosis,prognosis,and treatment.

Late Paleozoic–Mesozoic subduction and accretion of the Paleo-Pacific Plate: Insights from ophiolitic rocks in the Wandashan accretionary complex, NE China

The Wandashan accretionary complex(AC),consisting of the Raohe and Yuejinshan complexes,is located on the continental margin of Northeast Asia and represents an excellent source of information about Paleo-Pacific subduction and accretion.However,the protolith nature and tectonic evolution of the Wandashan AC are under debate.This contribution reports new geochronological,geochemical,and Sr-Nd-Pb-Hf isotopic data for ophiolitic rocks from the Wandashan AC.The 169–166 Ma plagioclasites and homogeneous gabbros from the Raohe complex are OIBs while 228–214 Ma homogeneous gabbros are continental VABs.Cumulate gabbros from the Yuejinshan complex formed at 280–278 Ma and~220 Ma and have similar characteristics with E-MORB and N-MORB,respectively.They are BABBs and their primary magma was derived from a source region between EMI and EMII that was affected by continental crustal contamination as well as subduction-zone metasomatism.Combined with previous studies,we suggest that the onset of subduction of the Paleo-Pacific Plate was in the Early Permian.Subsequently,a back-arc basin,whose present suture is on the eastern margin of the Jiamusi Massif,formed and widened during 280–232 Ma,after which the basin closed and BABBs were emplaced to form the Yuejinshan complex during 210–180 Ma.The formation of VABs of the Raohe complex is coincident with the closure of the back-arc basin,and together with the 169–166 Ma OIBs,they constitute a major part of the Raohe complex.The accretionary process was completed during 133–131 Ma.Taken together,the ophiolitic rocks indicating multistage magmatism in the Paleo-Wandashan region recorded the formation-closure process of back-arc basin and the accretionary process of the Wandashan AC,during the westward subduction of the Paleo-Pacific plate.The back-arc basin identified in our study sheds new lights on geodynamic evolution model of subduction and accretion of the Paleo-Pacific Plate on the continental margin of NE Asia.

Effects of Different Selenium Application Methods on Wheat (Triticum aestivum L.) Biofortification and Nutritional Quality

Mineral nutrient malnutrition,especially deficiency in selenium(Se),affects the health of approximately 1 billion people worldwide.Wheat,a staple food crop,plays an important role in producing Se-enriched foodstuffs to increase the Se intake of humans.This study aimed to evaluate the effects of different Se application methods on grain yield and nutritional quality,grain Se absorption and accumulation,as well as 14 other trace elements concentrations in wheat grains.A sand culture experiment was conducted via a completely randomized 3×2×1 factorial scheme(three Se levels×two methods of Se application,foliar or soil×one Se sources,selenite),with two wheat cultivars(Guizi No.1,Chinese Spring).The results showed that both foliar Se and soil Se application methods had effects on wheat pollination.Foliar Se application resulted in early flowering of wheat,while soil Se application caused early flowering of wheat at low Se levels(5 mg kg^(−1))and delayed wheat flowering at high selenium levels(10 mg kg^(−1)),respectively.For trace elements,human essential trace elements(Fe,Zn,Mn,Cu,Cr,Mo,Co and Ni)concentrations in wheat grains were dependent of Se applica-tion methods and wheat cultivars.However,toxic trace elements(Cd,Pb,Hg,As,Li and Al)concentrations can be decreased by both methods,indicating a possible antagonistic effect.Moreover,both methods increased Se concentrations,and improved grain yield and nutritional quality,while the foliar application was better than soil.Accordingly,this study provided useful information concerning nutritional biofortification of wheat,indicating that it is feasible to apply Se to conduct Se biofortification,inhibit the heavy metal elements concentrations and improve yield and quality in crops,which caused human health benefits.

TET2 Expression in Bone Marrow Mononuclear Cells of Patients with Myelodysplastic Syndromes and Its Clinical Significances

Objective To investigate the expression of TET2 mRNA and protein in the bone marrow mononuclear cells （BMMNC） of patients with myelodysplastic syndrome （MDS） and its clinical significance. Methods The expression of TET2 mRNA and protein in bone marrow mononuclear cells （BMMNC） of 32 patients with MDS and 20 healthy donors was examined by qPCR and Western blot. Results The expression of TET2 mRNA in BMMNC was down-regulated in MDS patients compared with the donor group [（0.41±0.28）% vs. （1.07±0.56）%] （P〈0.001）. Compared with lower expression group （TET2〈0.4） [（6.53±6.17）%], patients with higher expression of TET2 ≥0.4） presented significantly lower proportion of bone marrow blasts [（1.21±1.56）%1 （P〈0.05）. The expression of TET2 mRNA in BMMNC of MDS patients was inversely correlated with malignant clone burden （t=--0.398, P〈0.05） and IPSS r=-0.412, P〈0.05）. The expression of TET2 protein was down-regulated in MDS patients compared with that in the donor group. Conclusions The mRNA and protein expression of TET2 in BMMNC of MDS patients is decreased, which might be useful as an important parameter for the evaluation of MDS clone burden.

Late contralateral recurrence of retinal detachment in incontinentia pigmenti:A case report

BACKGROUND Incontinentia pigmenti(IP)is a rare X-linked genetic disease.It mainly manifests as skin lesions and causes problems in the eyes,teeth,bones,and central nervous system.Of the various ocular manifestations,the most severe with difficult recovery is retinal detachment(RD).Here,we report an unusual case of bilateral asymmetrical RD.CASE SUMMARY We present the case of an 11-year-old Chinese girl with IP who complained of sudden blurring of vision in the left eye.At that time,she had been blind in her right eye for 4 years.RD with traction was observed in both eyes.A massive retinal proliferative membrane,exudation,and hemorrhage were seen in the left eye.We performed vitrectomy in her left eye.Her visual acuity recovered to 20/50,and her retina had flattened within 2 d after surgery.During the 3-mo follow-up,we performed retinal laser treatment of the non-perfused retinal area in her left eye.Eventually,her visual acuity returned to 20/32,and no new retinal abnormalities developed.CONCLUSION In patients with IP with fundal abnormalities in one eye,it is important to focus on the rate of fundal change in the other eye.RD in its early stages can be effectively treated with timely vitrectomy and laser photocoagulation.

Prevalence of post-traumatic stress disorder after earthquakes among the elderly in China: A meta-analysis

BACKGROUND: The study aims to investigate the occurrence of post-traumatic stress disorder(PTSD) after earthquakes among the elderly. METHODS: Data from cross-sectional studies focusing on the prevalence of PTSD after earthquakes among the elderly were collected from Pub Med, EMBASE, Cochrane Library, and China National Knowledge Infrastructure in December 2019. The search terms included post-traumatic stress disorder, earthquake, and elderly. This study used Review Manager 5.0 to evaluate the impact of the results. In addition, forest plots, sensitivity analysis, and bias analysis were carried out on the included articles. The combined estimate of the risk ratio and the standard deviation of the 95% confidence interval(95% CI) were measurements of the size of the effect.RESULTS: There were 4,834 patients included from 10 eligible studies. The sample sizes of PTSD group and non-PTSD group were 1,277 and 3,557, respectively. The meta-analysis showed that the overall occurrence of PTSD after earthquakes among the elderly was 0.25;the occurrence in females was higher than that in males, and the occurrence in the same province indicated little difference(Wenchuan city 0.25 and Ya'an city 0.24).CONCLUSIONS: After earthquakes, the occurrence of PTSD is higher among the elderly than among other age groups, and higher among the females than among the males, while there is little difference among different areas within the same province. This indicated that prioritized specific psychological interventions should be provided to the aged and the females.

Expression of DLK1 Gene in the Bone Marrow Cells of Patients with Myelodysplastic Syndromes and Its Clinical Significance

Objective This study aims to investigate the expression of delta-like 1 （DLK1） gene in the bone marrow cells of patients with myelodysplastic syndromes （MDS） and to explore its molecular characteristics for the early diagnosis of MDS. Methods The expression of DLK1 mRNA in the bone marrow cells of cases with MDS, acute myeloid leukemia （AML）, and normal control groups were measured by real-time polymerase chain reaction and were analyzed for clinical significance. Results Significantly higher expression of DLK1 mRNA was observed in the bone marrow cells of MDS patients （0.7342±0.3652） compared with the normal control group （0.4801±0.1759） （P〈0.05）. The expression of DLK1 mRNA had a positive correlation with the proportion of bone marrow blasts （r=0.467, P〈0.05）. Moreover, DLK1 mRNA expression was significantly increased as MDS progressed （P〈0.05）. Patients with abnormal karyotypes exhibited significantly higher expression of DLK1 mRNA （0.9007±0.4334） than those with normal karyotypes （0.6411±0.2630） （P〈0.05）. Subsequently, patients with highly expressed DLK1 （≥0.8） presented significantly higher malignant clone burden （0.4134±0.3999） than those with lower DLK1 expression （〈0.8）,（0.1517±0.3109）, （P〈0.05）. Conclusions The DLK1 gene was highly expressed in MDS patients, and was increased as MDS progressed. The expression of DLK1 mRNA was positively correlated with the proportion of the bone marrow blasts. A high expression of DLK1 gene suggested a higher malignant clone burden of MDS.