当前文件： maolz/SubSonicDAL/MySiteProvider/Custom/Article.cs[1K，2009-6-12 11:47:17]，打开代码结构图

		            
 1using System; 
 2using System.Text; 
 3using System.Data;
 4using System.Data.SqlClient;
 5using System.Data.Common;
 6using System.Collections;
 7using System.Collections.Generic;
 8using System.ComponentModel;
 9using System.Configuration; 
10using System.Xml; 
11using System.Xml.Serialization;
12using SubSonic; 
13using SubSonic.Utilities;
14
15namespace SubSonic.Generated
16...{
17    using System.Linq;
18    public partial class Article
19    ...{
20        public string GetTags()
21        ...{
22            if (GetTagCollection().Count == 0)
23                return string.Empty;
24            string temp = string.Empty;
25            foreach (Tag t in GetTagCollection())
26            ...{
27                temp += t.Name + ",";
28            }
29            return temp.Substring(0, temp.Length - 1);
30        }
31        public string GetCategoryNames() 
32        ...{
33            if (this.GetCategoryCollection().Count == 0)
34                return string.Empty;
35            
36            System.Collections.Generic.List<string> list=new List<string>();
37            GetCategoryCollection().ForEach(t => list.Add(t.Name));
38            return String.Join(",", list.ToArray());
39        }
40        public CommentCollection GetCommentCollection() 
41        ...{
42            //Query qry = Comment.CreateQuery().WHERE(Comment.Columns.FkArticleId, this.PKId).ORDER_BY(Comment.Columns.PKId, "asc");
43            //Commentqry.ExecuteReader
44            return DB.Select().From<Comment>().Where(Comment.Columns.FkArticleId).IsEqualTo(this.PKId).ExecuteAsCollection<CommentCollection>().OrderByAsc(Comment.Columns.PKId);
45        }
46    }
47
48}
49
50