ruder

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 :: 管理 ::
        private static Dictionary<string,string> _selectSql=new Dictionary<string,string>();
        public static string SQL_SELECT
        {
            get
            {
                if (!_selectSql.ContainsKey(CurrentType.Name))
                {
                    StringBuilder sql = new StringBuilder();
                    sql.Append(" Select ");
                    bool isFirst = true;
                    foreach (PropertyInfo info in Attributes)
                    {
                        if (isFirst) { isFirst = false; } else { sql.Append(","); }
                        sql.Append(" [" + info.Name + "] ");
                    }
                    sql.Append(" From ");
                    sql.Append(" [dbo].[" + CurrentType.Name + @"] ");
                    _selectSql[CurrentType.Name] = sql.ToString();
                }
                return _selectSql[CurrentType.Name];
            }
        }
posted on 2009-04-29 17:33  徐境  阅读(174)  评论(0)    收藏  举报