protected override void ReadTableData() { Database database = LogicContext.GetDatabase(); HSQL sql = new HSQL(database); sql.Add("SELECT MEPAGE_MDID AS MDID,MEPAGE_COMID AS COMID,WFD_WFBID AS WFBID,WFD_WFID AS WFID,MEPAGE_URL AS PAGEURL,MEPAGE_TYPE"); sql.Add("FROM MEPAGE"); sql.Add("LEFT JOIN MODULE ON MODULE_MDID = MEPAGE_MDID"); sql.Add("LEFT JOIN WFD ON WFD_WFBID = MEPAGE_WFBID"); sql.Add("WHERE MEPAGE_COMID = MODULE_COMID"); sql.Add("ORDER BY MDID"); DataSet dataSet = database.OpenDataSet(sql); bool flag = dataSet.Tables.Count <= 0; if (!flag) { this.dtMePage = dataSet.Tables[0]; MePageCache.BuildMePageUrl(this.dtMePage); this.dvMePageBy_MdId = new DataView(this.dtMePage, "", "MDID", DataViewRowState.CurrentRows); this.dvMePageBy_MdId_WfbId = new DataView(this.dtMePage, "", "MDID,WFID", DataViewRowState.CurrentRows); } }