Nhibernate知识点汇总

1.查询
返回list集合
 public IList<ProjectMilestonePlanVersionKeybProjectSummary> GetListByRProjectIdAndPlanId(Guid rprojectId,
            Guid planVersionId)
        {sql参数   WHERE kv.RProjectID=:RProjectID and s.ProjectMilestonePlanVersionId=:PlanVersionId
         var sqlQuery = CurrentSession.CreateSQLQuery(strSql).AddEntity(typeof(ProjectMilestonePlanVersionKeybProjectSummary))
                .SetParameter("RProjectID", rprojectId, NHibernateUtil.Guid).SetParameter("PlanVersionId", planVersionId, NHibernateUtil.Guid);
           var list = sqlQuery.List<ProjectMilestonePlanVersionKeybProjectSummary>();
   }


  返回升序排序 return lst1.OrderBy(t => t.Bversion).ThenBy(t => int.Parse(t.DisplayOrder)).ToList();
    ThenBy 根据某个键按升序对序列中的元素执行后续排序
   返回降序排序  return sqlQuery.List<VWfMyFlow>().OrderByDescending(t => t.TaskCreationDate).Take(50).ToList();


 返回实体
   public ProjectMilestonePlanVersionBaseLine GetFirstBaseLinePlanVersionOfBVersion（）{
      IQuery sqlQuery = this.CurrentSession.CreateSQLQuery(strSql).AddEntity(typeof(ProjectMilestonePlanVersionBaseLine))
       return sqlQuery.List<ProjectMilestonePlanVersionBaseLine>().FirstOrDefault();
   }
 返回Guid
    public Guid GetLatestStatIdWithoutMonthlyReportByRprojectID（）{
     IQuery sqlQuery = this.CurrentSession.CreateSQLQuery(sbsql.ToString());
            return sqlQuery.List<Guid>().FirstOrDefault();
    }
返回一列
    public IList<string> GetAllBVersion()
        {
            return this.CurrentSession.CreateSQLQuery("select distinct BVersion  from BProject where DeleteFlag=0 order by BVersion").List<string>();
        }
查询记录是否存在
     public bool CheckRoleAndResource(){
        ISQLQuery sqlQuery = this.CurrentSession.CreateSQLQuery(strSql). AddScalar("HRRR_ID", NHibernateUtil.String);
          IList<string> retstr = sqlQuery.List<string>();
            return !(retstr.Count == 0);
     }


根据里程碑计划版本取得上一次里程碑计划基线版本的计入后续累计偏差值
    public int? GetPreviousBaselineNumberFollowAccumulateDeviation（）{
     IQuery query = this.CurrentSession.CreateSQLQuery(strSql).AddScalar("NFAD", NHibernateUtil.Int32);
     return query.UniqueResult<int?>();
    }
    UniqueResult 返回的实例只有一个或者null时用


  返回影响个数
    return ret == null ? 0 : ret.Count;
    
  执行存储过程
      public void CloseProjectTeamPlanByVersionId(Guid teamPlanVersionId)
        {
            string strSql;
            strSql = string.Format(@"exec [Proc_CloseProjectTeamPlanByVersionId] :a ");


            IQuery sqlQuery = this.CurrentSession.CreateSQLQuery(strSql);
            sqlQuery.SetParameter("a", teamPlanVersionId);
            sqlQuery.ExecuteUpdate();
        }
 执行sql转换类型
   public string QueryTaskID(Guid teamPlanWBSID)
        {
            string strSql = @"select count(*) AS Text from TeamTask 
                            where TeamPlanWBSID='" + teamPlanWBSID.ToString() + "' and DeleteFlag=0";


            ISQLQuery sqlQuery = this.CurrentSession.CreateSQLQuery(strSql).
                AddScalar("Text", NHibernateUtil.String);
            return sqlQuery.List<string>().FirstOrDefault();
        }
串联字符串使用指定分隔符
   return string.Join("-", result.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries));

   string.Join("','", lstTaskUniqueId)

是否包含指定键
   !para.ContainsKey("AllUser")
  
判断参数
  paras.ContainsKey(ServiceParams.WF_WORKFLOWINSTANCE_WORKFLOWINSTANCEID)


2.新增
    public int DeleteFaultBaselineByPlanVersionID(Guid planVersionId){
          IQuery sqlQuery = this.CurrentSession.CreateSQLQuery(strSql);
           return sqlQuery.ExecuteUpdate();
    }