687 lines
40 KiB
XML
687 lines
40 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="CheckInInfo">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="nvarchar" MaxLength="20" Nullable="false" />
|
|
<Property Name="IdNumber" Type="nvarchar" MaxLength="100" Nullable="false" />
|
|
<Property Name="CreationTime" Type="date" />
|
|
<Property Name="InfoSource" Type="int" Nullable="false" />
|
|
<Property Name="HotelCode" Type="int" />
|
|
<Property Name="Roomid" Type="int" />
|
|
<Property Name="CheckTime" Type="datetime" />
|
|
<Property Name="checkOutTime" Type="datetime" />
|
|
<Property Name="picture" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="identitys" Type="nvarchar" MaxLength="20" />
|
|
</EntityType>
|
|
<EntityType Name="CheckinTest">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="testState" Type="int" />
|
|
<Property Name="predictCheckIn" Type="datetime" />
|
|
<Property Name="creationTime" Type="datetime" />
|
|
<Property Name="checkInduration" Type="int" />
|
|
<Property Name="hotelid" Type="int" />
|
|
<Property Name="Roomid" Type="int" />
|
|
<Property Name="CheckoutTime" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="Dailyoperation">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Uname" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Creationtime" Type="datetime" Nullable="false" />
|
|
<Property Name="operatetype" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="operatedata" Type="nvarchar" MaxLength="200" />
|
|
<Property Name="hotelCode" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="DeviceManage">
|
|
<Key>
|
|
<PropertyRef Name="Facelid" />
|
|
</Key>
|
|
<Property Name="Facelid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="SerialNo" Type="varchar" MaxLength="20" Nullable="false" />
|
|
<Property Name="CreatedDate" Type="datetime" />
|
|
<Property Name="HotelCode" Type="varchar" MaxLength="20" />
|
|
<Property Name="RoomId" Type="int" />
|
|
<Property Name="Factory" Type="nvarchar" MaxLength="10" />
|
|
<Property Name="Status" Type="bit" Nullable="false" />
|
|
<Property Name="bindingDate" Type="date" />
|
|
<Property Name="bindingStatus" Type="bit" Nullable="false" />
|
|
<Property Name="faceIp" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="faceAddress" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="maintainStatus" Type="int" />
|
|
</EntityType>
|
|
<EntityType Name="FaceBinding">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="SerialNo" Type="nvarchar" MaxLength="100" />
|
|
<Property Name="Operator" Type="nvarchar" MaxLength="20" />
|
|
<Property Name="OperatorType" Type="bit" />
|
|
<Property Name="bindingDate" Type="datetime" />
|
|
<Property Name="HotelCode" Type="int" />
|
|
<Property Name="RoomId" Type="int" />
|
|
</EntityType>
|
|
<EntityType Name="FaceInfo">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="CreationDate" Type="date" Nullable="false" />
|
|
<Property Name="SerialNo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="BindingState" Type="bit" Nullable="false" />
|
|
<Property Name="BindingDate" Type="date" />
|
|
<Property Name="HotelCode" Type="int" />
|
|
<Property Name="Roomid" Type="int" />
|
|
<Property Name="FaceState" Type="bit" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="FaceIssue">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="faceSn" Type="nvarchar" MaxLength="100" Nullable="false" />
|
|
<Property Name="creationtime" Type="datetime" Nullable="false" />
|
|
<Property Name="pmsid" Type="nvarchar" MaxLength="200" />
|
|
<Property Name="picture" Type="nvarchar" MaxLength="100" />
|
|
<Property Name="issuestate" Type="int" Nullable="false" />
|
|
<Property Name="messageid" Type="nvarchar" MaxLength="100" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Hotel">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Code" Type="varchar" MaxLength="20" Nullable="false" />
|
|
<Property Name="Remark" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="UserWX" Type="bit" Nullable="false" />
|
|
<Property Name="HotelID" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Lodger">
|
|
<Key>
|
|
<PropertyRef Name="IDNumber" />
|
|
</Key>
|
|
<Property Name="LodgerId" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="LodgerNmae" Type="nvarchar" MaxLength="20" Nullable="false" />
|
|
<Property Name="IDNumber" Type="nvarchar" MaxLength="100" Nullable="false" />
|
|
<Property Name="Sex" Type="int" />
|
|
<Property Name="CheckInDate" Type="date" />
|
|
<Property Name="Sourcedian" Type="int" Nullable="false" />
|
|
<Property Name="phonenumber" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="remark" Type="nvarchar" MaxLength="50" />
|
|
</EntityType>
|
|
<EntityType Name="pmsInfo">
|
|
<Key>
|
|
<PropertyRef Name="pmsid" />
|
|
</Key>
|
|
<Property Name="pmsid" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Creationtime" Type="datetime" />
|
|
<Property Name="data" Type="nvarchar" MaxLength="300" />
|
|
<Property Name="infotype" Type="int" />
|
|
<Property Name="hotelid" Type="int" />
|
|
<Property Name="room" Type="int" />
|
|
</EntityType>
|
|
<EntityType Name="pmsInterface">
|
|
<Key>
|
|
<PropertyRef Name="pmsId" />
|
|
</Key>
|
|
<Property Name="pmsId" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="DateTime" Type="datetime" Nullable="false" />
|
|
<Property Name="pmsContent" Type="nvarchar" MaxLength="300" Nullable="false" />
|
|
<Property Name="hotelid" Type="int" />
|
|
<Property Name="room" Type="int" />
|
|
<Property Name="faceSN" Type="nvarchar" MaxLength="100" />
|
|
<Property Name="issueresult" Type="int" />
|
|
<Property Name="pmstype" Type="int" />
|
|
<Property Name="messageid" Type="nvarchar" MaxLength="100" />
|
|
</EntityType>
|
|
<EntityType Name="pmsLog">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="pmsid" Type="int" Nullable="false" />
|
|
<Property Name="step" Type="int" />
|
|
<Property Name="app" Type="int" />
|
|
<Property Name="Creationtime" Type="datetime" />
|
|
<Property Name="message" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="Data" Type="nvarchar" MaxLength="500" />
|
|
</EntityType>
|
|
<EntityType Name="subtabulation">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="masterid" Type="int" />
|
|
<Property Name="Lodgerid" Type="int" />
|
|
</EntityType>
|
|
<EntityType Name="TestUser">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="name" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="sex" Type="int" />
|
|
<Property Name="phone" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="idNumber" Type="nvarchar" MaxLength="100" />
|
|
<Property Name="picture" Type="nvarchar" MaxLength="200" />
|
|
<Property Name="creationTime" Type="datetime" />
|
|
<Property Name="state" Type="int" />
|
|
<Property Name="establish" Type="nvarchar" MaxLength="20" />
|
|
</EntityType>
|
|
<EntityType Name="transferFace">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="faceSN" Type="nvarchar" MaxLength="100" />
|
|
<Property Name="infoid" Type="nvarchar" MaxLength="150" />
|
|
<Property Name="faultState" Type="int" />
|
|
<Property Name="creationTime" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="ULog">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Uname" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Creationtime" Type="datetime" Nullable="false" />
|
|
<Property Name="operatetype" Type="nvarchar" MaxLength="20" Nullable="false" />
|
|
<Property Name="faceSN" Type="nvarchar" MaxLength="100" />
|
|
<Property Name="hotelcode" Type="int" />
|
|
<Property Name="roomid" Type="int" />
|
|
</EntityType>
|
|
<EntityContainer Name="FaceModelStoreContainer">
|
|
<EntitySet Name="CheckInInfo" EntityType="Self.CheckInInfo" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="CheckinTest" EntityType="Self.CheckinTest" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Dailyoperation" EntityType="Self.Dailyoperation" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="DeviceManage" EntityType="Self.DeviceManage" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="FaceBinding" EntityType="Self.FaceBinding" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="FaceInfo" EntityType="Self.FaceInfo" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="FaceIssue" EntityType="Self.FaceIssue" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Hotel" EntityType="Self.Hotel" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Lodger" EntityType="Self.Lodger" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="pmsInfo" EntityType="Self.pmsInfo" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="pmsInterface" EntityType="Self.pmsInterface" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="pmsLog" EntityType="Self.pmsLog" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="subtabulation" EntityType="Self.subtabulation" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="TestUser" EntityType="Self.TestUser" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="transferFace" EntityType="Self.transferFace" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="ULog" EntityType="Self.ULog" Schema="dbo" store:Type="Tables" />
|
|
</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="Hotel">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Code" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
|
<Property Name="Remark" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="UserWX" Type="Boolean" Nullable="false" />
|
|
<Property Name="HotelID" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
<EntityContainer Name="FaceEntitiesShow" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="Hotel" EntityType="Self.Hotel" />
|
|
<EntitySet Name="Lodger" EntityType="FaceModel.Lodger" />
|
|
<EntitySet Name="FaceInfo" EntityType="FaceModel.FaceInfo" />
|
|
<EntitySet Name="FaceBinding" EntityType="FaceModel.FaceBinding" />
|
|
<EntitySet Name="Dailyoperation" EntityType="FaceModel.Dailyoperation" />
|
|
<EntitySet Name="CheckInInfo" EntityType="FaceModel.CheckInInfo" />
|
|
<EntitySet Name="subtabulation" EntityType="FaceModel.subtabulation" />
|
|
<EntitySet Name="transferFace" EntityType="FaceModel.transferFace" />
|
|
<EntitySet Name="ULog" EntityType="FaceModel.ULog" />
|
|
<EntitySet Name="DeviceManage" EntityType="FaceModel.DeviceManage" />
|
|
<EntitySet Name="TestUser" EntityType="FaceModel.TestUser" />
|
|
<EntitySet Name="FaceIssue" EntityType="FaceModel.FaceIssue" />
|
|
<EntitySet Name="CheckinTest" EntityType="FaceModel.CheckinTest" />
|
|
<EntitySet Name="pmsInfo" EntityType="FaceModel.pmsInfo" />
|
|
<EntitySet Name="pmsLog" EntityType="FaceModel.pmsLog" />
|
|
<EntitySet Name="pmsInterface" EntityType="FaceModel.pmsInterface" />
|
|
</EntityContainer>
|
|
<EntityType Name="Lodger">
|
|
<Key>
|
|
<PropertyRef Name="IDNumber" />
|
|
</Key>
|
|
<Property Name="LodgerId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="LodgerNmae" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
<Property Name="IDNumber" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="Sex" Type="Int32" />
|
|
<Property Name="CheckInDate" Type="DateTime" Precision="0" />
|
|
<Property Name="Sourcedian" Type="Int32" Nullable="false" />
|
|
<Property Name="phonenumber" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="remark" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<EntityType Name="FaceInfo">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="CreationDate" Type="DateTime" Nullable="false" Precision="0" />
|
|
<Property Name="SerialNo" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="BindingState" Type="Boolean" Nullable="false" />
|
|
<Property Name="BindingDate" Type="DateTime" Precision="0" />
|
|
<Property Name="HotelCode" Type="Int32" />
|
|
<Property Name="Roomid" Type="Int32" />
|
|
<Property Name="FaceState" Type="Boolean" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="FaceBinding">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="SerialNo" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="Operator" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
<Property Name="OperatorType" Type="Boolean" />
|
|
<Property Name="bindingDate" Type="DateTime" Precision="3" />
|
|
<Property Name="HotelCode" Type="Int32" />
|
|
<Property Name="RoomId" Type="Int32" />
|
|
</EntityType>
|
|
<EntityType Name="Dailyoperation">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Uname" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Creationtime" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="operatetype" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="operatedata" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
|
<Property Name="hotelCode" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="CheckInInfo">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
<Property Name="IdNumber" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="CreationTime" Type="DateTime" Precision="0" />
|
|
<Property Name="InfoSource" Type="Int32" Nullable="false" />
|
|
<Property Name="HotelCode" Type="Int32" />
|
|
<Property Name="Roomid" Type="Int32" />
|
|
<Property Name="CheckTime" Type="DateTime" Precision="3" />
|
|
<Property Name="checkOutTime" Type="DateTime" Precision="3" />
|
|
<Property Name="picture" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="identitys" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<EntityType Name="subtabulation">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="masterid" Type="Int32" />
|
|
<Property Name="Lodgerid" Type="Int32" />
|
|
</EntityType>
|
|
<EntityType Name="transferFace">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="faceSN" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="infoid" Type="String" MaxLength="150" FixedLength="false" Unicode="true" />
|
|
<Property Name="faultState" Type="Int32" />
|
|
<Property Name="creationTime" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="ULog">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Uname" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Creationtime" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="operatetype" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
<Property Name="faceSN" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="hotelcode" Type="Int32" />
|
|
<Property Name="roomid" Type="Int32" />
|
|
</EntityType>
|
|
<EntityType Name="DeviceManage">
|
|
<Key>
|
|
<PropertyRef Name="Facelid" />
|
|
</Key>
|
|
<Property Name="Facelid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="SerialNo" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
|
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
|
<Property Name="HotelCode" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
|
<Property Name="RoomId" Type="Int32" />
|
|
<Property Name="Factory" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
|
|
<Property Name="Status" Type="Boolean" Nullable="false" />
|
|
<Property Name="bindingDate" Type="DateTime" Precision="0" />
|
|
<Property Name="bindingStatus" Type="Boolean" Nullable="false" />
|
|
<Property Name="faceIp" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="faceAddress" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="maintainStatus" Type="Int32" />
|
|
</EntityType>
|
|
<EntityType Name="TestUser">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="sex" Type="Int32" />
|
|
<Property Name="phone" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="idNumber" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="picture" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
|
<Property Name="creationTime" Type="DateTime" Precision="3" />
|
|
<Property Name="state" Type="Int32" />
|
|
<Property Name="establish" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<EntityType Name="FaceIssue">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="faceSn" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="creationtime" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="pmsid" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
|
<Property Name="picture" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="issuestate" Type="Int32" Nullable="false" />
|
|
<Property Name="messageid" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<EntityType Name="CheckinTest">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="testState" Type="Int32" />
|
|
<Property Name="predictCheckIn" Type="DateTime" Precision="3" />
|
|
<Property Name="creationTime" Type="DateTime" Precision="3" />
|
|
<Property Name="checkInduration" Type="Int32" />
|
|
<Property Name="hotelid" Type="Int32" />
|
|
<Property Name="Roomid" Type="Int32" />
|
|
<Property Name="CheckoutTime" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="pmsInfo">
|
|
<Key>
|
|
<PropertyRef Name="pmsid" />
|
|
</Key>
|
|
<Property Name="pmsid" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Creationtime" Type="DateTime" Precision="3" />
|
|
<Property Name="data" Type="String" MaxLength="300" FixedLength="false" Unicode="true" />
|
|
<Property Name="infotype" Type="Int32" />
|
|
<Property Name="hotelid" Type="Int32" />
|
|
<Property Name="room" Type="Int32" />
|
|
</EntityType>
|
|
<EntityType Name="pmsLog">
|
|
<Key>
|
|
<PropertyRef Name="id" />
|
|
</Key>
|
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="pmsid" Type="Int32" Nullable="false" />
|
|
<Property Name="step" Type="Int32" />
|
|
<Property Name="app" Type="Int32" />
|
|
<Property Name="Creationtime" Type="DateTime" Precision="3" />
|
|
<Property Name="message" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Data" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<EntityType Name="pmsInterface">
|
|
<Key>
|
|
<PropertyRef Name="pmsId" />
|
|
</Key>
|
|
<Property Name="pmsId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="DateTime" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="pmsContent" Type="String" Nullable="false" MaxLength="300" FixedLength="false" Unicode="true" />
|
|
<Property Name="hotelid" Type="Int32" />
|
|
<Property Name="room" Type="Int32" />
|
|
<Property Name="faceSN" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="issueresult" Type="Int32" />
|
|
<Property Name="pmstype" Type="Int32" />
|
|
<Property Name="messageid" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
</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="FaceModelStoreContainer" CdmEntityContainer="FaceEntitiesShow">
|
|
<EntitySetMapping Name="Hotel">
|
|
<EntityTypeMapping TypeName="FaceModel.Hotel">
|
|
<MappingFragment StoreEntitySet="Hotel">
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
|
<ScalarProperty Name="UserWX" ColumnName="UserWX" />
|
|
<ScalarProperty Name="HotelID" ColumnName="HotelID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Lodger">
|
|
<EntityTypeMapping TypeName="FaceModel.Lodger">
|
|
<MappingFragment StoreEntitySet="Lodger">
|
|
<ScalarProperty Name="remark" ColumnName="remark" />
|
|
<ScalarProperty Name="phonenumber" ColumnName="phonenumber" />
|
|
<ScalarProperty Name="Sourcedian" ColumnName="Sourcedian" />
|
|
<ScalarProperty Name="CheckInDate" ColumnName="CheckInDate" />
|
|
<ScalarProperty Name="Sex" ColumnName="Sex" />
|
|
<ScalarProperty Name="IDNumber" ColumnName="IDNumber" />
|
|
<ScalarProperty Name="LodgerNmae" ColumnName="LodgerNmae" />
|
|
<ScalarProperty Name="LodgerId" ColumnName="LodgerId" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="FaceInfo">
|
|
<EntityTypeMapping TypeName="FaceModel.FaceInfo">
|
|
<MappingFragment StoreEntitySet="FaceInfo">
|
|
<ScalarProperty Name="FaceState" ColumnName="FaceState" />
|
|
<ScalarProperty Name="Roomid" ColumnName="Roomid" />
|
|
<ScalarProperty Name="HotelCode" ColumnName="HotelCode" />
|
|
<ScalarProperty Name="BindingDate" ColumnName="BindingDate" />
|
|
<ScalarProperty Name="BindingState" ColumnName="BindingState" />
|
|
<ScalarProperty Name="SerialNo" ColumnName="SerialNo" />
|
|
<ScalarProperty Name="CreationDate" ColumnName="CreationDate" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="FaceBinding">
|
|
<EntityTypeMapping TypeName="FaceModel.FaceBinding">
|
|
<MappingFragment StoreEntitySet="FaceBinding">
|
|
<ScalarProperty Name="RoomId" ColumnName="RoomId" />
|
|
<ScalarProperty Name="HotelCode" ColumnName="HotelCode" />
|
|
<ScalarProperty Name="bindingDate" ColumnName="bindingDate" />
|
|
<ScalarProperty Name="OperatorType" ColumnName="OperatorType" />
|
|
<ScalarProperty Name="Operator" ColumnName="Operator" />
|
|
<ScalarProperty Name="SerialNo" ColumnName="SerialNo" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Dailyoperation">
|
|
<EntityTypeMapping TypeName="FaceModel.Dailyoperation">
|
|
<MappingFragment StoreEntitySet="Dailyoperation">
|
|
<ScalarProperty Name="hotelCode" ColumnName="hotelCode" />
|
|
<ScalarProperty Name="operatedata" ColumnName="operatedata" />
|
|
<ScalarProperty Name="operatetype" ColumnName="operatetype" />
|
|
<ScalarProperty Name="Creationtime" ColumnName="Creationtime" />
|
|
<ScalarProperty Name="Uname" ColumnName="Uname" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="CheckInInfo">
|
|
<EntityTypeMapping TypeName="FaceModel.CheckInInfo">
|
|
<MappingFragment StoreEntitySet="CheckInInfo">
|
|
<ScalarProperty Name="identitys" ColumnName="identitys" />
|
|
<ScalarProperty Name="picture" ColumnName="picture" />
|
|
<ScalarProperty Name="checkOutTime" ColumnName="checkOutTime" />
|
|
<ScalarProperty Name="CheckTime" ColumnName="CheckTime" />
|
|
<ScalarProperty Name="Roomid" ColumnName="Roomid" />
|
|
<ScalarProperty Name="HotelCode" ColumnName="HotelCode" />
|
|
<ScalarProperty Name="InfoSource" ColumnName="InfoSource" />
|
|
<ScalarProperty Name="CreationTime" ColumnName="CreationTime" />
|
|
<ScalarProperty Name="IdNumber" ColumnName="IdNumber" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="subtabulation">
|
|
<EntityTypeMapping TypeName="FaceModel.subtabulation">
|
|
<MappingFragment StoreEntitySet="subtabulation">
|
|
<ScalarProperty Name="Lodgerid" ColumnName="Lodgerid" />
|
|
<ScalarProperty Name="masterid" ColumnName="masterid" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="transferFace">
|
|
<EntityTypeMapping TypeName="FaceModel.transferFace">
|
|
<MappingFragment StoreEntitySet="transferFace">
|
|
<ScalarProperty Name="creationTime" ColumnName="creationTime" />
|
|
<ScalarProperty Name="faultState" ColumnName="faultState" />
|
|
<ScalarProperty Name="infoid" ColumnName="infoid" />
|
|
<ScalarProperty Name="faceSN" ColumnName="faceSN" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ULog">
|
|
<EntityTypeMapping TypeName="FaceModel.ULog">
|
|
<MappingFragment StoreEntitySet="ULog">
|
|
<ScalarProperty Name="roomid" ColumnName="roomid" />
|
|
<ScalarProperty Name="hotelcode" ColumnName="hotelcode" />
|
|
<ScalarProperty Name="faceSN" ColumnName="faceSN" />
|
|
<ScalarProperty Name="operatetype" ColumnName="operatetype" />
|
|
<ScalarProperty Name="Creationtime" ColumnName="Creationtime" />
|
|
<ScalarProperty Name="Uname" ColumnName="Uname" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="DeviceManage">
|
|
<EntityTypeMapping TypeName="FaceModel.DeviceManage">
|
|
<MappingFragment StoreEntitySet="DeviceManage">
|
|
<ScalarProperty Name="maintainStatus" ColumnName="maintainStatus" />
|
|
<ScalarProperty Name="faceAddress" ColumnName="faceAddress" />
|
|
<ScalarProperty Name="faceIp" ColumnName="faceIp" />
|
|
<ScalarProperty Name="bindingStatus" ColumnName="bindingStatus" />
|
|
<ScalarProperty Name="bindingDate" ColumnName="bindingDate" />
|
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
|
<ScalarProperty Name="Factory" ColumnName="Factory" />
|
|
<ScalarProperty Name="RoomId" ColumnName="RoomId" />
|
|
<ScalarProperty Name="HotelCode" ColumnName="HotelCode" />
|
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
|
<ScalarProperty Name="SerialNo" ColumnName="SerialNo" />
|
|
<ScalarProperty Name="Facelid" ColumnName="Facelid" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="TestUser">
|
|
<EntityTypeMapping TypeName="FaceModel.TestUser">
|
|
<MappingFragment StoreEntitySet="TestUser">
|
|
<ScalarProperty Name="establish" ColumnName="establish" />
|
|
<ScalarProperty Name="state" ColumnName="state" />
|
|
<ScalarProperty Name="creationTime" ColumnName="creationTime" />
|
|
<ScalarProperty Name="picture" ColumnName="picture" />
|
|
<ScalarProperty Name="idNumber" ColumnName="idNumber" />
|
|
<ScalarProperty Name="phone" ColumnName="phone" />
|
|
<ScalarProperty Name="sex" ColumnName="sex" />
|
|
<ScalarProperty Name="name" ColumnName="name" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="FaceIssue">
|
|
<EntityTypeMapping TypeName="FaceModel.FaceIssue">
|
|
<MappingFragment StoreEntitySet="FaceIssue">
|
|
<ScalarProperty Name="messageid" ColumnName="messageid" />
|
|
<ScalarProperty Name="issuestate" ColumnName="issuestate" />
|
|
<ScalarProperty Name="picture" ColumnName="picture" />
|
|
<ScalarProperty Name="pmsid" ColumnName="pmsid" />
|
|
<ScalarProperty Name="creationtime" ColumnName="creationtime" />
|
|
<ScalarProperty Name="faceSn" ColumnName="faceSn" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="CheckinTest">
|
|
<EntityTypeMapping TypeName="FaceModel.CheckinTest">
|
|
<MappingFragment StoreEntitySet="CheckinTest">
|
|
<ScalarProperty Name="CheckoutTime" ColumnName="CheckoutTime" />
|
|
<ScalarProperty Name="Roomid" ColumnName="Roomid" />
|
|
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
|
<ScalarProperty Name="checkInduration" ColumnName="checkInduration" />
|
|
<ScalarProperty Name="creationTime" ColumnName="creationTime" />
|
|
<ScalarProperty Name="predictCheckIn" ColumnName="predictCheckIn" />
|
|
<ScalarProperty Name="testState" ColumnName="testState" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="pmsInfo">
|
|
<EntityTypeMapping TypeName="FaceModel.pmsInfo">
|
|
<MappingFragment StoreEntitySet="pmsInfo">
|
|
<ScalarProperty Name="room" ColumnName="room" />
|
|
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
|
<ScalarProperty Name="infotype" ColumnName="infotype" />
|
|
<ScalarProperty Name="data" ColumnName="data" />
|
|
<ScalarProperty Name="Creationtime" ColumnName="Creationtime" />
|
|
<ScalarProperty Name="pmsid" ColumnName="pmsid" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="pmsLog">
|
|
<EntityTypeMapping TypeName="FaceModel.pmsLog">
|
|
<MappingFragment StoreEntitySet="pmsLog">
|
|
<ScalarProperty Name="Data" ColumnName="Data" />
|
|
<ScalarProperty Name="message" ColumnName="message" />
|
|
<ScalarProperty Name="Creationtime" ColumnName="Creationtime" />
|
|
<ScalarProperty Name="app" ColumnName="app" />
|
|
<ScalarProperty Name="step" ColumnName="step" />
|
|
<ScalarProperty Name="pmsid" ColumnName="pmsid" />
|
|
<ScalarProperty Name="id" ColumnName="id" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="pmsInterface">
|
|
<EntityTypeMapping TypeName="FaceModel.pmsInterface">
|
|
<MappingFragment StoreEntitySet="pmsInterface">
|
|
<ScalarProperty Name="messageid" ColumnName="messageid" />
|
|
<ScalarProperty Name="pmstype" ColumnName="pmstype" />
|
|
<ScalarProperty Name="issueresult" ColumnName="issueresult" />
|
|
<ScalarProperty Name="faceSN" ColumnName="faceSN" />
|
|
<ScalarProperty Name="room" ColumnName="room" />
|
|
<ScalarProperty Name="hotelid" ColumnName="hotelid" />
|
|
<ScalarProperty Name="pmsContent" ColumnName="pmsContent" />
|
|
<ScalarProperty Name="DateTime" ColumnName="DateTime" />
|
|
<ScalarProperty Name="pmsId" ColumnName="pmsId" />
|
|
</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> |