First of all, we follow the previous thinking, the first chapter of the T_product to carry out a certain expansion, the following figure:
Here, I added a t_product_category table for storing product classification information, classifying it as a tree structure, and adding a t_warehouse table for storing store letter information, then adding corresponding foreign keys and some extended fields in t_product. With the data table, the corresponding management code (CRUD, UI, etc.) for the classification and warehouse is started, and then called on the product page. In order to save space, this code is not posted here, anyway is a lot of.
In Rapidwebdev, similar to classification, warehouse information, which is not a very large amount of data, can be completely replaced with hierarchydate and Concretedata. Using Rapidwebdev, we only need to keep the T_product table, and then add the product classification and warehouse information configuration information in Sitemap.config, we can achieve the above functions, in the case of simple requirements, even code writing are saved.
<Item Text="业务模块">
<Item Text="产品管理" PageUrl="~/ProductManagement/DynamicPage.svc" Value="Everyone" />
<Item Text="产品分类管理" PageUrl="~/HierarchyDataManagement/DynamicPage.svc?HierarchyType=产品分类" Value="ProductGategoryManagement" />
<Item Text="仓库管理" PageUrl="~/ConcreteDataManagement/DynamicPage.svc?ConcreteDataType=仓库" Value="DepotManagement" />
</Item>
It's better to put up a picture to illustrate the problem, O (∩_∩) o