LIOT/EMIS.Entities.HRServices/HRServiceContext.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="HRServiceContext.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
        <EntityContainer Name="HRServiceContextStoreContainer">
          <EntitySet Name="Comm_OrgInfo" EntityType="HRServiceContext.Store.Comm_OrgInfo" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Comm_Posts" EntityType="HRServiceContext.Store.Comm_Posts" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Comm_Users" EntityType="HRServiceContext.Store.Comm_Users" store:Type="Tables" Schema="dbo" />
          <AssociationSet Name="FK__Comm_Users__dpid__15502E78" Association="HRServiceContext.Store.FK__Comm_Users__dpid__15502E78">
            <End Role="Comm_OrgInfo" EntitySet="Comm_OrgInfo" />
            <End Role="Comm_Users" EntitySet="Comm_Users" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Comm_OrgInfo">
          <Key>
            <PropertyRef Name="dpid" />
          </Key>
          <Property Name="dpid" Type="nvarchar" Nullable="false" MaxLength="55" />
          <Property Name="parentdpid" Type="nvarchar" MaxLength="55" />
          <Property Name="dpcode" Type="nvarchar" MaxLength="155" />
          <Property Name="dplv" Type="int" />
          <Property Name="dpname" Type="nvarchar" MaxLength="55" />
          <Property Name="dpfullname" Type="nvarchar" MaxLength="155" />
          <Property Name="dpdesc" Type="nvarchar" MaxLength="55" />
          <Property Name="isshow" Type="bit" />
          <Property Name="status" Type="char" MaxLength="1" />
          <Property Name="orderNo" Type="nvarchar" MaxLength="155" />
          <Property Name="isTmpDP" Type="char" Nullable="false" MaxLength="1" />
          <Property Name="createdt" Type="datetime" />
          <Property Name="updatedt" Type="datetime" />
          <Property Name="AllowDist" Type="int" />
          <Property Name="OrderNum" Type="varchar" MaxLength="50" />
        </EntityType>
        <EntityType Name="Comm_Posts">
          <Key>
            <PropertyRef Name="postid" />
          </Key>
          <Property Name="postid" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="dpid" Type="nvarchar" Nullable="false" MaxLength="55" />
          <Property Name="userid" Type="nvarchar" MaxLength="55" />
          <Property Name="pos" Type="nvarchar" MaxLength="55" />
          <Property Name="orderNo" Type="float" />
          <Property Name="IsTmpData" Type="bit" />
        </EntityType>
        <EntityType Name="Comm_Users">
          <Key>
            <PropertyRef Name="userid" />
          </Key>
          <Property Name="userid" Type="nvarchar" Nullable="false" MaxLength="55" />
          <Property Name="loginid" Type="nvarchar" MaxLength="55" />
          <Property Name="username" Type="nvarchar" MaxLength="55" />
          <Property Name="dpid" Type="nvarchar" MaxLength="55" />
          <Property Name="telephone" Type="nvarchar" MaxLength="55" />
          <Property Name="mobile" Type="nvarchar" MaxLength="55" />
          <Property Name="email" Type="nvarchar" MaxLength="55" />
          <Property Name="cardid" Type="nvarchar" MaxLength="55" />
          <Property Name="employeeclassid" Type="nvarchar" MaxLength="55" />
          <Property Name="jobtypeid" Type="nvarchar" MaxLength="55" />
          <Property Name="birthday" Type="datetime" />
          <Property Name="sex" Type="char" MaxLength="1" />
          <Property Name="orderNo" Type="nvarchar" MaxLength="55" />
          <Property Name="userrole" Type="nvarchar" MaxLength="55" />
          <Property Name="userligion" Type="nvarchar" MaxLength="55" />
          <Property Name="password" Type="nvarchar" MaxLength="55" />
          <Property Name="changepwddate" Type="datetime" />
          <Property Name="isshow" Type="bit" />
          <Property Name="status" Type="char" MaxLength="1" />
          <Property Name="createdt" Type="datetime" />
          <Property Name="updatedt" Type="datetime" />
          <Property Name="istmpuser" Type="bit" />
          <Property Name="SpecialLicensed" Type="bit" />
        </EntityType>
        <Association Name="FK__Comm_Users__dpid__15502E78">
          <End Role="Comm_OrgInfo" Type="HRServiceContext.Store.Comm_OrgInfo" Multiplicity="0..1" />
          <End Role="Comm_Users" Type="HRServiceContext.Store.Comm_Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Comm_OrgInfo">
              <PropertyRef Name="dpid" />
            </Principal>
            <Dependent Role="Comm_Users">
              <PropertyRef Name="dpid" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema xmlns="http://schemas.microsoft.com/ado/2008/09/edm" xmlns:cg="http://schemas.microsoft.com/ado/2006/04/codegeneration" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" Namespace="HRServiceContext" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation">
        <EntityContainer Name="HRServiceContextContainer" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Comm_OrgInfo" EntityType="HRServiceContext.Comm_OrgInfo" />
          <EntitySet Name="Comm_Posts" EntityType="HRServiceContext.Comm_Posts" />
          <EntitySet Name="Comm_Users" EntityType="HRServiceContext.Comm_Users" />
          <AssociationSet Name="FK__Comm_Users__dpid__15502E78" Association="HRServiceContext.FK__Comm_Users__dpid__15502E78">
            <End Role="Comm_OrgInfo" EntitySet="Comm_OrgInfo" />
            <End Role="Comm_Users" EntitySet="Comm_Users" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Comm_OrgInfo">
          <Key>
            <PropertyRef Name="dpid" />
          </Key>
          <Property Type="String" Name="dpid" Nullable="false" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="parentdpid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="dpcode" MaxLength="155" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="dplv" />
          <Property Type="String" Name="dpname" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="dpfullname" MaxLength="155" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="dpdesc" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="isshow" />
          <Property Type="String" Name="status" MaxLength="1" FixedLength="true" Unicode="false" />
          <Property Type="String" Name="orderNo" MaxLength="155" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="isTmpDP" Nullable="false" MaxLength="1" FixedLength="true" Unicode="false" />
          <Property Type="DateTime" Name="createdt" />
          <Property Type="DateTime" Name="updatedt" />
          <Property Type="Int32" Name="AllowDist" />
          <Property Type="String" Name="OrderNum" MaxLength="50" FixedLength="false" Unicode="false" />
          <NavigationProperty Name="Comm_Users" Relationship="HRServiceContext.FK__Comm_Users__dpid__15502E78" FromRole="Comm_OrgInfo" ToRole="Comm_Users" />
        </EntityType>
        <EntityType Name="Comm_Posts">
          <Key>
            <PropertyRef Name="postid" />
          </Key>
          <Property Type="Int32" Name="postid" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="String" Name="dpid" Nullable="false" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="userid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="pos" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="Double" Name="orderNo" />
          <Property Type="Boolean" Name="IsTmpData" />
        </EntityType>
        <EntityType Name="Comm_Users">
          <Key>
            <PropertyRef Name="userid" />
          </Key>
          <Property Type="String" Name="userid" Nullable="false" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="loginid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="username" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="dpid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="telephone" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="mobile" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="email" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="cardid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="employeeclassid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="jobtypeid" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="DateTime" Name="birthday" />
          <Property Type="String" Name="sex" MaxLength="1" FixedLength="true" Unicode="false" />
          <Property Type="String" Name="orderNo" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="userrole" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="userligion" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="password" MaxLength="55" FixedLength="false" Unicode="true" />
          <Property Type="DateTime" Name="changepwddate" />
          <Property Type="Boolean" Name="isshow" />
          <Property Type="String" Name="status" MaxLength="1" FixedLength="true" Unicode="false" />
          <Property Type="DateTime" Name="createdt" />
          <Property Type="DateTime" Name="updatedt" />
          <Property Type="Boolean" Name="istmpuser" />
          <Property Type="Boolean" Name="SpecialLicensed" />
          <NavigationProperty Name="Comm_OrgInfo" Relationship="HRServiceContext.FK__Comm_Users__dpid__15502E78" FromRole="Comm_Users" ToRole="Comm_OrgInfo" />
        </EntityType>
        <Association Name="FK__Comm_Users__dpid__15502E78">
          <End Type="HRServiceContext.Comm_OrgInfo" Role="Comm_OrgInfo" Multiplicity="0..1" />
          <End Type="HRServiceContext.Comm_Users" Role="Comm_Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Comm_OrgInfo">
              <PropertyRef Name="dpid" />
            </Principal>
            <Dependent Role="Comm_Users">
              <PropertyRef Name="dpid" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs" Space="C-S">
        <Alias Key="Model" Value="HRServiceContext" />
        <Alias Key="Target" Value="HRServiceContext.Store" />
        <EntityContainerMapping CdmEntityContainer="HRServiceContextContainer" StorageEntityContainer="HRServiceContextStoreContainer">
          <EntitySetMapping Name="Comm_OrgInfo">
            <EntityTypeMapping TypeName="HRServiceContext.Comm_OrgInfo">
              <MappingFragment StoreEntitySet="Comm_OrgInfo">
                <ScalarProperty Name="OrderNum" ColumnName="OrderNum" />
                <ScalarProperty Name="AllowDist" ColumnName="AllowDist" />
                <ScalarProperty Name="updatedt" ColumnName="updatedt" />
                <ScalarProperty Name="createdt" ColumnName="createdt" />
                <ScalarProperty Name="isTmpDP" ColumnName="isTmpDP" />
                <ScalarProperty Name="orderNo" ColumnName="orderNo" />
                <ScalarProperty Name="status" ColumnName="status" />
                <ScalarProperty Name="isshow" ColumnName="isshow" />
                <ScalarProperty Name="dpdesc" ColumnName="dpdesc" />
                <ScalarProperty Name="dpfullname" ColumnName="dpfullname" />
                <ScalarProperty Name="dpname" ColumnName="dpname" />
                <ScalarProperty Name="dplv" ColumnName="dplv" />
                <ScalarProperty Name="dpcode" ColumnName="dpcode" />
                <ScalarProperty Name="parentdpid" ColumnName="parentdpid" />
                <ScalarProperty Name="dpid" ColumnName="dpid" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Comm_Posts">
            <EntityTypeMapping TypeName="HRServiceContext.Comm_Posts">
              <MappingFragment StoreEntitySet="Comm_Posts">
                <ScalarProperty Name="IsTmpData" ColumnName="IsTmpData" />
                <ScalarProperty Name="orderNo" ColumnName="orderNo" />
                <ScalarProperty Name="pos" ColumnName="pos" />
                <ScalarProperty Name="userid" ColumnName="userid" />
                <ScalarProperty Name="dpid" ColumnName="dpid" />
                <ScalarProperty Name="postid" ColumnName="postid" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Comm_Users">
            <EntityTypeMapping TypeName="HRServiceContext.Comm_Users">
              <MappingFragment StoreEntitySet="Comm_Users">
                <ScalarProperty Name="SpecialLicensed" ColumnName="SpecialLicensed" />
                <ScalarProperty Name="istmpuser" ColumnName="istmpuser" />
                <ScalarProperty Name="updatedt" ColumnName="updatedt" />
                <ScalarProperty Name="createdt" ColumnName="createdt" />
                <ScalarProperty Name="status" ColumnName="status" />
                <ScalarProperty Name="isshow" ColumnName="isshow" />
                <ScalarProperty Name="changepwddate" ColumnName="changepwddate" />
                <ScalarProperty Name="password" ColumnName="password" />
                <ScalarProperty Name="userligion" ColumnName="userligion" />
                <ScalarProperty Name="userrole" ColumnName="userrole" />
                <ScalarProperty Name="orderNo" ColumnName="orderNo" />
                <ScalarProperty Name="sex" ColumnName="sex" />
                <ScalarProperty Name="birthday" ColumnName="birthday" />
                <ScalarProperty Name="jobtypeid" ColumnName="jobtypeid" />
                <ScalarProperty Name="employeeclassid" ColumnName="employeeclassid" />
                <ScalarProperty Name="cardid" ColumnName="cardid" />
                <ScalarProperty Name="email" ColumnName="email" />
                <ScalarProperty Name="mobile" ColumnName="mobile" />
                <ScalarProperty Name="telephone" ColumnName="telephone" />
                <ScalarProperty Name="dpid" ColumnName="dpid" />
                <ScalarProperty Name="username" ColumnName="username" />
                <ScalarProperty Name="loginid" ColumnName="loginid" />
                <ScalarProperty Name="userid" ColumnName="userid" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
    <edmx:Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </edmx:Connection>
    <edmx:Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="False" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="无" />
      </DesignerInfoPropertySet>
    </edmx:Options>
    <!-- Diagram content (shape and connector positions) -->
    <edmx:Diagrams>
      <Diagram Name="HRServiceContext" >
        <EntityTypeShape EntityType="HRServiceContext.Comm_OrgInfo" Width="1.5" PointX="0.75" PointY="1.875" Height="3.9529630533854156" />
        <EntityTypeShape EntityType="HRServiceContext.Comm_Posts" Width="1.5" PointX="5.75" PointY="0.75" Height="2.1050219726562496" />
        <EntityTypeShape EntityType="HRServiceContext.Comm_Users" Width="1.5" PointX="3" PointY="1.125" Height="5.43131591796875" />
        <AssociationConnector Association="HRServiceContext.FK__Comm_Users__dpid__15502E78" >
          <ConnectorPoint PointX="2.25" PointY="3.8514815266927078" />
          <ConnectorPoint PointX="3" PointY="3.8514815266927078" />
        </AssociationConnector>
      </Diagram>
    </edmx:Diagrams>
  </edmx:Designer>
</edmx:Edmx>