首页 > > 网络编程 > Mysql >

Wojilu学习笔记 (01)

2018-06-17 19:42:39来源：未知阅读 ()

“我记录”开发框架(wojilu framework) 是 .net 平台下的综合开发框架，主要用于 web 方面的快速开发。

官方网址：http://www.wojilu.com
源码托管网址： https://github.com/wojilu/wojilu
授权协议：Apache License，可免费用于商业环境

路由配置

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

默认Controller的Show(int id)方法，此处id直接传入

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);

          }

      }

CyqData数据

单条记录操作

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();
                }
            }