USE [iMES] GO SET IDENTITY_INSERT [dbo].[Sys_TableInfo] ON INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (2, N'角色管理', N'角色管理', NULL, NULL, NULL, NULL, NULL, 0, N'RoleName', N'System', N'iMES.System', NULL, 8, NULL, NULL, N'Sys_Role', N'Sys_Role', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (3, N'字典数据', N'字典数据', NULL, NULL, N'字典明细', N'Sys_DictionaryList', NULL, 0, N'DicName', N'System', N'iMES.System', NULL, 11, NULL, NULL, N'Sys_Dictionary', N'Sys_Dictionary', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (4, N'字典明细', N'字典明细', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'System', N'iMES.System', NULL, 11, NULL, NULL, N'Sys_DictionaryList', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (5, N'系统日志', N'系统日志', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'System', N'iMES.System', NULL, 10, NULL, NULL, N'Sys_Log', N'Sys_Log', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (6, NULL, N'用户管理', NULL, NULL, NULL, NULL, NULL, 0, N'UserName', N'System', N'iMES.System', NULL, 8, NULL, N'', N'Sys_User', N'Sys_User', N'HeadImageUrl', 1) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (8, N'用户基础信息', N'用户基础信息', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'System', N'iMES.System', 200, 0, NULL, NULL, N'无', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (10, N'日志管理', N'日志管理', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'System', N'iMES.System', NULL, 0, NULL, N'170', N'日志管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (11, N'配置管理', N'配置管理', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'System', N'iMES.System', NULL, 0, NULL, N'250', N'配置管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (15, N'成交均价', N'自动绑定下拉框', NULL, NULL, NULL, NULL, NULL, 0, N'AvgPrice', N'App', N'iMES.AppManager', NULL, 79, NULL, NULL, N'App_TransactionAvgPrice', N'App_TransactionAvgPrice', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (16, NULL, N'自定义实现一对多', NULL, NULL, NULL, NULL, NULL, 0, N'Price', N'App', N'iMES.AppManager', NULL, 79, NULL, NULL, N'App_ReportPrice', N'App_ReportPrice', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (19, NULL, N'导入导出', NULL, NULL, NULL, NULL, NULL, 0, N'PhoneNo', N'App', N'iMES.AppManager', NULL, 79, NULL, NULL, N'App_Transaction', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (20, NULL, N'启用图片支持', NULL, NULL, NULL, NULL, NULL, 0, N'ExpertName', N'App', N'iMES.AppManager', NULL, 79, NULL, NULL, N'App_Expert', N'App_Expert', N'HeadImageUrl', 1) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (27, N' 资讯', N'静态页面发布', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'News', N'iMES.AppManager', NULL, 0, NULL, NULL, N' 资讯', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (28, NULL, N'新闻列表', NULL, NULL, NULL, NULL, NULL, 0, N'Title', N'News', N'iMES.AppManager', NULL, 27, N'Content', N'CreateDate', N'App_News', N'App_News', N'ImageUrl', 3) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (76, N'订单管理', N'测试完整示例', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'订单管理', N'iMES.Order', NULL, 0, NULL, NULL, N'订单管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (77, N'销售订单', N'销售订单', NULL, NULL, N'订单明细', N'SellOrderList', NULL, 0, N'TranNo', N'Sell', N'iMES.Order', NULL, 76, NULL, N'CreateDate', N'SellOrder', N'SellOrder', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (78, N'订单明细', N'订单明细', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'Order', N'iMES.Order', NULL, 76, NULL, N'CreateDate', N'SellOrderList', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (79, N'Table 单表数据', N'Table+单表数据', NULL, NULL, NULL, NULL, NULL, 0, NULL, N'Order', N'iMES.Order', NULL, 0, NULL, NULL, N'Table+单表数据', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (80, N'基础表单查询', N'基础表单+编辑只读', NULL, NULL, NULL, NULL, NULL, 0, N'Name', N'Appointment', N'iMES.Order', NULL, 79, NULL, N'CreateDate', N'App_Appointment', N'App_Appointment', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (81, N'表单设计', N'表单设计', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'form', N'iMES.System', NULL, 0, NULL, NULL, N'0', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (82, N'表单设计', N'表单设计', NULL, NULL, NULL, NULL, NULL, 1, N'Title', N'form', N'iMES.System', NULL, 81, NULL, N'CreateDate', N'FormDesignOptions', N'FormDesignOptions', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (83, N'数据采集', N'数据采集', NULL, NULL, NULL, N'', NULL, 1, NULL, N'form', N'iMES.System', NULL, 81, NULL, N'CreateDate', N'FormCollectionObject', N'FormCollectionObject', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (84, N'自定义配置', N'自定义配置', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 0, NULL, NULL, N'自定义配置', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (85, N'用户扩展', N'用户扩展', NULL, NULL, NULL, NULL, NULL, 1, N'FieldValue', N'Custom', N'iMES.Custom', NULL, 84, NULL, N'CreateDate', N'Sys_User_ExtendData', N'Sys_User_ExtendData', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (86, N'实体扩展', N'实体扩展字段', NULL, NULL, NULL, NULL, NULL, 1, N'FieldName', N'Custom', N'iMES.Custom', NULL, 84, NULL, NULL, N'Sys_Table_Extend', N'Sys_Table_Extend', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (87, N'部门管理', N'部门管理', NULL, NULL, NULL, NULL, NULL, 1, N'DeptName', N'./', N'iMES.System', NULL, 8, NULL, N'CreateDate', N'Sys_Dept', N'Sys_Dept', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (88, N'基础数据', N'基础数据', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 0, NULL, NULL, N'基础数据', N'基础数据', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (89, N'单位表', N'单位管理', NULL, NULL, NULL, NULL, NULL, 1, N'UnitName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Sys_Unit', N'Sys_Unit', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (90, N'不良品项', N'不良品项', NULL, NULL, NULL, NULL, NULL, 1, N'DefectItemName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_DefectItem', N'Base_DefectItem', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (91, N'工序', N'工序', NULL, NULL, N'工序采集数据', N'Base_ProcessList', NULL, 1, N'ProcessName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_Process', N'Base_Process', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (92, N'工序采集数据', N'工序采集数据', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 88, NULL, NULL, N'Base_ProcessList', N'Base_ProcessList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (94, N'自定义编号规则', N'自定义编号规则', NULL, NULL, NULL, NULL, NULL, 1, N'GenerativeRule', N'Custom', N'iMES.Custom', NULL, 84, NULL, N'CreateDate', N'Base_NumberRule', N'Base_NumberRule', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (95, N'工艺路线', N'工艺路线', NULL, NULL, N'工序列表', N'Base_ProcessLineList', NULL, 1, N'ProcessLineName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_ProcessLine', N'Base_ProcessLine', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (96, N'工序列表', N'工艺路线-工序列表', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 88, NULL, N'Sequence', N'Base_ProcessLineList', N'Base_ProcessLineList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (97, N'绩效工资配置', N'绩效工资配置', NULL, NULL, NULL, NULL, NULL, 1, N'UnitPrice', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_MeritPay', N'Base_MeritPay', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (98, N'产品定义', N'产品定义', NULL, NULL, NULL, NULL, NULL, 1, N'ProductName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_Product', N'Base_Product', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (99, N'物料清单', N'物料清单', NULL, NULL, NULL, NULL, NULL, 1, N'PProductCode', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'View_Base_MaterialDetail', N'View_Base_MaterialDetail', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (100, N'物料清单-表', N'物料清单-表', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 88, NULL, NULL, N'Base_MaterialDetail', N'Base_MaterialDetail', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (101, N'库存管理', N'库存管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Warehouse', N'iMES.Warehouse', NULL, 0, NULL, NULL, N'库存管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (102, N'入库单', N'入库单', NULL, NULL, N'入库明细', N'Ware_WareHouseBillList', NULL, 1, N'WareHouseBillCode', N'Warehouse', N'iMES.Warehouse', NULL, 101, NULL, N'CreateDate', N'Ware_WareHouseBill', N'Ware_WareHouseBill', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (103, N'入库单明细', N'入库单明细', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Warehouse', N'iMES.Warehouse', NULL, 101, NULL, NULL, N'Ware_WareHouseBillList', N'Ware_WareHouseBillList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (104, N'出库单', N'出库单明细', NULL, NULL, NULL, NULL, NULL, 1, N'ProductCode', N'Warehouse', N'iMES.Warehouse', NULL, 101, NULL, NULL, N'Ware_OutWareHouseBillList', N'Ware_OutWareHouseBillList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (105, N'出库单', N'出库单', NULL, NULL, N'出库明细', N'Ware_OutWareHouseBillList', NULL, 1, N'OutWareHouseBillCode', N'Warehouse', N'iMES.Warehouse', NULL, 101, NULL, N'CreateDate', N'Ware_OutWareHouseBill', N'Ware_OutWareHouseBill', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (106, N'库存收发明细', N'库存收发明细', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'WareHouse', N'iMES.Warehouse', NULL, 101, NULL, N'CreateDate', N'View_WareInOutDetail', N'View_WareInOutDetail', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (107, N'库存余额', N'库存余额', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'WareHouse', N'iMES.Warehouse', NULL, 101, NULL, N'CreateDate', N'View_StockBalance', N'View_StockBalance', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (108, N'生产管理', N'生产管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Production', N'iMES.Production', NULL, 0, NULL, NULL, N'生产管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (109, N'销售订单-产品明细', N'销售订单-产品明细', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Production', N'iMES.Production', NULL, 108, NULL, NULL, N'Production_SalesOrderList', N'Production_SalesOrderList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (110, N'销售订单', N'销售订单', NULL, NULL, N'销售订单-产品明细', N'Production_SalesOrderList', NULL, 1, N'SalesOrderCode', N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_SalesOrder', N'Production_SalesOrder', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (111, N'生产计划-产品明细', N'生产计划-产品明细', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Production', N'iMES.Production', NULL, 108, NULL, NULL, N'Production_ProductPlanList', N'Production_ProductPlanList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (112, N'生产计划', N'生产计划', NULL, NULL, N'生产计划-产品明细', N'Production_ProductPlanList', NULL, 1, N'ProductPlanCode', N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_ProductPlan', N'Production_ProductPlan', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (113, N'装配工单-产品明细', N'装配工单-产品明细', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Production', N'iMES.Production', NULL, 108, NULL, N'LevelPath', N'Production_AssembleWorkOrderList', N'Production_AssembleWorkOrderList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (114, N'装配工单', N'装配工单', NULL, NULL, N'转配工单-产品明细', N'Production_AssembleWorkOrderList', NULL, 1, N'AssembleWorkOrderCode', N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_AssembleWorkOrder', N'Production_AssembleWorkOrder', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (115, N'工单', N'工单', NULL, NULL, N'生产任务', N'Production_WorkOrderList', NULL, 1, N'WorkOrderCode', N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_WorkOrder', N'Production_WorkOrder', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (116, N'任务', N'任务', NULL, NULL, NULL, NULL, NULL, 1, N'ProcessName', N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_WorkOrderList', N'Production_WorkOrderList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (117, N'模版分类', N'打印模版分类', NULL, NULL, NULL, NULL, NULL, 1, N'CatalogName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_PrintCatalog', N'Base_PrintCatalog', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (118, N'打印模版', N'打印模版', NULL, NULL, N'', NULL, NULL, 1, N'TemplateName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_PrintTemplate', N'Base_PrintTemplate', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (119, N'报工', N'报工', NULL, NULL, N'不良品项', N'Production_ReportWorkOrderList', NULL, 1, N'ProductCode', N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_ReportWorkOrder', N'Production_ReportWorkOrder', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (120, N'报工-不良品项', N'报工-不良品项', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Production', N'iMES.Production', NULL, 108, NULL, N'CreateDate', N'Production_ReportWorkOrderList', N'Production_ReportWorkOrderList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (121, N'产量统计', N'产量统计', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 122, NULL, N'CreateDate', N'View_OutputStatistics', N'View_OutputStatistics', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (122, N'报表', N'报表管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 0, NULL, NULL, N'报表', N'报表管理', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (123, N'审批流程', N'审批流程', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'flow', N'iMES.System', NULL, 0, NULL, NULL, N'审批流程', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (124, N'审批流程', N'审批流程配置', NULL, NULL, N'审批步骤', N'Sys_WorkFlowStep', NULL, 1, N'WorkName', N'flow', N'iMES.System', NULL, 123, NULL, N'CreateDate', N'Sys_WorkFlow', N'Sys_WorkFlow', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (125, N'审批节点', N'审批节点配置', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'flow', N'iMES.System', NULL, 123, NULL, N'CreateDate', N'Sys_WorkFlowStep', N'Sys_WorkFlowStep', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (126, N'审批流程', N'审批流程', NULL, NULL, N'审批节点', N'Sys_WorkFlowTableStep', NULL, 1, N'', N'flow', N'iMES.System', NULL, 123, NULL, N'CreateDate', N'Sys_WorkFlowTable', N'Sys_WorkFlowTable', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (127, N'审批节点', N'审批节点', NULL, NULL, NULL, NULL, NULL, 1, N'', N'flow', N'iMES.System', NULL, 123, NULL, N'CreateDate', N'Sys_WorkFlowTableStep', N'Sys_WorkFlowTableStep', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (128, N'员工绩效', N'员工绩效', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 122, NULL, N'CreateDate', N'View_EmployeePerformance', N'View_EmployeePerformance', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (130, N'工资报表', N'工资报表', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 122, NULL, N'ReportDate', N'View_SalaryReport', N'View_SalaryReport', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (131, N'不良品项分布', N'不良品项分布', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 122, NULL, N'CreateDate', N'View_DefectItemDistribute', N'View_DefectItemDistribute', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (132, N'不良品项汇总', N'不良品项汇总', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 122, NULL, N'StartDate', N'View_DefectItemSummary', N'View_DefectItemSummary', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (133, N'生产报表', N'生产报表', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Report', N'iMES.Report', NULL, 122, NULL, N'PlanStartDate', N'View_ProductionReport', N'View_ProductionReport', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (134, N'通知管理', N'通知管理', NULL, NULL, NULL, NULL, NULL, 1, N'NoticeTitle', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_Notice', N'Base_Notice', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (135, N'产品定义扩展', N'产品定义扩展', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 84, NULL, NULL, N'Base_Product_ExtendData', N'Base_Product_ExtendData', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (136, N'工序扩展', N'工序扩展', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 84, NULL, NULL, N'Base_Process_ExtendData', N'Base_Process_ExtendData', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (137, N'不良品项扩展', N'不良品项扩展', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 84, NULL, NULL, N'Base_DefectItem_ExtendData', N'Base_DefectItem_ExtendData', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (138, N'物料清单扩展', N'物料清单扩展', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 84, NULL, NULL, N'Base_MaterialDetail_ExtendData', N'Base_MaterialDetail_ExtendData', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (139, N'绩效工资配比扩展', N'绩效工资配比扩展', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Custom', N'iMES.Custom', NULL, 84, NULL, NULL, N'Base_MeritPay_ExtendData', N'Base_MeritPay_ExtendData', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (140, N'定时任务', N'定时任务', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Quartz', N'iMES.System', NULL, 0, NULL, NULL, N'定时任务', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (141, N'执行记录', N'执行记录', NULL, NULL, NULL, NULL, NULL, 1, N'', N'Quartz', N'iMES.System', NULL, 140, NULL, N'CreateDate', N'Sys_QuartzLog', N'Sys_QuartzLog', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (142, N'定时任务', N'定时任务', NULL, NULL, NULL, NULL, NULL, 1, N'TaskName', N'Quartz', N'iMES.System', NULL, 140, NULL, N'CreateDate', N'Sys_QuartzOptions', N'Sys_QuartzOptions', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (143, N'版本发布记录', N'版本发布记录', NULL, NULL, NULL, NULL, NULL, 1, N'Title', N'System', N'iMES.System', NULL, 8, NULL, N'CreateDate', N'Sys_VersionInfo', N'Sys_VersionInfo', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (144, N'设备管理', N'设备管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Equip', N'iMES.Equip', NULL, 0, NULL, NULL, N'设备管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (145, N'设备分类设置', N'设备分类设置', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'DevCatalogName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_DevCatalog', N'Equip_DevCatalog', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (146, N'车间设置', N'车间设置', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'WorkShopName', N'Custom', N'iMES.Custom', NULL, 88, NULL, N'CreateDate', N'Base_WorkShop', N'Base_WorkShop', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (147, N'设备台账', N'设备台账', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'DeviceName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_Device', N'Equip_Device', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (148, N'点检保养项目', N'点检保养项目', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'SpotMaintenanceName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_SpotMaintenance', N'Equip_SpotMaintenance', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (149, N'点检保养计划', N'点检保养计划', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'SpotMaintPlanName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_SpotMaintPlan', N'Equip_SpotMaintPlan', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (150, N'设备清单', N'设备清单', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'DeviceName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_SpotMaintPlanDevice', N'Equip_SpotMaintPlanDevice', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (151, N'点检项目', N'点检项目', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'SpotMaintenanceName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_SpotMaintPlanProject', N'Equip_SpotMaintPlanProject', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (152, N'维修单', N'维修单', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'MaintainPaperName', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_MaintainPaper', N'Equip_MaintainPaper', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (153, N'点检保养工单', N'点检保养工单', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'SpotMaintWorkOrderCode', N'Equip', N'iMES.Equip', NULL, 144, NULL, N'CreateDate', N'Equip_SpotMaintWorkOrder', N'Equip_SpotMaintWorkOrder', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (154, N'排班管理', N'排班管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Calendar', N'iMES.Calendar', NULL, 0, NULL, NULL, N'排班管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (155, N'班组成员', N'班组成员', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_TeamMember', N'Cal_TeamMember', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (156, N'班组', N'班组', N'SysDbContext', NULL, N'班组成员', N'Cal_TeamMember', NULL, 1, N'TeamName', N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_Team', N'Cal_Team', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (157, N'计划班次', N'计划班次', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'PlanShiftName', N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_PlanShift', N'Cal_PlanShift', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (158, N'计划班组', N'计划班组', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'TeamCode', N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_PlanTeam', N'Cal_PlanTeam', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (159, N'排班计划', N'排班计划', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'PlanName', N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_Plan', N'Cal_Plan', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (160, N'班组排班', N'班组排班', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'TheDate', N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_TeamShift', N'Cal_TeamShift', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (161, N'节假日设置', N'节假日设置', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'TheDay', N'Calendar', N'iMES.Calendar', NULL, 154, NULL, N'CreateDate', N'Cal_Holiday', N'Cal_Holiday', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (162, N'工装夹具管理', N'工装夹具管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Tools', N'iMES.Tools', NULL, 0, NULL, NULL, N'工装夹具管理', NULL, NULL, NULL) GO INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (163, N'工装夹具类型', N'工装夹具类型', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'ToolTypeName', N'Tools', N'iMES.Tools', NULL, 162, NULL, N'CreateDate', N'Tools_ToolType', N'Tools_ToolType', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (164, N'工装夹具台账', N'工装夹具台账', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'ToolName', N'Tools', N'iMES.Tools', NULL, 162, NULL, N'CreateDate', N'Tools_Tool', N'Tools_Tool', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (165, N'工具领用明细', N'工具领用明细', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'', N'Tools', N'iMES.Tools', NULL, 162, NULL, N'CreateDate', N'Tools_ToolsReceiveList', N'Tools_ToolsReceiveList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (166, N'工具领用', N'工具领用', N'SysDbContext', NULL, N'工具领用明细', N'Tools_ToolsReceiveList', NULL, 1, N'ToolsReceiveCode', N'Tools', N'iMES.Tools', NULL, 162, NULL, N'CreateDate', N'Tools_ToolsReceive', N'Tools_ToolsReceive', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (167, N'工具归还明细', N'工具归还明细', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Tools', N'iMES.Tools', NULL, 162, NULL, N'CreateDate', N'Tools_ToolsReturnList', N'Tools_ToolsReturnList', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (168, N'工具归还', N'工具归还', N'SysDbContext', NULL, N'工具归还明细', N'Tools_ToolsReturnList', NULL, 1, N'ToolsReturnCode', N'Tools', N'iMES.Tools', NULL, 162, NULL, N'CreateDate', N'Tools_ToolsReturn', N'Tools_ToolsReturn', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (169, N'质量管理', N'质量管理', NULL, NULL, NULL, NULL, NULL, 1, NULL, N'Quality', N'iMES.Quality', NULL, 0, NULL, NULL, N'质量管理', NULL, NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (170, N'常见缺陷', N'常见缺陷', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'DefectName', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_Defect', N'Quality_Defect', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (171, N'检测项管理', N'检测项管理', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'TestItemCode', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_TestItem', N'Quality_TestItem', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (172, N'检测模版', N'检测模版', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'TemplateName', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_Template', N'Quality_Template', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (173, N'检测模版-检测项', N'检测模版-检测项', N'SysDbContext', NULL, NULL, NULL, NULL, 1, N'TestItemIdCode', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_TemplateTestItem', N'Quality_TemplateTestItem', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (174, N'检测模版-产品', N'检测模版-产品', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Quality', N'iMES.Quality', NULL, 169, NULL, NULL, N'Quality_TemplateProduct', N'Quality_TemplateProduct', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (175, N'来料检验单-检验项', N'来料检验单-检验项', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Quality', N'iMES.Quality', NULL, 169, NULL, NULL, N'Quality_InComingCheckTestItem', N'Quality_InComingCheckTestItem', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (176, N'来料检验单', N'来料检验单', N'SysDbContext', NULL, N'来料检验单-检验项', N'Quality_InComingCheckTestItem', NULL, 1, N'InComingCheckName', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_InComingCheck', N'Quality_InComingCheck', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (177, N'过程检验单-检验项', N'过程检验单-检验项', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Quality', N'iMES.Quality', NULL, 169, NULL, NULL, N'Quality_ProcessCheckTestItem', N'Quality_ProcessCheckTestItem', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (178, N'过程检验', N'过程检验', N'SysDbContext', NULL, N'过程检验单-检验项', N'Quality_ProcessCheckTestItem', NULL, 1, N'ProcessCheckName', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_ProcessCheck', N'Quality_ProcessCheck', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (179, N'出货检验单-检验项', N'出货检验单-检验项', N'SysDbContext', NULL, NULL, NULL, NULL, 1, NULL, N'Quality', N'iMES.Quality', NULL, 169, NULL, NULL, N'Quality_OutCheckTestItem', N'Quality_OutCheckTestItem', NULL, NULL) INSERT [dbo].[Sys_TableInfo] ([Table_Id], [CnName], [ColumnCNName], [DBServer], [DataTableType], [DetailCnName], [DetailName], [EditorType], [Enable], [ExpressField], [FolderName], [Namespace], [OrderNo], [ParentId], [RichText], [SortName], [TableName], [TableTrueName], [UploadField], [UploadMaxCount]) VALUES (180, N'出货检验单', N'出货检验单', N'SysDbContext', NULL, N'出货检验单-检测项', N'Quality_OutCheckTestItem', NULL, 1, N'OutCheckName', N'Quality', N'iMES.Quality', NULL, 169, NULL, N'CreateDate', N'Quality_OutCheck', N'Quality_OutCheck', NULL, NULL) SET IDENTITY_INSERT [dbo].[Sys_TableInfo] OFF GO