臨時數(shù)據(jù)
窗口選擇數(shù)據(jù)規(guī)范可以用來顯示臨時數(shù)據(jù)，比如數(shù)據(jù)透視表的原數(shù)據(jù)。還有比如“數(shù)據(jù)管理模塊”中顯示前100條數(shù)據(jù)我們就使用了這種功能。
在任何需要顯示臨時數(shù)據(jù)的場景我們都可以考慮使用此數(shù)據(jù)規(guī)范。
使用此數(shù)據(jù)規(guī)范有兩種方式，一種就是通過數(shù)據(jù)規(guī)范，另外一種就是通過代碼。
我們先來看看在數(shù)據(jù)規(guī)范里面如何設(shè)置。
代碼
直接顯示指定的DataTableHelp中的數(shù)據(jù)。
| C# |
sanMuSoft.Data.Database db = Proj.SysDataFactory["DBMain"]; string strSQL = "select * from tableName"; FormSelectClient frmSelect = new FormSelectClient(); frmSelect.DataTableHelp = db.ExecuteDataTableHelp(strSQL); frmSelect.SelectModel = SelectModelEnum.ViewOnly; frmSelect.Editable = false; frmSelect.IsSystemForm = false; SelectForm frm = new SelectForm("frmSQLPreview", CurrentNodeText + "_預(yù)覽", null, frmSelect); frm.ShowDialog(); |
| VB.Net |
Dim db As sanMuSoft.Data.Database = Proj.SysDataFactory("DBMain") Dim strSQL As String = "select * from tableName" Dim frmSelect As FormSelectClient = New FormSelectClient() frmSelect.DataTableHelp = db.ExecuteDataTableHelp(strSQL) frmSelect.SelectModel = SelectModelEnum.ViewOnly frmSelect.Editable = False frmSelect.IsSystemForm = < /FONT > False Dim frm As SelectForm = New SelectForm("frmSQLPreview", CurrentNodeText & "_預(yù)覽", Nothing, frmSelect) frm.ShowDialog() |
根據(jù)RuleID來顯示數(shù)據(jù)。如果我們已經(jīng)通過數(shù)據(jù)規(guī)范設(shè)置了一個窗口選擇規(guī)范，然后想直接用代碼調(diào)用時，可以直接通過下面的代碼來調(diào)用。
| C# |
FormSelectClient frmSelect = new FormSelectClient("d2772b7ca74b43658ec913499d1bd9fb"); SelectForm frm = new SelectForm("frmSQLPreview", CurrentNodeText + "_預(yù)覽", null, frmSelect); frm.ShowDialog(); |
| VB.Net |
Dim frmSelect As FormSelectClient = New FormSelectClient("d2772b7ca74b43658ec913499d1bd9fb") Dim frm As SelectForm = New SelectForm("frmSQLPreview", CurrentNodeText & "_預(yù)覽", Nothing, frmSelect) frm.ShowDialog() |