当前文件： HandsonNews/App_Code/BLL/NewsClassManager.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.Data.SqlClient;
11/**//// <summary>
12/// NewsClassManager 的摘要说明
13
14
15
16
17
18
19
20
21
22/// </summary>
23public class NewsClassManager
24...{
25    public NewsClassManager()
26    ...{
27        //
28        // TODO: 在此处添加构造函数逻辑
29        //
30    }
31    public static DataSet FindNewsClass()
32    ...{
33        SqlConnection con = DataAccess.CreateConnection();
34        string sql = "Select c.ClassID,c.ClassName,i.ItemName,c.ClassDesc,c.ClassOrder from t_Class as c t_Item as i ";
35        SqlDataAdapter sda = new SqlDataAdapter(sql,con);
36        DataSet ds = new DataSet();
37        sda.Fill(ds);
38        return ds;
39    }
40    public static DataSet FindItemName()
41    ...{
42        SqlConnection con = DataAccess.CreateConnection();
43        string sql = "Select ItemID,ItemName from t_Item";
44        SqlDataAdapter sda = new SqlDataAdapter(sql,con);
45        DataSet ds = new DataSet();
46        sda.Fill(ds);
47        return ds;
48    }
49    public static int AddNewsClass(string className,int itemID,string classDesc,int classOrder)
50    ...{
51        int effectRows = 0;
52        SqlConnection con = DataAccess.CreateConnection();
53        SqlCommand cmd = new SqlCommand();
54        cmd.Connection = con;
55        cmd.CommandText = "insert into t_Class (ClassName,ClassDesc,ClassOrder,ItemID) values (@className,@classDesc,@classOrder,@itemID)";
56        cmd.Parameters.Add("@className", SqlDbType.VarChar, 50).Value = className;
57        cmd.Parameters.Add("@classDesc", SqlDbType.VarChar, 200).Value = classDesc;
58        cmd.Parameters.Add("@classOrder", SqlDbType.Int).Value = classOrder;
59        cmd.Parameters.Add("@itemID", SqlDbType.Int).Value = itemID;
60        try
61        ...{
62            if (cmd.Connection.State == ConnectionState.Closed)
63            ...{
64                //打开连接
65                cmd.Connection.Open();
66            }
67            effectRows = cmd.ExecuteNonQuery();
68        }
69        catch
70        ...{
71            // 捕获错误
72        }
73        
74        finally
75        ...{
76
77            //释放资源
78            if (con.State == ConnectionState.Open)
79            ...{
80                //关闭连接
81                con.Close();
82            }
83            con.Dispose();
84            cmd.Dispose();
85        }
86        //返回所影响的行数
87
88
89        return effectRows;
90    }
91    
92}
93