Esempio n. 1
0
        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);
            }
        }