在Power Builder中结合Formula One实现复杂报表

在应用程序开发中多数时候只能实现规则的报表 ,在实际应用中为了突出鲜明的层次感 ,开发者往往需要根据不同情况实现不规则的动态报表。本文阐述了在使用PowerBuilder开发应用程序中 ,如何使用第三方控件FormulaOne来实现复杂的动态报表 ,从而增强Power

如何用PowerBuilder和Formula One结合制作报表

介绍一种新颖的动态报表生成方法,即利用PB和Formula one结合来处理复杂的报表问题。本文对这种方法的设计思想以及实现过程进行了一定的讨论。

基于Delphi中Formula One构件的复杂中文报表的生成

用Delphi开发管理应用程序时 ,可利用FormulaOne构件强大的电子制表、数据分析和数据处理能力来弥补Quick -Report报表功能的局限性 ,增加应用程序报表的灵活性。阐述了在Del phi环境中用FormulaOne构件生成复杂中文报表的方法。该方法灵活、便捷。

利用Formula One控件实现数据窗口及其信息交换

为了满足一定的数据组织格式以及实现数据交换与共享 ,在数据窗口设计中引入了FormulaOneActiveX控件。介绍了一种通用的设计方法 ,在此基础上实现一个应用实例 ,并对其开发程序的性能进行了总结。

Evaluation of the famous classic formula Sanhua decoction based on network pharmacology and multi-component quantitative analysis

Background:Sanhua decoction has significant effects in the treatment of stroke.The study of the Sanhua decoction material benchmark was carried out to analyze the value transfer relationship between the Chinese herbal pieces and the substance benchmark.Methods:Network pharmacology was employed to investigate the potential active components and molecular mechanisms of Sanhua decoction in the treatment of stroke.15 batches of Sanhua decoction lyophilized powder were prepared using traditional formulas and subjected to high-performance liquid chromatography analysis to generate fingerprints of the Sanhua decoction substance benchmarks.Then,a multi-component quantitative analysis method was established,allowing for the simultaneous determination of ten components,to study the transfer of quantity values between pieces and substance benchmarks.Results:60 active ingredients were screened from Sanhua decoction by network pharmacology,of which gallic acid,magnolol honokiol,physcion,and aloe-emodin may have a greater effect than other active components.63 key targets and 134 pathways were predicted as the potential mechanism of Sanhua decoction in treating stroke.The fingerprint similarity of the Sanhua decoction substance benchmarks was found to be good among the 15 batches,confirming the 19 common peaks.The content of the 10 components was basically consistent.The components’transfer rates were within 30%of their respective means.Conclusions:This study provided a comprehensive and reliable strategy for the quality evaluation of Sanhua decoction substance benchmarks and held significant importance in improving its application value.

Optimal traditional Chinese medicine formulas in treating ulcerative colitis:Choose one or take it all?

Ulcerative colitis(UC)is a chronic inflammatory bowel disease that presents significant treatment challenges due to its complexity,especially in terms of the various side effects that traditional medications may bring during the chronic course of the disease.Traditional Chinese medicine(TCM)has emerged as a promising complementary therapy for UC.Based on the latest research,our editorial explored the current issues and potential essential research directions for TCM in treating UC.We anticipate that future high-quality research will pave the way for the optimization of TCM formulas for UC and their broader global application.

Software-aided efficient identification of the components of compound formulae and their metabolites in rats by UHPLC/IM-QTOF-MS and an in-house high-definition MS^(2) library: Sishen formula as a case

