コード例 #1
0
ファイル: left.aspx.cs プロジェクト: hantan2008/LEDCMS
        private void LoadData()
        {
            CMS.DAL.CMS_SysMod dal = new CMS.DAL.CMS_SysMod();

            DataSet relationSet = new DataSet();
            DataTable tmpTable1 = dal.GetList(" Mod_Level = 1 AND mod_isvisible = 1 order By mod_sortnum,ID ASC").Tables[0];
            tmpTable1.TableName = "T_SYS_Mod_Level1";
            DataTable tmpTable2 = dal.GetList(" Mod_Level = 2 AND mod_isvisible = 1 order By mod_sortnum,ID ASC").Tables[0];
            tmpTable2.TableName = "T_SYS_Mod_Level2";
            relationSet.Tables.Add(tmpTable1.Copy());
            relationSet.Tables.Add(tmpTable2.Copy());

            DataRelation Level1Level2Ralation = relationSet.Relations.Add("Level1Level2Ralation", relationSet.Tables["T_SYS_Mod_Level1"].Columns["ID"], relationSet.Tables["T_SYS_Mod_Level2"].Columns["mod_parentid"]);

            this.rptModLevel1.DataSource = relationSet.Tables["T_SYS_Mod_Level1"].DefaultView;
            this.rptModLevel1.DataBind();
        }
コード例 #2
0
ファイル: admin_index.aspx.cs プロジェクト: hantan2008/LEDCMS
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.lblAdminName.Text = "admin";

                CMS.DAL.CMS_SysMod dal = new CMS.DAL.CMS_SysMod();
                DataSet ds = dal.GetList("mod_level=1 and mod_isvisible = 1 order by mod_sortnum");

                this.RepeaterMainMenu.DataSource = ds;
                this.RepeaterMainMenu.DataBind();

                this.RepeaterMainMenu1.DataSource = ds;
                this.RepeaterMainMenu1.DataBind();

                DataSet dsChild = dal.GetList("mod_level=2 and mod_isvisible = 1 order by mod_sortnum");
                this.RepeaterChild.DataSource = dsChild;
                this.RepeaterChild.DataBind();
            }
        }