524 lines
31 KiB
Plaintext
524 lines
31 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="FaceModelDao.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="FaceIP" Type="varchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="Facestate" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="snnumber" Type="varchar" MaxLength="200" Nullable="false" />
|
|||
|
|
<Property Name="hotelid" Type="int" />
|
|||
|
|
<Property Name="houseid" Type="int" />
|
|||
|
|
<Property Name="photograph" Type="varbinary" MaxLength="50" />
|
|||
|
|
<Property Name="creationdate" Type="date" Nullable="false" />
|
|||
|
|
<Property Name="datechanged" Type="date" />
|
|||
|
|
</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="OpenratorLog">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Operatorname" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Operatorname" Type="nvarchar" MaxLength="20" Nullable="false" />
|
|||
|
|
<Property Name="Browsertype" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="ipaddressip" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|||
|
|
<Property Name="operationtype" Type="nvarchar" MaxLength="20" Nullable="false" />
|
|||
|
|
<Property Name="operatingdata" Type="nvarchar" MaxLength="20" Nullable="false" />
|
|||
|
|
<Property Name="ologdate" Type="date" 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="date" Nullable="false" />
|
|||
|
|
<Property Name="Isenabled" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="Operatorlistid" Type="int" Nullable="false" />
|
|||
|
|
<Property Name="Operatorimg" 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="RoomCheck">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="ID" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="ID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="Code" Type="varchar" MaxLength="20" Nullable="false" />
|
|||
|
|
<Property Name="RoomNumber" Type="varchar" MaxLength="20" Nullable="false" />
|
|||
|
|
<Property Name="XmlString" Type="nvarchar" MaxLength="1000" />
|
|||
|
|
<Property Name="CheckInDate" Type="datetime" Nullable="false" />
|
|||
|
|
<Property Name="SyncCheckIn" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="CheckOutDate" Type="datetime" />
|
|||
|
|
<Property Name="SyncCheckOut" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="RentDate" Type="datetime" />
|
|||
|
|
<Property Name="SyncRent" Type="bit" Nullable="false" />
|
|||
|
|
<Property Name="PhoneNumber" Type="varchar" MaxLength="60" />
|
|||
|
|
<Property Name="IDNumber" Type="varchar" MaxLength="200" />
|
|||
|
|
<Property Name="ValidateCode" Type="varchar" MaxLength="25" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="RoomCustomer">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="ID" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="ID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
|||
|
|
<Property Name="IDType" Type="int" />
|
|||
|
|
<Property Name="IDCard" Type="varchar" MaxLength="50" />
|
|||
|
|
<Property Name="Name" Type="nvarchar" MaxLength="20" />
|
|||
|
|
<Property Name="Sex" Type="int" />
|
|||
|
|
<Property Name="Birthday" Type="varchar" MaxLength="10" />
|
|||
|
|
<Property Name="PhotoUrl" Type="varchar" MaxLength="200" />
|
|||
|
|
<Property Name="Photo" Type="image" />
|
|||
|
|
<Property Name="CreatedDate" Type="datetime" Nullable="false" />
|
|||
|
|
<Property Name="ModifiedDate" Type="datetime" Nullable="false" />
|
|||
|
|
<Property Name="CheckInID" Type="bigint" />
|
|||
|
|
<Property Name="Status" Type="smallint" 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="FaceModelDaoStoreContainer">
|
|||
|
|
<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="OpenratorLog" EntityType="Self.OpenratorLog" Schema="dbo" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="Operator" EntityType="Self.Operator" Schema="dbo" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="ROOM" EntityType="Self.ROOM" Schema="dbo" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="RoomCheck" EntityType="Self.RoomCheck" Schema="dbo" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="RoomCustomer" EntityType="Self.RoomCustomer" Schema="dbo" store:Type="Tables" />
|
|||
|
|
<EntitySet Name="UserList" EntityType="Self.UserList" Schema="dbo" store:Type="Tables" />
|
|||
|
|
<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="FaceModelDao" 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="FaceIP" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
|||
|
|
<Property Name="Facestate" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="snnumber" Type="String" MaxLength="200" FixedLength="false" Unicode="false" Nullable="false" />
|
|||
|
|
<Property Name="hotelid" Type="Int32" />
|
|||
|
|
<Property Name="houseid" Type="Int32" />
|
|||
|
|
<Property Name="photograph" Type="Binary" MaxLength="50" FixedLength="false" />
|
|||
|
|
<Property Name="creationdate" Type="DateTime" Nullable="false" Precision="0" />
|
|||
|
|
<Property Name="datechanged" Type="DateTime" Precision="0" />
|
|||
|
|
</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="OpenratorLog">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="Operatorname" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="Operatorname" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
|||
|
|
<Property Name="Browsertype" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|||
|
|
<Property Name="ipaddressip" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|||
|
|
<Property Name="operationtype" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
|||
|
|
<Property Name="operatingdata" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
|||
|
|
<Property Name="ologdate" Type="DateTime" Nullable="false" Precision="0" />
|
|||
|
|
</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="0" />
|
|||
|
|
<Property Name="Isenabled" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="Operatorlistid" Type="Int32" Nullable="false" />
|
|||
|
|
<Property Name="Operatorimg" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<NavigationProperty Name="Operator1" Relationship="Self.FK_Operator_Operator" FromRole="Operator" ToRole="Operator1" />
|
|||
|
|
<NavigationProperty Name="Operator2" Relationship="Self.FK_Operator_Operator" FromRole="Operator1" ToRole="Operator" />
|
|||
|
|
</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="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="OpenratorLog" EntityType="Self.OpenratorLog" />
|
|||
|
|
<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="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>
|
|||
|
|
<EntitySet Name="RoomCheck" EntityType="FaceModelDao.RoomCheck" />
|
|||
|
|
<EntitySet Name="RoomCustomer" EntityType="FaceModelDao.RoomCustomer" />
|
|||
|
|
</EntityContainer>
|
|||
|
|
<EntityType Name="RoomCheck">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="ID" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="Code" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="RoomNumber" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="XmlString" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
|
|||
|
|
<Property Name="CheckInDate" Type="DateTime" Nullable="false" Precision="3" />
|
|||
|
|
<Property Name="SyncCheckIn" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="CheckOutDate" Type="DateTime" Precision="3" />
|
|||
|
|
<Property Name="SyncCheckOut" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="RentDate" Type="DateTime" Precision="3" />
|
|||
|
|
<Property Name="SyncRent" Type="Boolean" Nullable="false" />
|
|||
|
|
<Property Name="PhoneNumber" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="IDNumber" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="ValidateCode" Type="String" MaxLength="25" FixedLength="false" Unicode="false" />
|
|||
|
|
</EntityType>
|
|||
|
|
<EntityType Name="RoomCustomer">
|
|||
|
|
<Key>
|
|||
|
|
<PropertyRef Name="ID" />
|
|||
|
|
</Key>
|
|||
|
|
<Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|||
|
|
<Property Name="IDType" Type="Int32" />
|
|||
|
|
<Property Name="IDCard" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Name" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
|||
|
|
<Property Name="Sex" Type="Int32" />
|
|||
|
|
<Property Name="Birthday" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="PhotoUrl" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
|
|||
|
|
<Property Name="Photo" Type="Binary" MaxLength="Max" FixedLength="false" />
|
|||
|
|
<Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
|
|||
|
|
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
|
|||
|
|
<Property Name="CheckInID" Type="Int64" />
|
|||
|
|
<Property Name="Status" Type="Int16" Nullable="false" />
|
|||
|
|
</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="FaceModelDaoStoreContainer" CdmEntityContainer="FaceEntities">
|
|||
|
|
<EntitySetMapping Name="company">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.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="FaceModelDao.DeviceManage">
|
|||
|
|
<MappingFragment StoreEntitySet="DeviceManage">
|
|||
|
|
<ScalarProperty Name="Facelid" ColumnName="Facelid" />
|
|||
|
|
<ScalarProperty Name="FaceIP" ColumnName="FaceIP" />
|
|||
|
|
<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="FaceModelDao.Hotel">
|
|||
|
|
<MappingFragment StoreEntitySet="Hotel">
|
|||
|
|
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
|||
|
|
<ScalarProperty Name="hotelname" ColumnName="hotelname" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="ImageList">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.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="OpenratorLog">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.OpenratorLog">
|
|||
|
|
<MappingFragment StoreEntitySet="OpenratorLog">
|
|||
|
|
<ScalarProperty Name="Operatorname" ColumnName="Operatorname" />
|
|||
|
|
<ScalarProperty Name="Browsertype" ColumnName="Browsertype" />
|
|||
|
|
<ScalarProperty Name="ipaddressip" ColumnName="ipaddressip" />
|
|||
|
|
<ScalarProperty Name="operationtype" ColumnName="operationtype" />
|
|||
|
|
<ScalarProperty Name="operatingdata" ColumnName="operatingdata" />
|
|||
|
|
<ScalarProperty Name="ologdate" ColumnName="ologdate" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="Operator">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.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" />
|
|||
|
|
<ScalarProperty Name="Operatorimg" ColumnName="Operatorimg" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="ROOM">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.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="FaceModelDao.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="UserLog">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.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>
|
|||
|
|
<EntitySetMapping Name="RoomCheck">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.RoomCheck">
|
|||
|
|
<MappingFragment StoreEntitySet="RoomCheck">
|
|||
|
|
<ScalarProperty Name="ValidateCode" ColumnName="ValidateCode" />
|
|||
|
|
<ScalarProperty Name="IDNumber" ColumnName="IDNumber" />
|
|||
|
|
<ScalarProperty Name="PhoneNumber" ColumnName="PhoneNumber" />
|
|||
|
|
<ScalarProperty Name="SyncRent" ColumnName="SyncRent" />
|
|||
|
|
<ScalarProperty Name="RentDate" ColumnName="RentDate" />
|
|||
|
|
<ScalarProperty Name="SyncCheckOut" ColumnName="SyncCheckOut" />
|
|||
|
|
<ScalarProperty Name="CheckOutDate" ColumnName="CheckOutDate" />
|
|||
|
|
<ScalarProperty Name="SyncCheckIn" ColumnName="SyncCheckIn" />
|
|||
|
|
<ScalarProperty Name="CheckInDate" ColumnName="CheckInDate" />
|
|||
|
|
<ScalarProperty Name="XmlString" ColumnName="XmlString" />
|
|||
|
|
<ScalarProperty Name="RoomNumber" ColumnName="RoomNumber" />
|
|||
|
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
|||
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|||
|
|
</MappingFragment>
|
|||
|
|
</EntityTypeMapping>
|
|||
|
|
</EntitySetMapping>
|
|||
|
|
<EntitySetMapping Name="RoomCustomer">
|
|||
|
|
<EntityTypeMapping TypeName="FaceModelDao.RoomCustomer">
|
|||
|
|
<MappingFragment StoreEntitySet="RoomCustomer">
|
|||
|
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
|||
|
|
<ScalarProperty Name="CheckInID" ColumnName="CheckInID" />
|
|||
|
|
<ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
|
|||
|
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
|||
|
|
<ScalarProperty Name="Photo" ColumnName="Photo" />
|
|||
|
|
<ScalarProperty Name="PhotoUrl" ColumnName="PhotoUrl" />
|
|||
|
|
<ScalarProperty Name="Birthday" ColumnName="Birthday" />
|
|||
|
|
<ScalarProperty Name="Sex" ColumnName="Sex" />
|
|||
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|||
|
|
<ScalarProperty Name="IDCard" ColumnName="IDCard" />
|
|||
|
|
<ScalarProperty Name="IDType" ColumnName="IDType" />
|
|||
|
|
<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>
|