Identifying the compound formulae-related xenobiotics in bio-samples is full of challenges.Conventional strategies always exhibit the insufficiencies in overall coverage,analytical efficiency,and degree of automation,and the results highly rely on the personal knowledge and experience.The goal of this work was to establish a software-aided approach,by integrating ultra-high performance liquid chromatography/ion-mobility quadrupole time-of-flight mass spectrometry(UHPLC/IM-QTOF-MS)and in-house high-definition MS^(2) library,to enhance the identification of prototypes and metabolites of the compound formulae in vivo,taking Sishen formula(SSF)as a template.Seven different MS2 acquisition methods were compared,which demonstrated the potency of a hybrid scan approach(namely high-definition data-independent/data-dependent acquisition(HDDIDDA))in the identification precision,MS1 coverage,and MS^(2) spectra quality.The HDDIDDA data for 55 reference compounds,four component drugs,and SSF,together with the rat bio-samples(e.g.,plasma,urine,feces,liver,and kidney),were acquired.Based on the UNIFI™platform(Waters),the efficient data processing workflows were established by combining mass defect filtering(MDF)-induced classification,diagnostic product ions(DPIs),and neutral loss filtering(NLF)-dominated structural confirmation.The high-definition MS^(2) spectral libraries,dubbed in vitro-SSF and in vivo-SSF,were elaborated,enabling the efficient and automatic identification of SSF-associated xenobiotics in diverse rat bio-samples.Consequently,118 prototypes and 206 metabolites of SSF were identified,with the identification rate reaching 80.51%and 79.61%,respectively.The metabolic pathways mainly involved the oxidation,reduction,hydrolysis,sulfation,methylation,demethylation,acetylation,glucuronidation,and the combined reactions.Conclusively,the proposed strategy can drive the identification of compound formulae-related xenobiotics in vivo in an intelligent manner.

Fanlian Huazhuo formula:A promising therapeutic approach for metabolic associated steatotic liver disease

This article reviews the study,“Fanlian huazhuo formula alleviates high-fat-dietinduced nonalcoholic fatty liver disease by modulating autophagy and lipid synthesis signaling pathway”published in the World Journal of Gastroenterology.The study explores the therapeutic potential of Fanlian Huazhuo formula(FLHZF)in treating metabolic-associated steatotic liver disease(MASLD),demonstrating that FLHZF reduces lipid accumulation,oxidative stress,and liver injury in MASLD models by modulating key signaling pathways involved in lipid metabolism and autophagy.This editorial emphasizes the potential of FLHZF as a treatment for MASLD and calls for further research to verify its clinical efficacy.

Unraveling the mechanism of action of Shangxia Liangji formula for treating insomnia:a metabolomics and network pharmacology approach

Background:Insomnia is a prevalent clinical condition and Shangxia Liangji formula(SXLJF)is a well-established method of treatment.Nevertheless,the specific mechanism of action of SXLJF remains unclear.Methods:The mouse model of insomnia was established by intraperitoneal injection of para-chlorophenylalanine.Forty-two mice were randomly divided into a negative control group,model group,SXLJF group(18.72 g/kg/day),and positive control group(diazepam,2 mg/kg)and treated with the corresponding drugs for 7 consecutive days.The open field test and pentobarbital-induced sleeping test were conducted.LC-MS-based untargeted metabolomics and network pharmacology were applied to explore the potential targets of SXLJF for treating insomnia.Finally,key targets were validated using RT-qPCR.Results:Behavioral tests demonstrated that SXLJF reduced the total distance,average velocity,central distance,and sleep latency,and prolonged sleep duration.Metabolomics and network pharmacology revealed potential targets,signaling pathways,metabolic pathways,and metabolites associated with the anti-insomnia effects of SXLJF.Specifically,tyrosine hydroxylase(TH)and tyrosine metabolism emerged as crucial metabolic pathways and targets,respectively.RT-qPCR results supported the role of TH in the mechanism of SXLJF in treating insomnia.Conclusion:In conclusion,TH and tyrosine metabolism may represent significant targets and pathways for SXLJF in treating insomnia.

Formula One’s Financial Crisis

The global economic slowdown is bad news for F1 auto racing Formula One (Fl), the world’s most expensive sport, faces major changes next season as Fl teams and the sport’s sanctioning body, the

Study on Preservative Formula and Shelf Life of Cantonese Style Moon Cakes

To ensure the safety of consumers, prolong the shelf life of moon cake and reduce the cost of manufacturing and marketing enterprises, the optimization of preservative formula and the shelf life of cantonese style moon cake were studied. Through single and compound formula preservative test, the results showed that potassium sorbate and sodium dehydroacetate could inhibit the microorganisms in the moon cake, but the inhibitory effect of sodium dehydroacetate was stronger than that of potassium sorbate; and the combination of potassium sorbate and sodium dehydroacetate had a synergistic effect, and the best formula is ＇potassium sorbate 0.44 g/kg mixed with sodium dehydroacetate 0.38 g/kg. A batch of moon cake was prepared with the best preservative formula, then the total number of colonies, molds and coliform group in the samples were detected by random sampling at irregular intervals. The total number of molds exceeded the limit on the 187^th d, and it indicated that the shelf life of the product was 187 d. Compared with the conventional 15-day shelf life, this research greatly prolongs the sheff life of cantonese style moon cake, and cut down the cost of moon cake enterprises. It is worthy of popularization and application.

