Model1.msl 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
  3. <EntityContainerMapping StorageEntityContainer="Хранилище gr606_sosanModelContainer" CdmEntityContainer="Entities">
  4. <EntitySetMapping Name="Address">
  5. <EntityTypeMapping TypeName="gr606_sosanModel.Address">
  6. <MappingFragment StoreEntitySet="Address">
  7. <ScalarProperty Name="IdAddress" ColumnName="IdAddress" />
  8. <ScalarProperty Name="Street" ColumnName="Street" />
  9. <ScalarProperty Name="Number" ColumnName="Number" />
  10. <ScalarProperty Name="HouseNumber" ColumnName="HouseNumber" />
  11. <ScalarProperty Name="Flat" ColumnName="Flat" />
  12. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  13. </MappingFragment>
  14. </EntityTypeMapping>
  15. </EntitySetMapping>
  16. <EntitySetMapping Name="CardAmount">
  17. <EntityTypeMapping TypeName="gr606_sosanModel.CardAmount">
  18. <MappingFragment StoreEntitySet="CardAmount">
  19. <ScalarProperty Name="IdCard" ColumnName="IdCard" />
  20. <ScalarProperty Name="Sum" ColumnName="Sum" />
  21. <ScalarProperty Name="PaymentName" ColumnName="PaymentName" />
  22. <ScalarProperty Name="IdPay" ColumnName="IdPay" />
  23. </MappingFragment>
  24. </EntityTypeMapping>
  25. </EntitySetMapping>
  26. <EntitySetMapping Name="Cash">
  27. <EntityTypeMapping TypeName="gr606_sosanModel.Cash">
  28. <MappingFragment StoreEntitySet="Cash">
  29. <ScalarProperty Name="IdCash" ColumnName="IdCash" />
  30. <ScalarProperty Name="Sum" ColumnName="Sum" />
  31. <ScalarProperty Name="PaymentName" ColumnName="PaymentName" />
  32. <ScalarProperty Name="IdPay" ColumnName="IdPay" />
  33. </MappingFragment>
  34. </EntityTypeMapping>
  35. </EntitySetMapping>
  36. <EntitySetMapping Name="CashRegister">
  37. <EntityTypeMapping TypeName="gr606_sosanModel.CashRegister">
  38. <MappingFragment StoreEntitySet="CashRegister">
  39. <ScalarProperty Name="IdCashRegistre" ColumnName="IdCashRegistre" />
  40. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  41. <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
  42. <ScalarProperty Name="IdSurrender" ColumnName="IdSurrender" />
  43. <ScalarProperty Name="IdDate" ColumnName="IdDate" />
  44. <ScalarProperty Name="IdPay" ColumnName="IdPay" />
  45. </MappingFragment>
  46. </EntityTypeMapping>
  47. </EntitySetMapping>
  48. <EntitySetMapping Name="Dates">
  49. <EntityTypeMapping TypeName="gr606_sosanModel.Dates">
  50. <MappingFragment StoreEntitySet="Dates">
  51. <ScalarProperty Name="IdDate" ColumnName="IdDate" />
  52. <ScalarProperty Name="Date" ColumnName="Date" />
  53. </MappingFragment>
  54. </EntityTypeMapping>
  55. </EntitySetMapping>
  56. <EntitySetMapping Name="Employees">
  57. <EntityTypeMapping TypeName="gr606_sosanModel.Employees">
  58. <MappingFragment StoreEntitySet="Employees">
  59. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  60. <ScalarProperty Name="Surname" ColumnName="Surname" />
  61. <ScalarProperty Name="Name" ColumnName="Name" />
  62. <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
  63. <ScalarProperty Name="TelephoneNumber" ColumnName="TelephoneNumber" />
  64. <ScalarProperty Name="Email" ColumnName="Email" />
  65. <ScalarProperty Name="Login" ColumnName="Login" />
  66. <ScalarProperty Name="Password" ColumnName="Password" />
  67. </MappingFragment>
  68. </EntityTypeMapping>
  69. </EntitySetMapping>
  70. <EntitySetMapping Name="PasportDetails">
  71. <EntityTypeMapping TypeName="gr606_sosanModel.PasportDetails">
  72. <MappingFragment StoreEntitySet="PasportDetails">
  73. <ScalarProperty Name="IdDetail" ColumnName="IdDetail" />
  74. <ScalarProperty Name="Number" ColumnName="Number" />
  75. <ScalarProperty Name="Series" ColumnName="Series" />
  76. <ScalarProperty Name="IssuedBy" ColumnName="IssuedBy" />
  77. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  78. </MappingFragment>
  79. </EntityTypeMapping>
  80. </EntitySetMapping>
  81. <EntitySetMapping Name="Payment">
  82. <EntityTypeMapping TypeName="gr606_sosanModel.Payment">
  83. <MappingFragment StoreEntitySet="Payment">
  84. <ScalarProperty Name="IdPay" ColumnName="IdPay" />
  85. <ScalarProperty Name="HistoryAboutPayment" ColumnName="HistoryAboutPayment" />
  86. </MappingFragment>
  87. </EntityTypeMapping>
  88. </EntitySetMapping>
  89. <EntitySetMapping Name="Product">
  90. <EntityTypeMapping TypeName="gr606_sosanModel.Product">
  91. <MappingFragment StoreEntitySet="Product">
  92. <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
  93. <ScalarProperty Name="Name" ColumnName="Name" />
  94. <ScalarProperty Name="Manufacture" ColumnName="Manufacture" />
  95. <ScalarProperty Name="ProductGroup" ColumnName="ProductGroup" />
  96. <ScalarProperty Name="Cost" ColumnName="Cost" />
  97. <ScalarProperty Name="TypeOfProduct" ColumnName="TypeOfProduct" />
  98. <ScalarProperty Name="Bardcode" ColumnName="Bardcode" />
  99. <ScalarProperty Name="Margin" ColumnName="Margin" />
  100. <ScalarProperty Name="Quantity" ColumnName="Quantity" />
  101. <ScalarProperty Name="Discount" ColumnName="Discount" />
  102. <ScalarProperty Name="Unit" ColumnName="Unit" />
  103. <ScalarProperty Name="VAT" ColumnName="VAT" />
  104. </MappingFragment>
  105. </EntityTypeMapping>
  106. </EntitySetMapping>
  107. <EntitySetMapping Name="Revenue">
  108. <EntityTypeMapping TypeName="gr606_sosanModel.Revenue">
  109. <MappingFragment StoreEntitySet="Revenue">
  110. <ScalarProperty Name="IdRevenue" ColumnName="IdRevenue" />
  111. <ScalarProperty Name="SumRevenue" ColumnName="SumRevenue" />
  112. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  113. </MappingFragment>
  114. </EntityTypeMapping>
  115. </EntitySetMapping>
  116. <EntitySetMapping Name="SuppliersProduct">
  117. <EntityTypeMapping TypeName="gr606_sosanModel.SuppliersProduct">
  118. <MappingFragment StoreEntitySet="SuppliersProduct">
  119. <ScalarProperty Name="IdSupplier" ColumnName="IdSupplier" />
  120. <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
  121. <ScalarProperty Name="IdSupply" ColumnName="IdSupply" />
  122. </MappingFragment>
  123. </EntityTypeMapping>
  124. </EntitySetMapping>
  125. <EntitySetMapping Name="SupplyProduct">
  126. <EntityTypeMapping TypeName="gr606_sosanModel.SupplyProduct">
  127. <MappingFragment StoreEntitySet="SupplyProduct">
  128. <ScalarProperty Name="IdSupply" ColumnName="IdSupply" />
  129. <ScalarProperty Name="QuantityDeliveredProduct" ColumnName="QuantityDeliveredProduct" />
  130. <ScalarProperty Name="CostDeliveredProduct" ColumnName="CostDeliveredProduct" />
  131. <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
  132. </MappingFragment>
  133. </EntityTypeMapping>
  134. </EntitySetMapping>
  135. <EntitySetMapping Name="SurrenderOfMoney">
  136. <EntityTypeMapping TypeName="gr606_sosanModel.SurrenderOfMoney">
  137. <MappingFragment StoreEntitySet="SurrenderOfMoney">
  138. <ScalarProperty Name="IdSurrender" ColumnName="IdSurrender" />
  139. <ScalarProperty Name="Sum" ColumnName="Sum" />
  140. <ScalarProperty Name="NumberOfChecks" ColumnName="NumberOfChecks" />
  141. </MappingFragment>
  142. </EntityTypeMapping>
  143. </EntitySetMapping>
  144. <EntitySetMapping Name="WorkingShift">
  145. <EntityTypeMapping TypeName="gr606_sosanModel.WorkingShift">
  146. <MappingFragment StoreEntitySet="WorkingShift">
  147. <ScalarProperty Name="IdShift" ColumnName="IdShift" />
  148. <ScalarProperty Name="NameShift" ColumnName="NameShift" />
  149. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  150. </MappingFragment>
  151. </EntityTypeMapping>
  152. </EntitySetMapping>
  153. </EntityContainerMapping>
  154. </Mapping>