基于C#的Excel数据导入导出研究与实现

为了提高信息管理系统中数据导入导出操作的灵活性和通用性,本文详细介绍了在Visual Studio 2008使用C#语言、通过引用Office的COM组件技术,结合Microsoft SQL Server 2005实现了Excel数据导入到数据库以及数据库数据导出到Excel的设计思路和实现方法。实践证明该方法有较强的通用性和实用性。     

基于分层的改进A＊算法在路径规划中的应用

智能交通中的路径诱导系统能够极大地提高人们的出行效率与出行体验。经典A＊算法只注重搜索精度而忽略了搜索效率,在城市道路网络分层的基础上,对高层道路使用的A＊算法进行了改进,对于道路网络中的不同节点,设置估价函数具有不同的权值,同时给定权值的一个上下限阈值,以平衡算法的搜索效率与搜索精度。实验表明,得到的最短路径虽然不是常规的距离最短却是实际行驶时间最优的。     

深水表层钻井随钻压力与温度监测装置设计

深水表层钻井随钻压力与温度监测装置是监测深水表层钻井过程中井底当量循环密度（ECD）和循环温度的重要工具。通过深水表层钻井随钻压力与温度监测装置,现场技术人员可以实时掌握井下环空压力、钻柱内压和温度等工程参数,进而了解和分析井下工况,为深水表层钻井作业和动态压井钻井技术提供指导。设计的深水表层钻井随钻压力与温度监测装置以ARM为核心,利用数据采集技术和通信技术,实现了随钻压力与温度的采集传输。完成的深水表层钻井随钻压力与温度监测装置具有体积小、功耗低、抗振动和抗高温和低温的优点。监测装置已经在我国南海第一口深水井LW6—1—1井的领眼井中成功进行应用试验,验证了其在深水无隔水管钻井条件下的机械强度、稳定性、可靠性,测量得的数据能真实反映钻井工况。     

光纤光栅传感器中磁场测量稳定性研究

为了减小光纤光栅磁场传感器中线性双折射和入射起偏角对系统稳定性的影响,提高测量系统的准确性,提出一种减小线性双折射和起偏角大小对系统输出影响的设计方案。研究了基于法拉第效应的光纤光栅磁场传感器系统,得出系统输出电压与磁场的关系式,并通过降低线性双折射和确定入射起偏角改善了系统的输出特性。仿真表明:该方法可以有效抑制测量过程中线性双折射造成的非线性关系,从而提高磁场测量的稳定性。     

基于FDR原理的自动灌溉系统设计

利用土壤的介电特性测量土壤含水量是一种快速、简便、可靠的方法。根据频域反射(FDR)法测量原理,电磁波在土壤中的传播频率可用来测试土壤的介电常数,从而得到土壤容积含水率,设计出了一种基于FDR原理的自动灌溉系统,介绍了FDR测量原理,阐述了自动灌溉系统的软硬件构成,土壤水分传感器测得的土壤水分含量信息,经信号处理,输出为0~5V电压信号,经A/D转换送至AT89S52单片机进行判断处理,根据输出数值的大小控制电磁阀的通断时间,从而实现自动灌溉和节水灌溉的目的。试验表明:该系统工作稳定,控制准确,反应灵敏,满足自动灌溉要求。     

基于损益云模型的制造车间重调度决策方法

针对制造车间重调度触发机制问题,建立了制造车间重调度损益函数,揭示了生产车间重调度过程损失及增益的变化规律.引入云理论测度重调度损益的不确定性,使用逆向云算法计算重调度增益云和损失云的数字特征,根据云形态预测重调度损益变化趋势.提出一种基于损益云模型的重调度决策方法以判断是否需要重调度,并利用最佳损益比甄选预调度方案以兼顾生产系统的稳定性和有效性.最后,通过实例验证了该方法的合理性和实用性.     

Multi-label core vector machine with a zero label

Multi-label core vector machine (Rank-CVM) is an efficient and effective algorithm for multi-label classification. But there still exist two aspects to be improved: reducing training and testing computational costs further, and detecting relevant labels effectively. In this paper, we extend Rank-CVM via adding a zero label to construct its variant with a zero label, i.e., Rank-CVMz, which is formulated as the same quadratic programming form with a unit simplex constraint and non-negative ones as Rank-CVM, and then is solved by Frank–Wolfe method efficiently. Attractively, our Rank-CVMz has fewer variables to be solved than Rank-CVM, which speeds up training procedure dramatically. Further, the relevant labels are effectively detected by the zero label. Experimental results on 12 benchmark data sets demonstrate that our method achieves a competitive performance, compared with six existing multi-label algorithms according to six indicative instance-based measures. Moreover, on the average, our Rank-CVMz runs 83 times faster and has slightly fewer support vectors than its origin Rank-CVM.     

面向金泽水库取水安全的太浦河多目标联合调度研究

为强化上海市黄浦江供水系统的重要组成部分金泽水源地取水安全,又兼顾太湖流域及太浦河沿线区域防洪、供水需求,开展了太浦河太浦闸与沿线88个闸控口门的多目标联合调度研究。在分析太浦闸及两岸河道现有调度方式的基础上,拟定了两类共10个联合调度方案。采用细化后的太湖流域水量水质模型,对各调度方案进行了模拟。然后,构建了反映防洪、供水、水环境需求的多目标函数,采用蚁群优选算法对所有调度方案进行了优选。结果表明:与现状调度方案相比,太浦闸同时根据太湖水位和金泽断面水质情况加大下泄流量,同时太浦河沿线河道闸门有序控制,可显著提高金泽水源地关键水质指标达标率、抬升金泽水源地最低水位,又基本不影响流域及区域其他调度需求。     

脂肪酸系列表面活性剂的研究进展

概括和综述了4大类10余个脂肪酸系列表面活性剂的合成、性能和应用现状，重点评述了烷醇酰胺及其衍生物、乙氧基化脂肪酸甲酯、脂肪酸甲酯磺酸盐、N-酰基ED3A、氨基酸、咪唑啉、甜菜碱、双子表面活性剂等脂肪酸系列表面活性剂的研究进展。此系列表面活性剂易生物降解、安全、多功能和高效能。     

Effect of fretting amplitudes on fretting wear behavior of steel wires in coal mines

Given that fretting wear causes failure in steel wires, we carried out tangential fretting wear tests of steel wires on a self-made fretting wear test rig under contact loads of 9 and 29 N and fretting amplitudes ranging from 5 to 180 μm. We observed morphologies of fretted steel wire surfaces on an S-3000N scanning electron microscope in order to analyze fretting wear mecha-nisms. The results show that the fretting regime of steel wires transforms from partial slip regime into mixed fretting regime and gross slip regime with an increase in fretting amplitudes under a given contact load. In partial slip regime, the friction coefficient has a relatively low value. Four stages can be defined in mixed fretting and gross slip regimes. The fretting wear of steel wires in-creases obviously with increases in fretting amplitudes. Fretting scars present a typical morphology of annularity, showing slight damage in partial slip regime. However, wear clearly increases in mixed fretting regime where wear mechanism is a combination of plastic deformation, abrasive wear and oxidative wear. In gross slip regime, more severe degradation is present than in the other regimes. The main fretting wear mechanisms of steel wires are abrasive wear, surface fatigue and friction oxidation.