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