445 lines
25 KiB
XML
445 lines
25 KiB
XML
<?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="faceModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" 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="company">
|
||
<Key>
|
||
<PropertyRef Name="companyid" />
|
||
</Key>
|
||
<Property Name="companyid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="companyname" Type="nvarchar" MaxLength="20" Nullable="false" />
|
||
<Property Name="companyremark" Type="nvarchar" MaxLength="100" />
|
||
</EntityType>
|
||
<EntityType Name="DeviceManage">
|
||
<Key>
|
||
<PropertyRef Name="Facelid" />
|
||
</Key>
|
||
<Property Name="Facelid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="Facestate" Type="char" MaxLength="4" Nullable="false" />
|
||
<Property Name="snnumber" Type="varchar" MaxLength="200" Nullable="false" />
|
||
<Property Name="hotelid" Type="int" Nullable="false" />
|
||
<Property Name="houseid" Type="int" Nullable="false" />
|
||
<Property Name="photograph" Type="varbinary" MaxLength="50" />
|
||
<Property Name="creationdate" Type="datetime" Nullable="false" />
|
||
<Property Name="datechanged" Type="datetime" />
|
||
</EntityType>
|
||
<EntityType Name="Hotel">
|
||
<Key>
|
||
<PropertyRef Name="hotelid" />
|
||
</Key>
|
||
<Property Name="hotelid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="hotelname" Type="varchar" MaxLength="50" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="ImageList">
|
||
<Key>
|
||
<PropertyRef Name="Imageid" />
|
||
</Key>
|
||
<Property Name="Imageid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="Image" Type="nvarchar" MaxLength="254" Nullable="false" />
|
||
<Property Name="hotelid" Type="int" Nullable="false" />
|
||
<Property Name="houseid" Type="int" Nullable="false" />
|
||
<Property Name="userid" Type="int" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="Operator">
|
||
<Key>
|
||
<PropertyRef Name="Operatorid" />
|
||
</Key>
|
||
<Property Name="Operatorid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="name" Type="nvarchar" MaxLength="50" Nullable="false" />
|
||
<Property Name="pwd" Type="nvarchar" MaxLength="50" Nullable="false" />
|
||
<Property Name="companyid" Type="int" Nullable="false" />
|
||
<Property Name="mobile" Type="int" Nullable="false" />
|
||
<Property Name="tencentAI" Type="nvarchar" MaxLength="50" />
|
||
<Property Name="createdate" Type="datetime" Nullable="false" />
|
||
<Property Name="Isenabled" Type="bit" Nullable="false" />
|
||
<Property Name="Operatorlistid" Type="int" Nullable="false" />
|
||
</EntityType>
|
||
<!--生成过程中发现错误:
|
||
警告 6002: 表/视图“face.dbo.OperatorLog”未定义主键。已推断出该键，并将定义创建为只读的表/视图。-->
|
||
<EntityType Name="OperatorLog">
|
||
<Key>
|
||
<PropertyRef Name="ologdate" />
|
||
<PropertyRef Name="Operatorid" />
|
||
<PropertyRef Name="Browsertype" />
|
||
<PropertyRef Name="ipaddress" />
|
||
<PropertyRef Name="operationtype" />
|
||
<PropertyRef Name="operatingdata" />
|
||
</Key>
|
||
<Property Name="ologdate" Type="datetime" Nullable="false" />
|
||
<Property Name="Operatorid" Type="int" Nullable="false" />
|
||
<Property Name="Browsertype" Type="nvarchar" MaxLength="20" Nullable="false" />
|
||
<Property Name="ipaddress" Type="nvarchar" MaxLength="200" Nullable="false" />
|
||
<Property Name="operationtype" Type="nvarchar" MaxLength="10" Nullable="false" />
|
||
<Property Name="operatingdata" Type="nvarchar" MaxLength="70" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="OperatorrList">
|
||
<Key>
|
||
<PropertyRef Name="Operatorlistid" />
|
||
</Key>
|
||
<Property Name="Operatorlistid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="Operatorlistname" Type="varchar" MaxLength="10" Nullable="false" />
|
||
<Property Name="Operatorlistremark" Type="varchar" MaxLength="50" />
|
||
</EntityType>
|
||
<EntityType Name="ROOM">
|
||
<Key>
|
||
<PropertyRef Name="houseid" />
|
||
</Key>
|
||
<Property Name="houseid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="housename" Type="varchar" MaxLength="50" Nullable="false" />
|
||
<Property Name="hotelid" Type="int" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="UserList">
|
||
<Key>
|
||
<PropertyRef Name="userid" />
|
||
</Key>
|
||
<Property Name="userid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
||
<Property Name="username" Type="varchar" MaxLength="10" Nullable="false" />
|
||
<Property Name="status" Type="varchar" MaxLength="10" Nullable="false" />
|
||
<Property Name="usersex" Type="char" MaxLength="2" Nullable="false" />
|
||
<Property Name="identitys" Type="varchar" MaxLength="20" Nullable="false" />
|
||
<Property Name="edttime" Type="date" Nullable="false" />
|
||
</EntityType>
|
||
<!--生成过程中发现错误:
|
||
警告 6002: 表/视图“face.dbo.UserLog”未定义主键。已推断出该键，并将定义创建为只读的表/视图。-->
|
||
<EntityType Name="UserLog">
|
||
<Key>
|
||
<PropertyRef Name="ulogdate" />
|
||
<PropertyRef Name="userid" />
|
||
<PropertyRef Name="Facelid" />
|
||
<PropertyRef Name="Operatorid" />
|
||
</Key>
|
||
<Property Name="ulogdate" Type="datetime" Nullable="false" />
|
||
<Property Name="userid" Type="int" Nullable="false" />
|
||
<Property Name="Facelid" Type="int" Nullable="false" />
|
||
<Property Name="uoperate" Type="nvarchar" MaxLength="10" />
|
||
<Property Name="Operatorid" Type="int" Nullable="false" />
|
||
</EntityType>
|
||
<Association Name="FK_Operator_Operator">
|
||
<End Role="Operator" Type="Self.Operator" Multiplicity="1" />
|
||
<End Role="Operator1" Type="Self.Operator" Multiplicity="0..1" />
|
||
<ReferentialConstraint>
|
||
<Principal Role="Operator">
|
||
<PropertyRef Name="Operatorid" />
|
||
</Principal>
|
||
<Dependent Role="Operator1">
|
||
<PropertyRef Name="Operatorid" />
|
||
</Dependent>
|
||
</ReferentialConstraint>
|
||
</Association>
|
||
<EntityContainer Name="faceModelStoreContainer">
|
||
<EntitySet Name="company" EntityType="Self.company" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="DeviceManage" EntityType="Self.DeviceManage" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="Hotel" EntityType="Self.Hotel" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="ImageList" EntityType="Self.ImageList" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="Operator" EntityType="Self.Operator" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="OperatorrList" EntityType="Self.OperatorrList" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="ROOM" EntityType="Self.ROOM" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="UserList" EntityType="Self.UserList" Schema="dbo" store:Type="Tables" />
|
||
<EntitySet Name="OperatorLog" EntityType="Self.OperatorLog" store:Type="Tables" store:Schema="dbo">
|
||
<DefiningQuery>SELECT
|
||
[OperatorLog].[ologdate] AS [ologdate],
|
||
[OperatorLog].[Operatorid] AS [Operatorid],
|
||
[OperatorLog].[Browsertype] AS [Browsertype],
|
||
[OperatorLog].[ipaddress] AS [ipaddress],
|
||
[OperatorLog].[operationtype] AS [operationtype],
|
||
[OperatorLog].[operatingdata] AS [operatingdata]
|
||
FROM [dbo].[OperatorLog] AS [OperatorLog]</DefiningQuery>
|
||
</EntitySet>
|
||
<EntitySet Name="UserLog" EntityType="Self.UserLog" store:Type="Tables" store:Schema="dbo">
|
||
<DefiningQuery>SELECT
|
||
[UserLog].[ulogdate] AS [ulogdate],
|
||
[UserLog].[userid] AS [userid],
|
||
[UserLog].[Facelid] AS [Facelid],
|
||
[UserLog].[uoperate] AS [uoperate],
|
||
[UserLog].[Operatorid] AS [Operatorid]
|
||
FROM [dbo].[UserLog] AS [UserLog]</DefiningQuery>
|
||
</EntitySet>
|
||
<AssociationSet Name="FK_Operator_Operator" Association="Self.FK_Operator_Operator">
|
||
<End Role="Operator" EntitySet="Operator" />
|
||
<End Role="Operator1" EntitySet="Operator" />
|
||
</AssociationSet>
|
||
</EntityContainer>
|
||
</Schema>
|
||
</edmx:StorageModels>
|
||
<!-- CSDL content -->
|
||
<edmx:ConceptualModels>
|
||
<Schema Namespace="faceModel" 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">
|
||
<EntityType Name="company">
|
||
<Key>
|
||
<PropertyRef Name="companyid" />
|
||
</Key>
|
||
<Property Name="companyid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="companyname" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="companyremark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
||
</EntityType>
|
||
<EntityType Name="DeviceManage">
|
||
<Key>
|
||
<PropertyRef Name="Facelid" />
|
||
</Key>
|
||
<Property Name="Facelid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="Facestate" Type="String" MaxLength="4" FixedLength="true" Unicode="false" Nullable="false" />
|
||
<Property Name="snnumber" Type="String" MaxLength="200" FixedLength="false" Unicode="false" Nullable="false" />
|
||
<Property Name="hotelid" Type="Int32" Nullable="false" />
|
||
<Property Name="houseid" Type="Int32" Nullable="false" />
|
||
<Property Name="photograph" Type="Binary" MaxLength="50" FixedLength="false" />
|
||
<Property Name="creationdate" Type="DateTime" Nullable="false" Precision="3" />
|
||
<Property Name="datechanged" Type="DateTime" Precision="3" />
|
||
</EntityType>
|
||
<EntityType Name="Hotel">
|
||
<Key>
|
||
<PropertyRef Name="hotelid" />
|
||
</Key>
|
||
<Property Name="hotelid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="hotelname" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="ImageList">
|
||
<Key>
|
||
<PropertyRef Name="Imageid" />
|
||
</Key>
|
||
<Property Name="Imageid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="Image" Type="String" MaxLength="254" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="hotelid" Type="Int32" Nullable="false" />
|
||
<Property Name="houseid" Type="Int32" Nullable="false" />
|
||
<Property Name="userid" Type="Int32" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="Operator">
|
||
<Key>
|
||
<PropertyRef Name="Operatorid" />
|
||
</Key>
|
||
<Property Name="Operatorid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="pwd" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="companyid" Type="Int32" Nullable="false" />
|
||
<Property Name="mobile" Type="Int32" Nullable="false" />
|
||
<Property Name="tencentAI" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
||
<Property Name="createdate" Type="DateTime" Nullable="false" Precision="3" />
|
||
<Property Name="Isenabled" Type="Boolean" Nullable="false" />
|
||
<Property Name="Operatorlistid" Type="Int32" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="OperatorrList">
|
||
<Key>
|
||
<PropertyRef Name="Operatorlistid" />
|
||
</Key>
|
||
<Property Name="Operatorlistid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="Operatorlistname" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
||
<Property Name="Operatorlistremark" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
||
</EntityType>
|
||
<EntityType Name="ROOM">
|
||
<Key>
|
||
<PropertyRef Name="houseid" />
|
||
</Key>
|
||
<Property Name="houseid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="housename" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
||
<Property Name="hotelid" Type="Int32" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="UserList">
|
||
<Key>
|
||
<PropertyRef Name="userid" />
|
||
</Key>
|
||
<Property Name="userid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
||
<Property Name="username" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
||
<Property Name="status" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
||
<Property Name="usersex" Type="String" MaxLength="2" FixedLength="true" Unicode="false" Nullable="false" />
|
||
<Property Name="identitys" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
||
<Property Name="edttime" Type="DateTime" Nullable="false" Precision="0" />
|
||
</EntityType>
|
||
<EntityType Name="OperatorLog">
|
||
<Key>
|
||
<PropertyRef Name="ologdate" />
|
||
<PropertyRef Name="Operatorid" />
|
||
<PropertyRef Name="Browsertype" />
|
||
<PropertyRef Name="ipaddress" />
|
||
<PropertyRef Name="operationtype" />
|
||
<PropertyRef Name="operatingdata" />
|
||
</Key>
|
||
<Property Name="ologdate" Type="DateTime" Nullable="false" Precision="3" />
|
||
<Property Name="Operatorid" Type="Int32" Nullable="false" />
|
||
<Property Name="Browsertype" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="ipaddress" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="operationtype" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
|
||
<Property Name="operatingdata" Type="String" MaxLength="70" FixedLength="false" Unicode="true" Nullable="false" />
|
||
</EntityType>
|
||
<EntityType Name="UserLog">
|
||
<Key>
|
||
<PropertyRef Name="ulogdate" />
|
||
<PropertyRef Name="userid" />
|
||
<PropertyRef Name="Facelid" />
|
||
<PropertyRef Name="Operatorid" />
|
||
</Key>
|
||
<Property Name="ulogdate" Type="DateTime" Nullable="false" Precision="3" />
|
||
<Property Name="userid" Type="Int32" Nullable="false" />
|
||
<Property Name="Facelid" Type="Int32" Nullable="false" />
|
||
<Property Name="uoperate" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
|
||
<Property Name="Operatorid" Type="Int32" Nullable="false" />
|
||
</EntityType>
|
||
<Association Name="FK_Operator_Operator">
|
||
<End Role="Operator" Type="Self.Operator" Multiplicity="1" />
|
||
<End Role="Operator1" Type="Self.Operator" Multiplicity="0..1" />
|
||
<ReferentialConstraint>
|
||
<Principal Role="Operator">
|
||
<PropertyRef Name="Operatorid" />
|
||
</Principal>
|
||
<Dependent Role="Operator1">
|
||
<PropertyRef Name="Operatorid" />
|
||
</Dependent>
|
||
</ReferentialConstraint>
|
||
</Association>
|
||
<EntityContainer Name="faceEntities" annotation:LazyLoadingEnabled="true">
|
||
<EntitySet Name="company" EntityType="Self.company" />
|
||
<EntitySet Name="DeviceManage" EntityType="Self.DeviceManage" />
|
||
<EntitySet Name="Hotel" EntityType="Self.Hotel" />
|
||
<EntitySet Name="ImageList" EntityType="Self.ImageList" />
|
||
<EntitySet Name="Operator" EntityType="Self.Operator" />
|
||
<EntitySet Name="OperatorrList" EntityType="Self.OperatorrList" />
|
||
<EntitySet Name="ROOM" EntityType="Self.ROOM" />
|
||
<EntitySet Name="UserList" EntityType="Self.UserList" />
|
||
<EntitySet Name="OperatorLog" EntityType="Self.OperatorLog" />
|
||
<EntitySet Name="UserLog" EntityType="Self.UserLog" />
|
||
<AssociationSet Name="FK_Operator_Operator" Association="Self.FK_Operator_Operator">
|
||
<End Role="Operator" EntitySet="Operator" />
|
||
<End Role="Operator1" EntitySet="Operator" />
|
||
</AssociationSet>
|
||
</EntityContainer>
|
||
</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="faceModelStoreContainer" CdmEntityContainer="faceEntities">
|
||
<EntitySetMapping Name="company">
|
||
<EntityTypeMapping TypeName="faceModel.company">
|
||
<MappingFragment StoreEntitySet="company">
|
||
<ScalarProperty Name="companyid" ColumnName="companyid" />
|
||
<ScalarProperty Name="companyname" ColumnName="companyname" />
|
||
<ScalarProperty Name="companyremark" ColumnName="companyremark" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="DeviceManage">
|
||
<EntityTypeMapping TypeName="faceModel.DeviceManage">
|
||
<MappingFragment StoreEntitySet="DeviceManage">
|
||
<ScalarProperty Name="Facelid" ColumnName="Facelid" />
|
||
<ScalarProperty Name="Facestate" ColumnName="Facestate" />
|
||
<ScalarProperty Name="snnumber" ColumnName="snnumber" />
|
||
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
||
<ScalarProperty Name="houseid" ColumnName="houseid" />
|
||
<ScalarProperty Name="photograph" ColumnName="photograph" />
|
||
<ScalarProperty Name="creationdate" ColumnName="creationdate" />
|
||
<ScalarProperty Name="datechanged" ColumnName="datechanged" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="Hotel">
|
||
<EntityTypeMapping TypeName="faceModel.Hotel">
|
||
<MappingFragment StoreEntitySet="Hotel">
|
||
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
||
<ScalarProperty Name="hotelname" ColumnName="hotelname" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="ImageList">
|
||
<EntityTypeMapping TypeName="faceModel.ImageList">
|
||
<MappingFragment StoreEntitySet="ImageList">
|
||
<ScalarProperty Name="Imageid" ColumnName="Imageid" />
|
||
<ScalarProperty Name="Image" ColumnName="Image" />
|
||
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
||
<ScalarProperty Name="houseid" ColumnName="houseid" />
|
||
<ScalarProperty Name="userid" ColumnName="userid" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="Operator">
|
||
<EntityTypeMapping TypeName="faceModel.Operator">
|
||
<MappingFragment StoreEntitySet="Operator">
|
||
<ScalarProperty Name="Operatorid" ColumnName="Operatorid" />
|
||
<ScalarProperty Name="name" ColumnName="name" />
|
||
<ScalarProperty Name="pwd" ColumnName="pwd" />
|
||
<ScalarProperty Name="companyid" ColumnName="companyid" />
|
||
<ScalarProperty Name="mobile" ColumnName="mobile" />
|
||
<ScalarProperty Name="tencentAI" ColumnName="tencentAI" />
|
||
<ScalarProperty Name="createdate" ColumnName="createdate" />
|
||
<ScalarProperty Name="Isenabled" ColumnName="Isenabled" />
|
||
<ScalarProperty Name="Operatorlistid" ColumnName="Operatorlistid" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="OperatorrList">
|
||
<EntityTypeMapping TypeName="faceModel.OperatorrList">
|
||
<MappingFragment StoreEntitySet="OperatorrList">
|
||
<ScalarProperty Name="Operatorlistid" ColumnName="Operatorlistid" />
|
||
<ScalarProperty Name="Operatorlistname" ColumnName="Operatorlistname" />
|
||
<ScalarProperty Name="Operatorlistremark" ColumnName="Operatorlistremark" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="ROOM">
|
||
<EntityTypeMapping TypeName="faceModel.ROOM">
|
||
<MappingFragment StoreEntitySet="ROOM">
|
||
<ScalarProperty Name="houseid" ColumnName="houseid" />
|
||
<ScalarProperty Name="housename" ColumnName="housename" />
|
||
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="UserList">
|
||
<EntityTypeMapping TypeName="faceModel.UserList">
|
||
<MappingFragment StoreEntitySet="UserList">
|
||
<ScalarProperty Name="userid" ColumnName="userid" />
|
||
<ScalarProperty Name="username" ColumnName="username" />
|
||
<ScalarProperty Name="status" ColumnName="status" />
|
||
<ScalarProperty Name="usersex" ColumnName="usersex" />
|
||
<ScalarProperty Name="identitys" ColumnName="identitys" />
|
||
<ScalarProperty Name="edttime" ColumnName="edttime" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="OperatorLog">
|
||
<EntityTypeMapping TypeName="faceModel.OperatorLog">
|
||
<MappingFragment StoreEntitySet="OperatorLog">
|
||
<ScalarProperty Name="ologdate" ColumnName="ologdate" />
|
||
<ScalarProperty Name="Operatorid" ColumnName="Operatorid" />
|
||
<ScalarProperty Name="Browsertype" ColumnName="Browsertype" />
|
||
<ScalarProperty Name="ipaddress" ColumnName="ipaddress" />
|
||
<ScalarProperty Name="operationtype" ColumnName="operationtype" />
|
||
<ScalarProperty Name="operatingdata" ColumnName="operatingdata" />
|
||
</MappingFragment>
|
||
</EntityTypeMapping>
|
||
</EntitySetMapping>
|
||
<EntitySetMapping Name="UserLog">
|
||
<EntityTypeMapping TypeName="faceModel.UserLog">
|
||
<MappingFragment StoreEntitySet="UserLog">
|
||
<ScalarProperty Name="ulogdate" ColumnName="ulogdate" />
|
||
<ScalarProperty Name="userid" ColumnName="userid" />
|
||
<ScalarProperty Name="Facelid" ColumnName="Facelid" />
|
||
<ScalarProperty Name="uoperate" ColumnName="uoperate" />
|
||
<ScalarProperty Name="Operatorid" ColumnName="Operatorid" />
|
||
</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> |