SET IDENTITY_INSERT [dbo].[item] ON INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (1, N'權限', NULL, N'A', NULL, N'權限管理', NULL, 0, 4, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (2, N'使用者登錄', N'~/admin/user/reg.aspx', N'A', N'', N'管理者資料新增', N'', 1, 2, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (3, N'使用者管理', N'~/admin/user/index.aspx', N'A', N'', N'管理者資料查詢、修改、刪除', N'', 1, 3, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (4, N'選項', NULL, N'A', NULL, N'選項管理', NULL, 0, 1, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (5, N'選項登錄', N'~/admin/item/index.aspx', N'A', NULL, N'選項資料新增', NULL, 4, 5, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (7, N'選項排序', N'~/admin/item/range.aspx', N'A', NULL, N'設定主選項及次選項的排序', NULL, 4, 36, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (8, N'群組登錄', N'~/admin/user/group_reg.aspx', N'A', NULL, N'登錄群組及權限設定', NULL, 1, 5, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (9, N'群組資料', N'~/admin/user/group_show.aspx', N'A', N'', N'群組資料管理', N'', 1, 4, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (10, N'後台設定', N'~/admin/item/setting.aspx', N'A', NULL, N'設定編輯器圖片路徑、公司信箱、公司名稱…相關設定', NULL, 4, 37, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (11, N'變更管理密碼', N'~/admin/user/pass_edit.aspx', N'A', NULL, N'變更登錄後端之密碼', NULL, 1, 74, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (12, N'操作記錄查詢', N'~/admin/user/log.aspx', N'A', N'', N'', N'', 1, 123, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (20, N'公告', N'', N'A', N'', N'', N'', 0, 6, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (21, N'公告管理', N'~/admin/news/index.aspx', N'A', N'', N'', N'', 20, 126, N'~/admin/news/news_reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (22, N'公告分類管理', N'~/admin/news/kind_reg.aspx', N'A', N'', N'', N'', 20, 125, N'~/admin/news/range.aspx,~/admin/news/range2.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (23, N'人事', N'', N'A', N'', N'', N'', 0, 5, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (24, N'人員組別管理', N'~/admin/hr/kind_reg.aspx', N'A', N'', N'', N'', 23, 129, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (25, N'職稱管理', N'~/admin/hr/title_reg.aspx', N'A', N'', N'', N'', 23, 130, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (26, N'人員管理', N'~/admin/hr/index.aspx', N'A', N'', N'', N'', 23, 131, N'~/admin/hr/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (27, N'考勤', N'~/admin/hr/index2.aspx', N'A', N'', N'', N'', 23, 132, N'~/admin/hr/attendances.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (28, N'信眾', N'', N'A', N'', N'', N'', 0, 2, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (29, N'信眾資料', N'~/admin/follower/index.aspx', N'A', N'', N'', N'', 28, 134, N'~/admin/follower/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (30, N'公告檢視', N'~/admin/news/list.aspx', N'A', N'', N'', N'', 20, 134, N'~/admin/news/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (31, N'活動', N'', N'A', N'', N'', N'', 0, 7, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (34, N'活動詳細分類', N'~/admin/activity/kind_reg.aspx', N'A', N'', N'', N'', 31, 139, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (35, N'活動管理', N'~/admin/activity/index.aspx', N'A', N'', N'', N'', 31, 140, N'~/admin/activity/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (36, N'基本資料', N'', N'A', N'', N'', N'', 0, 10, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (37, N'套表列印設定', N'~/admin/files/index.aspx', N'A', N'', N'', N'', 36, 141, N'~/admin/files/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (38, N'報名', N'~/admin/order/index.aspx', N'A', N'', N'', N'', 0, 8, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (39, N'報名管理', N'~/admin/order/index.aspx', N'A', N'', N'', N'', 38, 143, N'~/admin/order/reg.aspx,~/admin/order/bed_reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (40, N'庫存', N'', N'A', N'', N'', N'', 0, 11, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (41, N'倉庫資料維護', N'~/admin/stock/kind_reg.aspx', N'A', N'', N'', N'', 40, 145, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (42, N'庫存管理', N'~/admin/stock/index.aspx', N'A', N'', N'', N'', 40, 147, N'~/admin/stock/news_reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (43, N'帳務', N'', N'A', N'', N'', N'', 0, 9, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (44, N'收支項目維護', N'~/admin/accounting/kind_reg.aspx', N'A', N'', N'', N'', 43, 148, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (45, N'收支帳戶維護', N'~/admin/accounting/kind_reg2.aspx', N'A', N'', N'', N'', 43, 149, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (46, N'專案', N'', N'A', N'', N'', N'', 0, 3, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (47, N'類別管理', N'~/admin/project/kind_reg.aspx', N'A', N'', N'', N'', 46, 151, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (48, N'收支管理', N'~/admin/accounting/index.aspx', N'A', N'', N'', N'', 43, 152, N'~/admin/accounting/news_reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (49, N'專案管理', N'~/admin/project/index.aspx', N'A', N'', N'', N'', 46, 153, N'~/admin/project/news_reg.aspx,~/admin/project/update.aspx,~/admin/project/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (50, N'贊助報告', N'~/admin/project/list.aspx', N'A', N'', N'', N'', 46, 154, N'~/admin/project/news_reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (51, N'品項分類管理', N'~/admin/activity/itemKind.aspx', N'A', N'', N'', N'', 36, 142, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (52, N'品項管理', N'~/admin/activity/index2.aspx', N'A', N'', N'', N'', 36, 143, N'~/admin/activity/item_reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (53, N'人員匯入', N'~/admin/hr/import.aspx', N'A', N'', N'', N'', 23, 128, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (54, N'信眾匯入', N'~/admin/follower/import.aspx', N'A', N'', N'', N'', 28, 133, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (55, N'掛單', N'', N'A', N'', N'', N'', 0, 13, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (56, N'房間管理', N'~/admin/bed/kind_reg.aspx', N'A', N'', N'', N'', 55, 160, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (57, N'報到名單​', N'~/admin/order/index2.aspx', N'A', N'', N'', N'', 38, 161, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (58, N'活動主類型', N'~/admin/activity/kind_reg2.aspx', N'A', N'', N'', N'', 31, 138, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (59, N'供應商', N'', N'A', N'', N'', N'', 0, 12, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (60, N'供應商分類管理', N'~/admin/supplier/kind_reg.aspx', N'A', N'', N'', N'', 59, 164, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (61, N'供應商管理', N'~/admin/supplier/index.aspx', N'A', N'', N'', N'', 59, 163, N'~/admin/supplier/reg.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (62, N'庫存異動原因', N'~/admin/stock/reason_reg.aspx', N'A', N'', N'', N'', 40, 146, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (63, N'牌位查詢列印', N'~/admin/printpw/yulan.aspx', N'A', N'', N'各活動的牌位查詢列印', N'', 31, 160, N'~/admin/printpw/index.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (64, N'疏文查詢', N'~/admin/shuwen/shuwen.aspx', N'A', N'', N'', N'', 38, 165, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (65, N'入帳沖帳', N'', N'A', N'', N'', N'', 0, 11, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (66, N'登錄匯款資料', N'~/admin/transfer/register.aspx', N'B', N'', N'', N'', 65, 167, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (67, N'出納:核對匯款人', N'~/admin/transfer/verify1.aspx', N'A', N'', N'', N'', 65, 168, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (68, N'出納:核對金額', N'~/admin/transfer/verify2.aspx', N'A', N'', N'', N'', 65, 169, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (69, N'個人-沖帳流程', N'~/admin/transfer/personal_reconcile.aspx', N'A', N'', N'', N'', 65, 170, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (70, N'共同-沖帳流程', N'~/admin/transfer/group_reconcile.aspx', N'A', N'', N'', N'', 65, 171, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (71, N'餘額核銷', N'~/admin/transfer/balance_reconcile.aspx', N'A', N'', N'', N'', 65, 173, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (72, N'餘額核銷查詢', N'~/admin/transfer/balance_reconcile_query.aspx', N'A', N'', N'', N'', 65, 174, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (73, N'沖帳查詢', N'~/admin/transfer/verify_order_record_query.aspx', N'A', N'', N'', N'', 65, 172, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (74, N'匯款/沖帳管理', N'~/admin/transfer/index.aspx', N'A', N'', N'', N'', 65, 166, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (75, N'掛單統計', N'~/admin/guadan/statistics.aspx', N'A', NULL, NULL, NULL, 55, 173, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (76, N'掛單時間參數設置', N'~/admin/guadan/guadantime/timeindex.aspx', N'A', NULL, NULL, N'', 55, 174, N'~/admin/guadan/guadantime/timeset.aspx,~/admin/guadan/guadantime/edit.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (77, N'掛單統計報表', N'~/admin/guadan/statistics_table.aspx', N'A', NULL, NULL, NULL, 55, 173, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (78, N'掛單蓮友', N'~/admin/guadan/guest/index.aspx', N'A', NULL, NULL, NULL, 55, 171, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (79, N'客房管理', N'~/admin/region/bed/index.aspx', N'A', NULL, NULL, NULL, 55, 168, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (80, N'床位和掛單狀態管理', N'~/admin/region/bed/bedstatus/index.aspx', N'A', NULL, NULL, NULL, 65, 169, N'~/admin/region/bed/bedstatus/create.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (81, N'掛單資料', N'~/admin/guadan/index.aspx', N'A', NULL, NULL, NULL, 55, 170, N'~/admin/guadan/view.aspx,~/admin/guadan/update.aspx', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (82, N'新建掛單', N'~/admin/guadan/create.aspx', N'A', NULL, NULL, NULL, 55, 169, NULL, NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (83, N'報名統計-1', N'~/admin/pivot/pivot-01.aspx', N'A', N'', N'', N'', 38, 175, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (84, N'報名統計-2', N'~/admin/pivot/query.aspx', N'A', N'', N'', N'', 38, 176, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (85, N'區域管理', N'', N'A', N'', N'', N'', 0, 177, N'', NULL) INSERT [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (86, N'區域資料', N'~/admin/region/index.aspx', N'A', N'', N'', N'', 85, 178, N'~/admin/region/handle_bed_in_used.aspx', NULL) SET IDENTITY_INSERT [dbo].[item] OFF GO