我的CMS开发记-3 只要是人就会犯错误，只要是软件就会有BUG,即使他是nhibernate

private SqlString FinalizeJoins(SqlString sqlString)
        {
            if (_queryCache.Contains(sqlString))
            {
                return (SqlString) _queryCache[sqlString];
            }
            // fix wxy 
            int beginOfFrom = sqlString.IndexOfCaseInsensitive(" from ");
            int endOfFrom = sqlString.IndexOfCaseInsensitive(" where ");

            if (beginOfFrom < 0)
            {
                return sqlString;
            }

            if (endOfFrom < 0)
            {
                endOfFrom = sqlString.Length;
            }

            string fromClause = sqlString.Substring(beginOfFrom, endOfFrom - beginOfFrom).ToString();

            string transformedFrom = TransformFromClause(fromClause);

            //put it all together again
            SqlStringBuilder final = new SqlStringBuilder(sqlString.Count + 1);
            final.Add(sqlString.Substring(0, beginOfFrom));
            final.Add(transformedFrom);
            final.Add(sqlString.Substring(endOfFrom));

            SqlString ret = final.ToSqlString();
            _queryCache[sqlString] = ret;

            return ret;
        }

private string TransformFromClause(string fromClause)
        {
            string transformed;

            //"from ".Length
            const int fromLength = 5;
            fromClause = fromClause.Substring(fromLength, fromClause.Length - fromLength);
            string[] blocks = fromClause.Split(',');
            if (blocks.Length > 1)
            {
                for (int i = 0; i < blocks.Length; i++)
                {
                    string tr = TransformJoinBlock(blocks[i]);
                    if (tr.IndexOf(" join ") > -1)
                    {
                        blocks[i] = "(select * from " + tr + ") as jetJoinAlias" + i.ToString();
                    }
                    else
                    {
                        blocks[i] = tr;
                    }
                }
                // wxy fixed
                transformed = " from " + string.Join(",", blocks);
            }
            else
            {
                transformed = " from " + TransformJoinBlock(blocks[0]);
            }

            return transformed;
        }