FORMULA ONE PK FOOTBALL

四年一次的这场盛会与F1本身就有很多共通点,首先大家的英文名字都以F开头,然后一场足球比赛有22名球员,而一场F1大奖赛现在也有22名车手。

Multimodal Identification by Transcriptomics and Multiscale Bioassays of Active Components in Xuanfeibaidu Formula to Suppress Macrophage-Mediated Immune Response

Xuanfeibaidu Formula (XFBD) is a Chinese medicine used in the clinical treatment of coronavirus disease 2019 (COVID-19) patients. Although XFBD has exhibited significant therapeutic efficacy in clinical practice, its underlying pharmacological mechanism remains unclear. Here, we combine a comprehensive research approach that includes network pharmacology, transcriptomics, and bioassays in multiple model systems to investigate the pharmacological mechanism of XFBD and its bioactive substances. High-resolution mass spectrometry was combined with molecular networking to profile the major active substances in XFBD. A total of 104 compounds were identified or tentatively characterized, including flavonoids, terpenes, carboxylic acids, and other types of constituents. Based on the chemical composition of XFBD, a network pharmacology-based analysis identified inflammation-related pathways as primary targets. Thus, we examined the anti-inflammation activity of XFBD in a lipopolysaccharide-induced acute inflammation mice model. XFBD significantly alleviated pulmonary inflammation and decreased the level of serum proinflammatory cytokines. Transcriptomic profiling suggested that genes related to macrophage function were differently expressed after XFBD treatment. Consequently, the effects of XFBD on macrophage activation and mobilization were investigated in a macrophage cell line and a zebrafish wounding model. XFBD exerts strong inhibitory effects on both macrophage activation and migration. Moreover, through multimodal screening, we further identified the major components and compounds from the different herbs of XFBD that mediate its anti-inflammation function. Active components from XFBD, including Polygoni cuspidati Rhizoma, Phragmitis Rhizoma, and Citri grandis Exocarpium rubrum, were then found to strongly downregulate macrophage activation, and polydatin, isoliquiritin, and acteoside were identified as active compounds. Components of Artemisiae annuae Herba and Ephedrae Herba were found to substantially inhibit endogenous macrophage migration, while the presence of ephedrine, atractylenolide I, and kaempferol was attributed to these effects. In summary, our study explores the pharmacological mechanism and effective components of XFBD in inflammation regulation via multimodal approaches, and thereby provides a biological illustration of the clinical efficacy of XFBD.

Correlation analysis and multiple regression formulas of refractive errors and ocular components

The multiple regression formulas and correlation of ocular components with refractive errors are presented by Gaussian optics. The refractive error changing rate for the cornea and lens power, the axial length, anterior chamber depth(ACD) and vitreous chamber depth(VCD) are calculated, including nonlinear terms for more accurate rate functions than the linear theory. Our theory, consistent with the empirical data, shows that the Pearson correlation coefficients for spherical equivalent(SE) and ocular components are highest for SE with axial length, ACD and VCD and weakest for corneal power, lens power and lens thickness. Moreover, our regression formulas show the asymmetric feature of the correlation that the axial length, ACD and VCD are more strongly correlated(with higher negative regression constants) with refractive errors in eyes with hyperopia than in eyes with myopia, particularly for severe hyperopia.

Effects of Qing’E Formula on the Expression of Bone Metabolic Markers and VDR mRNA in Postmenopausal Osteoporosis Patients

