当前文件：
NiitJob/App_Code/classes/News.cs[5K，2009-6-12 11:50:17]，
打开代码结构图
1
using System;
2using System.Data;
3using System.Data.SqlClient;
4using My.Hr.DbBase;
5using System.Collections ;
6
7namespace My
8
...{
9
/**//// <summary>
10
/// News description for News。
11
/// </summary>
12 public class News:Base
13 ...{
14 public News()
15 ...{
16
17 }
18
19 /**//// NewManager的所有新闻的列表要调用这个函数
20 public static DataSet GetNews()
21 ...{
22 strSQL = "SELECT * FROM news";
23
24 try
25 ...{
26 return ExecuteSql4Ds(strSQL);
27 }
28 catch
29 ...{
30 throw new Exception("Get all the news Information failed!");
31 }
32 }
33
34
35 /**//// <summary>
36 /// Get News Cover By NewsId
37 /// </summary>
38 /// <param name="NewsId">NewsId</param>
39 /// <returns></returns>
40 ///
41 public DataView GetNewsPicture(int newsId)
42 ...{
43 String strsql;
44 DataSet myDs;
45 strsql="select picture from news where Id="+newsId;
46 myDs=ExecuteSql4Ds(strsql);
47 return myDs.Tables[0].DefaultView ;
48 }
49
50
51 //get top ten best salers
52 public DataView GetNewsLatest10()
53 ...{
54 String strsql;
55 DataSet myDs;
56 strsql="select top 10 Id,title from news order by Id DESC";
57 myDs=ExecuteSql4Ds(strsql);
58 return myDs.Tables[0].DefaultView ;
59 }
60
61
62 public DataView GetNewsImportant10()
63 ...{
64 String strsql;
65 DataSet myDs;
66 strsql="select top 10 Id,title from news order by hits desc";
67 myDs=ExecuteSql4Ds(strsql);
68 return myDs.Tables[0].DefaultView ;
69 }
70
71 /**//// <summary>
72 /// add News,Operator Storeprocedure "AddNews"
73 /// </summary>
74 /// <param name="tempary">News detail,Kind:ArrayList</param>
75 /// <returns></returns>
76 public void AddNews(ArrayList tempary)
77 ...{
78 SqlConnection myCn=new SqlConnection(strConn);
79 SqlCommand myCm=new SqlCommand("AddNews",myCn);
80 myCm.CommandType =CommandType.StoredProcedure ;
81
82
83 myCm.Parameters.Add(new SqlParameter("@publicDate",SqlDbType.DateTime));
84 myCm.Parameters["@publicDate"].Value =tempary[0];
85
86 myCm.Parameters.Add(new SqlParameter("@source",SqlDbType.VarChar,30 ));
87 myCm.Parameters["@source"].Value =tempary[1];
88
89 myCm.Parameters.Add(new SqlParameter("@title",SqlDbType.VarChar,100));
90 myCm.Parameters["@title"].Value =tempary[2];
91
92 myCm.Parameters.Add(new SqlParameter("@content",SqlDbType.Text ));
93 myCm.Parameters["@content"].Value =tempary[3];
94
95 myCm.Parameters.Add(new SqlParameter("@picture",SqlDbType.VarChar,50));
96 myCm.Parameters["@picture"].Value =tempary[4];
97
98 myCm.Parameters.Add(new SqlParameter("@hits",SqlDbType.Int));
99 myCm.Parameters["@hits"].Value =0;
100
101 try
102 ...{
103 myCn.Open() ;
104 myCm.ExecuteNonQuery() ;
105 }
106 catch(System.Data.SqlClient.SqlException er)
107 ...{
108 throw new Exception(er.Message);
109 }
110 finally
111 ...{
112 myCm.Dispose() ;
113 myCn.Close() ;
114 }
115 }
116
117
118
119 /**//// <summary>
120 /// Delete News By Newsid
121 /// </summary>
122 /// <param name="NewsId"></param>
123 public void DeleteNewsById(int Id)
124 ...{
125 strSQL = "Delete From news Where Id="+Id;
126
127 try
128 ...{
129 ExecuteSql(strSQL);
130 }
131 catch
132 ...{
133 throw new Exception("delete failed!");
134 }
135 }
136
137 /**//// <summary>
138 /// Delete a group user
139 /// </summary>
140 /// <param name="names">Users' names</param>
141 public static void DeleteGroup(string names)
142 ...{
143 strSQL = "Delete From news Where Id in ('" + names + "')";
144
145 try
146 ...{
147 ExecuteSql(strSQL);
148 }
149 catch
150 ...{
151 throw new Exception("Delete user FAILED！");
152 }
153 }
154
155 public SqlDataReader GetNewsByHits()
156 ...{
157 string strsql;
158 SqlDataReader result;
159 try
160 ...{
161 SqlConnection myCn=new SqlConnection(strConn);
162 strsql="select top 10 id,title,descr=' '+SUBSTRING(content,0,100)+'......',image=case when(not picture is null) then ' <img src=upload/'+picture+' Border=1 width=70 height=100>' else ' <img src=img/pic.jpg border=1 width=70 height=100>' end from news order by hits DESC";
163 SqlCommand myCm=new SqlCommand(strsql,myCn);
164 myCn.Open ();
165 result=myCm.ExecuteReader(CommandBehavior.CloseConnection);
166 return result;
167 }
168 catch(System.Data.SqlClient.SqlException er)
169 ...{
170 throw new Exception(er.Message);
171 }
172
173 }
174
175 public DataRow GetNewsDetail(int newsId)
176 ...{
177 string strsql;
178 DataSet myDs;
179 try
180 ...{
181 strsql="select Id,title,source,publicDate,hits,content from news where Id= " + newsId;
182 myDs=ExecuteSql4Ds(strsql);
183 return myDs.Tables[0].Rows[0];
184 }
185 catch(System.Data.SqlClient.SqlException er)
186 ...{
187 throw new Exception(er.Message);
188 }
189
190 }
191 public DataRow GetNewsDetail(string name)
192 ...{
193 string strsql;
194 DataSet myDs;
195 try
196 ...{
197 strsql="select Id,title,source,publicDate,hits,content from news where title= " + name;
198 myDs=ExecuteSql4Ds(strsql);
199 return myDs.Tables[0].Rows[0];
200 }
201 catch(System.Data.SqlClient.SqlException er)
202 ...{
203 throw new Exception(er.Message);
204 }
205
206 }
207 /**//// <summary>
208 /// Add News hits
209 /// </summary>
210 /// <param name="NewsId">News ID</param>
211 /// <returns></returns>
212 public static void Hits(string newsId)
213 ...{
214 strSQL = "Update news set hits=hits+1 Where Id= " + newsId;
215 try
216 ...{
217 ExecuteSql4Ds(strSQL);
218 }
219 catch
220 ...{
221 throw new Exception("Hits FAILED!!");
222 }
223 }
224 }
225
}
226
打包下载该项目完整源码：人才招聘系统（NIIT学生作品）