没有合适的资源？快使用搜索试试~ 我知道了~

首页西门子MES手册 13 OpcenterEXCR_PortalStudio1_81RB1.pdf

西门子MES手册 13 OpcenterEXCR_PortalStudio1_81RB1.pdf

MES

Opcenter

需积分: 25 27 下载量 170 浏览量更新于2023-03-03 评论 1 收藏 4.02MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

330页

西门子生产执行系统MES Opcenter的软件相关说明书，有助于了解、学习、使用西门子的的MES系统Opcenter

资源详情

资源评论

资源推荐

Opcenter™ Execution Core

Portal Studio User Guide

Release 8 B.1

Notices

This documentation and all materials related to the software are confidential and proprietary to Siemens

Industry Software Inc. The contents of this document are copyrighted and cannot be reproduced in any form

without the written permission of Siemens Industry Software Inc. The information contained in this document

is subject to change without notice. Siemens Industry Software Inc. disclaims all liability for any consequence

arising from the use of this material.

EXCEPT AS EXPRESSLY PROVIDED IN YOUR LICENSE AGREEMENT, SIEMENS INDUSTRY SOFTWARE INC.

MAKES NO WARRANTIES, EXPRESSED OR IMPLIED, OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR

PURPOSE REGARDING LICENSED PROGRAMS, RELATED DOCUMENTATION, OR MARKETING MATERIALS.

A list of relevant Siemens trademarks can be found here. Other trademarks belong to their respective owners.

Document History

Portal Studio User Guide

January 2020

Printed in the U.S.

Release 8 B.1 Portal Studio User Guide iii

Contents

About This Guide xxi

Description xxi

Audience xxi

Conventions Used xxi

For Code Samples xxi

For Specific Information Types xxii

How This Guide Is Organized xxii

Related Publications xxiii

Contacting Technical Support xxiii

Security Information xxiv

Summary of Technical Changes xxiv

Chapter 1: Getting Started with Portal Studio 1-1

Introduction 1-1

Accessing Portal Studio 1-2

When Accessing Portal Studio 1-2

Portal StudioHome Page and Start Page Dashboard 1-4

How to Access Portal Studio 1-4

How to Return to the Portal 1-4

Session Expiration 1-5

When Session Expiration Occurs 1-5

Enabling Silverlight in Google Chrome 1-6

When Enabling Silverlight inGoogle Chrome 1-6

How to Enable Silverlight in Google Chrome Version 42 1-6

How to Enable Silverlight in Google Chrome Versions 43 and 44 1-6

Portal Studio User Interface Features 1-8

Standard Buttons 1-8

Standard Icons 1-8

Viewing Online Help 1-10

Contents

iv Portal Studio User Guide Release 8 B.1

When Viewing Online Help 1-10

How to View Online Help 1-10

Portal Studio Global Toolbar 1-11

Portal Studio Global Toolbar Buttons 1-11

Saving Changes 1-14

When Saving Changes 1-14

How to Save Your Changes 1-14

Developing in Workspaces 1-15

When Developing in Workspaces 1-15

When Using the ASPXConverter 1-16

When Using the Trace Log 1-16

How to Publish Content to an Active Workspace 1-16

Searching for Objects in a Pane 1-17

When Searching for an Object in a Pane 1-17

How to Search for an Object in a Pane 1-17

UIComponents Catalog 1-18

UI Components Catalog Pane 1-19

How to Navigate the UIComponents Catalog 1-19

Toolbox 1-20

ToolboxPane 1-20

Relative Button 1-20

How to Show or Hide the Toolbox 1-20

Controls 1-22

Fields Directory 1-29

When Using the Fields Directory 1-29

Properties Pane 1-30

How to Show the Properties Pane 1-30

Managing Layouts 1-31

Contents

WhenManaging Layouts 1-31

Chapter 2: Pages 2-1

Introduction 2-1

Creating a Page 2-2

When Creating a Page 2-2

Create New Page Pop-up 2-2

Create New Page Pop-upField Definitions 2-2

How to Create a Page 2-3

Opening an Existing Page 2-4

