Article(id=1187027209475731971, tenantId=1146029695717560320, journalId=1185652524569653253, issueId=1187027204178326004, articleNumber=1009-5438(2024)06-0084-04, orderNo=null, doi=null, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=null, receivedDate=1717430400000, receivedDateStr=2024-06-04, revisedDate=null, revisedDateStr=null, acceptedDate=null, acceptedDateStr=null, onlineDate=1760938940638, onlineDateStr=2025-10-20, pubDate=1735056000000, pubDateStr=2024-12-25, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1760938940638, onlineIssueDateStr=2025-10-20, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1760938940638, creator=13701087609, updateTime=1760938940638, updator=13701087609, issue=Issue{id=1187027204178326004, tenantId=1146029695717560320, journalId=1185652524569653253, year='2024', volume='50', issue='6', pageStart='1', pageEnd='98', issueExtLink='null', onlineDate='null', pubDate='null', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=-1, specialIssue=null, createTime=1760938939375, creator=13701087609, updateTime=1760939191531, updator=13701087609, preIssue=null, nextIssue=null, ext={EN=IssueExt(id=1187028261868548309, tenantId=1146029695717560320, journalId=1185652524569653253, issueId=1187027204178326004, language=EN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=), CN=IssueExt(id=1187028261868548310, tenantId=1146029695717560320, journalId=1185652524569653253, issueId=1187027204178326004, language=CN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=)}, issueFiles=null}, startPage=84, endPage=87, ext={EN=ArticleExt(id=1187100786451431800, articleId=1187027209475731971, tenantId=1146029695717560320, journalId=1185652524569653253, language=EN, title=Rapid Extraction of Test Data for Water Pressure of Steel Pipe with Access Database and WinCC VBScript, columnId=1187100786392711543, journalTitle=Science & Technology of Baotou Steel, columnName=Equipment and Automation, runingTitle=null, highlight=null, articleAbstract=

The purpose of testing water pressure of steel pipe is to confirm whether there is any water leakage with authorised pressure so as to ensure its performances to meet user requirements. In order to manage the test data for water pressure of steel pipes more effectively and improve flexibility of reports, the test data sheet for water pressure of steel pipes is established with Access database. The archiving and extraction of test data for water pressure of steel pipes are realized by using codes of WinCC VBScript and adopting mode of instruction programming so that the analytical capability for water pressure of steel pipes is improved. As a result, the archiving management of data is more user-friendly, which wins user’s recognition.

, correspAuthors=null, authorNote=null, correspAuthorsNote=null, copyrightStatement=null, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=null, magXml=null, pdfUrl=null, pdf=null, pdfFileSize=null, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=null, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=null, mapNumber=null, authorCompany=null, fund=null, authors=null, authorsList=Zhao Hai-yan, Duan Rui, Guo Qiang, Li Jun, Zhang Ming), CN=ArticleExt(id=1187027294846595646, articleId=1187027209475731971, tenantId=1146029695717560320, journalId=1185652524569653253, language=CN, title=利用Access数据库和WinCC VBScript快速提取钢管水压的测试数据, columnId=1185882040256840459, journalTitle=包钢科技, columnName=设备与自动化, runingTitle=null, highlight=null, articleAbstract=

钢管水压测试的目的是确认在规定压力下钢管是否漏水,从而保证其性能符合用户的要求。为了更有效地管理钢管水压的测试数据并提高报表的灵活性,利用Access数据库建立钢管水压测试数据表,通过使用WinCC VBScript代码,采用指令编程的方式,实现了钢管水压测试数据的归档和提取,提高了对钢管水压测试数据的分析能力,使数据的归档管理更加人性化,赢得了用户的认可。

, correspAuthors=null, authorNote=null, correspAuthorsNote=null, copyrightStatement=null, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=lk8agwljZGmNQWANlx6fUQ==, magXml=071LZPznnkNG4fFPOvxVKw==, pdfUrl=null, pdf=Tuj/aEfwhRbxh611ou2fmw==, pdfFileSize=null, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=null, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=pX7EVdXwCcFp2Oyt0i8v/w==, mapNumber=null, authorCompany=null, fund=null, authors=

赵海燕(1970-),男,内蒙古包头市人,硕士,高级工程师,现从事设备管理工作。

, authorsList=赵海燕, 段瑞, 郭强, 李军, 张明)}, authors=[Author(id=1187100875211293189, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1187100875286790663, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875211293189, language=EN, stringName=Zhao Hai-yan, firstName=Zhao, middleName=null, lastName=Hai-yan, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1187100875345510920, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875211293189, language=CN, stringName=赵海燕, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=内蒙古包钢钢管有限公司,内蒙古 包头 014010, bio={"content":"

赵海燕(1970-),男,内蒙古包头市人,硕士,高级工程师,现从事设备管理工作。

"}, bioImg=null, bioContent=

赵海燕(1970-),男,内蒙古包头市人,硕士,高级工程师,现从事设备管理工作。

, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1187100875152572929, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, xref=null, ext=[AuthorCompanyExt(id=1187100875156767234, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China), AuthorCompanyExt(id=1187100875160961539, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=内蒙古包钢钢管有限公司,内蒙古 包头 014010)])]), Author(id=1187100875395842570, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, orderNo=1, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1187100875462951436, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875395842570, language=EN, stringName=Duan Rui, firstName=Duan, middleName=null, lastName=Rui, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1187100875521671693, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875395842570, language=CN, stringName=段瑞, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=内蒙古包钢钢管有限公司,内蒙古 包头 014010, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1187100875152572929, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, xref=null, ext=[AuthorCompanyExt(id=1187100875156767234, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China), AuthorCompanyExt(id=1187100875160961539, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=内蒙古包钢钢管有限公司,内蒙古 包头 014010)])]), Author(id=1187100875576197647, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, orderNo=2, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1187100875643306513, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875576197647, language=EN, stringName=Guo Qiang, firstName=Guo, middleName=null, lastName=Qiang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1187100875710415378, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875576197647, language=CN, stringName=郭强, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=内蒙古包钢钢管有限公司,内蒙古 包头 014010, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1187100875152572929, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, xref=null, ext=[AuthorCompanyExt(id=1187100875156767234, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China), AuthorCompanyExt(id=1187100875160961539, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=内蒙古包钢钢管有限公司,内蒙古 包头 014010)])]), Author(id=1187100875764941332, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, orderNo=3, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1187100875815272982, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875764941332, language=EN, stringName=Li Jun, firstName=Li, middleName=null, lastName=Jun, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1187100875865604631, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875764941332, language=CN, stringName=李军, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=内蒙古包钢钢管有限公司,内蒙古 包头 014010, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1187100875152572929, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, xref=null, ext=[AuthorCompanyExt(id=1187100875156767234, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China), AuthorCompanyExt(id=1187100875160961539, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=内蒙古包钢钢管有限公司,内蒙古 包头 014010)])]), Author(id=1187100875915936281, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, orderNo=4, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1187100875983045147, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875915936281, language=EN, stringName=Zhang Ming, firstName=Zhang, middleName=null, lastName=Ming, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null), CN=AuthorExt(id=1187100876037571100, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, authorId=1187100875915936281, language=CN, stringName=张明, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=内蒙古包钢钢管有限公司,内蒙古 包头 014010, bio=null, bioImg=null, bioContent=null, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1187100875152572929, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, xref=null, ext=[AuthorCompanyExt(id=1187100875156767234, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China), AuthorCompanyExt(id=1187100875160961539, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=内蒙古包钢钢管有限公司,内蒙古 包头 014010)])])], keywords=[Keyword(id=1187100876155011613, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, orderNo=1, keyword=Access), Keyword(id=1187100876238897694, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, orderNo=2, keyword=WinCC VBScript), Keyword(id=1187100876352143903, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, orderNo=3, keyword=archiving and report), Keyword(id=1187100876431835680, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, orderNo=4, keyword=rapid extraction), Keyword(id=1187100876498944545, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, orderNo=1, keyword=Access), Keyword(id=1187100876553470498, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, orderNo=2, keyword=WinCC VBScrip), Keyword(id=1187100876641550883, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, orderNo=3, keyword=归档和报表), Keyword(id=1187100876704465444, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, orderNo=4, keyword=快速提取)], refs=[Reference(id=1187100877400719915, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, doi=null, pmid=null, pmcid=null, year=2004, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[1], rfOrder=0, authorNames=赵斯思, journalName=Visual Basic数据库编程技术与实例, refType=null, unstructuredReference=赵斯思. Visual Basic数据库编程技术与实例[M]. 北京: 人民邮电出版社, 2004., articleTitle=null, refAbstract=null), Reference(id=1187100877484605996, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, doi=null, pmid=null, pmcid=null, year=2004, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[2], rfOrder=1, authorNames=苏昆哲, journalName=深入浅出西门子WinCC V6:第2版, refType=null, unstructuredReference=苏昆哲. 深入浅出西门子WinCC V6:第2版[M]. 北京: 北京航空航天大学出版社, 2004., articleTitle=null, refAbstract=null), Reference(id=1187100877530743341, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, doi=null, pmid=null, pmcid=null, year=2004, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=[3], rfOrder=2, authorNames=高春艳, 李艳, 谷伟东, journalName=Visual Basic数据库关键技术与实例应用, refType=null, unstructuredReference=高春艳, 李艳, 谷伟东. Visual Basic数据库关键技术与实例应用[M]. 北京: 人民邮电出版社, 2004., articleTitle=null, refAbstract=null)], funds=null, companyList=[AuthorCompany(id=1187100875152572929, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, xref=null, ext=[AuthorCompanyExt(id=1187100875156767234, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China), AuthorCompanyExt(id=1187100875160961539, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, companyId=1187100875152572929, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=内蒙古包钢钢管有限公司,内蒙古 包头 014010)])], figs=[ArticleFig(id=1187100876880626213, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, label=null, caption=null, figureFileSmall=w8oVc84v0bZuaPk6p+LgXA==, figureFileBig=eQRvIzZOLiizCmrm6DCJWw==, tableContent=null), ArticleFig(id=1187100876951929382, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, label=图1, caption=无缝钢管水压测试数据流, figureFileSmall=w8oVc84v0bZuaPk6p+LgXA==, figureFileBig=eQRvIzZOLiizCmrm6DCJWw==, tableContent=null), ArticleFig(id=1187100877014843943, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, label=null, caption=null, figureFileSmall=UalBwutiSeGNMLjBdr9XJg==, figureFileBig=G09ZeJUmKBSRaKoN4XR4IA==, tableContent=null), ArticleFig(id=1187100877107118632, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, label=图2, caption=查询2022_5_30_3011编号钢管的结果, figureFileSmall=UalBwutiSeGNMLjBdr9XJg==, figureFileBig=G09ZeJUmKBSRaKoN4XR4IA==, tableContent=null), ArticleFig(id=1187100877182616105, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=EN, label=null, caption=null, figureFileSmall=null, figureFileBig=null, tableContent=
字段名称 数据类型 说明 字段大小
lngvalue 1 文本 试压开始时间 50
lngvalue 2 文本 试压结束时间 50
lngvalue 3 文本 操作员 50
lngvalue 4 文本 执行标准 50
lngvalue 5 文本 炉号 50
lngvalue 6 文本 批号 50
lngvalue 7 文本 材质 50
lngvalue 8 文本 规格 50
lngvalue 9 文本 管号 50
lngvalue 10 数字 试验压力 双精度型
lngvalue 11 数字 保压时间 长整型
lngvalue 12 文本 试压结果 50
lngvalue 13 文本 试压日期 50
), ArticleFig(id=1187100877245530666, tenantId=1146029695717560320, journalId=1185652524569653253, articleId=1187027209475731971, language=CN, label=表1, caption=

字段的名称、数据类型及其说明

, figureFileSmall=null, figureFileBig=null, tableContent=
字段名称 数据类型 说明 字段大小
lngvalue 1 文本 试压开始时间 50
lngvalue 2 文本 试压结束时间 50
lngvalue 3 文本 操作员 50
lngvalue 4 文本 执行标准 50
lngvalue 5 文本 炉号 50
lngvalue 6 文本 批号 50
lngvalue 7 文本 材质 50
lngvalue 8 文本 规格 50
lngvalue 9 文本 管号 50
lngvalue 10 数字 试验压力 双精度型
lngvalue 11 数字 保压时间 长整型
lngvalue 12 文本 试压结果 50
lngvalue 13 文本 试压日期 50
)], attaches=null, journal=Journal(id=1185652280146587652, delFlag=0, nameCn=包钢科技, nameEn=Science & Technology of Baotou Steel, nameHistory1=null, nameHistory2=null, issn=1009-5438, eissn=null, cn=15-1210/TF, coden=null, periodic=1, language=CN, oaType=null, ccby=null, superviseOffice=null, ownerOffice=null, pubOffice=null, editorOffice=null, officeType=null, aims=null, clcCode=null, officeProv=null, officeCity=null, officeAddr=null, officeZip=null, officeEmail=null, officePhone=null, editDirector=null, officeDirector=null, officeDirectorPhone=null, officeStaffNum=null, officeEmpNum=null, coverPicUrl=MuxxMe9Pr9qgO8IAocuQTg==, journalPrice=null, startedYear=null, abbrevIsoEn=null, journalRemark=null, publicationField=null, createdTime=1760611131943, updatedTime=1761728493461, createdBy=18614031015, updatedBy=13701087609, firstLetterCn=B, firstLetterEn=B, subjectCode=Engineering, subjectName=Engineering, subjectCodeEn=Engineering, subjectNameEn=null, picCn=MuxxMe9Pr9qgO8IAocuQTg==, picEn=ou3AszwYb0n2VtOVtaZ2lw==, jcr=null, cjcr=null, exts=[JournalExt(id=1190338834354245756, language=CN, name=包钢科技, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=, createdTime=1761728493536, updatedTime=1761728493536, createdBy=13701087609, updatedBy=13701087609, submissionGuidelinesUrl=, submissionAuthorUrl=https://bgkj.chinajournal.net.cn/EditorDN/index.aspx?t=1, submissionEditorUrl=https://bgkj.chinajournal.net.cn/EditorDN/index.aspx?t=3, submissionReviewUrl=https://bgkj.chinajournal.net.cn/EditorDN/index.aspx?t=2, submissionCeEditorUrl=, submissionAeEditorUrl=, option={"copyright":""}), JournalExt(id=1190338834408771709, language=EN, name=Science & Technology of Baotou Steel, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=, createdTime=1761728493549, updatedTime=1761728493549, createdBy=13701087609, updatedBy=13701087609, submissionGuidelinesUrl=, submissionAuthorUrl=https://bgkj.chinajournal.net.cn/EditorDN/index.aspx?t=1, submissionEditorUrl=https://bgkj.chinajournal.net.cn/EditorDN/index.aspx?t=3, submissionReviewUrl=https://bgkj.chinajournal.net.cn/EditorDN/index.aspx?t=2, submissionCeEditorUrl=, submissionAeEditorUrl=, option={"copyright":""})], databaseList=null, tenantJournalId=1185652524569653253, websiteList=[Website(id=1185655046684423052, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1185652524569653253, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/bgkj/CN, language=CN, createTime=1760611791535, createBy=18614031015, updateTime=1760611862376, updateBy=18614031015, name=包钢科技, tplId=1146099689490845704, title=包钢科技, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1185675258741801724, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=articleTextType, value=kx, createTime=1760616610465, updateTime=1760616610465, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675258708247289, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=banner, value=null, createTime=1760616610457, updateTime=1760616610457, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675258699858680, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=logo, value=https://castjournals.cast.org.cn/joweb/bgkj/CN/file/pic?fileId=nthji6+GG9SlnD/dssvyKA==, createTime=1760616610455, updateTime=1760616610455, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675258737607419, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/bgkj/CN/file/pic, createTime=1760616610464, updateTime=1760616610464, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675258729218810, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_cn_619/, createTime=1760616610462, updateTime=1760616610462, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675258750190333, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=themeColor, value=null, createTime=1760616610467, updateTime=1760616610467, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675258758578942, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046684423052, code=themeStyle, value=null, createTime=1760616610469, updateTime=1760616610469, creator=18614031015, updator=18614031015)]), Website(id=1185655046801863567, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1185652524569653253, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/bgkj/EN, language=EN, createTime=1760611791563, createBy=18614031015, updateTime=1760611898113, updateBy=18614031015, name=包钢科技-英文, tplId=1146101810881728533, title=Science & Technology of Baotou Steel, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1185675300932305667, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=articleTextType, value=kx, createTime=1760616620524, updateTime=1760616620524, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675300907139840, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=banner, value=null, createTime=1760616620518, updateTime=1760616620518, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675300898751231, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=logo, value=https://castjournals.cast.org.cn/joweb/bgkj/EN/file/pic?fileId=nthji6+GG9SlnD/dssvyKA==, createTime=1760616620516, updateTime=1760616620516, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675300923917058, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/bgkj/EN/file/pic, createTime=1760616620522, updateTime=1760616620522, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675300915528449, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_en_623/, createTime=1760616620520, updateTime=1760616620520, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675300936499972, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=themeColor, value=null, createTime=1760616620525, updateTime=1760616620525, creator=18614031015, updator=18614031015), WebsiteProps(id=1185675300999414533, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1185655046801863567, code=themeStyle, value=null, createTime=1760616620540, updateTime=1760616620540, creator=18614031015, updator=18614031015)])], journalTitle=包钢科技, weixinUrl=null, journalUrl=null, iacademicId=null, status=1, seqNo=null, journalTitleEn=Science & Technology of Baotou Steel, journalPhotoCn=MuxxMe9Pr9qgO8IAocuQTg==, journalPhotoEn=ou3AszwYb0n2VtOVtaZ2lw==, journalFirstLetter=B, journalRecommend=null, journalNew=null, journalCollection=1, jcrJf=null, cjcrJf=null, jcrJfStr=null, cjcrJfStr=null, submissionFirstDecision=null, sciSubjectClassification=null, casSubjectClassification=null, citeScore=null, totalCitationFrequency=null, icpCode=null, psCode=null, advertisingLicenseCode=null, copyrightInformation=null, country=null, option=, provinceCode=null, provinceName=null, collectFlag=false), detailUrlCn=https://castjournals.cast.org.cn/joweb/bgkj/CN/Y2024/V50/I6/84, detailUrlEn=https://castjournals.cast.org.cn/joweb/bgkj/EN/Y2024/V50/I6/84, pdfUrlCn=https://castjournals.cast.org.cn/joweb/bgkj/CN/PDF/Y2024/V50/I6/84, pdfUrlEn=https://castjournals.cast.org.cn/joweb/bgkj/EN/PDF/Y2024/V50/I6/84, aliStartDate=null, aliEndDate=null, collectionFlag=false, citedCount=null, citedUrl=null, reference=null)
收藏切换
利用Access数据库和WinCC VBScript快速提取钢管水压的测试数据
收藏切换
PDF下载
赵海燕 , 段瑞 , 郭强 , 李军 , 张明
包钢科技 | 设备与自动化 2024,50(6): 84-87
收起
收藏切换
包钢科技 | 设备与自动化 2024, 50(6): 84-87
利用Access数据库和WinCC VBScript快速提取钢管水压的测试数据
全屏
赵海燕, 段瑞, 郭强, 李军, 张明
作者信息
  • 内蒙古包钢钢管有限公司,内蒙古 包头 014010
  • 赵海燕(1970-),男,内蒙古包头市人,硕士,高级工程师,现从事设备管理工作。

Rapid Extraction of Test Data for Water Pressure of Steel Pipe with Access Database and WinCC VBScript
Zhao Hai-yan, Duan Rui, Guo Qiang, Li Jun, Zhang Ming
Affiliations
  • Inner Mongolia Baotou Steel Pipe Co., Ltd., Baotou 014010, Inner Mongolia Autonomous Region, China
出版时间: 2024-12-25
文章导航
收藏切换

钢管水压测试的目的是确认在规定压力下钢管是否漏水,从而保证其性能符合用户的要求。为了更有效地管理钢管水压的测试数据并提高报表的灵活性,利用Access数据库建立钢管水压测试数据表,通过使用WinCC VBScript代码,采用指令编程的方式,实现了钢管水压测试数据的归档和提取,提高了对钢管水压测试数据的分析能力,使数据的归档管理更加人性化,赢得了用户的认可。

Access  /  WinCC VBScrip  /  归档和报表  /  快速提取

The purpose of testing water pressure of steel pipe is to confirm whether there is any water leakage with authorised pressure so as to ensure its performances to meet user requirements. In order to manage the test data for water pressure of steel pipes more effectively and improve flexibility of reports, the test data sheet for water pressure of steel pipes is established with Access database. The archiving and extraction of test data for water pressure of steel pipes are realized by using codes of WinCC VBScript and adopting mode of instruction programming so that the analytical capability for water pressure of steel pipes is improved. As a result, the archiving management of data is more user-friendly, which wins user’s recognition.

Access  /  WinCC VBScript  /  archiving and report  /  rapid extraction
赵海燕, 段瑞, 郭强, 李军, 张明. 利用Access数据库和WinCC VBScript快速提取钢管水压的测试数据. 包钢科技, 2024 , 50 (6) : 84 -87 .
Zhao Hai-yan, Duan Rui, Guo Qiang, Li Jun, Zhang Ming. Rapid Extraction of Test Data for Water Pressure of Steel Pipe with Access Database and WinCC VBScript[J]. Science & Technology of Baotou Steel, 2024 , 50 (6) : 84 -87 .
通过使用Access数据库和WinCC VBScript,能够高效地提取钢管水压的测试数据。这种方法不仅简化了数据检索流程,还显著提高了工作效率。借助这两种工具,用户可以快速获取所需信息,从而更加有效地进行数据分析与决策。
本文探讨如何通过Access数据库和WinCC VBScript,利用数据连接和脚本编程快速提取钢管水压的测试数据,并展示相应的趋势图。
在建立钢管水压测试数据库之前,首先需要掌握Access数据库的基本结构[1]。Access数据库由多个表组成,每个表由行和列构成,每行是一条记录,每列是一个字段,每个字段都有唯一的名称。在Access数据库中,可以为字段设置规则,以确保当一个表中的值发生变化时,相关表中的值能够自动更新。字段大小对应特定的数据类型,当数据类型为“文本”时,字段大小属性的最大字符数设置为255;当数据类型为“数字”时,字段大小属性可以根据需求设置为双精度和长整型。
按照以下步骤在Access数据库中创建钢管水压的测试数据库。
(1)打开Microsoft Office Access,创建一个新的数据库文件,命名为“DB.mdb”。
(2)根据钢管水压测试的工艺要求,在数据库中生成一个包含13个字段的表。表1是每个字段的名称、数据类型及其说明。
数据源是指数据的来源以及访问这些数据所需的连接信息。可以通过开放数据库互连(ODBC-Open Database Connectivity)来连接多种类型的数据库。对于钢管水压测试数据,其来源为Access数据库,而ODBC的目标则是指向已经创建的“DB.mdb”数据库。
以下是创建ODBC连接,以便访问钢管水压的测试数据的具体步骤。
(1)打开控制面板。
(2)选择“管理工具”。
(3)点击“数据源ODBC”。
(4)在用户DNS项中,单击“添加”按钮。
(5)在弹出的“创建新数据源”框中,选择“Microsoft Access Driver (*.mdb)”。
(6)进入ODBC Microsoft Access安装对话框,在“数据源名”中输入“DB”,然后选择已经创建的“DB.mdb”数据库。
WinCC集成了VBScript,借助VBScript可以创建动作(action)和过程(procedure)。这些动作由触发器启动,并在全局脚本中仅定义一次,独立于界面存在[2]。通过VBScript指令[3],可以将过程值编程写入外部Access数据库的表中,从而实现数据的归档。
钢管水压的测试数据的归档动作是在WinCC全局脚本编辑器中编写的,使用了ADO(ActiveX Data Objects)数据库控件,以ODBC方式访问WinCC变量管理器,将过程值写入Access数据库中。
关键的程序代码如下所示:
strconnectionstring="Provider=MSDASQL;DSN=DB;UID=;PWD=;" //建立与Access Database的链接
strsql="insert into table1 values
('"&lngvalue1&"', '"&lngvalue2&"', '"&lngvalue3&"', '"&lngvalue4&"', '"&lngvalue5&"', '"&lngvalue6&"', '"&lngvalue7&"', '"&lngvalue8&"', '"&lngvalue9&"', "&lngvalue10&", "&lngvalue11&", '"&lngvalue12&"', '"&lngvalue13&"');" //对写入Access数据库的变量进行赋值
Set objconnection=CreateObject("ADODB.Connection")
objconnection.connectionstring=strconnectionstring //objConnection 连接
objconnection.Open //objConnection 连接打开
Set objcommand=CreateObject("ADODB. Command") //objcommand命令创建
With objcommand //objcommand命令
.ActiveConnection=objconnection //设定要通过哪个连接对象下命令
.CommandText=strsql //要下达至数据源的命令
End With
objcommand.execute //objCommand命令执行
调用VB 中的ADO 控件,设置属性,执行命令:
Set objcommand=Nothing
objconnection.close
Set objconnection=Nothing
End Function
运行该程序后,将生成钢管水压的测试数据流,如图1所示。该数据流记录了试压的开始时间、结束时间、操作员及执行标准等13个与钢管水压测试相关的重要数据值。
为了快速提取钢管水压的测试数据并展示趋势图,需要过滤掉数据库表中的无效数据。这个过程是通过预设条件,利用WinCC VBScript指令编程精确定位目标数据来完成的。
在钢管水压测试中,预设了两个查询条件:目标日期和目标管号。当用户点击“开始查询”按钮时,系统将根据目标管号和目标日期提取归档数据,并以设定的表格形式显示。
关键程序代码如下:
cxgh=HMIRuntime.Tags("lsqx_cxgh").Read//读取History画面中录入的第一个限定条件,目标管号
cxrq=HMIRuntime.Tags("lsqx_cxrq").Read//读取History画面中录入的第二个限定条件,目标日期
strConnectionString = "Provider=MSDASQL;DSN=DB;UID=;PWD=;" //建立与Access Database的链接
strSQL = "select * from table1 where 试压日期='"&cxrq&"' and 管号='"&cxgh&"'"//
按照预设的2个限定条件,以目标日期和目标管号进行查询
当用户点击“开始查询”按钮时,系统会激活曲线,并以趋势图的形式同步展示数据趋势。
关键程序代码如下:
Dim p1
Set p1=ScreenItems("控件1")
Dim begintime
Set begintime = HMIRuntime.Tags("lsqx_kssj")
begintime.Read //读取历史趋势的开始时间
Dim endtime
Set endtime = HMIRuntime.Tags("lsqx_jssj")//读取历史趋势的结束时间
endtime.Read
p1.Index=0 //趋势控件的Index属性设置为对应的第一条曲线号
p1.Online=0
p1.TimeRange=1
p1.Object.activate=0
p1.BeginTime=begintime.Value
p1.Object.activate=1 //激活曲线
提取的关键要点为:测试日期为2022年5月30日,指定管号为3011。展示内容包括设定压力、保压时间、炉号、批号及试压结果等各项数据记录,展现方式为趋势图和数据表。
首先,在历史记录画面的“查询日期”窗口中输入“2022_5_30”,以完成第一个条件;接着在“查询管号”窗口中输入“3011”,以完成第二个条件;最后,点击“开始查询”按钮,系统将在历史记录画面中展示符合条件的钢管数据信息及对应的趋势图。图2展示了查询2022_5_30编号为3011的钢管的结果。
通过使用WinCC VBScript代码,采用指令编程的方式,不仅实现了测试数据的归档管理,还高效地完成了测试数据的提取和趋势图的准确定位,得到了用户的认可。
在企业生产控制系统中,过程数据的归档与查询提取扮演着至关重要的角色。通过结合Access数据库与WinCC VBScript,我们能够高效地检索钢管水压的测试数据。这种方法不仅加快了数据处理的速度,还简化了信息检索的流程,确保了数据管理与访问的高效性。
参考文献 引证文献
排序方式:
[1]
赵斯思. Visual Basic数据库编程技术与实例[M]. 北京: 人民邮电出版社, 2004.
[2]
苏昆哲. 深入浅出西门子WinCC V6:第2版[M]. 北京: 北京航空航天大学出版社, 2004.
[3]
高春艳, 李艳, 谷伟东. Visual Basic数据库关键技术与实例应用[M]. 北京: 人民邮电出版社, 2004.
2024年第50卷第6期
PDF下载
113
50
引用本文
BibTeX
文章信息
  • 接收时间:2024-06-04
  • 首发时间:2025-10-20
  • 出版时间:2024-12-25
补充材料
相关文章
文章信息
作者
出版历史
  • 收稿日期:2024-06-04
基金
作者信息
    内蒙古包钢钢管有限公司,内蒙古 包头 014010
参考文献
分享链接
https://castjournals.cast.org.cn/joweb/bgkj/CN/1187027209475731971
分享至
全文二维码

扫描看全文

引用本文
BibTeX
本文的引用情况
2种不同金属材料的力学参数

Family
属数
Number of
genus
种数
Number of
species
占总种数比例
Percentage of
total species (%)

Genus
种数
Number of
species
占总种数比例
Percentage of total
species (%)
鹅膏菌科Amanitaceae 2 11 5.26 鹅膏菌属 Amanita 10 4.78
小菇科 Mycenaceae 2 12 5.74 丝盖伞属 Inocybe 5 2.39
多孔菌科 Polyporaceae 8 14 6.70 蜡蘑属 Laccaria 5 2.39
红菇科 Russulaceae 3 23 11.00 小皮伞属 Marasmius 6 2.87
小菇属 Mycena 11 5.26
光柄菇属 Pluteus 5 2.39
红菇属 Russula 17 8.13
栓菌属 Trametes 5 2.39
关闭全屏