Wojilu学习笔记 (01)

~/{controller}/{id};requirements:{id=int}

public void Show(int id)
        {
           

        }

public void Show(int id)
      {
          set("siteleft", qjw.Web.siteleft());

          using (MAction action = new MAction(TableNames.zt_article))
          {
              int page = ctx.route.page;
              int rowcount = 0;
              int pagesize = 10;
              MDataTable table = action.Select(page, pagesize, "IsDel=0 and classid="+ id +" order by posttime desc", out rowcount);
              //MDataTable table = action.Select("IsDel=0 order by posttime desc");

              IBlock block = getBlock("Article");
              foreach (MDataRow row in table.Rows)
              {
                  block.Set("article.id", row["id"]);
                  block.Set("article.title", row["title"]);
                  block.Next();
              }

              //生成分页条
              int recordCount = rowcount;
              int pageSize = pagesize;
              int currentPage = ctx.route.page;
              wojilu.PageHelper op = new wojilu.PageHelper(recordCount, pageSize, currentPage);
              set("page", op.PageBar);

          }

      }

using (MAction action = new MAction(TableNames.zt_class))
            {
                if (action.Fill(id))
                {
                    set("ztclass.id", action.Get<string>(zt_class.ID));
                    set("ztclass.classname", action.Get<string>(zt_class.ClassName));
                    set("ztclass.content", action.Get<string>(zt_class.Content));
                }
            }

using (MAction action = new MAction(TableNames.zt_class))
            {
                MDataTable table = action.Select("IsDel=0 and FatherId=0 and IsNav=1 and SystemId=1 and id>1 order by orderflag asc ");
                
                IBlock cblock = getBlock("Nav");

                foreach (MDataRow row in table.Rows)
                {
                    cblock.Set("ztclass.id", row["id"]);
                    cblock.Set("ztclass.classname", row["classname"]);
                    cblock.Set("ztclass.url", row["url"]);
                    cblock.Next();
                }
            }