When Opening an Existing Page 2-4

How to Open an Existing Page 2-4

Adding a Web Part to a Page 2-5

When Adding a Web Part to a Page 2-5

How to Add a Web Part to a Page 2-5

Viewing Web Parts on a Page 2-6

When Viewing Web Parts on a Page 2-6

How to View Web Parts on a Page 2-6

Extracting a Web Part 2-7

When Extracting a Web Part 2-7

How to Extract a Web Part 2-7

Previewing a Page 2-8

When Previewing a Page 2-8

How to Preview a Page 2-8

Testing a Page 2-9

When Testing a Page 2-9

How to Test a Page 2-9

Generating a Page 2-10

When Generating a Page 2-10

How to Generate a Page 2-10

Release 8 B.1 Portal Studio User Guide v

剩余329页未读，继续阅读

function getPagedList(contractId) { var contractId = body.param.ontractId; SELECT a.id, a.conract_id contractId, a.product_id productId, a.purchase_num purchaseNum, a.purchase_price purchasePrice, a.remark, b.product_name productName, b.spec_code specCode, c.type_name typeName, d.unit_code unitCode FROM mes214820519.wms_pur_list_214820519 a, mes214820519.wms_product_214820519 b, mes214820519.wms_product_class_214820519 c, mes214820519.wms_unit_code_214820519 d WHERE a.product_id=b.id AND b.product_class_id = c.id AND b.unit_code_id=d.id `; return db.pager(sql, {contractId: contractId}) } 这段代码的错误在哪

1. 在第一行中声明了 `contractId`，但在 SQL 查询语句中使用了 `body.param.ontractId`，应该改为 `body.param.contractId`。 2. SQL 查询语句的末尾多了一个反引号，应该删除它。正确的代码应该是： ``` ...

function getPagedList(contractId) { var contractId = body.param.contractId; var sql = ` SELECT a.id, a.contract_id contractId, a.product_id productId, a.purchase_num purchaseNum, a.purchase_price purchasePrice, a.remark, b.product_name productName, b.spec_code specCode, c.type_name typeName, d.unitcode unitCode FROM mes214820519.wms_pur_list_214820519 a, mes214820519.wms_product_214820519 b, mes214820519.wms_product_class_214820519 c, mes214820519.wms_unit_code_214820519 d WHERE a.product_id=b.id AND b.product_class_id = c.id AND b.unit_code_id=d.id AND a.contract_id=#{contractId}`; return db.pager(sql, {contractId: contractId}) } 用JavaScript语言修改这段代码

INNER JOIN mes214820519.wms_product_214820519 b ON a.product_id = b.id INNER JOIN mes214820519.wms_product_class_214820519 c ON b.product_class_id = c.id INNER JOIN mes214820519.wms_unit_code_...

org.mozilla.javascript.WrappedException: Wrapped org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select count(1) from (select a.id, a.contract_id contractId, a.product_id productId, a.purchase_num purchaseNum, a.purchase_price purchasePrice, a.remark, b.product_name productName, b.spec_code specCode, c.type_name typeName, d.unit_code unitCode from mes-214820524.wms_pur_list_214820524 a, mes-214820524.wms_product_214820524 b, mes-214820524.wms_product_class_214820524 c, mes-214820524.wms_unit_code_214820524 d where a.product_id=b.id and b.product_class_id = c.id and b.unit_code_id=d.id and a.contract_id= '3b353514235f4a8da8dbcdbcbb5a643e' ) t1]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-214820524.wms_pur_list_214820524 a, mes-214820524.wms_product_214820524 b,' at line 11 (JavaScriptScriptParse#22)at帮我分析一下这段错误，并告诉我怎么修改

从错误信息中可以看到，SQL 语句的表名是 "mes-214820524.wms_pur_list_214820524"，"mes-214820524.wms_product_214820524"，"mes-214820524.wms_product_class_214820524"，"mes-214820524.wms_unit_code_...

当超过10万条记录时,mysql上的Update查询执行慢解决办法，示例update mes_production_order,sap_sale_order_more set mes_production_order.ZSTATUS = sap_sale_order_more.ZSTATUS where mes_production_order.PRO_CODE = sap_sale_order_more.AUFNR

