此篇隨筆是2013年根據項目需求開發記錄的,不一定符合大眾口味,只需了解開發思路,畢竟解決方案多種多樣。
下面簡單說說需求點吧:
(1)通過下拉列表可以選擇一個DataSet(數據集),一個DataSet存在可以互相關聯的多個DataTable(數據表格),DataTable數據來源于數據庫視圖;SQL語句關聯比較復雜
(2)一個DataTable(數據表格)存在多個可供選擇查詢顯示的Column(列),支持動態組合
(3)Column(列)同時支持作為查詢條件進行并運算
先看效果吧,免得待會看到太多代碼失去看下去的興趣了:


(1)數據庫方面
1 USE [IMSDB] 2 GO 3 4 drop view View_CustomReport_ItemCategory 5 go 6 drop view View_CustomReport_ItemClassification 7 go 8 9 ---- the view total is 21 10 alter view View_CustomReport_BasicInfo 11 as 12 select iig.holding_id as 'Holding_Id', 13 row_number() over(order by iig.item_group_id) as 'Internal_ID', 14 od.dept_name as 'Holder_Department', 15 og.group_name as 'Holder_Group', 16 os.section_name as 'Holder_Section', 17 ou.unit_name as 'Holder_Unit', 18 iig.brand as 'Brand', 19 iig.model as 'Model', 20 iica.name_en as 'Category', 21 iicaSub.name_en as 'Sub____category', 22 iicl.name_en as 'Classification', 23 iiclSub.name_en as 'Sub____classification', 24 iig.item_desc as 'GF272_Descr
|
新聞熱點
疑難解答