Objectives: To study the partial mechanism of treating postmenopausal osteoporosis patients (POPs) using the ancient recipe of Qing’E Formula (QEF) by observing its effects on bone metabolic markers and VDR mRNA expression in primary POPs. Methods: Analysis was performed on 120 outpatient and inpatient POPs treated in our hospital between January and October 2013, where the patients were randomly divided into Qing’E group (QEF + Caltrate), Calcitriol group (Caltrate + Calcitriol soft capsules), and Compare group (Caltrate), each with a follow-up period of 1 year. Statistical analysis was then performed on bone mineral density, blood bone metabolic markers (β-CTX, N-MID, T-PINP) and changes in VDR mRNA expressions in the POPs before and after the treatments. Results: Prior to the treatments, bone mineral density and blood β-CTX, N-MID, T-PINP and VDR mRNA expression in the 3 groups of POPs exhibited no statistically significant differences, and the blood β-CTX, N-MID, T-PINP and VDR mRNA expression in the control group showed no statistically significant differences before and after the treatments. There were no significant differences in bone mineral density in the Qing’E group and the Calcitriol group before and after the treatments whereas the bone mineral density decreased in the control group after the treatments. As for blood β-CTX, N-MID, T-PINP and VDR mRNA expression, the measurements in POPs in the Qing’E group and the Calcitriol group were significantly higher than that of the control group. Conclusion: By adjusting the VDR mRNA expression, the QEF, a kidney-invigorating Chinese herbal formula, is capable of activating bone metabolism to prohibit further losses of bone mass, thereby preventing the deterioration of osteoporosis.

Stoney formula for piezoelectric film/elastic substrate system

With the trends in miniaturization, and particularly the introduction of micro- and nano-electro-mechanical system, piezoelectric materials used in microelectronic devices are deposited usually in the form of thin film on elastic substrates. In this work, the bending of a bilayer comprising a piezoelectric film deposited on an elastic substrate, due to the mismatch, is investigated. An analytic formula relating the curvature of the bilayer to the mismatch, the electroelastic constants and the film thickness is obtained, and from this formula, a transverse piezoelectric constant d31 can be estimated. Meanwhile the influence of electrornechanical coupling coefficient on the curvature is discussed.

Efficacy and safety of traditional Chinese medicine kidney-nourishing formula for Alzheimer's disease in comparison with donepezil:a systematic review and meta-analysis

Objective:Finding an effective therapy against Alzheimer’s disease(AD)has been associate increasingly pressing issue and traditional Chinese medicine(TCM)is widespread in the prevention and treatment of AD in China.The aim of this study was to judge the efficaciousness and safety of TCM kidney-nourishing(the changes of pathological state of kidney deficiency by means of TCM treatment and so on)formula(TKNF)for AD in comparison with donepezil.Methods:The retrieval period of seven databases was from the establishment of each database to April 2019.Two authors independently identified randomized controlled trials(RCTs),fetched data and assessed bias risk.Comprehensive analysis process was conducted with review manager for eligible and appropriate RCTs.Results:A complete of 981 AD patients from 13 studies were enclosed.Meta-analysis of RCTs showed that there was no significant difference in the improvement of Alzheimer's disease assessment scale-cognitive subscale score between 2 groups in short term,but the effect of long-term treatment may exceed donepezil;there was a significant difference in the improvement of activities of daily living score between 2 groups;there was a significant difference in TCM curative efficacy between 2 groups with long-term treatment.There was no significant difference in the incidence of adverse events between 2 groups.The quality of the evidence was high or moderate.Conclusion:Compared with donepezil,TKNF was an effective drug for AD patients and the clinical application of TKNF was safe.TKNF's long-term benefits need more evidence to verify.

The exciting and magical journey of components from compound formulae to where they fight

With its long-term empirical clinical practice and increasing number of health benefits reported,Chinese Materia Medica(CMM)is gaining increasing global acceptance.Importantly,the identification of chemical constituents in vitro and exposed forms in vivo is a prerequisite for understanding how CMM formulae prevent and treat diseases.This review systematically summarizes the exciting and magical journey of CMM components from compound formulae to where they fight,the possible structural transformation of CMM components in vitro and in vivo,and their pharmacological contribution.When a decoction is prepared,significant chemical reactions are observed,including degradation and production of polymers and self-assembling supramolecules,leading to the construction of a component library with diverse decoction structures.After ingestion,compounds pass through the intestinal and blood-brain barriers and undergo a more wonderful journey involving the gut microbiota,microbial enzymes,and endogenous drug-metabolizing enzymes(mainly liver enzymes).At this stage,they are modified and assembled into novel and complex compounds,such as newly generated metabolites,conjugates,and self-assembling superamolecules.This review might provide a strategic orientation to explore the active compounds of CMM formulae in vivo.