“我记录”开发框架(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(); } }
变量使用后就会释放,变量名可以重复
新闻热点
疑难解答