string hql = "FROM Hymimi.Blog.Article as Article";
hql += " WHERE Article.Category.CategoryID=" + this.categoryID;
hql += " ORDER BY Article.ArticleID ASC";
IQuery query = session.CreateQuery(hql);
query.SetMaxResults(this.maxResult);
query.SetFirstResult(this.maxResult * this.currentPageNum);
IList list = query.List();
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2005 sp2 U (http://www.altova.com) by any (Ru-Board) -->
<n:hibernate-mapping xmlns:n="urn:nhibernate-mapping-2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:nhibernate-mapping-2.0
..\nhibernate-mapping-2.0.xsd">
<n:class name="Hymimi.Blog.Article,Hymimi" table="article">
<n:id name="ArticleID" column="id" type="Int32">
<n:generator class="identity"/>
</n:id>
<n:many-to-one name="Channel" column="channel_id" class="Hymimi.Blog.Channel,Hymimi"/>
<n:many-to-one name="Category" column="category_id" class="Hymimi.Blog.Category,Hymimi"/>
<n:property name="Title" column="title" type="String"/>
<n:property name="SubHeading" column="subheading" type="String"/>
<n:property name="Body" column="body" type="StringClob"/>
<n:property name="CreateTime" column="create_time" type="DateTime"/>
<n:property name="UpdateTime" column="update_time" type="DateTime"/>
</n:class>
</n:hibernate-mapping>
hql += " WHERE Article.Category.CategoryID=" + this.categoryID;
hql += " ORDER BY Article.ArticleID ASC";
IQuery query = session.CreateQuery(hql);
query.SetMaxResults(this.maxResult);
query.SetFirstResult(this.maxResult * this.currentPageNum);
IList list = query.List();
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2005 sp2 U (http://www.altova.com) by any (Ru-Board) -->
<n:hibernate-mapping xmlns:n="urn:nhibernate-mapping-2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:nhibernate-mapping-2.0
..\nhibernate-mapping-2.0.xsd">
<n:class name="Hymimi.Blog.Article,Hymimi" table="article">
<n:id name="ArticleID" column="id" type="Int32">
<n:generator class="identity"/>
</n:id>
<n:many-to-one name="Channel" column="channel_id" class="Hymimi.Blog.Channel,Hymimi"/>
<n:many-to-one name="Category" column="category_id" class="Hymimi.Blog.Category,Hymimi"/>
<n:property name="Title" column="title" type="String"/>
<n:property name="SubHeading" column="subheading" type="String"/>
<n:property name="Body" column="body" type="StringClob"/>
<n:property name="CreateTime" column="create_time" type="DateTime"/>
<n:property name="UpdateTime" column="update_time" type="DateTime"/>
</n:class>
</n:hibernate-mapping>
解决方案 »
- C#如何在打印机服务器属性中添加自定义纸?
- 请教,如何手动设置从System.Attribute派生类?
- vs2005打包winform程序时如何添加序列号验证
- 请问怎么从这样的xml文件里取到字符串
- 如何在c#中改变form运行顺序
- 用ADO.net操作数据库(插入,更改等)代码好象没有问题,但我在打开SQL SERVER2000企业管理器时怎么数据表不随着更新,
- 请问大家有没有设置图象颜色深度的方法呀
- 求:门店收银系统断网的解决方案
- [求指导, 怎样打包字体,客户机器安装程序的时候一起把字体安装]
- 多个groupbox用法
- 有关打印的问题
- 请教在localhost/xxx.aspx运行,能正常显示treeview,但将其设置在internet上,比如219.128.98.7/xxx.aspx就不能正常显示treeview为什么
NHibernate.Expression.Order order = NHibernate.Expression.Order.Asc("ArticleID");
criteria.AddOrder(order);
criteria.SetFirstResult(this.maxResult * this.currentPageNum);
criteria.SetMaxResults(this.maxResult);
IList list = criteria.List();晕,这种方式也不行,五一回来,自己继续给自己up.
唉,CSDN上这方面的资料也很少,贴子也少得可怜.up一下