A recognition error occurred. near line 1, column 10

小渣渣

A recognition error occurred. near line 1, column 10

1. Guid guid=(request.HttpContext.Session["User"] as XXXX.Model.User).ID;
   
2.                     string sql = "SELECT ID,[Type],[Name],[Describe],[CreateTime],[_COUNT] FROM (SELECT ROW_NUMBER() OVER(Order by G.CreateTime DESC) AS RowNumber,G.ID,G.[Type],G.Name,G.Describe,G.CreateTime,COUNT(I.ID) AS _COUNT FROM a_Group G LEFT JOIN a_GroupInfo I ON G.ID=I.GROUP_ID WHERE G.[Status]=1 AND (I.[Status]=1 OR I.[Status] IS NULL) AND G.USER_GUID=:userid GROUP BY G.ID,G.[Type],G.Name,G.Describe,G.CreateTime) TEMP WHERE  RowNumber BETWEEN 1 AND 5";
   
3.                     

复制代码

原来：

1. var list = _session.CreateQuery(sql).SetGuid("userid", guid).List();

复制代码

改成：

1. var list = _session.CreateSQLQuery(sql).SetGuid("userid", guid).List();

复制代码

success！