1. 在 mes_production_order 和 sap_sale_order_more 表中创建 PRO_CODE 和 AUFNR 的联合索引： ALTER TABLE mes_production_order ADD INDEX idx_pro_code (PRO_CODE); ALTER TABLE sap_sale_order_more ADD ...

帮我优化SQL：SELECT distinct [TC_SGU04] ,[TC_SGT03],b.StationName,c.WorkNo,c.ID FROM [MES_DB_Utility].[dbo].[FromIT_WO_Data] a left join [MES_DB_Utility].[dbo].StationId_Name b on a.TC_SGT03 = b.StationId left join IPQC.dbo.SipWorkTable c on SUBSTRING(a.TC_SGU04,6,10)=c.WorkNo and a.TC_SGT03=c.WorkStation where a.TC_SGT02='2023-06-12T00:00:00' and a.TC_SGT03 in (select StationId FROM [MES_DB_Utility].[dbo].[StationId_Name])

1. 去除了不必要的括号，使得SQL语句更加简洁明了。 2. 将表别名添加到所有的字段前，使得SQL语句更加规范。 3. 将左连接的表优化为使用 INNER JOIN，避免了使用 LEFT JOIN 时可能出现的性能问题。 4. 将 IN 子查询...

优化代码insert into fr.fr_equipment_fill_out_all select date2 ,equipment ,team ,target_oee,theory_qty ,theory_ppm ,stop_time ,plan_downtime ,text1 ,text2 ,text3 ,text4 ,text5 from ( select ROW_NUMBER() over(partition by t1.equipment order by t1.date1) as num,neighbor(t1.date1,1) as date2,neighbor(t1.equipment,1) as equipment ,t1.date1,t1.equipment,t2.* from ( select DISTINCT a.date1 , b.equipment from (select toDate (`date`) as date1 from chuz_dim.dim_mes_date_all) a GLOBAL left join (select toDate(date_time) as date_time1, * from fr.fr_equipment_fill_out_all) b on 1=1 where date1 between (select min(date_time) from fr.fr_equipment_fill_out_all) and now() ) t1 GLOBAL left join ( select a.date1 , b.* from (select toDate (`date`) as date1 from chuz_dim.dim_mes_date_all) a GLOBAL left join (select toDate(date_time) as date_time1, * from fr.fr_equipment_fill_out_all) b on date1=date_time1 where date1 between (select MIN(date_time) from fr.fr_equipment_fill_out_all) and now() )t2 on t1.date1=t2.date1 and t1.equipment=t2.equipment order by t1.equipment ,t1.date1 ) t3 where date2 > date1 and date_time = (select max(date_time) from fr.fr_equipment_fill_out_all)

1. 使用JOIN代替子查询：将子查询中的表连接操作改为使用JOIN语句，可以提高查询效率。 2. 使用EXISTS代替IN：将子查询中的IN子句改为EXISTS子句，可以提高查询效率。 3. 使用变量存储重复的表达式：在查询中使用...

执行if (mes_receive_Name[i] == mes_target_Default[i])时，出现operand types are incompatible，但是mes_receive_Name[i]和mes_target_Default[i]输出的字符串都是一致的，该怎么解决

在上面的示例中，我们使用 `strcmp()` 函数来比较 `mes_receive_Name` 和 `mes_target_Default` 两个字符串的内容。如果返回值为 0，则表示两个字符串相等；否则，表示两个字符串不相等。希望这个解答能帮助你解决...

