HQL中in类型的传参

最新推荐文章于 2021-02-20 16:00:38 发布

原创最新推荐文章于 2021-02-20 16:00:38 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#string #query

public IList<Object[]> GetProResultBySubjectId(string subjectList, string planYear, string projectId)
        {
            var query = Session.CreateQuery(@"select u,b.Investment,u.SubjectBlance + b.Investment as xiaoJi from FinSubject u ,ProBaseInfoAnnualPlanDetail b where u.Id=b.AccountingItem and u.Id in(:subjectList) and b.ProBaseInfoProjectInfo=:projectId and b.PlanYear=:planYear and u.IsDelete=0 and b.IsDelete=0 order by u.Id ")
                         .SetParameterList("subjectList",subjectList.Split(','))
                         .SetString("projectId", projectId)
                         .SetString("planYear", planYear);

return query.List<Object[]>();
}