当前文件： HandsonNews/App_Code/NewsObj.cs[2K，2009-6-12 11:43:42]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Collections.Generic;
11using System.Data.SqlClient;
12/**//// <summary>
13/// NewsObj 的摘要说明
14
15
16/// </summary>
17public class NewsObj
18...{
19    public NewsObj()
20    ...{
21        //
22        // TODO: 在此处添加构造函数逻辑
23        //
24    }
25    public static List<News> FindNewsInfo()
26    ...{
27        //定义一个新闻类集合
28        List<News> news = new List<News>();
29        DataSet ds = Newsmanager.FindNewsInfo();
30        News newses = new News();
31        foreach (DataRow dr in ds.Tables[0].Rows)
32        ...{
33            //定义一个新闻类
34            
35            newses.NewsID = (int)dr["NewsID"];
36            newses.NewsTitle = (string)dr["NewsTitle"];
37            newses.NewsDate = (string)dr["NewsDate"];
38            //数据实体当中并不包含className值，如果将classID先放进去，
39
40
41            //然后再修改所属类别的模版，添加一个DropDownList再绑定一个数据源(不知道行不行)
42            newses.ClassID = (int)dr["ClassID"];
43            newses.NewsSource = (string)dr["NewSource"];
44            news.Add(newses);
45        }
46        return news;
47    }
48    public static List<NewsClass> GetClass()
49    ...{
50        List<NewsClass> classID_Name = new List<NewsClass>();
51        DataSet ds = Newsmanager.GetClass();
52        NewsClass newsClass = new NewsClass();
53        foreach (DataRow dr in ds.Tables[0].Rows)
54        ...{
55            newsClass.ClassID=(int)dr["ClassID"];
56            newsClass.ClassName=(string)dr["ClassName"];
57            classID_Name.Add(newsClass);
58        }
59        return classID_Name;
60        
61    }
62    public static void DeleteNews(int newsID)
63    ...{
64        SqlConnection con = DataAccess.CreateConnection();
65        SqlCommand cmd = new SqlCommand();
66        cmd.Connection = con;
67        cmd.CommandText = "delete from t_News where NewsID=@newsID";
68        cmd.Parameters.AddWithValue("@newsID", newsID);
69        try
70        ...{
71            if (cmd.Connection.State == ConnectionState.Closed)
72            ...{
73                cmd.Connection.Open();
74            }
75            cmd.ExecuteNonQuery();
76        }
77        finally
78        ...{
79            if (cmd.Connection.State == ConnectionState.Open)
80            ...{
81                cmd.Connection.Close();
82            }
83            cmd.Dispose();
84            con.Dispose();
85        }
86    }
87}
88