Model1.msl 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  3. <EntityContainerMapping StorageEntityContainer="Хранилище Goiman_A_AModelContainer" CdmEntityContainer="Goiman_A_AEntities">
  4. <EntitySetMapping Name="Agent">
  5. <EntityTypeMapping TypeName="Goiman_A_AModel.Agent">
  6. <MappingFragment StoreEntitySet="Agent">
  7. <ScalarProperty Name="ID" ColumnName="ID" />
  8. <ScalarProperty Name="Title" ColumnName="Title" />
  9. <ScalarProperty Name="AgentTypeID" ColumnName="AgentTypeID" />
  10. <ScalarProperty Name="Address" ColumnName="Address" />
  11. <ScalarProperty Name="INN" ColumnName="INN" />
  12. <ScalarProperty Name="KPP" ColumnName="KPP" />
  13. <ScalarProperty Name="DirectorName" ColumnName="DirectorName" />
  14. <ScalarProperty Name="Phone" ColumnName="Phone" />
  15. <ScalarProperty Name="Email" ColumnName="Email" />
  16. <ScalarProperty Name="Logo" ColumnName="Logo" />
  17. <ScalarProperty Name="Priority" ColumnName="Priority" />
  18. </MappingFragment>
  19. </EntityTypeMapping>
  20. </EntitySetMapping>
  21. <EntitySetMapping Name="AgentPriorityHistory">
  22. <EntityTypeMapping TypeName="Goiman_A_AModel.AgentPriorityHistory">
  23. <MappingFragment StoreEntitySet="AgentPriorityHistory">
  24. <ScalarProperty Name="ID" ColumnName="ID" />
  25. <ScalarProperty Name="AgentID" ColumnName="AgentID" />
  26. <ScalarProperty Name="ChangeDate" ColumnName="ChangeDate" />
  27. <ScalarProperty Name="PriorityValue" ColumnName="PriorityValue" />
  28. </MappingFragment>
  29. </EntityTypeMapping>
  30. </EntitySetMapping>
  31. <EntitySetMapping Name="AgentType">
  32. <EntityTypeMapping TypeName="Goiman_A_AModel.AgentType">
  33. <MappingFragment StoreEntitySet="AgentType">
  34. <ScalarProperty Name="ID" ColumnName="ID" />
  35. <ScalarProperty Name="Title" ColumnName="Title" />
  36. <ScalarProperty Name="Image" ColumnName="Image" />
  37. </MappingFragment>
  38. </EntityTypeMapping>
  39. </EntitySetMapping>
  40. <EntitySetMapping Name="Material">
  41. <EntityTypeMapping TypeName="Goiman_A_AModel.Material">
  42. <MappingFragment StoreEntitySet="Material">
  43. <ScalarProperty Name="ID" ColumnName="ID" />
  44. <ScalarProperty Name="Title" ColumnName="Title" />
  45. <ScalarProperty Name="CountInPack" ColumnName="CountInPack" />
  46. <ScalarProperty Name="Unit" ColumnName="Unit" />
  47. <ScalarProperty Name="CountInStock" ColumnName="CountInStock" />
  48. <ScalarProperty Name="MinCount" ColumnName="MinCount" />
  49. <ScalarProperty Name="Description" ColumnName="Description" />
  50. <ScalarProperty Name="Cost" ColumnName="Cost" />
  51. <ScalarProperty Name="Image" ColumnName="Image" />
  52. <ScalarProperty Name="MaterialTypeID" ColumnName="MaterialTypeID" />
  53. </MappingFragment>
  54. </EntityTypeMapping>
  55. </EntitySetMapping>
  56. <EntitySetMapping Name="MaterialCountHistory">
  57. <EntityTypeMapping TypeName="Goiman_A_AModel.MaterialCountHistory">
  58. <MappingFragment StoreEntitySet="MaterialCountHistory">
  59. <ScalarProperty Name="ID" ColumnName="ID" />
  60. <ScalarProperty Name="MaterialID" ColumnName="MaterialID" />
  61. <ScalarProperty Name="ChangeDate" ColumnName="ChangeDate" />
  62. <ScalarProperty Name="CountValue" ColumnName="CountValue" />
  63. </MappingFragment>
  64. </EntityTypeMapping>
  65. </EntitySetMapping>
  66. <EntitySetMapping Name="MaterialType">
  67. <EntityTypeMapping TypeName="Goiman_A_AModel.MaterialType">
  68. <MappingFragment StoreEntitySet="MaterialType">
  69. <ScalarProperty Name="ID" ColumnName="ID" />
  70. <ScalarProperty Name="Title" ColumnName="Title" />
  71. <ScalarProperty Name="DefectedPercent" ColumnName="DefectedPercent" />
  72. </MappingFragment>
  73. </EntityTypeMapping>
  74. </EntitySetMapping>
  75. <EntitySetMapping Name="Product">
  76. <EntityTypeMapping TypeName="Goiman_A_AModel.Product">
  77. <MappingFragment StoreEntitySet="Product">
  78. <ScalarProperty Name="ID" ColumnName="ID" />
  79. <ScalarProperty Name="Title" ColumnName="Title" />
  80. <ScalarProperty Name="ProductTypeID" ColumnName="ProductTypeID" />
  81. <ScalarProperty Name="ArticleNumber" ColumnName="ArticleNumber" />
  82. <ScalarProperty Name="Description" ColumnName="Description" />
  83. <ScalarProperty Name="Image" ColumnName="Image" />
  84. <ScalarProperty Name="ProductionPersonCount" ColumnName="ProductionPersonCount" />
  85. <ScalarProperty Name="ProductionWorkshopNumber" ColumnName="ProductionWorkshopNumber" />
  86. <ScalarProperty Name="MinCostForAgent" ColumnName="MinCostForAgent" />
  87. </MappingFragment>
  88. </EntityTypeMapping>
  89. </EntitySetMapping>
  90. <EntitySetMapping Name="ProductCostHistory">
  91. <EntityTypeMapping TypeName="Goiman_A_AModel.ProductCostHistory">
  92. <MappingFragment StoreEntitySet="ProductCostHistory">
  93. <ScalarProperty Name="ID" ColumnName="ID" />
  94. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  95. <ScalarProperty Name="ChangeDate" ColumnName="ChangeDate" />
  96. <ScalarProperty Name="CostValue" ColumnName="CostValue" />
  97. </MappingFragment>
  98. </EntityTypeMapping>
  99. </EntitySetMapping>
  100. <EntitySetMapping Name="ProductMaterial">
  101. <EntityTypeMapping TypeName="Goiman_A_AModel.ProductMaterial">
  102. <MappingFragment StoreEntitySet="ProductMaterial">
  103. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  104. <ScalarProperty Name="MaterialID" ColumnName="MaterialID" />
  105. <ScalarProperty Name="Count" ColumnName="Count" />
  106. </MappingFragment>
  107. </EntityTypeMapping>
  108. </EntitySetMapping>
  109. <EntitySetMapping Name="ProductSale">
  110. <EntityTypeMapping TypeName="Goiman_A_AModel.ProductSale">
  111. <MappingFragment StoreEntitySet="ProductSale">
  112. <ScalarProperty Name="ID" ColumnName="ID" />
  113. <ScalarProperty Name="AgentID" ColumnName="AgentID" />
  114. <ScalarProperty Name="ProductID" ColumnName="ProductID" />
  115. <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
  116. <ScalarProperty Name="ProductCount" ColumnName="ProductCount" />
  117. </MappingFragment>
  118. </EntityTypeMapping>
  119. </EntitySetMapping>
  120. <EntitySetMapping Name="ProductType">
  121. <EntityTypeMapping TypeName="Goiman_A_AModel.ProductType">
  122. <MappingFragment StoreEntitySet="ProductType">
  123. <ScalarProperty Name="ID" ColumnName="ID" />
  124. <ScalarProperty Name="Title" ColumnName="Title" />
  125. <ScalarProperty Name="DefectedPercent" ColumnName="DefectedPercent" />
  126. </MappingFragment>
  127. </EntityTypeMapping>
  128. </EntitySetMapping>
  129. <EntitySetMapping Name="Shop">
  130. <EntityTypeMapping TypeName="Goiman_A_AModel.Shop">
  131. <MappingFragment StoreEntitySet="Shop">
  132. <ScalarProperty Name="ID" ColumnName="ID" />
  133. <ScalarProperty Name="Title" ColumnName="Title" />
  134. <ScalarProperty Name="Address" ColumnName="Address" />
  135. <ScalarProperty Name="AgentID" ColumnName="AgentID" />
  136. </MappingFragment>
  137. </EntityTypeMapping>
  138. </EntitySetMapping>
  139. <EntitySetMapping Name="Supplier">
  140. <EntityTypeMapping TypeName="Goiman_A_AModel.Supplier">
  141. <MappingFragment StoreEntitySet="Supplier">
  142. <ScalarProperty Name="ID" ColumnName="ID" />
  143. <ScalarProperty Name="Title" ColumnName="Title" />
  144. <ScalarProperty Name="INN" ColumnName="INN" />
  145. <ScalarProperty Name="StartDate" ColumnName="StartDate" />
  146. <ScalarProperty Name="QualityRating" ColumnName="QualityRating" />
  147. <ScalarProperty Name="SupplierType" ColumnName="SupplierType" />
  148. </MappingFragment>
  149. </EntityTypeMapping>
  150. </EntitySetMapping>
  151. <AssociationSetMapping Name="MaterialSupplier" TypeName="Goiman_A_AModel.MaterialSupplier" StoreEntitySet="MaterialSupplier">
  152. <EndProperty Name="Material">
  153. <ScalarProperty Name="ID" ColumnName="MaterialID" />
  154. </EndProperty>
  155. <EndProperty Name="Supplier">
  156. <ScalarProperty Name="ID" ColumnName="SupplierID" />
  157. </EndProperty>
  158. </AssociationSetMapping>
  159. <EntitySetMapping Name="Role">
  160. <EntityTypeMapping TypeName="Goiman_A_AModel.Role">
  161. <MappingFragment StoreEntitySet="Role">
  162. <ScalarProperty Name="RoleName" ColumnName="RoleName" />
  163. <ScalarProperty Name="Role_ID" ColumnName="Role_ID" />
  164. </MappingFragment>
  165. </EntityTypeMapping>
  166. </EntitySetMapping>
  167. <EntitySetMapping Name="User">
  168. <EntityTypeMapping TypeName="Goiman_A_AModel.User">
  169. <MappingFragment StoreEntitySet="User">
  170. <ScalarProperty Name="Role_id" ColumnName="Role_id" />
  171. <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
  172. <ScalarProperty Name="FirstName" ColumnName="FirstName" />
  173. <ScalarProperty Name="SurName" ColumnName="SurName" />
  174. <ScalarProperty Name="Password" ColumnName="Password" />
  175. <ScalarProperty Name="Login" ColumnName="Login" />
  176. <ScalarProperty Name="User_ID" ColumnName="User_ID" />
  177. </MappingFragment>
  178. </EntityTypeMapping>
  179. </EntitySetMapping>
  180. </EntityContainerMapping>
  181. </Mapping>