123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181 |
- <?xml version="1.0" encoding="utf-8"?>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище Goiman_A_AModelContainer" CdmEntityContainer="Goiman_A_AEntities">
- <EntitySetMapping Name="Agent">
- <EntityTypeMapping TypeName="Goiman_A_AModel.Agent">
- <MappingFragment StoreEntitySet="Agent">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="AgentTypeID" ColumnName="AgentTypeID" />
- <ScalarProperty Name="Address" ColumnName="Address" />
- <ScalarProperty Name="INN" ColumnName="INN" />
- <ScalarProperty Name="KPP" ColumnName="KPP" />
- <ScalarProperty Name="DirectorName" ColumnName="DirectorName" />
- <ScalarProperty Name="Phone" ColumnName="Phone" />
- <ScalarProperty Name="Email" ColumnName="Email" />
- <ScalarProperty Name="Logo" ColumnName="Logo" />
- <ScalarProperty Name="Priority" ColumnName="Priority" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="AgentPriorityHistory">
- <EntityTypeMapping TypeName="Goiman_A_AModel.AgentPriorityHistory">
- <MappingFragment StoreEntitySet="AgentPriorityHistory">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="AgentID" ColumnName="AgentID" />
- <ScalarProperty Name="ChangeDate" ColumnName="ChangeDate" />
- <ScalarProperty Name="PriorityValue" ColumnName="PriorityValue" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="AgentType">
- <EntityTypeMapping TypeName="Goiman_A_AModel.AgentType">
- <MappingFragment StoreEntitySet="AgentType">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="Image" ColumnName="Image" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Material">
- <EntityTypeMapping TypeName="Goiman_A_AModel.Material">
- <MappingFragment StoreEntitySet="Material">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="CountInPack" ColumnName="CountInPack" />
- <ScalarProperty Name="Unit" ColumnName="Unit" />
- <ScalarProperty Name="CountInStock" ColumnName="CountInStock" />
- <ScalarProperty Name="MinCount" ColumnName="MinCount" />
- <ScalarProperty Name="Description" ColumnName="Description" />
- <ScalarProperty Name="Cost" ColumnName="Cost" />
- <ScalarProperty Name="Image" ColumnName="Image" />
- <ScalarProperty Name="MaterialTypeID" ColumnName="MaterialTypeID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="MaterialCountHistory">
- <EntityTypeMapping TypeName="Goiman_A_AModel.MaterialCountHistory">
- <MappingFragment StoreEntitySet="MaterialCountHistory">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="MaterialID" ColumnName="MaterialID" />
- <ScalarProperty Name="ChangeDate" ColumnName="ChangeDate" />
- <ScalarProperty Name="CountValue" ColumnName="CountValue" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="MaterialType">
- <EntityTypeMapping TypeName="Goiman_A_AModel.MaterialType">
- <MappingFragment StoreEntitySet="MaterialType">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="DefectedPercent" ColumnName="DefectedPercent" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Product">
- <EntityTypeMapping TypeName="Goiman_A_AModel.Product">
- <MappingFragment StoreEntitySet="Product">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="ProductTypeID" ColumnName="ProductTypeID" />
- <ScalarProperty Name="ArticleNumber" ColumnName="ArticleNumber" />
- <ScalarProperty Name="Description" ColumnName="Description" />
- <ScalarProperty Name="Image" ColumnName="Image" />
- <ScalarProperty Name="ProductionPersonCount" ColumnName="ProductionPersonCount" />
- <ScalarProperty Name="ProductionWorkshopNumber" ColumnName="ProductionWorkshopNumber" />
- <ScalarProperty Name="MinCostForAgent" ColumnName="MinCostForAgent" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="ProductCostHistory">
- <EntityTypeMapping TypeName="Goiman_A_AModel.ProductCostHistory">
- <MappingFragment StoreEntitySet="ProductCostHistory">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="ProductID" ColumnName="ProductID" />
- <ScalarProperty Name="ChangeDate" ColumnName="ChangeDate" />
- <ScalarProperty Name="CostValue" ColumnName="CostValue" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="ProductMaterial">
- <EntityTypeMapping TypeName="Goiman_A_AModel.ProductMaterial">
- <MappingFragment StoreEntitySet="ProductMaterial">
- <ScalarProperty Name="ProductID" ColumnName="ProductID" />
- <ScalarProperty Name="MaterialID" ColumnName="MaterialID" />
- <ScalarProperty Name="Count" ColumnName="Count" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="ProductSale">
- <EntityTypeMapping TypeName="Goiman_A_AModel.ProductSale">
- <MappingFragment StoreEntitySet="ProductSale">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="AgentID" ColumnName="AgentID" />
- <ScalarProperty Name="ProductID" ColumnName="ProductID" />
- <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
- <ScalarProperty Name="ProductCount" ColumnName="ProductCount" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="ProductType">
- <EntityTypeMapping TypeName="Goiman_A_AModel.ProductType">
- <MappingFragment StoreEntitySet="ProductType">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="DefectedPercent" ColumnName="DefectedPercent" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Shop">
- <EntityTypeMapping TypeName="Goiman_A_AModel.Shop">
- <MappingFragment StoreEntitySet="Shop">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="Address" ColumnName="Address" />
- <ScalarProperty Name="AgentID" ColumnName="AgentID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Supplier">
- <EntityTypeMapping TypeName="Goiman_A_AModel.Supplier">
- <MappingFragment StoreEntitySet="Supplier">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="INN" ColumnName="INN" />
- <ScalarProperty Name="StartDate" ColumnName="StartDate" />
- <ScalarProperty Name="QualityRating" ColumnName="QualityRating" />
- <ScalarProperty Name="SupplierType" ColumnName="SupplierType" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <AssociationSetMapping Name="MaterialSupplier" TypeName="Goiman_A_AModel.MaterialSupplier" StoreEntitySet="MaterialSupplier">
- <EndProperty Name="Material">
- <ScalarProperty Name="ID" ColumnName="MaterialID" />
- </EndProperty>
- <EndProperty Name="Supplier">
- <ScalarProperty Name="ID" ColumnName="SupplierID" />
- </EndProperty>
- </AssociationSetMapping>
- <EntitySetMapping Name="Role">
- <EntityTypeMapping TypeName="Goiman_A_AModel.Role">
- <MappingFragment StoreEntitySet="Role">
- <ScalarProperty Name="RoleName" ColumnName="RoleName" />
- <ScalarProperty Name="Role_ID" ColumnName="Role_ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="User">
- <EntityTypeMapping TypeName="Goiman_A_AModel.User">
- <MappingFragment StoreEntitySet="User">
- <ScalarProperty Name="Role_id" ColumnName="Role_id" />
- <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
- <ScalarProperty Name="FirstName" ColumnName="FirstName" />
- <ScalarProperty Name="SurName" ColumnName="SurName" />
- <ScalarProperty Name="Password" ColumnName="Password" />
- <ScalarProperty Name="Login" ColumnName="Login" />
- <ScalarProperty Name="User_ID" ColumnName="User_ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
|