當(dāng)from中有多個(gè)表時(shí),而select 中只需要一個(gè)表中的所有數(shù)據(jù),不必像sql一樣用*,只要把類名寫(xiě)出來(lái)就行,摸索出來(lái)的經(jīng)驗(yàn),記下,希望對(duì)大家有幫助.

見(jiàn)下面查詢,特別是加紅部分.

?????? [DataObjectMethod(DataObjectMethodType.Select)]
??????? public static ZjcXueshenghuojiang[] List(int xuenian, int xueqi,long banjiId,long banjiStudentId)
??????? {
??????????? //BaseBanjiStudent stu = new BaseBanjiStudent();
??????????? //stu.BanjiStudentid

??????????? string strHql = @"Select huojiang from ZjcXueshenghuojiang huojiang , BaseBanjiStudent stu ";
??????????? strHql += " where huojiang.Xuenian = :xuenian and huojiang.Xueqi = :xueqi ";
??????????? strHql += " and? huojiang.BanjiStudentId = stu.BanjiStudentid? and stu.BaseBanji.Banjiid = :banjiId ";
??????????? //??? strHql += " order by huojiang.StartDate DESC ";
??????????? SimpleQuery query = new SimpleQuery(
??????????????? typeof(ZjcXueshenghuojiang), strHql);
??????????? query.SetParameter("xuenian", xuenian);
??????????? query.SetParameter("xueqi", xueqi);
??????????? query.SetParameter("banjiId", banjiId);
??????????? return (ZjcXueshenghuojiang[])ExecuteQuery(query);
??????? }

轉(zhuǎn)載于:https://www.cnblogs.com/shiningrise/archive/2008/01/14/1037526.html

總結(jié)

以上是生活随笔為你收集整理的ActiveRecord多表查询的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。