1192 lines
71 KiB
Plaintext
1192 lines
71 KiB
Plaintext
|
<?xml version="1.0" encoding="utf-8"?>
|
|||
|
|
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|||
|
|
<!-- EF Runtime content -->
|
|||
|
|
<edmx:Runtime>
|
|||
|
|
<!-- SSDL content -->
|
|||
|
|
<edmx:StorageModels>
|
|||
|
|
<Schema Namespace="Model.Store" Provider="MySql.Data.MySqlClient" ProviderManifestToken="8.0" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
|
|||
|
|
<EntityType Name="TAlarm">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="StationId" Type="int" />
|
|||
|
|
<Property Name="Desc" Type="varchar" MaxLength="512" />
|
|||
|
|
<Property Name="StartTime" Type="datetime" Precision="0" Nullable="false" />
|
|||
|
|
<Property Name="StopTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="Status" Type="varchar" MaxLength="16" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TAlarmContent">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="TagIds" Type="varchar" MaxLength="20" />
|
|||
|
|
<Property Name="Offset" Type="int" />
|
|||
|
|
<Property Name="Desc" Type="varchar" MaxLength="500" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TBatteryInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="PalletVirtualId" Type="int" />
|
|||
|
|
<Property Name="BatteryCode" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="BatteryStatus" Type="tinyint" />
|
|||
|
|
<Property Name="PositionX" Type="tinyint" />
|
|||
|
|
<Property Name="PositionY" Type="tinyint" />
|
|||
|
|
<Property Name="ScanTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="BindingTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="UnbindingTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="DummyFlag" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="CoolTemp" Type="float" />
|
|||
|
|
<Property Name="Remarks" Type="varchar" MaxLength="255" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TBatteryNG">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="varchar" MaxLength="255" />
|
|||
|
|
<Property Name="BatteryCode" Type="varchar" MaxLength="32" Nullable="false" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Desc" Type="text" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TCavityInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="StationId" Type="utinyint" Nullable="false" />
|
|||
|
|
<Property Name="Name" Type="varchar" MaxLength="255" Nullable="false" />
|
|||
|
|
<Property Name="IsLoad" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="PalletId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Lock" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="Status" Type="tinyint" />
|
|||
|
|
<Property Name="Layer" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="Column" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="StationNumber" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="StationX" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="StationY" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="IsOpen" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="Remark" Type="varchar" MaxLength="512" Nullable="false" />
|
|||
|
|
<Property Name="LayerType" Type="tinyint" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TDeviceConfig">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Name" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="DriverName" Type="varchar" MaxLength="255" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="IsConnect" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="Desc" Type="varchar" MaxLength="255" />
|
|||
|
|
<Property Name="Json" Type="varchar" MaxLength="255" />
|
|||
|
|
<Property Name="Type" Type="tinyint" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TElectricEnergy">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="uint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="StationId" Type="int" />
|
|||
|
|
<Property Name="ElectricityA" Type="float" />
|
|||
|
|
<Property Name="ElectricityB" Type="float" />
|
|||
|
|
<Property Name="ElectricityC" Type="float" />
|
|||
|
|
<Property Name="VoltageA" Type="float" />
|
|||
|
|
<Property Name="VoltageB" Type="float" />
|
|||
|
|
<Property Name="VoltageC" Type="float" />
|
|||
|
|
<Property Name="ElectricEnergy" Type="float" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TLog">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="uint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Content" Type="varchar" MaxLength="8000" Nullable="false" />
|
|||
|
|
<Property Name="Level" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TMenuInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Header" Type="varchar" MaxLength="100" Nullable="false" />
|
|||
|
|
<Property Name="HeaderName" Type="varchar" MaxLength="100" />
|
|||
|
|
<Property Name="TargetView" Type="varchar" MaxLength="150" />
|
|||
|
|
<Property Name="ParentId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="MenuIcon" Type="varchar" MaxLength="100" />
|
|||
|
|
<Property Name="MenuIndex" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="MenuType" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="State" Type="bit" />
|
|||
|
|
<Property Name="JSON" Type="varchar" MaxLength="1000" />
|
|||
|
|
<Property Name="MenuImage" Type="blob" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TMesData">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="CommandType" Type="varchar" MaxLength="255" />
|
|||
|
|
<Property Name="Content" Type="text" />
|
|||
|
|
<Property Name="RecvContent" Type="text" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="SendTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="SendFlag" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="RecvTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="MsgType" Type="tinyint" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TPalletInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
<PropertyRef Name="PalletCode" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="VirtualId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="varchar" MaxLength="64" Nullable="false" />
|
|||
|
|
<Property Name="PalletStatus" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="BakingPosition" Type="int" />
|
|||
|
|
<Property Name="LoadingPosition" Type="int" />
|
|||
|
|
<Property Name="UnLoadingPosition" Type="int" />
|
|||
|
|
<Property Name="BatteryQty" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="BakingCount" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="LoadingBegingTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="LoadingOverTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="InStoveTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="BakingBeginTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="BakingOverTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="OutStoveTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="UnLoadingBegingTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="UnLoadingOverTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="JobNum" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="ScanTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="LastFlag" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="WaterValue" Type="varchar" MaxLength="7000" />
|
|||
|
|
<Property Name="UnLoadingCoolTemp" Type="float" />
|
|||
|
|
<Property Name="TotalBakingCount" Type="int" />
|
|||
|
|
</EntityType>
|
|||
|
|
<!--生成过程中发现错误:
|
|||
|
|
警告 6002: 表/视图“def.6098-8.TPalletInfoHistory”未定义主键。已推断出该键，并将定义创建为只读的表/视图。-->
|
|||
|
|
<EntityType Name="TPalletInfoHistory">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
<PropertyRef Name="VirtualId" />
|
|||
|
|
<PropertyRef Name="PalletCode" />
|
|||
|
|
<PropertyRef Name="PalletStatus" />
|
|||
|
|
<PropertyRef Name="BatteryQty" />
|
|||
|
|
<PropertyRef Name="BakingCount" />
|
|||
|
|
<PropertyRef Name="LastFlag" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="VirtualId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="varchar" MaxLength="64" Nullable="false" />
|
|||
|
|
<Property Name="PalletStatus" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="BakingPosition" Type="int" />
|
|||
|
|
<Property Name="LoadingPosition" Type="int" />
|
|||
|
|
<Property Name="UnLoadingPosition" Type="int" />
|
|||
|
|
<Property Name="BatteryQty" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="BakingCount" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="LoadingBegingTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="LoadingOverTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="InStoveTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="BakingBeginTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="BakingOverTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="OutStoveTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="UnLoadingBegingTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="UnLoadingOverTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="JobNum" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="ScanTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="LastFlag" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="WaterValue" Type="varchar" MaxLength="7000" />
|
|||
|
|
<Property Name="UnLoadingCoolTemp" Type="float" />
|
|||
|
|
<Property Name="TotalBakingCount" Type="int" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TProcessParameter">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="ProcessParamName" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="Parameters" Type="text" />
|
|||
|
|
<Property Name="BaseFalg" Type="bit" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TProductionInformation">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="JobNum" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="ProductionDatetime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="CurrentProduct" Type="bit" />
|
|||
|
|
<Property Name="DummyRule" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="ProcessParamId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="ReProcessParamId" Type="int" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TRgvAction">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Name" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="Desc" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="StepId" Type="tinyint" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TRoleInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="RoleId" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="RoleId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="RoleName" Type="varchar" MaxLength="100" Nullable="false" />
|
|||
|
|
<Property Name="State" Type="bit" />
|
|||
|
|
<Property Name="Role" Type="varchar" MaxLength="100" />
|
|||
|
|
<Property Name="AccessNode" Type="text" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TStation">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Name" Type="varchar" MaxLength="64" Nullable="false" />
|
|||
|
|
<Property Name="Desc" Type="varchar" MaxLength="64" Nullable="false" />
|
|||
|
|
<Property Name="Layers" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="Columns" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="Number" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="Type" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="PosX" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="PosY" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="LeftMargin" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="DeviceId" Type="tinyint" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TStoveSctualPatrol">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="PalletVirtualId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="CavityId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="varchar" MaxLength="64" Nullable="false" />
|
|||
|
|
<Property Name="Vacuum" Type="float" Nullable="false" />
|
|||
|
|
<Property Name="Temperature" Type="text" Nullable="false" />
|
|||
|
|
<Property Name="PID" Type="text" />
|
|||
|
|
<Property Name="CreateTime" Type="datetime" Precision="0" StoreGeneratedPattern="Identity" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TSysSetup">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="uint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="ParamCode" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="ParamName" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="ParamValue" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="CheckRegular" Type="varchar" MaxLength="100" Nullable="false" />
|
|||
|
|
<Property Name="Type" Type="tinyint" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTagList">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="uint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="StationIds" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="Address" Type="varchar" MaxLength="100" Nullable="false" />
|
|||
|
|
<Property Name="VarName" Type="varchar" MaxLength="100" Nullable="false" />
|
|||
|
|
<Property Name="ParamName" Type="varchar" MaxLength="100" />
|
|||
|
|
<Property Name="VarType" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="ArrayLen" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Number" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="OperType" Type="tinyint" />
|
|||
|
|
<Property Name="VarDesc" Type="varchar" MaxLength="255" />
|
|||
|
|
<Property Name="Json" Type="varchar" MaxLength="1024" />
|
|||
|
|
<Property Name="TirgEnable" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="TrigJson" Type="varchar" MaxLength="1024" />
|
|||
|
|
<Property Name="TagType" Type="int" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTaskRecord">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="PalletId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="TaskTypeId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Source" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Target" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Status" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="BuildTime" Type="datetime" Precision="0" Nullable="false" />
|
|||
|
|
<Property Name="StartTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="EndTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="StepId" Type="tinyint" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTaskStep">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="TaskRecordId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Count" Type="int" />
|
|||
|
|
<Property Name="StepId" Type="tinyint" Nullable="false" />
|
|||
|
|
<Property Name="StartTime" Type="datetime" Precision="0" />
|
|||
|
|
<Property Name="EndTime" Type="datetime" Precision="0" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTaskType">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Name" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="SourceDeviceType" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="TargetDeviceType" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="PalletStatus" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Priority" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="Json" Type="varchar" MaxLength="500" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TUserManage">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="UserName" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="Password" Type="varchar" MaxLength="128" />
|
|||
|
|
<Property Name="RoleId" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="UserId" Type="varchar" MaxLength="20" />
|
|||
|
|
<Property Name="Valid" Type="bit" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityContainer Name="ModelStoreContainer">
|
|||
|
|
<EntitySet Name="TAlarm" EntityType="Self.TAlarm" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TAlarmContent" EntityType="Self.TAlarmContent" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TBatteryInfo" EntityType="Self.TBatteryInfo" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TBatteryNG" EntityType="Self.TBatteryNG" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TCavityInfo" EntityType="Self.TCavityInfo" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TDeviceConfig" EntityType="Self.TDeviceConfig" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TElectricEnergy" EntityType="Self.TElectricEnergy" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TLog" EntityType="Self.TLog" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TMenuInfo" EntityType="Self.TMenuInfo" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TMesData" EntityType="Self.TMesData" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TPalletInfo" EntityType="Self.TPalletInfo" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TProcessParameter" EntityType="Self.TProcessParameter" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TProductionInformation" EntityType="Self.TProductionInformation" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TRgvAction" EntityType="Self.TRgvAction" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TRoleInfo" EntityType="Self.TRoleInfo" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TStation" EntityType="Self.TStation" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TStoveSctualPatrol" EntityType="Self.TStoveSctualPatrol" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TSysSetup" EntityType="Self.TSysSetup" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TTagList" EntityType="Self.TTagList" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TTaskRecord" EntityType="Self.TTaskRecord" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TTaskStep" EntityType="Self.TTaskStep" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TTaskType" EntityType="Self.TTaskType" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TUserManage" EntityType="Self.TUserManage" Schema="6098-8" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="TPalletInfoHistory" EntityType="Self.TPalletInfoHistory" store:Type="Tables" store:Schema="6098-8">
|
|||
|
|
<DefiningQuery>SELECT
|
|||
|
|
`TPalletInfoHistory`.`Id`,
|
|||
|
|
`TPalletInfoHistory`.`VirtualId`,
|
|||
|
|
`TPalletInfoHistory`.`PalletCode`,
|
|||
|
|
`TPalletInfoHistory`.`PalletStatus`,
|
|||
|
|
`TPalletInfoHistory`.`BakingPosition`,
|
|||
|
|
`TPalletInfoHistory`.`LoadingPosition`,
|
|||
|
|
`TPalletInfoHistory`.`UnLoadingPosition`,
|
|||
|
|
`TPalletInfoHistory`.`BatteryQty`,
|
|||
|
|
`TPalletInfoHistory`.`BakingCount`,
|
|||
|
|
`TPalletInfoHistory`.`LoadingBegingTime`,
|
|||
|
|
`TPalletInfoHistory`.`LoadingOverTime`,
|
|||
|
|
`TPalletInfoHistory`.`InStoveTime`,
|
|||
|
|
`TPalletInfoHistory`.`BakingBeginTime`,
|
|||
|
|
`TPalletInfoHistory`.`BakingOverTime`,
|
|||
|
|
`TPalletInfoHistory`.`OutStoveTime`,
|
|||
|
|
`TPalletInfoHistory`.`UnLoadingBegingTime`,
|
|||
|
|
`TPalletInfoHistory`.`UnLoadingOverTime`,
|
|||
|
|
`TPalletInfoHistory`.`JobNum`,
|
|||
|
|
`TPalletInfoHistory`.`ScanTime`,
|
|||
|
|
`TPalletInfoHistory`.`CreateTime`,
|
|||
|
|
`TPalletInfoHistory`.`LastFlag`,
|
|||
|
|
`TPalletInfoHistory`.`WaterValue`,
|
|||
|
|
`TPalletInfoHistory`.`UnLoadingCoolTemp`,
|
|||
|
|
`TPalletInfoHistory`.`TotalBakingCount`
|
|||
|
|
FROM `TPalletInfoHistory` AS `TPalletInfoHistory`</DefiningQuery>
|
|||
|
|
</EntitySet>
|
|||
|
|
</EntityContainer>
|
|||
|
|
</Schema></edmx:StorageModels>
|
|||
|
|
<!-- CSDL content -->
|
|||
|
|
<edmx:ConceptualModels>
|
|||
|
|
<Schema Namespace="Model" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
|||
|
|
<EntityContainer Name="BakingEntities" annotation:LazyLoadingEnabled="true">
|
|||
|
|
<EntitySet Name="TAlarm" EntityType="Model.TAlarm" />
|
|||
|
|
<EntitySet Name="TAlarmContent" EntityType="Model.TAlarmContent" />
|
|||
|
|
<EntitySet Name="TBatteryInfo" EntityType="Model.TBatteryInfo" />
|
|||
|
|
<EntitySet Name="TBatteryNG" EntityType="Model.TBatteryNG" />
|
|||
|
|
<EntitySet Name="TCavityInfo" EntityType="Model.TCavityInfo" />
|
|||
|
|
<EntitySet Name="TDeviceConfig" EntityType="Model.TDeviceConfig" />
|
|||
|
|
<EntitySet Name="TElectricEnergy" EntityType="Model.TElectricEnergy" />
|
|||
|
|
<EntitySet Name="TLog" EntityType="Model.TLog" />
|
|||
|
|
<EntitySet Name="TMenuInfo" EntityType="Model.TMenuInfo" />
|
|||
|
|
<EntitySet Name="TMesData" EntityType="Model.TMesData" />
|
|||
|
|
<EntitySet Name="TPalletInfo" EntityType="Model.TPalletInfo" />
|
|||
|
|
<EntitySet Name="TProcessParameter" EntityType="Model.TProcessParameter" />
|
|||
|
|
<EntitySet Name="TProductionInformation" EntityType="Model.TProductionInformation" />
|
|||
|
|
<EntitySet Name="TRgvAction" EntityType="Model.TRgvAction" />
|
|||
|
|
<EntitySet Name="TRoleInfo" EntityType="Model.TRoleInfo" />
|
|||
|
|
<EntitySet Name="TStation" EntityType="Model.TStation" />
|
|||
|
|
<EntitySet Name="TStoveSctualPatrol" EntityType="Model.TStoveSctualPatrol" />
|
|||
|
|
<EntitySet Name="TSysSetup" EntityType="Model.TSysSetup" />
|
|||
|
|
<EntitySet Name="TTagList" EntityType="Model.TTagList" />
|
|||
|
|
<EntitySet Name="TTaskRecord" EntityType="Model.TTaskRecord" />
|
|||
|
|
<EntitySet Name="TTaskStep" EntityType="Model.TTaskStep" />
|
|||
|
|
<EntitySet Name="TTaskType" EntityType="Model.TTaskType" />
|
|||
|
|
<EntitySet Name="TUserManage" EntityType="Model.TUserManage" />
|
|||
|
|
<EntitySet Name="TPalletInfoHistory" EntityType="Model.TPalletInfoHistory" />
|
|||
|
|
</EntityContainer>
|
|||
|
|
<EntityType Name="TAlarm">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="StationId" Type="Int32" />
|
|||
|
|
<Property Name="Desc" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="StartTime" Type="DateTime" Nullable="false" />
|
|||
|
|
<Property Name="StopTime" Type="DateTime" />
|
|||
|
|
<Property Name="Status" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TAlarmContent">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="TagIds" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Offset" Type="Int32" />
|
|||
|
|
<Property Name="Desc" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TBatteryInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="PalletVirtualId" Type="Int32" />
|
|||
|
|
<Property Name="BatteryCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="BatteryStatus" Type="SByte" />
|
|||
|
|
<Property Name="PositionX" Type="SByte" />
|
|||
|
|
<Property Name="PositionY" Type="SByte" />
|
|||
|
|
<Property Name="ScanTime" Type="DateTime" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="BindingTime" Type="DateTime" />
|
|||
|
|
<Property Name="UnbindingTime" Type="DateTime" />
|
|||
|
|
<Property Name="DummyFlag" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="CoolTemp" Type="Single" />
|
|||
|
|
<Property Name="Remarks" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TBatteryNG">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="PalletCode" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="BatteryCode" Type="String" Nullable="false" MaxLength="32" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Desc" Type="String" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TCavityInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="StationId" Type="Byte" Nullable="false" />
|
|||
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="IsLoad" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="PalletId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Lock" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="Status" Type="SByte" />
|
|||
|
|
<Property Name="Layer" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="Column" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="StationNumber" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="StationX" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="StationY" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="IsOpen" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="Remark" Type="String" Nullable="false" MaxLength="512" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="LayerType" Type="SByte" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TDeviceConfig">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="DriverName" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Enable" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="IsConnect" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="Desc" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Json" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Type" Type="SByte" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TElectricEnergy">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="StationId" Type="Int32" />
|
|||
|
|
<Property Name="ElectricityA" Type="Single" />
|
|||
|
|
<Property Name="ElectricityB" Type="Single" />
|
|||
|
|
<Property Name="ElectricityC" Type="Single" />
|
|||
|
|
<Property Name="VoltageA" Type="Single" />
|
|||
|
|
<Property Name="VoltageB" Type="Single" />
|
|||
|
|
<Property Name="VoltageC" Type="Single" />
|
|||
|
|
<Property Name="ElectricEnergy" Type="Single" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TLog">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Content" Type="String" Nullable="false" MaxLength="8000" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Level" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TMenuInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Header" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="HeaderName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="TargetView" Type="String" MaxLength="150" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ParentId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="MenuIcon" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="MenuIndex" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="MenuType" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="State" Type="Boolean" />
|
|||
|
|
<Property Name="JSON" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="MenuImage" Type="Binary" MaxLength="Max" FixedLength="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TMesData">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="CommandType" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Content" Type="String" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="RecvContent" Type="String" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="SendTime" Type="DateTime" />
|
|||
|
|
<Property Name="SendFlag" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="RecvTime" Type="DateTime" />
|
|||
|
|
<Property Name="MsgType" Type="SByte" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TPalletInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
<PropertyRef Name="PalletCode" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="VirtualId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="String" Nullable="false" MaxLength="64" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="PalletStatus" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="BakingPosition" Type="Int32" />
|
|||
|
|
<Property Name="LoadingPosition" Type="Int32" />
|
|||
|
|
<Property Name="UnLoadingPosition" Type="Int32" />
|
|||
|
|
<Property Name="BatteryQty" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="BakingCount" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="LoadingBegingTime" Type="DateTime" />
|
|||
|
|
<Property Name="LoadingOverTime" Type="DateTime" />
|
|||
|
|
<Property Name="InStoveTime" Type="DateTime" />
|
|||
|
|
<Property Name="BakingBeginTime" Type="DateTime" />
|
|||
|
|
<Property Name="BakingOverTime" Type="DateTime" />
|
|||
|
|
<Property Name="OutStoveTime" Type="DateTime" />
|
|||
|
|
<Property Name="UnLoadingBegingTime" Type="DateTime" />
|
|||
|
|
<Property Name="UnLoadingOverTime" Type="DateTime" />
|
|||
|
|
<Property Name="JobNum" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ScanTime" Type="DateTime" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="LastFlag" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="WaterValue" Type="String" MaxLength="7000" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="UnLoadingCoolTemp" Type="Single" />
|
|||
|
|
<Property Name="TotalBakingCount" Type="Int32" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TProcessParameter">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="ProcessParamName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Parameters" Type="String" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="BaseFalg" Type="Boolean" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TProductionInformation">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="JobNum" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ProductionDatetime" Type="DateTime" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="CurrentProduct" Type="Boolean" />
|
|||
|
|
<Property Name="DummyRule" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="ProcessParamId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="ReProcessParamId" Type="Int32" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TRgvAction">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Desc" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="StepId" Type="SByte" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TRoleInfo">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="RoleId" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="RoleId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="RoleName" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="State" Type="Boolean" />
|
|||
|
|
<Property Name="Role" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="AccessNode" Type="String" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TStation">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="64" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Desc" Type="String" Nullable="false" MaxLength="64" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Layers" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="Columns" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="Number" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="Type" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="PosX" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="PosY" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="LeftMargin" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="DeviceId" Type="SByte" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TStoveSctualPatrol">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="PalletVirtualId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="CavityId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="String" Nullable="false" MaxLength="64" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Vacuum" Type="Single" Nullable="false" />
|
|||
|
|
<Property Name="Temperature" Type="String" Nullable="false" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="PID" Type="String" MaxLength="65535" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TSysSetup">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="ParamCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ParamName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ParamValue" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="CheckRegular" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Type" Type="SByte" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTagList">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="StationIds" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Address" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="VarName" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ParamName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="VarType" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ArrayLen" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Number" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="OperType" Type="SByte" />
|
|||
|
|
<Property Name="VarDesc" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Json" Type="String" MaxLength="1024" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="TirgEnable" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="TrigJson" Type="String" MaxLength="1024" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="TagType" Type="Int32" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTaskRecord">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="PalletId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="TaskTypeId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Source" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Target" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="BuildTime" Type="DateTime" Nullable="false" />
|
|||
|
|
<Property Name="StartTime" Type="DateTime" />
|
|||
|
|
<Property Name="EndTime" Type="DateTime" />
|
|||
|
|
<Property Name="StepId" Type="SByte" Nullable="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTaskStep">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="TaskRecordId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Count" Type="Int32" />
|
|||
|
|
<Property Name="StepId" Type="SByte" Nullable="false" />
|
|||
|
|
<Property Name="StartTime" Type="DateTime" />
|
|||
|
|
<Property Name="EndTime" Type="DateTime" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TTaskType">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="SourceDeviceType" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="TargetDeviceType" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="PalletStatus" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Priority" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Enable" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="Json" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TUserManage">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="UserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Password" Type="String" MaxLength="128" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="RoleId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="UserId" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Valid" Type="Boolean" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="TPalletInfoHistory">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Id" />
|
|||
|
|
<PropertyRef Name="VirtualId" />
|
|||
|
|
<PropertyRef Name="PalletCode" />
|
|||
|
|
<PropertyRef Name="PalletStatus" />
|
|||
|
|
<PropertyRef Name="BatteryQty" />
|
|||
|
|
<PropertyRef Name="BakingCount" />
|
|||
|
|
<PropertyRef Name="LastFlag" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Id" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="VirtualId" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="PalletCode" Type="String" Nullable="false" MaxLength="64" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="PalletStatus" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="BakingPosition" Type="Int32" />
|
|||
|
|
<Property Name="LoadingPosition" Type="Int32" />
|
|||
|
|
<Property Name="UnLoadingPosition" Type="Int32" />
|
|||
|
|
<Property Name="BatteryQty" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="BakingCount" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="LoadingBegingTime" Type="DateTime" />
|
|||
|
|
<Property Name="LoadingOverTime" Type="DateTime" />
|
|||
|
|
<Property Name="InStoveTime" Type="DateTime" />
|
|||
|
|
<Property Name="BakingBeginTime" Type="DateTime" />
|
|||
|
|
<Property Name="BakingOverTime" Type="DateTime" />
|
|||
|
|
<Property Name="OutStoveTime" Type="DateTime" />
|
|||
|
|
<Property Name="UnLoadingBegingTime" Type="DateTime" />
|
|||
|
|
<Property Name="UnLoadingOverTime" Type="DateTime" />
|
|||
|
|
<Property Name="JobNum" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ScanTime" Type="DateTime" />
|
|||
|
|
<Property Name="CreateTime" Type="DateTime" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="LastFlag" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="WaterValue" Type="String" MaxLength="7000" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="UnLoadingCoolTemp" Type="Single" />
|
|||
|
|
<Property Name="TotalBakingCount" Type="Int32" />
|
|||
|
|
</EntityType>
|
|||
|
|
</Schema>
|
|||
|
|
</edmx:ConceptualModels>
|
|||
|
|
<!-- C-S mapping content -->
|
|||
|
|
<edmx:Mappings>
|
|||
|
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
|
|||
|
|
<EntityContainerMapping StorageEntityContainer="ModelStoreContainer" CdmEntityContainer="BakingEntities">
|
|||
|
|
<EntitySetMapping Name="TAlarm">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TAlarm">
|
|||
|
|
<MappingFragment StoreEntitySet="TAlarm">
|
|||
|
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
|||
|
|
<ScalarProperty Name="StopTime" ColumnName="StopTime" />
|
|||
|
|
<ScalarProperty Name="StartTime" ColumnName="StartTime" />
|
|||
|
|
<ScalarProperty Name="Desc" ColumnName="Desc" />
|
|||
|
|
<ScalarProperty Name="StationId" ColumnName="StationId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TAlarmContent">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TAlarmContent">
|
|||
|
|
<MappingFragment StoreEntitySet="TAlarmContent">
|
|||
|
|
<ScalarProperty Name="Desc" ColumnName="Desc" />
|
|||
|
|
<ScalarProperty Name="Offset" ColumnName="Offset" />
|
|||
|
|
<ScalarProperty Name="TagIds" ColumnName="TagIds" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TBatteryInfo">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TBatteryInfo">
|
|||
|
|
<MappingFragment StoreEntitySet="TBatteryInfo">
|
|||
|
|
<ScalarProperty Name="Remarks" ColumnName="Remarks" />
|
|||
|
|
<ScalarProperty Name="CoolTemp" ColumnName="CoolTemp" />
|
|||
|
|
<ScalarProperty Name="DummyFlag" ColumnName="DummyFlag" />
|
|||
|
|
<ScalarProperty Name="UnbindingTime" ColumnName="UnbindingTime" />
|
|||
|
|
<ScalarProperty Name="BindingTime" ColumnName="BindingTime" />
|
|||
|
|
<ScalarProperty Name="ScanTime" ColumnName="ScanTime" />
|
|||
|
|
<ScalarProperty Name="PositionY" ColumnName="PositionY" />
|
|||
|
|
<ScalarProperty Name="PositionX" ColumnName="PositionX" />
|
|||
|
|
<ScalarProperty Name="BatteryStatus" ColumnName="BatteryStatus" />
|
|||
|
|
<ScalarProperty Name="BatteryCode" ColumnName="BatteryCode" />
|
|||
|
|
<ScalarProperty Name="PalletVirtualId" ColumnName="PalletVirtualId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TBatteryNG">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TBatteryNG">
|
|||
|
|
<MappingFragment StoreEntitySet="TBatteryNG">
|
|||
|
|
<ScalarProperty Name="Desc" ColumnName="Desc" />
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="BatteryCode" ColumnName="BatteryCode" />
|
|||
|
|
<ScalarProperty Name="PalletCode" ColumnName="PalletCode" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TCavityInfo">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TCavityInfo">
|
|||
|
|
<MappingFragment StoreEntitySet="TCavityInfo">
|
|||
|
|
<ScalarProperty Name="LayerType" ColumnName="LayerType" />
|
|||
|
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
|||
|
|
<ScalarProperty Name="Enable" ColumnName="Enable" />
|
|||
|
|
<ScalarProperty Name="IsOpen" ColumnName="IsOpen" />
|
|||
|
|
<ScalarProperty Name="StationY" ColumnName="StationY" />
|
|||
|
|
<ScalarProperty Name="StationX" ColumnName="StationX" />
|
|||
|
|
<ScalarProperty Name="StationNumber" ColumnName="StationNumber" />
|
|||
|
|
<ScalarProperty Name="Column" ColumnName="Column" />
|
|||
|
|
<ScalarProperty Name="Layer" ColumnName="Layer" />
|
|||
|
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
|||
|
|
<ScalarProperty Name="Lock" ColumnName="Lock" />
|
|||
|
|
<ScalarProperty Name="PalletId" ColumnName="PalletId" />
|
|||
|
|
<ScalarProperty Name="IsLoad" ColumnName="IsLoad" />
|
|||
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|||
|
|
<ScalarProperty Name="StationId" ColumnName="StationId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TDeviceConfig">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TDeviceConfig">
|
|||
|
|
<MappingFragment StoreEntitySet="TDeviceConfig">
|
|||
|
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
|||
|
|
<ScalarProperty Name="Json" ColumnName="Json" />
|
|||
|
|
<ScalarProperty Name="Desc" ColumnName="Desc" />
|
|||
|
|
<ScalarProperty Name="IsConnect" ColumnName="IsConnect" />
|
|||
|
|
<ScalarProperty Name="Enable" ColumnName="Enable" />
|
|||
|
|
<ScalarProperty Name="DriverName" ColumnName="DriverName" />
|
|||
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TElectricEnergy">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TElectricEnergy">
|
|||
|
|
<MappingFragment StoreEntitySet="TElectricEnergy">
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="ElectricEnergy" ColumnName="ElectricEnergy" />
|
|||
|
|
<ScalarProperty Name="VoltageC" ColumnName="VoltageC" />
|
|||
|
|
<ScalarProperty Name="VoltageB" ColumnName="VoltageB" />
|
|||
|
|
<ScalarProperty Name="VoltageA" ColumnName="VoltageA" />
|
|||
|
|
<ScalarProperty Name="ElectricityC" ColumnName="ElectricityC" />
|
|||
|
|
<ScalarProperty Name="ElectricityB" ColumnName="ElectricityB" />
|
|||
|
|
<ScalarProperty Name="ElectricityA" ColumnName="ElectricityA" />
|
|||
|
|
<ScalarProperty Name="StationId" ColumnName="StationId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TLog">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TLog">
|
|||
|
|
<MappingFragment StoreEntitySet="TLog">
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="Level" ColumnName="Level" />
|
|||
|
|
<ScalarProperty Name="Content" ColumnName="Content" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TMenuInfo">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TMenuInfo">
|
|||
|
|
<MappingFragment StoreEntitySet="TMenuInfo">
|
|||
|
|
<ScalarProperty Name="MenuImage" ColumnName="MenuImage" />
|
|||
|
|
<ScalarProperty Name="JSON" ColumnName="JSON" />
|
|||
|
|
<ScalarProperty Name="State" ColumnName="State" />
|
|||
|
|
<ScalarProperty Name="MenuType" ColumnName="MenuType" />
|
|||
|
|
<ScalarProperty Name="MenuIndex" ColumnName="MenuIndex" />
|
|||
|
|
<ScalarProperty Name="MenuIcon" ColumnName="MenuIcon" />
|
|||
|
|
<ScalarProperty Name="ParentId" ColumnName="ParentId" />
|
|||
|
|
<ScalarProperty Name="TargetView" ColumnName="TargetView" />
|
|||
|
|
<ScalarProperty Name="HeaderName" ColumnName="HeaderName" />
|
|||
|
|
<ScalarProperty Name="Header" ColumnName="Header" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TMesData">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TMesData">
|
|||
|
|
<MappingFragment StoreEntitySet="TMesData">
|
|||
|
|
<ScalarProperty Name="MsgType" ColumnName="MsgType" />
|
|||
|
|
<ScalarProperty Name="RecvTime" ColumnName="RecvTime" />
|
|||
|
|
<ScalarProperty Name="SendFlag" ColumnName="SendFlag" />
|
|||
|
|
<ScalarProperty Name="SendTime" ColumnName="SendTime" />
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="RecvContent" ColumnName="RecvContent" />
|
|||
|
|
<ScalarProperty Name="Content" ColumnName="Content" />
|
|||
|
|
<ScalarProperty Name="CommandType" ColumnName="CommandType" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TPalletInfo">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TPalletInfo">
|
|||
|
|
<MappingFragment StoreEntitySet="TPalletInfo">
|
|||
|
|
<ScalarProperty Name="TotalBakingCount" ColumnName="TotalBakingCount" />
|
|||
|
|
<ScalarProperty Name="UnLoadingCoolTemp" ColumnName="UnLoadingCoolTemp" />
|
|||
|
|
<ScalarProperty Name="WaterValue" ColumnName="WaterValue" />
|
|||
|
|
<ScalarProperty Name="LastFlag" ColumnName="LastFlag" />
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="ScanTime" ColumnName="ScanTime" />
|
|||
|
|
<ScalarProperty Name="JobNum" ColumnName="JobNum" />
|
|||
|
|
<ScalarProperty Name="UnLoadingOverTime" ColumnName="UnLoadingOverTime" />
|
|||
|
|
<ScalarProperty Name="UnLoadingBegingTime" ColumnName="UnLoadingBegingTime" />
|
|||
|
|
<ScalarProperty Name="OutStoveTime" ColumnName="OutStoveTime" />
|
|||
|
|
<ScalarProperty Name="BakingOverTime" ColumnName="BakingOverTime" />
|
|||
|
|
<ScalarProperty Name="BakingBeginTime" ColumnName="BakingBeginTime" />
|
|||
|
|
<ScalarProperty Name="InStoveTime" ColumnName="InStoveTime" />
|
|||
|
|
<ScalarProperty Name="LoadingOverTime" ColumnName="LoadingOverTime" />
|
|||
|
|
<ScalarProperty Name="LoadingBegingTime" ColumnName="LoadingBegingTime" />
|
|||
|
|
<ScalarProperty Name="BakingCount" ColumnName="BakingCount" />
|
|||
|
|
<ScalarProperty Name="BatteryQty" ColumnName="BatteryQty" />
|
|||
|
|
<ScalarProperty Name="UnLoadingPosition" ColumnName="UnLoadingPosition" />
|
|||
|
|
<ScalarProperty Name="LoadingPosition" ColumnName="LoadingPosition" />
|
|||
|
|
<ScalarProperty Name="BakingPosition" ColumnName="BakingPosition" />
|
|||
|
|
<ScalarProperty Name="PalletStatus" ColumnName="PalletStatus" />
|
|||
|
|
<ScalarProperty Name="PalletCode" ColumnName="PalletCode" />
|
|||
|
|
<ScalarProperty Name="VirtualId" ColumnName="VirtualId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TProcessParameter">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TProcessParameter">
|
|||
|
|
<MappingFragment StoreEntitySet="TProcessParameter">
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="BaseFalg" ColumnName="BaseFalg" />
|
|||
|
|
<ScalarProperty Name="Parameters" ColumnName="Parameters" />
|
|||
|
|
<ScalarProperty Name="ProcessParamName" ColumnName="ProcessParamName" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TProductionInformation">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TProductionInformation">
|
|||
|
|
<MappingFragment StoreEntitySet="TProductionInformation">
|
|||
|
|
<ScalarProperty Name="ReProcessParamId" ColumnName="ReProcessParamId" />
|
|||
|
|
<ScalarProperty Name="ProcessParamId" ColumnName="ProcessParamId" />
|
|||
|
|
<ScalarProperty Name="DummyRule" ColumnName="DummyRule" />
|
|||
|
|
<ScalarProperty Name="CurrentProduct" ColumnName="CurrentProduct" />
|
|||
|
|
<ScalarProperty Name="ProductionDatetime" ColumnName="ProductionDatetime" />
|
|||
|
|
<ScalarProperty Name="JobNum" ColumnName="JobNum" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TRgvAction">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TRgvAction">
|
|||
|
|
<MappingFragment StoreEntitySet="TRgvAction">
|
|||
|
|
<ScalarProperty Name="StepId" ColumnName="StepId" />
|
|||
|
|
<ScalarProperty Name="Desc" ColumnName="Desc" />
|
|||
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TRoleInfo">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TRoleInfo">
|
|||
|
|
<MappingFragment StoreEntitySet="TRoleInfo">
|
|||
|
|
<ScalarProperty Name="AccessNode" ColumnName="AccessNode" />
|
|||
|
|
<ScalarProperty Name="Role" ColumnName="Role" />
|
|||
|
|
<ScalarProperty Name="State" ColumnName="State" />
|
|||
|
|
<ScalarProperty Name="RoleName" ColumnName="RoleName" />
|
|||
|
|
<ScalarProperty Name="RoleId" ColumnName="RoleId" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TStation">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TStation">
|
|||
|
|
<MappingFragment StoreEntitySet="TStation">
|
|||
|
|
<ScalarProperty Name="DeviceId" ColumnName="DeviceId" />
|
|||
|
|
<ScalarProperty Name="Enable" ColumnName="Enable" />
|
|||
|
|
<ScalarProperty Name="LeftMargin" ColumnName="LeftMargin" />
|
|||
|
|
<ScalarProperty Name="PosY" ColumnName="PosY" />
|
|||
|
|
<ScalarProperty Name="PosX" ColumnName="PosX" />
|
|||
|
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
|||
|
|
<ScalarProperty Name="Number" ColumnName="Number" />
|
|||
|
|
<ScalarProperty Name="Columns" ColumnName="Columns" />
|
|||
|
|
<ScalarProperty Name="Layers" ColumnName="Layers" />
|
|||
|
|
<ScalarProperty Name="Desc" ColumnName="Desc" />
|
|||
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TStoveSctualPatrol">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TStoveSctualPatrol">
|
|||
|
|
<MappingFragment StoreEntitySet="TStoveSctualPatrol">
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="PID" ColumnName="PID" />
|
|||
|
|
<ScalarProperty Name="Temperature" ColumnName="Temperature" />
|
|||
|
|
<ScalarProperty Name="Vacuum" ColumnName="Vacuum" />
|
|||
|
|
<ScalarProperty Name="PalletCode" ColumnName="PalletCode" />
|
|||
|
|
<ScalarProperty Name="CavityId" ColumnName="CavityId" />
|
|||
|
|
<ScalarProperty Name="PalletVirtualId" ColumnName="PalletVirtualId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TSysSetup">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TSysSetup">
|
|||
|
|
<MappingFragment StoreEntitySet="TSysSetup">
|
|||
|
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
|||
|
|
<ScalarProperty Name="CheckRegular" ColumnName="CheckRegular" />
|
|||
|
|
<ScalarProperty Name="ParamValue" ColumnName="ParamValue" />
|
|||
|
|
<ScalarProperty Name="ParamName" ColumnName="ParamName" />
|
|||
|
|
<ScalarProperty Name="ParamCode" ColumnName="ParamCode" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TTagList">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TTagList">
|
|||
|
|
<MappingFragment StoreEntitySet="TTagList">
|
|||
|
|
<ScalarProperty Name="TagType" ColumnName="TagType" />
|
|||
|
|
<ScalarProperty Name="TrigJson" ColumnName="TrigJson" />
|
|||
|
|
<ScalarProperty Name="TirgEnable" ColumnName="TirgEnable" />
|
|||
|
|
<ScalarProperty Name="Json" ColumnName="Json" />
|
|||
|
|
<ScalarProperty Name="VarDesc" ColumnName="VarDesc" />
|
|||
|
|
<ScalarProperty Name="OperType" ColumnName="OperType" />
|
|||
|
|
<ScalarProperty Name="Number" ColumnName="Number" />
|
|||
|
|
<ScalarProperty Name="ArrayLen" ColumnName="ArrayLen" />
|
|||
|
|
<ScalarProperty Name="VarType" ColumnName="VarType" />
|
|||
|
|
<ScalarProperty Name="ParamName" ColumnName="ParamName" />
|
|||
|
|
<ScalarProperty Name="VarName" ColumnName="VarName" />
|
|||
|
|
<ScalarProperty Name="Address" ColumnName="Address" />
|
|||
|
|
<ScalarProperty Name="StationIds" ColumnName="StationIds" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TTaskRecord">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TTaskRecord">
|
|||
|
|
<MappingFragment StoreEntitySet="TTaskRecord">
|
|||
|
|
<ScalarProperty Name="StepId" ColumnName="StepId" />
|
|||
|
|
<ScalarProperty Name="EndTime" ColumnName="EndTime" />
|
|||
|
|
<ScalarProperty Name="StartTime" ColumnName="StartTime" />
|
|||
|
|
<ScalarProperty Name="BuildTime" ColumnName="BuildTime" />
|
|||
|
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
|||
|
|
<ScalarProperty Name="Target" ColumnName="Target" />
|
|||
|
|
<ScalarProperty Name="Source" ColumnName="Source" />
|
|||
|
|
<ScalarProperty Name="TaskTypeId" ColumnName="TaskTypeId" />
|
|||
|
|
<ScalarProperty Name="PalletId" ColumnName="PalletId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TTaskStep">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TTaskStep">
|
|||
|
|
<MappingFragment StoreEntitySet="TTaskStep">
|
|||
|
|
<ScalarProperty Name="EndTime" ColumnName="EndTime" />
|
|||
|
|
<ScalarProperty Name="StartTime" ColumnName="StartTime" />
|
|||
|
|
<ScalarProperty Name="StepId" ColumnName="StepId" />
|
|||
|
|
<ScalarProperty Name="Count" ColumnName="Count" />
|
|||
|
|
<ScalarProperty Name="TaskRecordId" ColumnName="TaskRecordId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TTaskType">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TTaskType">
|
|||
|
|
<MappingFragment StoreEntitySet="TTaskType">
|
|||
|
|
<ScalarProperty Name="Json" ColumnName="Json" />
|
|||
|
|
<ScalarProperty Name="Enable" ColumnName="Enable" />
|
|||
|
|
<ScalarProperty Name="Priority" ColumnName="Priority" />
|
|||
|
|
<ScalarProperty Name="PalletStatus" ColumnName="PalletStatus" />
|
|||
|
|
<ScalarProperty Name="TargetDeviceType" ColumnName="TargetDeviceType" />
|
|||
|
|
<ScalarProperty Name="SourceDeviceType" ColumnName="SourceDeviceType" />
|
|||
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TUserManage">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TUserManage">
|
|||
|
|
<MappingFragment StoreEntitySet="TUserManage">
|
|||
|
|
<ScalarProperty Name="Valid" ColumnName="Valid" />
|
|||
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|||
|
|
<ScalarProperty Name="RoleId" ColumnName="RoleId" />
|
|||
|
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
|||
|
|
<ScalarProperty Name="UserName" ColumnName="UserName" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="TPalletInfoHistory">
|
|||
|
|
<EntityTypeMapping TypeName="Model.TPalletInfoHistory">
|
|||
|
|
<MappingFragment StoreEntitySet="TPalletInfoHistory">
|
|||
|
|
<ScalarProperty Name="TotalBakingCount" ColumnName="TotalBakingCount" />
|
|||
|
|
<ScalarProperty Name="UnLoadingCoolTemp" ColumnName="UnLoadingCoolTemp" />
|
|||
|
|
<ScalarProperty Name="WaterValue" ColumnName="WaterValue" />
|
|||
|
|
<ScalarProperty Name="LastFlag" ColumnName="LastFlag" />
|
|||
|
|
<ScalarProperty Name="CreateTime" ColumnName="CreateTime" />
|
|||
|
|
<ScalarProperty Name="ScanTime" ColumnName="ScanTime" />
|
|||
|
|
<ScalarProperty Name="JobNum" ColumnName="JobNum" />
|
|||
|
|
<ScalarProperty Name="UnLoadingOverTime" ColumnName="UnLoadingOverTime" />
|
|||
|
|
<ScalarProperty Name="UnLoadingBegingTime" ColumnName="UnLoadingBegingTime" />
|
|||
|
|
<ScalarProperty Name="OutStoveTime" ColumnName="OutStoveTime" />
|
|||
|
|
<ScalarProperty Name="BakingOverTime" ColumnName="BakingOverTime" />
|
|||
|
|
<ScalarProperty Name="BakingBeginTime" ColumnName="BakingBeginTime" />
|
|||
|
|
<ScalarProperty Name="InStoveTime" ColumnName="InStoveTime" />
|
|||
|
|
<ScalarProperty Name="LoadingOverTime" ColumnName="LoadingOverTime" />
|
|||
|
|
<ScalarProperty Name="LoadingBegingTime" ColumnName="LoadingBegingTime" />
|
|||
|
|
<ScalarProperty Name="BakingCount" ColumnName="BakingCount" />
|
|||
|
|
<ScalarProperty Name="BatteryQty" ColumnName="BatteryQty" />
|
|||
|
|
<ScalarProperty Name="UnLoadingPosition" ColumnName="UnLoadingPosition" />
|
|||
|
|
<ScalarProperty Name="LoadingPosition" ColumnName="LoadingPosition" />
|
|||
|
|
<ScalarProperty Name="BakingPosition" ColumnName="BakingPosition" />
|
|||
|
|
<ScalarProperty Name="PalletStatus" ColumnName="PalletStatus" />
|
|||
|
|
<ScalarProperty Name="PalletCode" ColumnName="PalletCode" />
|
|||
|
|
<ScalarProperty Name="VirtualId" ColumnName="VirtualId" />
|
|||
|
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
</EntityContainerMapping>
|
|||
|
|
</Mapping>
|
|||
|
|
</edmx:Mappings>
|
|||
|
|
</edmx:Runtime>
|
|||
|
|
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
|
|||
|
|
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|||
|
|
<Connection>
|
|||
|
|
<DesignerInfoPropertySet>
|
|||
|
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
|||
|
|
</DesignerInfoPropertySet>
|
|||
|
|
</Connection>
|
|||
|
|
<Options>
|
|||
|
|
<DesignerInfoPropertySet>
|
|||
|
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
|||
|
|
<DesignerProperty Name="EnablePluralization" Value="false" />
|
|||
|
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
|
|||
|
|
<DesignerProperty Name="UseLegacyProvider" Value="false" />
|
|||
|
|
<DesignerProperty Name="CodeGenerationStrategy" Value="无" />
|
|||
|
|
</DesignerInfoPropertySet>
|
|||
|
|
</Options>
|
|||
|
|
<!-- Diagram content (shape and connector positions) -->
|
|||
|
|
<Diagrams></Diagrams>
|
|||
|
|
</Designer>
|
|||
|
|
</edmx:Edmx>
|