SELECT 物料号, 资材类型 FROM ( SELECT CONSUMABLESPECNAME AS 物料号, CONSUMABLETYPE AS 资材类型 FROM BIOTADM_MES_BSCONSUMABLEINVENTORY WHERE AREANAME = 'Rework' AND FACTORYNAME = 'MNT' AND CONSUMABLETYPE IN ('上POL', '下POL', '外加工_PCBA', 'SourceDriver', 'Polarizer', 'GataDriver') MINUS SELECT B.MATNR AS 物料号,B.WGBEZ AS 资材类型 FROM BIOTADM_MES_WIP A LEFT JOIN BIOTADM_MES_ERP_PP1_FGCODE B ON(A.PRODUCTSPECNAME =B.ZFGCODE) WHERE 1=1 AND B.WGBEZ IN('上POL','下POL','外加工_PCBA','SourceDriver','Polarizer','GataDriver') AND A.SYSTEMNAME='MNT' AND PROCESSOPERATIONNAME IN('MR701','MR710','MR1010','MR102','MR104','MR105','MR120','MR121','MR101') ) 优化

它从两个表中获取数据，一个是 BIOTADM_MES_BSCONSUMABLEINVENTORY 表，另一个是 BIOTADM_MES_WIP 表和 BIOTADM_MES_ERP_PP1_FGCODE 表的联结结果。通过 MINUS 运算符将两个结果集进行差集运算，得到的结果集中包含...

MES_CONSUME_MAT_STOCK_REAL

MES_CONSUME_MAT_STOCK_REAL是一个用于实时消耗物料库存的MES系统中的数据表。在制造业中，物料库存是非常重要的，它表示了企业所拥有的原材料、半成品和成品的数量。MES_CONSUME_MAT_STOCK_REAL表记录了实时的物料...

SELECT IF(B.BILL_NO IS NOT NULL, '已入库', '未入库') AS STATUS FROM MATERIAL_RETURN_MES A LEFT JOIN MATERIAL_RETURN B ON A.ASN_NO = B.BILL_NO WHERE A.STATUS = '已作废' OR B.BILL_NO IS NOT NULL SQL代码提示缺失右括号

请在 SQL 语句的最后加上一个右括号即可： ``` ...FROM MATERIAL_RETURN_MES A LEFT JOIN MATERIAL_RETURN B ON A.ASN_NO = B.BILL_NO WHERE A.STATUS = '已作废' OR B.BILL_NO IS NOT NULL ```

智造扫地僧

粉丝: 18
资源: 39

上传资源快速赚钱

我的内容管理收起

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

会员权益专享

西门子MES手册 13 OpcenterEXCR_PortalStudio1_81RB1.pdf

评论0

会员权益专享

最新资源

西门子MES手册 13 OpcenterEXCR_PortalStudio1_81RB1.pdf

评论0

CAMSTAR MES系统开发手册

西门子MES手册 14 OpcenterEXCR_ShopFloor_81RB1.pdf

MES接口模块用户手册(详细篇)201801版.pdf

当超过10万条记录时,mysql上的Update查询执行慢解决办法，示例update mes_production_order,sap_sale_order_more set mes_production_order.ZSTATUS = sap_sale_order_more.ZSTATUS where mes_production_order.PRO_CODE = sap_sale_order_more.AUFNR

MES-SAP 生产报工接口代码

Create MATERIALIZED view [dbo].[view_mes_sum_output_year1]

super(TableNameConstant.MES_JOB_JNGH, MesJobJngh.class, functions);

帮我用代码写一个MES系统

strncpy(mes_receive_Name[i], this.name, elCount(mes_receive_Name[i]));的含义

@MapperScan("{com.million.mes.basic.dbapi.common.dao,com.million.mes.basic.dbapi.common.modelpagedao}")

Consider defining a bean of type 'com.pinkitec.mes.hanger.server.util.HangerUtil' in your configuration.

执行if (mes_receive_Name[i] == mes_target_Default[i])时，出现operand types are incompatible，但是mes_receive_Name[i]和mes_target_Default[i]输出的字符串都是一致的，该怎么解决

MES_CONSUME_MAT_STOCK_REAL

SELECT IF(B.BILL_NO IS NOT NULL, '已入库', '未入库') AS STATUS FROM MATERIAL_RETURN_MES A LEFT JOIN MATERIAL_RETURN B ON A.ASN_NO = B.BILL_NO WHERE A.STATUS = '已作废' OR B.BILL_NO IS NOT NULL SQL代码提示缺失右括号

会员权益专享

最新资源